all published TEDx/TEDed translations with missing translator or reviewer

data.txt

video_id, language_code, translator_credit, reviewer_credit
_WLlHpCjrmE  en	Curing Cancer with Golden Nanoparticles: Dr. Amal Ayoub at TEDxJerusalem	missing	missing
0jF9xyF8mxQ	en	If superpowers were real, which would you choose? - Joy Lin	missing	missing
0YzvupOX8Is	en	A clever way to estimate enormous numbers - Michael Mitchell	missing	missing
0YzvupOX8Is	es	Una forma inteligente de estimar números enormes - Michael Mitchell	present	missing
5UD0RjZdUHk	en	Stories: Legacies of Who We Are - Awele Makeba	present	missing
74I0M0RKNIE	en	The History of Keeping Time - Karen Mensing	missing	missing
9FCsyK4aRXQ	en	Modern Warrior: Damien Mander at TEDxSydney	missing	missing
AmFMJC45f1Q	ar	كيف يمكننا بطي الورق أن نصل الى القمر ؟	missing	missing
AmFMJC45f1Q	en	How Folding Paper Can Get You to the Moon	missing	missing
b_lT6mJM_fA	it	Biocarburanti e bioprospezione per principianti - Craig A. Kohn	missing	missing
BMcduh1HEHA	en	Alzheimer and memory palaces: Kasper Bormans at TEDxLeuven	missing	missing
C9vnuaPGxrg	en	Questions No One Knows the Answers to	missing	missing
DD_8Jm5pTLk	zh-tw	四季變化的原因 - Rebecca Kaplan	missing	missing
De5BNXTJtJQ	en	Using unanswered questions to teach - John Gensic	missing	missing
dlW0fa-FkPQ	en	The Happiness Advantage: Leda Karabela at TEDxThessaloniki	missing	missing
Dz8E8UOBFJQ	en	The Power of Simple Words - Terin Izil 	missing	missing
F8UFGu2M2gM	en	How simple ideas lead to scientific discoveries	present	missing
FjnGdiqk96Y	es	El diseño es esencial para el cambio - Kara Pecknold en TEDx Vancouver	missing	missing
FzApYQDIXlg	es	Los ingredientes de una revolución - Noah Feldman en TEDxUChicago 2012	missing	missing
GEAzWD3038Y	en	Celebrate Your Struggles: Deidre Combs at TEDxBozeman	missing	missing
Hul8htHa9AY	en	Vedat Ozan: Sense of Smell at TEDxSabanciUniversity	missing	missing
i_R7ouD8-Eo	en	How Life Begins in the Deep Ocean	missing	missing
I2apGYUX7Q0	en	Why Can't We See Evidence of Alien Life?	missing	missing
Ie8qJuXYN7w	en	The Real Origin of the Franchise - Sir Harold Evans	missing	missing
iMGRpzf2RL8	en	Poetic Stickup: Put the Financial Aid in the Bag	missing	missing
ipnc2FkRVf8	es	El color de nuestra deliberación - Juan Fernando Giraldo en TEDxTeusaquillo	missing	missing
j0_u-lourd0	en	The power of a great introduction - Carolyn Mohr 	missing	missing
KKlboo6PAO4	es	Serendipia en la pobreza: Heberto Morales en TEDx Guadalajara	missing	missing
KM4Xe6Dlp0Y	en	Cameron Russell: Looks aren't everything. Believe me, I'm a model.	missing	missing
KM4Xe6Dlp0Y	pl	Cameron Russell: Looks aren't everything. Believe me, I'm a model. 	missing	missing
kMWxuF9YW38	ar	تحديد جنس المولود أعقد مما تتخيل	present	missing
kMWxuF9YW38	en	Sex Determination: More Complicated Than You Thought	present	missing
KymR6N1HT88	en	Equality, sports, and Title IX - Erin Buzuvis and Kristine Newhall	missing	missing
LhMGK4dsgYw	en	Mysteries of vernacular: Gorgeous - Jessica Oreck and Rachael Teel	missing	missing
MBZBqNrsAPM	en	Mysteries of vernacular: Quarantine - Jessica Oreck and Rachael Teel	missing	missing
NgasyGDQDeM	en	Overcoming the scientific divide - Aaron Reedy	missing	missing
NRgWRXFXLQs	en	The magic of QR codes in the classroom - Karen Mensing	missing	missing
othM2dwi2bE	en	TEDx Introduction	missing	missing
OttRV5ykP7A	ro	Cum să accelerezi o reacție chimică	present	missing
Qq0kMEWzdHg	en	The game-changing amniotic egg - April Tucker	missing	missing
QUW_Zv_jJb8	en	How big is the ocean? - Scott Gass	missing	missing
r8ffs_MeY5M	es	Disección de la Adoración de los Reyes Magos de Botticelli - James Earle	missing	missing
rIVkvrEiVm0	en	Is there a center of the universe? - Marjee Chmiel and Trevor Owens	missing	missing
rkRbebvoYqI	pl	Jaki kolor ma środa? Badanie świata synestezji  - Richard E. Cytowic	missing	missing
rysYgMpP87k	en	TEDxFlandersSalon -Bruno De Wever- Cultural identity and historic understanding	missing	missing
rysYgMpP87k	nl	TEDxFlandersSalon -Bruno De Wever- Culturele identiteit en historisch besef	missing	missing
S8hiiy3Gksw	nl	TEDxAmsterdam 2012 Lissa Zeviar - The Art of Sign Language: for Babies, Boobs and Bobs	missing	missing
sd6OLoQW0hY	ja	TEDxTokyo -  Yoshie Komuro -  Life Balance  -  [日本語]	missing	missing
tr4gWi9Jf6k	en	The Cockroach Beatbox	missing	missing
tr4gWi9Jf6k	sk	Švábí beatbox 	missing	missing
UBIO8vWO6Cs	es	La innovación en lo humano: Jaume Mateu en TEDxLaRioja	missing	missing
UPA3bwVVzGI	es	¿Cómo de infinito es el infinito?	present	missing
Uqly8ERIkHM	en	Deep ocean mysteries and wonders - David Gallo	missing	missing
UVjMOxsbJGk	es	¿Qué es la arquibiótica?: Vincent Callebaut en TEDxNantes	missing	missing
UZ5UGnU7oOI	en	What is color? - Colm Kelleher	missing	missing
V8miLevRI_o	en	Vermicomposting: How worms can reduce our waste - Matthew Ross	missing	missing
vdCjKH5IKJ8	en	Insults by Shakespeare	present	missing
w-YLJ-pHRhA	en	If superpowers were real: Invisibility - Joy Lin	missing	missing
xFQ_fO2D7f0	es	La vida secreta del plancton	missing	missing
xFQ_fO2D7f0	hu	A plankton titkos élete	missing	present
xFQ_fO2D7f0	ja	謎に満ちたプランクトンの生態	missing	missing
XNjvipiJTjY	es	Diagnosticando a un zombie: cerebro y comportamiento - Tim Verstynen & Bradley Voytek	missing	missing
yQP4UJhNn0I	it	Ma quanto è piccolo un atomo?	present	missing

query.sql

SELECT video_id, language_code, title, 
  IF(author_id IS NULL, 'missing', 'present') AS translator_credit,
  IF(reviewer_id IS NULL, 'missing', 'present') AS reviewer_credit
FROM amara_subtitle
WHERE
  STATUS = 'published'
  AND (author_id IS NULL OR reviewer_id IS NULL)
ORDER BY video_id, language_code;