Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
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"
Toggle Highlighting
SQL
USE idwiki_p; SELECT image_pages.page_title FROM page image_pages#,# categorylinks ci1, imagelinks il,#, page pi1, categorylinks ci2, # page blp_pages#, categorylinks c1, page p1, categorylinks c2 INNER JOIN page p1 ON (p1.page_id = c1.cl_from) INNER JOIN categorylinks c2 ON (c2.cl_to = p1.page_title) INNER JOIN page blp_pages ON (blp_pages.page_id = c2.cl_from) INNER JOIN imagelinks il ON (il.il_to = blp_pages.page_title) INNER JOIN categorylinks ci1 ON (ci1.cl_from = il.il_from) WHERE c1.cl_to = "Orang_hidup" #AND c1.cl_from = p1.page_id #AND c2.cl_to = p1.page_title #AND c2.cl_from = blp_pages.page_id AND ci1.cl_to = "Gambar_berlisensi_penggunaan_wajar" #AND ci1.cl_from = pi1.page_id #AND ci2.cl_to = pi1.page_title #AND il.il_from = ci1.cl_from #AND blp_pages.page_title = il.il_to AND ci1.cl_from = image_pages.page_id
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
.
Checking query status...