| RESULTSET |
| query |
| |
BESTANDOR |
BESTCASH |
BESTCOST |
BESTRATE |
BESTTIME |
CASHTOTAL |
DTISTOPDATE |
LNGMODELYEAR |
LNGSPECIALCASH |
LNGTOTALCASH |
LNGTYPE |
PK_AUTSFINCENTIVEID |
PK_AUTSFINCENTIVESPECIALID |
TOTALREBATEOPPORTUNITY |
TXTMAKE |
TXTMODEL |
TXTSPECIALBODY |
TXTSPECIALQUALIFY |
TXTSPECIALRESTRICTIONS |
TXTSPECIALTITLE |
TXTVEHICLEHINTS |
TXTVEHICLEHINTSFOREXCLUSION |
| 1 |
and
|
0
|
18.41
|
3.99
|
60
|
[empty string]
|
2026-11-08 00:00:00.0
|
2026
|
750
|
0.00
|
2
|
10204
|
85996459
|
1750.00
|
Honda
|
Accord 1.5T SE
|
Eligible through 01/04/2027. Offer toward Cap Cost Reduction or Down Payment Assistance with the lease/finance through Honda Financial Services of a select new and not previously reported sold select Honda models to qualified current owners of 2011 or newer Honda automobiles. Must provide proof of ownership of eligible vehicle in the form of a current vehicle registration or proof of valid auto insurance. Offer not available to customers receiving conquest incentive. Zero Due at Signing Lease programs are NOT eligible. No trade-in required. Offer excludes purchases made prior to the program period and is transferable among members of the same household when the retail delivery registration address matches the current address on the proof-of- ownership document. Not redeemable for cash. Incentive paid to dealer and requires dealer participation. Not all customers will qualify. See dealer for details.
|
[empty string]
|
[empty string]
|
HFS Loyalty
|
{MODEL:Accord,TRIM:SE,MODEL_CODE:CY1F4TJW}
|
[empty string]
|
| 2 |
and
|
0
|
18.41
|
3.99
|
60
|
[empty string]
|
2026-11-08 00:00:00.0
|
2026
|
500
|
0.00
|
2
|
10204
|
85996458
|
1750.00
|
Honda
|
Accord 1.5T SE
|
For well-qualified clients who meet Honda Graduate Program criteria, subject to approval by HFS. Only one $500 Honda College Graduate Bonus per vehicle. $500 towards Cap Cost Reduction or Down Payment Assistance with the lease or purchase of a new and not previously reported sold Honda vehicle. Offer cannot be combined with Zero Due at Signing Lease Program. Offer applies to eligible college graduates who have graduated within the past two years or will graduate within the next six months with a master's, bachelor's or associate degree from a U.S.-accredited college or registered nursing school. Offer valid through 3/31/2027 and may be terminated at any time.
|
[empty string]
|
[empty string]
|
Honda Graduate Offer
|
{MODEL:Accord,TRIM:SE,MODEL_CODE:CY1F4TJW}
|
[empty string]
|
| 3 |
and
|
0
|
18.41
|
3.99
|
60
|
[empty string]
|
2026-11-08 00:00:00.0
|
2026
|
500
|
0.00
|
2
|
10204
|
85996460
|
1750.00
|
Honda
|
Accord 1.5T SE
|
For well-qualified clients who meet the Military Appreciation Offer criteria, subject to approval by HFS. Only one $500 Honda Military Appreciation offer per vehicle. $500 towards Cap Cost Reduction or Down Payment Assistance with the lease or purchase of a new and not previously reported sold Honda vehicle. Offer cannot be combined with Zero Due at Signing Lease Program. Offer applies to Active Duty U.S. Military and Ready Reserve and their spouses; eligible U.S. Military Veterans within two years of their separation from active service and their spouses; eligible U.S. Military Retirees; spouses of U.S. Military Retirees and Gold Star family members. Offer valid through 3/31/2027 and may be terminated at any time. NOTE: During the term of the retail installment finance contract or lease with Honda Financial Services, buyer may not take their vehicle outside the United States without prior written consent of Honda Financial Services. During the term of the retail installment finance contract or lease, buyer must notify Honda Financial Services immediately of any change in buyer address.
|
[empty string]
|
[empty string]
|
Honda Military Appreciation Offer
|
{MODEL:Accord,TRIM:SE,MODEL_CODE:CY1F4TJW}
|
[empty string]
|
| 4 |
and
|
0
|
18.41
|
3.99
|
60
|
[empty string]
|
2026-11-08 00:00:00.0
|
2026
|
0
|
0.00
|
2
|
10204
|
85996461
|
1750.00
|
Honda
|
Accord 1.5T SE
|
The Honda Customer Mobility Assistance Program is proud to support the mobility needs of drivers and passengers with physical disabilities. Honda will provide a reimbursement of up to $1,000 to each eligible, original retail customer for expenses incurred to purchase and install qualifying adaptive vehicle equipment on any eligible purchased or leased Honda vehicle. Only original vehicle owner. Honda will consider reimbursement for those modifications that have been approved by the National Highway Transportation Safety Administration (NHTSA). Only one reimbursement request is permitted per vehicle. Up to 6 months of the adaptive equipment installation Audit Requirements.
|
[empty string]
|
[empty string]
|
Honda Mobility Assistance
|
{MODEL:Accord,TRIM:SE,MODEL_CODE:CY1F4TJW}
|
[empty string]
|
|
| SQL |
SELECT tblSFIncentives.PK_autSFIncentiveID,
tblSFIncentives.txtMake,
tblSFIncentives.txtModel,
tblSFIncentives.lngModelYear,
tblSFIncentives.lngTotalCash,
tblSFIncentives.txtVehicleHints,
tblSFIncentives.txtVehicleHintsForExclusion,
tblSFIncentives.dtiStopDate,
tblSFIncentiveSpecials.PK_autSFIncentiveSpecialID,
tblSFIncentiveSpecials.txtSpecialTitle,
tblSFIncentiveSpecials.lngSpecialCash,
tblSFIncentiveSpecials.txtSpecialBody,
tblSFIncentiveSpecials.txtSpecialQualify,
tblSFIncentiveSpecials.txtSpecialRestrictions,
tblSFIncentiveSpecials.lngType,
tblSFIncentives.lngTotalCash +
(SELECT SUM(S2.lngSpecialCash)
FROM tblSFIncentiveSpecials S2
WHERE S2.FK_lngSFIncentiveID = tblSFIncentives.PK_autSFIncentiveID
AND S2.ysnActive = 1
AND S2.lngType = 2) AS TotalRebateOpportunity,
(SELECT SUM(Cash.lngCash)
FROM tblSFIncentiveCash Cash
WHERE Cash.FK_lngSFIncentiveID = tblSFIncentives.PK_autSFIncentiveID
AND Cash.ysnActive = 1) AS CashTotal,
BestAPR.lngTime AS BestTime,
BestAPR.txtValue AS BestRate,
BestAPR.lngCash AS BestCash,
BestAPR.txtAndOR AS BestAndOr,
BestAPR.lngCostPer1000 AS BestCost
FROM tblSFIncentives
LEFT JOIN tblSFIncentiveSpecials
ON tblSFIncentives.PK_autSFIncentiveID = tblSFIncentiveSpecials.FK_lngSFIncentiveID
AND tblSFIncentiveSpecials.ysnActive = 1
AND tblSFIncentiveSpecials.lngType = 2
LEFT JOIN tblSFIncentiveCodeLink
ON tblSFIncentives.PK_autSFIncentiveID = tblSFIncentiveCodeLink.FK_lngSFIncentiveID
AND tblSFIncentiveCodeLink.txtStyleID = '0'
OUTER APPLY (
SELECT TOP 1 tblSFIncentiveAPRs.lngTime,
tblSFIncentiveAPRs.txtValue,
tblSFIncentiveAPRs.lngCash,
tblSFIncentiveAPRs.txtAndOr,
tblSFIncentiveAPRs.lngCostPer1000
FROM tblSFIncentiveAPRs
WHERE tblSFIncentiveAPRs.FK_lngSFIncentiveID = tblSFIncentives.PK_autSFIncentiveID
AND tblSFIncentiveAPRs.ysnActive = 1
ORDER BY tblSFIncentiveAPRs.txtValue, tblSFIncentiveAPRs.lngTime DESC
) AS BestAPR
WHERE tblSFIncentives.lngModelYear = '2026'
AND tblSFIncentives.txtMake = 'Honda'
-- AND tblSFIncentives.FK_lngDealerID = '4'
AND (
tblSFIncentiveCodeLink.txtStyleID IS NOT NULL
OR
tblSFIncentives.txtModel = 'Accord'
OR (
(tblSFIncentives.txtVehicleHints LIKE '%MODEL:Accord[,}]%' OR tblSFIncentives.txtVehicleHints NOT LIKE '%MODEL:%')
AND (
tblSFIncentives.txtVehicleHints LIKE '%MODEL_CODE:CY1F4TJW[,}]%'
OR (
tblSFIncentives.txtVehicleHints NOT LIKE '%MODEL_CODE:%'
AND
tblSFIncentives.txtVehicleHintsForExclusion NOT LIKE '%MODEL_CODE:CY1F4TJW[,}]%'
)
)
AND (
tblSFIncentives.txtVehicleHints LIKE '%TRIM:SE[,}]%'
OR (
tblSFIncentives.txtVehicleHints NOT LIKE '%TRIM:%'
AND
tblSFIncentives.txtVehicleHintsForExclusion NOT LIKE '%TRIM:SE[,}]%'
)
)
)
)
AND tblSFIncentives.ysnActive = 1
AND tblSFIncentives.dtiStopDate >= Convert(DateTime, Floor(Convert(Float, getdate())))
ORDER BY tblSFIncentives.txtMake, tblSFIncentives.lngModelYear DESC, tblSFIncentives.txtModel |