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 ( "Linguistics", "Linguistics_lists", "Lists_of_language_lists", "Lists_by_language", "Lists_of_languages", "Lists_of_abbreviations", "Lists_of_country_names", "Lists_of_etymologies", "Linguistic_example_sentences", "Lists_of_phrases", "Slogan_lists", "Sociolinguistics_lists", "Swadesh_lists", "Translation-related_lists", "Word_lists", "Lists_of_words", "Branches_of_linguistics", "Anthropological_linguistics", "Applied_linguistics", "Cognitive_linguistics", "Computational_linguistics", "Corpus_linguistics", "Historical_linguistics", "Language_geography", "Lexicology", "Linguistic_morphology", "Neurolinguistics", "Philosophy_of_language", "Phonetics", "Phonology", "Phraseology", "Pragmatics", "Psycholinguistics", "Quantitative_linguistics", "Semantics", "Semantics_(linguistics)", "Sociolinguistics", "Syntax", "Linguistic_typology", "Linguists", "Grammarians_by_nationality", "Linguists_by_ethnicity", "Medieval_linguists", "Ancient_linguists", "Linguists_by_century", "Linguists_by_field_of_research", "Linguists_by_nationality", "Applied_linguists", "Amateur_linguists", "Fellows_of_the_Chartered_Institute_of_Linguists", "Fellows_of_the_Linguistic_Society_of_America", "Fictional_linguists", "Indigenous_linguists", "Missionary_linguists", "People_of_the_Prague_linguistic_circle", "Recipients_of_the_Neil_and_Saras_Smith_Medal_for_Linguistics", "Women_linguists", "Linguistics_writers", "Linguist_stubs", "Wikipedia_categories_named_after_linguists", "Language_classification", "Classification_of_African_languages", "Conditionals_in_linguistics", "Natural_language_conditionals", "Constructed_languages", "Artistic_languages", "Comparison_of_constructed_languages", "Constructed_language_creators", "Constructed_languages_resources", "Constructed_scripts", "Controlled_natural_languages", "Constructed_languages_by_decade_of_introduction", "Engineered_languages", "Formal_languages", "Gibberish_language", "Grammars_of_constructed_languages", "Interlinguistics", "International_auxiliary_languages", "Language_games", "Musical_languages", "Constructed_language_organizations", "Constructed_language_speakers", "Volapük", "Zonal_constructed_languages", "Constructed_language_stubs", "Linguistics_databases", "Cross-Linguistic_Linked_Data", "Lexical_databases", "Discourse_analysis", "Books_about_discourse_analysis", "Corpus_linguistics", "Political_linguistics", "Systemic_functional_linguistics", "Linguistics_events", "Linguistics_conferences", "Linguistics_olympiads", "Grammar", "Grammars_of_specific_languages", "Formal_languages", "Grammar_frameworks", "Grammar_books", "Grammatical_categories", "Linguistic_morphology", "Punctuation", "Reduplication", "Semantics", "Semantics_(linguistics)", "Syntax", "Grammar_stubs", "History_of_linguistics", "Ancient_linguists", "Arab_grammarians", "Berber_grammarians", "Linguistic_turn", "Medieval_linguists", "Vyakarana", "Language_contact", "Code-switching", "Interlinguistics", "Linguistic_strata", "Lists_of_loanwords", "Macaronic_language", "Mixed_languages", "Pidgins_and_creoles", "Language_documentation", "Language_games", "Word_games", "Word_play", "Languages", "Lists_by_language", "Lists_of_languages", "Categories_by_language", "Constructed_languages", "Languages_by_geographical_region", "Language_naming", "Languages_by_origin", "Languages_by_script", "Sign_languages", "Languages_by_place_in_society", "Spurious_languages", "Languages_by_time", "Languages_by_typology", "Whistled_languages", "Language_stubs", "Wikipedia_categories_named_after_languages", "Linguistic_controversies", "Signatories_of_the_Declaration_on_the_Common_Language", "Definitions", "Disputes_in_English_grammar", "English-only_movement_in_the_United_States", "Language_conflict_in_India", "Linguistic_discrimination", "Controversy_over_linguistic_and_ethnic_identity_in_Moldova", "Naming_controversies", "Language_conflict_in_Pakistan", "Linguistic_error", "Nonstandard_spelling", "Speech_error", "Linguistic_modality", "Grammatical_moods", "Linguistics_projects", "Linguistic_research", "Linguistics_databases", "Linguistics_works", "Academic_works_about_linguistics", "Linguistic_maps", "Works_about_translation", "Linguistics_websites", "Onomastics", "Country_names", "Ethnonyms", "Exonyms", "Hypocorisms", "Language_naming", "Names", "Onomasticon", "Theophoric_names", "Toponymy", "Linguistics_organizations", "Endangered_languages_projects", "Language_advocacy_organizations", "Language_regulators", "Linguistics_conferences", "Linguistic_research_institutes", "Linguistic_societies", "Translation_organizations", "Linguistics_organization_stubs", "Orthography", "Language_orthographies", "Capitalization", "Collation", "Diacritics", "Grammatology", "Graphemes", "Letters_with_final_form", "Multigraphs_(orthography)", "Multilingual_orthographies", "Orthographers", "Orthography_reform", "Punctuation", "Spelling", "Pseudolinguistics", "Linguistic_hoaxes", "Neuro-linguistic_programming", "Linguistic_research", "Corpus_linguistics", "Linguistics_educators", "Linguistic_research_in_India", "Linguistic_theories_and_hypotheses", "Methods_in_linguistics", "Language_regulators", "Linguistic_research_institutes", "Unsolved_problems_in_linguistics", "Academic_works_about_linguistics", "Semiotics", "Academic_works_about_semiotics", "Experimental_semiotics", "Infographics", "Music_semiology", "Nonverbal_communication", "Phonaesthetics", "Pragmatics", "Semantics", "Semioticians", "Semiotics_organizations", "Sign_systems", "Signage", "Structuralism", "Symbolic_interactionism", "Symbolism", "Symbols", "Systemic_functional_linguistics", "Vexillology", "Zoosemiotics", "Semiotics_stubs", "Linguistics_terminology", "Time_in_linguistics", "Grammatical_aspects", "Grammatical_tenses", "Linguistic_units", "Consonants", "Grammatical_construction_types", "Units_of_linguistic_morphology", "Semantic_units", "Syntactic_entities", "Vowels", "Linguistics_stubs", "Computational_linguistics_stubs", "Grammar_stubs", "Language_stubs", "Linguist_stubs", "Linguistics_book_stubs", "Linguistics_journal_stubs", "Linguistic_morphology_stubs", "Name_stubs", "Linguistics_organization_stubs", "Philology_stubs", "Phonetics_stubs", "Phonology_stubs", "Semantics_stubs", "Semiotics_stubs", "Syntax_stubs", "Translation_stubs", "Vocabulary_and_usage_stubs", "Writing_system_stubs") ) AS c ON p.page_id = c.cl_from LEFT OUTER JOIN (SELECT * FROM langlinks WHERE ll_lang IN ("cs", "de") ) 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...