Untitled query #52456

SQL

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;
*/
SQL

Checking query status...
