select tbl_sanpham.id, tbl_sanpham.tensanpham, tbl_sanpham.giaban, tbl_sanpham.giakhuyenmai, tbl_sanpham.anh1, tbl_sanpham.parent, tbl_sanpham.urltuybien from tbl_sanpham JOIN tbl_log_website ON tbl_log_website.parent = tbl_sanpham.id where tbl_log_website.status<>1 and (tbl_log_website.cat=2120) order by tbl_sanpham.sort asc, tbl_sanpham.Date_added desc limit 0,120