select tc.id, tc.email, tc.homepage, tc.fax, tc.telephon, tc.name  as company, tc.city, tc.zip_street as zip, tc.iso_country as country, tc.street, tc.modus as modus, tc.client_nr as client_nr, tc.state, '25010100' as code from tbl_companies tc  where tc.id=