A Database Error Occurred

Error Number: 1055

Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'fos.rtc.menuid' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

SELECT rtc.restaurantid, count(rtc.menuid) as total,rtc.menuid,rtc.addeddate,rest.restaurant_name,rest.restaurant_seourl ,rest.restaurant_state,rest.restaurant_city, rsm.menu_name,rsm.menu_price,rsm.menu_photo,rsm.menu_description FROM `rt_restaurant_cart` as rtc left join rt_restaurant as rest on rest.restaurant_id=rtc.restaurantid left join rt_restaurant_menu as rsm on rsm.id=rtc.menuid where rsm.status=1 AND rest.restaurant_id!=846 /*where rtc.addeddate BETWEEN CURDATE() - INTERVAL 45 DAY AND CURDATE()*/ GROUP by rtc.restaurantid ORDER BY total DESC LIMIT 6

Filename: /var/www/html/www.tuckeat.com/controllers/frontend.php

Line Number: 170