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.
AllergyandAir.com Casback Tags:
AllergyandAir.com cashback comparison,
AllergyandAir.com cash back comparison,
AllergyandAir.com rebate comparison
,
Relavant Stores:
Target - 10% ,
Lowe's - 18% ,
Dick's Sporting Goods - 5% ,
Amazon - 5% ,
DoorDash - 12500% ,
Groupon - 13% ,
Walgreens - 10% ,
Walmart - 10% ,
Kohl's - 10% ,
Uber Eats - $10 ,
Don't miss out AllergyandAir.com Cashback when you shop at AllergyandAir.com. AllergyandAir.com cashback may be combined with AllergyandAir.com coupons. Cashbackbin helps you find the highest AllergyandAir.com cashback rebate rates as well as AllergyandAir.com Airline mileage rewards and AllergyandAir.com Hotel Points by comparing reputable cashback vendor offers. AllergyandAir.com cashback rates vary for each cashback vendor and be sure to visit Cashbackbin for the latest AllergyandAir.com cashback offer rates. Save more with AllergyandAir.com cashback.
AllergyandAir.com
This is sample description about AllergyandAir.com. AllergyandAir.comoffers unique designs for domestic and international customers for woman and kids of all ages.
| Cashback Rewards Top | |||
|---|---|---|---|
| Portal | Rate | Signup Bonus | |
No cash back offers are available for this store. |
|||
| Points / Miles Rewards Top | |||
|---|---|---|---|
| Portal | Rate | Signup | |
No cash back offers are available for this store. |
|||
If you purchase something through a link on our site, GiftCardPlace may get a small share of the sale.
Don't miss out AllergyandAir.com Cashback when you shop at AllergyandAir.com. AllergyandAir.com cashback may be combined with AllergyandAir.com coupons. Cashbackbin helps you find the highest AllergyandAir.com cashback rebate rates as well as AllergyandAir.com Airline mileage rewards and AllergyandAir.com Hotel Points by comparing reputable cashback vendor offers. AllergyandAir.com cashback rates vary for each cashback vendor and be sure to visit Cashbackbin for the latest AllergyandAir.com cashback offer rates. Save more with AllergyandAir.com cashback.
ⓘ If you purchase something through a link on our site, GiftCardPlace may get a small share of the sale.
AllergyandAir.com Casback Tags :
AllergyandAir.com cashback comparison,
AllergyandAir.com cash back comparison,
AllergyandAir.com 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]