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;