select * from couponsmain where favoriteMerchant = 1 and rating > 23 and status = 'active' and DATE( enddate ) >= Date( Now() ) GROUP BY(merchantname) order by startdate desc Limit 21,21 Previous