select distinct t.site as site,a.cust_num,a.cust_seq,name,c.RowPointer, isnull(country,' ') + ',' + isnull(zip,' ') + ','  + isnull(city,' ') + ',' + isnull(addr##1,' ') as adr1,isnull(country,' ') + ',' + isnull(zip,' ') + ',' + isnull(city,' ' ) + ',' + isnull(addr##1,' ' ) as adr2,RUSinn,isnull(RUSkpp,'Нет данных') as RUSkpp,isnull(RUSokpo,'Нет данных') as RUSokpo,isnull(a.Uf_Rusogrn,'Нет данных') as Rusogrn,RUSAcct,RUSCorrAcct,RUSbik,RUSBankName,contact##1,isnull(Uf_StrategCust,0) as Uf_StrategCust,isnull(Uf_StrategProspect,0) as Uf_StrategProspec,isnull(phone##1, 'Нет данных') as phone,isnull(ship_to_email, 'Нет данных') as cust_email,  emp_num , 'customer' as tablename, c.posted_bal, l.lcr_num,
case a.cust_num when 'K00616' then  'R\K006168.jpg' else null end as logo_cust
from sl_spb..customer c
inner join sl_spb..custaddr a on (a.cust_num = c.cust_num and c.cust_seq = a.cust_seq) 
inner join #tmp_cust t on (t.cust_num = c.cust_num) 
inner join sl_spb..cust_lcr l on (t.cust_num = l.cust_num) 
where a.cust_num = c.cust_num  and a.cust_seq = 0  and site = 'SPB'  and getdate() >= l.issue_date and getdate() <= l.exp_date
and a.cust_num <>  'K001186' and  a.cust_num not in ( 'K000828','K000827','K000862','K001813','K005404','K006799','K010497','К001875')
FOR XML AUTO