SQL
AخA
USE frwikisource_p;
SELECT DISTINCT index_page.pl_title
FROM page AS ind, page, pagelinks AS index_page
LEFT JOIN templatelinks AS main_page
ON
main_page.tl_namespace = 104 AND
main_page.tl_title = index_page.pl_title AND
main_page.tl_from_namespace = 0
WHERE
ind.page_namespace = 112 AND
ind.page_title = "Revue_des_Deux_Mondes_-_1845_-_tome_9.djvu" AND
index_page.pl_from = ind.page_id AND
index_page.pl_namespace = 104 AND
page.page_namespace = 104 AND
page.page_title = index_page.pl_title AND
main_page.tl_title is NULL;
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.