추가할 만한 상품

select *, ifnull(if(it_option_type='' or it_option_type='radio', case when it_price10>0 and 10<='1' then it_price10 when it_price9>0 and 9<='1' then it_price9 when it_price8>0 and 8<='1' then it_price8 when it_price7>0 and 7<='1' then it_price7 when it_price6>0 and 6<='1' then it_price6 when it_price5>0 and 5<='1' then it_price5 when it_price4>0 and 4<='1' then it_price4 when it_price3>0 and 3<='1' then it_price3 when it_price2>0 and 2<='1' then it_price2 else it_price end, concat(case when io_price10>0 and 10<='1' then io_price10 when io_price9>0 and 9<='1' then io_price9 when io_price8>0 and 8<='1' then io_price8 when io_price7>0 and 7<='1' then io_price7 when io_price6>0 and 6<='1' then io_price6 when io_price5>0 and 5<='1' then io_price5 when io_price4>0 and 4<='1' then io_price4 when io_price3>0 and 3<='1' then io_price3 when io_price2>0 and 2<='1' then io_price2 else io_price end, ',', case when io_out10>0 and 10<='1' then io_out10 when io_out9>0 and 9<='1' then io_out9 when io_out8>0 and 8<='1' then io_out8 when io_out7>0 and 7<='1' then io_out7 when io_out6>0 and 6<='1' then io_out6 when io_out5>0 and 5<='1' then io_out5 when io_out4>0 and 4<='1' then io_out4 when io_out3>0 and 3<='1' then io_out3 when io_out2>0 and 2<='1' then io_out2 else io_out end)), 0) as io_price from `g5_shop_item` a where it_use = '1' and it_type1 = '1' order by it_order, it_id desc limit 0 , 10

1054 : Unknown column 'io_price10' in 'field list'

error file : /shop/cart.php