Untitled query #14688

SQL

USE enwiki_p;

select *
from enwiki_p.page enp, enwiki_p.page_props enpp, wikidatawiki_p.page wdp
where enp.page_namespace = 14
and enp.page_title = 'Rage_(German_band)_songs'
and enp.page_id = enpp.pp_page
and enpp.pp_propname = 'wikibase_item'
and enpp.pp_value = wdp.page_title
and wdp.page_namespace = 0
;
-- page_id = 45662151; -- page_title = 'Rage (German band) songs';

SELECT *
FROM wikidatawiki_p.page
limit 5;

-- select * from page_props limit 5;

-- show tables;

-- Category:Rage (German band) songs
-- Q25213720
SQL

Checking query status...
