Utilizamos cookies propias y de terceros para mejorar nuestros servicios. Si continua navegando, consideramos que acepta su uso.
Puede obtener más información, en nuestra Política de Cookies.
MySQL Error Occured 1064: 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 a.id ORDER BY total DESC LIMIT 5' at line 1
QUERY = SELECT a.*, count(a.id) as total FROM `galerias` a LEFT JOIN visitas_galerias b ON a.id = b.id_galeria WHERE 1=1 AND (aprobada=1 AND (datum=(DATE_SUB(CURDATE(),INTERVAL 1 DAY)) AND id_cat LIKE '%00018%') GROUP BY a.id ORDER BY total DESC LIMIT 5