SELECT
ts.name
,tng.x_nip
,tng.org_id
,ts.site_id
,tsp.instance_name
,tsp.x_cupii
,tsp.part_status
,tsp.ship_date
,ta.zipcode KOD_POCZTOWY
,ta.city MIASTO
,ta.x_street ULICA
,ta.x_house NR_DOMU
FROM
table_site ts
join table_bus_org tng on (ts.primary2bus_org = tng.objid)
join table_site_part tsp on (ts.objid = tsp.site_part2site)
join table_sit_prt_role tspr on (tsp.objid = tspr.Prt_Role2site_Part)
join table_site ts1 on (ts1.objid = tspr.PRT_ROLE2SITE)
join table_address ta on (ts1.CUST_SHIPADDR2ADDRESS = ta.objid)
WHERE
tng.x_nipunique = '9522122126'