select * from tbl_product,tbl_productinfo where tbl_product.product_id=tbl_productinfo.prod_id and tbl_productinfo.cat_id='47' and tbl_product.product_id!='995' order by tbl_product.product_id desc limit 0,4