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='amazon' 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
