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:
FPT Play Box
FPT Play Box: TV Box hàng đầu Việt Nam

FPT Play Box

1,390VNĐ

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

790VNĐ

Thêm vào giỏ
Vinabox X9
VINABOX X9 - RAM 2G, ANDROID 6.0, HÀNG CÔNG TY, 4K@60FPS

Vinabox X9

1,190VNĐ

Thêm vào giỏ

Himedia H1
Android TV Box Himedia H1

Himedia H1

1,190VNĐ

Thêm vào giỏ
Himedia H8 Plus
HIMEDIA H8 Plus cấu hình cực khủng cùng chip lõi 8, ram 2G, Rom 16G, Android 5.1

Himedia H8 Plus

2,350VNĐ

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

HiMedia Q5 Pro

2,790VNĐ

Thêm vào giỏ

FPT Play Box 4K
FPT Play Box: TV Box hàng đầu Việt Nam

FPT Play Box 4K

1,490VNĐ

Thêm vào giỏ
Himedia Q10 Pro
Android TV Box kiêm HD Player Himedia Q10 Pro

Himedia Q10 Pro

3,590VNĐ

Thêm vào giỏ
Himedia A5
Himedia A5 - Lõi tám AmlogicS912, Android 6.0, RAM 2GB

Himedia A5

2,390VNĐ

Thêm vào giỏ