SELECT d_items.id,d_items_idioma.keywords
FROM art_articles
LEFT JOIN d_items ON d_items.id = art_articles.id_item
LEFT JOIN d_items_idioma ON d_items.id = d_items_idioma.id
WHERE art_articles.arxivat<>'Y'
AND art_articles.web='Y'
AND d_items.actiu='Y'
AND d_items.eliminat<>'Y'
AND d_items_idioma.id_idioma='es'
AND d_items.data_publicacio < '1568754238'
AND (d_items.data_caducitat > '1568754238'
OR d_items.data_caducitat <= 0)
AND art_articles.id_area='32'
ORDER BY d_items.orden ASC
LIMIT 0,48
Whatsapp: 608291265