비교검색


  • You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '&& GC.cate_index<100000000 GROUP BY GC2.cate_num ORDER BY GC2.cate_ind' at line 7
    SELECT
    GC2.cate_num, GC2.cate_name, GC2.cate_index From
    NT_admin.Goods as ntG
    left join Goods as G using(goods_num)
    left join Goods_Category as GC using(cate_num)
    left join Goods_Category as GC2 on GC2.cate_index=truncate(GC.cate_index,-4)
    WHERE ntG.brd_num="" && GC.cate_index>= && GC.cate_index<100000000
    GROUP BY GC2.cate_num
    ORDER BY GC2.cate_index ASC
상품정렬 : 인기도순  브랜드순  분류순  낮은가격순  높은가격순 47개의 상품이 검색되었습니다.
사진 상품정보 규격정보 판매가격
모델 규격 판매가
KF-ICC06 6 14,190
KF-ICC10 10 18,260
14,190
80,080
모델 규격 판매가
63225 6.5 35,860
35,860
모델 규격 판매가
63215 6.5 33,220
33,220
60,060
66,220
27,170
570,570
135,630
112,970
57,640
36,740
모델 규격 판매가
95 16 165 SB 6.5 77,990
95 16 160 SB 6 78,210
95 16 200 SB 8 97,130
77,990
모델 규격 판매가
95 11 165 SB 6.5 47,960
95 11 200 SB 8 72,600
95 12 200 SB 8 86,020

2.. more

47,960
280,500
5,940
82,390
25,520
14,190
12,650

1 2 3