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
Kvapilikova
.
Toggle Highlighting
SQL
SELECT p.page_title, c.cl_to, c.cl_from, c.cl_type, l.ll_lang, l.ll_title FROM page p INNER JOIN (SELECT * FROM categorylinks WHERE cl_to IN ( "Zoology", "Animals", "Zoology_by_country", "Subfields_of_zoology", "Zoological_collectors", "Zoologists", "Anatomy", "Animal_anatomy", "Animal_cognition", "Animal_communication", "Animal_emotions", "Animal_genetics", "Animal_metabolism", "Animal_physiology", "Animal_proteins", "Cnidarian_biology", "Cryptozoology", "Deuterostome_zoology", "Animal_developmental_biology", "Animal_ecology", "Ethology", "Glossaries_of_zoology", "History_of_zoology", "Zoology_organizations", "Paleozoology", "Professorships_in_zoology", "Protostome_biology", "Sociobiology", "Sponge_biology", "Animal_taxonomy", "Zoology_timelines", "Wikipedia_books_on_animals", "Wikipedia_books_on_zoology", "Zoological_literature", "Zoological_nomenclature", "Zoology-related_lists", "Zoosemiotics", "Zoology_stubs") ) AS c ON p.page_id = c.cl_from LEFT OUTER JOIN (SELECT * FROM langlinks WHERE ll_lang IN ("sk", "fr") ) AS l ON l.ll_from = c.cl_from
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...