SELECT id,location_id,eventgroup_id,eventrule_id,region_id,created_by_user_id,changed_by_user_id,name,is_active,is_profi_event,description,date,start_date,end_date,created_at,changed_at,admission,flyer_original,flyer_small,flyer_index,eventtypes,credit_points,likes,credit_notice,pictures,views,old_id,linkedCity_id,raffle_id,ticket_url,total_picture_views,category,is_fullscreen_gallery_enabled,comments,total_users_tagged,is_repaired,soundcloud_link,youtube_link,introduction,special_landingpage,needs_approval,has_flyer,special_priority,source_id,is_renewed,is_premium FROM events WHERE date = "2019-06-23" AND is_active = 1 AND linkedCity_id IN (14,39,43,88,291,474,510) ORDER BY date ASC, is_premium DESC