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
EdwardAlexanderCrowley
.
Toggle Highlighting
SQL
use wikidatawiki_p; SELECT ips_item_id, ips_site_page from wb_items_per_site, sites WHERE ips_site_id = "enwiki" AND ips_site_id = site_global_key AND ips_site_page in ( "Late Triassic", "Yinotheria", "Australosphenida", "Theriiformes", "Holotheria", "Trechnotheria", "Cladotheria", "Afroinsectiphilia", "Eulipotyphla", "Eulipotyphla", "Terrestrial locomotion", "Aerial locomotion", "Arboreal locomotion", "Fossorial", "Bipedalism", "Tool use in animals", "Alarm signal", "Animal echolocation", "Fission-fusion society", "Harem (zoology)", "Polygyny in animals", "Monogamy in animals", "Polyandry in nature", "List of placental mammals", "List of monotremes and marsupials", "List of mammal genera", "List of mammal species", "Lemur", "Mammal Species of the World", "Journal of Mammalogy", "Journal of Mammalogy", "Ambondro mahabo", "Amphilestes", "Amphitherium", "Middle Jurassic", "Tikitherium", "Late Triassic", "Malcolm McKenna", "Theriiformes", "Holotheria", "Kuehneotheria", "Epitheria", "Preptotheria", "Lipotyphla", "Eparctocyona", "Altungulata", "Retrotransposon marker", "Boreoeutheria", "Epitheria", "Exafroplacentalia", "Nuclear DNA", "Boreoeutheria", "Eulipotyphla", "Scrotifera", "Afroinsectiphilia", "Cosmopolitan distribution", "Boreoeutheria", "Eulipotyphla", "Scrotifera", "Fereuungulata", "Evolution of mammals", "Docodonta", "Haldanodon", "Australosphenida", "Fruitafossor", "Haramiyavia", "Tinodon", "Gobiconodonta", "Trechnotheria", "Eye socket", "Temporal fenestra", "Probainognathia", "Carrier's constraint", "Trucidocynodon", "Nocturnal bottleneck", "Spalacotheriid", "Epipubic bone", "Ukhaatherium", "Asioryctitheria", "Teinolophos", "Megaconus", "Epipubic bone", "Megazostrodon", "Erythrotherium", "Protungulatum donnae", "Squamosal", "Quadrate bone", "Polyphyodont", "GeroScience", "Occipital condyle", "Rib cage", "Diastole", "Setae", "Frugivore", "Bolus (digestion)", "Cud", "Sacculation", "Excretory system", "Ureotelic", "Renal pyramid", "Loop of Henle", "Renal medulla", "Reniculate kidney", "Embryonic cloaca", "Penile urethra", "Syrinx (bird anatomy)", "Purr", "Screaming", "Cranial nerve nucleus", "Superior laryngeal nerve", "Motor cortex", "Motor neuron", "Spine (zoology)", "Awn hair", "Spine (zoology)", "Vellus hair", "Aquatic mammal", "Disruptive coloration", "Ambush predator", "Earth tone", "Arboreal", "Sexual dimorphism in non-human primates", "Mammalian reproduction", "Penile sheath", "Oviduct", "Uterine horn", "Matschie's tree-kangaroo", "Epipubic bones", "Symplesiomorphy", "Endotherm", "Common shrew", "Heterothermic", "Life expectancy", "Maximum life span", "Animal locomotion", "Terrestrial locomotion", "Knuckle-walking", "Bipedalism", "Horse gait", "Horse gait", "Horse gait", "Horse gait", "Horse gait", "Gait (human)", "Crawling (human)", "Gait", "Leaping gaits", "Arboreal locomotion", "Brachiation", "Brachiation", "Prehensile tail", "Aerial locomotion", "Egyptian fruit bat", "Merkel cell", "Fossorial", "Burrow", "Badger", "Food storage", "Marsupial mole", "Cape golden mole", "Cursorial", "Aquatic locomotion", "Marine mammal", "Aquatic mammal", "Dorsal fin", "List of semiaquatic tetrapods", "Muscle fascicle", "Specific gravity", "Vervet monkey", "Alarm signal", "Animal communication", "Animal echolocation", "Alarm signal", "Roar (vocalization)", "Greater spear-nosed bat", "Vervet monkey", "Animal echolocation", "Granivory", "Frugivory", "Nectarivory", "Gummivory", "Mycophagy", "Hypocarnivore", "Mesocarnivore", "Hypocarnivore", "Maxillary canine", "Zoopharmacognosy", "Arctic ground squirrel", "Aestivate", "Animal cognition", "Social animal", "Damaraland mole-rat", "Fission-fusion society", "Human uses of mammals", "George Stubbs", "Edwin Landseer", "Greyhound racing", "Pack animal", "Upholstery", "Hybrid (biology)", "Quagga Project", "Hybrid zone", "Breeding back", "Heck cattle", "Purebred", "Holocene extinction", "Defaunation", "Empty forest", "Global Assessment Report on Biodiversity and Ecosystem Services", "List of critically endangered species", "Live Science", "Biodiversity loss", "Living Planet Index", "Species affected by poaching", "Ivory trade", "Cetacean bycatch", "List of recently extinct mammals", "Ecological extinction", "List of mammal genera", "List of mammalogists", "List of monotremes and marsupials", "List of placental mammals", "List of prehistoric mammals", "List of threatened mammals of the United States", "Lists of mammals by population", "Lists of mammals by region", "Mammals described in the 2000s", "Mammals in culture" ) ORDER BY ips_item_id #AND site_group = "wikipedia"
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...