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 '%Laser%' OR t1.nume LIKE '%Laser%' OR t1.cod LIKE '%Laser%' OR t1.cod LIKE '%Laser%') AND t1.vizibil=1 AND t3.pret_ales=1 AND t1.categorie_id IN (9produse=promotii, 13, 158, 176, 184, 182, 186, 540, 541, 542, 465, 466, 468, 476, 467, 469, 513, 514, 15, 23, 24, 27, 33, 34, 35, 36, 487, 31, 471, 472, 17, 18, 518, 524, 519, 520, 521, 522, 523, 488, 490, 491, 494, 550, 504, 539, 499, 500, 501, 502, 503, 527, 528, 529, 530, 531, 532, 533, 534, 538, 22)Unknown column '9produse' in 'where clause'