select ip.pages_id, ipd.pages_title, ipd.pages_blurb from pages ip, pages_description ipd left join pages_to_categories ip2c on ip2c.pages_id = ip.pages_id where ipd.pages_id = ip.pages_id and ip2c.categories_id = '0' and ipd.language_id = '1' and ip.pages_status = '1' order by ip.pages_sort_order, ipd.pages_title
