BEST 100

어머!? 이건 사야해! 요즘 가장 사랑받는 인기제품들

Product type

접기

Price

접기

Discount

접기

    select * from ( select a.it_id, a.it_delivery_type, a.it_stock, a.category_id, a.area_id, a.it_img_l, a.it_name, a.it_price_type, a.it_discount_rate, a.it_price1, a.it_price2, b.wr_category, it_money, it_money_type, it_delivery, a.it_now_cnt, a.it_english_url, a.it_paydate, a.it_sales, a.it_star, a.it_popular, a.it_hot, a.it_simple_title , @rank:=@rank+1 as rank from nfor_item a join nfor_item_category b on a.category_id = b.category_id and b.wr_depth = 3 JOIN (select @rank:=0) r where it_payenddate >='2019-07-16 09:04:07' and a.category_id like '002%' and it_show = '1' order by it_popular desc , it_paydate desc limit 0, 100 ) a where 1 = 1 order by it_popular desc,it_datetime desc, rank, a.it_paydate desc

    1054 : Unknown column 'it_datetime' in 'order clause'

    error file : /index.php