SQL
AخA
SELECT
p_source.page_id, log_title, log_page, log_params, log_timestamp
FROM
plwiki_p.logging
LEFT JOIN page AS p_source ON p_source.page_title = log_title AND p_source.page_namespace = log_namespace
WHERE
log_type = 'move' AND
log_namespace = 0 AND
log_params LIKE '%:"Wikipedysta:%'
ORDER BY
log_id DESC
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.