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.

Checking query status...