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 '%bosch%' OR t1.nume LIKE '%bosch%' OR t1.cod LIKE '%bosch%' OR t1.cod LIKE '%bosch%') AND t1.vizibil=1 AND t3.pret_ales=1 AND t1.categorie_id IN (10produse=promotii, 40, 42, 41, 46, 346, 348, 349, 350, 47, 48, 344, 345, 359, 360, 361, 49, 50, 51, 52, 57, 58, 59, 462, 484, 515, 547)Unknown column '10produse' in 'where clause'