select mp.uid, mp.parent_uid, mp.url_path_segment , mp.title, mp2.url_path_segment parentseg  from mf_pages mp
left join mf_pages mp2 on mp2.uid = mp.parent_uid
where mp.deleted = 0 and mp.title not like "%old" order by parentseg, mp.url_path_segment
