Database error: Invalid SQL: SELECT p.product_id, c.category_name_1, p.product_name_1, p.rotation_code, SUM((datediff(oi.departure_date, oi.arrival_date)*86400)+(oi.dropoff_time-oi.pickup_time)) as `order_duration` FROM product p JOIN category c ON(c.category_type="C") JOIN product_category_xref pcx ON(c.category_id=pcx.category_id AND p.product_id=pcx.product_id) JOIN product p2 ON(p2.product_parent_id=p.product_id OR p2.product_id=p.product_id) LEFT JOIN order_item oi ON(oi.product_id=p2.product_id) WHERE p.product_parent_id=0 AND p.product_publish="Y" GROUP BY p.product_id ORDER BY `order_duration` DESC;
MySQL Error: 1055 (Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'rqumdakx_imscart.c.category_name_1' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by)
possibly on page shop/browse