select odelivery.* , c_clients.description as client_name, users.accno from odelivery left join c_clients on c_clients.code=odelivery.client left join users on users.uid=odelivery.wclaim where odelivery.cstatus=1 and odelivery.cnumber=''