album / name artist(s) label role/credit date chart#
album \\/ name
artist -lrb- s -rrb-
label
role\\/credit
date
chart #
list length
list length
number parsed year month day
text <ct,text> text <c,text> date text
rainbow mini album enomoto atsuko avex, japan songwriter september 15, 2004 no.1 oricon japan dvd chart
gold
which label was he a part of after pony canyon , japan in 2007 ?
WDT NN VBD-AUX PRP DT NN IN IN NN NNP , NNP IN CD .
Johnny's Entertainment, Japan
select c3 from w where id = ( select max ( id ) from w where c3 = 'pony canyon, japan' and c5_year = 2007 ) + 1