Left Join

select g.description,p.`date`,starttime,endtime,r.`date` from playlist p left join sendrecord r on p.`date`=r.`date`and p. playergpid=r.playergpid,playergp g
where p.playergpid=g.playergpid
and mediaId=119