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