select ct.*, ar.address1, ar.address2, ar.city, ar.province, ar.postal, ar.country, description, seller_id  from viewClientroster as ct  join tblclients as tc on (tc.clientid = ct.clientid) left join tblclientaddrs as ar on (ct.clientid=ar.clientrid and ar.status=1) left join tblcontactinfos as ci on (ct.clientid=ci.clientrid and ci.contacttype=3) where ct.clientID= and ct.pw like ''