Início - Benege

SQL: SELECT * FROM medias INNER JOIN nodes ON medias.codNode = nodes.codNode INNER JOIN nodes_idiomas ON nodes.codNode = nodes_idiomas.codNode WHERE 1 = 1 AND nodes_idiomas.codIdioma = 1 AND nodes.codTipoNode = 12 AND nodes.activo = 1 ORDER BY nodes.ordem ASC

SQL: SELECT * FROM nodes INNER JOIN nodes_idiomas ON nodes.codNode = nodes_idiomas.codNode WHERE isDestaque = 1 AND nodes.activo = 1 AND nodes_idiomas.codIdioma = 1 LIMIT 4