Skip to content

"Query error: You have an error in your SQL syntax" #29

Description

@NovemLinguae

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' )

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions