S0 / C0     장바구니   주문배송조회   상품리뷰   고객센터   모바일버젼
비교검색

분류 _

  • 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 '&& cate_index<100000000 && right(cate_index,6)!="000000" && GC.cate_view="V" && ' at line 8
    SELECT
    cate_num, cate_name From
    NS_main.Goods_Category as GC
    left join NS_main.Goods as G using(cate_num)
    left join NT_admin.Goods as ntG using(goods_num)
    left join NT_admin.Brand as ntB using(brd_num)
    left join NT_admin.Goods_price as ntGP using(goods_num)
    WHERE cate_index>= && cate_index<100000000 && right(cate_index,6)!="000000" && GC.cate_view="V" && goods_view="V" && brd_view="V" && gs_view="V"
    GROUP BY truncate(cate_index,-4)
    ORDER BY rand()
    LIMIT 12
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 ') && instr(CS.st_option,"B") && CS.cs_num=GS.cs_num && GC2.cate_index>= && GC2.c' at line 11
SELECT
CS.cs_num, st_name, unit_name, CS.st_option, S.st_option as st_type From
NT_admin.Category_standard as CS
left join NT_admin.Standard as S using(st_num)
left join NT_admin.Standard_unit as SU using(unit_num)
left join Goods_Category as GC using(cate_num),
NT_admin.Goods_standard as GS
left join NT_admin.Goods as G using(goods_num)
left join Goods as G2 on G2.goods_num=G.goods_num
left join Goods_Category as GC2 on GC2.cate_num=G2.cate_num
WHERE CS.cate_num in (0,) && instr(CS.st_option,"B") && CS.cs_num=GS.cs_num && GC2.cate_index>= && GC2.cate_index<100000000
GROUP BY CS.cs_num
ORDER BY instr(CS.st_option,"A") DESC, instr(CS.st_option,"Z") ASC, GC.cate_index ASC, CS.st_sort ASC
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 '&& cate_index<100000000) GROUP BY ntG.goods_num ORDER BY goods_level DESC, ' at line 15
SELECT
cate_num,
G.goods_num, goods_name,
if(brd_group>0,brd_group,brd_num) as brd_num,
if(brd_group>0,(SELECT brd_name FROM NT_admin.Brand WHERE brd_num=B.brd_group),brd_name) as brd_name,
ntGP.gs_num, gs_sint,
min(TNS_Price(ntGP.gs_num)) as goods_price1,
max(TNS_Price(ntGP.gs_num)) as goods_price2 FROM
Goods as G
left join Goods_Category as GC using(cate_num)
left join NT_admin.Goods as ntG using(goods_num)
left join NT_admin.Brand as B using(brd_num)
left join NT_admin.Goods_price as ntGP using(goods_num)
left join NT_admin.Goods_stock as ntGS using(gs_num)
WHERE ntG.goods_num>3 AND cate_view="V" AND brd_view="V" AND gs_view!="H" AND goods_view!="H" AND gs_bprice>=1 && (cate_index>= && cate_index<100000000)
GROUP BY ntG.goods_num
ORDER BY goods_level DESC, brd_level DESC, G.goods_num DESC, gs_sort ASC
0 개의 상품이 검색되었습니다.

검색된 상품이 없습니다.

개인정보취급방침 | 이용약관 | 사업자정보확인 | 주문배송조회 | 고객센터 | 상품리뷰 | 상품문의 | 모바일버젼
  • 통신판매신고 : 2011-대구서구-0003
  • 결제대금예치업(에스크로) 등록 : A08-150825-001
  • 사업자번호 : 504-18-11305
  • 상호 : 툴앤샵, 대표 : 곽장표외 1명(이일우)
  • 주소 : 대구광역시 서구 북비산로81길 1번지 (비산동)
  • 전화 : 010-6242-0989, 팩스 : 053-557-0912
  • 견적,문의 이메일 : toolnshop@toolnshop.kr
  • 개인정보보호담당 : 이일우
  • Copyright ⓒ 2020 tool&shop All right reserved.