MariaDB [soegame]> select storename, storetype, ownercharid, concat(c.firstgiven, " ", c.lastgiven) as name, u.forumaccount from stores s join characters c on c.charid = s.ownercharid join users u using(userid) where storetype = "chopshop";
+------------------------+-----------+-------------+-------------+--------------+
| storename              | storetype | ownercharid | name        | forumaccount |
+------------------------+-----------+-------------+-------------+--------------+
| Low Power Construction | ChopShop  |       20269 | Ina Hansen  | Bella        |
| Hayes Auto             | ChopShop  |       31765 | Brian Smith | Majic        |
| Back Alley             | ChopShop  |         251 | Bob Mcgrath | Talbot       |
+------------------------+-----------+-------------+-------------+--------------+
3 rows in set (0.22 sec)