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
.
https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/Shared_Resources/MySQL_queries#Mistagged_non-free_content
Toggle Highlighting
SQL
SELECT #CONCAT('#[[:Attēls:',DISTINCT(lvwiki_p.page.page_title),']]') as "Nosaukums lvwiki", DISTINCT(lvwiki_p.page.page_title) as "Nosaukums lvwiki", commonswiki_p.image.img_name as "Nosaukums Commons" FROM lvwiki_p.image, commonswiki_p.image, lvwiki_p.categorylinks, lvwiki_p.page WHERE lvwiki_p.image.img_sha1 = commonswiki_p.image.img_sha1 and lvwiki_p.page.page_title != commonswiki_p.image.img_name AND lvwiki_p.page.page_title = lvwiki_p.image.img_name AND lvwiki_p.categorylinks.cl_from = lvwiki_p.page.page_id AND lvwiki_p.categorylinks.cl_to IN ("Aizsargāti_attēli", "Aizsargāti_logo", "Aizsargātas_pastmarkas", "Aizsargāti_filmu_plakāti", "Aizsargāti_grāmatu_vāki", "Aizsargāti_skaņas_faili", "Albuma_vāka_attēli", "Pastmarkas") AND lvwiki_p.image.img_sha1 != 'phoiac9h4m842xq45sp7s6u21eteeq1';
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...