totoSELECT *
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%' )
AND ( Select1 LIKE '%corsair%')
GROUP BY Select10 ORDER BY Prijs ASC LIMIT 1500
Ventilateur Boitier corsair au meilleur prix | Comparateur-Gamer.fr
