[2020-04-07T10:23:56+03:00] Error: Unknown column 'c.closed' in 'where clause' / Invalid query string: SELECT s.* ,(SELECT e.date_start FROM online_schedule_ex e WHERE e.par_id = s.id ORDER BY e.date_start DESC LIMIT 1) as date_last ,('2020-05-05') as date_max FROM online_schedule s INNER JOIN online_centers c ON c.id = s.par_id WHERE NOT s.hidden AND NOT c.closed AND ((s.date_end > '2020-04-29') OR (s.date_end = 0) OR (DATE(s.date_end) IS NULL)) AND ((s.date_start <= '2020-05-05') OR (s.date_start = 0) OR (DATE(s.date_start) IS NULL)) AND NOT EXISTS ( SELECT e.* FROM online_schedule_ex e WHERE e.par_id = s.id AND ((e.date_start > '2020-04-07') AND (e.date_start >= '2020-04-29')) ) LIMIT 30 (1054) Referer: /razvitie/centers/montazh-foto-video/
MySQL error