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='216' OR categorie='217' OR categorie='218' OR categorie='219' OR categorie='220' OR categorie='221')) 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='216' OR categorie='217' OR categorie='218' OR categorie='219' OR categorie='220' OR categorie='221')) AND EAN!='' AND date >= CURRENT_DATE - INTERVAL 14 DAY GROUP BY EAN ORDER BY clicks DESC LIMIT 50
Unknown column 'categorie' in 'where clause'