SELECT * FROM pages WHERE url_rewrite='recent' AND parent_id=(SELECT page_id FROM pages WHERE url_rewrite='other' AND (parent_id IS NULL OR parent_id=(SELECT page_id FROM pages WHERE url_rewrite=NULL AND parent_id IS NULL))) LIMIT 1