LEFT JOIN con solo un registro

[PIRRUMAN]

Gracias , lo intente pero demora bastante el query alguna idea de optimizarlo?

SELECT A.phone_number,CASE WHEN B.start_time IS NULL THEN A.call_date
ELSE B.start_time END as fecha,CASE WHEN B.start_time IS NULL THEN
A.length_in_sec ELSE B.length_in_sec END as duracionseg,C.user,A.status,B.filename,B.location
FROM asterisk.vicidial_log A

//ASI LO TENIA Y ME DUIPLICABA RESULTADOS
LEFT JOIN recordig_log B

// ASI LO INTENTE
LEFT JOIN (SELECT MAX(length_in_sec) length_in_sec, vicidial_id,start_time,filename,location FROM recording_log GROUP BY vicidial_id) B

//ASI CON UNA VISTA
LEFT JOIN Vtblrecording B


ON A.uniqueid=B.vicidial_id

LEFT JOIN vicidial_users C ON
A.user=C.user WHERE A.campaign_id='00000002'
AND ( A.status='A' OR A.status='AB' OR A.status='ADC' OR A.status='B'
OR A.status='BROMA' OR A.status='CALLBK' OR A.status='CANCEL'
OR A.status='DC' OR A.status='DEC' OR A.status='DNC'
OR A.status='DROP' OR A.status='ENC' OR A.status='ENCARQ'
OR A.status='ENCEXP' OR A.status='ENCINC' OR A.status='INCALL'
OR A.status='INCLON' OR A.status='INFGEN' OR A.status='INFPRO'
OR A.status='MALHIS' OR A.status='N' OR A.status='NA' OR A.status='NI'
OR A.status='NOCONT' OR A.status='NOEXI' OR A.status='NOINT'
OR A.status='NTDD' OR A.status='PDP' OR A.status='PDROP' OR A.status='PRUE'
OR A.status='PTP' OR A.status='REGIST' OR A.status='SALE' OR A.status='SEGUIM'
OR A.status='SINCON' OR A.status='YACTE' OR A.status='YAENCU' )
AND date(A.call_date) >='2012-02-13' AND date(A.call_date) <='2012-02-13'

con lo que me indicaste y con la vista me demora bastante el query
mi vista es:

SELECT MAX(length_in_sec) length_in_sec, vicidial_id,start_time,filename,location FROM recording_log WHERE vicidial_id!="" GROUP BY vicidial_id;

coloque lenght_in_sec como un indice

de antemano gracias