Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
XXN
.
Toggle Highlighting
SQL
/*USE rowiki_p; SELECT page_title, pp_value, ll_title, tw2.CI FROM page join (SELECT SUBSTRING_INDEX(pl1.pl_title, '/', -1) as sbs, b.CountField as CI FROM test2wiki_p.pagelinks pl1 right JOIN (SELECT pl2.pl_title, COUNT(*) AS CountField FROM test2wiki_p.pagelinks pl2 where pl2.pl_from = 57964 GROUP BY pl2.pl_title) b ON pl1.pl_title=b.pl_title) tw2 on page_title =tw2.sbs LEFT JOIN langlinks ON ll_from = page_id LEFT JOIN (SELECT * FROM page_props WHERE pp_propname = 'wikibase_item') AS props ON pp_page = page_id WHERE ll_lang="uk" AND page_namespace = 0 and page_is_redirect = 0*/ USE rowiki_p; SELECT page_title, pp_value, ll_title FROM page LEFT JOIN langlinks ON ll_from = page_id LEFT JOIN (SELECT * FROM page_props WHERE pp_propname = 'wikibase_item') AS props ON pp_page = page_id WHERE ll_lang="uk" AND page_namespace = 0 and page_is_redirect = 0 and page_title in (SELECT pl1.pl_title FROM test2wiki_p.pagelinks pl1 where pl1.pl_from = 57964/*33258*/) /**/ /* (SELECT pl1.pl_title FROM test2wiki_p.pagelinks pl1 INNER JOIN (SELECT pl_title, COUNT(*) AS CountField FROM test2wiki_p.pagelinks pl2 GROUP BY pl2.pl_title) b ON pl1.pl_title=b.pl_title where pl1.pl_from = 57964)*/ #ORDER BY page_title; /* USE wikidatawiki_p; SELECT * FROM wb_items_per_site WHERE ips_site_id='rowiki' AND ips_site_page IN (SELECT REPLACE(pl1.pl_title, '_', ' ') FROM test2wiki_p.pagelinks pl1 where pl1.pl_from = 57964) */ #SELECT pl1.pl_title FROM test2wiki_p.pagelinks pl1 where pl1.pl_from = 57964 /* SELECT SUBSTRING_INDEX(pl1.pl_title, '/', -1), b.CountField FROM test2wiki_p.pagelinks pl1 right JOIN (SELECT pl2.pl_title, COUNT(*) AS CountField FROM test2wiki_p.pagelinks pl2 where pl2.pl_from = 57964 GROUP BY pl2.pl_title) b ON pl1.pl_title=b.pl_title */
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...