SQL
AخA
USE commonswiki_p;
SELECT
CONCAT('* [[:File:', page_title, ']]') AS title,
page_id AS page_id
FROM
page, /* for host page */
templatelinks
WHERE
page_id = tl_from AND /* host page */
tl_namespace = 10 AND
tl_title = 'Wiki_Loves_Earth_2017';
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.