Warning:  [mysql error 1064] You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '))
  AND (category_id NOT IN (42,39))
  ORDER BY date_available ASC,date_crea...' at line 5

SELECT DISTINCT(id)
  FROM piwigo_images i
    INNER JOIN piwigo_image_category AS ic ON id = ic.image_id
    LEFT JOIN piwigo_image_tag AS it ON id = it.image_id
  WHERE (category_id IN ())
  AND (category_id NOT IN (42,39))
  ORDER BY date_available ASC,date_creation ASC, date_available DESC, id ASC in /home/cc/public_html/cc/gallery/include/dblayer/functions_mysqli.inc.php on line 847