Fork of
Untitled query #14719
by جار الله
This query is marked as a draft
This query has been published
by لوقا.
SQL
x
select re.rev_id,co.comment_text,us.user_name from revision as re
inner join comment as co on re.rev_comment_id = co.comment_id
inner join user as us on re.rev_user = us.user_id
where re.rev_page = 1149712
limit 10;
#select * from comment limit 10
#select * from page where page_id = 1149712
#select * from page_props where pp_page = 1149712
#select * from redirect limit 10 #where rd_from = 1149712
/*
select page.page_title,redirect.rd_title from page
inner join redirect
on redirect.rd_from = page.page_id
where page_is_redirect = 1 and redirect.rd_title in (select page_title from page where page_id = 1149712)
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.