Untitled query #52367

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 (
"Geography", "Geography_by_location", "Geography_by_city", "Geography_by_continent", "Geography_by_country", "Geography_by_region", "Administrative_divisions", "Categories_by_mountain_range", "Geographical_centres", "Geography_of_dwarf_planets", "Geography_of_planets", "Geography_of_islands", "Landforms_by_place", "Place_names", "Regions", "Subjects_by_plains", "Geographers", "Geographers_by_century", "Geographers_by_ethnicity", "Geographers_by_nationality", "Geographers_by_specialty", "Women_geographers", "Ancient_geographers", "Recipients_of_the_Cullum_Geographical_Medal", "Geographic_data_and_information_scholars", "Geography_award_winners", "Massey_Medal_recipients", "Medieval_geographers", "Geographers_of_medieval_Islam", "Presidents_of_the_International_Geographical_Union", "Geographer_stubs", "Geography-related_lists", "Lists_by_city", "Lists_by_continent", "Lists_by_country", "Lists_by_island", "Lists_by_organization", "Lists_by_region", "Lists_of_geography_lists", "Africa_geography-related_lists", "Asia_geography-related_lists", "Europe_geography-related_lists", "North_America_geography-related_lists", "Oceania_geography-related_lists", "South_America_geography-related_lists", "Geography-related_lists_by_country", "Lists_of_animals_by_location", "Lists_of_bodies_of_water", "Border-related_lists", "Lists_of_civil_parishes", "Lists_of_coordinates", "Lists_of_countries", "Lists_of_countries_by_geography", "Demographic_lists", "Lists_of_ecoregions", "Lists_of_events_by_place", "Lists_of_extreme_points", "Lists_of_films_by_shooting_location", "Lists_and_galleries_of_flags", "Geography-related_lists_of_superlatives", "Geology-related_lists", "Hydrology_lists", "Lists_of_impact_craters_on_Earth", "Lists_of_landforms", "Lists_of_maps", "Meteorology_lists", "Lists_of_people_by_location", "Lists_of_places", "Lists_of_Ramsar_sites", "Rivers-related_lists", "Surface_features_of_bodies_of_the_Solar_System", "Lists_of_species_by_location", "Geography_awards", "Awards_of_Royal_Geographical_Society", "Awards_of_the_American_Geographical_Society", "Awards_of_the_Royal_Scottish_Geographical_Society", "Geography_award_winners", "Branches_of_geography", "Cartography", "Geographic_data_and_information_fields_of_study", "Human_geography", "Physical_geography", "Political_geography", "Regional_geography", "Geographic_classifications", "Biogeographic_realms", "Biomes", "Country_classifications", "Districts_of_London_by_classification", "Ecosystems", "Geographic_taxonomies", "Twin_cities", "Geography_conferences", "Deserts", "Deserts_by_continent", "Deserts_by_country", "Lists_of_deserts", "Desert_greening", "Desertification", "Deserts_and_xeric_shrublands", "Ergs", "Desert_fauna", "Deserts_in_fiction", "Desert_flora", "Wadis", "Wikipedia_categories_named_after_deserts", "Spatial_epidemiology", "Geography_education", "Geography_education_in_Russia", "Geography_education_in_the_United_Kingdom", "Geography_education_in_the_United_States", "Geography_education_software", "Geography_educational_video_games", "Professorships_in_geography", "Schools_of_geography", "Geography_teachers", "Environmental_studies", "Environmental_conferences", "Environmental_studies_institutions", "Environmental_studies_journals", "Environmental_studies_organizations", "Environmental_studies_scholars", "Human_ecology", "Environmental_humanities", "Outdoors", "Environmental_science", "Environmental_social_science", "Exploration", "Exploration_by_continent", "Exploration_by_country", "Explorers", "Age_of_Discovery", "Age_of_Sail", "Bibliographies_of_explorations", "Expeditions", "History_books_about_exploration", "History_of_mountaineering", "Ocean_exploration", "Oil_exploration", "Polar_exploration", "Scientific_exploration", "Exploration_ships", "Space_exploration", "Urban_exploration", "Exploration_video_games", "Voyages", "Geographic_data_and_information", "Aerial_photography", "Geographic_data_and_information_companies", "Geographic_coordinate_systems", "Geographical_databases", "Digital_elevation_models", "Earth_observation", "Gazetteers", "Maps", "Geographic_data_and_information_organizations", "Photography_and_videography_of_Earth", "Place_names", "Geographic_position", "Geographic_data_and_information_professionals", "Geographic_data_and_information_software", "Geographic_information_systems", "Toponymy", "Web_mapping", "Geographical_zones", "Polar_regions", "Tropics", "Geography_competitions", "National_Geographic_Bee", "History_of_geography", "History_of_cartography", "Age_of_Discovery", "Age_of_Sail", "Ancient_geographers", "Cartography_in_the_Dutch_Republic", "Early_modern_Netherlandish_cartography", "Gazetteers", "Geographic_societies", "Historians_of_geography", "Historical_geography", "Historical_roads", "Ancient_Indian_geography", "Islamic_geography", "Medieval_geographers", "Russian_Geographical_Society", "Land_systems", "Landscape", "Landscape_architecture", "Land_art", "Landscape_art", "Cityscapes", "Cultural_landscapes", "Landscape_ecology", "Ecomuseums", "Geomorphology", "Landscape_history", "Horticulture_and_gardening", "Landforms", "Lawns", "Landscape_photography", "Sustainable_gardening", "Geography_organizations", "Cartography_organizations", "Geographic_data_and_information_organizations", "Demographics_organizations", "Geographic_information_systems_organizations", "International_environmental_organizations", "Schools_of_geography", "Geographic_societies", "Urban_planning_organizations", "Places", "Places_by_location", "Places_by_type", "Categories_by_location", "Lists_of_places", "Environments", "Places_in_folklore", "Former_places", "Hyperlocal_media", "Metaphors_referring_to_places", "Place_names", "Outer_space", "People_associated_with_places", "Places_in_popular_culture", "Submerged_places", "Geographic_position", "Geocodes", "Geographic_coordinate_systems", "Outdoor_locating_games", "Internet_geolocation", "Land_tenure", "Geomarketing", "Places", "Real_estate", "Location-based_software", "Geopositioning", "Vertical_position", "Geographical_regions", "Geographic_areas_of_seismological_interest", "Ecoregions", "Geographical_regions_of_Bulgaria", "Geographic_regions_of_Canada", "Geographical,_historical_and_cultural_regions_of_France", "Geographical,_historical_and_cultural_regions_of_Italy", "Geographical_regions_of_Kosovo", "Geographical_regions_of_Montenegro", "Geographical_regions_of_Serbia", "Geographic_regions_of_Ukraine", "Geographical_regions_of_Venezuela", "Geographical_superlatives", "Lists_of_extreme_points", "Extreme_points_of_Earth", "Geography-related_lists_of_superlatives", "Highest_points", "Highest_things", "Lowest_points", "Surveying", "Surveying_of_Australia", "Surveying_of_Canada", "Cave_surveying", "Geodetic_datums", "Geodetic_surveys", "Home_inspection", "Surveying_of_India", "Initial_points", "Land_surveying_of_the_United_States", "Land_surveying_systems", "Surveying_organizations", "Surveying_instruments", "Surveyors", "Topography", "Vertical_datums", "Geographical_technology", "Geographic_coordinate_systems", "Geographic_information_systems", "Global_Positioning_System", "Neogeography", "Remote_sensing", "Geography_terminology", "Geographic_taxonomies", "Geopolitical_terminology", "Geography_terminology_stubs", "Time_zones", "Tz_database", "Time_zones_in_the_United_States", "UTC_offsets", "Types_of_geographical_division", "Types_of_administrative_division", "Police_divisions", "Works_about_geography", "Geographic_literature", "Wikipedia_books_on_geography", "Wikis_about_geography", "Geographic_images", "Images_of_buildings_and_structures", "Images_of_cities", "Images_by_country", "Images_of_the_Geograph_British_Isles_project", "Wikipedia_images_of_maps", "Geography_stubs", "Geography_book_stubs", "Building_and_structure_stubs", "Fjord_stubs", "Glacier_stubs", "Island_stubs", "Lake_stubs", "Marine_geography_stubs", "Mountain_stubs", "Palaeogeography_stubs", "Protected_area_stubs", "River_stubs", "Road_stubs", "Geography_terminology_stubs", "Topography_stubs", "Waterfall_stubs", "Africa_geography_stubs", "Antarctica_geography_stubs", "Asia_geography_stubs", "Europe_geography_stubs", "North_America_geography_stubs", "Oceania_geography_stubs", "South_America_geography_stubs", "Area_studies_stubs", "Cartography_stubs", "Fictional_location_stubs", "Geography_stub_templates")
        ) AS c
    ON p.page_id = c.cl_from
    LEFT OUTER JOIN
        (SELECT *
        FROM
            langlinks
        WHERE ll_lang IN ("cs", "es")
        ) 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...
