MySQL Error - Unknown column 'xyz' in 'on clause' -

i upgraded mysql version 4 5 , error..

error no : 1054 error : unknown column 'c.city' in 'on clause'

`select b.expirydate, a.ben_changed, a.amlnotes, a.processdate, c.phone beneficiaryphone, cpstate.statename collectionpointstate, cpcity.cityname collectionpointcity, cp.agentname     collectionpointname, cp.agentaddress collectionpointaddress, cp.agenttelephone collectionpointphoneno, b.postcode customerpostcode, co.countryname bencountryname,  st.statename benstatename, ct.cityname bencityname, a.depositbankname depositbankname, b.address customeraddress, b.phone customerphone, a.releasedate, a.releasedby,    a.collectiontype, b.mobile customermobile, c.mobile beneficiarymobile, a.releasemessage, a.releaseorder, a.amlnotes, bf.bankname, a.branchname, a.accountno, a.ordertime, h.agentname     payingagentname, a.cashcommission, d.agentname officename, a.orderdate, a.orderid, a.orderamount, a.agentcommission, e.username orderby, g.currencycode fromcurrency,   f.currencycode currency, a.exchangerate, a.benamount, b.surname customersurname, b.firstname customerfirstname, c.surname bensurname, c.firstname benfirstname, a.orderstatus,   a.saleid, a.benid, a.contactid contact_master b, ben_master c, agent_master d, sales_master left join agent_master cp on a.collectionofficeid = cp.agentid left join city_master cpcity on cp.city = cpcity.cityid left join state_master cpstate on cp.state = cpstate.stateid left join currency_master f on a.currency = f.currencyid left join city_master ct on c.city = ct.cityid left join state_master st on c.state = st.stateid left join country_master co on c.country = co.countryid left join currency_master g on a.fromcurrency = g.currencyid left join user_master e on a.orderby = e.userid left join payingagent_master h on a.payingagent = h.agentid left join bank_master bf on a.bankname = bf.bankid a.contactid = b.contactid , a.benid = c.benid , a.officeid = d.agentid , a.contactid =  '2' , orderdate & gt ; =  '2013-04-09' , orderdate & lt ; =  '2013-04-09' , a.orderby !=  'onlinewebsite' order orderdate, ordertime asc  limit 0 , 30`  

please advise..

thank you,

the reason there no column named city in table ben_master. please confirm.
luck!