Linh kiện »
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 FROM #_sanpham sp LEFT JOIN ( SELECT id,id_sp, MIN(gia) AS gia 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_ctch.id_thuoctinh = '6746'