year league record finish manager playoffs notes
year
league
record
finish
manager
playoffs
notes
number
number number1 number2
first second first_number
list length
number text score rank(text) <f,text> text text
1947 sunset league 69-69 4th (t) thomas lloyd league champs channel cities moved to reno july 1
who was the previous manager of the california league before ray perry ?
WP VBD-AUX DT JJ NN IN DT NNP NN IN NNP NNP .
Leonard Noren
select c5_list from w where c2 = 'california league' and c1_number < ( select c1_number from w where c5_list = 'ray perry' ) order by id desc limit 1