Fork of
Untitled query #60760
by Draco flavus
This query is marked as a draft
This query has been published
by Draco flavus.
SQL
AخA
USE plwikisource_p;
SELECT
page_title,
iwl_title
FROM page
INNER JOIN templatelinks on tl_from = page_id
INNER JOIN iwlinks on iwl_from = page_id
WHERE
tl_from_namespace = 0 AND
tl_namespace = 10 AND
tl_title = "Dane_tekstu" AND
(iwl_prefix = "commons" OR iwl_prefix = "c")
;
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.