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 ( "Biology", "Biology_by_country", "Paleontology_by_country", "Biotechnology_by_country", "Botany_by_country", "Ecology_by_country", "Biology_organizations_by_country", "Zoology_by_country", "Biology_and_natural_history_in_the_Dutch_Republic", "Biology_in_the_United_States", "Biologists", "Biologists_by_ethnicity", "Biologists_by_century", "Biologists_by_field_of_research", "Biologists_by_nationality", "Lists_of_biologists", "Professorships_in_biology", "Women_biologists", "Amateur_biologists", "Biology_award_winners", "Cultural_depictions_of_biologists", "Fictional_biologists", "Pseudoscientific_biologists", "Tamil_biologists", "Biologist_stubs", "Biology-related_lists", "Lists_of_biologists", "Lists_of_biota", "Ecology_lists", "Lists_of_ecoregions", "Lists_of_forests", "Glossaries_of_biology", "Lists_of_human_anatomical_features", "Lists_of_largest_organisms", "Life_extension_lists", "Medical_lists", "Molecular-biology-related_lists", "Lists_of_sequenced_genomes", "Zoology-related_lists", "Branches_of_biology", "Branches_of_botany", "Branches_of_mycology", "Subfields_of_zoology", "Biologists_by_field_of_research", "History_of_biology_by_subdiscipline", "Anatomy", "Astrobiology", "Biochemistry", "Biomedicine", "Bionics", "Biophysics", "Botany", "Cell_biology", "Chemical_biology", "Chronobiology", "Computational_biology", "Conservation_biology", "Developmental_biology", "Ecology", "Evolutionary_biology", "Genetics", "Geobiology", "Gerontology", "Human_biology", "Lichenology", "Marine_biology", "Medicine", "Microbiology", "Molecular_biology", "Morphology_(biology)", "Mycology", "Neuroscience", "Nutrition", "Paleobiology", "Pathology", "Physiology", "Soil_biology", "Structural_biology", "Systems_biology", "Taxonomy_(biology)", "Zoology", "Biology_awards", "Biochemistry_awards", "Biology_award_winners", "Biomedical_awards", "Ecology_awards", "Frink_Medal_winners", "Genetics_awards", "Medicine_awards", "Neuroscience_awards", "Ornithology_awards", "Paleontology_awards", "Biocides", "Biocides_by_mechanism", "Acaricides", "Algaecides", "Antibiotics", "Antimicrobials", "Antiparasitic_agents", "Antiprotozoal_agents", "Antiviral_drugs", "Avicides", "Bactericides", "Fungicides", "Herbicides", "Insecticides", "Microbicides", "Molluscicides", "Pesticides", "Rodenticides", "Spermicide", "Virucides", "Biological_classification", "British_National_Vegetation_Classification", "Eukaryotes_by_classification", "Fungi_by_classification", "Levels_of_organization_(Biology)", "Biological_nomenclature", "Phylogenetics", "Protein_classification", "Sex", "Taxonomy_(biology)", "Tree_of_life_(biology)", "Biological_descriptions", "Descriptions_from_Illustrations_of_Exotic_Entomology", "Taxa", "Undescribed_species", "Biological_records", "Largest_organisms", "Lists_of_people-related_superlatives", "Oldest_organisms", "Origin_of_life", "Biological_rules", "Ecogeographic_rules", "Biological_systems", "Ecosystems", "Organ_systems", "Biology_software", "Bioinformatics_software", "Biomedical_software", "Biosimulation_software", "Biovisualization_software", "Free_biology_software", "Biotechnology", "Biotechnology_by_country", "Biotechnologists", "Antibody-drug_conjugates", "Artificial_organs", "Biochemical_engineering", "Biochemistry", "Biofuels_technology", "Bioinformatics", "Biological_engineering", "Bioluminescence", "Biomedical_districts", "Biopunk", "Bioreactors", "Bioremediation", "Biosensors", "Biotechnology_databases", "Breakthrough_therapy", "Cell_imaging", "Cloning", "Cyborgs", "DNA_sequencing", "Escherichia_coli", "Genetic_engineering", "Genome_projects", "History_of_biotechnology", "Induced_stem_cells", "Industrial_enzymes", "Biotechnology_literature", "Biotechnology_law", "Life_sciences_industry", "Lists_of_sequenced_genomes", "LncRNA", "Medical_technology", "Microarrays", "Molecular_genetics", "Oncolytic_virus", "Biotechnology_organizations", "Pharmaceutical_isolates", "Biotechnology_products", "Regulation_of_biotechnologies", "Specialty_drugs", "Stem_cell_research", "Stem_cells", "Synthetic_biology", "Therapeutic_gene_modulation", "Translational_medicine", "Vaccination", "Biological_warfare", "Biotechnology_stubs", "Biological_censuses", "Bird_censuses", "Biological_concepts", "Biological_rules", "Biological_theorems", "Biology_laws", "Genetics_concepts", "Biological_hypotheses", "Biology_theories", "Biology_controversies", "Animal-related_controversies", "Extraterrestrial_life", "Biology_and_culture", "Animals_in_human_culture", "Botanical_art", "Cultural_depictions_of_biologists", "Dinosaurs_in_fiction", "Evolution_in_popular_culture", "Fiction_about_creatures", "Forests_in_culture", "Biological_hazards", "Biological_mass_media", "Biology_organizations", "Plants_in_culture", "Works_about_biology", "Biology_education", "Biology_competitions", "Bioscience_education", "Biological_simulation_video_games", "Biology-themed_board_games", "Genetics_education", "Eukaryote_biology", "Eukaryotic_cells", "Eukaryote_genetics", "Eukaryote_proteins", "SAR_supergroup_biology", "Biological_evolution", "Evolution_by_taxon", "Antibiotic_resistance", "Antipredator_adaptations", "Aquatic_organisms", "Books_about_evolution", "Evolution_and_religion", "Evolutionarily_significant_biological_phenomena", "Evolutionary_biology", "Extinction_events", "Gaps_in_the_fossil_record", "Origin_of_life", "Evolution_in_popular_culture", "Rate_of_evolution", "Tree_of_life_(biology)", "United_States_creationism_and_evolution_case_law", "Evolution_stubs", "History_of_biology", "History_of_biology_by_subdiscipline", "Biology_by_century", "Biology_by_decade", "Biology_by_year", "Biologists", "History_of_bioethics", "Biology_and_natural_history_in_the_Dutch_Republic", "History_of_biotechnology", "Biological_events", "Biology_experiments", "Historians_of_biology", "Natural_history", "Obsolete_biological_theories", "Obsolete_taxa", "Biology_timelines", "Biology_images", "Images_of_animals", "Paleontology_images", "Biological_interactions", "Aggression", "Chemosynthetic_symbiosis", "Biological_defense_mechanisms", "Eating_behaviors", "Mutualism_(biology)", "Reproduction", "Symbiosis", "Philosophy_of_biology", "Animal_ethics", "Antinatalism", "Bioethics", "Biological_concepts", "Deep_ecology", "Developmental_biology", "Evolutionary_biology", "Natalism", "Philosophy_of_sexuality", "Biological_processes", "Biogeomorphology", "Cellular_processes", "Evolutionary_processes", "Homeostasis", "Immune_system_process", "Memory_processes", "Pigmentation", "Reproduction", "Self-replication", "Senescence", "Viral_life_cycle", "Quantum_biology", "Standardized_tests_for_Biology", "Biological_techniques_and_tools", "Biochemistry_methods", "Cell_imaging", "Cloning", "Flow_cytometry", "Fluorescence_techniques", "Microbiology_equipment", "Biological_models", "Molecular_biology_techniques", "Reagents_for_biochemistry", "Biology_terminology", "Biological_nomenclature", "Biological_rules", "Ecology_terminology", "Evolutionary_biology_terminology", "Glossaries_of_biology", "Latin_biological_phrases", "Unsolved_problems_in_biology", "Ailments_of_unknown_cause", "Unsolved_problems_in_neuroscience", "Biological_waste", "Animal_waste_products", "Excretion", "Medical_waste", "Wikipedia_books_on_biology", "Wikipedia_books_on_astrobiology", "Wikipedia_books_on_biochemistry", "Wikipedia_books_on_ecology", "Wikipedia_books_on_evolutionary_biology", "Wikipedia_books_on_genetics", "Wikipedia_books_on_health", "Wikipedia_books_on_neuroscience", "Wikipedia_books_on_organisms", "Wikipedia_books_on_physiology", "Wikipedia_books_on_scientific_classification", "Wikipedia_books_on_zoology", "Biology_stubs", "Anatomy_stubs", "Biochemistry_stubs", "Bioinformatics_stubs", "Biologist_stubs", "Biotechnology_stubs", "Biology_book_stubs", "Botany_stubs", "Biological_database_stubs", "Developmental_biology_stubs", "Ecology_stubs", "Evolution_stubs", "Genetics_stubs", "Biology_journal_stubs", "Microbiology_stubs", "Mycology_stubs") ) AS c ON p.page_id = c.cl_from LEFT OUTER JOIN (SELECT * FROM langlinks WHERE ll_lang IN ("cs", "en") ) 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...