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.
800Florals.com Casback Tags:
800Florals.com cashback comparison,
800Florals.com cash back comparison,
800Florals.com rebate comparison
flowers, florists, flower delivery, 800, florist, flowers online, send, 1800, florals, online florist, delivered, floral, shop, on line, order, phillips, sending, buy, usa, canada, united states,
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]