That still shouldn't work. As MySQL will tell you, you can't mix grouping functions with non-grouped columns without using a GROUP BY clause. This is the error you'll get:
ERROR 1140: Mixing of GROUP columns (MIN(),MAX(),COUNT()...) with no GROUP columns is illegal if there is no GROUP BY clause
The problem is that COUNT(subid) returns a single value, while text, name, and author returns a value for each combination of rows from the two tables. MySQL can't return a single row in one column and multiple rows in another column. It just won't work!
Rethink what you're trying to do and see if you can come up with a more sensible way of getting the information you're after. We'll be happy to help!