SQL
AخA
!!Better us_e https://en.wikipedia.org/wiki/Help:Searching
USE etwiki_p;
SELECT *
FROM pagelinks
WHERE pl_title LIKE 'USA_kveekerite_organisatsioon'
INNER JOIN page ON pl_from = page_id
INNER JOIN templatelinks ON page_id = tl_from
AND NOT EXISTS tl_title LIKE 'NobelRahu'
#AND NOT EXISTS (select 1 from pagelinks where pl_from = author.page_id and pl_namespace = 0 and pl_title = text.page_title)
#and (
# exists (select 1 from categorylinks where cl_from = text.page_id and cl_to = concat('Testi_di_', author.page_title))
# or exists (select 1 from categorylinks where cl_from = text.page_id and cl_to = concat('Traduzioni_di_', author.page_title))
#)
LIMIT 99;
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.