Fork of
b
by Ahmad Kanik
This query is marked as a draft
This query has been published
by Ahmad Kanik.
SQL
AخA
SELECT CONCAT("[[টেমপ্লেট:", page_title, ']]') as Template
FROM categorylinks
JOIN page ON page_id = cl_from
WHERE cl_to = 'ভারতের_রাজনৈতিক_দলের_রঙ_টেমপ্লেট'
AND cl_type = 'page'
AND page_namespace = 10
AND page_title NOT IN
(SELECT lt_title
FROM linktarget
WHERE lt_namespace=10
AND lt_id IN
(SELECT tl_target_id
FROM templatelinks)
);
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.