select a.ct_id,
a.it_id,
a.it_name,
a.ct_price,
a.ct_point,
a.ct_qty,
a.ct_status,
a.ct_send_cost,
b.ca_id,
b.ca_id2,
b.ca_id3
from g5_shop_cart a left join g5_shop_item b on ( a.it_id = b.it_id )
where a.od_id = '2022081214014459' and substring(a.ct_time, 1, 10) >= '2018-06-23' group by a.it_id order by a.ct_id
1055 : Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'vreduzone_db.a.ct_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
error file : /shop/cart.php