日期:2014-05-16 浏览次数:20821 次
sqlString = "select v.voice_file_id,time_to_sec(v.duration) as duration, " +
"v.audio_channel,v.create_time, s.confidence_score,s.phrase_id, " +
"time_to_sec(s.start_time) as start_time, time_to_sec(s.end_time) as end_time " +
"from (select confidence_score, phrase_id, start_time, end_time, voice_file_id " +
"from search_job_result limit "+(j * 100000)+",100000"+") s, voice_file v where s.voice_file_id = v.voice_file_id";