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 ('5188') 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
Android TV Box - HD Nha Trang

Android TV Box

Sắp xếp theo:
Kiwibox S2 Pro
Kiwibox S2 Pro – Giá rẻ trong phân khúc RAM 2GB

Kiwibox S2 Pro

1,190VNĐ

Thêm vào giỏ
Kiwibox T+
Kiwibox T+ tích hợp truyền hình số mặt đất

Kiwibox T+

1,290VNĐ

Thêm vào giỏ
Kiwibox S3 Pro
Android Tivi Box Kiwibox S3 PRO

Kiwibox S3 Pro

1,490VNĐ

Thêm vào giỏ

Kiwibox S1 Pro
Android TV Box Kiwibox S1 Pro Ram 2GB

Kiwibox S1 Pro

1,190VNĐ

Thêm vào giỏ
Kiwibox S1 New
Android TV Box Kiwibox S1 New 2017

Thêm vào giỏ
Vinabox X12 3G
ANDROID BOX RAM 3G - VINABOX X12 3G - ROM 16G, MẠNH MẼ CHIP S912 - 8 NHÂN.

Vinabox X12 3G

1,890VNĐ

Thêm vào giỏ

JmGO G3 Pro
Máy chiếu Android JmGO G3 Pro

JmGO G3 Pro

17,500VNĐ

Thêm vào giỏ
Mibox 4k Global
Mibox 4k Global (bản quốc tế) Android TV 6.0

Mibox 4k Global

1,590VNĐ

Thêm vào giỏ
Vinabox X2
VINABOX X2 - ANDROID BOX HÀNG CÔNG TY, GIÁ HẤP DẪN, LÕI TỨ, RAM 1G.

Vinabox X2

850VNĐ

Thêm vào giỏ

Vinabox X9
VINABOX X9 - RAM 2G, ANDROID 6.0, HÀNG CÔNG TY, 4K@60FPS

Vinabox X9

1,050VNĐ

Thêm vào giỏ
Himedia H1
Android TV Box Himedia H1

Himedia H1

1,090VNĐ

Thêm vào giỏ
HiMedia Q5 Pro
Android TV Box Himedia Q5 Pro

HiMedia Q5 Pro

2,690VNĐ

Thêm vào giỏ