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", "Animals_by_adaptation", "Animals_by_common_name", "Animals_by_habitat", "Animals_by_location", "Animals_by_year_of_formal_description", "Individual_animals", "Animal_births", "Animal_locomotion", "Animal_physiology", "Animals_by_conservation_status", "Animal_cognition", "Animal_common_names", "Cryptids", "Ctenophores", "Evolution_of_animals", "Animal_health", "Animals_and_humans", "Hybrid_animals", "Images_of_animals", "Invertebrates", "Lists_of_animals", "Nocturnal_animals", "Oldest_animals", "ParaHoxozoa", "Parazoa", "Robotic_animals", "Set_indices_on_animalia", "Animal_sexuality", "Animal_taxa", "Animal_stubs", "Zoology_by_country", "Ornithology_by_country", "Zoology_organizations_by_country", "Zoology_in_the_United_States", "Subfields_of_zoology", "Zoologists_by_field_of_research", "Arthropodology", "Bryozoology", "Herpetology", "Ichthyology", "Mammalogy", "Ornithology", "Paleozoology", "Planktology", "Zoological_collectors", "Conchologists", "Egg_collectors", "Zoologists", "Lists_of_zoologists", "Zoologists_by_century", "Zoologists_by_field_of_research", "Zoologists_by_nationality", "Women_zoologists", "Zoologists_with_author_abbreviations", "Medieval_zoologists", "Tamil_zoologists", "Zoologists_of_medieval_Islam", "Zoologist_stubs", "Anatomy", "Anatomists", "Anatomical_planes", "Anatomical_terminology", "Anatomy_journals", "Anatomy_portals", "Anatomy_websites", "Animal_anatomy", "Body_Regions", "Brain_anatomy", "Cell_anatomy", "Comparative_anatomy", "Computational_anatomy", "Embryology", "Eye_anatomy", "Fungal_morphology_and_anatomy", "Histology", "History_of_anatomy", "Human_anatomy", "Anatomy_literature", "Organs_(anatomy)", "Anatomical_pathology", "Plant_anatomy", "Anatomical_preservation", "Sexual_anatomy", "Anatomical_simulation", "Tissues_(biology)", "Wikipedia_articles_incorporating_text_from_the_20th_edition_of_Gray's_Anatomy_(1918)", "Wikipedia_books_on_anatomy", "Anatomy_stubs", "Animal_anatomy", "Animal_head", "Animal_nervous_system", "Body_fluids", "Body_plans", "Animal_cells", "Circulatory_system", "Cnidarian_anatomy", "Dental_anatomy", "Deuterostome_anatomy", "Glands", "Animal_hair", "Invertebrate_nervous_system", "Lymphatic_system", "Animal_morphology", "Mouth", "Protostome_anatomy", "Animal_reproductive_system", "Senses_by_taxon", "Sexual_dimorphism", "Sponge_anatomy", "Urinary_system", "Animal_anatomy_stubs", "Muscle_stubs", "Animal_cognition", "Animal_communication", "Animal_emotions", "Animal_intelligence", "Neuroethology", "Talking_animals", "Animal_communication", "Animals_that_use_echolocation", "Fiction_about_animal_communication", "Human–animal_communication", "Animal_sexuality", "Animal_sounds", "Talking_animals", "Warning_coloration", "Whale_sounds", "Animal_emotions", "Animal_genetics", "Domesticated_animal_genetics", "Animal_genes", "Protostome_genetics", "Vertebrate_genetics", "Animal_metabolism", "Animal_metabolites", "Animal_physiology", "Animal_anatomy", "Animal_neurophysiology", "Body_fluids", "Animal_death", "Electroreceptive_animals", "Excretion", "Fish_physiology", "Insect_physiology", "Kinin–kallikrein_system", "Respiration", "Sleep", "Thermoregulation", "Animal_proteins", "Avian_proteins", "Cnidarian_proteins", "Insect_proteins", "Mammalian_proteins", "Molluscan_proteins", "Cnidarian_biology", "Cnidariologists", "Cnidarian_anatomy", "Cnidarian_proteins", "Cryptozoology", "Bigfoot", "Critics_of_cryptozoology", "Cryptids", "Cryptozoologists", "Cryptozoology_in_fiction", "Living_dinosaurs", "Loch_Ness_Monster", "Cryptozoological_television_series", "Cryptozoology_stubs", "Deuterostome_zoology", "Chordate_zoology", "Echinoderm_biology", "Animal_developmental_biology", "Developmental_neuroscience", "Embryology", "Gastrulation", "Hedgehog_signaling_pathway", "Insect_developmental_biology", "Larvae", "Mating", "Vertebrate_developmental_biology", "Animal_ecology", "Animal_conservation", "Deuterostome_ecology", "Introduced_animals", "Protostome_ecology", "Animal_reintroduction", "Ethology", "Ethologists", "Abnormal_behaviour_in_animals", "Animal_cannibalism", "Animal_emotions", "Animal_locomotion", "Animal_migration", "Animal_sounds", "Animals_by_eating_behaviors", "Behavior_by_type_of_animal", "Behavioral_ecology", "Biological_interactions", "Ethology_journals", "Mammal_behavior", "Mating", "Neuroethology", "Shelters_built_or_used_by_animals", "Tool-using_animals", "Visual_arts_by_animals", "Zoosemiotics", "Ethology_stubs", "Glossaries_of_zoology", "History_of_zoology", "Animals_by_year_of_formal_description", "Bestiaries", "Zoology_organizations", "Zoology_organizations_by_country", "Animal_breeding_organizations", "Entomological_organizations", "Herpetology_organizations", "Ichthyology_organizations", "Linnean_Society_of_London", "Monkey_parks", "Zoology_museums", "Ornithological_organizations", "Zoo_associations", "Zoological_societies", "Zoos", "Paleozoology", "Paleozoologists", "Invertebrate_paleozoology", "Paleomalacology", "Prehistoric_animals", "Vertebrate_paleozoology", "Professorships_in_zoology", "Protostome_biology", "Protostome_anatomy", "Protostome_ecology", "Protostome_genetics", "Insect_biology", "Insect_physiology", "Malacology", "Nematology", "Sociobiology", "Behavioral_ecology", "Books_about_sociobiology", "Evolutionary_psychology", "Sexual_orientation_and_science", "Sponge_biology", "Spongiologists", "Sponge_anatomy", "Animal_taxonomy", "Bilaterian_taxonomy", "Cnidarian_taxonomy", "Systems_of_animal_taxonomy", "Zoology_timelines", "Wikipedia_books_on_animals", "Wikipedia_books_on_dogs", "Wikipedia_books_on_gastropods", "Wikipedia_books_on_birds", "Wikipedia_books_on_zoology", "Wikipedia_books_on_anatomy", "Wikipedia_books_on_animals", "Zoological_literature", "Arachnological_literature", "Carcinological_literature", "Entomological_literature", "Herpetological_literature", "Ichthyological_literature", "Malacological_literature", "Mammalogical_literature", "Nematological_literature", "Ornithological_literature", "Zoology_books", "Zoology_journals", "Zoological_nomenclature", "Animal_taxonomy", "Forma_taxa", "Morphas", "Zoology-related_lists", "Lists_of_animals", "EDGE_species", "Ornithology_lists", "Lists_of_things_named_after_animals", "Lists_of_vertebrates", "Zoosemiotics", "Animal_communication", "Zoomusicology", "Zoology_stubs", "Animal_anatomy_stubs", "Cryptozoology_stubs", "Ethology_stubs", "Veterinary_medicine_stubs", "Zoologist_stubs", "Zoo_stubs", "Zoology_book_stubs", "Zoology_journal_stubs", "Animal_stubs", "Breed_stubs", "Zoology_stub_templates") ) 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...