Compare Cashback Rebate Offers for Stores
Follow Us:
Check Cashback Offers For Your Favorite Stores:
CashBackBin helps you find and compare cashback offers for your favorite stores.
|
Cashback Rewards
Points/Miles Rewards
|
||||||||||||
ⓘ If you purchase something through a link on our site, GiftCardPlace may get a small share of the sale.
1 Hai Casback Tags:
1 Hai cashback comparison,
1 Hai cash back comparison,
1 Hai rebate comparison
,
Relavant Stores:
Amazon - 5% ,
Staples - 19.5% ,
Lowe's - 18% ,
Apple Store - 4% ,
Bed Bath & Beyond - 10% ,
Dick's Sporting Goods - 5% ,
Best Buy - 5% ,
Bloomingdale's - 18.1% ,
Kohl's - 14.6% ,
Macy's - 18.8% ,
Don't miss out 1 Hai Cashback when you shop at 1 Hai. 1 Hai cashback may be combined with 1 Hai coupons. Cashbackbin helps you find the highest 1 Hai cashback rebate rates as well as 1 Hai Airline mileage rewards and 1 Hai Hotel Points by comparing reputable cashback vendor offers. 1 Hai cashback rates vary for each cashback vendor and be sure to visit Cashbackbin for the latest 1 Hai cashback offer rates. Save more with 1 Hai cashback.
1 Hai
Test1
| Cashback Rewards Top | |||
|---|---|---|---|
| Portal | Rate | Signup Bonus | |
No cash back offers are available for this store. |
|||
| Points / Miles Rewards Top | |||
|---|---|---|---|
| Portal | Rate | Signup | |
|
Hilton HHonors | 15 pt./$ | Apply |
If you purchase something through a link on our site, GiftCardPlace may get a small share of the sale.
Don't miss out 1 Hai Cashback when you shop at 1 Hai. 1 Hai cashback may be combined with 1 Hai coupons. Cashbackbin helps you find the highest 1 Hai cashback rebate rates as well as 1 Hai Airline mileage rewards and 1 Hai Hotel Points by comparing reputable cashback vendor offers. 1 Hai cashback rates vary for each cashback vendor and be sure to visit Cashbackbin for the latest 1 Hai cashback offer rates. Save more with 1 Hai cashback.
ⓘ If you purchase something through a link on our site, GiftCardPlace may get a small share of the sale.
1 Hai Casback Tags :
1 Hai cashback comparison,
1 Hai cash back comparison,
1 Hai rebate comparison,
,
Relevant Stores :
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from rtm.cashback_dollars)) AS retailmenot_cashback_dollars, TRIM(TRAILING '.' ' at line 1
SELECT m.manufacturers_name, m.manufacturers_alias, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from ajm.cashback_percent)) AS activejunky_cashback_percent, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from bfm.cashback_percent)) AS befrugal_cashback_percent, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from cm.cashback_percent)) AS citi_cashback_percent, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from ccm.cashback_percent)) AS couponcactus_cashback_percent, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from ddm.cashback_percent)) AS discover_deals_cashback_percent, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from dlr.cashback_percent)) AS dollardig_cashback_percent, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from di.cashback_percent)) AS dubli_cashback_percent, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from ebm.cashback_percent)) AS ebates_cashback_percent,from rtm.cashback_dollars)) AS retailmenot_cashback_dollars, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from exb.cashback_percent)) AS extrabux_cashback_percent, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from erb.cashback_percent)) AS extrarebates_cashback_percent, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from gsm.cashback_percent)) AS givingassistant_cashback_percent, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from gbm.cashback_percent)) AS gocashBack_cashback_percent, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from gbs.cashback_percent)) AS greenbackstreet_cashback_percent, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from hdm.cashback_percent)) AS hoopladoopla_cashback_percent, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from fcm.cashback_percent)) AS fatcoupon_cashback_percent, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from ism.cashback_percent)) AS iconsumer_cashback_percent, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from lrm.cashback_percent)) AS luckyrewards_cashback_percent, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from mss.cashback_percent)) AS mainstreetshares_cashback_percent, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from mrm.cashback_percent)) AS mrrebates_cashback_percent, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from ml.fixedpoints)) AS memolink_cashback_percent, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from pcm.cashback_percent)) AS pandacashback_cashback_percent, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from pfm.cashback_percent)) AS pennyful_cashback_percent, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from pp.cashback_percent)) AS purchperks_cashback_percent, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from rbm.cashback_percent)) AS rebateblast_cashback_percent, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from ssm.cashback_percent)) AS rebatesme_cashback_percent, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from shm.cashback_percent)) AS shopathome_cashback_percent, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from sbm.cashback_percent)) AS simplybest_cashback_percent, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from spm.cashback_percent)) AS lemoney_cashback_percent, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from ssr.cashback_percent)) AS sunshinerewards_cashback_percent, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from tbm.cashback_percent)) AS topcashback_cashback_percent, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from umm.cashback_percent)) AS upromise_cashback_percent, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from yzm.cashback_percent)) AS yazing_cashback_percent, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from rbc.cashback_percent)) AS rebatecodes_cashback_percent, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from swb.cashback_percent)) AS swagbucks_cashback_percent, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from hon.cashback_percent)) AS huntin_obsession_cashback_percent, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from mp.fixedpoints)) AS mypoints_cashback_percent, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from ajm.cashback_dollars)) AS activejunky_cashback_dollars, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from bfm.cashback_dollars)) AS befrugal_cashback_dollars, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from cm.cashback_dollars)) AS citi_cashback_dollars, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from ccm.cashback_dollars)) AS couponcactus_cashback_dollars, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from ddm.cashback_dollars)) AS discover_deals_cashback_dollars, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from dlr.cashback_dollars)) AS dollardig_cashback_dollars, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from di.cashback_dollars)) AS dubli_cashback_dollars, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from ebm.cashback_dollars)) AS ebates_cashback_dollars, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from exb.cashback_dollars)) AS extrabuxcashback_dollars, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from rtm.cashback_dollars)) AS retailmenot_cashback_dollars, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from erb.cashback_dollars)) AS extrarebates_cashback_dollars, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from gsm.cashback_dollars)) AS givingassistant_cashback_dollars, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from gbm.cashback_dollars)) AS gocashBack_cashback_dollars, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from gbs.cashback_dollars)) AS greenbackstreet_cashback_dollars, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from hdm.cashback_dollars)) AS hoopladoopla_cashback_dollars, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from fcm.cashback_dollars)) AS fatcoupon_cashback_dollars, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from ism.cashback_dollars)) AS iconsumer_cashback_dollars, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from lrm.cashback_dollars)) AS luckyrewards_cashback_dollars, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from mss.cashback_dollars)) AS mainstreetshares_cashback_dollars, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from mrm.cashback_dollars)) AS mrrebates_cashback_dollars, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from ml.pointsperdollar)) AS memolink_cashback_dollars, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from pcm.cashback_dollars)) AS pandacashback_cashback_dollars, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from pfm.cashback_dollars)) AS pennyful_cashback_dollars, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from pp.cashback_dollars)) AS purchperks_cashback_dollars, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from rbm.cashback_dollars)) AS rebateblast_cashback_dollars, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from ssm.cashback_dollars)) AS rebatesme_cashback_dollars, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from shm.cashback_dollars)) AS shopathome_cashback_dollars, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from sbm.cashback_dollars)) AS simplybest_cashback_dollars, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from spm.cashback_dollars)) AS lemoney_cashback_dollars, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from ssr.cashback_dollars)) AS sunshinerewards_cashback_dollars, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from tbm.cashback_dollars)) AS topcashback_cashback_dollars, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from umm.cashback_dollars)) AS upromise_cashback_dollars, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from yzm.cashback_dollars)) AS yazing_cashback_dollars, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from rbc.cashback_dollars)) AS rebatecodes_cashback_dollars, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from swb.cashback_dollars)) AS swagbucks_cashback_dollars, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from hon.cashback_dollars)) AS huntin_obsession_cashback_dollars , TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from mp.pointsperdollar)) AS mypoints_cashback_dollars, m.url_ext FROM manufacturers m LEFT JOIN activejunky_map ajm ON ajm.cashbackbin_id = m.manufacturers_id LEFT JOIN befrugal_map bfm ON bfm.cashbackbin_id = m.manufacturers_id LEFT JOIN citi_map cm ON cm.cashbackbin_id = m.manufacturers_id LEFT JOIN couponcactus_map ccm ON ccm.cashbackbin_id = m.manufacturers_id LEFT JOIN discover_deals_map ddm ON ddm.cashbackbin_id = m.manufacturers_id LEFT JOIN dollardig_map dlr ON dlr.cashbackbin_id = m.manufacturers_id LEFT JOIN dubli_map di ON di.cashbackbin_id = m.manufacturers_id LEFT JOIN ebates_map ebm ON ebm.cashbackbin_id = m.manufacturers_id LEFT JOIN retailmenot_map rtm ON rtm.cashbackbin_id = m.manufacturers_id LEFT JOIN extrabux_map exb ON exb.cashbackbin_id = m.manufacturers_id LEFT JOIN extrarebates_map erb ON erb.cashbackbin_id = m.manufacturers_id LEFT JOIN givingassistant_map gsm ON gsm.cashbackbin_id = m.manufacturers_id LEFT JOIN gocashBack_map gbm ON gbm.cashbackbin_id = m.manufacturers_id LEFT JOIN greenbackstreet_map gbs ON gbs.cashbackbin_id = m.manufacturers_id LEFT JOIN hoopladoopla_map hdm ON hdm.cashbackbin_id = m.manufacturers_id LEFT JOIN fatcoupon_map fcm ON fcm.cashbackbin_id = m.manufacturers_id LEFT JOIN iconsumer_map ism ON ism.cashbackbin_id = m.manufacturers_id LEFT JOIN luckyrewards_map lrm ON lrm.cashbackbin_id = m.manufacturers_id LEFT JOIN mainstreetshares_map mss ON mss.cashbackbin_id = m.manufacturers_id LEFT JOIN mrrebates_map mrm ON mrm.cashbackbin_id = m.manufacturers_id LEFT JOIN memolink_map ml ON ml.cashbackbin_id = m.manufacturers_id LEFT JOIN pandacashback_map pcm ON pcm.cashbackbin_id = m.manufacturers_id LEFT JOIN pennyful_map pfm ON pfm.cashbackbin_id = m.manufacturers_id LEFT JOIN rebatefanatic_map pp ON pp.cashbackbin_id = m.manufacturers_id LEFT JOIN rebateblast_map rbm ON rbm.cashbackbin_id = m.manufacturers_id LEFT JOIN rebatesme_map ssm ON ssm.cashbackbin_id = m.manufacturers_id LEFT JOIN shopathome_map shm ON shm.cashbackbin_id = m.manufacturers_id LEFT JOIN simplybest_map sbm ON sbm.cashbackbin_id = m.manufacturers_id LEFT JOIN lemoney_map spm ON spm.cashbackbin_id = m.manufacturers_id LEFT JOIN sunshinerewards_map ssr ON ssr.cashbackbin_id = m.manufacturers_id LEFT JOIN topcashback_map tbm ON tbm.cashbackbin_id = m.manufacturers_id LEFT JOIN upromise_map umm ON umm.cashbackbin_id = m.manufacturers_id LEFT JOIN yazing_map yzm ON yzm.cashbackbin_id = m.manufacturers_id LEFT JOIN rebatecodes_map rbc ON rbc.cashbackbin_id = m.manufacturers_id LEFT JOIN swagbucks_map swb ON swb.cashbackbin_id = m.manufacturers_id LEFT JOIN huntin_obsession_map hon ON hon.cashbackbin_id = m.manufacturers_id LEFT JOIN mypoints_map mp ON mp.cashbackbin_id = m.manufacturers_id WHERE m.manufacturers_id in (SELECT mmp.merchant_id from merchant_categories_map mmp where mmp.category_id=5) ORDER BY rand() ASC LIMIT 8
[TEP STOP]
SELECT m.manufacturers_name, m.manufacturers_alias, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from ajm.cashback_percent)) AS activejunky_cashback_percent, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from bfm.cashback_percent)) AS befrugal_cashback_percent, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from cm.cashback_percent)) AS citi_cashback_percent, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from ccm.cashback_percent)) AS couponcactus_cashback_percent, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from ddm.cashback_percent)) AS discover_deals_cashback_percent, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from dlr.cashback_percent)) AS dollardig_cashback_percent, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from di.cashback_percent)) AS dubli_cashback_percent, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from ebm.cashback_percent)) AS ebates_cashback_percent,from rtm.cashback_dollars)) AS retailmenot_cashback_dollars, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from exb.cashback_percent)) AS extrabux_cashback_percent, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from erb.cashback_percent)) AS extrarebates_cashback_percent, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from gsm.cashback_percent)) AS givingassistant_cashback_percent, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from gbm.cashback_percent)) AS gocashBack_cashback_percent, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from gbs.cashback_percent)) AS greenbackstreet_cashback_percent, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from hdm.cashback_percent)) AS hoopladoopla_cashback_percent, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from fcm.cashback_percent)) AS fatcoupon_cashback_percent, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from ism.cashback_percent)) AS iconsumer_cashback_percent, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from lrm.cashback_percent)) AS luckyrewards_cashback_percent, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from mss.cashback_percent)) AS mainstreetshares_cashback_percent, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from mrm.cashback_percent)) AS mrrebates_cashback_percent, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from ml.fixedpoints)) AS memolink_cashback_percent, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from pcm.cashback_percent)) AS pandacashback_cashback_percent, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from pfm.cashback_percent)) AS pennyful_cashback_percent, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from pp.cashback_percent)) AS purchperks_cashback_percent, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from rbm.cashback_percent)) AS rebateblast_cashback_percent, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from ssm.cashback_percent)) AS rebatesme_cashback_percent, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from shm.cashback_percent)) AS shopathome_cashback_percent, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from sbm.cashback_percent)) AS simplybest_cashback_percent, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from spm.cashback_percent)) AS lemoney_cashback_percent, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from ssr.cashback_percent)) AS sunshinerewards_cashback_percent, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from tbm.cashback_percent)) AS topcashback_cashback_percent, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from umm.cashback_percent)) AS upromise_cashback_percent, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from yzm.cashback_percent)) AS yazing_cashback_percent, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from rbc.cashback_percent)) AS rebatecodes_cashback_percent, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from swb.cashback_percent)) AS swagbucks_cashback_percent, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from hon.cashback_percent)) AS huntin_obsession_cashback_percent, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from mp.fixedpoints)) AS mypoints_cashback_percent, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from ajm.cashback_dollars)) AS activejunky_cashback_dollars, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from bfm.cashback_dollars)) AS befrugal_cashback_dollars, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from cm.cashback_dollars)) AS citi_cashback_dollars, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from ccm.cashback_dollars)) AS couponcactus_cashback_dollars, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from ddm.cashback_dollars)) AS discover_deals_cashback_dollars, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from dlr.cashback_dollars)) AS dollardig_cashback_dollars, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from di.cashback_dollars)) AS dubli_cashback_dollars, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from ebm.cashback_dollars)) AS ebates_cashback_dollars, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from exb.cashback_dollars)) AS extrabuxcashback_dollars, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from rtm.cashback_dollars)) AS retailmenot_cashback_dollars, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from erb.cashback_dollars)) AS extrarebates_cashback_dollars, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from gsm.cashback_dollars)) AS givingassistant_cashback_dollars, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from gbm.cashback_dollars)) AS gocashBack_cashback_dollars, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from gbs.cashback_dollars)) AS greenbackstreet_cashback_dollars, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from hdm.cashback_dollars)) AS hoopladoopla_cashback_dollars, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from fcm.cashback_dollars)) AS fatcoupon_cashback_dollars, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from ism.cashback_dollars)) AS iconsumer_cashback_dollars, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from lrm.cashback_dollars)) AS luckyrewards_cashback_dollars, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from mss.cashback_dollars)) AS mainstreetshares_cashback_dollars, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from mrm.cashback_dollars)) AS mrrebates_cashback_dollars, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from ml.pointsperdollar)) AS memolink_cashback_dollars, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from pcm.cashback_dollars)) AS pandacashback_cashback_dollars, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from pfm.cashback_dollars)) AS pennyful_cashback_dollars, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from pp.cashback_dollars)) AS purchperks_cashback_dollars, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from rbm.cashback_dollars)) AS rebateblast_cashback_dollars, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from ssm.cashback_dollars)) AS rebatesme_cashback_dollars, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from shm.cashback_dollars)) AS shopathome_cashback_dollars, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from sbm.cashback_dollars)) AS simplybest_cashback_dollars, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from spm.cashback_dollars)) AS lemoney_cashback_dollars, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from ssr.cashback_dollars)) AS sunshinerewards_cashback_dollars, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from tbm.cashback_dollars)) AS topcashback_cashback_dollars, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from umm.cashback_dollars)) AS upromise_cashback_dollars, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from yzm.cashback_dollars)) AS yazing_cashback_dollars, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from rbc.cashback_dollars)) AS rebatecodes_cashback_dollars, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from swb.cashback_dollars)) AS swagbucks_cashback_dollars, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from hon.cashback_dollars)) AS huntin_obsession_cashback_dollars , TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from mp.pointsperdollar)) AS mypoints_cashback_dollars, m.url_ext FROM manufacturers m LEFT JOIN activejunky_map ajm ON ajm.cashbackbin_id = m.manufacturers_id LEFT JOIN befrugal_map bfm ON bfm.cashbackbin_id = m.manufacturers_id LEFT JOIN citi_map cm ON cm.cashbackbin_id = m.manufacturers_id LEFT JOIN couponcactus_map ccm ON ccm.cashbackbin_id = m.manufacturers_id LEFT JOIN discover_deals_map ddm ON ddm.cashbackbin_id = m.manufacturers_id LEFT JOIN dollardig_map dlr ON dlr.cashbackbin_id = m.manufacturers_id LEFT JOIN dubli_map di ON di.cashbackbin_id = m.manufacturers_id LEFT JOIN ebates_map ebm ON ebm.cashbackbin_id = m.manufacturers_id LEFT JOIN retailmenot_map rtm ON rtm.cashbackbin_id = m.manufacturers_id LEFT JOIN extrabux_map exb ON exb.cashbackbin_id = m.manufacturers_id LEFT JOIN extrarebates_map erb ON erb.cashbackbin_id = m.manufacturers_id LEFT JOIN givingassistant_map gsm ON gsm.cashbackbin_id = m.manufacturers_id LEFT JOIN gocashBack_map gbm ON gbm.cashbackbin_id = m.manufacturers_id LEFT JOIN greenbackstreet_map gbs ON gbs.cashbackbin_id = m.manufacturers_id LEFT JOIN hoopladoopla_map hdm ON hdm.cashbackbin_id = m.manufacturers_id LEFT JOIN fatcoupon_map fcm ON fcm.cashbackbin_id = m.manufacturers_id LEFT JOIN iconsumer_map ism ON ism.cashbackbin_id = m.manufacturers_id LEFT JOIN luckyrewards_map lrm ON lrm.cashbackbin_id = m.manufacturers_id LEFT JOIN mainstreetshares_map mss ON mss.cashbackbin_id = m.manufacturers_id LEFT JOIN mrrebates_map mrm ON mrm.cashbackbin_id = m.manufacturers_id LEFT JOIN memolink_map ml ON ml.cashbackbin_id = m.manufacturers_id LEFT JOIN pandacashback_map pcm ON pcm.cashbackbin_id = m.manufacturers_id LEFT JOIN pennyful_map pfm ON pfm.cashbackbin_id = m.manufacturers_id LEFT JOIN rebatefanatic_map pp ON pp.cashbackbin_id = m.manufacturers_id LEFT JOIN rebateblast_map rbm ON rbm.cashbackbin_id = m.manufacturers_id LEFT JOIN rebatesme_map ssm ON ssm.cashbackbin_id = m.manufacturers_id LEFT JOIN shopathome_map shm ON shm.cashbackbin_id = m.manufacturers_id LEFT JOIN simplybest_map sbm ON sbm.cashbackbin_id = m.manufacturers_id LEFT JOIN lemoney_map spm ON spm.cashbackbin_id = m.manufacturers_id LEFT JOIN sunshinerewards_map ssr ON ssr.cashbackbin_id = m.manufacturers_id LEFT JOIN topcashback_map tbm ON tbm.cashbackbin_id = m.manufacturers_id LEFT JOIN upromise_map umm ON umm.cashbackbin_id = m.manufacturers_id LEFT JOIN yazing_map yzm ON yzm.cashbackbin_id = m.manufacturers_id LEFT JOIN rebatecodes_map rbc ON rbc.cashbackbin_id = m.manufacturers_id LEFT JOIN swagbucks_map swb ON swb.cashbackbin_id = m.manufacturers_id LEFT JOIN huntin_obsession_map hon ON hon.cashbackbin_id = m.manufacturers_id LEFT JOIN mypoints_map mp ON mp.cashbackbin_id = m.manufacturers_id WHERE m.manufacturers_id in (SELECT mmp.merchant_id from merchant_categories_map mmp where mmp.category_id=5) ORDER BY rand() ASC LIMIT 8
[TEP STOP]