Dine aktive koder:
Dine gamle koder:
################################################# SELECT * FROM ( SELECT keyword, mobile, MAX(stamp) AS stamp FROM bil_regnskab_data WHERE mobile = GROUP BY keyword ) AS a WHERE stamp > DATE_SUB(NOW(),INTERVAL 3 MONTH) ORDER BY stamp DESC #################################################You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND bil_regnskab_data.keyword = '' ORDER BY km ###########' at line 14
######################################################## SELECT #MD5(CONCAT(benzin.keyword,'|',benzin.mobile)) AS sender, bil_regnskab_data.*, #// ok_92.pris AS ok_92, #// q8_92.pris AS q8_92, grupper.gruppe_id FROM bil_regnskab_data JOIN bil_regnskab_grupper AS grupper USING(keyword,mobile) JOIN bil_regnskab_grupper AS login_user USING(gruppe_id) #// LEFT JOIN bil_regnskab_priser AS ok_92 ON ( ok_92.date = DATE(bil_regnskab_data.stamp ) AND #// ok_92.produkt = 'OK 92oktan' ) #// LEFT JOIN bil_regnskab_priser AS q8_92 ON ( q8_92.date = DATE(bil_regnskab_data.stamp ) AND #// q8_92.produkt = 'Q8 92oktan' ) WHERE login_user.mobile = AND bil_regnskab_data.keyword = '' ORDER BY km ########################################################You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY keyword ) AS a WHERE stamp < DATE_SUB(NOW(),INTERVAL 3 M' at line 9
################################################# SELECT * FROM ( SELECT keyword, mobile, MAX(stamp) AS stamp FROM bil_regnskab_data WHERE mobile = GROUP BY keyword ) AS a WHERE stamp < DATE_SUB(NOW(),INTERVAL 3 MONTH) ORDER BY stamp DESC #################################################