| query |
| RESULTSET |
| query |
| |
CATEGORYID |
CATEGORYIMAGE |
CATEGORYNAME |
MAKEID |
MAKEID |
MAKEIMAGE |
MAKENAME |
MODELID |
MODELID |
MODELIMAGE |
MODELNAME |
NEWCATEGORYID |
NEWMAKEID |
NEWMODELID |
PARTNUMBERID |
PARTNUMBERNAME |
PARTNUMBERSECTIONNAME |
PARTNUMBERSHORTNAME |
SUB_MENU |
SUB_MENU_3 |
SUB_MENU_4 |
SUB_MENU_5 |
SUB_MENU_6 |
SUB_MENU_7 |
SUB_MENU_8 |
SUB_MENU_TWO |
| 1 |
1
|
ExcavatorParts.png
|
Excavator Parts
|
10
|
10
|
[empty string]
|
Hyundai
|
171
|
171
|
[empty string]
|
R200W7
|
1
|
13
|
[empty string]
|
5021820
|
31N8-50370
|
Excavator
|
CLAMP-HOSE
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
[empty string]
|
|
| CACHED |
false |
| EXECUTIONTIME |
0 |
| SQL |
SELECT p.partNumberId, p.partNumberName, p.partNumberShortName, p.makeId ,
s.partNumberSectionName, s.modelId, s.sub_menu, s.sub_menu_two, s.sub_menu_3, s.sub_menu_4, s.sub_menu_5, s.sub_menu_6, s.sub_menu_7, s.sub_menu_8,
mo.modelId, mo.modelName, mo.newModelId, mo.modelImage,
c.categoryId, c.categoryName, c.newCategoryId, c.categoryImage,
ma.makeId, ma.makeName, ma.newMakeId, ma.makeImage
FROM s_partnumbers p
INNER JOIN s_partnumbersections s ON p.partNumberSectionId = s.partNumberSectionId
INNER JOIN s_models mo ON s.modelId = mo.modelId
INNER JOIN s_categories c ON mo.categoryId = c.categoryId
INNER JOIN s_makes ma ON p.makeId = ma.makeId
WHERE p.partNumberId = ?
ORDER BY p.partNumberName |
| SQLPARAMETERS |
|
Hyundai - Excavator Parts
Parts Catalogue - R200W7 - 31N8-50370 - CLAMP-HOSE
How to source parts at UrParts
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.
