Pixabay files on Commons missing {{pixabay}}

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.

SQL

#USE stop;
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'
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'))
#GROUP BY pt
LIMIT 200;

SQL

Checking query status...