Author: orenbochman
Description:
When running the following query on the a query on the Hebrew language database in tool labs there are some Unexpected results.
SELECT rev_user_text, page_title FROM revision
JOIN page ON page_id = rev_page
JOIN user_groups ON ug_user = rev_user
WHERE page_namespace = '3'
AND page_is_redirect = '0'
AND ug_group != 'bot'
AND page_title NOT LIKE '%/%';
Methinks This may be a collation issue or something to do with slash definition.
Version: unspecified
Severity: normal
Whiteboard: aklapper-moreinfo