SELECT sp.id_code, sp.ten, sp.id_loai, sp.id_price, sp.id_brand, sp.alias, sp.so_thu_tu, sp.hinh_anh, sp.id_spct_instead, sp.sp_sale, sp.tieu_bieu, sp_ch_min.gia AS min_price, sp_ch_min.gia_lo AS price_lo, sp_ch_min.gia_hi AS price_hi FROM #_sanpham sp LEFT JOIN ( SELECT id, id_sp, MIN(gia) AS gia, MIN(NULLIF(gia,0)) AS gia_lo, MAX(NULLIF(gia,0)) AS gia_hi FROM #_sanpham_cauhinh GROUP BY id_sp ) AS sp_ch_min ON sp_ch_min.id_sp = sp.id_code LEFT JOIN #_sanpham_chitietcauhinh sp_ctch ON sp_ctch.id_cauhinh = sp_ch_min.id WHERE sp.hien_thi = 1 AND ( sp.id_loai IN (114) OR FIND_IN_SET(114, sp.id_cates) ) GROUP BY sp.id_code ORDER BY sp.id

Bản lề

Sắp xếp theo: Nổi bật Giảm giá Giá thấp đến cao Giá cao đến thấp

Bộ bàn phím chuột Logitech MK200 (Đen) – Bền bỉ, gõ êm, chính hãng - Vietitpro.vn

360,000 đ

Còn hàng