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 8
SELECT id
FROM piwigo_images i
INNER JOIN piwigo_image_category ic ON id=ic.image_id
WHERE category_id IN (23,31)
AND (category_id NOT IN (17,38,39,22,40))
GROUP BY id
HAVING COUNT(DISTINCT category_id)=2
ORDER BY name 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/functions_category.inc.php(654): query2array()
#1 /var/www/vhosts/pedregateam.enpreproduccion.com/media.pedregateam.com/include/section_init.inc.php(246): get_image_ids_for_categories()
#2 /var/www/vhosts/pedregateam.enpreproduccion.com/media.pedregateam.com/index.php(12): include('/var/www/vhosts...')
#3 {main}
thrown in /var/www/vhosts/pedregateam.enpreproduccion.com/media.pedregateam.com/include/dblayer/functions_mysqli.inc.php on line 908