whatever I can fetch about pages for CEES stat (2)

Fork of whatever I can fetch about pages for CEES stat by Base

This query is marked as a draft This query has been published by Base.

SQL

select rev_id, rev_page, /*page_title, *//* ips_item_id,*/ rev_user, rev_user_text, rev_timestamp, rev_len, rev_parent_id, rev_sha1
from ukwiki_p.revision_userindex  r
-- join ukwiki_p.page p
-- on p.page_id = r.rev_page
-- left join wikidatawiki_p.wb_items_per_site d
-- on ips_site_id = "ukwiki" and p.page_title = replace(d.ips_site_page, " ", "_")
/*where page_title IN (
	"Індевор_(шатл)",
	"Струмоприймач",
  	"Список_національних_парків_Японії"
)*/
where rev_page IN (
	1,
  	2,
  	3,
  	24235
)
order by rev_timestamp asc

SQL

Checking query status...