SELECT crment.description, v.accountname, v.parentid, v.account_type, v.industry, v.annualrevenue, v.rating, v.ownership, v.siccode, v.tickersymbol, v.phone,
v.otherphone, v.email1, v.email2, v.website, v.fax, v.employees, v.emailoptout, v.notify_owner,
fld.*,asa.*,
shi.ship_city DELCITY, shi.ship_code DELCODE, shi.ship_country DELCOUNTRY,
shi.ship_state DELSTATE, shi.ship_pobox DELPOBOX, shi.ship_street DELSTREET

FROM vtiger_account v join vtiger_accountbillads asa on (v.AccountID = asa.accountAddressID)
join vtiger_accountshipads shi on (v.AccountID = shi.accountAddressID)
join vtiger_accountscf fld on (v.AccountID = fld.AccountID)
join vtiger_crmentity crment on (v.AccountID = crment.crmid)