mysql: perspective subquery apportionment limitation

in mysql 5.0 since does following blunder start perplexing emanate perspective subquery clause?

error 1349 (hy000): view's name contains subquery clause

if discount mysql engine, following since haven't implemented underline yet?

also, good workarounds limitation?

are there any workarounds work any subquery apportionment there queries spoken but controlling subquery clause?

---

an instance query (was buried comment):

select temp.username 
from (select u1.name username, count(m1.userfromid) sentcount 
      summary m1, user u1 
      where u1.uid = m1.userfromid 
      organisation u1.name carrying sentcount > 3 ) temp