select a.*,b.name1, b.name2, b.desc1, b.desc2,b.score1, b.score2 from event_template_utf8 as a left outer join event_vote as b on a.id=b.event_id where a.name='RongRaiAxPremeNobu' and a.record_status=1 and a.category_id='hitz'