{{ state.meta.isTrade ? 'Sign in or register to build customer quotes you can reuse.' : 'Sign in or create an account to save items for later.' }}
This {{ state.meta.labelSingular.toLowerCase() }} is empty.
Browse the site and click "{{ state.meta.labelAdd }}" on any part.

This shouldn't happen.
| query | |||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| RESULTSET |
|
||||||||||||||||||||||||||||||||||||||||||||||||||
| CACHED | false | ||||||||||||||||||||||||||||||||||||||||||||||||||
| EXECUTIONTIME | 37 | ||||||||||||||||||||||||||||||||||||||||||||||||||
| 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, S.hideRetailDiscounts FROM Powerflex_Complete_2 P JOIN web_stock_cache S ON S.PartNumber=P.PartNumber COLLATE Latin1_General_CI_AS 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 | ||||||||||||||||||||||||||||||||||||||||||||||||||
| SQLPARAMETERS |
|
||||||||||||||||||||||||||||||||||||||||||||||||||