SQL
AخA
SELECT
p.page_title,
SUBSTRING(c.content, 1, 200) AS snippet
FROM page AS p
JOIN revision AS r ON p.page_id = r.rev_page
JOIN slots AS s ON r.rev_id = s.slot_revision_id
JOIN content AS c ON s.slot_content_id = c.content_id
JOIN slot_roles AS sr ON s.slot_role_id = sr.role_id
WHERE
p.page_namespace = 0
AND sr.role_name = 'main'
AND BINARY c.content REGEXP '[^\\.\\!\\?]\\s+(Januari|Februari|Maart|April|Mei|Juni|Juli|Augustus|September|Oktober|November|December)'
LIMIT 100;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.