Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
Fork of
Bad links from wikis to Commons: redirects
by
Achim55
This query is marked as a draft
This query has been published
by
Achim55
.
Toggle Highlighting
SQL
USE commonswiki_p; SELECT CONCAT('# [[:File:', REPLACE (page_title,'_',' '), ']]') AS pt #FROM page INNER JOIN externallinks #ON el_from = page_id AND el_to LIKE '%pixabay.com%' #WHERE page_namespace = 6 #AND page_title LIKE '%.jpg' FROM externallinks INNER JOIN page ON page_id = el_from AND page_namespace = 6 AND page_title LIKE '%.jpg' AND page_id NOT IN (SELECT tl_from FROM templatelinks WHERE tl_from_namespace = 6 AND tl_namespace = 10 AND tl_title IN ('Pixabay', 'LicenseReview', 'License-review', 'Licensereview', 'License_review', 'License_Review', 'Licencereview', 'LicenceReview', 'Licence_review')) WHERE el_to LIKE '%pixabay.com%' #AND NOT EXISTS (SELECT 1 FROM templatelinks # WHERE tl_from = page_id # AND tl_from_namespace = 6 # AND tl_namespace = 10 # AND tl_title IN ('Pixabay', # 'LicenseReview', # 'License-review', # 'Licensereview', # 'License_review', # 'License_Review', # 'Licencereview', # 'LicenceReview', # 'Licence_review')) GROUP BY pt 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...