Pixabay files on Commons missing {{pixabay}}

Fork of Pixabay files on Commons missing {{pixabay}} by Achim55

This query is marked as a draft This query has been published by Zhuyifei1999.

SQL

USE commonswiki_p;

SET SESSION optimizer_switch='materialization=off';

SELECT DISTINCT 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 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')
                LIMIT 1)
LIMIT 1000;

SQL

Checking query status...