select pd.pages_name,pd.pages_id,pd.pages_resumen,IF(pd.pages_description is null or length(pd.pages_description) = 0 ,0,1) as has_desc from pages_description_subsections pd left join pages_subsections p on pd.pages_id = p.pages_id where p.parent_id = 19 and p.pages_status = 1 and p.date_news <= now() and pd.language_id = '2' order by p.sort_order asc