솔루션 > 업종별 솔루션
상품 1 개
-
[ErrMsg] Unknown column '20desc' in 'order clause'
[function] getDataPage
[query] SELECT A.sp_idx, A.sp_code, A.sp_name, A.sp_model, A.sp_price1, A.sp_price2, A.sp_price3, A.sp_event, B.si_file1 FROM ss_product A LEFT JOIN ss_product_images B ON A.sp_idx=B.sp_idx WHERE A.sp_useYn='Y' AND A.sc_code1 ='9' AND A.sc_code2 ='2' ORDER BY A.sp_price3%20desc LIMIT 0, 40------------