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
//Sidebar Text