비교검색


  • 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
상품정렬 : 인기도순  브랜드순  분류순  낮은가격순  높은가격순 134개의 상품이 검색되었습니다.
사진 상품정보 규격정보 판매가격
16,720
24,530
3,190
54,670
34,650
40,810
13,310
35,640
18,040
23,100
20,020
25,300
모델 전장 판매가
YP-3.0 1,790~3,040 56,430
56,430
모델 전장 판매가
DE-2131 3,000 45,870
DE-2232 3,000 68,090
DE-3232 3,000 82,720

1.. more

45,870
모델 전장 판매가
DG-7320 2,400 36,740
36,740
16,280
모델 전장 판매가
S-430 1,260~3,000 58,410
S-440 1,600~4,000 65,670
S-450 1,940~5,000 73,040

1.. more

58,410
모델 전장 판매가
CUAH2.1 1,950 71,830
CUAH3.6 1,880~3,600 106,920
CUAH4.1 1,330~4,100 122,650

3.. more

122,650
27,830
14,850

1 2 3 4 5 6 7