Query: SELECT
TC.*
, T.id
, T.nombre_es AS nombre
, (SELECT source FROM mdi_site_galeria WHERE trabajo_id = TC.trabajo_id AND portada = 1 LIMIT 1) AS imagen
, (SELECT url_es FROM mdi_site_categoria WHERE id = TC.categoria_id ) AS url
, T.url_es AS url_trabajo
FROM mdi_site_trabajo_categoria TC
JOIN mdi_site_trabajo T ON TC.trabajo_id = T.id
WHERE TC.categoria_id = AND T.destacado = 1 AND T.protegido = 0
GROUP BY T.id
ORDER BY orden Error #1064 Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND T.destacado = 1 AND T.protegido = 0
GROUP BY T.id
ORDER BY orden' at line 10
MDI Concept - TRABAJOS -