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 250,50