select d.username,d.status,a.id,a.member_title,a.fname,a.lname,a.mobile,a.profile_pic,c.name as card_name from members a left join membership_details b on b.member_id=a.id inner join card_type c on c.id=b.card_id inner join login d on d.id=a.login_id AND d.status IN ('active') order by fname ASC LIMIT 0,24