toto
SELECT *
FROM jnew_dataitems
WHERE(Select4 LIKE '%PC Portable%' or Select4 LIKE '%Ordinateur portable%' )
AND (Select4 NOT LIKE '%Mémoire%') AND (Select4 NOT LIKE '%Batterie%') AND (Select4 NOT LIKE '%Refroidissement%') AND (Select4 NOT LIKE '%Accessoires%') AND (Select4 NOT LIKE '%Chargeur%') AND (Select4 NOT LIKE '%Station%') AND (Select4 NOT LIKE '%Ventilateur%') AND (Select4 NOT LIKE '%Garanties%') AND (Select4 NOT LIKE '%Sac pour ordinateur portable%') AND (Select4 NOT LIKE '%Sacs, sacoches, housses%') AND (Select10 NOT LIKE '') AND (prijs >= '100')
AND (feed LIKE '%LDLC%' or feed LIKE '%Cdiscount%' or feed LIKE '%Boulanger%' or feed LIKE '%Materiel.net%' or feed LIKE '%RueDuCommerce%' or feed LIKE '%Fnac%' )
GROUP BY Select10 ORDER BY COUNT(Select10) DESC LIMIT 1200,50
PC Portable au meilleur prix | Comparateur-Gamer.fr
