Fork of
مقالات يبدأ تاريخها بتحويل
by FShbib
This query is marked as a draft
This query has been published
by SHEIKH.
SQL
AخA
USE bnwiki_p;
SELECT CONCAT('# [[', page_title, ']]') AS page_title, rev_comment
FROM page, revision
WHERE page.page_id = revision.rev_page
AND rev_comment LIKE '%Move_to%'
AND page_namespace = 0
AND rev_parent_id = 0
AND page_is_redirect = 0
ORDER BY rev_comment
#LIMIT 10;
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.