subquery error

[Aijaz Mallick]

"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from design d, design_statuses ds, user u
where designer_name in (Select name' at line 3 "

... iget this erro ..when i execute this query .....



select d.design_id, d.design_num, d.design_description, d.small_image_url,
ds.design_status_id, d.designer_id, u.name as designer_name
from from design d, design_statuses ds, user u
where designer_name in (Select name from user
where user_id in(3,5))
and d.design_id = ds.design_id
and ds.design_status_id = 3
and u.user_id = ds.market_exec_id
and u.user_id = 5
limit 0,10