postgresql7.1
select s.synonym_id
from category_synonyms s, categories c
where s.synonym_id in ([join $synonym_id ,])
and c.category_id = s.category_id
and acs_permission__permission_p(c.tree_id,:user_id,'category_tree_write') = 't'
and s.synonym_p = 't'