Program
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>=1675554311 OR actions.end_date>=1675554311) AND (actions.team=6 OR actions.extended1=6 OR actions.extended2=6 OR actions.extended3=6) AND actions.visible=1 AND actions.todelete=0 GROUP BY actions.id ORDER BY actions.top DESC, actions.start_date ASC LIMIT 300Omlouváme se, program ještě není připraven.
