+-----------------+-----------------+----------+-----------+
| manufacturer_id | name            | mfg_code | prodcount |
+-----------------+-----------------+----------+-----------+
| 41              | MICKEY THOMPSON | MKY      | 764       |
| 73              | NA              | NA       | 96        |
| 76              | SOLAR           | SLR      | 23        |
| 110             | Vredestein      | VRD      | 1         |
| 124             | ROADX           | RDX      | 160       |
+-----------------+-----------------+----------+-----------+