drop table if exists b;
/*!50001 drop view if exists b*/;
/*!50001 create table b (
  m char(16) character set utf8 default null,
  h char(16) character set utf8 default null,
  n char(16) character set utf8 not null default '',
  o int(11) not null default '0',
  p varchar(50) character set utf8 not null default ''
) engine=myisam default charset=latin1*/;


drop table if exists c;
create table c (
  q char(16) not null default '',
  r int(11) not null,
  x1 int(11) not null,
  x2 int(11) default null,
  x3 int(11) default null,
  primary key  (q)
) engine=innodb default charset=utf8;



/*!40000 alter table c disable keys */;
lock tables c write;
insert into c values ('116',4,4,27,27),('117',4,4,28,28),('500',2,2,17,17),('501',2,2,18,18),('540',4,4,43,43),('560',4,4,44,44),('570',2,2,24,24);
unlock tables;
/*!40000 alter table c enable keys */;


drop table if exists d;
create table d (
  s int(11) not null default '0',
  x4 int(11) not null,
  x5 varchar(50) default null,
  x6 varchar(255) not null,
  x7 char(15) not null,
  x8 char(12) not null,
  t int(11) not null,
  x9 tinyint(1) not null,
  x10 int(11) default null,
  x11 int(11) default null,
  x12 int(11) default null,
  x13 int(11) default null,
  x14 int(11) default null,
  x15 int(11) default null,
  x16 int(11) default null,
  x17 int(11) default null,
  x18 int(11) default null,
  x19 int(11) default null,
  x20 tinyint(1) default null,
  x21 int(11) not null,
  x22 int(11) not null,
  x23 tinyint(1) not null,
  x24 int(11) default null,
  u char(16) default null,
  x25 tinyint(1) default null,
  primary key  (s)
) engine=innodb default charset=utf8;



/*!40000 alter table d disable keys */;
lock tables d write;
insert into d values (1,5,'foooooooo','foooooooo','10.1.1.167','000000000000',1,0,null,null,null,null,null,null,null,null,null,null,0,1,1,0,null,'',0),(2,3,'top','top','10.1.254.98','001049000982',1,0,null,null,null,null,null,null,null,null,null,null,0,1,1,0,null,'',0),(3,8,'aoiwooooojfo','aoiwooooojfo','10.1.100.30','000000000000',2,0,null,null,null,null,null,null,null,null,null,null,0,1,2,0,null,'',0),(4,3,'adlk','adlk','10.1.96.200','001049000f5e',2,0,null,null,null,null,null,null,null,null,null,null,0,1,2,0,null,'',0),(5,8,'hq 2','hq 2','10.1.1.173','000000000000',1,0,null,null,null,null,null,null,null,null,null,null,0,1,3,0,null,'',0);
unlock tables;
/*!40000 alter table d enable keys */;

drop table if exists e;
create table e (
  q char(16) not null default '',
  x26 int(11) not null,
  v int(11) not null,
  x27 varchar(50) not null,
  x28 varchar(50) not null,
  x29 varchar(50) not null,
  x30 int(11) not null,
  x31 int(11) not null,
  x32 tinyint(1) not null,
  x33 int(11) not null,
  x34 int(11) default null,
  x35 int(11) not null,
  x36 tinyint(1) not null,
  x37 tinyint(1) not null,
  x38 tinyint(1) not null,
  x39 tinyint(1) not null,
  x40 tinyint(1) not null,
  x41 int(11) not null,
  x42 tinyint(1) not null,
  x43 tinyint(1) not null,
  x44 tinyint(1) default null,
  x45 tinyint(1) not null,
  x46 tinyint(1) not null,
  x47 int(11) default null,
  x48 int(11) not null,
  x49 varchar(32) default null,
  x50 datetime default null,
  x51 datetime default null,
  vmserverid int(11) default null,
  x52 int(11) not null,
  x53 varchar(64) default null,
  x54 varchar(50) default null,
  x55 int(11) default null,
  x56 varchar(64) default null,
  x57 char(16) default null,
  x58 tinyint(1) default null,
  x59 tinyint(1) default null,
  x60 int(11) default null,
  x61 tinyint(1) default null,
  primary key  (q)
) engine=innodb default charset=utf8;


/*!40000 alter table e disable keys */;
lock tables e write;
insert into e values ('116',5,7,' ','f24b448e9e95d4647343673ca97b8ed8','1234',1,1,0,1,null,3,0,0,0,0,0,0,0,0,0,0,0,null,1,null,null,null,null,1,null,null,null,null,null,0,0,null,0),('117',5,8,' ','f24b448e9e95d4647343673ca97b8ed8','1234',1,1,0,1,null,3,0,0,0,0,0,0,0,0,0,0,0,null,1,null,null,null,null,1,null,null,null,null,null,0,0,null,0),('500',2,1,'u500','4cb9c8a8048fd02294477fcb1a41191a','1234',1,4,1,1,1,3,0,0,0,1,0,4,0,0,0,0,0,null,1,null,null,null,1,1,null,null,null,'ouakdlfjwoijewif',null,0,1,1,0),('501',1,2,'u501','4cb9c8a8048fd02294477fcb1a41191a','1234',1,8,1,1,1,3,1,1,1,1,0,4,0,0,0,0,0,null,1,null,null,null,1,1,null,null,null,null,null,0,1,1,0),('540',10,5,'u540','4cb9c8a8048fd02294477fcb1a41191a','1234',1,8,1,1,null,3,1,1,1,1,0,4,0,0,0,0,0,null,1,null,null,null,2,1,null,null,null,null,null,0,1,2,0),('550',9,4,'u550','4cb9c8a8048fd02294477fcb1a41191a','1234',1,4,1,1,null,3,0,0,1,1,0,4,0,0,0,0,0,null,1,null,null,null,1,1,null,null,null,null,null,0,1,3,0),('560',1,6,'u560','4cb9c8a8048fd02294477fcb1a41191a','1234',1,8,1,1,1,3,1,1,1,1,0,4,0,0,0,0,0,null,1,null,null,null,2,1,null,null,null,null,null,0,1,1,0),('570',1,9,'u570','4cb9c8a8048fd02294477fcb1a41191a','1234',1,8,1,1,1,3,0,0,1,1,0,4,0,0,0,0,0,null,1,null,null,null,3,1,null,null,null,null,null,0,1,1,0);
unlock tables;
/*!40000 alter table e enable keys */;

drop table if exists f;
create table f (
  v int(11) not null auto_increment,
  q char(16) default null,
  aa varchar(50) default null,
  ab varchar(50) default null,
  ac varchar(255) default null,
  ad varchar(50) default null,
  ae char(20) default null,
  af char(20) default null,
  ag varchar(50) default null,
  ah varchar(50) default null,
  ai varchar(50) default null,
  aj varchar(50) default null,
  ak varchar(50) default null,
  al varchar(50) default null,
  am varchar(50) default null,
  an varchar(50) default null,
  ao varchar(50) default null,
  ap varchar(50) default null,
  primary key  (v)
) engine=innodb default charset=utf8;


/*!40000 alter table f disable keys */;
lock tables f write;
insert into f values (1,null,'lkjf','500',null,null,null,null,null,'ouakdlfjwoijewif',null,null,null,null,null,null,null,null),(2,null,'lkjf','501',null,null,null,null,null,'ouakdlfjwoijewif',null,null,null,null,null,null,null,null),(3,null,'asldkfj',null,null,null,null,null,null,null,null,null,null,null,null,null,null,null),(4,null,'lkjf','550',null,null,null,null,null,'ouakdlfjwoijewif',null,null,null,null,null,null,null,null),(5,null,'lkjf','540',null,null,null,null,null,'ouakdlfjwoijewif',null,null,null,null,null,null,null,null),(6,null,'lkjf','560',null,null,null,null,null,'ouakdlfjwoijewif',null,null,null,null,null,null,null,null),(7,null,'smdi','a;liaafwiioji',null,null,null,null,null,null,null,'116',null,null,null,null,null,null),(8,null,'smdi','a;liaafwiioji',null,null,null,null,null,null,null,'117',null,null,null,null,null,null),(9,null,'lkjf','570',null,null,null,null,null,'ouakdlfjwoijewif',null,null,null,null,null,null,null,null);
unlock tables;
/*!40000 alter table f enable keys */;

drop table if exists g;
create table g (
  t int(11) not null auto_increment,
  aa varchar(50) not null,
  u char(16) default null,
  ab char(16) default null,
  ac char(16) default null,
  ad char(16) default null,
  ae char(16) default null,
  af int(11) default null,
  ag char(16) default null,
  ah char(16) default null,
  nah char(16) default null,
  nbah int(11) default null,
  nbcah int(11) default null,
  mm int(11) not null,
  primary key  (t)
) engine=innodb default charset=utf8;


/*!40000 alter table g disable keys */;
lock tables g write;
insert into g values (1,'woifwoojo',null,null,null,null,null,3,'100','100','100',3,16,1),(2,'aoiwooooojfo',null,null,null,null,null,3,'101','101','101',3,16,2);
unlock tables;
/*!40000 alter table g enable keys */;

drop table if exists h;
create table h (
  h char(16) not null default '',
  a1 varchar(50) not null,
  dntypeid int(11) not null,
  hidden tinyint(1) not null,
  dnuuid varchar(36) not null,
  excludefromdialbyname tinyint(1) not null,
  a2 int(11) default null,
  an int(11) not null auto_increment,
  primary key  (h),
  key (an)
) engine=innodb default charset=utf8;


/*!40000 alter table h disable keys */;
lock tables h write;
insert into h values ('100','woid',2,0,'e5d339d5-5e4f-4b1d-9c04-39290e7a9c09',1,1,1),('101','woidfj',4,0,'0ba61333-a7cc-4faa-a186-785a2f001c8a',1,1,2),('102','woidfj',5,0,'b0c1cd91-01f7-4602-8bdc-eacb0b383e90',1,1,3),('103','woid',3,0,'3f54e626-04f8-401b-aa33-287990d219a9',1,1,4),('104','aldfkjw',15,0,'ea70add1-d9e1-49e7-891b-9190efa13b11',1,1,5),('105','aldfkjw',16,0,'0a61424e-828e-4144-86a9-e63f9cdb7430',1,1,6),('106','aldfkjw',17,0,'80a0bf89-e364-401d-a692-2175963212d6',1,1,7),('107','account code service',18,0,'73d48cd4-599b-4a8e-909b-950e7cbc1caf',1,1,8),('108','system conference',19,0,'098d9f40-3f81-454e-b791-6aaaf06775d7',1,1,9),('109','aoiwooooojfo',16,0,'5118e4a3-66d6-4d7b-8e13-a3268965dfb8',0,null,16),('110','aoiwooooojfo',17,0,'169b5fce-dc80-4876-8c1e-8e3a61c071b8',0,null,17),('111','aoiwooooojfo',15,0,'3bb93848-b4e5-433f-bbaf-2bd16722251b',0,null,18),('112','xx',21,0,'3c97df53-9465-4584-841c-2448e113606a',0,1,21),('113','hq 2 vmext',16,0,'19fd6f58-71fc-43d1-a16d-bbf9b6976a9c',0,null,22),('114','hq 2 vmloginext',17,0,'68af8bbd-c4d8-480d-8141-e89c43e114c3',0,null,23),('115','hq 2 vmaaext',15,0,'f070bfb1-c364-4830-9487-caceaa2e2aee',0,null,24),('116','smdiaoiwooooojfo',20,1,'2a64ecd7-d7d2-449c-b620-36e9a0f13791',0,1,28),('117','smdiaoiwooooojfo',20,1,'7bfccb2f-d4d5-4859-b848-1192349ab9d1',0,1,29),('250','asldkfj',9,0,'70306fd0-1e94-42f7-a639-74b4154db215',0,1,20),('500','lkjf 500',1,0,'05c49dc2-621d-43e2-9447-0299441f5a83',0,1,15),('501','lkjf 501',1,0,'d4cfcfe2-6e33-44fc-933c-95ca0f5686eb',0,1,19),('540','lkjf 540',1,0,'628e1c2c-fd45-4346-9ede-d40f3cd060db',0,1,26),('550','lkjf 550',23,0,'ef907536-26c4-4006-86ee-be66b21d3f15',0,1,25),('560','lkjf 560',1,0,'a2655c2d-7368-47fb-b043-39a22cf63416',0,1,27),('570','lkjf 570',1,0,'f3051eeb-d7e7-4265-9f80-d331b0ed6508',0,1,30),('600','oifjo',10,0,'e9de9a14-0a4b-4e6c-a678-63052b88e6d5',1,1,10),('601','a;ldkfj',11,0,'6dc7e5ec-0854-4ba6-b1ca-c57bf64a656e',1,1,11),('602','aodfojoooo',11,0,'dbfb5704-af56-40b7-a4cf-8e625d4ea439',1,1,12),('603','oioaijiif',11,0,'07cece61-0d5f-4929-b85e-00a0ce980948',1,1,13),('700','default',8,0,'ad591890-f246-48e1-9be0-ade7e1b6e077',1,1,14);
unlock tables;
/*!40000 alter table h enable keys */;

drop table if exists i;
create table i (
  o int(11) not null auto_increment,
  p varchar(50) not null,
  xa int(11) not null,
  xq tinyint(1) not null,
  xw char(16) default null,
  xe char(16) default null,
  xt char(16) default null,
  xy char(16) default null,
  xu char(16) default null,
  a5 char(16) default null,
  xi tinyint(1) default null,
  xo tinyint(1) default null,
  xp tinyint(1) default null,
  w tinyint(1) default null,
  xs tinyint(1) default null,
  xd tinyint(1) default null,
  kkkk tinyint(1) default null,
  xf tinyint(1) default null,
  xg tinyint(1) default null,
  xh tinyint(1) default null,
  jjjj tinyint(1) default null,
  xk tinyint(1) default null,
  xj tinyint(1) default null,
  xz tinyint(1) default null,
  xx tinyint(1) default null,
  xc int(11) default null,
  xv tinyint(1) default null,
  xb tinyint(1) default null,
  xn tinyint(1) default null,
  x26 int(11) default null,
  iiii char(16) default null,
  mm int(11) not null,
  xm varchar(64) default null,
  x3 varchar(64) default null,
  x4 int(11) default null,
  x5 tinyint(1) default null,
  vmserverid int(11) default null,
  a2 int(11) default null,
  x6 tinyint(1) default null,
  x7 char(16) default null,
  x8 int(11) default null,
  x9 tinyint(1) default null,
  x0 tinyint(1) default null,
  xwe varchar(64) default null,
  wea varchar(64) default null,
  xwz int(11) default null,
  primary key  (o)
) engine=innodb default charset=utf8;


/*!40000 alter table i disable keys */;
lock tables i write;
insert into i values
(1,'x',1,1,'9','408',null,null,'100','700',0,0,0,0,1,1,1,1,1,1,1,1,0,0,1,null,0,0,0,null,null,1,'alskdf',null,null,1,1,1,0,null,null,0,0,null,null,1),
(2,'x',3,1,'9','408',null,null,'100','700',0,0,0,0,1,1,1,1,1,1,1,1,0,0,1,null,0,0,0,null,null,1,'alskdf',null,null,0,null,1,0,null,null,0,0,null,null,1),
(3,'x',4,1,'9','408',null,null,'100','700',0,0,0,0,1,1,1,1,1,1,1,1,0,0,1,null,0,0,0,null,null,1,'slakfj',null,null,0,null,1,0,null,null,0,0,null,null,1),
(4,'x',1,0,null,null,null,null,'100','700',0,0,0,0,1,1,1,1,1,1,1,1,0,0,1,null,0,0,0,null,null,1,'slakfj',null,null,1,3,1,0,null,null,0,0,null,null,null);
unlock tables;
/*!40000 alter table i enable keys */;

drop table if exists j;
create table j (
  o int(11) default null,
  x int(11) not null auto_increment,
  w tinyint(1) not null,
  a1 int(11) not null,
  m char(16) default null,
  primary key  (x)
) engine=innodb default charset=utf8;

/*!40000 alter table j disable keys */;
lock tables j write;
insert into j values (1, 1, 1, 1, 1);
unlock tables;
/*!40000 alter table j enable keys */;

drop table if exists k;
create table k (
  o int(11) not null default '0',
  x int(11) not null default '0',
  n char(16) not null default '',
  h char(16) default null,
  a5 char(16) default null,
  bbb char(32) default null,
  a1 char(32) default null,
  y int(11) not null auto_increment,
  primary key  (o,x,n),
  unique key adiddigitmapid (y)
) engine=innodb default charset=utf8;

/*!40000 alter table k disable keys */;
lock tables k write;
insert into k values (1, 1, 1, 1, 1, 1, 1, 1);
unlock tables;
/*!40000 alter table k enable keys */;

drop table if exists b;
drop view if exists b;
create view b as
select
    j.m, k.h, k.n,
    i.o, i.p
from
    j
    join k
    on j.x = k.x
    join i
    on k.o = i.o
        and j.o = k.o
where j.w = 0;

select count(*) from h left join b on h.h = b.h join e on h.h = e.q join f on f.v = e.v join c on e.q = c.q join d on s = r;

select count(*) from h left join b on h.h = b.h join e on h.h = e.q join f on f.v = e.v join c on e.q = c.q join d;

select count(*) from h left join b on h.h = b.h join e on h.h = e.q join f on f.v = e.v join c on e.q = c.q;

select version();