idwiki: fairuse image on BLPs (v1.0.0)

Fork of idwiki: fairuse image on BLPs (TODO test 2) by Kenrick95

This query is marked as a draft This query has been published by Kenrick95.

List of images where
- image is somewhere under "Gambar_berlisensi_penggunaan_wajar" (fairuse) category
- image appear on page x
- page x is somewhere under "Orang_hidup" (living person)

NOTE: QUERY TOOK ALMOST 30 MINUTES TO RUN. PROCEED WITH CAUTION!

SQL

USE idwiki_p;
SELECT image_pages.page_title
FROM page image_pages
INNER JOIN imagelinks il ON (il.il_to = image_pages.page_title)
INNER JOIN categorylinks ci1 ON (ci1.cl_from = image_pages.page_id)
INNER JOIN (SELECT c2.cl_from AS `page_id`
    FROM (categorylinks c1)
    INNER JOIN page p1 ON (p1.page_id = c1.cl_from)
    INNER JOIN categorylinks c2 ON (c2.cl_to = p1.page_title)
    WHERE c1.cl_to = "Orang_hidup") blp_pages
WHERE ci1.cl_to = "Gambar_berlisensi_penggunaan_wajar"
	AND il.il_from = blp_pages.page_id

SQL

Checking query status...