Offer15% off every Milltek Sport exhaust until 30 November. No code needed.Shop now › OfferBlack Friday: 20% off every Probite brake disc and pad until 1 December. No code needed.Shop now › OfferBlack Friday: 30% off every Whiteline part until 9 December. No code needed.Shop now › Offer30% off all Pipercross until 6th DecemberShop now ›
Shopping for: TOYOTA LAND CRUISER PRADO (_J12_) 3.0 D-4D (KDJ120_)
Menu

{{ flash }}
✓

Added to basket

{{ transferDone.added }} item moved into your basket.

{{ transferDone.skipped }} item skipped — no current price available.

Your {{ state.meta.labelSingular.toLowerCase() }} is still saved.

Save items to your {{ state.meta.labelSingular.toLowerCase() }}

{{ 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.' }}

{{ authError }}
{{ authError }}

No Products Found

This shouldn't happen.

query
RESULTSET
query
  BLACKSERIESDIAGRAMFILENAME BUSHSIZE DATECREATED DIAGREF EAN EXTRAINFOHTML FITTINGINSTRUCTIONSFILENAME HERITAGECOLLECTIONDIAGRAMFILENAME HIDERETAILDISCOUNTS IMAGEFILENAME INSTOCK LASTUPDATED OEM1 OEM2 OEM3 PACKSIZE PARTNUMBER PRODUCTDESCRIPTION PRODUCTNOTES QTYREQUIRED ROADSERIESDIAGRAMFILENAME SERIES SERIESDESCRIPTION WEIGHT
CACHED false
EXECUTIONTIME 99
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
array
1 Ford
2 KA Models
3 KA (2016 - 2021)
4 [empty string]
5 [empty string]
Back to Top