select distinct eve_id, eve_img, eve_gal_id, eve_link_imdb, eve_link_kinobox, eve_link_csfd, eve_capacity,eve_stickers, eve_icons, eve_reservation, eve_reservation_link,eve_loc_id, eve_ticketprice,eve_hideprice, eve_parent_eve_id, eve_subeventsallowed, eve_evc_id as typ, evc_group,
evi_name, evi_subtitle, evi_shortinfo, evi_description,evi_video, eve_subeventsallowed, loc_name, loc_adresa_street, loc_adresa_city, loc_adresa_zip, loc_www, loc_telefon, loc_email
 from Events join Events_info on evi_eve_id=eve_id and evi_show=2 and evi_la='cz' join Events_categories ON evc_id = eve_evc_id
 left join Locations on loc_id=eve_loc_id and loc_show>0  
 where eve_id='4841' and eve_show=2