I have a the following MySQL tables (MySQL 5.6):

contacts

```
+----+----------------+
| id |     email      |
+----+----------------+
|  1 | one@domain.tld |
|  2 | two@domain.tld |
+----+----------------+

```

contact\_attributes

```
+----+-------------+
| id |    name     |
+----+-------------+
|  1 | name        |
|  2 | current_car |
|  3 | car_color   |
+----+-------------+

```

contact\_attribute\_values

```
+----+------------+-------------------------+------------+
| id |   value    | contact_attribute_value | contact_id |
+----+------------+-------------------------+------------+
|  1 | John Doe   |                       1 |          1 |
|  2 | Eva Milton |                       1 |          2 |
|  3 | BMW X3     |                       2 |          1 |
|  4 | Volvo XC90 |                       2 |          2 |
|  5 | Pink       |                       3 |          1 |
|  6 | Blue       |                       3 |          2 |
+----+------------+-------------------------+------------+

```

Is there a way to create a temporary table with the following schema in MySQL to fetch and filter the contacts by attributes?

```
+------------+----------------+------------+-------------+-----------+
| contact_id | contact_email  |    name    | current_car | car_color |
+------------+----------------+------------+-------------+-----------+
|          1 | one@domain.tld | John Doe   | BMW X3      | Pink      |
|          2 | two@domain.tld | Eva Milton | Volvo XC90  | blue      |
+------------+----------------+------------+-------------+-----------+

```

Thanks for your help