idwiki: fairuse image on BLP (nope)

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" category
- image appear on page x
- page x is somewhere under "Orang_hidup"

SQL

USE idwiki_p;
SELECT p.page_title FROM page p
INNER JOIN categorylinks c1 ON p.page_id = c1.cl_from
INNER JOIN imagelinks i ON p.page_title = i.il_to
INNER JOIN page x ON x.page_id = i.il_from
INNER JOIN categorylinks c2 ON x.page_id = c2.cl_from
INNER JOIN page sc3 ON sc3.page_id = c2.cl_from
INNER JOIN categorylinks c3 ON c3.cl_to = sc3.page_title
WHERE c1.cl_to = "Gambar_berlisensi_penggunaan_wajar"
AND c3.cl_to = "Orang_hidup"
AND p.page_namespace = 6

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...