Current Offers
Current Offers
id='PREOWNED'>select * from(select of_offers.modelyear, of_offers.make, of_offers.model, of_offers.trimpackage, of_offers.offertitle, of_offers.info, of_offers.disclaimer, of_offers.offertype, of_offers.apr, of_offers.termlength, of_offers.monthlypayment, of_offers.cashdue, of_offers.imagelink, of_offers.validfrom, of_offers.expireson, of_offers.rebate, of_offers.customtitle from of_sites inner join of_sites_has_of_offers on of_sites.id = of_sites_has_of_offers.of_sites_id inner join of_offers on of_sites_has_of_offers.of_offers_id = of_offers.id where of_sites.sitename = 'centralfloridahondadealers.com' and of_offers.expireson >= now() and of_offers.validfrom <= now() order by sortorder asc) sub_offers where sub_offers.offertype = 'preowned'