postgresql7.1
select * from card_comment
where ref_card = :card_id and
ref_community = :community_id
select * from card
where ref_user= :user_id and ref_community= :community_id
select * from card_percent where ref_community= :community_id order by percent desc
select * from card_task where ref_percent= :percent_id and ref_community = :community_id order by task_name
select * from card_note
where ref_card= :card_id and ref_task= :task_id