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 (p1.page_title,'_',' '), ']]') AS pt
FROM page p1
INNER JOIN externallinks
ON el_from = p1.page_id AND el_to LIKE '%pixabay.com%'
INNER JOIN (SELECT p2.page_id FROM page p2 INNER JOIN templatelinks
                         ON tl_from = p2.page_id AND tl_from_namespace = 6 AND tl_namespace = 10
                AND tl_title NOT IN ('Pixabay',
                                 'LicenseReview',
                                 'License-review',
                                 'Licensereview',
                                 'License_review',
                                 'License_Review',
                                 'Licencereview',
                                 'LicenceReview',
                                 'Licence_review'))
WHERE p2.page_id = p1.page_id
AND p1.page_namespace = 6
AND p1.page_title LIKE '%.jpg'
#GROUP BY pt
LIMIT 10;

SQL

Checking query status...