query
RESULTSET
query
  ALTMAKEID CANCEL CATEGORYID CATEGORYNAME COMPLETE COUNTRYNAME DATETIME DESCRIPTION ID MAKEID MAKEIMAGE MAKENAME MAKESHORTURL MAKEUSERDEFINED MODELID MODELIMAGE MODELNAME NOTIFYBUYER PARTNO STATUS USERID
1 [empty string] No 6 Off Road Truck Parts No United Kingdom 2023-01-31 15:57:02.0 <p>Hydraulic pump to suit an Ausa 108DA with 3 cylinder perkins engine.</p> <p>Dumper serial number is 394.28013</p> <p>Engine code on serial plate is 329126-H</p> <p>Manufactuered in 2001</p> 298775 134 Ausa.png Ausa Ausa-parts 0 3478 [empty string] 108DA 0 091301000 Approved 137729
CACHED false
EXECUTIONTIME 0
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.modelImage AS 'modelImage', 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.id = ? ORDER BY e.id DESC LIMIT 100000 ) AS optimizedSub1
SQLPARAMETERS
array
1 298775
Ausa 108DA 091301000 - New & Used Parts | Heavy Equipment & Plant Spare Part Requests
x

UrParts is a global part sourcing website. This is just one example from a buyer in United Kingdom who was looking for parts.

Ausa 108DA
Ausa

Ausa 108DA

Part Number(s): 091301000

Off Road Truck Parts

Make: Ausa

Model: 108DA

Date of Request : 31 January 2023 at 3:57 PM

Get a Quote Make a new request
Request Details

Hydraulic pump to suit an Ausa 108DA with 3 cylinder perkins engine. Dumper serial number is 394.28013 Engine code on serial plate is 329126-H...

Read More

Your request will go directly to suppliers that can potentially supply the parts you need and they will contact you directly.

How to source parts at UrParts

Related Ausa Off Road Truck Parts Requests

View All Requests

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
We use cookies to improve your experience on this website. Read More