| partname | Model  | Amount |
| Engine   | ModelA | 1      |
| Filter   | ModelB | 4      |

| id | name  |
| 1  | volvo |

| id | carid | name   |
| 1  | 1     | Engine |
| 2  | 1     | Filter |

| id | part_id | columnname | columnvalue
| 1  | 1       | Model      | ModelA
| 2  | 1       | Amount     | 1
| 3  | 2       | Model      | ModelB
| 4  | 2       | Amount     | 4

SELECT `parts`.`name`,
max(case when partdata.`columnname` = 'Model' then partdata.columnvalue end) AS `Model`,
max(case when partdata.`columnname` = 'Amount' then partdata.columnvalue end) AS `Amount`
FROM `parts` INNER JOIN `partdata`
ON `parts`.`id` = `partdata`.`part_id`
WHERE `carid` = 1