SELECT
 "car"."vin" as "VIN",
 "manufacturer"."name" AS "Manufacturer",
 "model"."name" AS "Model"
FROM "car", "manufacturer", "model"
WHERE
  "car"."vin" = ?
  AND "car"."model" = "model"."id"
  AND "model"."manufacturer" = "manufacturer"."id"
