2SELECT DISTINCT(c.idContingut), c.dataModificacio, (SELECT IFNULL(en,'') FROM mod_contingut_literal WHERE idLiteral=c.titol) AS literalTitol , (SELECT IFNULL(en,'') FROM mod_contingut_literal WHERE idLiteral=c.descripcio) AS literalDescripcio FROM mod_contingut c, mod_contingut_literal l WHERE c.idMenu=:idMenu AND c.publicat='S' AND c.dataEliminacio=0 ORDER BY ordre

9SELECT DISTINCT(c.idContingut), c.dataModificacio, (SELECT IFNULL(en,'') FROM mod_contingut_literal WHERE idLiteral=c.titol) AS literalTitol , (SELECT IFNULL(en,'') FROM mod_contingut_literal WHERE idLiteral=c.descripcio) AS literalDescripcio FROM mod_contingut c, mod_contingut_literal l WHERE c.idMenu=:idMenu AND c.publicat='S' AND c.dataEliminacio=0 ORDER BY ordre