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.
All-Battery.com Casback Tags:
All-Battery.com cashback comparison,
All-Battery.com cash back comparison,
All-Battery.com rebate comparison
battery, batteries, rechargeable battery, rechargeable batteries, charger, chargers, ni-mh, best offer, electronics, power, digital camera, ac converter, dc adaptor, nimh, battery charger, digital cameras, power inverters, car adaptors,
Relavant Stores:
1054 - Unknown column 'rtm.cashback_percent' in 'field list'
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, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from rtm.cashback_percent)) AS retailmenot_cashback_percent, 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 rebatefanatic_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 extrabux_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 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 10
[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, TRIM(TRAILING '.' FROM TRIM(TRAILING '0' from rtm.cashback_percent)) AS retailmenot_cashback_percent, 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 rebatefanatic_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 extrabux_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 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 10
[TEP STOP]