SQL
AخA
SELECT CONCAT('[[', REPLACE('_', ' ', page_title), ']]') AS 'Artikel',
IF(pp_value IS NULL, '', CONCAT('[[:Datei:', REPLACE('_', ' ', pp_value), ']]')) AS 'Vorschaubild'
FROM templatelinks, page LEFT JOIN page_props
ON pp_page = page_id
AND pp_propname = 'page_image_free'
WHERE page_namespace = 0
AND page_id = tl_from
AND tl_namespace = 10
AND tl_title = 'Infobox_Chemikalie'
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.