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 = 'PA01001470' and t_pro_product.product_id = t_pro_product_environment.product_id where t_pro_group_product.account_id = 'PA01001470' and t_pro_group_product.group_id IN ('3676') 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
- HP Elitebook | Dell | ThinkPad | WorkStation | Laptop LÊ SƠN

Tổng đài Hỗ trợ

  • Laptop Lê Sơn Hà nội

    ĐT: 09.1800.2220 - 096.696.4334

    Email: laptopleson.usa@gmail.com

  • Laptop Lê Sơn Sài gòn

    ĐT:09.1900.2220 - 096.695.1234

    Email: laptopleson.usa@gmail.com

  • Chủ sở hữu

    Laptop LÊ SƠN

    Mời Bạn liên hệ trực tiếp qua điện thoại : *** Hotline Hà Nội : 09.1800.2220 - 096.695.1234 Địa chỉ : số 2.8 tầng 2 tòa nhà i9 ngõ Ngõ 13 Khuất Duy Tiến - Thanh xuân Bắc - Thanh xuân - Hà nội. *** Hotline Sài gòn : 09.1900.1220 Địa chỉ : 688/87 Quang Trung - Quận Gò Vấp - TP Hồ Chí Minh.

    Blog

    Facebook Lê Sơn

    Like Facebook/h3>

    Video giới thiệu

    Giá trên 15 triệu đến 20 triệu

    Sắp xếp theo:
    Laptop Dell Precision M4800/4900MQ-K2100M USA
    Laptop Dell Precision M4800/4900MQ-K2100M USA

    Thêm vào giỏ
    Laptop Dell Precision M6700 Mobile Workstation
    Laptop Dell Precision M6700 Mobile Workstation - Laptop Lê Sơn

    Thêm vào giỏ