Error=Can't create/write to file '/tmp/#sql_b7c_0.MYI' (Errcode: 28)
SELECT ct_member.* FROM ct_member,ct_membertogroup WHERE (ct_member.id=ct_membertogroup.member_id) and (ct_membertogroup.group_id=1) GROUP BY ct_membertogroup.member_id