select m.menu_name, i.id, i.parent_id, i.link, i.link_id, i.link_type, i.target_blank, i.class, i.sub_categories, i.sort_order, t.title, i.menu_id, i.submenu , m.last_modified, cd.categories_name from menus m inner join menu_items i on i.menu_id = m.id and i.platform_id='23' left join menu_titles t on t.item_id = i.id and t.language_id = 1 left join categories_description cd on cd.language_id =1 and cd.categories_id=i.link_id and i.link_type='categories' where 1 order by i.sort_order

Art of Camille Pissarro (A-Z) Biography Famous Pissarro Paintings