SELECT a.id_site_area,
a.order_content_by,
a.order_content_direction,
a.id_top_area,
a.show_sitemap_childs,
if(at.title is null , a.name, at.title) title,
at.big_text,
at.meta_keyword,
at.meta_description,
at.meta_title,
at.photo,
st.*
FROM site_area a
JOIN site_template st using(id_template)
LEFT JOIN site_area_info at ON(at.id_site_area = a.id_site_area and at.id_lang = 3)
WHERE active = 1
AND a.id_top_area = 7 ORDER BY
Coffee | Krea – Electrodomésticos/Small domestic appliances /Pequeños domésticos KREA|Bialetti|Rondine|Girmi
