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