Untitled query #53106

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 (
"Mathematics", "Fields_of_mathematics", "Algebra", "Mathematical_analysis", "Applied_mathematics", "Arithmetic", "Combinatorics", "Computational_mathematics", "Discrete_mathematics", "Dynamical_systems", "Elementary_mathematics", "Experimental_mathematics", "Foundations_of_mathematics", "Game_theory", "Geometry", "Graph_theory", "Mathematical_logic", "Mathematics_of_infinitesimals", "Number_theory", "Order_theory", "Probability_and_statistics", "Recreational_mathematics", "Topology", "Mathematics-related_lists", "Lists_of_mathematics_lists", "Cryptography_lists_and_comparisons", "Glossaries_of_mathematics", "Lists_of_integrals", "Lists_of_mathematicians", "Lists_of_things_named_after_mathematicians", "Lists_of_problems", "Lists_of_shapes", "Statistics-related_lists", "Mathematicians", "Mathematicians_by_award", "Mathematicians_by_century", "Mathematicians_by_city", "Mathematicians_by_field", "Mathematicians_by_nationality", "Lists_of_mathematicians", "Women_mathematicians", "African_mathematicians", "Amateur_mathematicians", "Ancient_mathematicians", "Cultural_depictions_of_mathematicians", "Fellows_of_the_American_Mathematical_Society", "Fictional_mathematicians", "Lists_of_things_named_after_mathematicians", "Mathematicians_involved_with_Mathematische_Annalen", "Medieval_mathematicians", "Mental_calculators", "Pseudonymous_mathematicians", "Second_Wranglers", "Senior_Wranglers", "Wikipedia_categories_named_after_mathematicians", "Mathematician_stubs", "Mathematics_and_art", "Algorithmic_art", "Fractal_artists", "Mathematical_artists", "Mathematical_artworks", "Tessellation", "Mathematical_classification_systems", "Mathematical_concepts", "Mathematical_axioms", "Basic_concepts_in_set_theory", "Mathematical_objects", "Mathematical_principles", "Quantity", "Mathematical_relations", "Mathematical_structures", "Mathematical_constants", "0_(number)", "1_(number)", "E_(mathematical_constant)", "Golden_ratio", "Pi", "Control_theory", "Control_theorists", "Resonance", "Classical_control_theory", "Control_engineering", "Control_theory_publications", "Feedback", "Filter_theory", "Motion_control", "Nonlinear_control", "Optimal_control", "Richard_E._Bellman_Control_Heritage_Award_recipients", "Servomechanisms", "Stability_theory", "Stochastic_control", "Transfer_functions", "Variational_analysis", "Cultural_depictions_of_mathematicians", "Cultural_depictions_of_Archimedes", "Cultural_depictions_of_Aristotle", "Cultural_depictions_of_Giordano_Bruno", "Cultural_depictions_of_Nicolaus_Copernicus", "Cultural_depictions_of_Albert_Einstein", "Cultural_depictions_of_Galileo_Galilei", "Cultural_depictions_of_Stephen_Hawking", "Cultural_depictions_of_Hypatia", "Cultural_depictions_of_Johannes_Kepler", "Cultural_depictions_of_Isaac_Newton", "Cultural_depictions_of_Pythagoras", "Cultural_depictions_of_Alan_Turing", "Mathematics_and_culture", "Mathematics_by_culture", "Mathematics_and_art", "Mathematics_awards", "Mathematics_books", "Mathematics_competitions", "Mathematics_conferences", "Documentary_television_series_about_mathematics", "Mathematics_education", "Ethnomathematicians", "Fermat's_Last_Theorem", "Mathematical_humor", "Mathematics_and_mysticism", "Mathematics_of_music", "Mathematics-related_topics_in_popular_culture", "Mathematics_organizations", "Mathematical_problems", "Recreational_mathematics", "Mathematics_education_television_series", "Works_about_mathematics", "Mathematical_examples", "History_of_mathematics", "Mathematics_by_culture", "Mathematics_by_period", "Academic_works_about_mathematics", "History_of_algebra", "History_of_calculus", "History_of_computer_science", "History_of_geometry", "Hilbert's_problems", "Historians_of_mathematics", "Historical_treatment_of_quaternions", "Historiography_of_mathematics", "History_of_logic", "Mathematical_problems", "History_of_probability_and_statistics", "Mathematics_timelines", "Works_about_the_history_of_mathematics", "Mathematics_in_Germany", "Mathematical_notation", "Coordinate_systems", "Mathematical_markup_languages", "Mathematical_symbols", "Numeral_systems", "Mathematical_typefaces", "Z_notation", "Mathematical_science_occupations", "Mathematicians", "Mathematics_educators", "Mathematical_cognition_researchers", "Mathematics_education", "Philosophy_of_mathematics", "Ancient_Greek_philosophy_of_mathematics", "Concepts_in_the_philosophy_of_mathematics", "Formalism_(deductive)", "Infinity", "Mathematical_logic", "Mathematical_objects", "Mathematics_and_mysticism", "Mathematical_paradoxes", "Philosophers_of_mathematics", "Philosophy_of_computer_science", "Philosophy_of_mathematics_literature", "Philosophy_of_statistics", "Structuralism_(philosophy_of_mathematics)", "Theories_of_deduction", "Validity_(statistics)", "Mathematical_projects", "Mathematical_proofs", "Article_proofs", "Articles_containing_proofs", "Automated_theorem_proving", "Computer-assisted_proofs", "Invalid_proofs", "Proof_techniques", "Proof_theory", "Proof_without_words", "Pseudomathematics", "Numerology", "Pseudophysics", "Set_indices_on_mathematics", "Mathematical_terminology", "Formal_methods_terminology", "Mathematical_theorems", "Lemmas", "Inequalities", "Mathematical_identities", "Theorems_in_algebra", "Theorems_in_analysis", "Conjectures_that_have_been_proved", "Theorems_in_discrete_mathematics", "Theorems_in_dynamical_systems", "Theorems_in_the_foundations_of_mathematics", "Theorems_in_geometry", "Theorems_in_mathematical_physics", "Theorems_in_number_theory", "Probability_theorems", "Theorems_in_propositional_logic", "Theorems_in_statistics", "Theorems_in_topology", "Mathematical_theorems_in_theoretical_computer_science", "Uniqueness_theorems", "Mathematical_tools", "Calculators", "Mathematical_markup_languages", "Mathematical_software", "Mathematical_tables", "Women_in_mathematics", "Association_for_Women_in_Mathematics", "Fellows_of_the_Association_for_Women_in_Mathematics", "Women_mathematicians", "Wikipedia_books_on_mathematics", "Wikipedia_books_on_logic", "Mathematics_stubs", "Cryptography_stubs", "Mathematics_literature_stubs", "Mathematician_stubs", "Algebra_stubs", "Mathematical_analysis_stubs", "Applied_mathematics_stubs", "Category_theory_stubs", "Combinatorics_stubs", "Mathematics_competition_stubs", "Geometry_stubs", "Mathematics_journal_stubs", "Mathematical_logic_stubs", "Number_theory_stubs", "Number_stubs", "Probability_stubs", "Statistics_stubs", "Topology_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.
SQL

Checking query status...
