SELECT i.*, cait.`ca_id`, sum(i2.`it_nomatter_qty` = 1 OR i2.`it_stock_qty` > 0 OR i.`it_nomatter_qty` = 1 OR i.`it_stock_qty` > 0) > 0 as selling, COUNT(i.`it_id`)>1 as has_sub_item FROM `yc4_item` i JOIN `shop_on_ca_it` cait ON i.it_id = cait.it_id LEFT JOIN `yc4_item` i2 ON i.it_id = i2.`it_subequal_target_id` WHERE cait.`ca_id` LIKE '0620%' and i.`it_use` = '1' AND (i.`it_subequal_target_id` = '' OR i.`it_subequal_target_id` = i.`it_id`) GROUP BY cait.`ca_id`, i.it_id order by cait.`ca_id`, it_amount%20asc , it_name, it_order, i.it_id desc limit 0, 200
1052 : Column 'it_amount' in order clause is ambiguous
error file : /shop/list.php