Error 500

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'publish_start_date' in 'where clause' (SQL: select count(*) as aggregate from `stay_rooms` inner join (select `object_id`, MAX(updated_at) AS max_date from `stay_rooms` where (`approval_status` = 1) group by `object_id`) max_table on `max_table`.`object_id` = `stay_rooms`.`object_id` and `max_table`.`max_date` = `stay_rooms`.`updated_at` where (`status` = 1) and (`approval_status` = 1) and ((`publish_start_date` is null and `publish_end_date` is null) or (`publish_start_date` <= 2021-10-25 11:58:37 and `publish_end_date` >= 2021-10-25 11:58:37)) and (`is_featured` = 1))

Back To Home