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:
Android Tivi Box Xiaomi Mibox S 4K
Android Tivi Box Xiaomi Mibox S 4K

Thêm vào giỏ
FPT Play Box+ 2019
FPT Play Box+ 2019

FPT Play Box+ 2019

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

990VNĐ

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

Himedia Q10 Pro

3,390VNĐ

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

Himedia A5 Octa

2,300VNĐ

Thêm vào giỏ