IMNASA Neumáticas

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='es' AND art_articles.id_familia='1' AND art_articles.id IN( SELECT id_tabla FROM art_caracteristiques_relacions WHERE ( (id_carac='12' AND valor='20' ) OR (id_carac='12' AND valor='24' ) ) AND art_caracteristiques_relacions.tabla='art_articles')