select fn.*, category.categoryName,category.categoryId,category.categoryTitle,category.cat_slug from (SELECT offercoupon.slNo,offercoupon.storeId,offercoupon.type,offercoupon.title,offercoupon.offercoupon_slug,offercoupon.category from offercoupon WHERE offercoupon.storeId='adda52' and offercoupon.expiry >=NOW() GROUP BY offercoupon.slNo) fn inner join category on(find_in_set(category.categoryId,fn.category) and category.status='1') GROUP BY category.categoryName

Get secret cashback in your Inbox

Subscribe with India Shoppers
Provide you Cashbacks worth more than Rs.250