Query: SELECT `BookingOrdersDate`.`selected_date` AS `selected_date`, SUM(`BookingOrder`.`people_num`) + 1 AS `people_num` FROM `booking_orders_dates` AS `BookingOrdersDate` JOIN `booking_orders` AS `BookingOrder` ON (`BookingOrdersDate`.`order_id` = `BookingOrder`.`id`) JOIN `booking_items` AS `BookingItem` ON (`BookingOrder`.`booking_item_id` = `BookingItem`.`id`) WHERE `BookingOrder`.`booking_item_id` = AND `BookingOrder`.`status` IN ('paid', 'paid_full', 'completed') GROUP BY `BookingOrdersDate`.`selected_date` ORDER BY `BookingOrdersDate`.`selected_date`
Warning: SQL Error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND `BookingOrder`.`status` IN ('paid', 'paid_full', 'completed') GROUP BY ' at line 9 in /home/fesdev/public_html/cake/libs/model/datasources/dbo_source.php on line 463