-
Notifications
You must be signed in to change notification settings - Fork 2
Open
Description
Query error: 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 '* FROM user_groups WHERE ug_user = user_id AND ug_group = 'sysop' ) AND NOT ...' at line 4
I get this error with the explainer tool, but not with Quarry. The fact that these aren't behaving 1:1 suggests something odd.
SELECT user_editcount, user_name, user_registration
FROM user
WHERE user_editcount > 10000
AND NOT EXISTS (SELECT * FROM user_groups WHERE ug_user = user_id AND ug_group = 'sysop' )
AND NOT EXISTS (SELECT * FROM user_groups WHERE ug_user = user_id AND ug_group = 'bot' )
Metadata
Metadata
Assignees
Labels
No labels