SELECT count( distinct(t1.id) ) AS total_produse_cautare FROM produse t1 INNER JOIN produse_pret t3 ON t1.id=t3.produs_id WHERE t1.vizibil=1 AND (t1.nume LIKE '% %' OR t1.nume LIKE '%%' OR t1.cod LIKE '% %' OR t1.cod LIKE '%%') AND t1.vizibil=1 AND t3.pret_ales=1 AND t1.categorie_id IN (9produse=promotii)Unknown column '9produse' in 'where clause'