-
-
Save alexdean/151c85481e746999cdb3 to your computer and use it in GitHub Desktop.
all published TED Talk translations missing a translator or reviewer credit
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| talk id, language_code, headline, translator_credit, reviewer_credit | |
| 12 fa Eva Vertes looks to the future of medicine missing present | |
| 32 vi Vik Muniz: Art with wire, sugar, chocolate and string missing present | |
| 40 mr Frans Lanting: The story of life in photographs present missing | |
| 53 ar Majora Carter: Greening the ghetto missing missing | |
| 53 bn Majora Carter: Greening the ghetto missing missing | |
| 53 de Majora Carter: Greening the ghetto missing missing | |
| 53 es Majora Carter: Greening the ghetto missing missing | |
| 53 fa Majora Carter: Greening the ghetto missing missing | |
| 53 fi Majora Carter: Greening the ghetto missing missing | |
| 53 he Majora Carter: Greening the ghetto missing missing | |
| 53 hi Majora Carter: Greening the ghetto missing missing | |
| 53 it Majora Carter: Greening the ghetto missing missing | |
| 53 ja Majora Carter: Greening the ghetto missing missing | |
| 53 kn Majora Carter: Greening the ghetto missing missing | |
| 53 ko Majora Carter: Greening the ghetto missing present | |
| 53 pl Majora Carter: Greening the ghetto present missing | |
| 53 pt-br Majora Carter: Greening the ghetto missing missing | |
| 53 ru Majora Carter: Greening the ghetto missing missing | |
| 53 sw Majora Carter: Greening the ghetto missing missing | |
| 53 ta Majora Carter: Greening the ghetto missing missing | |
| 53 te Majora Carter: Greening the ghetto missing missing | |
| 53 th Majora Carter: Greening the ghetto missing missing | |
| 53 tr Majora Carter: Greening the ghetto missing present | |
| 53 ur Majora Carter: Greening the ghetto missing missing | |
| 53 vi Majora Carter: Greening the ghetto missing missing | |
| 62 ru Bjorn Lomborg: Global priorities bigger than climate change present missing | |
| 66 lo Ken Robinson says schools kill creativity missing missing | |
| 66 nb Ken Robinson says schools kill creativity missing missing | |
| 66 ne Ken Robinson says schools kill creativity present missing | |
| 66 ru Ken Robinson says schools kill creativity present missing | |
| 69 ar Wade Davis: Dreams from endangered cultures missing missing | |
| 69 bn Wade Davis: Dreams from endangered cultures missing missing | |
| 69 de Wade Davis: Dreams from endangered cultures missing present | |
| 69 es Wade Davis: Dreams from endangered cultures missing present | |
| 69 fa Wade Davis: Dreams from endangered cultures missing missing | |
| 69 fi Wade Davis: Dreams from endangered cultures missing missing | |
| 69 fr Wade Davis: Dreams from endangered cultures missing missing | |
| 69 he Wade Davis: Dreams from endangered cultures present missing | |
| 69 hi Wade Davis: Dreams from endangered cultures missing missing | |
| 69 it Wade Davis: Dreams from endangered cultures missing missing | |
| 69 ja Wade Davis: Dreams from endangered cultures missing missing | |
| 69 kn Wade Davis: Dreams from endangered cultures missing missing | |
| 69 ko Wade Davis: Dreams from endangered cultures missing present | |
| 69 pl Wade Davis: Dreams from endangered cultures missing missing | |
| 69 pt-br Wade Davis: Dreams from endangered cultures missing missing | |
| 69 ru Wade Davis: Dreams from endangered cultures missing missing | |
| 69 sw Wade Davis: Dreams from endangered cultures missing missing | |
| 69 ta Wade Davis: Dreams from endangered cultures missing missing | |
| 69 te Wade Davis: Dreams from endangered cultures missing missing | |
| 69 th Wade Davis: Dreams from endangered cultures missing missing | |
| 69 tr Wade Davis: Dreams from endangered cultures missing present | |
| 69 ur Wade Davis: Dreams from endangered cultures missing missing | |
| 69 vi Wade Davis: Dreams from endangered cultures missing missing | |
| 69 zh-cn Wade Davis: Dreams from endangered cultures missing missing | |
| 70 da Richard St. John's 8 secrets of success missing missing | |
| 70 it Richard St. John's 8 secrets of success missing missing | |
| 70 my Richard St. John's 8 secrets of success present missing | |
| 70 sl Richard St. John's 8 secrets of success present missing | |
| 89 fa Ben Saunders skis to the North Pole missing present | |
| 92 ar Hans Rosling: Stats that reshape your worldview missing missing | |
| 92 bn Hans Rosling: Stats that reshape your worldview missing missing | |
| 92 de Hans Rosling: Stats that reshape your worldview missing present | |
| 92 es Hans Rosling: Stats that reshape your worldview missing missing | |
| 92 fi Hans Rosling: Stats that reshape your worldview missing missing | |
| 92 fr Hans Rosling: Stats that reshape your worldview missing missing | |
| 92 he Hans Rosling: Stats that reshape your worldview missing missing | |
| 92 hi Hans Rosling: Stats that reshape your worldview missing missing | |
| 92 it Hans Rosling: Stats that reshape your worldview missing missing | |
| 92 ja Hans Rosling: Stats that reshape your worldview missing present | |
| 92 kn Hans Rosling: Stats that reshape your worldview missing missing | |
| 92 ko Hans Rosling: Stats that reshape your worldview missing present | |
| 92 pl Hans Rosling: Stats that reshape your worldview missing missing | |
| 92 pt-br Hans Rosling: Stats that reshape your worldview missing missing | |
| 92 ru Hans Rosling: Stats that reshape your worldview missing missing | |
| 92 sw Hans Rosling: Stats that reshape your worldview missing missing | |
| 92 ta Hans Rosling: Stats that reshape your worldview missing missing | |
| 92 te Hans Rosling: Stats that reshape your worldview missing missing | |
| 92 th Hans Rosling: Stats that reshape your worldview missing missing | |
| 92 tr Hans Rosling: Stats that reshape your worldview missing present | |
| 92 ur Hans Rosling: Stats that reshape your worldview missing missing | |
| 92 vi Hans Rosling: Stats that reshape your worldview missing missing | |
| 92 zh-cn Hans Rosling: Stats that reshape your worldview missing present | |
| 92 zh-tw Hans Rosling: Stats that reshape your worldview missing missing | |
| 93 uk Barry Schwartz: The paradox of choice present missing | |
| 97 de Dan Gilbert: The surprising science of happiness present missing | |
| 97 ru Dan Gilbert: The surprising science of happiness present missing | |
| 104 nl William McDonough: Cradle to cradle design present missing | |
| 113 ml Richard Dawkins: Militant atheism present missing | |
| 127 bn Ngozi Okonjo-Iweala: Want to help Africa? Do business here missing missing | |
| 127 fa Ngozi Okonjo-Iweala: Want to help Africa? Do business here missing missing | |
| 127 he Ngozi Okonjo-Iweala: Want to help Africa? Do business here missing missing | |
| 127 hi Ngozi Okonjo-Iweala: Want to help Africa? Do business here missing missing | |
| 127 ja Ngozi Okonjo-Iweala: Want to help Africa? Do business here missing missing | |
| 127 kn Ngozi Okonjo-Iweala: Want to help Africa? Do business here missing missing | |
| 127 pl Ngozi Okonjo-Iweala: Want to help Africa? Do business here missing missing | |
| 127 sw Ngozi Okonjo-Iweala: Want to help Africa? Do business here missing missing | |
| 127 ta Ngozi Okonjo-Iweala: Want to help Africa? Do business here missing missing | |
| 127 te Ngozi Okonjo-Iweala: Want to help Africa? Do business here missing missing | |
| 127 th Ngozi Okonjo-Iweala: Want to help Africa? Do business here missing missing | |
| 127 tr Ngozi Okonjo-Iweala: Want to help Africa? Do business here missing present | |
| 127 ur Ngozi Okonjo-Iweala: Want to help Africa? Do business here missing missing | |
| 127 vi Ngozi Okonjo-Iweala: Want to help Africa? Do business here missing missing | |
| 129 ar Blaise Aguera y Arcas demos Photosynth missing missing | |
| 129 bn Blaise Aguera y Arcas demos Photosynth missing missing | |
| 129 de Blaise Aguera y Arcas demos Photosynth missing missing | |
| 129 es Blaise Aguera y Arcas demos Photosynth missing missing | |
| 129 fa Blaise Aguera y Arcas demos Photosynth missing missing | |
| 129 fi Blaise Aguera y Arcas demos Photosynth missing missing | |
| 129 he Blaise Aguera y Arcas demos Photosynth missing missing | |
| 129 hi Blaise Aguera y Arcas demos Photosynth missing missing | |
| 129 it Blaise Aguera y Arcas demos Photosynth missing missing | |
| 129 ja Blaise Aguera y Arcas demos Photosynth missing present | |
| 129 kn Blaise Aguera y Arcas demos Photosynth missing missing | |
| 129 ko Blaise Aguera y Arcas demos Photosynth missing present | |
| 129 pl Blaise Aguera y Arcas demos Photosynth missing missing | |
| 129 pt-br Blaise Aguera y Arcas demos Photosynth missing missing | |
| 129 ru Blaise Aguera y Arcas demos Photosynth missing missing | |
| 129 sw Blaise Aguera y Arcas demos Photosynth missing missing | |
| 129 ta Blaise Aguera y Arcas demos Photosynth missing missing | |
| 129 te Blaise Aguera y Arcas demos Photosynth missing missing | |
| 129 th Blaise Aguera y Arcas demos Photosynth missing missing | |
| 129 tr Blaise Aguera y Arcas demos Photosynth missing present | |
| 129 ur Blaise Aguera y Arcas demos Photosynth missing missing | |
| 129 vi Blaise Aguera y Arcas demos Photosynth missing missing | |
| 130 pt Bob Thurman: We can be Buddhas missing present | |
| 140 zh-cn Hans Rosling: New insights on poverty missing missing | |
| 140 zh-tw Hans Rosling: New insights on poverty missing missing | |
| 142 pt Alan Russell: The potential of regenerative medicine missing present | |
| 145 fa Deborah Gordon: The emergent genius of ant colonies missing present | |
| 157 de Jacqueline Novogratz on patient capitalism present missing | |
| 163 mk Steven Pinker: The surprising decline in violence present missing | |
| 170 es Jeff Skoll makes movies that matter missing missing | |
| 170 fr Jeff Skoll makes movies that matter missing missing | |
| 179 hup Kenichi Ebina's magic moves present missing | |
| 179 ka Kenichi Ebina's magic moves missing missing | |
| 179 mt Kenichi Ebina's magic moves present missing | |
| 179 pt-br Kenichi Ebina's magic moves present missing | |
| 179 ru Kenichi Ebina's magic moves missing present | |
| 187 ru Lawrence Lessig: Laws that choke creativity present missing | |
| 194 ru Murray Gell-Mann on beauty and truth in physics present missing | |
| 197 ru Philippe Starck: Design and destiny present missing | |
| 205 ru JJ Abrams: The mystery box missing present | |
| 208 pt Ben Dunlap: The life-long learner missing present | |
| 212 fr Robin Chase on Zipcar and her next big idea present missing | |
| 215 it David Macaulay's Rome Antics missing present | |
| 220 vi Joseph Lekuton tells a parable for Kenya present missing | |
| 228 pt Alan Kay shares a powerful idea about ideas missing present | |
| 229 ar Jill Bolte Taylor's stroke of insight missing present | |
| 229 de Jill Bolte Taylor's stroke of insight missing missing | |
| 229 es Jill Bolte Taylor's stroke of insight missing present | |
| 229 fi Jill Bolte Taylor's stroke of insight missing missing | |
| 229 it Jill Bolte Taylor's stroke of insight missing missing | |
| 229 ja Jill Bolte Taylor's stroke of insight missing present | |
| 229 ko Jill Bolte Taylor's stroke of insight missing present | |
| 229 nb Jill Bolte Taylor's stroke of insight missing missing | |
| 229 pt-br Jill Bolte Taylor's stroke of insight missing missing | |
| 229 ru Jill Bolte Taylor's stroke of insight missing missing | |
| 229 zh-cn Jill Bolte Taylor's stroke of insight missing missing | |
| 234 ar Karen Armstrong makes her TED Prize wish: the Charter for Compassion missing missing | |
| 234 es Karen Armstrong makes her TED Prize wish: the Charter for Compassion missing missing | |
| 234 he Karen Armstrong makes her TED Prize wish: the Charter for Compassion missing missing | |
| 234 sq Karen Armstrong makes her TED Prize wish: the Charter for Compassion missing present | |
| 234 ur Karen Armstrong makes her TED Prize wish: the Charter for Compassion missing missing | |
| 237 ru Clifford Stoll: The call to learn present missing | |
| 242 pt Stephen Hawking: Questioning the universe missing present | |
| 243 ar Al Gore: New thinking on the climate crisis missing missing | |
| 243 bn Al Gore: New thinking on the climate crisis missing missing | |
| 243 de Al Gore: New thinking on the climate crisis missing missing | |
| 243 es Al Gore: New thinking on the climate crisis missing missing | |
| 243 fa Al Gore: New thinking on the climate crisis missing missing | |
| 243 fi Al Gore: New thinking on the climate crisis missing missing | |
| 243 hi Al Gore: New thinking on the climate crisis missing missing | |
| 243 it Al Gore: New thinking on the climate crisis missing missing | |
| 243 kn Al Gore: New thinking on the climate crisis missing missing | |
| 243 pl Al Gore: New thinking on the climate crisis missing missing | |
| 243 pt-br Al Gore: New thinking on the climate crisis missing missing | |
| 243 ru Al Gore: New thinking on the climate crisis missing missing | |
| 243 sw Al Gore: New thinking on the climate crisis missing missing | |
| 243 ta Al Gore: New thinking on the climate crisis missing missing | |
| 243 te Al Gore: New thinking on the climate crisis missing missing | |
| 243 th Al Gore: New thinking on the climate crisis missing missing | |
| 243 tr Al Gore: New thinking on the climate crisis missing present | |
| 243 ur Al Gore: New thinking on the climate crisis missing missing | |
| 243 vi Al Gore: New thinking on the climate crisis missing missing | |
| 248 bi Alisa Miller: The news about the news present missing | |
| 248 zh-cn Alisa Miller: The news about the news missing present | |
| 251 zh-cn Brian Greene: Making sense of string theory missing present | |
| 267 pt Arthur Ganson: Moving sculpture present missing | |
| 272 ru Philip Zimbardo: The psychology of evil present missing | |
| 278 he George Dyson at the birth of the computer missing present | |
| 279 rup Chris Jordan: Turning powerful stats into art present missing | |
| 287 es Nellie McKay sings "Clonie" present missing | |
| 287 lv Nellie McKay sings "Clonie" missing present | |
| 301 zh A.J. Jacobs: My year of living biblically missing present | |
| 306 nl Freeman Dyson: Let's look for life in the outer solar system missing present | |
| 319 ru Kevin Kelly: The next 5,000 days of the web present missing | |
| 327 ru Lennart Green: Close-up card magic with a twist missing present | |
| 348 fa Ann Cooper talks school lunches missing present | |
| 350 fr Caleb Chung plays with Pleo missing present | |
| 356 ca Stefan Sagmeister: Designing with slogans present missing | |
| 366 es Mihaly Csikszentmihalyi: Flow, the secret to happiness missing present | |
| 371 ru Garrett Lisi: An 8-dimensional model of the universe present missing | |
| 383 af Rives: A story of mixed emoticons missing missing | |
| 383 he Rives: A story of mixed emoticons missing missing | |
| 383 id Rives: A story of mixed emoticons missing missing | |
| 383 ja Rives: A story of mixed emoticons missing missing | |
| 400 fil Ursus Wehrli tidies up art present missing | |
| 403 it Franco Sacchi tours Nigeria's booming Nollywood missing missing | |
| 405 fa Bill Joy: What I'm worried about, what I'm excited about missing present | |
| 407 as Andy Hobsbawm says: Do the green thing present missing | |
| 408 eu Gregory Petsko on the coming neurological epidemic missing missing | |
| 409 ro Richard Preston on the giant trees missing present | |
| 416 ru Dennis vanEngelsdorp: a plea for bees present missing | |
| 440 tr Peter Ward on Earth's mass extinctions missing present | |
| 441 pl Sherwin Nuland on hope present missing | |
| 451 pt-br Bill Gates: Mosquitos, malaria and education present missing | |
| 453 ru Elizabeth Gilbert: Your elusive creative genius present missing | |
| 455 nl Milton Glaser on using design to make ideas new missing present | |
| 462 ru Barry Schwartz: Our loss of wisdom present missing | |
| 463 ru Juan Enriquez: The next species of human present missing | |
| 472 ko Miru Kim's underground art missing present | |
| 473 ru Evan Williams on listening to Twitter users present missing | |
| 480 ru Don Norman: 3 ways good design makes you happy present missing | |
| 482 ru Aimee Mullins: It's not fair having 12 pairs of legs present missing | |
| 494 ro Jacqueline Novogratz on escaping poverty missing present | |
| 499 ru Nathan Wolfe's jungle search for viruses missing missing | |
| 501 pl Jacek Utko designs to save newspapers missing missing | |
| 501 ru Jacek Utko designs to save newspapers present missing | |
| 506 es Nathaniel Kahn on "My Architect" present missing | |
| 507 ru Bruce Bueno de Mesquita predicts Iran's future present missing | |
| 523 ru Erik Hersman on reporting crisis via texting missing present | |
| 524 fr Ben Katchor's comics of bygone New York missing present | |
| 532 ru Sean Gourley on the mathematics of war present missing | |
| 540 sv Hans Rosling on HIV: New facts and stunning data visuals missing missing | |
| 549 pt Mary Roach: 10 things you didn't know about orgasm missing present | |
| 587 it Arthur Benjamin: Teach statistics before calculus! present missing | |
| 589 es Daniel Libeskind's 17 words of architectural inspiration present missing | |
| 592 km Sophal Ear: Escaping the Khmer Rouge present missing | |
| 592 vi Sophal Ear: Escaping the Khmer Rouge present missing | |
| 593 hr The Top 10 TEDTalks present missing | |
| 595 es TEDx Intro 2009 present missing | |
| 622 fa Cary Fowler: One seed at a time, protecting the future of food missing present | |
| 633 de Misha Glenny investigates global crime networks missing present | |
| 637 fa Oliver Sacks: What hallucination reveals about our minds present missing | |
| 645 fr Parag Khanna maps the future of countries missing present | |
| 670 id Marcus du Sautoy: Symmetry, reality's riddle present missing | |
| 685 fa Pranav Mistry: The thrilling potential of SixthSense technology present missing | |
| 712 uk Loretta Napoleoni: The intricate economics of terrorism missing present | |
| 715 az Charles Anderson discovers dragonflies that cross oceans present missing | |
| 821 pl Jonathan Drori: Every pollen grain has a story missing present | |
| 823 ko Natalie Merchant sings old poems to life present missing | |
| 843 id Stephen Wolfram: Computing a theory of everything missing present | |
| 855 id Dan Meyer: Math class needs a makeover missing present | |
| 865 lo Ken Robinson: Bring on the learning revolution! missing missing | |
| 885 nn Margaret Gould Stewart: How YouTube thinks about copyright missing present | |
| 930 am Sheryl WuDunn: Our century's greatest injustice present missing | |
| 946 pt His Holiness the Karmapa: The technology of the heart missing present | |
| 949 pt Sugata Mitra: The child-driven education present missing | |
| 988 id David Byrne sings "(Nothing But) Flowers" missing present | |
| 1007 id Conrad Wolfram: Teaching kids real math with computers missing present | |
| 1010 pl John Hardy: My green school dream missing present | |
| 1033 el Hanna Rosin: New data on the rise of women missing present | |
| 1041 pl Majora Carter: 3 stories of local eco-entrepreneurship missing present | |
| 1051 vi Thomas Thwaites: How I built a toaster -- from scratch missing present | |
| 1056 pt Van Jones: The economic injustice of plastic present missing | |
| 1063 am Jake Shimabukuro plays "Bohemian Rhapsody" missing missing | |
| 1068 cs Suheir Hammad: Poems of war, peace, women, power missing present | |
| 1068 el Suheir Hammad: Poems of war, peace, women, power missing present | |
| 1070 uk Cynthia Breazeal: The rise of personal robots missing present | |
| 1076 zh-tw Jacqueline Novogratz: Inspiring a life of immersion missing present | |
| 1084 ar Wadah Khanfar: A historic moment in the Arab world present missing | |
| 1094 mn David Brooks: The social animal present missing | |
| 1106 nn Patricia Ryan: Don't insist on English! missing present | |
| 1117 el Jackson Browne: "If I Could Be Anywhere" missing present | |
| 1138 el Suzanne Lee: Grow your own clothes present missing | |
| 1165 el Paul Romer: The world's first charter city? missing present | |
| 1170 ko Steve Keil: A manifesto for play, for Bulgaria and beyond missing present | |
| 1209 sh Jeremy Gilley: One day of peace missing present | |
| 1220 ru Yasheng Huang: Does democracy stifle economic growth? present missing | |
| 1235 de Danielle de Niese: A flirtatious aria missing missing | |
| 1238 lt Graham Hill: Less stuff, more happiness missing missing | |
| 1250 fr Guy-Philippe Goldstein: How cyberattacks threaten real-world peace present missing | |
| 1250 vi Guy-Philippe Goldstein: How cyberattacks threaten real-world peace missing present | |
| 1259 th Paul Zak: Trust, morality -- and oxytocin? missing missing | |
| 1266 vi Ben Kacyra: Ancient wonders captured in 3D missing missing | |
| 1280 zh Phil Plait: How to defend Earth from asteroids missing present | |
| 1311 ru Alberto Cairo: There are no scraps of men present missing | |
| 1313 ca Jane Fonda: Life's third act missing present | |
| 1315 zh Sebastian Wernicke: 1000 TEDTalks, 6 words present missing | |
| 1322 bg Drew Berry: Animations of unseeable biology present missing | |
| 1323 ca Morley sings "Women of Hope" present missing | |
| 1336 el Diana Nyad: Extreme swimming with the world's most dangerous jellyfish missing present | |
| 1336 zh-cn Diana Nyad: Extreme swimming with the world's most dangerous jellyfish missing present | |
| 1360 vi Simon Berrow: How do you save a shark you know nothing about? present missing | |
| 1368 cs Tan Le: My immigration story missing present | |
| 1378 vi Bryan Stevenson: We need to talk about an injustice present missing | |
| 1382 eu A TED speaker's worst nightmare missing missing | |
| 1389 ru Jonathan Haidt: Religion, evolution, and the ecstasy of self-transcendence present missing | |
| 1390 ar Rob Reid: The $8 billion iPod missing present | |
| 1394 ja T. Boone Pickens: Let's transform energy -- with natural gas present missing | |
| 1422 sq Drew Curtis: How I beat a patent troll present missing | |
| 1425 sq Christina Warinner: Tracking ancient diseases using ... plaque present missing | |
| 1479 hu Rodney Mullen: Pop an ollie and innovate! missing missing | |
| 1547 ar Ivan Krastev: Can democracy exist without trust? missing missing | |
| 1547 fa Ivan Krastev: Can democracy exist without trust? missing missing | |
| 1553 zh-cn Candy Chang: Before I die I want to... missing missing | |
| 1564 pt-br Julian Treasure: Why architects need to use their ears missing missing | |
| 1565 tr Tristram Stuart: The global food waste scandal missing missing | |
| 1607 hu Matt Killingsworth: Want to be happier? Stay in the moment missing missing | |
| 1642 tr Jonathan Haidt: How common threats can make common (political) ground missing missing | |
| 1676 hu Wade Davis: Gorgeous photos of a backyard wilderness worth saving missing missing | |
| 1693 tr Danny Hillis: The Internet could crash. We need a Plan B missing missing | |
| 1699 ja Richard Turere: My invention that made peace with lions present missing | |
| 1718 hy John McWhorter: Txtng is killing language. JK!!! missing missing | |
| 1719 uk Robert Gordon: The death of innovation, the end of growth missing missing | |
| 1726 lt Nilofer Merchant: Got a meeting? Take a walk missing missing | |
| 1727 es Taylor Wilson: My radical plan for small nuclear fission reactors missing missing | |
| 1738 hu Ken Robinson: How to escape education's death valley missing missing | |
| 1740 ja John Legend: "True Colors" missing missing | |
| 1741 sv Meg Jay: Why 30 is not the new 20 missing missing | |
| 1742 lt Maria Bezaitis: The surprising need for strangeness missing missing | |
| 1743 uk Jay Silver: Hack a banana, make a keyboard! missing missing | |
| 1744 id Judy MacDonald Johnston: Prepare for a good end of life missing missing | |
| 1745 id Sergey Brin: Why Google Glass? missing missing | |
| 1747 cs Phil Hansen: Embrace the shake missing missing | |
| 1750 uk Ji-Hae Park: The violin, and my dark night of the soul missing missing | |
| 1756 ar Andrew Solomon: Love, no matter what missing missing | |
| 1757 tr Anas Aremeyaw Anas: How I named, shamed and jailed missing missing | |
| 1765 id George Papandreou: Imagine a European democracy without borders missing missing | |
| 1768 he Didier Sornette: How we can predict the next financial crisis missing missing | |
| 1771 ar Joseph Kim: The family I lost in North Korea. And the family I gained. missing missing | |
| 1771 sk Joseph Kim: The family I lost in North Korea. And the family I gained. missing missing | |
| 1772 es Lesley Hazleton: The doubt essential to faith missing missing |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT o.talkid, o.culture, e.altheadline, | |
| IF(o.translator_profile_id IS NULL, 'missing', 'present') AS translator_credit, | |
| IF(o.reviewer_profile_id IS NULL, 'missing', 'present') AS reviewer_credit | |
| FROM talks_i18n o | |
| INNER JOIN talks_i18n e ON (o.talkid = e.talkid AND e.culture = 'en') | |
| WHERE | |
| o.has_published_subs = 1 | |
| AND (o.reviewer_profile_id IS NULL OR o.translator_profile_id IS NULL) | |
| AND o.culture <> 'en' | |
| ORDER BY talkid, culture; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment