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 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...