mysql> EXPLAIN SELECT *, COUNT(id) As count, GROUP_CONCAT(cre_name ORDER BY id)
As credits, GROUP_CONCAT(id ORDER BY id) As cawids
    -> FROM svr08test
    -> LEFT JOIN creator ON (creator = cre_id)
    -> LEFT JOIN superstar ON (name = sup_id)
    -> GROUP BY name
    -> ;
+----+-------------+-----------+--------+---------------+---------+---------+-------------------------------+------+----------------+
| id | select_type | table     | type   | possible_keys | key     | key_len | ref                           | rows | Extra          |
+----+-------------+-----------+--------+---------------+---------+---------+-------------------------------+------+----------------+
|  1 | SIMPLE      | svr08test | ALL    | NULL          | NULL    |    NULL | NULL                          |   12 | Using filesort |
|  1 | SIMPLE      | creator   | eq_ref | PRIMARY       | PRIMARY |       2 | cawsws_caws.svr08test.creator |    1 |                |
|  1 | SIMPLE      | superstar | eq_ref | PRIMARY       | PRIMARY |       2 | cawsws_caws.svr08test.name    |    1 |                |
+----+-------------+-----------+--------+---------------+---------+---------+-------------------------------+------+----------------+
3 rows in set (0.01 sec)