| SQL |
SELECT
P.[PartNumber],
P.[ProductDescription],
P.[ProductNotes],
P.[BushSize],
P.[Weight],
P.[QuantityReq'd] AS [QtyRequired],
P.[PackSize],
P.[DiagRef],
P.[RoadSeriesDiagramFileName],
P.[BlackSeriesDiagramFileName],
P.[HeritageCollectionDiagramFileName],
P.[ImageFileName],
P.[DateCreated],
P.[LastUpdated],
P.[OEM1] AS [OEM1],
P.[OEM2] AS [OEM2],
P.[OEM3] AS [OEM3],
P.EAN,
P.[FittingInstructionsFileName],
P.[ExtraInfoHTML],
P.[Series],
CASE
WHEN P.[Series]='road' THEN 'Road Series'
WHEN P.[Series]='black' THEN 'Black Series'
WHEN P.[Series]='heritage' THEN 'Heritage Series'
WHEN P.[Series]='road+black' THEN 'Road + Black Series'
WHEN P.[Series]='all' THEN 'All Series'
ELSE ''
END AS [SeriesDescription],
ISNULL(STK.Quantity,0) AS InStock
FROM
Powerflex_Complete_2 P
JOIN web_stock S ON S.PartNumber=P.PartNumber
LEFT JOIN Octane_Stock_Feed_Data STK ON STK.PartNumber=P.PartNumber AND STK.Quantity > 0
WHERE
P.Make=? AND
P.Model=? AND
ISNULL(P.Variants1,'')=? AND
ISNULL(P.Variants2,'')=? AND
ISNULL(P.Variants3,'')=?
ORDER BY
[ProductDescription],
PartNumber |
