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 ( "Artificial_intelligence", "Affective_computing", "Social_robots", "AI_accelerators", "Artificial_intelligence_applications", "Agent-based_software", "Applied_data_mining", "Applied_machine_learning", "Automated_planning_and_scheduling", "Computer_vision_software", "Deepfakes", "Expert_systems", "Face_recognition", "Free_artificial_intelligence_applications", "Handwriting_recognition", "Natural_language_processing", "Natural_language_processing_software", "Neural_network_software", "Optical_character_recognition", "Speech_recognition", "Voice_technology", "Argument_technology", "Argument_mapping", "Artificial_immune_systems", "Artificial_intelligence_associations", "Association_for_the_Advancement_of_Artificial_Intelligence", "Automated_reasoning", "Automated_theorem_proving", "Rule_engines", "Type_inference", "Chatbots", "Cloud_robotics", "Cognitive_architecture", "Computer_vision", "3D_imaging", "Applications_of_computer_vision", "Commercial_computer_vision_systems", "Computer_vision_research_infrastructure", "Datasets_in_computer_vision", "Digital_geometry", "Feature_detection_(computer_vision)", "Geometry_in_computer_vision", "Geometry_processing", "Image_noise_reduction_techniques", "Image_processing", "Image_segmentation", "Image_sensor_technology_in_computer_vision", "Learning_in_computer_vision", "Machine_vision", "Mathematical_morphology", "Motion_in_computer_vision", "Object_recognition_and_categorization", "Photogrammetry", "Computer_vision_researchers", "Computer_vision_software", "Artificial_intelligence_conferences", "Signal_processing_conferences", "Evolutionary_computation", "Artificial_life", "Digital_organisms", "Evolutionary_algorithms", "Interactive_evolutionary_computation", "Existential_risk_from_artificial_general_intelligence", "Artificial_intelligence_in_fiction", "Novels_about_artificial_intelligence", "Video_games_about_artificial_intelligence", "Comics_about_artificial_intelligence", "Android_(robot)_films", "Fictional_androids", "Androids_in_fiction", "Artificial_intelligence_characters_in_video_games", "Code_Lyoko", "Destination:_Void_universe", "Fictional_artificial_intelligences", "Films_about_artificial_intelligence", "Knight_Rider", "The_Matrix_(franchise)", "Fictional_robots", "Television_series_about_artificial_intelligence", "Terminator_(franchise)", "Tom_Clancy's_Net_Force", "Television_episodes_about_artificial_intelligence", "Fictional_artificial_intelligences", "Fictional_androids", "Fictional_gynoids", "Artificial_intelligence_characters_in_video_games", "Fictional_virtual_assistants", "Fuzzy_logic", "Predicate_logic", "Game_artificial_intelligence", "Card_game_video_games", "Computer_chess", "Computer_Go", "Computer_poker_players", "Computer_shogi", "Computer_draughts_players", "Go_software_(game)", "Human_versus_computer_matches", "Scrabble_software", "History_of_artificial_intelligence", "Human–computer_interaction", "Affective_computing", "Affective_haptics", "Ambient_intelligence", "Automatic_identification_and_data_capture", "Brain–computer_interfacing", "Computer_error_messages", "Computing_input_devices", "Ergonomics", "History_of_human–computer_interaction", "Human-based_computation", "Human–computer_interaction_journals", "Interactive_evolutionary_computation", "Interactivity", "Natural_language_and_computing", "Multimodal_interaction", "Human–computer_interaction_researchers", "Responsive_web_design", "Smart_bands", "Speech_recognition", "Ubiquitous_computing", "Usability", "User_interfaces", "Virtual_reality", "Voice_technology", "Wearable_devices", "Knowledge_engineering", "Knowledge_representation", "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", "Artificial_intelligence_laboratories", "Logic_programming", "Logic_programming_researchers", "Automated_theorem_proving", "Constraint_logic_programming", "Constraint_programming", "Inductive_logic_programming", "Logic_programming_languages", "Normal_forms_(logic)", "Substitution_(logic)", "Unification_(computer_science)", "Machine_learning", "Applied_machine_learning", "Artificial_neural_networks", "Bayesian_networks", "Classification_algorithms", "Cluster_analysis", "Computational_learning_theory", "Artificial_intelligence_conferences", "Signal_processing_conferences", "Data_mining_and_machine_learning_software", "Datasets_in_machine_learning", "Deep_learning", "Dimension_reduction", "Ensemble_learning", "Evolutionary_algorithms", "Genetic_programming", "Inductive_logic_programming", "Kernel_methods_for_machine_learning", "Latent_variable_models", "Learning_in_computer_vision", "Log-linear_models", "Loss_functions", "Machine_learning_algorithms", "Machine_learning_task", "Markov_models", "Ontology_learning_(computer_science)", "Reinforcement_learning", "Machine_learning_researchers", "Natural_language_processing_researchers", "Semisupervised_learning", "Statistical_natural_language_processing", "Structured_prediction", "Supervised_learning", "Support_vector_machines", "Unsupervised_learning", "Mind–body_problem", "Multi-agent_systems", "Agent-based_programming_languages", "Agent-based_software", "Agent-oriented_programming_languages", "Botnets", "Neural_network_data_exchange_formats", "Open-source_artificial_intelligence", "Free_artificial_intelligence_applications", "Philosophy_of_artificial_intelligence", "Singularitarianism", "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", "Natural_language_processing_researchers", "Speech_processing_researchers", "Robotics", "Robotics_by_company", "Robotics_by_country", "Robots", "History_of_robotics", "Adaptable_robotics", "Agricultural_robotics", "Robot_architectures", "Articulated_robotics", "BEAM_robotics", "Biorobotics", "Cloud_robotics", "Robotics_concepts", "Robot_control", "Cyborgs", "Entertainment_robotics", "Robotics_events", "Robotics_hardware", "Health_care_robotics", "Home_automation", "Industrial_robotics", "Robotics_journals", "Robotics_lists", "Machine_vision", "Robotic_manipulation", "Medical_robotics", "Military_robotics", "Multi-robot_systems", "Robotics_organizations", "Physical_computing", "Robotics_projects", "Robotic_art", "Roboticists", "Robotics_software", "Uncanny_valley", "Works_about_robotics", "Robotics_stubs", "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", "Self-driving_cars", "Service_robots", "Sex_robots", "Social_robots", "Robot_sports", "Sports_robots", "Telepresence_robots", "Robotic_telescopes", "Unmanned_vehicles", "Works_about_robots", "Rule_engines", "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 IN ("en", "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
.
Checking query status...