Warning: [mysql error 1052] Column 'id' in where clause is ambiguous
SELECT UT.id, UT.username, COUNT(DISTINCT(IT.id)) AS PBU
FROM piwigo_users as UT
INNER JOIN piwigo_images AS IT ON IT.added_by = UT.id
INNER JOIN piwigo_image_category AS ic ON IT.id = ic.image_id
WHERE (category_id NOT IN (295,296,297,183,339,337,336,332,333,310,300,345,344,281) AND category_id IN (-1) AND id IN (-1))
GROUP BY IT.added_by
HAVING PBU >0
ORDER BY username ASC
LIMIT 1000; in /var/www/html/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/html/include/dblayer/functions_mysqli.inc.php:211
Stack trace:
#0 /var/www/html/plugins/see_photos_by_user/main.inc.php(61): pwg_db_fetch_assoc()
#1 /var/www/html/include/functions_plugins.inc.php(264): section_init_SPBA()
#2 /var/www/html/include/section_init.inc.php(697): trigger_notify()
#3 /var/www/html/index.php(12): include('/var/www/html/i...')
#4 {main}
thrown in /var/www/html/include/dblayer/functions_mysqli.inc.php on line 211