SELECT actions.top AS top, actions.start_date, actions.end_date, actions.showdate AS showdate, actions.id AS id, actions.team AS team, actions.act_id AS act_id, actions.extid AS extid, actions.tickettype, actions.price AS newprice, actions.note, actions.dgextravalues, actions.dabing AS dabingnew, actions.duration, actions_detail.subject AS subject, actions_detail.meta_name AS meta_name, actions_detail.dabing AS dabing, actions_detail.type AS type, actions_detail.extype AS extype, actions_detail.basicinfo AS basicinfo, actions_detail.price AS price, actions_detail.perex AS perex, actions_detail.detail AS detail, MIN(photo.photo_id) AS photo FROM actions_detail LEFT JOIN photo ON actions_detail.id=photo.actions_id LEFT JOIN actions ON actions_detail.id=actions.act_id WHERE (actions.start_date>=1680320936 OR 1680320936<=(actions.end_date+68400)) AND actions_detail.team=3 AND actions.visible=1 AND actions.todelete=0 GROUP BY actions.id ORDER BY actions.top DESC, actions.start_date ASC LIMIT 3
