SQL
AخA
use jawiki_p;
select *
from pagelinks as pl
inner join (
select page.page_id, page.page_title
from page
inner join (
select ru.rev_page
from revision_userindex as ru
where
ru.rev_user = "404375" and
ru.rev_parent_id = "0" and
ru.rev_minor_edit = "0"
) as ca on page.page_id = ru.rev_page
where page.page_namespace="0"
) as pg on pl.pl_title = pg.page_title
where pl.pl_from_namespace = "4"
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.