select distinct  1 , yu.id, ys.id, streetname, yb.id, buildingno, porch, floor, flat, phone, agreementno, '' , nullif( 1 , 1 ), '', '', nullif( 1 , 1 )
 from yaol_streets ys, yaol_buildings yb, yaol_owners yo, yaol_users yu , yaol_user_counters yuc, yaol_user_counter_types yuct
 where ys.id=yb.streetid and yb.id=yo.buildingid and yu.ownerid=yo.id and yu.id=yuc.userid and yuc.countertype=yuct.id and ((yuc.countertype=- 32765  and yuc.countervalue> 33 ) or (yuc.countertype=- 32766  and yuc.countervalue> 33 ) or yuc.countertype=- 32755 ) and yb.id=- 32761  and ys.id=- 32765 

 union

select distinct  2 , yu.id, nullif( 1 , 1 ), '', nullif( 1 , 1 ), '', nullif( 1 , 1 ), nullif( 1 , 1 ), nullif( 1 , 1 ), nullif( 1 , 1 ), nullif( 1 , 1 ), i.ip , nullif( 1 , 1 ), '', '', nullif( 1 , 1 )
 from yaol_streets ys, yaol_buildings yb, yaol_owners yo, yaol_users yu, yaol_user_logins yul, ips i , yaol_user_counters yuc, yaol_user_counter_types yuct
 where ys.id=yb.streetid and yb.id=yo.buildingid and yu.ownerid=yo.id and yul.userid=yu.id and yul.ip=i.id and yu.id=yuc.userid and yuc.countertype=yuct.id and ((yuc.countertype=- 32765  and yuc.countervalue> 33 ) or (yuc.countertype=- 32766  and yuc.countervalue> 33 ) or yuc.countertype=- 32755 ) and yb.id=- 32761  and ys.id=- 32765 

 union

select distinct  3 , yu.id, nullif( 1 , 1 ), '',nullif( 1 , 1 ), '', nullif( 1 , 1 ), nullif( 1 , 1 ), nullif( 1 , 1 ), nullif( 1 , 1 ), nullif( 1 , 1 ), '' , yuct.id, yuct.counternick, yuct.countername, yuc.countervalue
 from yaol_streets ys, yaol_buildings yb, yaol_owners yo, yaol_users yu, yaol_user_counters yuc, yaol_user_counter_types yuct
 where ys.id=yb.streetid and yb.id=yo.buildingid and yu.ownerid=yo.id and yuc.userid=yu.id and yuc.countertype=yuct.id and ((yuc.countertype=- 32765  and yuc.countervalue> 33 ) or (yuc.countertype=- 32766  and yuc.countervalue> 33 ) or yuc.countertype=- 32755 ) and yb.id=- 32761  and ys.id=- 32765 

 order by  4 , 6 , 7 , 9 

select distinct yu.id
 from yaol_users yu , yaol_user_counters yuc
 where yu.id=yuc.userid and ((yuc.countertype=- 32765  and yuc.countervalue> 33 ) or (yuc.countertype=- 32766  and yuc.countervalue> 33 ) or yuc.countertype=- 32755 ) and yb.id=- 32761  and ys.id=- 32765