Bất Động sản tương tự

select sanpham.*, huong.TieuDe as HuongNha, l.TieuDe as TenLoaiNha from sanpham left join huong on huong.id=sanpham.huong left join loainha l on l.id = sanpham.loainha where sanpham.id<>8392 AND sanpham.DaBan = 0 AND sanpham.secid = AND sanpham.TrangThai=1 ORDER BY sanpham.order_date desc, sanpham.NgayDang desc LIMIT 9