Warning: [mysql error 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 ' file ASC, id ASC' at line 5
SELECT DISTINCT(id)
FROM piwigo_images
INNER JOIN piwigo_image_category AS ic ON id = ic.image_id
WHERE date_available>=LEAST(SUBDATE(CURRENT_DATE,INTERVAL 7 DAY),SUBDATE('2024-06-05 11:59:25',INTERVAL 1 DAY))
AND (category_id NOT IN (17,38,39,22,40))ORDER BY date_available DESC,, file ASC, id ASC
; in /var/www/vhosts/pedregateam.enpreproduccion.com/media.pedregateam.com/include/dblayer/functions_mysqli.inc.php on line 847
Fatal error: Uncaught Error: Call to a member function fetch_assoc() on bool in /var/www/vhosts/pedregateam.enpreproduccion.com/media.pedregateam.com/include/dblayer/functions_mysqli.inc.php:908
Stack trace:
#0 /var/www/vhosts/pedregateam.enpreproduccion.com/media.pedregateam.com/include/section_init.inc.php(474): query2array()
#1 /var/www/vhosts/pedregateam.enpreproduccion.com/media.pedregateam.com/index.php(12): include('/var/www/vhosts...')
#2 {main}
thrown in /var/www/vhosts/pedregateam.enpreproduccion.com/media.pedregateam.com/include/dblayer/functions_mysqli.inc.php on line 908