toto
SELECT *
FROM jnew_dataitems
WHERE(Select4 LIKE '%Ventilateur boîtier%' or Select4 LIKE '%Ventilateur Boîtier PC%' )
AND (Select4 NOT LIKE '%Batterie%') AND (Select4 NOT LIKE '%Accessoires%') AND (Select4 NOT LIKE '%Chargeur%') AND (Select4 NOT LIKE '%Station%') AND (Select4 NOT LIKE '%Garanties%') AND (Select10 NOT LIKE '') AND (prijs >= '5')
AND (feed LIKE '%LDLC%' or feed LIKE '%Top Achat%' or feed LIKE '%Grosbill%' or feed LIKE '%Materiel.net%' or feed LIKE '%RueDuCommerce%' )
GROUP BY Select10 ORDER BY COUNT(Select10) DESC LIMIT 200,50
Ventilateur Boitier au meilleur prix | Comparateur-Gamer.fr
