https://bugzilla.wikimedia.org/show_bug.cgi?id=52151
Web browser: ---
Bug ID: 52151
Summary: hebrew wikiedpdia tools databases in tools
Product: Wikimedia Labs
Version: unspecified
Hardware: All
OS: All
Status: NEW
Severity: normal
Priority: Unprioritized
Component: Infrastructure
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected], [email protected]
Classification: Unclassified
Mobile Platform: ---
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.
--
You are receiving this mail because:
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
