select p.*,c.is_deal,c.cat_name as catname from tbl_products p inner join tbl_category c on p.cat_id=c.cat_id
inner join tbl_employees e on p.employee_id=e.employee_id
where e.check_pincode="No" and e.status=1 and c.cat_id!="119" and c.is_deal="No" and p.status=1 and (p.product_type="" or p.product_type is NULL) and p.employee_id=2014 order by p.sale_price asc LIMIT 0,30
