Komatsu - Loader Parts
Parts Catalogue - WA470-1 - 421-12-12191 - SPACER
How to source parts at UrParts
Related Komatsu Loader Parts Requests
| query | |||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| RESULTSET |
|
||||||||||||||||||||||||||||||||||||||||||
| CACHED | false | ||||||||||||||||||||||||||||||||||||||||||
| EXECUTIONTIME | 78 | ||||||||||||||||||||||||||||||||||||||||||
| SQL | SELECT optimizedSub1.*, (SELECT c.categoryName FROM categories c WHERE c.categoryId = optimizedSub1.categoryId) AS categoryName, (SELECT uc.countryName FROM usersaccounts u JOIN countries uc ON u.userCountryId = uc.countryId WHERE optimizedSub1.userId = u.userId) AS countryName FROM ( SELECT e.id AS 'id', e.userId AS 'userId', e.description AS 'description', e.partNo AS 'partNo', e.dateTime AS 'dateTime', e.altMakeId AS 'altMakeId', e.complete AS 'complete', e.cancel AS 'cancel', e.status AS 'status', e.notifyBuyer AS 'notifyBuyer', e.categoryId AS 'categoryId', mo.modelName AS 'modelName', mo.modelId AS 'modelId', mo.makeId AS 'makeId', ma.makeName AS 'makeName', ma.makeImage AS 'makeImage', ma.makeUserDefined AS 'makeUserDefined', ma.makeShortUrl AS 'makeShortUrl' FROM enquiries e JOIN models mo ON e.modelId = mo.modelId JOIN makes ma ON mo.makeId = ma.makeId WHERE 1 = 1 AND e.categoryId = ? AND mo.makeId = ? AND e.status = ? ORDER BY e.id DESC LIMIT 8 ) AS optimizedSub1 | ||||||||||||||||||||||||||||||||||||||||||
| SQLPARAMETERS |
|
||||||||||||||||||||||||||||||||||||||||||
Get Instant Free Quotes from Trusted Parts Suppliers
Submit your free parts request through UrParts to have it instantly sent to approved suppliers, and receive competitive quotes directly to your email.
Submit your parts request now
Submit a Request