query> SELECT SQL_CALC_FOUND_ROWS generalsettings.*, country.*, producttypes.* FROM generalsettings LEFT JOIN locations AS country ON country.id = generalsettings.id_country LEFT JOIN producttypes ON producttypes.id = generalsettings.id_producttype WHERE generalsettings.dominio like "%dhl.fotoc.com.uy;%" ORDER BY generalsettings.id

query> SELECT SQL_CALC_FOUND_ROWS contentlangs.* FROM contentlangs WHERE contentlangs.code='es' ORDER BY contentlangs.id

query> SELECT SQL_CALC_FOUND_ROWS contentlangs.* FROM contentlangs ORDER BY contentlangs.id

query> SELECT SQL_CALC_FOUND_ROWS generalsetting_infos.*, contentlangs.*, generalsettings.* FROM generalsetting_infos LEFT JOIN contentlangs ON contentlangs.id = generalsetting_infos.id_contentlang LEFT JOIN generalsettings ON generalsettings.id = generalsetting_infos.id_generalsetting WHERE generalsetting_infos.id_generalsetting='10' AND generalsetting_infos.id_contentlang='1' ORDER BY generalsetting_infos.id

query> SELECT SQL_CALC_FOUND_ROWS generalsetting_infos.*, contentlangs.*, generalsettings.* FROM generalsetting_infos LEFT JOIN contentlangs ON contentlangs.id = generalsetting_infos.id_contentlang LEFT JOIN generalsettings ON generalsettings.id = generalsetting_infos.id_generalsetting WHERE generalsetting_infos.id_generalsetting='10' AND generalsetting_infos.id_contentlang='2' ORDER BY generalsetting_infos.id

query> SELECT SQL_CALC_FOUND_ROWS generalsetting_infos.*, contentlangs.*, generalsettings.* FROM generalsetting_infos LEFT JOIN contentlangs ON contentlangs.id = generalsetting_infos.id_contentlang LEFT JOIN generalsettings ON generalsettings.id = generalsetting_infos.id_generalsetting WHERE generalsetting_infos.id_generalsetting='10' AND generalsetting_infos.id_contentlang='3' ORDER BY generalsetting_infos.id

query> SELECT SQL_CALC_FOUND_ROWS generalsetting_infos.*, contentlangs.*, generalsettings.* FROM generalsetting_infos LEFT JOIN contentlangs ON contentlangs.id = generalsetting_infos.id_contentlang LEFT JOIN generalsettings ON generalsettings.id = generalsetting_infos.id_generalsetting WHERE generalsetting_infos.id_generalsetting='10' AND generalsetting_infos.id_contentlang='4' ORDER BY generalsetting_infos.id

query> SELECT SQL_CALC_FOUND_ROWS generalsettingbanners.*, generalsettings.* FROM generalsettingbanners LEFT JOIN generalsettings ON generalsettings.id = generalsettingbanners.id_generalsetting WHERE generalsettingbanners.id_generalsetting='10' ORDER BY generalsettingbanners.orden DESC

query> SELECT SQL_CALC_FOUND_ROWS CONCAT('',section_infos.name) as pagename,CONCAT('',section_infos.page_title) as page_title,CONCAT('',section_infos.link_text) as text,CONCAT('',section_infos.meta_title) as meta_title,CONCAT('',section_infos.meta_keywords) as meta_keywords,CONCAT('',section_infos.meta) as meta,CONCAT('',sectiontemplates.code) as template,CONCAT('',sections.defaultcontent) as defaultcontent, sections.*, sectiontemplates.* FROM sections LEFT JOIN sectiontemplates ON sectiontemplates.id = sections.id_sectiontemplate LEFT JOIN contentlangs ON contentlangs.code = 'es' LEFT JOIN section_infos ON sections.id = section_infos.id_section AND section_infos.id_contentlang=contentlangs.id LEFT JOIN section_infos as secinfo ON sections.id = secinfo.id_section LEFT JOIN contentdomain ON contentdomain.contentid = CONCAT("section_",sections.id) AND contentdomain.id_generalsetting = '10' WHERE sections.visible IN (1) AND ( sections.code='sboxeHomep' OR secinfo.name='sboxeHomep') AND (contentdomain.id IS  NULL or contentdomain.status = 1) ORDER BY sections.orden DESC LIMIT 1