-- USE enwiki_p;

​

SELECT 

    concat("[[:en:",page_title,"|",page_title,"]]") title_en,  ll_title

FROM

    page, langlinks

  WHERE

    ll_from = page_id and

    page_namespace = 0 and

    ll_title like "Telugu:%"

--    page_title in ("Harold Lloyd","Lillian Gish","Buster Keaton","Mary Pickford","Gloria Swanson","Asta Nielsen","Fred Astaire","Sarah Bernhardt","Humphrey Bogart","Marlon Brando","Marx Brothers","James Cagney","Charlie Chaplin","Claudette Colbert","Gary Cooper","Joan Crawford","Bette Davis","Robert De Niro","James Dean","Henry Fonda","Jane Fonda","Clark Gable","Judy Garland","Whoopi Goldberg","Cary Grant","Tom Hanks","Katharine Hepburn","Grace Kelly","Gene Kelly","Marilyn Monroe","Eddie Murphy","Jack Nicholson","Gregory Peck","Barbara Stanwyck","James Stewart","Meryl Streep","Elizabeth Taylor","Shirley Temple","Spencer Tracy","John Wayne","Mae West","Robin Williams","Bruce Lee","Amitabh Bachchan","Pran (actor)","Toshiro Mifune","Brigitte Bardot","Jean-Paul Belmondo","Louis de Funès","Alain Delon","Fernandel","Jean Gabin","Jean Marais","Gérard Philipe","Richard Burton","Michael Caine","Sean Connery","Daniel Day-Lewis","Audrey Hepburn","Anthony Hopkins","Edmund Kean","Vivien Leigh","Laurence Olivier","Peter O'Toole","Peter Sellers","Adriano Celentano","Gina Lollobrigida","Sophia Loren","Marcello Mastroianni","Ingrid Bergman","Greta Garbo","Mikhail Ulyanov","Yevgeny Leonov","Innokenty Smoktunovsky","Armen Dzhigarkhanyan","Marlene Dietrich","Maximilian Schell","Alvin Ailey","Marian Anderson","Frederick Ashton","Mikhail Baryshnikov","Maurice Béjart","Carlo Blasis","Andrea Bocelli","Erik Bruhn","George Carlin","Enrico Caruso","Cyd Charisse","Boris Christoff","David Copperfield (illusionist)","Plácido Domingo","Isadora Duncan","Fanny Elssler","Michel Fokine","Margot Fonteyn","Gregory Hines","Harry Houdini","Tamara Karsavina","Rudolf von Laban","Jenny Lind","Vaslav Nijinsky","Birgit Nilsson","Rudolf Nureyev","Luciano Pavarotti","Anna Pavlova","Marius Petipa","Leontyne Price","Jerome Robbins","Renata Scotto","Beverly Sills","Marie Taglioni","Maria Tallchief","Phidias","Vitruvius","Hieronymus Bosch","Jan van Eyck","Giotto","Andrei Rublev","El Greco","Jacques-Louis David","Eugène Delacroix","François Mansart","Nicolas Poussin","Albrecht Dürer","Caspar David Friedrich","Hans Holbein the Younger","Karl Friedrich Schinkel","Francesco Borromini","Caravaggio","Gian Lorenzo Bernini","Giovanni Bellini","Sandro Botticelli","Donato Bramante","Canaletto","Piero della Francesca","Andrea Mantegna","Masaccio","Michelangelo","Andrea Palladio","Raphael","Andrea del Sarto","Tintoretto","Titian","Paolo Veronese","Leonardo da Vinci","Anthony van Dyck","Peter Paul Rubens","Rembrandt","Johannes Vermeer","Jusepe de Ribera","Diego Velázquez","Marc Chagall","Marcel Duchamp","René Magritte","Frida Kahlo","Mary Cassatt","Georgia O'Keeffe","Jackson Pollock","Mark Rothko","Andy Warhol","Grant Wood",";;ఐరోపా","Paul Klee","Gustav Klimt","Edvard Munch","Victor Vasarely","Jean-Auguste-Dominique Ingres","Marie-Antoine Carême","Paul Cézanne","Edgar Degas","Paul Gauguin","Édouard Manet","Henri Matisse","Claude Monet","Pierre-Auguste Renoir","Henri Rousseau","Henri de Toulouse-Lautrec","Georges Seurat","Francis Bacon (artist)","William Hogarth","J. M. W. Turner","M. C. Escher","Vincent van Gogh","Piet Mondrian","Wassily Kandinsky","Kazimir Malevich","Ilya Repin","Nicholas Roerich","Salvador Dalí","Francisco Goya","Joan Miró","Pablo Picasso","Auguste Rodin","Donatello","Imhotep","Oscar Niemeyer","Walter Burley Griffin","William Le Baron Jenney","Frank Gehry","Frank Lloyd Wright","Richard Meier","Louis Sullivan","I. M. Pei","Mimar Sinan","Kenzō Tange","Alvar Aalto","Le Corbusier","Antoni Gaudí","Victor Horta","Inigo Jones","Richard Neutra","Renzo Piano","Christopher Wren","Günter Behnisch","Peter Behrens","Walter Gropius","Erich Mendelsohn","Frei Otto","Ludwig Mies van der Rohe","Hans Scharoun","Shitao","Raja Ravi Varma","Hiroshige","Hokusai","Sesshū Tōyō","Abu Nuwas","Adam Mickiewicz","Alexander Pushkin","Alejo Carpentier","Alexandre Dumas","Alice Walker","Allen Ginsberg","Amir Khusrow","Anton Chekhov","Arthur Rimbaud","Brothers Grimm","Carl Sandburg","Charles Dickens","Cicero","Dashiell Hammett","Douglas Adams","Du Fu","Edgar Allan Poe","Eino Leino","Emily Dickinson","Erich Maria Remarque","Ernest Hemingway","F. Scott Fitzgerald","Franz Kafka","Fyodor Dostoevsky","John Donne","Gabriel García Márquez","Geoffrey Chaucer","George Bernard Shaw","George Orwell","Ghalib","H. G. Wells","Hans Christian Andersen","Harold Pinter","Heinrich Heine","Henrik Ibsen","Henry James","Henry Miller","Hermann Hesse","Hildegard of Bingen","Ilf and Petrov","Isaac Asimov","Ivan Vazov","J. R. R. Tolkien","Jack Kerouac","Jack London","Rumi","James Joyce","Jane Austen","Jerome K. Jerome","Johann Wolfgang von Goethe","John Steinbeck","John Updike","Jonathan Swift","Jorge Luis Borges","José Martí","José Saramago","Jules Verne","Kālidāsa","Langston Hughes","Leo Tolstoy","Lewis Carroll","Li Bai","Lord Byron","Marcel Proust","Mark Twain","Mario Vargas Llosa","Matsuo Bashō","Maxim Gorky","Miguel de Cervantes","Mikhail Bulgakov","Molière","Murasaki Shikibu","Naguib Mahfouz","Nathaniel Hawthorne","Nikolai Gogol","Nikos Kazantzakis","Olaf Stapledon","Omar Khayyam","Pablo Neruda","Petrarch","Philip K. Dick","Rabindranath Tagore","Rainer Maria Rilke","Gabriele D'Annunzio","Brontë family","Robert A. Heinlein","Saadi Shirazi","Salman Rushdie","Sappho","Saul Bellow","Thomas Hardy","Thomas Mann","Thomas Pynchon","Toni Morrison","Truman Capote","Umberto Eco","Victor Hugo","Yasunari Kawabata","Yukio Mishima","Qu Yuan","Aesop","Menander","Aeschylus","Aristophanes","Euripides","Hafez","Homer","Horace","Ovid","Plutarch","Sophocles","Virgil","Pliny the Elder","Dante Alighieri","Ferdowsi","Jami","Kabir","Nizami Ganjavi","Rudaki","Giovanni Boccaccio","Ali-Shir Nava'i","William Shakespeare","Chrétien de Troyes","Christine de Pizan","François Villon","Fuzûlî","Tulsidas","Pedro Calderón de la Barca","Luís de Camões","Pierre Corneille","Daniel Defoe","Gavrila Derzhavin","John Dryden","Samuel Johnson","John Milton","Michel de Montaigne","François Rabelais","Jean Racine","Lope de Vega")

limit 100