MZ                @                                       	!L!This program cannot be run in DOS mode.

$       PE  L ǝЪ         " 0          b         @                                 `                            O     8                       T 8                                                             H           .text   h                         `.rsrc   8                     @  @.reloc                        @  B                D     H      d  d     { ;                                          0 {     (  
(  s  
%r  po  
&
{  o  
{  o   
{  @o!  
s  
%r  po  
&{  o  
{  o   
{  @o!  
**   0      {>  r  po"  
8  %r  p%{  o#  
%rY  p%{  o#  
%r  p%{  o#  
%r  p($  
s%  
%o&  
{>  ('  
o(  
{=  (  o)  
{=  o*  
o+  
Z
{>  r  po"  
{>  (,  
o(  
{>  r  po-  
(.  
o"  
{=  (  o)  
{=  o*  
 *         Z  0 
    {@  r  po"  
{  r  po"  
{  r  po"  
{  {  o/  
8  %r  p%{  o#  
%rY  p%{  o#  
%r  p%{  o#  
%r  p($  
s%  

r  ps0  
s1  
o2  
&{;  o3  
o+  
D{  (,  
o(  
{  (,  
o(  
{  rn po"  
{  o-  
o"  
 *          D  **0      {  r  po"  
{  r  po"  
{  {
  o/  
8  %r  p%{  o#  
%rY  p%{  o#  
%r  p%{  o#  
%r  p($  
s%  

r~ ps0  
s1  
o2  
&{  o3  
o+  
D{  (,  
o(  
{  (,  
o(  
{  rn po"  
{  o-  
o"  
 *          D  0     {:  r  po"  
{9  r  po"  
{  {  o/  
8  %r  p%{  o#  
%rY  p%{  o#  
%r  p%{  o#  
%r  p($  
s%  

{  o#  
r p{  o#  
(4  
s0  
s1  
o2  
&{  o3  
o+  
D{:  (,  
o(  
{9  (,  
o(  
{:  rn po"  
{9  o-  
o"  
 *       D  *  0     {  r  po"  
{  r  po"  
{  {"  o/  
8  %r  p%{  o#  
%rY  p%{  o#  
%r  p%{  o#  
%r  p($  
s%  

r p{  o#  
rp(4  
s0  
s1  
o2  
&{  o3  
o+  
D{  (,  
o(  
{  (,  
o(  
{  rn po"  
{  o-  
o"  
 *         D  0     {)  r  po"  
{*  r  po"  
8  %r  p%{  o#  
%rY  p%{  o#  
%r  p%{  o#  
%r  p($  
s%  

r<p{  o#  
rp(4  
s0  
s1  
o2  
&{$  o3  
o+  
D{)  (,  
o(  
{*  (,  
o(  
{)  rn po"  
{*  o-  
o"  
 *          D  0     {,  r  po"  
{+  r  po"  
8  %r  p%{  o#  
%rY  p%{  o#  
%r  p%{  o#  
%r  p($  
s%  

rUp{  o#  
rKp(4  
s0  
s1  
o2  
&{%  o3  
o+  
D{,  (,  
o(  
{+  (,  
o(  
{,  rn po"  
{+  o-  
o"  
 *          D  0     {-  r  po"  
{.  r  po"  
8  %r  p%{  o#  
%rY  p%{  o#  
%r  p%{  o#  
%r  p($  
s%  

8  %rKp%{  o#  
%rgfp%{  o#  
%rgp%{  o#  
%rhp%{  o#  
%rnp%	{  o#  
%
rop%{  o#  
%rnp%
{  o#  
%rpp%{  o#  
%rqp%{  o#  
%rrp%{  o#  
%rsp%{  o#  
%rtp($  
s0  
s1  
o2  
&{&  o3  
o+  
D{-  (,  
o(  
{.  (,  
o(  
{-  rn po"  
{.  o-  
o"  
 * A              D     0 S    {1  r  po"  
{0  r  po"  
8  %r  p%{  o#  
%rY  p%{  o#  
%r  p%{  o#  
%r  p($  
s%  

	8  %r+up%{  o#  
%r^p%{  o#  
%rp%{  o#  
%rp%{  o#  
%rp($  
s0  
s1  
o2  
&{/  o3  
o+  
D{1  (,  
o(  
{0  (,  
o(  
{1  rn po"  
{0  o-  
o"  
 * A              D     0     {5  r  po"  
{6  r  po"  
8  %r  p%{  o#  
%rY  p%{  o#  
%r  p%{  o#  
%r  p($  
s%  

rp{  o#  
r+p(4  
s0  
s1  
o2  
&{2  o3  
o+  
D{5  (,  
o(  
{6  (,  
o(  
{6  rn po"  
{5  o-  
o"  
 *          D  0      {8  r  po"  
{7  r  po"  
8  %r  p%{  o#  
%rY  p%{  o#  
%r  p%{  o#  
%r  p($  
s%  

rp{  o#  
(.  
s0  
s1  
o2  
&{4  o3  
o+  
D{7  (,  
o(  
{8  (,  
o(  
{8  rn po"  
{7  o-  
o"  
 *       D  0     {  o5  
:  rps6  
(7  
(8  
t  
o3  ~9  
o+  ~D  -%  (:  
  (:  
(;  
(<  
D  ~D  {=  
~D  o=  G  o)  o>  
{  o#  
o@  +V
+@o-  XG  	XG  {;  o?  
o@  
oA  
	oB  
oC  
o'  	X
	{;  oD  
2X{;  o?  
oE  
2o;  o8  o/  o$  &o1  o$  &{  o5  
@4  rps6  
(7  
(8  
t  o3  ~9  
o+  ~E  -%  (:  
  (:  
(;  
(<  
E  ~E  {=  
~E  o=  G  o)  o>  
{
  o#  
o@  +a+Go-  XG  XG  {  o?  
o@  
oA  
oB  
oC  
o'  X{  oD  
2X{  o?  
oE  
2o;  o8  o/  o$  &o1  o$  &{  o5  
@4  rps6  
(7  
(8  
t  o3  ~9  
o+  	~F  -%  (:  
  (:  
(;  
(<  
F  ~F  {=  
~F  	o=  G  o)  o>  
{"  o#  
o@  
+a+Go-  
XG  XG  {/  o?  

o@  
oA  
oB  
oC  
o'  X{/  oD  
2
X

{/  o?  
oE  
2o;  o8  o/  o$  &o1  o$  &{  o5  
@4  rps6  
(7  
(8  
t  o3  ~9  
o+  
~G  -%  (:  
  (:  
(;  
(<  
G  ~G  {=  
~G  
o=  G  o)  o>  
{#  o#  
o@  +a+Go-  XG  XG  {2  o?  
o@  
oA  
oB  
oC  
o'  X{2  oD  
2X{2  o?  
oE  
2o;  o8  o/  o$  &o1  o$  &{  o5  
@4  rps6  
(7  
(8  
t  o3  ~9  
o+  ~H  -%  (:  
  (:  
(;  
(<  
H  ~H  {=  
~H  o=  G  o)  o>  
{   o#  
o@  +a+Go-  XG  XG  {%  o?  
o@  
oA  
oB  
oC  
o'  X{%  oD  
2X{%  o?  
oE  
2o;  o8  o/  o$  &o1  o$  &{  o5  
@4  rps6  
(7  
(8  
t  o3  ~9  
o+  ~I  -%  (:  
  (:  
(;  
(<  
I  ~I  {=  
~I  o=  G  o)  o>  
{!  o#  
o@  +a+Go-  XG  XG  {&  o?  
o@  
oA  
oB  
oC  
o'  X{&  oD  
2X{&  o?  
oE  
2o;  o8  o/  o$  &o1  o$  &{  o5  
@4  rps6  
(7  
(8  
t  o3  ~9  
o+  ~J  -%  (:  
  (:  
(;  
(<  
J  ~J  {=  
~J  o=  G  o)  o>  
{  o#  
o@  +a+Go-  XG  XG  {  o?  
o@  
oA  
oB  
oC  
o'  X{  oD  
2X{  o?  
oE  
2o;  o8  o/  o$  &o1  o$  &{  o5  
@4  rps6  
(7  
(8  
t  o3  ~9  
o+  ~K  -%  (:  
  (:  
(;  
(<  
K  ~K  {=  
~K  o=  G  o)  o>  
{  o#  
o@  +a+Go-  XG  XG  {$  o?  
o@  
oA  
oB  
oC  
o'  X{$  oD  
2X{$  o?  
oE  
2o;  o8  o/  o$  &o1  o$  &{  o5  
@4  rps6  
(7  
(8  
t    o3  ~9  
o+  !~L  -%  (:  
  (:  
(;  
(<  
L  ~L  {=  
~L  !o=  G  o)  o>  
{3  o#  
o@  "+a#+G o-  "XG  #XG  {4  o?  
"o@  
oA  
#oB  
oC  
o'  #X##{4  oD  
2"X""{4  o?  
oE  
2 o;   o8   o/  o$  & o1  o$  &{  o5  
	@4  rps6  
(7  
(8  
t  $$o3  ~9  
o+  %~M  -%  (:  
  (:  
(;  
(<  
M  ~M  {=  
~M  %o=  G  o)  o>  
{  o#  
o@  &+a'+G$o-  &XG  'XG  {  o?  
&o@  
oA  
'oB  
oC  
o'  'X''{  oD  
2&X&&{  o?  
oE  
2$o;  $o8  $o/  o$  &$o1  o$  &A({  {  o/  
{@  (,  
o(  
{@  rp(o-  
(.  
o"  
 *   A              A     z,{  ,{  oF  
(G  
* 0 &      (:  
sH  

sI  
}  sI  
}  sJ  
}  sJ  
}  sJ  
}  sI  
}  sK  
}  sK  
}	  sI  
}
  sJ  
}  sL  
}  sI  
}  sI  
}  sM  
}  sL  
}
  sI  
}  sI  
}  sM  
}  sL  
}  sI  
}@  sI  
}  sI  
}  sM  
};  sN  
}  sL  
}"  sI  
}0  sI  
}1  sM  
}/  sL  
}#  sI  
}5  sI  
}6  sM  
}2  sL  
}   sI  
}+  sI  
},  sM  
}%  sL  
}!  sI  
}.  sI  
}-  sM  
}&  sL  
}  sI  
}*  sI  
})  sM  
}$  sI  
}'  sI  
}(  sL  
}3  sI  
}7  sI  
}8  sM  
}4  sL  
}  sI  
}9  sI  
}:  sM  
}  sK  
}  sJ  
}  sI  
}  sJ  
}  sI  
}  sK  
}<  sI  
}>  sK  
}?  sK  
}=  {  oO  
{  oP  
{
  oO  
{  oP  
{  oO  
{;  oP  
{  oO  
{"  oO  
{/  oP  
{#  oO  
{2  oP  
{   oO  
{%  oP  
{!  oO  
{&  oP  
{  oO  
{$  oP  
{3  oO  
{4  oP  
{  oO  
{  oP  
(O  
{  oQ  
{  oR  
{  sS  
oT  
{  rpoU  
{  &
sV  
oW  
{  oX  
{  rpo"  
{  oQ  
{   )  sS  
oT  
{  rpoU  
{  
sV  
oW  
{  oX  
{  r+po"  
{  3sS  
oT  
{  r3poU  
{  dsV  
oW  
{  oX  
{      sS  
oT  
{  rEpoU  
{  dsV  
oW  
{  oX  
{   E  sS  
oT  
{  rWpoU  
{  dsV  
oW  
{  	oX  
{  oY  
{  oQ  
{      sS  
oT  
{  ripoU  
{  !
sV  
oW  
{  oX  
{  rwpo"  
{  rp"  A    sZ  
o[  
{   %  .sS  
oT  
{  rpoU  
{  bsV  
oW  
{  oX  
{  rpo"  
{  o\  
{  
  s]  
o^  
{    s]  
o^  
{    s]  
o^  
{  
  s]  
o^  
{    s]  
o^  
{    s]  
o^  
{    s]  
o^  
{	  rp"  A    sZ  
o[  
{	  {NsS  
oT  
{	  rpoU  
{	  \sV  
oW  
{	  oX  
{	  rpo"  
{	  o\  
{	    s]  
o^  
{
  oQ  
{
  rp"  A    sZ  
o[  
{
      ZsS  
oT  
{
  rpoU  
{
  0sV  
oW  
{
  oX  
{
  r
po"  
{   "  ZsS  
oT  
{  rpoU  
{  esV  
oW  
{  oX  
{  o_  
{  o`  
{  o_  
{  o`  
{  o_  
{  o`  
{  sS  
oa  
{  r-poU  
{  sb  
oc  
{        sV  
oW  
{  od  
{  r?po"  
{  oe  
{  	  s]  
o^  
{  oQ  
{  7<sS  
oT  
{  r_poU  
{  sV  
oW  
{  oX  
{  oQ  
{  7sS  
oT  
{  ropoU  
{  sV  
oW  
{  oX  
{  of  
{  og  
{  (h  
oi  
{  oj  
{  ok  
{  sS  
oT  
{  rpoU  
{        sV  
oW  
{  oX  
{  ol  
{
  o_  
{  o`  
{
  o_  
{  o`  
{
  o_  
{  o`  
{
  sS  
oa  
{
  rpoU  
{
  sb  
oc  
{
        sV  
oW  
{
  od  
{
  rpo"  
{
  oe  
{  oQ  
{  (?sS  
oT  
{  rpoU  
{  sV  
oW  
{  oX  
{  oQ  
{  (sS  
oT  
{  rpoU  
{  sV  
oW  
{  oX  
{  om  
{  of  
{  og  
{  (h  
oi  
{  oj  
{  ok  
{  sS  
oT  
{  rpoU  
{        sV  
oW  
{  oX  
{  (n  
oo  
{  o_  
{@  o`  
{  o_  
{  o`  
{  o_  
{  o`  
{  o_  
{;  o`  
{  sS  
oa  
{  rpoU  
{  sb  
oc  
{        sV  
oW  
{  od  
{  rpo"  
{@  oQ  
{@  oR  
{@  "sS  
oT  
{@  r)poU  
{@  sV  
oW  
{@  oX  
{  oQ  
{  =sS  
oT  
{  r9poU  
{  sV  
oW  
{  oX  
{  oQ  
{  'sS  
oT  
{  rGpoU  
{  sV  
oW  
{  oX  
{;  of  
{;  og  
{;  (h  
oi  
{;  oj  
{;  ok  
{;  sS  
oT  
{;  rUpoU  
{;        sV  
oW  
{;  oX  
{  om  
{  o_  
{  o`  
{  o_  
{
  o`  
{  o_  
{"  o`  
{  o_  
{#  o`  
{  o_  
{   o`  
{  o_  
{!  o`  
{  o_  
{  o`  
{  o_  
{  o`  
{  o_  
{3  o`  
{  o_  
{  o`  
{  ok  
{  rp"  4A    sZ  
o[  
{  op  
{  ssS  
oT  
{  oq  
{  rspoU  
{  or  
{        sV  
oW  
{  
oX  
{"  o_  
{0  o`  
{"  o_  
{1  o`  
{"  o_  
{/  o`  
{"  sS  
oa  
{"  rpoU  
{"  sb  
oc  
{"        sV  
oW  
{"  od  
{"  rpo"  
{"  oe  
{0  oQ  
{0     dsS  
oT  
{0  rpoU  
{0  sV  
oW  
{0  oX  
{1  oQ  
{1     6sS  
oT  
{1  rpoU  
{1  sV  
oW  
{1  oX  
{/  of  
{/  og  
{/  (h  
oi  
{/  oj  
{/  ok  
{/  sS  
oT  
{/  rpoU  
{/        sV  
oW  
{/  oX  
{/  ol  
{#  o_  
{5  o`  
{#  o_  
{6  o`  
{#  o_  
{2  o`  
{#  sS  
oa  
{#  rpoU  
{#  sb  
oc  
{#        sV  
oW  
{#  	od  
{#  rpo"  
{#  oe  
{5  oQ  
{5      ZsS  
oT  
{5  rpoU  
{5  sV  
oW  
{5  oX  
{6  oQ  
{6      *sS  
oT  
{6  r+poU  
{6  sV  
oW  
{6  oX  
{2  of  
{2  og  
{2  (h  
oi  
{2  oj  
{2  ok  
{2  sS  
oT  
{2  r;poU  
{2        sV  
oW  
{2  oX  
{2  ol  
{   o_  
{+  o`  
{   o_  
{,  o`  
{   o_  
{%  o`  
{   sS  
oa  
{   rWpoU  
{   sb  
oc  
{         sV  
oW  
{   od  
{   ripo"  
{   oe  
{+  oQ  
{+   N  RsS  
oT  
{+  rpoU  
{+  sV  
oW  
{+  oX  
{,  oQ  
{,   N  'sS  
oT  
{,  rpoU  
{,  sV  
oW  
{,  oX  
{%  of  
{%  og  
{%  (h  
oi  
{%  oj  
{%  ok  
{%  sS  
oT  
{%  rpoU  
{%        sV  
oW  
{%  oX  
{%  ol  
{!  o_  
{.  o`  
{!  o_  
{-  o`  
{!  o_  
{&  o`  
{!  sS  
oa  
{!  rpoU  
{!  sb  
oc  
{!        sV  
oW  
{!  od  
{!  rpo"  
{!  oe  
{.  oQ  
{.     asS  
oT  
{.  rpoU  
{.  sV  
oW  
{.  oX  
{-  oQ  
{-     1sS  
oT  
{-  rpoU  
{-  sV  
oW  
{-  oX  
{&  of  
{&  og  
{&  (h  
oi  
{&  oj  
{&  ok  
{&  sS  
oT  
{&  rpoU  
{&        sV  
oW  
{&  oX  
{&  ol  
{  o_  
{*  o`  
{  o_  
{)  o`  
{  o_  
{$  o`  
{  o_  
{'  o`  
{  o_  
{(  o`  
{  sS  
oa  
{  r'poU  
{  sb  
oc  
{        sV  
oW  
{  od  
{  r9po"  
{  oe  
{*  oQ  
{*     BsS  
oT  
{*  rMpoU  
{*  sV  
oW  
{*  oX  
{)  oQ  
{)     sS  
oT  
{)  r]poU  
{)  sV  
oW  
{)  oX  
{$  of  
{$  og  
{$  (h  
oi  
{$  oj  
{$  ok  
{$  sS  
oT  
{$  rmpoU  
{$        sV  
oW  
{$  oX  
{$  ol  
{'  oQ  
{'      sS  
oT  
{'  rpoU  
{'  sV  
oW  
{'  oX  
{(  oQ  
{(      BsS  
oT  
{(  rpoU  
{(  sV  
oW  
{(  oX  
{3  o_  
{7  o`  
{3  o_  
{8  o`  
{3  o_  
{4  o`  
{3  sS  
oa  
{3  rpoU  
{3        sV  
oW  
{3  
od  
{3  rpo"  
{3  oe  
{7  oQ  
{7     JsS  
oT  
{7  rpoU  
{7  sV  
oW  
{7  oX  
{8  oQ  
{8     'sS  
oT  
{8  rpoU  
{8  sV  
oW  
{8  oX  
{4  of  
{4  og  
{4  (h  
oi  
{4  oj  
{4  ok  
{4  sS  
oT  
{4  rpoU  
{4        sV  
oW  
{4  oX  
{4  ol  
{  o_  
{9  o`  
{  o_  
{:  o`  
{  o_  
{  o`  
{  sS  
oa  
{  r
poU  
{  sb  
oc  
{        sV  
oW  
{  od  
{  rpo"  
{  oe  
{9  oQ  
{9     GsS  
oT  
{9  rCpoU  
{9  sV  
oW  
{9  oX  
{:  oQ  
{:     -sS  
oT  
{:  rSpoU  
{:  sV  
oW  
{:  oX  
{  of  
{  og  
{  (h  
oi  
{  os  
{  oj  
{  ok  
{  sS  
oT  
{  rcpoU  
{        sV  
oW  
{  oX  
{  rp"  A    sZ  
o[  
{     .sS  
oT  
{  rpoU  
{  }sV  
oW  
{  oX  
{  rpo"  
{  o\  
{    s]  
o^  
{  rp"  A    sZ  
o[  
{     YsS  
oT  
{  rpoU  
{   *  sV  
oW  
{  oX  
{  rpo"  
{  oQ  
{  rp"  A    sZ  
o[  
{     CsS  
oT  
{  rpoU  
{  {sV  
oW  
{  oX  
{  r'po"  
{     YsS  
oT  
{  rKpoU  
{     sV  
oW  
{  oX  
{  r]po"  
{  oQ  
{  rp"  A    sZ  
o[  
{   ,  CsS  
oT  
{  r(poU  
{      sV  
oW  
{  oX  
{  r6po"  
{    s]  
o^  
{<  rp"  A    sZ  
o[  
{<  
NsS  
oT  
{<  rnpoU  
{<  \sV  
oW  
{<  oX  
{<  r~po"  
{<  o\  
{<    s]  
o^  
{>  oQ  
{>  oR  
{>  rp"  AsZ  
o[  
{>     sS  
oT  
{>  rpoU  
{>  sV  
oW  
{>  oX  
{?  (  o)  
{?  o*  
{?  rp"  A    sZ  
o[  
{?   v  *sS  
oT  
{?  sb  
ot  
{?  rpoU  
{?  +&sV  
oW  
{?  oX  
{?  o\  
{?    s]  
o^  
{=  (  o)  
{=  o*  
{=  ou  
ov  
{=  (w  
o(  
{=     sS  
oT  
{=  sb  
ot  
{=  rpoU  
{=  &#sV  
oW  
{=  oX  
{=  o\  
{=    s]  
o^  
om  
"  @"  PAsx  
(y  
(z  
o{  
oQ  
(|  
oo  
      sV  
(}  
(_  
{?  o`  
(_  
{>  o`  
(_  
{=  o`  
(_  
{<  o`  
(_  
{  o`  
(_  
{  o`  
(_  
{  o`  
(_  
{  o`  
(_  
{  o`  
(_  
{  o`  
(_  
{
  o`  
(_  
{	  o`  
(_  
{  o`  
(_  
{  o`  
(_  
{  o`  
(_  
{  o`  
(_  
{  o`  
(_  
{  o`  
(_  
{  o`  
(_  
{  o`  
rpo~  
tc  (  
rp(U  
rpo"  
  s]  
(  
{  o  
{  o  
{  o  
{
  o  
{
  o  
{  o  
{  o  
{  o  
{;  o  
{  o  
{"  o  
{"  o  
{/  o  
{#  o  
{#  o  
{2  o  
{   o  
{   o  
{%  o  
{!  o  
{!  o  
{&  o  
{  o  
{  o  
{$  o  
{3  o  
{3  o  
{4  o  
{  o  
{  o  
{  o  
(  
(  
*Z(  
(  
s  (  
*(  
*~A  -r0p  (:  
o  
s  
A  ~A  *~B  *B  *j(  r|p~B  o  
t(  *j(  rp~B  o  
t(  *j(  rp~B  o  
t(  *j(  rp~B  o  
t(  *j(  rp~B  o  
t(  *j(  rp~B  o  
t(  *j(  rp~B  o  
t(  *~C  *(  
*Vs!  (  
t  C  * BSJB         v4.0.30319     l     #~  L    #Strings    &   #US     #GUID   , 8	  #Blob         W7		   3      f      M   @   7   	      n                                   
      l	 	 )    j  	 	 	 	 	  V   

 K S
 
 
 u

 
 
 =
  D D X
D H
& <     D { D ;  $ 
 
 f = 0  T	 D  	 =	 FG  
 %
 
 + 
D K
b
 
 

  ^& ab
 D } D 
 vD 

 
 
 D
 .

 J
 

  RD a

  
 \

 
 
 

 % .D 
  
 x

 
  Z

 V
 
 
  

 
 
  

   ;             A    3e A     +e A     C       D #     D #     D #     D #   p  D #      D #   g  D (   T  D *     D *     D *     D *     D ,     D ,   S  D <     D >    e D A  }b  f Cf j Rj j f Jn 5n .f Kj %r :r  r v n j f r j f  z z Nf f  f f =z 
f ` f r r Er r r z z Uz [f f f / f f af f cf z f w f z  r   z cf f f if kf &f h z n  n f n 7 f P~   L    #   }  .  P             K       
 !     
 $#     
 &#     %	 (#     	 D$     
 x%     
 |%       &     * '      (      +      ,     5 -      .     2 ;     N ! ;     \ " b     u" b     " c    " .c    " 5c    	" =c    k# Xc     # sc    w# c     # c    f# c    k# c    ]# c    .# d     # 	d    #      T #     x#       $     
$     
!'      s *     
;*       ,     _,      T .     
.        /     
#/       0     
0        1     
1      ?  2     
b 2        3     
3     
# 3      q 4     
^4     
j 4       5     
n5      S  6     
b 6     
 7    
   r
   
   r
   
   r
   
   r
   
   r
   
   r
   
   r
   
   r
   
   r
   
   r
   
   r
   
   r
   
   r
   
   r
   
   r
   
   r
   
   
                                        ]                                                 H       
 L 
 <    P  ( 	     
 )  1  9  A  I  Q  Y  a  i  q  y     ! ) Q  a' i y, i 6         _D  I  !O  V " b f   p \l r  y  H cl  b   8         g   	

q! V8 E 5U ^A;dIkQ;qY
x  A aN  N  6              i 6
  y -
Z  
  @_  t
 Z     l  or  6J ~ 
 l r  
    y  zC
 +l /  &l  R
1  V  i !!:!|
#  q)1/17Y 1s?)  O.  '.  0.  O. # X. + n. 3 n. ; n. C X. K t. S n. [ n. c . k . s I  O     {  {    {   ' c .   {   X  { c  2 #{ # '#c # C{ C C c{ c 'c lcc zc i {  lc   ({ c  2  C{ c  '  L{  "  U{ c  l 	 ^#{ # 2#c 	# ) C{ C lCc C I gc{ cc c i p { c 	  y{       (` 1` : C L  U` ^  g  g@ @ p` ` p y   G ZI ZK ZM ZO ZQ ZS ZU \W ZY ^[ Z] ^_ ^a ^c ^e `k ^m `o `= ]   |   
      
           o     {     j  o  a  T   1  ?    '      1  '  n  r"                	      
               &   '   )   -   /   1   3 !  5 #  7 %  8 %  : '  ; '  = )  ? +  @ + 'I                            HB               H               HD               H               H               Q
               Q
           5       V       _VtblGap4_10 tabPage10 label10 dataGridView10 label20 label30 _VtblGap5_60 <>p__0 _VtblGap1_11 label11 dataGridView11 label21 get_black331 get_expexcel331 _VtblGap6_161 _VtblGap2_1 <>p__1 button2_Click_1 CallSite`1 tabPage1 label1 Form1 button1 dataGridView1 textBox1 label12 label22 Int32 <>p__2 button2_Click_2 tabPage2 label2 button2 textBox2 label13 label23 get_black33 get_expexcel33 _VtblGap1_3 <>p__3 button2_Click_3 Func`3 tabPage3 label3 button3 WindowsFormsApp3 dataGridView3 textBox3 label14 _VtblGap1_124 label24 <>p__4 button2_Click_4 tabPage4 label4 button4 dataGridView4 textBox4 _VtblGap1_15 label15 label25 _VtblGap7_5 <>p__5 button2_Click_5 tabPage5 label5 button5 dataGridView5 textBox5 _VtblGap3_16 <>o__16 label16 label26 <>p__6 tabPage6 label6 button6 dataGridView6 textBox6 label17 label27 <>p__7 button2_Click_7 tabPage7 label7 dataGridView7 label18 label28 _VtblGap1_8 <>p__8 button2_Click_8 tabPage8 label8 dataGridView8 label19 _VtblGap2_29 label29 <>p__9 tabPage9 label9 dataGridView9 <Module> GetTypeFromCLSID SizeF RHS System.Data System.Data.OleDb SelectTab mscorlib Form1_Load add_Load Add get_Red get_red Synchronized Guid FlatButtonAppearance get_FlatAppearance CreateInstance defaultInstance set_DataSource set_AutoCompleteSource set_AutoCompleteCustomSource set_AutoScaleMode set_AutoCompleteMode set_ColumnHeadersHeightSizeMode DataGridViewColumnHeadersHeightSizeMode set_VirtualMode set_AutoSizeColumnsMode DataGridViewAutoSizeColumnsMode set_AutoSizeRowsMode DataGridViewAutoSizeRowsMode TabPage set_BackgroundImage get_Message Range get_WhiteSmoke Invoke DataTable IEnumerable IDisposable get_Visible set_Visible RuntimeTypeHandle GetTypeFromHandle DockStyle set_BorderStyle set_FlatStyle FontStyle get_Name set_Name set_Multiline Type System.Core get_Culture set_Culture resourceCulture ButtonBase ApplicationSettingsBase Close Dispose Create Template EditorBrowsableState CallSite get_White DispIdAttribute STAThreadAttribute CompilerGeneratedAttribute GuidAttribute ComEventInterfaceAttribute GeneratedCodeAttribute DebuggerNonUserCodeAttribute DebuggableAttribute EditorBrowsableAttribute ComVisibleAttribute AssemblyTitleAttribute InterfaceTypeAttribute AssemblyTrademarkAttribute TargetFrameworkAttribute AssemblyFileVersionAttribute LCIDConversionAttribute AssemblyConfigurationAttribute AssemblyDescriptionAttribute DefaultMemberAttribute TypeIdentifierAttribute CompilationRelaxationsAttribute CoClassAttribute AssemblyProductAttribute AssemblyCopyrightAttribute AssemblyCompanyAttribute RuntimeCompatibilityAttribute get_Value value WindowsFormsApp3.exe set_Size set_AutoSize set_BorderSize set_ClientSize ISupportInitialize set_Padding System.Runtime.Versioning String disposing Missing System.Drawing set_HotTrack tabPage1_Click button1_Click button3_Click tabPage4_Click button4_Click button5_Click label6_Click button6_Click add_Click set_Dock _Workbook get_ssis_export_excel_file_task Marshal Label Microsoft.Office.Interop.Excel System.ComponentModel DataGridViewCell Fill set_AutoScroll TabControl ScrollableControl ContainerControl get_UserControl set_UserControl Program get_Item System Form resourceMan get_Green get_green Open Main set_Margin set_Icon _Application set_Location System.Configuration System.Globalization System.Reflection AutoCompleteStringCollection DataGridViewCellCollection ControlCollection DataGridViewRowCollection OleDbConnection Exception System.Data.Common Button Run CultureInfo Bitmap set_AllowDrop Microsoft.CSharp set_UseSystemPasswordChar sender Microsoft.CSharp.RuntimeBinder CallSiteBinder get_ResourceManager ComponentResourceManager EventHandler System.CodeDom.Compiler IContainer OleDbDataAdapter set_BackgroundColor set_ForeColor set_BackColor set_UseVisualStyleBackColor Activator .ctor .cctor System.Diagnostics System.Runtime.InteropServices System.Runtime.CompilerServices System.Resources WindowsFormsApp3.Form1.resources WindowsFormsApp3.Properties.Resources.resources DebuggingModes WindowsFormsApp3.Properties EnableVisualStyles CSharpBinderFlags Settings EventArgs get_Workbooks get_Cells get_Controls System.Windows.Forms get_Columns set_AutoScaleDimensions System.Collections SystemColors Sheets get_Worksheets components DocEvents WorkbookEvents AppEvents get_Rows Concat GetObject _Worksheet Target get_ControlLightLight AutoFit EndInit BeginInit GraphicsUnit get__Default set__Default get_Default SetCompatibleTextRenderingDefault InitializeComponent DocEvents_Event WorkbookEvents_Event AppEvents_Event Point set_Font get_Count get_ColumnCount Convert SuspendLayout set_BackgroundImageLayout ResumeLayout PerformLayout get_Text set_Text get_HighlightText DataGridView DataGridViewRow set_TabIndex get_SelectedIndex set_SelectedIndex ColumnIndex RowIndex TextBox get_Assembly     
S e l e c t  	w e r e   =P r o v i d e r = M S D A O R A ; D a t a   S o u r c e = ' M' ; P e r s i s t   S e c u r i t y   I n f o = T r u e ; U s e r   I D = ' ' ; P a s s w o r d = ' ' ; U n i c o d e = T r u e C O N N E C T   E R R O R :    ms e l e c t   t . E M I T E N T , t . F I L I A L , ( t o _ d a t e ( ( t o _ c h a r ( t . E X C H _ D A T E ,   ' d d . m m . y y y y   h h 2 4 . m i . s s ' ) ) ,   ' d d . m m . y y y y   h h 2 4 . m i . s s ' )   +   ( 3   /   2 4 ) )   a s   " E X C H _ D A T E + 3 "   f r o m   S E C . I E M _ R E P L _ F O R _ S U P P O R T   t   o r d e r   b y   1 , 2 (!  s e l e c t   
 
 a a a s . e m i t , 
 
 a a a s . f i l ,   
 
 a a a s . e m _ f i l , 
 
 a a a s . e n a m e ,   
 
 d e c o d e ( a a a s . e m a i l ,   n u l l ,   ' s u p p o r t @ f l e e t c o r . r u ' ,   a a a s . e m a i l )   e m a i l   f r o m   ( s e l e c t   f f r . * , d d d f . e m a i l   f r o m   
 
 ( s e l e c t   e m i t , 
 
               f i l , 
 
               ( e m i t   | |   ' _ '   | |   f i l )   e m _ f i l , 
 
               l i s t a g g ( c h r ( 1 0 )   | |   r r r ,   ' * ' )   W I T H I N   G R O U P ( o r d e r   b y   e m i t ,   f i l )   a s   e n a m e 
 
     f r o m   ( s e l e c t   N V L ( t e . S T K _ E M I T E N T _ I D ,   0 )   e m i t , 
 
                               t e . S T K _ F I L I A L _ I D   f i l , 
 
                               d e c o d e ( t f s . t r z _ t y p e , 
 
                                             2 4 , 
 
                                             ' >72@0B  ' , 
 
                                             2 2 , 
 
                                             ' >72@0B  =0  AG5B  :;85=B0  =0  B5@<8=0;5' , 
 
                                             2 3 , 
 
                                             ' $>@<8@>20=85  ' , 
 
                                             3 3 , 
 
                                             '  50;870F8O  ' , 
 
                                             1 , 
 
                                             ' 515B' , 
 
                                             2 , 
 
                                             ' >72@0B  =0  :0@BC' , 
 
                                             3 , 
 
                                             ' @548B  :0@BK' , 
 
                                             t f s . T R Z _ T Y P E )   | |   ' .   '   | |   ' 0B0. :   '   | | 
 
                               t o _ c h a r ( t f s . T E R M I N A L _ D A T E ,   ' D D - M O N - Y Y Y Y _ H H 2 4 : M I : S S ' )   | |   ' .   '   | | 
 
                               ' 0@B0: '   | |   t f s . C A R D N U M   | |   ' .   '   | |   ' >;- 2>: '   | | 
 
                               t f s . A M O U N T   | |   ' .   '   | |   c h r ( 1 0 )   | |   '   -<8B.   B5@<. :   '   | | 
 
                               t f s . A C Q U I R E R _ I D   | |   ' .   '   | |   ' !  B5@<. : '   | |   t f s . T E R M I N A L _ I D   | |   ' .   '   | |   / *   ' !  ": '   | |   t f s . P O S _ I D   | |   ' .   '   | | * / 
 
                               ' &5=0: '   | |   t f s . P R I C E   | |   ' .   '   | |   ' #A;C30: '   | |   t f s . S E R V I C E S _ I D   | |   ' .   '   | | 
 
                               ' !C<<0: '   | |   t f s . T S U M   | |   ' .   '   | |   c h r ( 1 0 )   | |   ' -<8B. !": '   | | 
 
                               N V L ( t e . S T K _ E M I T E N T _ I D ,   0 )   | |   ' .   '   | |   ' G U I D : '   | | 
 
                               t f s . T R A N S A C T I O N S _ I D   | |   c h r ( 1 0 )   | |   ' * * '   r r r 
 
                     f r o m   s e c . t r a n s a c t i o n s _ f o r _ s u p p o r t   t f s 
 
                   i n n e r   j o i n   s e c . t e r m i n a l _ e m i t e n t s _ f o r _ s u p p o r t   t e 
 
                         o n   ( t e . T E R M I N A L _ I D   =   t f s . T E R M I N A L _ I D   a n d 
 
                               t e . T E R M I N A L _ E M I T E N T _ I D   =   t f s . A C Q U I R E R _ I D ) 
 
                   i n n e r   j o i n   s e c . c a r d s _ f o r _ s u p p o r t   c 
 
                         o n   ( c . C A R D N U M   =   t f s . C A R D N U M ) 
 
                       a n d   t f s . T R Z _ S T A T E   =   0 
 
                       a n d   t f s . T E R M I N A L _ D A T E   <   t o _ d a t e ( S Y S D A T E   -   1 ) 
 
                       a n d   t f s . T E R M I N A L _ D A T E   >   t o _ d a t e ( S Y S D A T E   -   4 ) 
 
                       a n d   c . O N L I N E _ C A R D T Y P E   < >   1 ) 
 
   g r o u p   b y   e m i t ,   f i l 
 
   o r d e r   b y   e m i t ,   f i l )   f f r 
 
   l e f t   j o i n     
 
   ( s e l e c t   *   f r o m ( s e l e c t   e m i t e n t _ i d | |   ' _ '   | | f i l i a l _ i d   e m _ f i l s ,   e m a i l   f r o m   
 
 ( s e l e c t   2 3   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' m i h a i l l l @ m a i l . r u ; n a f t a _ s e r v i s @ m a i l . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   1 1 5   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' a r t u r 2 u @ y a n d e x . r u ; m a y @ u k n . r u ; p e a @ u k n . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   1 2 2   a s   e m i t e n t _ i d ,   1   a s   f i l i a l _ i d ,   ' d m v @ y n p . r u ; m r r @ y n p . r u ; c a r d u s e r @ y n p . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   1 2 7   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' a s e m e n o v @ l c a r d - t k . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   1 3 6   a s   e m i t e n t _ i d ,   1   a s   f i l i a l _ i d ,   ' t a t i a n a . k u z n e c o v a @ n e f t e m a r k e t . c o m '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   1 6 9   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' m a r g e l l a n @ g m a i l . c o m '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   1 7 4   a s   e m i t e n t _ i d ,   1   a s   f i l i a l _ i d ,   ' r u d a k o v i u @ o p t a n m . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   1 7 4   a s   e m i t e n t _ i d ,   2   a s   f i l i a l _ i d ,   ' r u d a k o v i u @ o p t a n m . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   1 9 7   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' b n u @ p o s t m x . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   2 3 6   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' i n f o @ a z s p r o s t o r . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   2 5 3   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' m a i l @ m a i l . c o m '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   2 5 5   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' m u s a y e v s h a k i r @ g m a i l . c o m '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   2 7 3   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' d . g r e c h i n @ t a i f - a z s . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   2 8 1   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' s u p e r 3 7 @ y a n d e x . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   2 9 4   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' m a i l @ m a i l . c o m '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   3 9 3   a s   e m i t e n t _ i d ,   1   a s   f i l i a l _ i d ,   ' 1 0 9 @ 8 1 8 5 . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   3 9 4   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' n c t @ i r k u t s k . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   4 1 1   a s   e m i t e n t _ i d ,   1   a s   f i l i a l _ i d ,   ' a m v @ a z s 6 3 . r u ; i n f o @ a z s - s m a r t . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   4 1 1   a s   e m i t e n t _ i d ,   2   a s   f i l i a l _ i d ,   ' a m v @ a z s 6 3 . r u ; i n f o @ a z s - s m a r t . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   4 1 1   a s   e m i t e n t _ i d ,   4   a s   f i l i a l _ i d ,   ' a m v @ a z s 6 3 . r u ; i n f o @ a z s - s m a r t . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   4 2 2   a s   e m i t e n t _ i d ,   1   a s   f i l i a l _ i d ,   ' s e r g e i . l a z a r e n k o @ c i r c l e k e u r o p e . c o m ; e k a t e r i n a . k u c h e r y a v e n k o @ c i r c l e k e u r o p e . c o m '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   4 4 3   a s   e m i t e n t _ i d ,   1   a s   f i l i a l _ i d ,   ' m a i l @ m a i l . c o m '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   4 4 3   a s   e m i t e n t _ i d ,   2   a s   f i l i a l _ i d ,   ' a . m a m y k i n @ g e s - p o v o l j e . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   4 4 3   a s   e m i t e n t _ i d ,   3   a s   f i l i a l _ i d ,   ' a . m a m y k i n @ g e s - p o v o l j e . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   4 4 3   a s   e m i t e n t _ i d ,   4   a s   f i l i a l _ i d ,   ' a . m a m y k i n @ g e s - p o v o l j e . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   4 4 3   a s   e m i t e n t _ i d ,   5   a s   f i l i a l _ i d ,   ' a . m a m y k i n @ g e s - p o v o l j e . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   4 4 3   a s   e m i t e n t _ i d ,   6   a s   f i l i a l _ i d ,   ' a . m a m y k i n @ g e s - p o v o l j e . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   4 4 3   a s   e m i t e n t _ i d ,   7   a s   f i l i a l _ i d ,   ' a . m a m y k i n @ g e s - p o v o l j e . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   4 4 3   a s   e m i t e n t _ i d ,   8   a s   f i l i a l _ i d ,   ' a . m a m y k i n @ g e s - p o v o l j e . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   4 4 3   a s   e m i t e n t _ i d ,   9   a s   f i l i a l _ i d ,   ' a . m a m y k i n @ g e s - p o v o l j e . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   4 6 6   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' s v i r i d e n k o v v y @ e k a . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   5 2 0   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' m a i l @ m a i l . c o m '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   5 2 2   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' a d m i n @ t o r e k o . c o m '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   5 2 3   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' t n p s . i t @ g m a i l . c o m ; j u l i a . t n p s @ m a i l . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   5 2 9   a s   e m i t e n t _ i d ,   1   a s   f i l i a l _ i d ,   ' v y c a r d @ g m a i l . c o m '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   5 3 3   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' m . a l e x @ f a e t o n . s p b . r u ; O . V a h r i n @ f a e t o n . s p b . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   5 3 4   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' s h a p u r k o @ n p s - a z s . r u ; n p s s 9 6 @ m a i l . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   5 4 1   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' v a l p o s t 7 0 @ m a i l . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   5 6 6   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' b b e n z i n @ m a i l . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   5 7 0   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' G r i s c h e n k o _ D @ s o v i n t e r . r u ; R a s s u d k o v a @ s o v i n t e r . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   5 8 2   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' a u g r a . s u r g u t @ m a i l . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   5 8 9   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' 1 9 3 @ p o c k o . r u ; r u s . i v c @ m a i l . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   6 9 5   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' m 1 0 - o i l @ m 1 0 - o i l . r u ; s y s a d m i n @ m 1 0 - o i l . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   7 0 1   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' a l f a n e f t @ l i s t . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   7 2 0   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' m a z a y @ a - 1 0 0 . b y '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   7 2 2   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' v t k - p r o g @ m a i l . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   7 2 7   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' m a i l @ m a i l . c o m '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   7 3 2   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' n u r a z s @ y a n d e x . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   7 4 2   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' p s - c a r d @ m a i l . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   7 4 3   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' a z s @ k r o n g s . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   7 4 4   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' o i l p l u s @ m a i l . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   7 5 2   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' m a i l @ m a i l . c o m '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   7 5 7   a s   e m i t e n t _ i d ,   1   a s   f i l i a l _ i d ,   ' u . p r o n i n @ p t k . r u ; e . b a r a n o v a @ p t k . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   7 5 7   a s   e m i t e n t _ i d ,   2   a s   f i l i a l _ i d ,   ' u . p r o n i n @ p t k . r u ; e . b a r a n o v a @ p t k . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   7 5 7   a s   e m i t e n t _ i d ,   3   a s   f i l i a l _ i d ,   ' u . p r o n i n @ p t k . r u ; e . b a r a n o v a @ p t k . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   7 5 7   a s   e m i t e n t _ i d ,   4   a s   f i l i a l _ i d ,   ' u . p r o n i n @ p t k . r u ; e . b a r a n o v a @ p t k . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   7 5 7   a s   e m i t e n t _ i d ,   5   a s   f i l i a l _ i d ,   ' u . p r o n i n @ p t k . r u ; e . b a r a n o v a @ p t k . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   7 5 7   a s   e m i t e n t _ i d ,   6   a s   f i l i a l _ i d ,   ' u . p r o n i n @ p t k . r u ; e . b a r a n o v a @ p t k . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   7 5 7   a s   e m i t e n t _ i d ,   7   a s   f i l i a l _ i d ,   ' u . p r o n i n @ p t k . r u ; e . b a r a n o v a @ p t k . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   7 5 7   a s   e m i t e n t _ i d ,   8   a s   f i l i a l _ i d ,   ' u . p r o n i n @ p t k . r u ; e . b a r a n o v a @ p t k . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   7 5 7   a s   e m i t e n t _ i d ,   9   a s   f i l i a l _ i d ,   ' u . p r o n i n @ p t k . r u ; e . b a r a n o v a @ p t k . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   7 5 7   a s   e m i t e n t _ i d ,   1 0   a s   f i l i a l _ i d ,   ' u . p r o n i n @ p t k . r u ; e . b a r a n o v a @ p t k . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   7 5 7   a s   e m i t e n t _ i d ,   1 1   a s   f i l i a l _ i d ,   ' u . p r o n i n @ p t k . r u ; e . b a r a n o v a @ p t k . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   7 6 6   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' p e t r o l 3 7 @ m a i l . r u ; v a v i l o v v m @ g m a i l . c o m '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   7 6 7   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' e k o y l @ y a . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   7 7 1   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' a v t o e k o n o m 2 0 1 1 @ m a i l . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   7 9 4   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' b e k a @ w i s s o l . g e ; m a x @ w i s s o l . g e '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   7 9 7   a s   e m i t e n t _ i d ,   1   a s   f i l i a l _ i d ,   ' a d m i n @ s i b t r o i l . c o m '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   7 9 7   a s   e m i t e n t _ i d ,   2   a s   f i l i a l _ i d ,   ' a d m i n @ s i b t r o i l . c o m '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   8 0 5   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' o c 8 0 5 @ b e n z o k a r t a . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   8 1 1   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' m i s h a t k i n . a p @ t r a s s a g k . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   8 1 9   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' a n o s o v a @ s u n p e t r o l . r u ; s . k o z l o v @ s u n p e t r o l . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   8 2 4   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' g o w a a @ y a n d e x . r u ; u r e n n p @ m a i l . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   8 2 7   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' m a x @ r e a d y . t k ; s u p p o r t @ s e l e c t p r o . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   8 3 4   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' s a n a k i n 8 8 @ m a i l . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   8 4 6   a s   e m i t e n t _ i d ,   2   a s   f i l i a l _ i d ,   ' c n p s @ y a n d e x . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   8 4 7   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' i . g . s e r v i c e @ y a n d e x . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   8 9 1   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' e a . t r a n s c a r t @ m a i l . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   9 0 7   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' e u c h @ l i n o s . s u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   9 0 8   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' m a i l @ m a i l . c o m '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   9 1 2   a s   e m i t e n t _ i d ,   1   a s   f i l i a l _ i d ,   ' o l g a @ t p - c e n t e r . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   9 1 2   a s   e m i t e n t _ i d ,   2   a s   f i l i a l _ i d ,   ' o l g a @ t p - c e n t e r . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   9 1 4   a s   e m i t e n t _ i d ,   1   a s   f i l i a l _ i d ,   ' s v @ f t c a r d . r u ; t k k @ f t c a r d . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   9 1 4   a s   e m i t e n t _ i d ,   2   a s   f i l i a l _ i d ,   ' s v @ f t c a r d . r u ; t k k @ f t c a r d . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   9 1 4   a s   e m i t e n t _ i d ,   7   a s   f i l i a l _ i d ,   ' s v @ f t c a r d . r u ; t k k @ f t c a r d . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   9 1 4   a s   e m i t e n t _ i d ,   8   a s   f i l i a l _ i d ,   ' s v @ f t c a r d . r u ; t k k @ f t c a r d . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   9 5 1   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' m a r i u s . b o r o d a c h i @ r o m p e t r o l . c o m '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   9 5 3   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' s h a n s v @ y a n d e x . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   9 5 8   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' n o v i k o v a 1 5 9 5 @ m a i l . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   9 6 2   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' i v a n @ d o r i s s n e f t . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   9 6 7   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' d g e n a k o v a @ n e f t m . r u ; f i l u k o v @ n e f t m . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   9 6 8   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' n i c e _ k 2 @ m a i l . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   9 6 9   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' a d a m i r c h i y a n @ y a n d e x . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   9 7 2   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' p i k t k . m a i l @ m a i l . r u ; v a s . 1 1 @ m a i l . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   9 7 8   a s   e m i t e n t _ i d ,   1   a s   f i l i a l _ i d ,   ' k o p o s o v . a v @ a s t r a - a z s . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   9 7 8   a s   e m i t e n t _ i d ,   7   a s   f i l i a l _ i d ,   ' k o p o s o v . a v @ a s t r a - a z s . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   9 8 0   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' b e r l i o - p i t e r @ m a i l . r u ; t o - c a r d @ y a n d e x . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   1 0 0 5   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' a l e k s e y . s c h m e l e v @ p e t r o l c a r d s . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   1 0 0 8   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' i r i n a @ e l f - o i l . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   1 0 2 0   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' a d m i n @ m a s t e r s c a r d . r u ; i g o r @ m a s t e r s c a r d . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   1 0 3 6   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' b a r y s h e v o o @ r e g i o n a z s . r u ; p a n c h e n k o b a @ r e g i o n a z s . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   1 0 3 7   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' o v i s @ o v i s . u a '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   1 0 6 7   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' m a r i y a . g a z o i l @ m a i l . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   1 0 6 8   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' r u s o v a g n @ a z s t e r m i n a l . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   1 0 7 4   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' d . n . f e d o r o v @ s o u z i k . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   1 0 9 4   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' m a i l @ m a i l . c o m '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   1 1 0 4   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' 9 2 0 3 6 1 3 5 3 8 @ m a i l . r u ; n e f t t r a n z i t @ m a i l . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   1 1 0 8   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' a d m i n @ u - a l l i a n c e . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   1 1 2 8   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' b t i s e r p @ m a i l . r u ; m o r o z o v a g 1 7 @ m a i l . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   1 1 3 1   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' 2 4 6 5 3 2 1 0 @ m a i l . r u ; t e c h - d a l @ m a i l . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   1 1 4 8   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' t r a n s p e t r o l 7 2 @ m a i l . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   1 1 5 3   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' a l g a z t r a n s @ y a n d e x . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   1 1 5 8   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' s u p e r . r n - a n @ y a n d e x . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   1 1 6 2   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' a n t o n @ c a r d - o i l . r u ; i n f o @ c a r d - o i l . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   1 1 9 6   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' b e r i k _ a k t o b e @ m a i l . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   1 4 4 4   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' k m a @ r m k a r t . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   1 5 5 0   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' 0 9 . 1 1 7 @ s h 5 2 . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   1 5 5 1   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' a v @ v e r v e x . r u ; n m @ v e r v e x . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   1 5 6 5   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' g r e e n l i n e 1 1 6 @ b k . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   1 5 7 0   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' d m i t r i v k @ t c o i l . r u ; i n f o @ i r b i s c a r d . r u ; T i m u r R S @ t c o i l . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   1 5 7 5   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' t p k a d m i n @ e x p c a r d . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   2 0 0 8   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' M a r i y a . S e m e n o v a @ f o o d c a r d s . r u ; Y a n a . M u s i n o v a @ f o o d c a r d s . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   2 0 1 2   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' a d m i n @ v t k 3 4 . r u ; e z h i h i n a @ v t k 3 4 . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   2 2 1 1   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' m i s h a t k i n . a p @ t r a s s a g k . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t     2 0 7 6     a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' a t i k h o n o v @ v o l g a - i n t e r . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t     2 1 3 1     a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' m a i l @ m a i l . c o m '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t     3 0 0 0     a s   e m i t e n t _ i d ,   1   a s   f i l i a l _ i d ,   ' a l e k s e y . s c h m e l e v @ p e t r o l c a r d s . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t     3 0 0 0     a s   e m i t e n t _ i d ,   2   a s   f i l i a l _ i d ,   ' a l e k s e y . s c h m e l e v @ p e t r o l c a r d s . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t     3 0 0 5     a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' a l e k s e y . s c h m e l e v @ p e t r o l c a r d s . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t     3 0 5 0     a s   e m i t e n t _ i d ,   1   a s   f i l i a l _ i d ,   ' a l e k s e y . s c h m e l e v @ p e t r o l c a r d s . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t     3 0 5 0     a s   e m i t e n t _ i d ,   2   a s   f i l i a l _ i d ,   ' a l e k s e y . s c h m e l e v @ p e t r o l c a r d s . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t     3 0 5 0     a s   e m i t e n t _ i d ,   3   a s   f i l i a l _ i d ,   ' a l e k s e y . s c h m e l e v @ p e t r o l c a r d s . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t     4 0 9 1     a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' a l e k s e y . s c h m e l e v @ p e t r o l c a r d s . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t     4 0 9 2     a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' a l e k s e y . s c h m e l e v @ p e t r o l c a r d s . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t     4 0 9 3     a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' a l e k s e y . s c h m e l e v @ p e t r o l c a r d s . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t     4 0 9 4     a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' a l e k s e y . s c h m e l e v @ p e t r o l c a r d s . r u '   a s   e m a i l   f r o m   d u a l     )   m a i l )   s s s d ) d d d f 
 
 
 
 o n   f f r . E M _ F I L = d d d f . e m _ f i l s )   a a a s     
 
 
 
 u n i o n   a l l 
 
 
 
 s e l e c t   
 
 a a a s . e m i t , 
 
 a a a s . f i l ,   
 
 a a a s . e m _ f i l , 
 
 a a a s . e n a m e ,   
 
 d e c o d e ( a a a s . e m a i l ,   n u l l ,   ' s u p p o r t @ f l e e t c o r . r u ' ,   a a a s . e m a i l )   e m a i l   f r o m   ( s e l e c t   f f r . * , d d d f . e m a i l   f r o m   
 
 ( s e l e c t   e m i t , 
 
               f i l , 
 
               ( e m i t   | |   ' _ '   | |   f i l )   e m _ f i l , 
 
               l i s t a g g ( c h r ( 1 0 )   | |   r r r ,   ' * ' )   W I T H I N   G R O U P ( o r d e r   b y   e m i t ,   f i l )   a s   e n a m e 
 
     f r o m   ( s e l e c t   N V L ( t e . S T K _ E M I T E N T _ I D ,   0 )   e m i t , 
 
                               t e . S T K _ F I L I A L _ I D   f i l , 
 
                               d e c o d e ( t f s . t r z _ t y p e , 
 
                                             2 4 , 
 
                                             ' >72@0B  ' , 
 
                                             2 2 , 
 
                                             ' >72@0B  =0  AG5B  :;85=B0  =0  B5@<8=0;5' , 
 
                                             2 3 , 
 
                                             ' $>@<8@>20=85  ' , 
 
                                             3 3 , 
 
                                             '  50;870F8O  ' , 
 
                                             1 , 
 
                                             ' 515B' , 
 
                                             2 , 
 
                                             ' >72@0B  =0  :0@BC' , 
 
                                             3 , 
 
                                             ' @548B  :0@BK' , 
 
                                             t f s . T R Z _ T Y P E )   | |   ' .   '   | |   ' 0B0. :   '   | | 
 
                               t o _ c h a r ( t f s . T E R M I N A L _ D A T E ,   ' D D - M O N - Y Y Y Y _ H H 2 4 : M I : S S ' )   | |   ' .   '   | | 
 
                               ' 0@B0: '   | |   t f s . C A R D N U M   | |   ' .   '   | |   ' >;- 2>: '   | | 
 
                               t f s . A M O U N T   | |   ' .   '   | |   c h r ( 1 0 )   | |   '   -<8B.   B5@<. :   '   | | 
 
                               t f s . A C Q U I R E R _ I D   | |   ' .   '   | |   ' !  B5@<. : '   | |   t f s . T E R M I N A L _ I D   | |   ' .   '   | |   / *   ' !  ": '   | |   t f s . P O S _ I D   | |   ' .   '   | | * / 
 
                               ' &5=0: '   | |   t f s . P R I C E   | |   ' .   '   | |   ' #A;C30: '   | |   t f s . S E R V I C E S _ I D   | |   ' .   '   | | 
 
                               ' !C<<0: '   | |   t f s . T S U M   | |   ' .   '   | |   c h r ( 1 0 )   | |   ' -<8B. !": '   | | 
 
                               N V L ( t e . S T K _ E M I T E N T _ I D ,   0 )   | |   ' .   '   | |   ' G U I D : '   | | 
 
                               t f s . T R A N S A C T I O N S _ I D   | |   c h r ( 1 0 )   | |   ' * * '   r r r 
 
                     f r o m   s e c . t r a n s a c t i o n s _ f o r _ s u p p o r t   t f s 
 
                   i n n e r   j o i n   s e c . t e r m i n a l _ e m i t e n t s _ f o r _ s u p p o r t   t e 
 
                         o n   ( t e . T E R M I N A L _ I D   =   t f s . T E R M I N A L _ I D   a n d 
 
                               t e . T E R M I N A L _ E M I T E N T _ I D   =   t f s . A C Q U I R E R _ I D ) 
 
                   i n n e r   j o i n   s e c . c a r d s _ f o r _ s u p p o r t   c 
 
                         o n   ( c . C A R D N U M   =   t f s . C A R D N U M ) 
 
                       a n d   t f s . T R Z _ S T A T E   =   0 
 
                       a n d   t f s . T E R M I N A L _ D A T E   <   t o _ d a t e ( S Y S D A T E   -   4 ) 
 
                       a n d   t f s . T E R M I N A L _ D A T E   >   t o _ d a t e ( S Y S D A T E   -   9 ) 
 
                       a n d   c . O N L I N E _ C A R D T Y P E   < >   1 ) 
 
   g r o u p   b y   e m i t ,   f i l 
 
   o r d e r   b y   e m i t ,   f i l )   f f r 
 
   l e f t   j o i n     
 
   ( s e l e c t   *   f r o m ( s e l e c t   e m i t e n t _ i d | |   ' _ '   | | f i l i a l _ i d   e m _ f i l s ,   e m a i l   f r o m   
 
 ( s e l e c t   2 3   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' m i h a i l l l @ m a i l . r u ; n a f t a _ s e r v i s @ m a i l . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   1 1 5   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' a r t u r 2 u @ y a n d e x . r u ; m a y @ u k n . r u ; p e a @ u k n . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   1 2 2   a s   e m i t e n t _ i d ,   1   a s   f i l i a l _ i d ,   ' d m v @ y n p . r u ; m r r @ y n p . r u ; c a r d u s e r @ y n p . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   1 2 7   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' a s e m e n o v @ l c a r d - t k . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   1 3 6   a s   e m i t e n t _ i d ,   1   a s   f i l i a l _ i d ,   ' t a t i a n a . k u z n e c o v a @ n e f t e m a r k e t . c o m '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   1 6 9   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' m a r g e l l a n @ g m a i l . c o m '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   1 7 4   a s   e m i t e n t _ i d ,   1   a s   f i l i a l _ i d ,   ' r u d a k o v i u @ o p t a n m . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   1 7 4   a s   e m i t e n t _ i d ,   2   a s   f i l i a l _ i d ,   ' r u d a k o v i u @ o p t a n m . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   1 9 7   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' b n u @ p o s t m x . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   2 3 6   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' i n f o @ a z s p r o s t o r . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   2 5 3   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' m a i l @ m a i l . c o m '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   2 5 5   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' m u s a y e v s h a k i r @ g m a i l . c o m '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   2 7 3   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' d . g r e c h i n @ t a i f - a z s . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   2 8 1   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' s u p e r 3 7 @ y a n d e x . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   2 9 4   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' m a i l @ m a i l . c o m '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   3 9 3   a s   e m i t e n t _ i d ,   1   a s   f i l i a l _ i d ,   ' 1 0 9 @ 8 1 8 5 . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   3 9 4   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' n c t @ i r k u t s k . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   4 1 1   a s   e m i t e n t _ i d ,   1   a s   f i l i a l _ i d ,   ' a m v @ a z s 6 3 . r u ; i n f o @ a z s - s m a r t . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   4 1 1   a s   e m i t e n t _ i d ,   2   a s   f i l i a l _ i d ,   ' a m v @ a z s 6 3 . r u ; i n f o @ a z s - s m a r t . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   4 1 1   a s   e m i t e n t _ i d ,   4   a s   f i l i a l _ i d ,   ' a m v @ a z s 6 3 . r u ; i n f o @ a z s - s m a r t . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   4 2 2   a s   e m i t e n t _ i d ,   1   a s   f i l i a l _ i d ,   ' s e r g e i . l a z a r e n k o @ c i r c l e k e u r o p e . c o m ; e k a t e r i n a . k u c h e r y a v e n k o @ c i r c l e k e u r o p e . c o m '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   4 4 3   a s   e m i t e n t _ i d ,   1   a s   f i l i a l _ i d ,   ' m a i l @ m a i l . c o m '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   4 4 3   a s   e m i t e n t _ i d ,   2   a s   f i l i a l _ i d ,   ' a . m a m y k i n @ g e s - p o v o l j e . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   4 4 3   a s   e m i t e n t _ i d ,   3   a s   f i l i a l _ i d ,   ' a . m a m y k i n @ g e s - p o v o l j e . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   4 4 3   a s   e m i t e n t _ i d ,   4   a s   f i l i a l _ i d ,   ' a . m a m y k i n @ g e s - p o v o l j e . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   4 4 3   a s   e m i t e n t _ i d ,   5   a s   f i l i a l _ i d ,   ' a . m a m y k i n @ g e s - p o v o l j e . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   4 4 3   a s   e m i t e n t _ i d ,   6   a s   f i l i a l _ i d ,   ' a . m a m y k i n @ g e s - p o v o l j e . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   4 4 3   a s   e m i t e n t _ i d ,   7   a s   f i l i a l _ i d ,   ' a . m a m y k i n @ g e s - p o v o l j e . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   4 4 3   a s   e m i t e n t _ i d ,   8   a s   f i l i a l _ i d ,   ' a . m a m y k i n @ g e s - p o v o l j e . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   4 4 3   a s   e m i t e n t _ i d ,   9   a s   f i l i a l _ i d ,   ' a . m a m y k i n @ g e s - p o v o l j e . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   4 6 6   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' s v i r i d e n k o v v y @ e k a . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   5 2 0   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' m a i l @ m a i l . c o m '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   5 2 2   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' a d m i n @ t o r e k o . c o m '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   5 2 3   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' t n p s . i t @ g m a i l . c o m ; j u l i a . t n p s @ m a i l . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   5 2 9   a s   e m i t e n t _ i d ,   1   a s   f i l i a l _ i d ,   ' v y c a r d @ g m a i l . c o m '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   5 3 3   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' m . a l e x @ f a e t o n . s p b . r u ; O . V a h r i n @ f a e t o n . s p b . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   5 3 4   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' s h a p u r k o @ n p s - a z s . r u ; n p s s 9 6 @ m a i l . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   5 4 1   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' v a l p o s t 7 0 @ m a i l . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   5 6 6   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' b b e n z i n @ m a i l . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   5 7 0   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' G r i s c h e n k o _ D @ s o v i n t e r . r u ; R a s s u d k o v a @ s o v i n t e r . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   5 8 2   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' a u g r a . s u r g u t @ m a i l . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   5 8 9   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' 1 9 3 @ p o c k o . r u ; r u s . i v c @ m a i l . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   6 9 5   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' m 1 0 - o i l @ m 1 0 - o i l . r u ; s y s a d m i n @ m 1 0 - o i l . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   7 0 1   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' a l f a n e f t @ l i s t . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   7 2 0   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' m a z a y @ a - 1 0 0 . b y '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   7 2 2   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' v t k - p r o g @ m a i l . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   7 2 7   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' m a i l @ m a i l . c o m '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   7 3 2   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' n u r a z s @ y a n d e x . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   7 4 2   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' p s - c a r d @ m a i l . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   7 4 3   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' a z s @ k r o n g s . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   7 4 4   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' o i l p l u s @ m a i l . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   7 5 2   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' m a i l @ m a i l . c o m '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   7 5 7   a s   e m i t e n t _ i d ,   1   a s   f i l i a l _ i d ,   ' u . p r o n i n @ p t k . r u ; e . b a r a n o v a @ p t k . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   7 5 7   a s   e m i t e n t _ i d ,   2   a s   f i l i a l _ i d ,   ' u . p r o n i n @ p t k . r u ; e . b a r a n o v a @ p t k . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   7 5 7   a s   e m i t e n t _ i d ,   3   a s   f i l i a l _ i d ,   ' u . p r o n i n @ p t k . r u ; e . b a r a n o v a @ p t k . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   7 5 7   a s   e m i t e n t _ i d ,   4   a s   f i l i a l _ i d ,   ' u . p r o n i n @ p t k . r u ; e . b a r a n o v a @ p t k . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   7 5 7   a s   e m i t e n t _ i d ,   5   a s   f i l i a l _ i d ,   ' u . p r o n i n @ p t k . r u ; e . b a r a n o v a @ p t k . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   7 5 7   a s   e m i t e n t _ i d ,   6   a s   f i l i a l _ i d ,   ' u . p r o n i n @ p t k . r u ; e . b a r a n o v a @ p t k . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   7 5 7   a s   e m i t e n t _ i d ,   7   a s   f i l i a l _ i d ,   ' u . p r o n i n @ p t k . r u ; e . b a r a n o v a @ p t k . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   7 5 7   a s   e m i t e n t _ i d ,   8   a s   f i l i a l _ i d ,   ' u . p r o n i n @ p t k . r u ; e . b a r a n o v a @ p t k . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   7 5 7   a s   e m i t e n t _ i d ,   9   a s   f i l i a l _ i d ,   ' u . p r o n i n @ p t k . r u ; e . b a r a n o v a @ p t k . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   7 5 7   a s   e m i t e n t _ i d ,   1 0   a s   f i l i a l _ i d ,   ' u . p r o n i n @ p t k . r u ; e . b a r a n o v a @ p t k . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   7 5 7   a s   e m i t e n t _ i d ,   1 1   a s   f i l i a l _ i d ,   ' u . p r o n i n @ p t k . r u ; e . b a r a n o v a @ p t k . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   7 6 6   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' p e t r o l 3 7 @ m a i l . r u ; v a v i l o v v m @ g m a i l . c o m '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   7 6 7   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' e k o y l @ y a . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   7 7 1   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' a v t o e k o n o m 2 0 1 1 @ m a i l . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   7 9 4   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' b e k a @ w i s s o l . g e ; m a x @ w i s s o l . g e '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   7 9 7   a s   e m i t e n t _ i d ,   1   a s   f i l i a l _ i d ,   ' a d m i n @ s i b t r o i l . c o m '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   7 9 7   a s   e m i t e n t _ i d ,   2   a s   f i l i a l _ i d ,   ' a d m i n @ s i b t r o i l . c o m '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   8 0 5   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' o c 8 0 5 @ b e n z o k a r t a . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   8 1 1   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' m i s h a t k i n . a p @ t r a s s a g k . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   8 1 9   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' a n o s o v a @ s u n p e t r o l . r u ; s . k o z l o v @ s u n p e t r o l . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   8 2 4   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' g o w a a @ y a n d e x . r u ; u r e n n p @ m a i l . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   8 2 7   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' m a x @ r e a d y . t k ; s u p p o r t @ s e l e c t p r o . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   8 3 4   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' s a n a k i n 8 8 @ m a i l . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   8 4 6   a s   e m i t e n t _ i d ,   2   a s   f i l i a l _ i d ,   ' c n p s @ y a n d e x . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   8 4 7   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' i . g . s e r v i c e @ y a n d e x . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   8 9 1   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' e a . t r a n s c a r t @ m a i l . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   9 0 7   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' e u c h @ l i n o s . s u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   9 0 8   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' m a i l @ m a i l . c o m '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   9 1 2   a s   e m i t e n t _ i d ,   1   a s   f i l i a l _ i d ,   ' o l g a @ t p - c e n t e r . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   9 1 2   a s   e m i t e n t _ i d ,   2   a s   f i l i a l _ i d ,   ' o l g a @ t p - c e n t e r . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   9 1 4   a s   e m i t e n t _ i d ,   1   a s   f i l i a l _ i d ,   ' s v @ f t c a r d . r u ; t k k @ f t c a r d . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   9 1 4   a s   e m i t e n t _ i d ,   2   a s   f i l i a l _ i d ,   ' s v @ f t c a r d . r u ; t k k @ f t c a r d . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   9 1 4   a s   e m i t e n t _ i d ,   7   a s   f i l i a l _ i d ,   ' s v @ f t c a r d . r u ; t k k @ f t c a r d . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   9 1 4   a s   e m i t e n t _ i d ,   8   a s   f i l i a l _ i d ,   ' s v @ f t c a r d . r u ; t k k @ f t c a r d . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   9 5 1   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' m a r i u s . b o r o d a c h i @ r o m p e t r o l . c o m '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   9 5 3   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' s h a n s v @ y a n d e x . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   9 5 8   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' n o v i k o v a 1 5 9 5 @ m a i l . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   9 6 2   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' i v a n @ d o r i s s n e f t . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   9 6 7   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' d g e n a k o v a @ n e f t m . r u ; f i l u k o v @ n e f t m . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   9 6 8   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' n i c e _ k 2 @ m a i l . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   9 6 9   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' a d a m i r c h i y a n @ y a n d e x . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   9 7 2   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' p i k t k . m a i l @ m a i l . r u ; v a s . 1 1 @ m a i l . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   9 7 8   a s   e m i t e n t _ i d ,   1   a s   f i l i a l _ i d ,   ' k o p o s o v . a v @ a s t r a - a z s . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   9 7 8   a s   e m i t e n t _ i d ,   7   a s   f i l i a l _ i d ,   ' k o p o s o v . a v @ a s t r a - a z s . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   9 8 0   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' b e r l i o - p i t e r @ m a i l . r u ; t o - c a r d @ y a n d e x . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   1 0 0 5   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' a l e k s e y . s c h m e l e v @ p e t r o l c a r d s . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   1 0 0 8   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' i r i n a @ e l f - o i l . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   1 0 2 0   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' a d m i n @ m a s t e r s c a r d . r u ; i g o r @ m a s t e r s c a r d . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   1 0 3 6   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' b a r y s h e v o o @ r e g i o n a z s . r u ; p a n c h e n k o b a @ r e g i o n a z s . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   1 0 3 7   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' o v i s @ o v i s . u a '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   1 0 6 7   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' m a r i y a . g a z o i l @ m a i l . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   1 0 6 8   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' r u s o v a g n @ a z s t e r m i n a l . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   1 0 7 4   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' d . n . f e d o r o v @ s o u z i k . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   1 0 9 4   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' m a i l @ m a i l . c o m '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   1 1 0 4   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' 9 2 0 3 6 1 3 5 3 8 @ m a i l . r u ; n e f t t r a n z i t @ m a i l . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   1 1 0 8   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' a d m i n @ u - a l l i a n c e . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   1 1 2 8   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' b t i s e r p @ m a i l . r u ; m o r o z o v a g 1 7 @ m a i l . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   1 1 3 1   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' 2 4 6 5 3 2 1 0 @ m a i l . r u ; t e c h - d a l @ m a i l . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   1 1 4 8   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' t r a n s p e t r o l 7 2 @ m a i l . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   1 1 5 3   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' a l g a z t r a n s @ y a n d e x . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   1 1 5 8   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' s u p e r . r n - a n @ y a n d e x . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   1 1 6 2   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' a n t o n @ c a r d - o i l . r u ; i n f o @ c a r d - o i l . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   1 1 9 6   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' b e r i k _ a k t o b e @ m a i l . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   1 4 4 4   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' k m a @ r m k a r t . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   1 5 5 0   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' 0 9 . 1 1 7 @ s h 5 2 . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   1 5 5 1   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' a v @ v e r v e x . r u ; n m @ v e r v e x . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   1 5 6 5   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' g r e e n l i n e 1 1 6 @ b k . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   1 5 7 0   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' d m i t r i v k @ t c o i l . r u ; i n f o @ i r b i s c a r d . r u ; T i m u r R S @ t c o i l . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   1 5 7 5   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' t p k a d m i n @ e x p c a r d . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   2 0 0 8   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' M a r i y a . S e m e n o v a @ f o o d c a r d s . r u ; Y a n a . M u s i n o v a @ f o o d c a r d s . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   2 0 1 2   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' a d m i n @ v t k 3 4 . r u ; e z h i h i n a @ v t k 3 4 . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t   2 2 1 1   a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' m i s h a t k i n . a p @ t r a s s a g k . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t     2 0 7 6     a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' a t i k h o n o v @ v o l g a - i n t e r . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t     2 1 3 1     a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' m a i l @ m a i l . c o m '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t     3 0 0 0     a s   e m i t e n t _ i d ,   1   a s   f i l i a l _ i d ,   ' a l e k s e y . s c h m e l e v @ p e t r o l c a r d s . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t     3 0 0 0     a s   e m i t e n t _ i d ,   2   a s   f i l i a l _ i d ,   ' a l e k s e y . s c h m e l e v @ p e t r o l c a r d s . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t     3 0 0 5     a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' a l e k s e y . s c h m e l e v @ p e t r o l c a r d s . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t     3 0 5 0     a s   e m i t e n t _ i d ,   1   a s   f i l i a l _ i d ,   ' a l e k s e y . s c h m e l e v @ p e t r o l c a r d s . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t     3 0 5 0     a s   e m i t e n t _ i d ,   2   a s   f i l i a l _ i d ,   ' a l e k s e y . s c h m e l e v @ p e t r o l c a r d s . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t     3 0 5 0     a s   e m i t e n t _ i d ,   3   a s   f i l i a l _ i d ,   ' a l e k s e y . s c h m e l e v @ p e t r o l c a r d s . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t     4 0 9 1     a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' a l e k s e y . s c h m e l e v @ p e t r o l c a r d s . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t     4 0 9 2     a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' a l e k s e y . s c h m e l e v @ p e t r o l c a r d s . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t     4 0 9 3     a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' a l e k s e y . s c h m e l e v @ p e t r o l c a r d s . r u '   a s   e m a i l   f r o m   d u a l   U N I O N   A L L 
 
 s e l e c t     4 0 9 4     a s   e m i t e n t _ i d ,   0   a s   f i l i a l _ i d ,   ' a l e k s e y . s c h m e l e v @ p e t r o l c a r d s . r u '   a s   e m a i l   f r o m   d u a l   )   m a i l )   s s s d ) d d d f 
 
 
 
 o n   f f r . E M _ F I L = d d d f . e m _ f i l s )   a a a s        s e l e c t   t . C A R D N U M   a s   0@B0, 
 
               d e c o d e ( t . S T A T E , 
 
                             ' 0 ' , 
 
                             ' !>740=>- 2  @01>B5' , 
 
                             ' 1 ' , 
 
                             ' K?>;=5=>' , 
 
                             ' 2 ' , 
 
                             ' K?>;=5=>  A  >H81:>9' , 
 
                             ' 3 ' , 
 
                             ' #40;5=>  2  &' , 
 
                             t . S T A T E )   a s   !>AB>O=85, 
 
               t . C R E A T E _ D A T E   !>740=>_ 2_ &, 
 
               d e c o d e ( t . O P E R , 
 
                             ' 1 ' , 
 
                             ' B;>65==>5  ?>?>;=5=85  -' , 
 
                             ' 2 ' , 
 
                             ' B;>65==>5  A?8A0=85  -' , 
 
                             ' 3 ' , 
 
                             ' 7<5=5=85  <0:A8<0;L=>3>  >1I53>  ;8<8B0  ' , 
 
                             ' 4 ' , 
 
                             ' 7<5=5=85  <0:A8<0;L=>3>  AC<<0@=>3>  ;8<8B0  ' , 
 
                             ' 5 ' , 
 
                             ' 7<5=5=85  $  2>48B5;O' , 
 
                             ' 6 ' , 
 
                             ' 7<5=5=85  :><?0=88' , 
 
                             ' 7 ' , 
 
                             ' 7<5=5=85  =><5@0  <0H8=K' , 
 
                             ' 8 ' , 
 
                             ' 7<5=5=85  B8?0  8/ 8;8  ?5@8>48G=>AB8  ;8<8B0  :>H5;L:0' , 
 
                             ' 9 ' , 
 
                             ' 7<5=5=85  @568<0  @01>BK  :0@BK' , 
 
                             ' 1 0 ' , 
 
                             ' >102;5=85  :>H5;L:0' , 
 
                             ' 1 1 ' , 
 
                             ' #40;5=85  :>H5;L:0' , 
 
                             ' 1 2 ' , 
 
                             ' 7<5=5=85  <0:A8<0;L=>3>  10;0=A0' , 
 
                             ' 1 3 ' , 
 
                             ' 7<5=5=85  =><5@>2  D8@<K  8  D8;80;0' , 
 
                             ' 1 4 ' , 
 
                             ' 7<5=5=85  40BK  ?>A;54=53>  >1A;C6820=8O' , 
 
                             ' 1 5 ' , 
 
                             ' #40;Q==>5  87<5=5=85  P I N   ?>;L7>20B5;O' , 
 
                             ' 1 6 ' , 
 
                             ' !1@>A  :>;8G5AB20  >AB02H8EAO  ?>?KB>:  22>40  P I N   ( U N L O C K   :0@BK) ' , 
 
                             ' 1 7 ' , 
 
                             ' #AB0=>2:0  B5:CI53>  7=0G5=8O  8=48284C0;L=>3>  ;8<8B0' , 
 
                             ' 1 8 ' , 
 
                             ' #AB0=>2:0  B5:CI53>  7=0G5=8O  >1I53>  ;8<8B0' , 
 
                             ' 1 9 ' , 
 
                             ' #AB0=>2:0  B5:CI53>  7=0G5=8O  AC<<0@=>3>  ;8<8B0' , 
 
                             ' 2 0 ' , 
 
                             ' !1@>A/ CAB0=>2:0  :>;8G5AB20  >AB02H8EAO  ?>?KB>:  22>40  P I N ,   1;>:8@>2:0/ @071;>:8@>2:0  P I N ' , 
 
                             ' 2 1 ' , 
 
                             ' @>2545=85  >B;>65==>3>  2>72@0B0  A  2>AAB0=>2;5=85<  10;0=A0/ ;8<8B>2' , 
 
                             ' =><5@  >?5@0F88-   '   | |   t . O P E R   | |   '   - CB>G=8BL  2  &' )   a s   ?5@0F8O, 
 
               d e c o d e ( t . S E R V I C E _ I D , 
 
                             q . s e r v i c e s _ i d , 
 
                             t . S E R V I C E _ I D   | |   '   -   '   | |   q . s e r v i c e _ n a m e , 
 
                             t . S E R V I C E _ I D )   a s   CA;C30, 
 
               d e c o d e ( t . S C H E M E ,   ' 1 ' ,   ' -' ,   ' 2 ' ,   ' !' ,   t . S C H E M E )   a s   !E5<0, 
 
               d e c o d e ( t . L I M I T _ T Y P E , 
 
                             ' 1 ' , 
 
                             ' 1I89' , 
 
                             ' 2 ' , 
 
                             ' =48284C0;L=K9' , 
 
                             t . L I M I T _ T Y P E )   a s   "8?_ ;8<8B0, 
 
               d e c o d e ( t . P E R I O D I T Y _ L I M I T , 
 
                             ' 1 ' , 
 
                             ' !CB>G=K9' , 
 
                             ' 2 ' , 
 
                             ' 545;L=K9' , 
 
                             ' 3 ' , 
 
                             ' 5AOG=K9' , 
 
                             t . P E R I O D I T Y _ L I M I T )   a s   5@8>4_ ;8<8B0, 
 
               t . C U R R E N T _ L I M I T   /   P O W E R ( 1 0 ,   t . P R E C )   a s   "5:_ ;8<8B, 
 
               t . M A X _ L I M I T   /   P O W E R ( 1 0 ,   t . P R E C )   a s   0:A_ ;8<8B, 
 
               t . B A L A N C E   /   P O W E R ( 1 0 ,   t . P R E C )   a s   0;0=A, 
 
               t . T S   a s   0B0_ 70?8A8, 
 
               t . M A X _ B A L A N C E   a s   0:A_ 10;0=A, 
 
               t . D C V _ N A M E   a s   #AB0=_ $_ =072_ :><?_ =><5@"!, 
 
               t . O N L _ C A R D _ T Y P E   a s    07@5H_ =0_ o f f l i n e _ >1A;, 
 
               t . F I R M _ N U M B E R   a s   #AB0=_ =><5@_ D8@<K, 
 
               t . F I L I A L _ N U M B E R   a s   #AB0=_ =><5@_ D8;80;0, 
 
               t . L S D   a s   #AB0=_ , 
 
               t . E X P _ D A T E , 
 
               t . I S S U E R _ I D   a s   -<, 
 
               t . F I L I A L _ I D   a s   F , 
 
               t . P R E C   a s   ">G=>ABL, 
 
               t . P S N   a s   ?@2K?_ :@B, 
 
               t . C R Y P T _ N U M _ O C   a s   ><5@_ :@8?B>3@0<<K_ &
 
     f r o m   S E C . C G   t 
 
     L E F T   O U T E R   J O I N   s e c . S E R V I C E S   q 
 
         O N   t . I S S U E R _ I D   =   q . E M I T E N T _ I D 
 
       a n d   t . S E R V I C E _ I D   =   q . s e r v i c e s _ i d 
 
   w h e r e   t . C A R D N U M   = 9o r d e r   b y   t . C R Y P T _ N U M _ O C   d e s c  s e l e c t   t . C A R D N U M   a s   0@B0, 
 
               d e c o d e ( t . S E R V I C E S _ I D , 
 
                             q . s e r v i c e s _ i d , 
 
                             t . S E R V I C E S _ I D   | |   '   -   '   | |   q . s e r v i c e _ n a m e , 
 
                             0 , 
 
                             ' ' , 
 
                             t . S E R V I C E S _ I D )   a s   #A;C30, 
 
               d e c o d e ( t . A D D _ I N _ O N L I N E ,   0 ,   ' ' ,   1 ,   ' >102;5=85' )   | | 
 
               d e c o d e ( t . D E L _ I N _ O N L I N E ,   0 ,   ' ' ,   1 ,   ' #40;5=85' )   | | 
 
               d e c o d e ( t . C H A N G E _ I N _ O N L I N E ,   0 ,   ' ' ,   1 ,   ' o n l i n e   87<5=5=85' )   a s   ##, 
 
               d e c o d e ( p . A D D _ I N _ O N L I N E ,   1 ,   ' >102;5=  ' )   | | 
 
               d e c o d e ( p . D E L _ I N _ O N L I N E ,   1 ,   ' #40;5=  ' )   | | 
 
               d e c o d e ( p . C H A N G E _ I N _ O N L I N E ,   1 ,   ' o n l i n e   87<5=5=85  ' )   | | 
 
               T O _ C H A R ( p . T E R M I N A L _ D A T E ,   ' d d . m m . y y y y   H H 2 4 : M I : S S ' )   a s    50;870F8O_ ##0, 
 
               p . T E R M I N A L _ I D   a s   =0_ "
 
     f r o m   s e c . c a r d s _ l i m i t s _ f o r _ s u p p o r t   t 
 
     F U L L   O U T E R   J O I N   s e c . S E R V I C E S   q 
 
         O N   t . E M I T E N T _ I D   =   q . E M I T E N T _ I D 
 
       a n d   t . S E R V I C E S _ I D   =   q . s e r v i c e s _ i d 
 
     F U L L   O U T E R   J O I N   S E C . T R A N S A C T I O N S _ C H A N G E _ P U R S E   p 
 
         O N   t . C A R D N U M   =   p . C A R D N U M 
 
       a n d   t . S E R V I C E S _ I D   =   p . P U R S E S _ I D 
 
   w h e r e   t . S E R V I C E S _ I D   < >   0 
 
       a n d   t . C A R D N U M   =   Oo r d e r   b y   t . S E R V I C E S _ I D ,   p . T E R M I N A L _ D A T E  +s e l e c t   t . C A R D N U M   a s   0@B0, 
 
               d e c o d e ( t . l i m i t _ t y p e , 
 
                             ' 0 ' , 
 
                             ' D8=. >3@0=8G5=8O' , 
 
                             ' 1 ' , 
 
                             ' ?>  :>;- 2C  B@7. 451' , 
 
                             ' 2 ' , 
 
                             ' ?>  ;8B@0<' , 
 
                             t . l i m i t _ t y p e )   a s   "8?_ ;8<8B0, 
 
               d e c o d e ( t . S E R V I C E S _ I D , 
 
                             q . s e r v i c e s _ i d , 
 
                             t . S E R V I C E S _ I D   | |   '   -   '   | |   q . s e r v i c e _ n a m e , 
 
                             0 , 
 
                             ' ' , 
 
                             t . S E R V I C E S _ I D )   a s   #A;C30, 
 
               ( s e l e c t   m . A C Q U I R E R _ S E R V I C E S _ I D   | |   '   -   '   | |   a . S E R V I C E _ N A M E 
 
                     f r o m   s e c . s e r v i c e s   a 
 
                   w h e r e   a . E M I T E N T _ I D   =   2 0 0 5 
 
                       a n d   m . A C Q U I R E R _ S E R V I C E S _ I D   =   a . S E R V I C E S _ I D )   a s   t e r m _ 2 0 0 5 , 
 
               d e c o d e ( t . A D D _ I N _ O N L I N E , 
 
                             0 , 
 
                             ' ' , 
 
                             1 , 
 
                             ' >102;5=85' , 
 
                             t . A D D _ I N _ O N L I N E )   | | 
 
               d e c o d e ( t . D E L _ I N _ O N L I N E , 
 
                             0 , 
 
                             ' ' , 
 
                             1 , 
 
                             ' #40;5=85' , 
 
                             t . D E L _ I N _ O N L I N E )   | | 
 
               d e c o d e ( t . C H A N G E _ I N _ O N L I N E , 
 
                             0 , 
 
                             ' ' , 
 
                             1 , 
 
                             ' o n l i n e   87<5=5=85' , 
 
                             t . C H A N G E _ I N _ O N L I N E )   a s   ##, 
 
               d e c o d e ( t . C O M M O N _ L I M I T , 
 
                             0 , 
 
                             ' =48284C0;L=K9' , 
 
                             1 , 
 
                             ' 1I89' , 
 
                             t . C O M M O N _ L I M I T )   a s   "8?_ ;8<8B0, 
 
               d e c o d e ( t . l i m i t _ t y p e , 
 
                             ' 2 ' , 
 
                             d e c o d e ( t . P U R S E _ L I M I T _ T Y P E , 
 
                                           0 , 
 
                                           ' !CB>G=K9' , 
 
                                           1 0 0 0 0 , 
 
                                           ' 5AOG=K9' , 
 
                                           t . P U R S E _ L I M I T _ T Y P E ) )   a s   8<8B, 
 
               t . P U R S E _ M A X _ L I M I T   *   1   a s   0:A_ ;8<, 
 
               d e c o d e ( t . a c t i v e ,   ' 1 ' ,   ' 0' ,   ' 0 ' ,   ' - - - ' ,   t . a c t i v e )   a s   :B82, 
 
               d e c o d e ( t . s c h e m e s _ i d , 
 
                             1 , 
 
                             ' -' , 
 
                             2 , 
 
                             ' -' , 
 
                             3 , 
 
                             ' !' , 
 
                             4 , 
 
                             ' !' , 
 
                             5 , 
 
                             ' &"' , 
 
                             6 , 
 
                             ' !' , 
 
                             7 , 
 
                             ' -$&' , 
 
                             8 , 
 
                             ' $&' , 
 
                             9 , 
 
                             ' -  ' , 
 
                             n u l l , 
 
                             n u l l , 
 
                             t . s c h e m e s _ i d   | |   '   -   CB>G=8BL  2  &! ' )   a s   !E5<0, 
 
               d e c o d e ( t . A C T I V E , 
 
                             ' 1 ' , 
 
                             d e c o d e ( t . d a i l y _ l i m i t   *   1 , 
 
                                           ' 0 ' , 
 
                                           ' ! ! !   '   | |   t . d a i l y _ l i m i t   *   1 , 
 
                                           t . d a i l y _ l i m i t   *   1 ) , 
 
                             t . d a i l y _ l i m i t   *   1 )   | | 
 
               d e c o d e ( T R U N C ( c p . L A S T _ T R A N S A C T I O N ) , 
 
                             T R U N C ( S Y S D A T E ) , 
 
                             d e c o d e ( n v l ( ( c . D A I L Y _ C U R R E N T ) ,   0 ) , 
 
                                           0 , 
 
                                           ' ' , 
 
                                           ' - '   | |   n v l ( ( c . D A I L Y _ C U R R E N T   *   1 ) ,   0 )   | |   ' = '   | | 
 
                                           ( ( t . d a i l y _ l i m i t   *   1 )   -   n v l ( ( c . D A I L Y _ C U R R E N T   *   1 ) ,   0 ) ) )   | | 
 
                             ( c a s e 
 
                                   w h e n ( ( t . d a i l y _ l i m i t   *   1 )   -   n v l ( ( c . D A I L Y _ C U R R E N T   *   1 ) ,   0 ) )   <   0   a n d 
 
                                             t . A C T I V E   =   1   t h e n 
 
                                     '     < - -   ! ! ! ' 
 
                               e n d ) )   a s   =52=>9, 
 
               d e c o d e ( t . A C T I V E , 
 
                             ' 1 ' , 
 
                             d e c o d e ( t . w e e k l y _ l i m i t   *   1 , 
 
                                           ' 0 ' , 
 
                                           ' ! ! !   '   | |   t . w e e k l y _ l i m i t   *   1 , 
 
                                           t . w e e k l y _ l i m i t   *   1 ) , 
 
                             t . w e e k l y _ l i m i t   *   1 )   | | 
 
               d e c o d e ( T O _ C H A R ( ( T O _ D A T E ( c p . L A S T _ T R A N S A C T I O N ) )   -   1 ,   ' W W . Y Y Y Y ' ) , 
 
                             T O _ C H A R ( S Y S D A T E   -   1 ,   ' W W . Y Y Y Y ' ) , 
 
                             d e c o d e ( n v l ( ( c . w e e k l y _ C U R R E N T ) ,   0 ) , 
 
                                           0 , 
 
                                           ' ' , 
 
                                           ' - '   | |   n v l ( ( c . W E E K L Y _ C U R R E N T   *   1 ) ,   0 )   | |   ' = '   | | 
 
                                           ( ( t . w e e k l y _ l i m i t   *   1 )   -   n v l ( ( c . W E E K L Y _ C U R R E N T   *   1 ) ,   0 ) ) )   | | 
 
                             ( c a s e 
 
                                   w h e n ( ( t . w e e k l y _ l i m i t   *   1 )   -   n v l ( ( c . W E E K L Y _ C U R R E N T   *   1 ) ,   0 ) )   < =   0   a n d 
 
                                             t . A C T I V E   =   1   t h e n 
 
                                     '     < - -   ! ! ! ' 
 
                               e n d ) )   a s   545;L=K9, 
 
               d e c o d e ( t . A C T I V E , 
 
                             ' 1 ' , 
 
                             d e c o d e ( t . m o n t h l y _ l i m i t   *   1 , 
 
                                           ' 0 ' , 
 
                                           ' ! ! !   '   | |   t . m o n t h l y _ l i m i t   *   1 , 
 
                                           t . m o n t h l y _ l i m i t   *   1 ) , 
 
                             t . m o n t h l y _ l i m i t   *   1 )   | | 
 
               d e c o d e ( T O _ C H A R ( c p . L A S T _ T R A N S A C T I O N ,   ' M M . Y Y Y Y ' ) , 
 
                             T O _ C H A R ( S Y S D A T E ,   ' M M . Y Y Y Y ' ) , 
 
                             d e c o d e ( n v l ( ( c . m o n t h l y _ C U R R E N T ) ,   0 ) , 
 
                                           0 , 
 
                                           ' ' , 
 
                                           ' - '   | |   n v l ( ( c . M O N T H L Y _ C U R R E N T   *   1 ) ,   0 )   | |   ' = '   | | 
 
                                           ( ( t . m o n t h l y _ l i m i t   *   1 )   -   n v l ( ( c . M O N T H L Y _ C U R R E N T   *   1 ) ,   0 ) ) )   | | 
 
                             ( c a s e 
 
                                   w h e n ( ( t . m o n t h l y _ l i m i t   *   1 )   -   n v l ( ( c . M O N T H L Y _ C U R R E N T   *   1 ) ,   0 ) )   < =   0   a n d 
 
                                             t . A C T I V E   =   1   t h e n 
 
                                     '     < - -   ! ! ! ' 
 
                               e n d ) )   a s   5AOG=K9, 
 
               t . t s   a s   0B0_ 70?8A8, 
 
               d e c o d e ( t . S C H E M E S _ I D ,   9 ,   ( c . P U R S E _ B A L A N C E   +   c f . P U R S E _ B A L A N C E ) )   a s   =;09=_ >AB0B>:_ -, 
 
               d e c o d e ( t . S C H E M E S _ I D ,   9 ,   c . P U R S E _ B A L A N C E )   5;LB0_ -, 
 
               d e c o d e ( t . S C H E M E S _ I D ,   9 ,   c f . P U R S E _ B A L A N C E )   a s   AB0B>:_ -_ 87_ &, 
 
               t . f i l i a l _ i d   a s   $8;80;, 
 
               t . o v e r d r a f t   *   1   a s   25@4@0DB
 
     f r o m   s e c . c a r d s _ l i m i t s _ f o r _ s u p p o r t   t 
 
     L E F T   O U T E R   J O I N   s e c . S E R V I C E S   q 
 
         O N   t . E M I T E N T _ I D   =   q . E M I T E N T _ I D 
 
       a n d   t . S E R V I C E S _ I D   =   q . S E R V I C E S _ I D 
 
     L E F T   O U T E R   J O I N   S E C . S E R V I C E S _ M A P   m 
 
         O N   t . E M I T E N T _ I D   =   m . E M I T E N T _ I D 
 
       a n d   t . S E R V I C E S _ I D   =   m . E M I T E N T _ S E R V I C E S _ I D 
 
       a n d   m . A C Q U I R E R _ I D   =   2 0 0 5 
 
     L E F T   O U T E R   J O I N   s e c . C A R D S _ C U R R E N T   c 
 
         O N   t . E M I T E N T _ I D   =   c . E M I T E N T _ I D 
 
       a n d   t . C A R D N U M   =   c . C A R D N U M 
 
       a n d   t . L I M I T _ T Y P E   =   c . L I M I T _ T Y P E 
 
       a n d   t . S E R V I C E S _ I D   =   c . S E R V I C E S _ I D 
 
     L E F T   O U T E R   J O I N   s e c . c a r d s _ p a r a m s _ f o r _ s u p p o r t   c p 
 
         O N   t . C A R D N U M   =   c p . C A R D N U M 
 
       a n d   t . E M I T E N T _ I D   =   c p . E M I T E N T _ I D 
 
     L E F T   O U T E R   J O I N   s e c . c a r d s _ o f f _ i n f o   c f 
 
         O N   t . C A R D N U M   =   c f . C A R D N U M 
 
       a n d   c f . S E R V I C E S _ I D   =   t . S E R V I C E S _ I D 
 
   w h e r e   t . C A R D N U M     = Io r d e r   b y   t . l i m i t _ t y p e ,   t . S E R V I C E S _ I D  s e l e c t   d e c o d e ( t . l i m i t _ t y p e , 
 
                             ' 0 ' , 
 
                             ' D8=. >3@0=8G5=8O' , 
 
                             ' 1 ' , 
 
                             ' ?>  :>;- 2C  B@7. 451' , 
 
                             ' 2 ' , 
 
                             ' >  ;8B@0<' , 
 
                             t . l i m i t _ t y p e )   a s   "8?_ ;8<8B0, 
 
               d e c o d e ( t . S E R V I C E S _ I D , 
 
                             q . s e r v i c e s _ i d , 
 
                             t . S E R V I C E S _ I D   | |   '   -   '   | |   q . s e r v i c e _ n a m e , 
 
                             ' 0 ' , 
 
                             ' ' , 
 
                             t . S E R V I C E S _ I D )   a s   #A;C30, 
 
               ( s e l e c t   m . A C Q U I R E R _ S E R V I C E S _ I D   | |   '   -   '   | |   a . S E R V I C E _ N A M E 
 
                     f r o m   s e c . s e r v i c e s   a 
 
                   w h e r e   a . E M I T E N T _ I D   =   2 0 0 5 
 
                       a n d   m . A C Q U I R E R _ S E R V I C E S _ I D   =   a . S E R V I C E S _ I D )   a s   t e r m _ 2 0 0 5 , 
 
               d e c o d e ( t . a c t i v e ,   ' 1 ' ,   ' 0' ,   ' 0 ' ,   ' - - - ' ,   t . a c t i v e )   a s   :B82, 
 
               d e c o d e ( t . A C T I V E , 
 
                             ' 1 ' , 
 
                             d e c o d e ( t . d a i l y _ l i m i t   *   1 , 
 
                                           ' 0 ' , 
 
                                           ' ! ! !   '   | |   t . d a i l y _ l i m i t   *   1 , 
 
                                           t . d a i l y _ l i m i t   *   1 ) , 
 
                             t . d a i l y _ l i m i t   *   1 )   | | 
 
               d e c o d e ( T R U N C ( c u p . L A S T _ T R A N S A C T I O N ) , 
 
                             T R U N C ( S Y S D A T E ) , 
 
                             d e c o d e ( n v l ( ( c . D A I L Y _ C U R R E N T ) ,   0 ) , 
 
                                           0 , 
 
                                           ' ' , 
 
                                           ' - '   | |   n v l ( ( c . D A I L Y _ C U R R E N T   *   1 ) ,   0 )   | |   ' = '   | | 
 
                                           ( ( t . d a i l y _ l i m i t   *   1 )   -   n v l ( ( c . D A I L Y _ C U R R E N T   *   1 ) ,   0 ) ) )   | | 
 
                             ( c a s e 
 
                                   w h e n ( ( t . d a i l y _ l i m i t   *   1 )   -   n v l ( ( c . D A I L Y _ C U R R E N T   *   1 ) ,   0 ) )   <   0   a n d 
 
                                             t . A C T I V E   =   1   t h e n 
 
                                     '     < - -   ! ! ! ' 
 
                               e n d ) )   a s   =52=>9, 
 
               d e c o d e ( t . A C T I V E , 
 
                             ' 1 ' , 
 
                             d e c o d e ( t . w e e k l y _ l i m i t   *   1 , 
 
                                           ' 0 ' , 
 
                                           ' ! ! !   '   | |   t . w e e k l y _ l i m i t   *   1 , 
 
                                           t . w e e k l y _ l i m i t   *   1 ) , 
 
                             t . w e e k l y _ l i m i t   *   1 )   | | 
 
               d e c o d e ( T O _ C H A R ( c u p . L A S T _ T R A N S A C T I O N   -   1 ,   ' W W . Y Y Y Y ' ) , 
 
                             T O _ C H A R ( S Y S D A T E   -   1 ,   ' W W . Y Y Y Y ' ) , 
 
                             d e c o d e ( n v l ( ( c . w e e k l y _ C U R R E N T ) ,   0 ) , 
 
                                           0 , 
 
                                           ' ' , 
 
                                           ' - '   | |   n v l ( ( c . W E E K L Y _ C U R R E N T   *   1 ) ,   0 )   | |   ' = '   | | 
 
                                           ( ( t . w e e k l y _ l i m i t   *   1 )   -   n v l ( ( c . W E E K L Y _ C U R R E N T   *   1 ) ,   0 ) ) )   | | 
 
                             ( c a s e 
 
                                   w h e n ( ( t . w e e k l y _ l i m i t   *   1 )   -   n v l ( ( c . W E E K L Y _ C U R R E N T   *   1 ) ,   0 ) )   < =   0   a n d 
 
                                             t . A C T I V E   =   1   t h e n 
 
                                     '     < - -   ! ! ! ' 
 
                               e n d ) )   a s   545;L=K9, 
 
               d e c o d e ( t . A C T I V E , 
 
                             ' 1 ' , 
 
                             d e c o d e ( t . m o n t h l y _ l i m i t   *   1 , 
 
                                           ' 0 ' , 
 
                                           ' ! ! !   '   | |   t . m o n t h l y _ l i m i t   *   1 , 
 
                                           t . m o n t h l y _ l i m i t   *   1 ) , 
 
                             t . m o n t h l y _ l i m i t   *   1 )   | | 
 
               d e c o d e ( T O _ C H A R ( c u p . L A S T _ T R A N S A C T I O N ,   ' M M . Y Y Y Y ' ) , 
 
                             T O _ C H A R ( S Y S D A T E ,   ' M M . Y Y Y Y ' ) , 
 
                             d e c o d e ( n v l ( ( c . m o n t h l y _ C U R R E N T ) ,   0 ) , 
 
                                           0 , 
 
                                           ' ' , 
 
                                           ' - '   | |   n v l ( ( c . M O N T H L Y _ C U R R E N T   *   1 ) ,   0 )   | |   ' = '   | | 
 
                                           ( ( t . m o n t h l y _ l i m i t   *   1 )   -   n v l ( ( c . M O N T H L Y _ C U R R E N T   *   1 ) ,   0 ) ) )   | | 
 
                             ( c a s e 
 
                                   w h e n ( ( t . m o n t h l y _ l i m i t   *   1 )   -   n v l ( ( c . M O N T H L Y _ C U R R E N T   *   1 ) ,   0 ) )   < =   0   a n d 
 
                                             t . A C T I V E   =   1   t h e n 
 
                                     '     < - -   ! ! ! ' 
 
                               e n d ) )   a s   5AOG=K9, 
 
               t . t s   a s   0B0_ 70?8A8, 
 
               t . o v e r d r a f t   *   1   a s   25@4@0DB, 
 
               t . e m i t e n t _ i d   a s   -<8B5=B, 
 
               t . f i l i a l _ i d   a s   F , 
 
               d e c o d e ( t . c u s t o m e r s _ i d , 
 
                             ( s e l e c t   t . c u s t o m e r s _ i d 
 
                                   f r o m   S E C . c a r d s _ f o r _ s u p p o r t   t 
 
                                 w h e r e   t . c a r d n u m   =   s) ,   ' :0@B0  MB>9  :><?0=88- '   | |   t . c u s t o m e r s _ i d ,   ( s e l e c t   d i s t i n c t ( t . i d _ c o n t )   f r o m   s e c . c o n t _ m e r g e   t     w h e r e   t . i d _ c o n t   =   ( s e l e c t   t . c u s t o m e r s _ i d   f r o m   S E C . c a r d s _ f o r _ s u p p o r t   t     w h e r e   t . c a r d n u m   =   )   o r   t . i d _ c o n t 2   =   ( s e l e c t   t . c u s t o m e r s _ i d     f r o m   S E C . c a r d s _ f o r _ s u p p o r t   t     w h e r e   t . c a r d n u m   =    A) ) ,   ' <0BL- '   | |   t . C U S T O M E R S _ I D ,   t . C U S T O M E R S _ I D )   a s   I D _ :;85=B0    f r o m   s e c . C U S T O M E R S _ L I M I T S   t     L E F T   O U T E R   J O I N   s e c . S E R V I C E S   q   O N   t . e m i t e n t _ i d   =   q . E M I T E N T _ I D   a n d   t . S E R V I C E S _ I D   =   q . S E R V I C E S _ I D   L E F T   O U T E R   J O I N   S E C . S E R V I C E S _ M A P   m     O N   t . E M I T E N T _ I D   =   m . E M I T E N T _ I D   a n d   t . S E R V I C E S _ I D   =   m . E M I T E N T _ S E R V I C E S _ I D   a n d   m . A C Q U I R E R _ I D   =   2 0 0 5   L E F T   O U T E R   J O I N   s e c . c u s t o m e r s _ c u r r e n t   c   O N   t . E M I T E N T _ I D   =   c . E M I T E N T _ I D   a n d   t . L I M I T _ T Y P E   =   c . L I M I T _ T Y P E   a n d   t . S E R V I C E S _ I D   =   c . S E R V I C E S _ I D   a n d   t . C U S T O M E R S _ I D   =   c . C U S T O M E R S _ I D   L E F T   O U T E R   J O I N   s e c . c u s t o m e r s _ p a r a m s   c u p   O N   t . C U S T O M E R S _ I D   =   c u p . C U S T O M E R S _ I D   w h e r e   t . c u s t o m e r s _ i d   I N     ( s e l e c t   t . i d _ c o n t 2   f r o m   s e c . c o n t _ m e r g e   t     w h e r e   t . i d _ c o n t   =     ( s e l e c t   d i s t i n c t   ( t . i d _ c o n t )   f r o m   s e c . c o n t _ m e r g e   t     w h e r e   t . i d _ c o n t   =   ( s e l e c t   t . c u s t o m e r s _ i d     f r o m   S E C . c a r d s _ f o r _ s u p p o r t   t     w h e r e   t . c a r d n u m   =   )   o r   t . i d _ c o n t 2   =   ( s e l e c t   t . c u s t o m e r s _ i d   f r o m   S E C . c a r d s _ f o r _ s u p p o r t   t   w h e r e   t . c a r d n u m   =    M) ) )     O R   t . c u s t o m e r s _ i d   I N   ( s e l e c t   d i s t i n c t   ( t . i d _ c o n t )   f r o m   s e c . c o n t _ m e r g e   t     w h e r e   t . i d _ c o n t   =   ( s e l e c t   t . c u s t o m e r s _ i d   f r o m   S E C . c a r d s _ f o r _ s u p p o r t   t   w h e r e   t . c a r d n u m   =    ) )   O R   t . c u s t o m e r s _ i d   I N ( s e l e c t   t . c u s t o m e r s _ i d   f r o m   S E C . c a r d s _ f o r _ s u p p o r t   t   w h e r e   t . c a r d n u m   =    Y)   o r d e r   b y   d e c o d e ( t . c u s t o m e r s _ i d ,   ( s e l e c t   d i s t i n c t ( t . i d _ c o n t )   f r o m   s e c . c o n t _ m e r g e   t   w h e r e   t . i d _ c o n t   =   ( s e l e c t   t . c u s t o m e r s _ i d     f r o m   S E C . c a r d s _ f o r _ s u p p o r t   t   w h e r e   t . c a r d n u m   =  ) o r   t . i d _ c o n t 2   =     ( s e l e c t   t . c u s t o m e r s _ i d   f r o m   S E C . c a r d s _ f o r _ s u p p o r t   t     w h e r e   t . c a r d n u m   =    ) ) ,     ' 0 0 0 1 1 1 1 <0BL  -   '   | |   t . c u s t o m e r s _ i d ,   ( s e l e c t   t . c u s t o m e r s _ i d   f r o m   S E C . c a r d s _ f o r _ s u p p o r t   t         w h e r e   t . c a r d n u m   = 	 ) , ' 0 0 0 1 1 1 <0BL  -   '   | |   t . c u s t o m e r s _ i d , t . c u s t o m e r s _ i d ) , t . l i m i t _ t y p e , t . S E R V I C E S _ I D  \/s e l e c t ( s e l e c t   T O _ C H A R ( S Y S D A T E ,   ' D D - M M - Y Y Y Y   H H 2 4 : M I : S S ' )   f r o m   d u a l )   a s   0B0_ 2K1>@:8_ 8=D>, 
 
               c d . c a r d n u m   a s   ><5@_ :0@BK, 
 
               d e c o d e ( c d . o n l i n e _ c a r d t y p e , 
 
                             1 , 
 
                             '   ( ">;L:>  >DD;09=  /   '!  ;N1>9) ' , 
 
                             2 , 
 
                             ' B   ( DD;09=- >=;09=  /   '!  ;N1>9) ' , 
 
                             3 , 
 
                             ' C   ( ">;L:>  >=;09=  /   '!  ;N1>9) ' , 
 
                             4 , 
 
                             ' D   ( ">;L:>  >=;09=  /   '!  >=;09=) ' , 
 
                             5 , 
 
                             ' E   >40@>G=0O  :0@B0' , 
 
                             6 , 
 
                             ' F   ( DD;09=- >=;09=  /   '!  ;N1>9) ' , 
 
                             7 , 
 
                             ' G     038AB@0;L' , 
 
                             9 , 
 
                             ' K   ( ">;L:>  >=;09=  /   '!  >=;09=)   !5BL  P e t r o l   P l u s ' , 
 
                             1 0 , 
 
                             ' H   ( DD;09=- =;09=)   #=825@A0;L=0O  :0@B0  V i s a   ( >1O7  02B>@87) ' , 
 
                             1 1 , 
 
                             ' I   ( DD;09=- =;09=)   #=825@A0;L=0O  :0@B0  V i s a   ( =5>1O7  02B>@87) ' , 
 
                             1 2 , 
 
                             ' J   ( ">;L:>  >=;09=  /   '!  >=;09=)   #=825@A0;L=0O  :0@B0  V i s a ' , 
 
                             c d . o n l i n e _ c a r d t y p e )   a s   =;09=_ B8?_ :0@BK, 
 
               d e c o d e ( c d . s t a t u s _ i d , 
 
                             0 , 
 
                             ' 5  D>@<0B8@>20=0' , 
 
                             1 , 
 
                             '   @01>B5' , 
 
                             2 , 
 
                             ' '!' , 
 
                             3 , 
 
                             ' #B5@O=0' , 
 
                             4 , 
 
                             ' 5  2K40=0' , 
 
                             5 , 
 
                             ' 01;>:8@>20=0' , 
 
                             6 , 
 
                             ' AB0=>2;5=0' , 
 
                             7 , 
 
                             ' $8@<0  2  '!' , 
 
                             1 0 0 , 
 
                             ' >72@0I5=0' , 
 
                             1 0 1 , 
 
                             ' #B8;878@>20=0' , 
 
                             1 0 2 , 
 
                             ' #:@045=0' , 
 
                             c d . s t a t u s _ i d   | |   '   CB>G=8BL,   GB>  MB>  B0:>5! ' )   | | 
 
               d e c o d e ( c d . C O N D I T I O N A L _ B L , 
 
                             n u l l , 
 
                             n u l l , 
 
                             ' 0 ' , 
 
                             n u l l , 
 
                             ' 1 ' , 
 
                             '   -   #'!' , 
 
                             c d . C O N D I T I O N A L _ B L   | |   '   CB>G=8BL,   GB>  MB>  B0:>5! ' )   a s   !>AB>O=85_ :0@BK, 
 
               d e c o d e ( c d . d a y s , 
 
                             ' 1 1 1 1 1 1 1 ' , 
 
                             ' A5  4=8  =545;8  @07@5H5=K  ' , 
 
                             ' 0 0 0 0 0 0 0 ' , 
 
                             ' !     )+!   ' , 
 
                             ( c a s e 
 
                                 w h e n   S U B S T R ( c d . d a y s ,   1 ,   1 )   =   ' 1 '   t h e n 
 
                                   ' =  ' 
 
                             e n d )   | |   ( c a s e 
 
                                 w h e n   S U B S T R ( c d . d a y s ,   2 ,   1 )   =   ' 1 '   t h e n 
 
                                   ' B  ' 
 
                             e n d )   | |   ( c a s e 
 
                                 w h e n   S U B S T R ( c d . d a y s ,   3 ,   1 )   =   ' 1 '   t h e n 
 
                                   ' !@  ' 
 
                             e n d )   | |   ( c a s e 
 
                                 w h e n   S U B S T R ( c d . d a y s ,   4 ,   1 )   =   ' 1 '   t h e n 
 
                                   ' 'B  ' 
 
                             e n d )   | |   ( c a s e 
 
                                 w h e n   S U B S T R ( c d . d a y s ,   5 ,   1 )   =   ' 1 '   t h e n 
 
                                   ' B  ' 
 
                             e n d )   | |   ( c a s e 
 
                                 w h e n   S U B S T R ( c d . d a y s ,   6 ,   1 )   =   ' 1 '   t h e n 
 
                                   ' !1  ' 
 
                             e n d )   | |   ( c a s e 
 
                                 w h e n   S U B S T R ( c d . d a y s ,   7 ,   1 )   =   ' 1 '   t h e n 
 
                                   ' A  ' 
 
                             e n d ) )   | | 
 
               d e c o d e ( c d . T I M E _ F R O M , 
 
                             n u l l , 
 
                             n u l l , 
 
                             ' c   '   | |   t o _ c h a r ( c d . T I M E _ F R O M ,   ' H H 2 4 : M I : S S ' )   | |   '   ' )   | | 
 
               d e c o d e ( c d . T I M E _ T O , 
 
                             n u l l , 
 
                             n u l l , 
 
                             ' ?>  '   | |   t o _ c h a r ( c d . T I M E _ T O ,   ' H H 2 4 : M I : S S ' ) )   a s   @5<5==K5_ >3@0=8G5=8O, 
 
               c u . c u s t o m e r s _ i d   a s   I D _ :;85=B0_ =0_ !, 
 
               c u . d a t e _ o n l i n e   a s   0B0_ 2K2>40_ 2_ >=;09=, 
 
               c p . l a s t _ t r a n s a c t i o n   a s   _ :0@BK, 
 
               c u p . l a s t _ t r a n s a c t i o n   a s   _ :;85=B0, 
 
               ( s e l e c t   d o . s e r v i c e _ b a l a n c e 
 
                     f r o m   s e c . c u s t o m e r s _ o f f _ i n f o   d o 
 
                                         w h e r e   d o . s e r v i c e s _ i d   =   1 
 
                       
 
                                             a n d   d o . c u s t o m e r s _ i d   =   c d . c u s t o m e r s _ i d )   a s   DD_ 10;0=A_ @C1;59, 
 
               r o u n d ( n v l ( c u p . b a l a n c e ,   0 ) ,   2 )   a s   5;LB0_ 10;0=A0_ =0_ !, 
 
               ( ( s e l e c t   d o . s e r v i c e _ b a l a n c e 
 
                       f r o m   s e c . c u s t o m e r s _ o f f _ i n f o   d o 
 
                                         w h e r e   d o . s e r v i c e s _ i d   =   1 
 
                     
 
                                             a n d   d o . c u s t o m e r s _ i d   =   c d . c u s t o m e r s _ i d )   + n v l ( c u p . b a l a n c e ,   0 ) )   | | 
 
                                 d e c o d e ( c u . o v e r d r a f t , 
 
                                               0 , 
 
                                               N U L L , 
 
                                               '   - - -   '   | |   ' >ABC?=. AC<<0. o n l i n e . A. CG5B. >25@  '   | | 
 
                                               ( ( r o u n d ( n v l ( c u . o v e r d r a f t ,   0 ) ,   2 ) )   + 
 
                                               ( ( s e l e c t   d o . s e r v i c e _ b a l a n c e 
 
                   
 
                                                         f r o m   s e c . c u s t o m e r s _ o f f _ i n f o   d o 
 
                                         w h e r e   d o . s e r v i c e s _ i d   =   1 
 
     
 
                                             a n d   d o . c u s t o m e r s _ i d   =   c d . c u s t o m e r s _ i d )   + c u p . b a l a n c e ) ) )   a s   O N L I N E _ 10;0=A, 
 
               0   -   ( r o u n d ( n v l ( c u . o v e r d r a f t ,   0 ) ,   2 ) )   a s   O n l i n e _ >25@4@0DB, 
 
               r o u n d ( n v l ( c u p . t i m e _ c r e d i t _ b a l a n c e ,   0 ) ,   2 )   a s   @5<5==K9_ :@548B, 
 
               ( s e l e c t   d i s t i n c t ( t . i d _ c o n t ) 
 
                     f r o m   s e c . c o n t _ m e r g e   t 
 
                   w h e r e   t . i d _ c o n t   =   c d . c u s t o m e r s _ i d 
 
                         o r   t . i d _ c o n t 2   =   c d . c u s t o m e r s _ i d )   a s   I D _ <0B5@8, 
 
               ( n v l ( ( s e l e c t   S U M ( p . s e r v i c e _ b a l a n c e ) 
 
                             f r o m   s e c . C U S T O M E R S _ O F F _ I N F O   p 
 
                           w h e r e   p . c u s t o m e r s _ i d   I N 
 
                                       ( s e l e c t   t . i d _ c o n t 2 
 
                                             f r o m   s e c . c o n t _ m e r g e   t 
 
                                           w h e r e   t . i d _ c o n t   = 
 
                                                       ( s e l e c t   d i s t i n c t ( t . i d _ c o n t ) 
 
                                                             f r o m   s e c . c o n t _ m e r g e   t 
 
                                                           w h e r e   t . i d _ c o n t   =   c d . c u s t o m e r s _ i d 
 
                                                                 o r   t . i d _ c o n t 2   =   c d . c u s t o m e r s _ i d ) ) ) , 
 
                         0 )   + ( s e l e c t   p . s e r v i c e _ b a l a n c e 
 
                                         f r o m   s e c . C U S T O M E R S _ O F F _ I N F O   p 
 
                                         w h e r e   p . c u s t o m e r s _ i d   = 
 
                                                     ( s e l e c t   d i s t i n c t ( t . i d _ c o n t ) 
 
                                                           f r o m   s e c . c o n t _ m e r g e   t 
 
                                                         w h e r e   t . i d _ c o n t   =   c d . c u s t o m e r s _ i d 
 
                                                               o r   t . i d _ c o n t 2   =   c d . c u s t o m e r s _ i d ) ) )   a s   !;8BK9_ >DD_ 10;0=A, 
 
               ( n v l ( ( s e l e c t   S U M ( p . b a l a n c e ) 
 
                             f r o m   s e c . C U S T O M E R S _ P A R A M S   p 
 
                           w h e r e   p . c u s t o m e r s _ i d   I N 
 
                                       ( s e l e c t   t . i d _ c o n t 2 
 
                                             f r o m   s e c . c o n t _ m e r g e   t 
 
                                           w h e r e   t . i d _ c o n t   = 
 
                                                       ( s e l e c t   d i s t i n c t ( t . i d _ c o n t ) 
 
                                                             f r o m   s e c . c o n t _ m e r g e   t 
 
                                                           w h e r e   t . i d _ c o n t   =   c d . c u s t o m e r s _ i d 
 
                                                                 o r   t . i d _ c o n t 2   =   c d . c u s t o m e r s _ i d ) ) ) , 
 
                         0 )   + n v l ( ( s e l e c t   r . b a l a n c e 
 
                                                 f r o m   s e c . C U S T O M E R S _ P A R A M S   r 
 
                                               w h e r e   r . c u s t o m e r s _ i d   = 
 
                                                           ( s e l e c t   d i s t i n c t ( t . i d _ c o n t ) 
 
                                                                 f r o m   s e c . c o n t _ m e r g e   t 
 
                                                               w h e r e   t . i d _ c o n t   =   c d . c u s t o m e r s _ i d 
 
                                                                     o r   t . i d _ c o n t 2   =   c d . c u s t o m e r s _ i d ) ) , 
 
                                             0 ) )   a s   5;LB0_ 10;_ >1I0O, 
 
               ( ( n v l ( ( s e l e c t   S U M ( p . s e r v i c e _ b a l a n c e ) 
 
                               f r o m   s e c . C U S T O M E R S _ O F F _ I N F O   p 
 
                             w h e r e   p . c u s t o m e r s _ i d   I N 
 
                                         ( s e l e c t   t . i d _ c o n t 2 
 
                                               f r o m   s e c . c o n t _ m e r g e   t 
 
                                             w h e r e   t . i d _ c o n t   = 
 
                                                         ( s e l e c t   d i s t i n c t ( t . i d _ c o n t ) 
 
                                                               f r o m   s e c . c o n t _ m e r g e   t 
 
                                                             w h e r e   t . i d _ c o n t   =   c d . c u s t o m e r s _ i d 
 
                                                                   o r   t . i d _ c o n t 2   =   c d . c u s t o m e r s _ i d ) ) ) , 
 
                           0 )   + 
 
               ( s e l e c t   p . s e r v i c e _ b a l a n c e 
 
                         f r o m   s e c . C U S T O M E R S _ O F F _ I N F O   p 
 
                       w h e r e   p . c u s t o m e r s _ i d   = 
 
                                   ( s e l e c t   d i s t i n c t ( t . i d _ c o n t ) 
 
                                         f r o m   s e c . c o n t _ m e r g e   t 
 
                                       w h e r e   t . i d _ c o n t   =   c d . c u s t o m e r s _ i d 
 
                                             o r   t . i d _ c o n t 2   =   c d . c u s t o m e r s _ i d ) ) )   + 
 
               ( n v l ( ( s e l e c t   S U M ( p . b a l a n c e ) 
 
                               f r o m   s e c . C U S T O M E R S _ P A R A M S   p 
 
                             w h e r e   p . c u s t o m e r s _ i d   I N 
 
                                         ( s e l e c t   t . i d _ c o n t 2 
 
                                               f r o m   s e c . c o n t _ m e r g e   t 
 
                                             w h e r e   t . i d _ c o n t   = 
 
                                                         ( s e l e c t   d i s t i n c t ( t . i d _ c o n t ) 
 
                                                               f r o m   s e c . c o n t _ m e r g e   t 
 
                                                             w h e r e   t . i d _ c o n t   =   c d . c u s t o m e r s _ i d 
 
                                                                   o r   t . i d _ c o n t 2   =   c d . c u s t o m e r s _ i d ) ) ) , 
 
                           0 )   + n v l ( ( s e l e c t   r . b a l a n c e 
 
                                                     f r o m   s e c . C U S T O M E R S _ P A R A M S   r 
 
                                                   w h e r e   r . c u s t o m e r s _ i d   = 
 
                                                               ( s e l e c t   d i s t i n c t ( t . i d _ c o n t ) 
 
                                                                     f r o m   s e c . c o n t _ m e r g e   t 
 
                                                                   w h e r e   t . i d _ c o n t   =   c d . c u s t o m e r s _ i d 
 
                                                                         o r   t . i d _ c o n t 2   =   c d . c u s t o m e r s _ i d ) ) , 
 
                                                 0 ) )   | | 
 
               d e c o d e ( ( s e l e c t   d . O V E R D R A F T 
 
                                   f r o m   s e c . c u s t o m e r s _ f o r _ s u p p o r t   d 
 
                                 w h e r e   d . C U S T O M E R S _ I D   = 
 
                                             ( s e l e c t   d i s t i n c t ( t . i d _ c o n t ) 
 
                                                   f r o m   s e c . c o n t _ m e r g e   t 
 
                                                 w h e r e   t . i d _ c o n t   =   c d . c u s t o m e r s _ i d 
 
                                                       o r   t . i d _ c o n t 2   =   c d . c u s t o m e r s _ i d ) ) , 
 
                               0 , 
 
                               N U L L , 
 
                               N U L L , 
 
                               N U L L , 
 
                               '   - - -   >ABC?=. >1I. AC<<0. o n l i n e . A. CG5B. >25@. <0B  '   | | 
 
                               ( ( s e l e c t ( d . O V E R D R A F T ) 
 
                                       f r o m   s e c . c u s t o m e r s _ f o r _ s u p p o r t   d 
 
                                     w h e r e   d . C U S T O M E R S _ I D   = 
 
                                                 ( s e l e c t   d i s t i n c t ( t . i d _ c o n t ) 
 
                                                       f r o m   s e c . c o n t _ m e r g e   t 
 
                                                     w h e r e   t . i d _ c o n t   =   c d . c u s t o m e r s _ i d 
 
                                                           o r   t . i d _ c o n t 2   =   c d . c u s t o m e r s _ i d ) )   + 
 
                               ( ( n v l ( ( s e l e c t   S U M ( p . s e r v i c e _ b a l a n c e ) 
 
                                                 f r o m   s e c . C U S T O M E R S _ O F F _ I N F O   p 
 
                                               w h e r e   p . c u s t o m e r s _ i d   I N 
 
                                                           ( s e l e c t   t . i d _ c o n t 2 
 
                                                                 f r o m   s e c . c o n t _ m e r g e   t 
 
                                                               w h e r e   t . i d _ c o n t   = 
 
                                                                           ( s e l e c t   d i s t i n c t ( t . i d _ c o n t ) 
 
                                                                                 f r o m   s e c . c o n t _ m e r g e   t 
 
                                                                               w h e r e   t . i d _ c o n t   =   c d . c u s t o m e r s _ i d 
 
                                                                                     o r   t . i d _ c o n t 2   =   c d . c u s t o m e r s _ i d ) ) ) , 
 
                                             0 )   + 
 
                               ( s e l e c t   p . s e r v i c e _ b a l a n c e 
 
                                           f r o m   s e c . C U S T O M E R S _ O F F _ I N F O   p 
 
                                         w h e r e   p . c u s t o m e r s _ i d   = 
 
                                                     ( s e l e c t   d i s t i n c t ( t . i d _ c o n t ) 
 
                                                           f r o m   s e c . c o n t _ m e r g e   t 
 
                                                         w h e r e   t . i d _ c o n t   =   c d . c u s t o m e r s _ i d 
 
                                                               o r   t . i d _ c o n t 2   =   c d . c u s t o m e r s _ i d ) ) )   + 
 
                               ( n v l ( ( s e l e c t   S U M ( p . b a l a n c e ) 
 
                                                 f r o m   s e c . C U S T O M E R S _ P A R A M S   p 
 
                                               w h e r e   p . c u s t o m e r s _ i d   I N 
 
                                                           ( s e l e c t   t . i d _ c o n t 2 
 
                                                                 f r o m   s e c . c o n t _ m e r g e   t 
 
                                                               w h e r e   t . i d _ c o n t   = 
 
                                                                           ( s e l e c t   d i s t i n c t ( t . i d _ c o n t ) 
 
                                                                                 f r o m   s e c . c o n t _ m e r g e   t 
 
                                                                               w h e r e   t . i d _ c o n t   =   c d . c u s t o m e r s _ i d 
 
                                                                                     o r   t . i d _ c o n t 2   =   c d . c u s t o m e r s _ i d ) ) ) , 
 
                                             0 )   + n v l ( ( s e l e c t   r . b a l a n c e 
 
                                                                         f r o m   s e c . C U S T O M E R S _ P A R A M S   r 
 
                                                                       w h e r e   r . c u s t o m e r s _ i d   = 
 
                                                                                   ( s e l e c t   d i s t i n c t ( t . i d _ c o n t ) 
 
                                                                                         f r o m   s e c . c o n t _ m e r g e   t 
 
                                                                                       w h e r e   t . i d _ c o n t   =   c d . c u s t o m e r s _ i d 
 
                                                                                             o r   t . i d _ c o n t 2   =   c d . c u s t o m e r s _ i d ) ) , 
 
                                                                     0 ) ) ) ) ) )   a s   O N L I N E _ 10;0=A_ >1I89, 
 
               ( s e l e c t   0   -   ( d . O V E R D R A F T ) 
 
                     f r o m   s e c . c u s t o m e r s _ f o r _ s u p p o r t   d 
 
                   w h e r e   d . C U S T O M E R S _ I D   = 
 
                               ( s e l e c t   d i s t i n c t ( t . i d _ c o n t ) 
 
                                     f r o m   s e c . c o n t _ m e r g e   t 
 
                                   w h e r e   t . i d _ c o n t   =   c d . c u s t o m e r s _ i d 
 
                                         o r   t . i d _ c o n t 2   =   c d . c u s t o m e r s _ i d ) )   a s   25@4@0DB_ <0B5@8, 
 
                           ( s e l e c t   l i s t a g g ( t . i d _ c o n t 2 ,   ' ;   ' )     w i t h i n   g r o u p ( o r d e r   b y   t . i d _ c o n t 2 )     f r o m   s e c . c o n t _ m e r g e   t   w h e r e 
 
                       t . i d _ c o n t   =     ( s e l e c t   d i s t i n c t ( t . i d _ c o n t )   a s   I D _ <0B5@8    f r o m   s e c . c o n t _ m e r g e   t     w h e r e   t . i d _ c o n t   =   ( s e l e c t   c d . c u s t o m e r s _ i d 
 
                                                             f r o m   s e c . c a r d s _ f o r _ s u p p o r t   c d       w h e r e   c d . c a r d n u m   =   )     o r   t . i d _ c o n t 2   =   ( s e l e c t   c d . c u s t o m e r s _ i d   f r o m   s e c . c a r d s _ f o r _ s u p p o r t   c d     w h e r e   c d . c a r d n u m   =    ) ) )   a s   I D _ 4>G5:,   ( s e l e c t   d e c o d e ( ( s e l e c t   c o u n t ( * )   f r o m   S E C . C G   t   w h e r e   t . S T A T E   =   0   a n d   t . C A R D N U M   =   ) ,   0 ,   N U L L , ' !   !   !   !",   +  /  !   !   ! ' )   f r o m   d u a l )   a s   040=85_ 4;O_ :0@BK  f r o m   s e c . c a r d s _ f o r _ s u p p o r t   c d ,   s e c . c a r d s _ p a r a m s _ f o r _ s u p p o r t   c p ,   s e c . c u s t o m e r s _ f o r _ s u p p o r t   c u ,   s e c . c u s t o m e r s _ p a r a m s   c u p   w h e r e   c d . c a r d n u m   =         a n d   c d . c a r d n u m   =   c p . c a r d n u m ( + )   a n d   c d . c u s t o m e r s _ i d   =   c u . c u s t o m e r s _ i d ( + )   a n d   c d . c u s t o m e r s _ i d   =   c u p . c u s t o m e r s _ i d ( + )  s e l e c t   d e c o d e ( t o _ c h a r ( s r v c . s e r v i c e s _ i d ) , 
 
                             n u l l , 
 
                             t o _ c h a r ( c u o . s e r v i c e s _ i d ) , 
 
                             s r v c . s e r v i c e _ n a m e )   a s   #A;C30_ :;85=B0, 
 
               t o _ c h a r ( c u o . s e r v i c e _ b a l a n c e )   a s   0;0=A_ AG5B0_ :;85=B0, 
 
               t o _ c h a r ( c u o . s e r v i c e _ b a l a n c e _ f p )   a s   AB0B>:_ ?>_ $&
 
     f r o m   s e c . c u s t o m e r s _ o f f _ i n f o   c u o ,   s e c . s e r v i c e s   s r v c 
 
   w h e r e   c u o . c u s t o m e r s _ i d   = 
 
               ( s e l e c t   c d . c u s t o m e r s _ i d 
 
                     f r o m   s e c . c a r d s _ f o r _ s u p p o r t   c d 
 
                   w h e r e   c d . c a r d n u m   =   )   a n d   s r v c . s e r v i c e s _ i d ( + )   =   c u o . s e r v i c e s _ i d   a n d   s r v c . e m i t e n t _ i d ( + )   =   c u o . e m i t e n t _ i d  s e l e c t   t . C A R D N U M   0@B0, 
 
               t o _ c h a r ( t . T E R M I N A L _ D A T E ,   ' d d . m m . y y y y   h h 2 4 : m i : s s ' )   a s   0B0_ @50;870F88_ _ ?>_ G5:C, 
 
               t . A C Q U I R E R _ I D   | |   ' / '   | |   t . T E R M I N A L _ I D   a s   "5@<8=0;, 
 
               d e c o d e ( t . S E R V I C E S _ I D ,   q . s e r v i c e s _ i d ,   q . s e r v i c e _ n a m e ,   t . S E R V I C E S _ I D )   | | 
 
               '   -   =>2K9  ;8<8B  -   '   | |   t . L I M I T _ S U M   | |   '   '   | | 
 
               d e c o d e ( t . S E R V I C E S _ I D ,   q . s e r v i c e s _ i d ,   q . U N I T _ L E T T E R ,   t . S E R V I C E S _ I D )   #A;C30, 
 
               t o _ c h a r ( t . T S ,   ' d d . m m . y y y y   h h 2 4 : m i : s s ' )   0B0_ 70?8A8
 
     f r o m   S E C . T R A N S A C T I O N S _ D C L   t 
 
     F U L L   O U T E R   J O I N   s e c . S E R V I C E S   q 
 
         O N   t . E M I T E N T _ I D   =   q . E M I T E N T _ I D 
 
       a n d   t . S E R V I C E S _ I D   =   q . s e r v i c e s _ i d 
 
   w h e r e   t . C A R D N U M   =   I0 0 0 2 4 5 0 0 - 0 0 0 0 - 0 0 0 0 - C 0 0 0 - 0 0 0 0 0 0 0 0 0 0 4 6 #(  -! ":   
l a b e l 1  
S e r v e r  
l a b e l 2  P s w  t e x t B o x 1  t e x t B o x 2  t e x t B o x 3  
l a b e l 3  L o g i n  )M i c r o s o f t   S a n s   S e r i f  b u t t o n 2  C A R D   I N F O   A S  b u t t o n 4  L O S T   T R Z   A S  
l a b e l 4  
C a r d   !t e x t B o x 4  t a b P a g e 4  C A R D   O P E R A T I O N S  l a b e l 1 2  l a b e l 1 1  d a t a G r i d V i e w 4  t a b P a g e 2  L o s t _ T R Z _ A S  l a b e l 1 0  
l a b e l 9  d a t a G r i d V i e w 1  t a b P a g e 1  I e m _ r e p l _ A S  l a b e l 3 0  
l a b e l 8  
l a b e l 7  d a t a G r i d V i e w 1 1  T a b C o n t r o l  t a b P a g e 8  C A R D   I N F O  l a b e l 2 2  l a b e l 2 1  d a t a G r i d V i e w 8  t a b P a g e 9  C L I E N T   A C C O U N T  l a b e l 2 3  l a b e l 2 4  d a t a G r i d V i e w 9  t a b P a g e 6  C A R D   L I M I T S  l a b e l 1 6  l a b e l 1 5  d a t a G r i d V i e w 6  t a b P a g e 7  C L I E N T   L I M I T S  l a b e l 1 8  l a b e l 1 7  d a t a G r i d V i e w 7  t a b P a g e 5  C A R D   U D U K  l a b e l 2 0  l a b e l 1 9  d a t a G r i d V i e w 5  l a b e l 1 3  l a b e l 1 4  t a b P a g e 1 0  C A R D   O I L  l a b e l 2 6  l a b e l 2 5  d a t a G r i d V i e w 1 0  t a b P a g e 3  #A n y   T a b l e   o r   V i e w  l a b e l 2 8  l a b e l 2 7  d a t a G r i d V i e w 3  b u t t o n 5  !A N Y   T A B L E   /   V I E W  t e x t B o x 5  US E L E C T   *   F R O M   s e c . t r a n s a c t i o n s _ f o r _ s u p p o r t  
l a b e l 5  #T a b l e   /   V i e w   N a m e  t e x t B o x 6  W H E R E   c a r d n u m =   1 0 0 5 0 0 0 0 0 0     a n d   t e r m i n a l _ d a t e > = s y s d a t e - 3 0   a n d   R O W N U M   < 5 0 0   o r d e r   b y   t e r m i n a l _ d a t e   d e s c 
l a b e l 6  7S Q L   C L A U S E   (   u s e   R O W N U M !   )    b u t t o n 3  I E M   R E P L   A S  +A r i a l   R o u n d e d   M T   B o l d  l a b e l 2 9  b u t t o n 6  b u t t o n 1  $ t h i s . I c o n  F o r m 1  I n f o _ B D   v . 1 . 0  KW i n d o w s F o r m s A p p 3 . P r o p e r t i e s . R e s o u r c e s  b l a c k 3 3  b l a c k 3 3 1  e x p e x c e l 3 3  e x p e x c e l 3 3 1  g r e e n  r e d  7s s i s - e x p o r t - e x c e l - f i l e - t a s k - *J!k          	  aa  a  m         qum U q u  @) 4 4 4 4 4 4 4 4 4 4m    	 
 D   D    ! %  ) -  y 9  = A IM E  U  Y  ] a e m q u  y  }       A     z\V4?_
:EIMQUY]D i             4  ,  @    0     , @   0        TWrapNonExceptionThrows       WindowsFormsApp3       Copyright ©  2019  ) $db4ed487-295b-4235-bf80-04415b4cee9b   1.0.0.0  M .NETFramework,Version=v4.7.2 TFrameworkDisplayName.NET Framework 4.7.2                                                    <          .          n     A 3System.Resources.Tools.StronglyTypedResourceBuilder16.0.0.0  Y KMicrosoft.VisualStudio.Editors.SettingsDesigner.SettingsSingleFileGenerator11.0.0.0      ) $00024413-0000-0000-C000-000000000046  V (Microsoft.Office.Interop.Excel.AppEvents(Microsoft.Office.Interop.Excel.AppEvents  X $00020813-0000-0000-c000-000000000046.Microsoft.Office.Interop.Excel.AppEvents_Event  ) $000208D5-0000-0000-C000-000000000046  _ ZSystem.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089  ) $00024411-0000-0000-C000-000000000046  V (Microsoft.Office.Interop.Excel.DocEvents(Microsoft.Office.Interop.Excel.DocEvents  X $00020813-0000-0000-c000-000000000046.Microsoft.Office.Interop.Excel.DocEvents_Event  
 _Default  ) $00020846-0000-0000-C000-000000000046  ) $000208D7-0000-0000-C000-000000000046  ) $000208DA-0000-0000-C000-000000000046  ) $00024412-0000-0000-C000-000000000046  ` -Microsoft.Office.Interop.Excel.WorkbookEvents-Microsoft.Office.Interop.Excel.WorkbookEvents  ] $00020813-0000-0000-c000-0000000000463Microsoft.Office.Interop.Excel.WorkbookEvents_Event  ) $000208DB-0000-0000-C000-000000000046  ) $000208D8-0000-0000-C000-000000000046             lSystem.Resources.ResourceReader, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089#System.Resources.RuntimeResourceSet         fSystem.Drawing.Icon, System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3aBj    5  $ t h i s . I c o n     @              QSystem.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a   System.Drawing.Icon   IconDataIconSizeSystem.Drawing.Size      	   System.Drawing.Size   widthheight                                  (       @             ^  ^                                   
   ,   J   f                                    v   \   >                                          8                                                                        k   !                 A                        w   ]   J   <   3   -   +   +   .   5   ?   N   c   }                               R            ^   %                                                                              
   0   p                     R                                                                                             {                                                                                                    S               !                                                                                              U               !                                                          	                                     T                         )   V                                                      p   E             S               O                                                                              e   k                              [   9   !                                              &   @   e                                 V                                                                                            r                  )                                                                                         _                                                                                                        S                                                                                                                  T               "                      	      +   :   F   P   W   Z   Y   U   N   C   6   &                            V                      8   q                                                               b   *       R                                                   z   w   w   |                                                            n   <                                                                    !   G   }                                                                                                              &                                                                                                                   T               !                                                                                          U                                                                                                                  S               !                               *   6   @   G   J   J   E   =   3   '                               V                      7   j                                                               ^   ,       R                                                                                                                        v   D   "                                                                (   N                                                                                                                                        J                                                                                 
   ,   b            H       p                        q   Z   H   ;   2   -   +   +   .   5   ?   M   a   {                        J                 M                                                                           ;                                      ,   I   d   |                                 w   ^   B   %   
                        )       H                         _   (                @    )(        lSystem.Resources.ResourceReader, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089#System.Resources.RuntimeResourceSet         hSystem.Drawing.Bitmap, System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3aPADPAD[nF
v<jJ+p    A      \   k   (   v     b l a c k 3 3     b l a c k 3 3 1 ~  e x p e x c e l 3 3 ?  e x p e x c e l 3 3 1 	  
g r e e n k
  r e d   6s s i s - e x p o r t - e x c e l - f i l e - t a s k K  @              QSystem.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a   System.Drawing.Bitmap   Data   	        PNG

   
IHDR   !   "   p   gAMA  a   	pHYs    (J  }IDATXG;k2aVXYBJ!`g?RQ{
6

$hikmeeH$o2ٍYm>82geWM@4]̿΢_9ix, P($áJ0pWp8SedKijVTJ%|0\n5a%<Ԥ-{KD"J$bXC5gVX\9@ŐYʹ2^rlA>!tgzHc!T.7uz4ͤe!(y-kooo,=(˥к.,>>>cG߇v-j
gRIhwwwh@l6kn	9r~VjZ/95F,><<t^@E//5Y~a:ʀsL&0rɺ\lB\R7VNrQ.c~x~~f_cw&
,~yyQn0gќ]x<EwG"owe5i%Ip( .lfEyz.AkFa詊b^`(P(~Ţa9؅R\.'t>! ^T(    IENDB`@              QSystem.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a   System.Drawing.Bitmap   Data   	        PNG

   
IHDR         A   gAMA  a    cHRM  z&         u0  `  :  pQ<   	pHYs    +  IDAT8O=PKkI
."p@ 6DD
VbaVګ`*{g޽j|8dh4Mb.%鷯QZ|Ngz=6C`b v1u]~y;8zevpو!lQXըjQݦFYx\x9jvP@0MH@ܳRDi)da&(0RZ6Ce^za3zQB\NA%)|>`tݰ2!˲u2}W0idIXT`ZbPgz	j.˜)3
Leau	f
~D~pCm/`0?d2y8az'_<RF'    IENDB`@              QSystem.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a   System.Drawing.Bitmap   Data   	        PNG

   
IHDR      "   Hit   gAMA  a    cHRM  z&         u0  `  :  pQ<   	pHYs    +  iIDATXG1Pba,!Lo(1Hjf_`"B
bL|}ޞZ]=<y8C" }I2fe|+7.Kr^r`rp(t:KډbtV^gN@h4~痴FnK予6=GJn7Y.Nïb2hrc]ĸEqUUfI"!P(d2]qV#lryNp|W«VV+X,|>ǯ@
=^8N%1FgzHWbP*i{P%F@fjve#FWJ%4D"qv;A/4Ab#gh7
F(jI,lRʻ3Tm6#Og=JeFH
UzF
NaW:ȡJ,(Mߧ=&b<MI3^)o7
q$&hwH0|Ա30b/|\L&r<n%
R
u-'<iXV]p/:B4J    IENDB`@              QSystem.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a   System.Drawing.Bitmap   Data   	        PNG

   
IHDR      "   Hit   gAMA  a    cHRM  z&         u0  `  :  pQ<   	pHYs    +  iIDATXG1Pba,!Lo(1Hjf_`"B
bL|}ޞZ]=<y8C" }I2fe|+7.Kr^r`rp(t:KډbtV^gN@h4~痴FnK予6=GJn7Y.Nïb2hrc]ĸEqUUfI"!P(d2]qV#lryNp|W«VV+X,|>ǯ@
=^8N%1FgzHWbP*i{P%F@fjve#FWJ%4D"qv;A/4Ab#gh7
F(jI,lRʻ3Tm6#Og=JeFH
UzF
NaW:ȡJ,(Mߧ=&b<MI3^)o7
q$&hwH0|Ա30b/|\L&r<n%
R
u-'<iXV]p/:B4J    IENDB`@              QSystem.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a   System.Drawing.Bitmap   Data   	        PNG

   
IHDR   !   #   ,cd   gAMA  a   	pHYs    (J  IDATXGXklTEҪ>mіGk6E@h|D1V	EFi`CCTIDTBb$0hٹw>,KKf3sw;w
$j=P>'D2³~X|z>'$EsN޸D?Q,b(_ǡ1oV-͌M5p4~Yf̛S+
En5C,EQBxN7ּFƈ"._&OTG&<;-4!~uQ1G#m.DYg%UpDxw[sS:88C!Ot@8ϳ]<4JB;Bgkt*Z^Ǳi1޲{p[E<lgi~#>W?1B \ԃOPᚆ_"mo'خhcs?(]jGj2J5&l[YYhڶv3Člؔq? ޥFJ+3g.ihD";>Ks%dKq8فai#ELZ	`~	Y5XZFy5{P\N9/'}7m 	"+lφfE08q1du넹4>UxkyFG#/vщ\Ed7ޗ\r!dJ~C&KOXd9{NPd4)lZpz>2Jb
RKNt-6̜
/P<)	6{Poh=M.7$+CxU隯	'}Qe\G	nRǪeOB|оmU]kz{;v+GøSHҷTaǛtc_gyipχKvbSؐ3f8Ӫ/=%"@<̧?(ǡǔ*祈-/oBʆaec9Kv!gڳk )R`݄Mw^")=C#<@

(GB+,3+x3[+iӨ?IrfbJQ)w+C\n:)z 
P>]1"O"c{upiY	oB<aUX]+7yz$46y3Ӄe홍I*RQ"ΓT$AY6؄zL:\'㲮4س?0_LEGLtr!gYqEZh<z>
!F"W	;y=
'U5WLr^4gf-qEhp<)qX	T#-WIby
|y	09lԎ?
_3]F}??|NY&
_
`    IENDB`@              QSystem.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a   System.Drawing.Bitmap   Data   	        PNG

   
IHDR   !   #   ,cd   gAMA  a   	pHYs    (J  0IDATXGX[lTUmk>kcƨ**	m1&LkD#D#HD>i$FP+I
~[B,H**$mH;۵N;3J6sk{=&1`emzX
]"ڪ?ĔUb
_q-}rCZ|[$jcϓhQĎoK	p/znHIU s*>¾:W##'kI|a
3)Ax9=":{8ŕrd
Ek'ϽӭW"Dċߒ)m!)r+LqFmݲK4Cʖ0+_~i4&$]_q y>1ۈ2OHbN~pPF't-1:g  "n[aF)s&$<5h7e)K(]cG L' mG_C*ЌhEz?7ųuzLŨ<e˚֍*("XU|5br32_;Ҋi|с y[A(>&w
^$r29Sҝ|~bg:w顈EI_Ŗ5oz\2*\P"ω	y~ϠnS[h-

jMy #/F,VSV@uT-5^-ZC5vA|$>pBfJrUJ0ٿinC"OP"jDk|wDt`
aXcr"|׉ve5qA<hN

Ks밞/Hn*Zor{q2~H׫/
"x:!81cP4t#3`ѧZnMïDlj9Ł)s<TR
^42*~Q_J4Ri|!n\<21r`&rE(D,%g߲4ɮ(z\`|ۍ|e$ k3ABec|<4qvC+)'^MCnpȟ0"ڍ)IB阞H(~HꃭxmK'6ORQ؜R96Np	#os!#_>KIo\z~0򐏼g.+!D1KjNoIiZ$O7G#r\KV|
"<4ίyc[T sN1<APc;^J턝MU-ԓm߁*أ۞WQ?<ڵ[m Mn4emRzv=#oi6,    IENDB`@              QSystem.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a   System.Drawing.Bitmap   Data   	        PNG

   
IHDR   2   2   ?   gAMA  a   	pHYs    +   tIME0+t9  kIDAThCwUb]AAk,Ql"nl*EX7ϗߘsrww]M{93̜-SL/"W_ŷ~}|7_Ƨ~'N'|2ﾸcԨQ[n%xG^?0w}p^[
->?C~W^n-N;w}cmm6;c<
;C0 bc=㏏k6yx㧟~ziA=qy>Fny~(2$N;QG,ޞVdZG+vu4I}c]vK/4=д Ň~xz1x`tA;v3DgXhC޻1͂<,<o❮ D=.#-2j>ѿ̽>:nx2~.	.'"J^ Q<(ۆncg}v<)6TNr"@ )aTv%)^:3>_F]xj'B{gZPD_/ƽ{
I"rHdےQP\3kA=h%]
Fƍ_|q/&lGm{pŮB?ZwƦn:@38#E-(Vw\~T
5gJ
.ckD Ԕ"oT=ӽ4M1s@+{,{$lͦ
17|=Ӱj}1aT٦_qEŰasIh2/c_Sz+|<㬳Ϊ!MXa"ܬa4ӻ[f8Pvj6qez衼~uץ$AE%y˵w4LȯJk&(%\'x"^zxw>[0UB.M\qq'gKoMpI2fySNI;x{MhSD@I΃Pyq	'N?؉'sLNwA]s(tcƌ	^V&-Vv.9zphCbK0ꫯK.d,RѫW<_xcN"
x p[lql묳N;_|Xb%`^zX~kXaoDz6r/%f#5X#VYeXveXXfeZ[ntƍBK	<D䀜h!10 UW]5sSO͍P~Wa	`c9猗_~9ZGP%S+NF<Q 6hGU|IdtҤIqGzB0
cS'aTBf<#Z\y).V$)kXfG0{!ԮTWEEfHoGtM>`k3O3׈z*
`wfNt뭷f+2bĈeORU X]b`rfm;rjf1$lmEDƛy뮻}$ Zܚwy[շoXhbEM|oI*akVI틾>NAf⌁LEFъ02Rq;ɓ'wxd8$>I\RqoL2{N:ӧO+"pCŗO{$w˘rd*"EQ%蹏Tґ<E P}.`jC>g*B?묳fB5hZWًZQ/p GbjunwfHytPE]7
^a(eY2/qs[,*GiK#L u]7?r[/rd5L1ZBHh)tZY
ζ(_!B>$z/ "$f?py睉n)]NMp.MVҙ="CNեM7kI_~([rw^}[QX,,~(W.$siQAtxJ+-"@
;ѳQIƳՈ9UZ%5*L{0YysWơ>96z? A.lA=,6(vwfZ_"GZy,L0T ɞRc`㵲U"fXX?#t-ϽyQ%ANCkЏ>(1xTV!S.q
!ԌMR>%Αf}Q,ibLg	!B˘kzU2~m`/Gl17̺^	JZ!ԄXO
BD r7֚Fct=J- sw_37x8j뭷΍fGJ92=('[rØm%5ĹZ ^U"@iuT} D48㪫Jep6n4t`a4gRBNkma4&mdܘkI	m]{Skkk#᥺%dR(O{H͇fQX1ie2gp{VѶbUfVNVp>Nu5BFl2L
%ESD qj=pW-"fFAH +G2.[Q 2zP^SIj^a3<s=5Yk5Kl?/iYk>!T#,4ʡkΎ0eʔATWW    IENDB`         츛                                       RSDS5vaJg0   C:\Users\evgeny.mikhailenko\source\repos\WindowsFormsApp3\WindowsFormsApp3\obj\Release\WindowsFormsApp3.pdb 8         R                         D           _CorExeMain mscoree.dll     %  @                                                                                                                                                                                                                                                                                                                                                                                                                                           0     `                              H                                          x                                                                                                       8              (       @             ^  ^                                   
   ,   J   f                                    v   \   >                                          8                                                                        k   !                 A                        w   ]   J   <   3   -   +   +   .   5   ?   N   c   }                               R            ^   %                                                                              
   0   p                     R                                                                                             {                                                                                                    S               !                                                                                              U               !                                                          	                                     T                         )   V                                                      p   E             S               O                                                                              e   k                              [   9   !                                              &   @   e                                 V                                                                                            r                  )                                                                                         _                                                                                                        S                                                                                                                  T               "                      	      +   :   F   P   W   Z   Y   U   N   C   6   &                            V                      8   q                                                               b   *       R                                                   z   w   w   |                                                            n   <                                                                    !   G   }                                                                                                              &                                                                                                                   T               !                                                                                          U                                                                                                                  S               !                               *   6   @   G   J   J   E   =   3   '                               V                      7   j                                                               ^   ,       R                                                                                                                        v   D   "                                                                (   N                                                                                                                                        J                                                                                 
   ,   b            H       p                        q   Z   H   ;   2   -   +   +   .   5   ?   M   a   {                        J                 M                                                                           ;                                      ,   I   d   |                                 w   ^   B   %   
                        )       H                         _   (                @    )                           \          \4   V S _ V E R S I O N _ I N F O                      ?                         D    V a r F i l e I n f o     $    T r a n s l a t i o n          S t r i n g F i l e I n f o      0 0 0 0 0 4 b 0      C o m m e n t s       "   C o m p a n y N a m e         J   F i l e D e s c r i p t i o n     W i n d o w s F o r m s A p p 3     0   F i l e V e r s i o n     1 . 0 . 0 . 0   J   I n t e r n a l N a m e   W i n d o w s F o r m s A p p 3 . e x e     H   L e g a l C o p y r i g h t   C o p y r i g h t        2 0 1 9   *   L e g a l T r a d e m a r k s         R   O r i g i n a l F i l e n a m e   W i n d o w s F o r m s A p p 3 . e x e     B   P r o d u c t N a m e     W i n d o w s F o r m s A p p 3     4   P r o d u c t V e r s i o n   1 . 0 . 0 . 0   8   A s s e m b l y   V e r s i o n   1 . 0 . 0 . 0   H           ﻿<?xml version="1.0" encoding="UTF-8" standalone="yes"?>

<assembly xmlns="urn:schemas-microsoft-com:asm.v1" manifestVersion="1.0">
  <assemblyIdentity version="1.0.0.0" name="MyApplication.app"/>
  <trustInfo xmlns="urn:schemas-microsoft-com:asm.v2">
    <security>
      <requestedPrivileges xmlns="urn:schemas-microsoft-com:asm.v3">
        <requestedExecutionLevel level="asInvoker" uiAccess="false"/>
      </requestedPrivileges>
    </security>
  </trustInfo>
</assembly>                                                                                                                                                                                                                   d8                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      