| 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
|
17.05
|
0.90
|
60
|
2500
|
2026-11-22 00:00:00.0
|
2027
|
500
|
2500.00
|
2
|
10747
|
86061375
|
3500.00
|
Nissan
|
Pathfinder SV 4WD
|
Proof of current enrollment in an accredited U.S. college, university, or graduate school with proof of graduation within the past 24 months, or written confirmation of upcoming graduation within the next 6 months, required. Cash offer is available towards the purchase or lease of an eligible vehicle from new dealer stock. Subject to residency restrictions. Cannot be combined with the Nissan Military Program offer or other VPP offers. Limit one vehicle purchase per qualified participant. Other restrictions apply. Contact dealer for details. Offer is subject to change or termination at any time without notice.
|
[empty string]
|
[empty string]
|
Nissan Conditional Offer - College Graduate Discount
|
{MODEL:Pathfinder,TRIM:SV,MODEL_CODE:52017}
|
[empty string]
|
| 2 |
and
|
0
|
17.05
|
0.90
|
60
|
2500
|
2026-11-22 00:00:00.0
|
2027
|
500
|
2500.00
|
2
|
10747
|
86061376
|
3500.00
|
Nissan
|
Pathfinder SV 4WD
|
Available to the following individuals with proof of eligibility: U.S. residents with a valid U.S. driver's license who are: (i) current U.S. Active and Reserve Military personnel, (ii) Honorably discharged U.S. Military Veterans, (iii) U.S. military Gold Star Familiies who provides dealer with a photocopy of DD-214, DD-1300, Summary of Benefits letter, or death certificate. Cash offer is available towards the purchase or lease of an eligible vehicle from new dealer stock. View Military Cash Program Offers link for list of current eligible vehicles. Subject to residency restrictions. Cannot be combined with the Nissan College Grad Program or the Nissan Business Associate Program. Limit up to 2 vehicle leases or purchases per calendar year per qualified participant for personal use only. Offer not valid for fleet or business use. Other restrictions may apply. Contact dealer for details. Offer is subject to change or termination at any time without notice.
|
[empty string]
|
[empty string]
|
Nissan Conditional Offer - Military Appreciation
|
{MODEL:Pathfinder,TRIM:SV,MODEL_CODE:52017}
|
[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 = '2027'
AND tblSFIncentives.txtMake = 'Nissan'
-- AND tblSFIncentives.FK_lngDealerID = '4'
AND (
tblSFIncentiveCodeLink.txtStyleID IS NOT NULL
OR
tblSFIncentives.txtModel = 'Pathfinder'
OR (
(tblSFIncentives.txtVehicleHints LIKE '%MODEL:Pathfinder[,}]%' OR tblSFIncentives.txtVehicleHints NOT LIKE '%MODEL:%')
AND (
tblSFIncentives.txtVehicleHints LIKE '%MODEL_CODE:52017[,}]%'
OR (
tblSFIncentives.txtVehicleHints NOT LIKE '%MODEL_CODE:%'
AND
tblSFIncentives.txtVehicleHintsForExclusion NOT LIKE '%MODEL_CODE:52017[,}]%'
)
)
AND (
tblSFIncentives.txtVehicleHints LIKE '%TRIM:SV[,}]%'
OR (
tblSFIncentives.txtVehicleHints NOT LIKE '%TRIM:%'
AND
tblSFIncentives.txtVehicleHintsForExclusion NOT LIKE '%TRIM:SV[,}]%'
)
)
)
)
AND tblSFIncentives.ysnActive = 1
AND tblSFIncentives.dtiStopDate >= Convert(DateTime, Floor(Convert(Float, getdate())))
ORDER BY tblSFIncentives.txtMake, tblSFIncentives.lngModelYear DESC, tblSFIncentives.txtModel |