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-10-12" AND is_active = 1 AND linkedCity_id IN (42,53,59,100,142,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,414,434,481,484,503,504) ORDER BY date ASC, is_premium DESC