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
Danilo.mac
.
Artigos que não têm predefinições começadas por "Info/" na ptwiki, mas cujo artigo na enwiki contém predefinições começadas por "Infobox " e que usam dados de declarações do Wikidata. Esta lista ajuda a estabelecer uma prioridade de colocação de infoboxes com dados do Wikidata em artigos da ptwiki.
Toggle Highlighting
SQL
SELECT page_title AS ARTIGO, page_len AS TAMANHO FROM ptwiki_p.page WHERE page_namespace = 0 AND NOT page_is_redirect AND page_id NOT IN (SELECT DISTINCT tl_from FROM ptwiki_p.templatelinks WHERE tl_from_namespace = 0 AND tl_namespace = 10 AND tl_title LIKE 'Info/%') AND page_title IN (SELECT REPLACE(ll_title, ' ', '_') FROM enwiki_p.langlinks INNER JOIN (SELECT DISTINCT tl_from AS enpageid FROM enwiki_p.templatelinks WHERE tl_from_namespace = 0 AND tl_namespace = 10 AND tl_title LIKE 'Infobox\_%' AND tl_from IN (SELECT DISTINCT eu_page_id FROM enwiki_p.wbc_entity_usage WHERE eu_aspect = 'O') ) AS pagetitles ON ll_from = enpageid WHERE ll_lang = 'pt');
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...