Untitled query #50730

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 (
"Artificial_intelligence", "Affective_computing", "Social_robots", "AI_accelerators", "Artificial_intelligence_applications", "Agent-based_software", "Financial_markets_software", "Virtual_assistants", "Applied_data_mining", "Applied_machine_learning", "AlphaGo", "Automated_planning_and_scheduling", "Scheduling_(computing)", "Computer_vision_software", "Image_processing_software", "Photogrammetry_software", "Deepfakes", "Expert_systems", "Medical_expert_systems", "Face_recognition", "Facial_expressions", "Facial_recognition_software", "Free_artificial_intelligence_applications", "Handwriting_recognition", "Natural_language_processing", "Corpus_linguistics", "Finite_automata", "Machine_translation", "Natural_language_generation", "Natural_language_processing_software", "Optical_character_recognition", "Statistical_natural_language_processing", "Tasks_of_natural_language_processing", "Natural_language_processing_software", "Chatbots", "Machine_translation_software", "Natural_language_processing_toolkits", "Neural_network_software", "Optical_character_recognition", "Automatic_number_plate_recognition", "Music_OCR_software", "OCR_typefaces", "Speech_recognition", "Devices_capable_of_speech_recognition", "Language_modeling", "Speech_recognition_hardware", "Speech_recognition_software", "Voice_technology", "Anti-stuttering_devices", "Psychoacoustics", "Speaker_recognition", "Speech_codecs", "Speech_processing", "Speech_recognition", "Speech_synthesis", "Argument_technology", "Argument_mapping", "Argument_maps", "Artificial_immune_systems", "Artificial_intelligence_associations", "Association_for_the_Advancement_of_Artificial_Intelligence", "Fellows_of_the_Association_for_the_Advancement_of_Artificial_Intelligence", "Presidents_of_the_Association_for_the_Advancement_of_Artificial_Intelligence", "Automated_reasoning", "Automated_theorem_proving", "Satisfiability_problems", "Theorem_proving_software_systems", "Unification_(computer_science)", "Rule_engines", "Expert_systems", "Type_inference", "Unification_(computer_science)", "Chatbots", "Cloud_robotics", "Cognitive_architecture", "Computer_vision", "3D_imaging", "3D_computer_graphics", "3D_films", "Graphical_projections", "Holography", "Mobile_phones_with_stereo_camera", "3D_scanners", "Stereoscopy", "Applications_of_computer_vision", "Animal_identification", "Augmented_reality", "Deepfakes", "Face_recognition", "Gesture_recognition", "Handwriting_recognition", "Image_search", "Machine_vision", "Optical_character_recognition", "Remote_sensing", "Robot_navigation", "Robots", "Self-driving_cars", "Commercial_computer_vision_systems", "Computer_vision_research_infrastructure", "Datasets_in_computer_vision", "Datasets_in_computer_vision", "Digital_geometry", "Digital_topology", "Feature_detection_(computer_vision)", "Geometry_in_computer_vision", "Stereophotogrammetry", "Geometry_processing", "Image_noise_reduction_techniques", "Image_processing", "3D_computer_graphics", "3D_imaging", "Color", "Computer_graphic_artifacts", "Digital_photography", "Feature_detection_(computer_vision)", "Graphics_file_formats", "Image_compression", "Image_noise_reduction_techniques", "Image_processing_software", "Image_processors", "Image_segmentation", "Interpolation", "Mathematical_morphology", "Medical_imaging", "Sony_image_processing", "Stereophotogrammetry", "Wavelets", "Image_segmentation", "Image_sensor_technology_in_computer_vision", "Learning_in_computer_vision", "Machine_vision", "Mathematical_morphology", "Motion_in_computer_vision", "Motion_capture", "Object_recognition_and_categorization", "Photogrammetry", "Aerial_photography", "Photogrammetry_journals", "Photogrammetry_organizations", "Photogrammetrists", "Photogrammetry_software", "Stereophotogrammetry", "Computer_vision_researchers", "Fellows_of_the_International_Association_for_Pattern_Recognition", "Computer_vision_software", "Image_processing_software", "Photogrammetry_software", "Artificial_intelligence_conferences", "Signal_processing_conferences", "Evolutionary_computation", "Artificial_life", "Artificial_life_in_fiction", "Digital_organisms", "Emergence", "Artificial_life_models", "Researchers_of_artificial_life", "Self-replication", "Artificial_trees", "Virtual_babies", "Virtual_pets", "Digital_organisms", "Evolutionary_algorithms", "Evolutionary_algorithms", "Gene_expression_programming", "Genetic_algorithms", "Genetic_programming", "Nature-inspired_metaheuristics", "Interactive_evolutionary_computation", "Existential_risk_from_artificial_general_intelligence", "Artificial_intelligence_in_fiction", "Novels_about_artificial_intelligence", "Novels_about_robots", "Video_games_about_artificial_intelligence", "Video_games_about_robots", "Rise_of_the_Robots", "Comics_about_artificial_intelligence", "Robot_comics", "Android_(robot)_films", "Terminator_(franchise)_films", "Fictional_androids", "Cylons", "Fictional_gynoids", "Androids_in_fiction", "Android_(robot)_comics", "Android_(robot)_films", "Android_(robot)_video_games", "Androids_in_literature", "Androids_in_television", "Blade_Runner_(franchise)", "Fictional_androids", "Artificial_intelligence_characters_in_video_games", "Robot_characters_in_video_games", "Code_Lyoko", "Code_Lyoko_images", "Destination:_Void_universe", "Fictional_artificial_intelligences", "Fictional_androids", "Fictional_gynoids", "Artificial_intelligence_characters_in_video_games", "Fictional_virtual_assistants", "Films_about_artificial_intelligence", "Android_(robot)_films", "Knight_Rider_films", "The_Matrix_(franchise)_films", "Knight_Rider", "Knight_Rider_characters", "Knight_Rider_episodes", "Knight_Rider_films", "Knight_Rider_(1982_TV_series)_seasons", "Knight_Rider_television_series", "Knight_Rider_video_games", "The_Matrix_(franchise)", "The_Matrix_(franchise)_characters", "The_Matrix_(franchise)_films", "The_Matrix_(franchise)_music", "The_Matrix_(franchise)_video_games", "Fictional_robots", "DC_Comics_robots", "Fictional_robotic_dinosaurs", "Fictional_robotic_dogs", "Fictional_mecha", "Gobots", "Fictional_humanoid_robots", "Marvel_Comics_robots", "Robotic_dragons", "Robot_superheroes", "Robot_supervillains", "Star_Wars_droid_characters", "Robot_characters_in_video_games", "Television_series_about_artificial_intelligence", "Terminator_(franchise)", "Terminator_(franchise)_characters", "Terminator_(franchise)_comics", "Terminator_(franchise)_films", "Terminator_(franchise)_images", "Terminator:_The_Sarah_Connor_Chronicles", "Terminator_(franchise)_video_games", "Tom_Clancy's_Net_Force", "Television_episodes_about_artificial_intelligence", "Television_episodes_about_robots", "Fictional_artificial_intelligences", "Fictional_androids", "Cylons", "Fictional_gynoids", "Fictional_gynoids", "Music_videos_featuring_gynoids", "Artificial_intelligence_characters_in_video_games", "Robot_characters_in_video_games", "Fictional_virtual_assistants", "Fuzzy_logic", "Predicate_logic", "Mathematical_relations", "Quantification_(science)", "Game_artificial_intelligence", "Card_game_video_games", "Card_battle_video_games", "Poker_video_games", "Computer_chess", "Chess_computers", "Chess_software", "Computer_chess_competitions", "Internet_chess_servers", "Computer_chess_people", "Computer_Go", "AlphaGo", "Go_software_(game)", "Computer_poker_players", "Computer_shogi", "Internet_shogi_servers", "Shogi_software", "Computer_draughts_players", "Go_software_(game)", "AlphaGo", "Human_versus_computer_matches", "Scrabble_software", "History_of_artificial_intelligence", "Human–computer_interaction", "Affective_computing", "Social_robots", "Affective_haptics", "Ambient_intelligence", "Internet_of_things", "Smart_bands", "Wearable_devices", "Automatic_identification_and_data_capture", "Biometrics", "Indoor_positioning_system", "Mass_digitization", "Radio_direction_finding", "Radio-frequency_identification", "Radio-frequency_identification_companies", "Brain–computer_interfacing", "Brain–computer_interfacing_in_fiction", "Computer_error_messages", "Computing_input_devices", "Computer_keyboards", "Haptic_technology", "Image_scanners", "Input/output_integrated_circuits", "IPad_styluses", "Joysticks", "Pointing_devices", "Pointing-device_text_input", "Surface_computing", "Touchscreens", "Video_game_controllers", "Videotelephony", "Webcams", "Ergonomics", "Accessibility", "Adapted_automobiles", "Anthropometry", "Cognitive_ergonomics", "Ergonomics_companies", "Organizational_ergonomics", "Physical_ergonomics", "Posture", "Usability", "History_of_human–computer_interaction", "Gesture_recognition", "Human-based_computation", "Human-based_computation_games", "Social_search", "Human–computer_interaction_journals", "Interactive_evolutionary_computation", "Natural_language_and_computing", "Computing_by_natural_language", "Computational_linguistics", "Character_encoding", "Input_methods", "Internationalization_and_localization", "Computer_jargon", "Language-specific_Linux_distributions", "Natural_language_processing", "Non-English-based_programming_languages", "Language_software", "Computer-assisted_translation", "Machine_translation", "Multimodal_interaction", "Haptic_technology", "Human–computer_interaction_researchers", "Human-Computer_Interaction_Institute_faculty", "Jef_Raskin", "Responsive_web_design", "Smart_bands", "Speech_recognition", "Devices_capable_of_speech_recognition", "Language_modeling", "Speech_recognition_hardware", "Speech_recognition_software", "Ubiquitous_computing", "Ambient_intelligence", "Indoor_positioning_system", "Ubiquitous_computing_researchers", "Smart_bands", "Tracking", "Wearable_computers", "Wearable_devices", "Usability", "Adaptive_Web_Design", "Responsive_web_design", "Usability_inspection", "User_interfaces", "Computer_accessibility", "Adaptive_Web_Design", "Computing_output_devices", "Interface_designers", "Graphical_user_interfaces", "Haptic_technology", "Hypertext", "Physical_computing", "Responsive_web_design", "Terminal_emulators", "Computer_terminals", "Text_mode", "Text_user_interface", "User_interface_techniques", "Zoomable_user_interfaces", "Virtual_reality", "Haptic_technology", "Virtual_reality_headsets", "Holography", "Mixed_reality", "Virtual_reality_organizations", "Virtual_reality_pioneers", "Psychoacoustics", "Ray_tracing_(graphics)", "Virtual_avatars", "Virtual_economy", "Virtual_reality_communities", "Virtual_reality_games", "Virtual_reality_in_fiction", "Virtual_reality_works", "Voice_technology", "Anti-stuttering_devices", "Psychoacoustics", "Speaker_recognition", "Speech_codecs", "Speech_processing", "Speech_recognition", "Speech_synthesis", "Wearable_devices", "Wearable_computers", "Knowledge_engineering", "Knowledge_representation", "Argument_mapping", "Belief_revision", "Dewey_Decimal_Classification", "Grouping", "Knowledge_bases", "Knowledge_representation_languages", "Knowledge_representation_software", "Lexical_databases", "Library_of_Congress_Classification", "Microformats", "Minimum_Information_Standards", "Multi-agent_systems", "Ontology_(information_science)", "Semantic_desktop", "Semantic_Web", "Thesauri", "Knowledge_representation", "Argument_mapping", "Argument_maps", "Belief_revision", "Cognitive_inertia", "Dewey_Decimal_Classification", "Grouping", "Articles_about_multiple_people", "Christian_denominational_families", "Groups_of_Egyptian_deities", "Functional_groups", "Galaxy_clusters", "Groups_(military_aviation)", "Human_haplogroups", "Lake_groups", "Language_families", "Lists_of_groups_with_specific_numbers_of_members", "Minor_planet_groups_and_families", "Operating_system_families", "Parliamentary_groups", "Group_portraits", "Programming_language_families", "Satellite_groups", "Sequences_and_series", "Stellar_groupings", "Taxonomy", "Knowledge_bases", "Knowledge_graphs", "Knowledge_representation_languages", "Domain-specific_knowledge_representation_languages", "Ontology_languages", "Resource_Description_Framework", "Knowledge_representation_software", "Concept_mapping_software", "Mind-mapping_software", "Ontology_editors", "Rule_engines", "Lexical_databases", "Scrabble_lexica", "Library_of_Congress_Classification", "Microformats", "Minimum_Information_Standards", "Multi-agent_systems", "Agent-based_programming_languages", "Agent-based_software", "Agent-oriented_programming_languages", "Botnets", "Ontology_(information_science)", "Ontology_editors", "Ontology_languages", "Ontology_learning_(computer_science)", "Semantic_desktop", "Semantic_Web", "Semantic_Web_companies", "Domain-specific_knowledge_representation_languages", "Folksonomy", "Knowledge_bases", "Microformats", "Semantic_Web_people", "Resource_Description_Framework", "Semantic_HTML", "Semantic_wikis", "Triplestores", "Thesauri", "Artificial_intelligence_laboratories", "Logic_programming", "Logic_programming_researchers", "Automated_theorem_proving", "Satisfiability_problems", "Theorem_proving_software_systems", "Unification_(computer_science)", "Constraint_logic_programming", "Constraint_programming", "Constraint_logic_programming", "Constraint_programming_languages", "Inductive_logic_programming", "Logic_programming_languages", "Functional_logic_programming_languages", "Prolog_programming_language_family", "Normal_forms_(logic)", "Substitution_(logic)", "Unification_(computer_science)", "Substitution_(logic)", "Machine_learning", "Applied_machine_learning", "AlphaGo", "Artificial_neural_networks", "Deep_learning", "Neural_network_software", "Bayesian_networks", "Classification_algorithms", "Artificial_neural_networks", "Decision_trees", "Ensemble_learning", "Cluster_analysis", "Cluster_analysis_algorithms", "Clustering_criteria", "Computational_learning_theory", "Artificial_intelligence_conferences", "Signal_processing_conferences", "Data_mining_and_machine_learning_software", "Social_network_analysis_software", "Datasets_in_machine_learning", "Datasets_in_computer_vision", "Deep_learning", "Deepfakes", "Dimension_reduction", "Factor_analysis", "Ensemble_learning", "Evolutionary_algorithms", "Gene_expression_programming", "Genetic_algorithms", "Genetic_programming", "Nature-inspired_metaheuristics", "Genetic_programming", "Inductive_logic_programming", "Kernel_methods_for_machine_learning", "Support_vector_machines", "Latent_variable_models", "Factor_analysis", "Structural_equation_models", "Learning_in_computer_vision", "Log-linear_models", "Loss_functions", "Machine_learning_algorithms", "Genetic_algorithms", "Machine_learning_task", "Markov_models", "Hidden_Markov_models", "Markov_networks", "Ontology_learning_(computer_science)", "Reinforcement_learning", "Machine_learning_researchers", "Semisupervised_learning", "Statistical_natural_language_processing", "Language_modeling", "Structured_prediction", "Graphical_models", "Supervised_learning", "Support_vector_machines", "Unsupervised_learning", "Mind–body_problem", "Multi-agent_systems", "Agent-based_programming_languages", "Agent-based_software", "Financial_markets_software", "Virtual_assistants", "Agent-oriented_programming_languages", "Botnets", "Computer_security_companies_specializing_in_botnets", "Neural_network_data_exchange_formats", "Open-source_artificial_intelligence", "Free_artificial_intelligence_applications", "Philosophy_of_artificial_intelligence", "Singularitarianism", "Singularitarians", "Uncanny_valley", "Artificial_intelligence_publications", "Artificial_intelligence_researchers", "Artificial_intelligence_ethicists", "Fellows_of_the_Association_for_the_Advancement_of_Artificial_Intelligence", "Fellows_of_the_European_Association_for_Artificial_Intelligence", "Fellows_of_the_SSAISB", "Logic_programming_researchers", "Machine_learning_researchers", "Speech_processing_researchers", "Robotics", "Robotics_by_company", "Robotics_at_Boston_Dynamics", "Robotics_at_Fujitsu", "Robotics_at_Honda", "Robotics_at_Kawasaki", "Robotics_at_KUKA", "Robotics_at_ROBOTIS", "Robotics_at_Seiko_Epson", "Robotics_at_Sony", "Robotics_at_TOSY", "Robotics_at_Unimation", "Robotics_by_country", "Robots_by_country", "Roboticists_by_nationality", "Robotics_in_Australia", "Robotics_in_China", "Robotics_in_Estonia", "Robotics_in_France", "Robotics_in_Germany", "Robotics_in_India", "Industrial_robotics_by_country", "Robotics_in_Iran", "Robotics_in_Japan", "Robotics_in_the_Netherlands", "Robotics_in_Pakistan", "Robotics_in_Sweden", "Robotics_in_the_United_Kingdom", "Robotics_in_the_United_States", "Robots", "Robots_in_fiction", "Robots_by_country", "Robots_by_date", "Robots_by_environment", "Robots_by_fuel", "Android_(robot)", "Automata_(mechanical)", "Autonomous_ships", "Ecological_robots", "Educational_robots", "Entertainment_robots", "Handling_robots", "Historical_robots", "Hobbyist_robots", "Individual_robots", "Industrial_robots", "Medical_robots", "Micro_robots", "Military_robots", "Online_robots", "Open-source_robots", "Robot_parts", "Personal_assistant_robots", "Prototype_robots", "Rescue_and_protection_robots", "Robotic_exoskeletons", "Self-driving_cars", "Service_robots", "Sex_robots", "Social_robots", "Robot_sports", "Sports_robots", "Telepresence_robots", "Robotic_telescopes", "Unmanned_vehicles", "Works_about_robots", "History_of_robotics", "Robotics_by_century", "Robotics_by_decade", "Robotics_by_year", "Historical_robots", "Adaptable_robotics", "Robot_kits", "Agricultural_robotics", "Robot_architectures", "Articulated_robotics", "BEAM_robotics", "Biorobotics", "Robotic_animals", "Biorobotics_in_fiction", "Flower_robots", "Humanoid_robots", "Cloud_robotics", "Robotics_concepts", "Self-replication", "Robot_control", "Automated_planning_and_scheduling", "Robot_kinematics", "Robot_locomotion", "Robot_navigation", "Robotic_sensing", "Wireless_robotics", "Cyborgs", "Cyborgs_in_fiction", "Entertainment_robotics", "Entertainment_robots", "Animatronics", "Robotics_events", "Robotics_competitions", "Robotics_hardware", "3D_printers", "Health_care_robotics", "Bionics", "Medical_robotics", "Medical_robots", "Home_automation", "Domestic_robots", "Garage_door_openers", "Home_automation_companies", "Smart_devices", "Smart_home_hubs", "Temperature_control", "Industrial_robotics", "Industrial_robots", "Industrial_robotics_by_country", "3D_printing", "CNC", "Industrial_robotics_companies", "Deaths_caused_by_industrial_robots", "Robotics_lists", "Lists_of_fictional_robots", "Machine_vision", "Robotic_manipulation", "Handling_robots", "Robotic_manipulators", "Medical_robotics", "Medical_robots", "Computer-assisted_surgery", "Military_robotics", "Military_robots", "Multi-robot_systems", "Robotics_organizations", "Robotics_companies", "Physical_computing", "Robotics_projects", "Robots", "Robotic_art", "Monochrom", "Robot_musicians", "Roboticists", "Roboticists_by_nationality", "3D_printing_specialists", "Animatronic_engineers", "Fictional_roboticists", "Robotics_software", "Robot_operating_systems", "Robot_programming_languages", "Robotics_suites", "Video_games_about_robots", "Uncanny_valley", "Works_about_robotics", "Works_about_robots", "Robotics_books", "Robotics_magazines", "Robotics_stubs", "Robots", "Robots_in_fiction", "Robots_in_television", "Robot_comics", "Robot_films", "Robots_in_literature", "Fictional_robots", "Androids_in_fiction", "Robot_animation", "Biorobotics_in_fiction", "Drones_in_fiction", "Fictional_roboticists", "Mecha", "Powered_exoskeletons_in_fiction", "Self-replicating_machines_in_fiction", "Songs_about_robots", "Star_Wars", "Transformers_(franchise)", "Video_games_about_robots", "Robots_by_country", "Space_probes_by_country", "Robots_of_Australia", "Robots_of_Austria", "Robots_of_Brazil", "Robots_of_Canada", "Robots_of_Chile", "Robots_of_China", "Robots_of_Croatia", "Robots_of_France", "Robots_of_Germany", "Robots_of_Hungary", "Robots_of_India", "Robots_of_Iran", "Robots_of_Israel", "Robots_of_Italy", "Robots_of_Japan", "Robots_of_Malaysia", "Robots_of_Mexico", "Robots_of_the_Netherlands", "Robots_of_New_Zealand", "Robots_of_Pakistan", "Robots_of_Portugal", "Robots_of_Russia", "Robots_of_Saudi_Arabia", "Robots_of_Singapore", "Robots_of_South_Korea", "Robots_of_the_Soviet_Union", "Robots_of_Spain", "Robots_of_Sweden", "Robots_of_Switzerland", "Robots_of_the_United_Arab_Emirates", "Robots_of_the_United_Kingdom", "Robots_of_the_United_States", "Robots_of_Vietnam", "Robots_of_Yemen", "Robots_by_date", "Robots_by_century", "Robots_by_decade", "Robots_by_year", "Robots_by_environment", "Aerobots", "Land_robots", "Space_robots", "Underwater_robots", "Robots_by_fuel", "Nuclear-powered_robots", "Solar-powered_robots", "Android_(robot)", "Androids", "Androids_in_fiction", "Uncanny_valley", "Automata_(mechanical)", "Automata_in_Greek_Mythology", "Chess_automatons", "Autonomous_ships", "Ecological_robots", "Educational_robots", "Robot_kits", "Entertainment_robots", "Animatronic_robots", "Robot_musicians", "Toy_robots", "Handling_robots", "Robot_hands", "Laboratory_robots", "Robotic_manipulators", "Historical_robots", "Hobbyist_robots", "Robot_kits", "Individual_robots", "Flower_robots", "Humanoid_robots", "Individual_mecha", "Robotic_animals", "Fictional_robots", "Industrial_robots", "Medical_robots", "Diagnostic_robots", "Disability_robots", "Rehabilitation_robots", "Surgical_robots", "Therapeutic_robots", "Micro_robots", "Micro_air_vehicles", "Military_robots", "Airborne_military_robots", "Bomb_disposal_robots", "IRobot", "Unmanned_ground_combat_vehicles", "Online_robots", "Open-source_robots", "Lego_Mindstorms", "Robot_parts", "Robot_hands", "Robot_heads", "Robot_legs", "Personal_assistant_robots", "Prototype_robots", "Rescue_and_protection_robots", "Robotic_exoskeletons", "Powered_exoskeletons_in_fiction", "Self-driving_cars", "DARPA_Grand_Challenge", "Service_robots", "Domestic_robots", "Sex_robots", "Social_robots", "Robot_sports", "Robotics_competitions", "Sports_robots", "Robot_combat", "Robot_football", "Sports_robots", "Chess_automatons", "Combat_robots", "Soccer_robots", "Telepresence_robots", "Robotic_telescopes", "Wide_Angle_Search_for_Planets", "Unmanned_vehicles", "Missile_guidance", "Radio_control", "Uncrewed_spacecraft", "Unmanned_aerial_vehicles", "Unmanned_ground_vehicles", "Unmanned_watercraft", "Works_about_robots", "Robot_comics", "Documentary_films_about_robots", "Robot_films", "Robot_games", "Short_stories_about_robots", "Robot_animation", "Songs_about_robots", "Video_games_about_robots", "Rule_engines", "Expert_systems", "Medical_expert_systems", "Turing_tests", "Chatbots", "Uncanny_valley", "Virtual_assistants", "Amazon_Alexa", "Fictional_virtual_assistants", "Artificial_intelligence_stubs")   
        ) AS c 
    ON p.page_id = c.cl_from 
    LEFT OUTER JOIN 
        (SELECT * 
        FROM 
	    langlinks 
        WHERE ll_lang = "cs"
        ) 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...
