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
Edgars2007
.
pl_from = page_id use wikidatawiki_p; select CONCAT("Q",ips_item_id), CONCAT("Llv"), CONCAT('"',ips_site_page,'"') from wb_items_per_site i #join wb_terms on ips_item_id = term_entity_id and term_type = "label" where i.ips_site_id='lvwiki' and i.ips_item_id not in (select term_entity_id from wb_terms where# ips_item_id = term_entity_id and term_type = "label" and term_language='lv') group by ips_item_id limit 1000; ---------------------------------------------------- USE wikidatawiki_p; SELECT * FROM pagelinks WHERE #pl_namespace = 0 AND pl_from=23133519 limit 15; -------------------------------- use wikidatawiki_p; select *#CONCAT("Q",ips_item_id), CONCAT("Llv"), CONCAT('"',ips_site_page,'"') from wb_items_per_site i join pagelinks on pl_from=23133519 and #join wb_terms on ips_item_id = term_entity_id and term_type = "label" where i.ips_site_id='lvwiki' group by ips_item_id limit 19; ------------------------------------------ use wikidatawiki_p; select *#CONCAT("Q",ips_item_id), CONCAT("Llv"), CONCAT('"',ips_site_page,'"') from pagelinks left join wb_items_per_site i on pl_from=23133519 and pl_title=ips_item_id #join wb_terms on ips_item_id = term_entity_id and term_type = "label" where i.ips_site_id='lvwiki' group by ips_item_id limit 19;
Toggle Highlighting
SQL
use lvwiki_p; SELECT #*concat('* [[Veidne:',p.page_title,']]') concat('* [[Veidne:',p.page_title,']]') #COUNT(tl.tl_from) from page p left join templatelinks tl on tl.tl_namespace = 10 and p.page_title=tl.tl_title where p.page_namespace=10 and p.page_title not like "%/%" and p.page_is_redirect=0 and p.page_id not in (SELECT eu_page_id from wbc_entity_usage wb GROUP BY eu_page_id) and p.page_id not in (select ll_from from langlinks ll ) and tl.tl_from is null group by p.page_title ORDER BY COUNT(tl.tl_from) asc limit 1000;
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...