Untitled query #51889

This query is marked as a draft This query has been published by Kvapilikova.
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", "Invertebrates_by_adaptation", "Birds_by_adaptation", "Fish_by_adaptation", "Mammals_by_adaptation", "Amphibious_organisms", "Aposematic_animals", "Aquatic_animals", "Bioluminescent_animals", "Blind_animals", "Cave_animals", "Animal_cognition", "Diving_animals", "Animals_by_eating_behaviors", "Animals_that_use_echolocation", "Electroreceptive_animals", "Ethology", "Gliding_animals", "Largest_organisms", "Animal_locomotion", "Animal_migration", "Parasitic_animals", "Animal_physiology", "Poisonous_animals", "Rolling_animals", "Animal_sexuality", "Tool-using_animals", "Animals_with_only_two_limbs", "Animals_by_common_name", "Birds_by_common_name", "Frogs", "Toads", "Tortoises", "Animals_by_habitat", "Desert_fauna", "Fish_by_habitat", "Mangrove_fauna", "Animals_by_location", "Animals_by_region", "Fauna_by_continent", "Fauna_by_country", "Fauna_by_biogeographic_realm", "Fauna_by_sea_or_ocean", "Lists_of_animals_by_location", "Extinct_animals_by_location", "Cosmopolitan_animals", "Endemic_fauna", "Animal_breeds_by_location_of_origin", "Animals_in_captivity", "Cnidarians_by_location", "Echinoderms_by_continent", "Animals_in_France", "Invertebrates_by_location", "Animals_in_Ireland", "Animals_in_Pakistan", "Pantropical_fauna", "Animals_in_Romania", "Fauna_of_South_America_by_location", "Animals_in_space", "Sponges_by_location", "Animals_in_the_United_Kingdom", "Animals_in_the_United_States", "Vertebrates_by_location", "Wayward_animals", "Animals_by_year_of_formal_description", "Amphibians_by_year_of_formal_description", "Birds_by_year_of_formal_description", "Crustaceans_by_year_of_formal_description", "Fish_by_year_of_formal_description", "Insects_by_year_of_formal_description", "Mammals_by_year_of_formal_description", "Molluscs_by_year_of_formal_description", "Nematodes_by_year_of_formal_description", "Reptiles_by_year_of_formal_description", "Spiders_by_year_of_formal_description", "Sponges_by_year_of_formal_description", "Animals_described_in_the_18th_century", "Animals_described_in_the_19th_century", "Animals_described_in_the_20th_century", "Animals_described_in_the_21st_century", "Starfish_by_year_of_formal_description", "Individual_animals", "Individual_animals_by_country", "Individual_animals_by_period", "Individual_animals_by_taxon", "Individual_wild_animals", "Lists_of_individual_animals", "Animal_actors", "Individual_albino_animals", "Animal_amputees", "Awards_to_animals", "Circus_animals", "Cloned_animals", "Endlings", "Animals_on_the_Internet", "Missing_or_escaped_animals", "Animals_in_politics", "Redirects_from_animals", "Animals_in_space", "Individual_animals_in_sport", "Wayward_animals", "Animal_births", "Animal_births_by_time", "Racehorse_births_by_century", "Animal_locomotion", "Animal_flight", "Aquatic_locomotion", "Arboreal_locomotion", "Gait_abnormalities", "Terrestrial_locomotion", "Animal_physiology", "Animal_anatomy", "Animal_neurophysiology", "Body_fluids", "Animal_death", "Electroreceptive_animals", "Excretion", "Fish_physiology", "Insect_physiology", "Kinin–kallikrein_system", "Respiration", "Sleep", "Thermoregulation", "Animals_by_conservation_status", "Fauna_of_Africa_by_conservation_status", "Fauna_of_Asia_by_conservation_status", "Fauna_of_North_America_by_conservation_status", "Fauna_of_Oceania_by_conservation_status", "Fauna_of_South_America_by_conservation_status", "Lists_of_animals_by_conservation_status", "Fauna_of_the_United_States_by_conservation_status", "Fauna_of_Australia_by_conservation_status", "Critically_endangered_animals", "Endangered_animals", "Endangered_ocean_life", "Extinct_animals", "Fish_by_conservation_status", "Insects_by_conservation_status", "Near_threatened_animals", "Vulnerable_animals", "Animal_cognition", "Animal_communication", "Animal_emotions", "Animal_intelligence", "Neuroethology", "Talking_animals", "Animal_common_names", "Amphibian_common_names", "Animals_by_common_name", "Bird_common_names", "Fish_common_names", "Invertebrate_common_names", "Mammal_common_names", "Reptile_common_names", "Set_indices_on_animal_common_names", "Cryptids", "Fiction_about_cryptids", "Hominid_cryptids", "Loch_Ness_Monster", "Mothman", "Purported_mammals", "Ctenophores", "Ctenophore_genera", "Nuda", "Prehistoric_ctenophores", "Tentaculata", "Ctenophore_stubs", "Evolution_of_animals", "Animals_by_adaptation", "Evolution_of_protostomes", "Evolution_of_vertebrates", "Animal_health", "Animal_diseases", "Bird_health", "Animal_death", "Fish_health", "Inbred_animals", "Insect_health", "Mammal_health", "Oldest_animals", "Parasites_of_animals", "Animal_health_in_the_United_Kingdom", "Animals_and_humans", "Animals_by_use", "Invertebrates_and_humans", "Vertebrates_and_humans", "Animal-related_accidents_and_incidents", "Animal_attacks", "Animal_care_occupations", "Animal_disease_control", "Animal_emotions", "Animal_keeping_by_humans", "Animal_killing", "Animal_rescuers", "Animal_rights", "Animal_sacrifice", "Animal_shows", "Animal-assisted_therapy", "Animal-borne_bombs", "Aquariums", "Animal_bites", "Buildings_and_structures_used_to_confine_animals", "Human–animal_communication", "Cowboy_culture", "Animals_in_human_culture", "Dishes_involving_the_consumption_of_live_animals", "Animals_in_entertainment", "Human–wildlife_conflict", "Hunting", "Animal_identification", "Animal_law", "Lists_of_things_named_after_animals", "Missing_or_escaped_animals", "Animal_models", "Animal_organizations", "Animal_parasites_of_humans", "People_associated_with_animals", "Pest_control", "Pets", "Animals_in_politics", "Animal_products", "Biorobotics", "Animal_shelters", "Animal_theft", "Urban_wildlife", "Animal_welfare", "Zoonoses", "Zoophilia", "Zoophobias", "Hybrid_animals", "Amphibia_hybrids", "Bird_hybrids", "Fish_hybrids", "Mammal_hybrids", "Images_of_animals", "Arthropod_images", "Chordate_images", "Invertebrates", "Invertebrates_by_adaptation", "Invertebrates_by_location", "Invertebrates_and_humans", "Invertebrate_common_names", "Lists_of_invertebrates", "Invertebrate_paleozoology", "Lists_of_animals", "Lists_of_animals_by_location", "Lists_of_animals_described_in_the_21st_century", "Lists_of_animals_(alphabetic)", "Lists_of_arthropods", "Lists_of_cnidarians", "Lists_of_animals_by_conservation_status", "Lists_of_domesticated_animals", "Lists_of_echinoderms", "Lists_of_fictional_animals", "Lists_of_animals_displaying_homosexual_behavior", "Lists_of_individual_animals", "Lists_of_invertebrates", "Lists_of_largest_animals", "Lists_of_molluscs", "Lists_of_animals_in_mythology_and_religion", "Lists_of_animal_species", "Lists_of_vertebrates", "Lists_of_zoos", "Nocturnal_animals", "Bats", "Owls", "Oldest_animals", "ParaHoxozoa", "Bilaterians", "Cnidarians", "Placozoa", "Parazoa", "Placozoa", "Robotic_animals", "Robotic_dinosaurs", "Robotic_dogs", "Robotic_snakes", "Robotic_spiders", "Set_indices_on_animalia", "Set_indices_on_animal_common_names", "Disused_trilobite_generic_names", "Set_indices_on_snakes", "Set_indices_on_spiders", "Animal_sexuality", "Animal_breeding", "Avian_sexuality", "Lists_of_animals_displaying_homosexual_behavior", "Mammalian_sexuality", "Mating_systems", "Orgasm", "Reproduction_in_animals", "Works_about_animal_sexuality", "Zoophilia", "Animal_taxa", "Animal_taxa_by_author", "Animal_taxa_by_rank", "Individual_animals_by_taxon", "Bilaterian_taxa", "Cnidarian_taxa", "Monotypic_animal_taxa", "Obsolete_animal_taxa", "Prehistoric_animal_taxa", "Animal_taxonomy", "Animal_stubs", "Parasitic_animal_stubs", "Prehistoric_animal_stubs", "Cnidarian_stubs", "Ctenophore_stubs", "Deuterostome_stubs", "Pet_stubs", "Poriferan_stubs", "Protostome_stubs", "Xenacoelomorpha_stubs", "Zoology_by_country", "Ornithology_by_country", "Bird_sanctuaries_by_country", "Ornithology_in_Australia", "Ornithology_in_Canada", "Ornithology_in_the_Caribbean", "Ornithology_in_Denmark", "Ornithology_in_England", "Ornithology_in_Ireland", "Ornithology_in_the_Netherlands", "Ornithology_in_Nigeria", "Ornithology_in_Norway", "Ornithology_in_the_United_Kingdom")   
        ) 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.
SQL

Checking query status...
