hiwiki articles with interwikis to a list of enwiki pages

Fork of Wikidata - tables - wb_items_per_site - describe table, sample data by Jura1
This query is marked as a draft This query has been published by Guillaume (WMF).
SQL

use wikidatawiki_p;

SELECT ips_site_page
	FROM wb_items_per_site
    WHERE ips_site_id = 'hiwiki'
    AND ips_item_id IN (
            SELECT DISTINCT(ips_item_id) FROM wb_items_per_site
                WHERE ips_site_id = 'enwiki'
    			AND ips_site_page IN ("Aang", "Abani Bari Achho", "Abelian group", "Abu'l-Fazl ibn Mubarak", "Acer rubrum", "Adobe Premiere Pro", "Air pollution", "Alberto Korda", "Albinism", "Alexandria", "Alice", "Alice Walker", "Alopecia areata", "Alprazolam", "Amateur radio", "Amazon Kindle", "Amelia Vega", "Americium", "Amit Chaudhuri", "Amoxicillin", "Anadish Pal", "Anandalok", "Anandamela", "Ananta Mandal", "Ancient Egyptian deities", "And Still I Rise", "Androgen", "Animal House", "Anita Bose Pfaff", "Anita Desai", "Anita Majumdar", "Anjolie Ela Menon", "Anna Wintour", "Annada Shankar Ray", "Anthozoa", "Aphthous stomatitis", "Aranyak", "Argon", "Arithmetic", "Aryabhata", "ASCII art", "Asit Kumar Haldar", "Astatine", "Astronomical object", "Atacama Desert", "Baby Halder", "Bahadur Shah Zafar", "Balkans", "Banquo", "Barber", "Barium", "BASIC", "Basmati", "Battle of Blenheim", "Battle of Saraighat", "Battle of the Alamo", "Bauhaus", "Beard", "Beat Generation", "Beeswax", "Belle", "Bengal famine of 1943", "Bengal Presidency", "Bengali theatre", "Benjamin Disraeli", "Bertolt Brecht", "Big King", "Bikram Choudhury", "Binary search algorithm", "Bismuth", "BitLocker", "Bivalvia", "Bjarke Ingels", "Black Act", "Black Beauty", "Black Lives Matter", "Black Swan", "Body piercing", "Boer", "Bone", "Borderline personality disorder", "Bournemouth", "Brahmagupta", "Bumblebee", "Bunyip", "Byte", "Cadmium", "Caligula", "Capacitance", "Capacitor types", "Carbohydrate", "Carbon-14", "Carboxylic acid", "Carmen", "Caspar David Friedrich", "Cefixime", "Ceftriaxone", "Cefuroxime", "Cell nucleus", "Central nervous system", "Cerium", "Cervix", "Chaitanya Charitamrita", "Chariot racing", "Charles Babbage", "Charles I of England", "Chemical compound", "Chemical element", "Chemistry", "Chemotherapy", "Chevrolet Volt", "Chitra Banerjee Divakaruni", "Chitto Jetha Bhayshunyo", "Chough", "Cinnarizine", "Ciprofloxacin", "Cirque du Soleil", "Clerodendrum", "Clindamycin", "Clotrimazole", "Cnidaria", "Coconut water", "Coevolution", "Collagen induction therapy", "Colley Cibber", "Color blindness", "Comet", "Committee on Data for Science and Technology", "Common tailorbird", "Communication protocol", "Commutative property", "Compact disc", "Computer", "Computer mouse", "Confucianism", "Confucius", "Connective tissue", "Constantinople", "Constellation", "Constipation", "Cormac McCarthy", "Coronation", "Cortana", "Cortisol", "Cough", "Crash: Mind over Mutant", "Criss Angel", "Curium", "Cutaneous condition", "Cytoplasm", "Cytosol", "Daguerreotype", "Dara Shukoh", "Death of Adolf Hitler", "Deinonychus", "Density", "Deuterium", "Digestion", "Dinesh Das", "DivX", "Domperidone", "Dorothy Parker", "DPT vaccine", "Drowning Girl", "Durbar Mahila Samanwaya Committee", "Dyslexia", "Earth Day", "Eckhart Tolle", "EgyptAir", "Ekal Vidyalaya", "Elaine Paige", "Electrical injury", "Émile Zola", "Emmeline Pankhurst", "Ender's Game", "Epinephrine", "Eragon", "Erbium", "Erich von Däniken", "Erythropoietin", "Esomeprazole", "Estradiol", "Estrogen", "Etoricoxib", "Europium", "Evita", "Evolutionary history of life", "Expo 67", "Eye", "Factorial", "Felice Beato", "Fexofenadine", "Final Fantasy IX", "Final Fantasy Tactics Advance", "Fine Brothers", "Flag of Japan", "Flatulence", "Flatworm", "Flying Dutchman", "Folate", "Fortinet", "Foster's reactance theorem", "Foundation series", "Four Quartets", "Francium", "French Revolution", "Frost at Midnight", "Führerbunker", "Fyodor Dostoyevsky", "Gandhi Jayanti", "Ganesh Pyne", "Gariahat Road", "Gastroenterology", "Gay bathhouse", "Georges Bizet", "German battleship Bismarck", "Getty Center", "Gilbert and Sullivan", "Giles Deacon", "Gill Sans", "Girls' Generation", "Global dimming", "Global Positioning System", "Gloria Steinem", "Glucagon", "Göbekli Tepe", "Goosebumps", "Governor-General of India", "Grandma Moses", "Grape", "Green Knight", "Group theatre of Kolkata", "Guy Fawkes", "Guy Fawkes Night", "Hafnium", "Hair conditioner", "Halo 3", "Halo 4", "Hand", "Hansuli Banker Upakatha", "Harold Pinter", "Harry Houdini", "Harsha", "Haskell", "HDMI", "Heart", "Heat", "Hecate", "Hel", "Hemen Majumdar", "Henry Moore", "History of Bihar", "History of Brazil", "Homeopathy", "Homme by David Beckham", "Homologous recombination", "Homology", "Hope", "Human brain", "Human rights", "Humayun", "Hypoglossal nerve", "I Know Why the Caged Bird Sings", "I. M. Pei", "Immanuel Kant", "Imru' al-Qais", "Indium", "Internal energy", "Internet Explorer", "Iodine", "Ionic compound", "iPad", "iPad", "iPad", "iPad 2", "IPv4", "Iridium", "Iron(III) chloride", "Itachi Uchiha", "Jagir", "Jahandar Shah", "Jallianwala Bagh massacre", "James Russell Lowell", "Jane Austen", "Jayasri Burman", "Jnanadanandini Devi", "John le Carré", "John Logie Baird", "John Millington Synge", "John Steinbeck", "John, King of England", "Joomla", "Joseph Goebbels", "July Revolution", "JVC", "Kalinga War", "Kanva dynasty", "Karuṇā", "Kenwood Corporation", "Kenzō Tange", "Keyboard layout", "Kinky Boots", "Knee", "Konstantin Stanislavski", "Kosher foods", "Kunal Basu", "Lahiri Mahasaya", "Lalita Lajmi", "Lanthanum", "Las Meninas", "Lawrencium", "Lead", "Lead–acid battery", "Lead(II) nitrate", "League of Nations", "Lee Strasberg Theatre and Film Institute", "Leela Majumdar", "Lemony Snicket's A Series of Unfortunate Events", "Lens", "Leo Tolstoy", "Light in August", "Linear search", "Linezolid", "Lisa del Giocondo", "Little egret", "Livermorium", "LocoRoco", "Long hair", "Losartan", "Louvre", "Louvre Abu Dhabi", "Lung", "M. C. Escher", "Mac Pro", "MacBook", "Macula of retina", "Madras Presidency", "Mahajanapada", "Major depressive disorder", "Mallory Hagan", "Maneka Sorcar", "Marcel Proust", "Marchantiophyta", "Medicine", "Meera Mukherjee", "Meitei people", "Merchants of Doubt", "Mercury", "Messier 87", "Metroid", "Metronidazole", "Microsoft Excel", "Middlesex", "Miguel de Cervantes", "Mihrimah Sultan", "Milan Kundera", "Milo of Croton", "Misty Copeland", "Mitochondrion", "Moby", "Mongol Empire", "Montelukast", "Moravia", "Morphine", "MPEG-1", "Muhammad Shah", "Mukul Dey", "MultiMediaCard", "Mummy", "Na Hanyate", "Nabulsi soap", "Nagoya", "Nail", "Names of Japan", "Nancy Drew", "Nandikar", "Nandrolone", "Naomi Campbell", "Nastanirh", "Natural resource", "Nawab", "Nebular hypothesis", "Neodymium", "Neri Oxman", "Netbook", "Neurology", "New World Order", "Nicotinamide adenine dinucleotide", "Nicotinamide adenine dinucleotide phosphate", "Nicotine", "Nihonium", "Nina Davuluri", "Nintendo DSi", "Nirmala", "Noël Coward", "Noh", "Nonviolent Communication", "O. Henry", "Oaxaca", "Odysseus", "Ohm", "Oliver Goldsmith", "Oliver Sacks", "Opuntia", "Organ", "Osmium", "Otto von Bismarck", "Outliers", "Ovary", "Oxytocin", "P. C. Sorcar Jr.", "Palate", "Palladian architecture", "Palladium", "Panchala", "Pancreas", "Pantoprazole", "Paralysis", "Paul Cézanne", "Paul Gauguin", "PC Card", "Peace of Westphalia", "Peking opera", "Père Goriot", "Perseus", "Pharaoh", "Pharmaceutical drug", "Pharmacy", "Philip Larkin", "Philip Roth", "Phishing", "Phosphatase", "Photography", "Physical exercise", "PicsArt Photo Studio", "Pioneer Corporation", "PlayStation", "Plutarch", "Plymouth, Massachusetts", "Pnictogen", "Poison dart frog", "Pokémon Black and White", "Pokémon Diamond and Pearl", "Pokémon FireRed and LeafGreen", "Pokémon Gold and Silver", "Pokémon HeartGold and SoulSilver", "Pokémon Red and Blue", "Polonium", "PostgreSQL", "Power", "Prabhat Samgiita", "Pressure", "Pride and Prejudice", "Priyanka Yoshikawa", "Proactiv", "Psychiatry", "Pudendal nerve", "Pus", "Q Who", "Quinine", "Rabeprazole", "Rabindra Nritya Natya", "Racism", "Radium", "Raj Kumar Shukla", "Ramaprasad Banik", "Rampal Power Station", "Ranitidine", "Rassundari Devi", "Red Army", "Red Dead Redemption", "Red Sindhi", "Reginald Edward Harry Dyer", "Regular polygon", "Reiki", "Reinhard Heydrich", "René Descartes", "Resistor", "Retinol", "Rhenium", "Rheumatism", "River Avon, Bristol", "Robotics", "Roger Bacon", "Romila Thapar", "Rubella", "Sahaj Path", "Sakti Burman", "Samaresh Majumdar", "Samarium", "Samir Mondal", "Samuel Bourne", "Samuel Johnson", "SAS Institute", "Satyananda Giri", "Saul Bellow", "Sawfly", "Schottky diode", "Sclera", "Seawater", "Second-wave feminism", "Sejanus", "Seneca Falls Convention", "Serial ATA", "Sestina", "Shanti Ashram", "Shingles", "Shobhabazar", "Sickle", "Sildenafil", "Sinai Peninsula", "Sir Gawain and the Green Knight", "Sistine Chapel ceiling", "Sivananda Saraswati", "Skopje", "Slaughterhouse-Five", "Slavoj Žižek", "Slum", "Smartsheet", "Sodium carbonate", "Sonnet 18", "Sound", "Spirulina", "Spleen", "Square root of 2", "Star Trek", "Starfish", "Stem cell", "Stephen Crane", "Still Jennifer Lopez", "Stoicism", "Stretch marks", "Subwoofer", "Sumit Sarkar", "Sunil Das", "Super Mario Galaxy", "Super Mario Galaxy 2", "Super Metroid", "Superliner", "Sustainability", "Swapnasandhani", "Swine influenza", "Tantalum", "Tashkent Declaration", "Teleological argument", "Tellurium", "Terry Eagleton", "Terry Pratchett", "Tessellation", "Testosterone", "The Adventures of Sherlock Holmes", "The Alchemist", "The Canterbury Tales", "The Decameron", "The Dying Swan", "The Fountainhead", "The Hardy Boys", "The Hidden Oracle", "The Home and the World", "The King and I", "The Lucy poems", "The Music Machine", "The Phantom of the Opera", "The Phantom Tollbooth", "The Plays of William Shakespeare", "The Princess and the Pea", "The Royal Opera", "The Secret Seven", "The Son of Neptune", "The Stranger", "The Tales of Beedle the Bard", "The Winds of Winter", "Thigh", "Thomas Jefferson", "Thomas Roe", "Three Witches", "Thulium", "Thumbelina", "Thyroid", "Tick", "Tin", "Tin Goyenda", "Tinea versicolor", "To Autumn", "Tobacco", "Tokyo Tower", "Tomb Raider: Underworld", "Toothache", "Tory Burch", "Tosca", "Tracheal intubation", "Transformers", "Transformers: Dark of the Moon", "Transformers: War for Cybertron", "Transistor", "Traumatic brain injury", "Treasure Island", "Treaty of Yandabo", "Tunicate", "Uday Shankar", "Ukiyo-e", "Ultrabook", "Ulysses", "Unification of Germany", "Uniform Resource Identifier", "Unish-Kuri", "Upamanyu Chatterjee", "Ur", "Uranium", "Urban heat island", "Uterus", "Vaccine", "Valhalla", "Valkyrie", "Variable-frequency drive", "Venus flytrap", "Vidyadhar Bhattacharya", "Visual Basic .NET", "Vitamin", "Vitamin C", "Vitruvian Man", "Vladimir Nabokov", "Volcanic ash", "Volt", "Vomiting", "Waiting for Godot", "War", "War and Peace", "Warfarin", "Water cycle", "Waterstones", "Watson", "Welsh National Opera", "What If?: Serious Scientific Answers to Absurd Hypothetical Questions", "Whey", "White tea", "Wi-Fi", "Wicked", "Wii", "Wilkinson Microwave Anisotropy Probe", "William Adam", "William Etty", "Willy Loman", "Windows Server 2016", "Winsor McCay", "Wipeout", "Wipeout Pure", "Women's health", "Women's rights", "Woolly mammoth", "Workhouse", "World Health Day", "Wreck of the RMS Titanic", "Xeroderma", "Yertle the Turtle and Other Stories", "Yoga", "Zagros Mountains")
            );
;
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...
