select SQL_CALC_FOUND_ROWS t_pro_product.product_id, t_pro_product.model_number, t_pro_product.product_name, t_pro_product.price, t_pro_product.weight, t_pro_product.model_number, t_pro_product.sales_price, t_pro_product.members_price, t_pro_product.product_img, t_pro_product.t_product_img, t_pro_product.stock_flg , t_pro_product.stock_num , t_pro_product.new_mark_flg , t_pro_product.new_mark_icon , t_pro_product.simple_expl, date_format(t_pro_product_environment.new_mark_limit,'%Y-%m-%d') as new_mark_limit from t_pro_group_product force index (order_num) left join t_pro_product on t_pro_group_product.account_id = t_pro_product.account_id and t_pro_group_product.product_id = t_pro_product.product_id left join t_pro_product_environment on t_pro_product_environment.account_id = 'PA01002222' and t_pro_product.product_id = t_pro_product_environment.product_id where t_pro_group_product.account_id = 'PA01002222' and t_pro_group_product.group_id IN ('5194') and t_pro_product.disp_flg = 0 and t_pro_product.del_flg = 0 and ( t_pro_product.stock_flg = 1 or (t_pro_product.stock_flg = 0 and t_pro_product.stock_num > 0) or (t_pro_product.stock_flg = 0 and (t_pro_product.stock_num = 0 or t_pro_product.stock_num is null) and (t_pro_product.soldoutdisp_flg = 0 or t_pro_product.soldoutdisp_flg is null ) ) ) and concat(ifnull(t_pro_product.start_date,current_date),' ',ifnull(t_pro_product.start_time,'00:00:00')) <= now() and concat(ifnull(t_pro_product.end_date,current_date),' ',ifnull(t_pro_product.end_time,'23:59:59')) >= now() group by t_pro_group_product.product_id order by t_pro_group_product.order_num is null, t_pro_group_product.order_num, t_pro_group_product.product_id desc limit 12 offset 0
Camera giám sát - HD Nha Trang

Camera giám sát

Sắp xếp theo:
Yi Outdoor Camera
Camera giám sát ngoài trời Yi Outdoor 1080p

Yi Outdoor Camera

1,790VNĐ

Thêm vào giỏ
KBVISION KX-7104TD4
ĐẦU GHI HÌNH F4 KBVISION KX-7104TD4 (4 KÊNH HDCVI + 1 KÊNH IP)

Thêm vào giỏ
KBVISION KX-2002S4
CAMERA HDCVI KBVISION KX-2002S4 (DOME 2.0 MEGAPIXEL)

KBVISION KX-2002S4

1,380VNĐ

Thêm vào giỏ

KBVISION KX-2002C4
CAMERA HDCVI KBVISION KX-2002C4 (DOME 2.0 MEGAPIXEL)

KBVISION KX-2002C4

1,220VNĐ

Thêm vào giỏ
KBVISION KX-2001S4
CAMERA 4IN1 HDCVI KBVISION KX-2001S4 (2.0 MEGAPIXEL)

KBVISION KX-2001S4

1,380VNĐ

Thêm vào giỏ
KBVISION KX-2001C4
CAMERA HDCVI KBVISION KX-2001C4 (THÂN 2.0 MEGAPIXEL)

KBVISION KX-2001C4

1,220VNĐ

Thêm vào giỏ

VANTECH VP-864A/T/C
ĐẦU GHI HÌNH 8 KÊNH ALL IN ONE VANTECH VP-864ATC

Thêm vào giỏ
VANTECH VP-464A/T/C
ĐẦU GHI HÌNH 4 KÊNH ALL IN ONE VANTECH VP-464ATC

Thêm vào giỏ
Vantech VP-2200A/T/C
CAMERA WATERPROOF 3IN1 2MP VANTECH VP-2200A/T/C

Thêm vào giỏ

Vantech VP- 2224A/T/C
CAMERA DOME 3IN1 2MP VANTECH VP-2224A/T/C

Thêm vào giỏ
Trọn Bộ Camera Không Dây NVR KIT 4 mắt
Bộ Camera Không Dây NVR KIT 4 mắt

Thêm vào giỏ
Trọn bộ 4 camera quan sát AHD J-Tech AHD5602B 2MP
Trọn bộ 4 camera quan sát AHD J-Tech AHD5602B 2MP

Thêm vào giỏ

Hỗ trợ trực tuyến

  • Kinh doanh

    ĐT: 0888884368

    Email: hdnhatrang@gmail.com

  • Kỹ thuật

    ĐT:0905281283

    Email: hdnhatrang@gmail.com

Tin mới nhất

Video giới thiệu

Like Facebook

Thống kê

Tổng lượt truy cập: 666492
Hôm nay: 242