SELECT count(DISTINCT d_items.id) as total
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_idioma.id_idioma='ca'
AND art_articles.id_area='27'
