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 (
	"Індевор (шатл)",
	"Струмоприймач",
  	"Список національних парків Японії"
)
order by rev_timestamp asc

SQL

Checking query status...