Erreur SQL !
SELECT SUM(clicks) as clicks, EAN, COUNT(*) as offres, MIN(t1.price) as bestprice, (SELECT product_name FROM flow WHERE EAN = t1.EAN ORDER BY clicks DESC LIMIT 1) AS nom FROM `flow` as t1 WHERE (product_name LIKE '%%' AND (categorie='91' OR categorie='92' OR categorie='93' OR categorie='94' OR categorie='95' OR categorie='96' OR categorie='97' OR categorie='98' OR categorie='99' OR categorie='100' OR categorie='101' OR categorie='112' OR categorie='113' OR categorie='114' OR categorie='115' OR categorie='116')) AND EAN!='' AND date >= CURRENT_DATE - INTERVAL 14 DAY GROUP BY EAN ORDER BY clicks DESC LIMIT 50
Unknown column 'categorie' in 'where clause'
SELECT SUM(clicks) as clicks, EAN, COUNT(*) as offres, MIN(t1.price) as bestprice, (SELECT product_name FROM flow WHERE EAN = t1.EAN ORDER BY clicks DESC LIMIT 1) AS nom FROM `flow` as t1 WHERE (product_name LIKE '%%' AND (categorie='91' OR categorie='92' OR categorie='93' OR categorie='94' OR categorie='95' OR categorie='96' OR categorie='97' OR categorie='98' OR categorie='99' OR categorie='100' OR categorie='101' OR categorie='112' OR categorie='113' OR categorie='114' OR categorie='115' OR categorie='116')) AND EAN!='' AND date >= CURRENT_DATE - INTERVAL 14 DAY GROUP BY EAN ORDER BY clicks DESC LIMIT 50
Unknown column 'categorie' in 'where clause'