SQL
x
/*select * from wikidatawiki_p.page as wp
where wp.page_namespace = 0
and wp.page_title in (
*/
select pp.pp_value from trwiki_p.page as p
join trwiki_p.page_props pp on pp.pp_page = p.page_id
where p.page_namespace = 0
and p.page_id in (select tl_from from templatelinks tl where tl.tl_title in ("Vikisöz") and tl.tl_from_namespace = 0 )
and pp.pp_propname = "wikibase_item"
-- )
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.