year title role notes
year
title
role
notes
number
list length list_first list_second
list length
number text <f,text(text)> <n, text>
1987 frog kathy television movie
which film is under the year of 1999 and has the role of mandy murphy ?
WDT NN VBD-AUX IN DT NN IN CD CC VBD-AUX DT NN IN NNP NNP .
Any Given Sunday
select c2 from w where c1 = 1999 and c3_list = 'mandy murphy'