MySQL error:
[2024-03-19T12:54:55+03:00] [1146] Error: Table 'champio2_vyborg.schedule_ex_digit' doesn't exist / Invalid query string: SELECT s.*, (SELECT e.date_start FROM schedule_ex_digit e WHERE e.par_id = s.id ORDER BY e.date_start DESC LIMIT 1) as date_last FROM schedule_digit s WHERE ((DATE(s.date_end) > CURDATE()) OR (DATE(s.date_end)=0) OR (DATE(s.date_end) IS NULL)) AND ( (((DATE(s.date_start) <= DATE_ADD(CURDATE(),INTERVAL 7 DAY)) OR (DATE(s.date_start)=0) OR (DATE(s.date_start) IS NULL)) AND s.type = 10) OR ((DATE(s.date_start) <= DATE_ADD(CURDATE(),INTERVAL 7 DAY)) AND s.type = 20) ) AND NOT EXISTS ( SELECT e.* FROM schedule_ex_digit e WHERE e.par_id = s.id AND ( ((DATE(e.date_start) > CURDATE()) AND (DATE(e.date_start) <= DATE_ADD(CURDATE(),INTERVAL 7 DAY))) /*правило (e1)*/ OR (DATE(e.date_start) >= DATE_ADD(CURDATE(),INTERVAL 7 DAY)) /*PAE202003 - правило (e2) Для случая когда ушли вперед*/ ) LIMIT 1 ) Referer: / In: ->sch_ex_task_EXEC --> allTasks->schedule_ex --> ->task_run