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 | re
f                           | rows | Extra          |
+----+-------------+-----------+--------+---------------+---------+---------+---
----------------------------+------+----------------+
|  1 | SIMPLE      | svr08test | ALL    | NULL          | NULL    |    NULL | NU
LL                          |   12 | Using filesort |
|  1 | SIMPLE      | creator   | eq_ref | PRIMARY       | PRIMARY |       2 | ca
wsws_caws.svr08test.creator |    1 |                |
|  1 | SIMPLE      | superstar | eq_ref | PRIMARY       | PRIMARY |       2 | ca
wsws_caws.svr08test.name    |    1 |                |
+----+-------------+-----------+--------+---------------+---------+---------+---
----------------------------+------+----------------+
3 rows in set (0.01 sec)




After editing:

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 (svr08test.creator = creator.cre_id) LEFT JOIN superstar ON (svr08test.name = superstar.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.00 sec)