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") ) 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...