CREATE or replace VIEW `v1` AS select distinct sql_no_cache `table0003_18483_1_36552`.`col18` AS `col18` from `table0033` `table0033_18483_0_36551` left join `table0003` `table0003_18483_1_36552` on `table0033_18483_0_36551`.`col04` = `table0003_18483_1_36552`.`col04` and `table0033_18483_0_36551`.`col20` = `table0003_18483_1_36552`.`col20` and `table0033_18483_0_36551`.`col28` = `table0003_18483_1_36552`.`col28` and `table0033_18483_0_36551`.`col33` = `table0003_18483_1_36552`.`col33` and `table0033_18483_0_36551`.`col36` = `table0003_18483_1_36552`.`col36` and `table0033_18483_0_36551`.`col46` = `table0003_18483_1_36552`.`col46` and `table0033_18483_0_36551`.`col64` = `table0003_18483_1_36552`.`col64` and `table0033_18483_0_36551`.`col65` = `table0003_18483_1_36552`.`col65` where (`table0033_18483_0_36551`.`col56`,`table0003_18483_1_36552`.`col28`,`table0003_18483_1_36552`.`col72` ) = ((select'1' AS `1`),(select '1' AS `1`),convert((select '1' AS `1`) using latin1)) xor ((`table0003_18483_1_36552`.`col44`,`table0003_18483_1_36552`.`col64`,`table0033_18483_0_36551`.`col38`) = ((select '1' AS `1`),(select '1' AS `1`),( select distinct `table0014_18466_1_36519`.`col02` AS `col02` from `table0014` `table0014_18466_1_36519` force INDEX (`idx05`) force INDEX (`idx41`) force INDEX (`idx44`) force INDEX (`idx32`) join `table0033` `table0033_18466_0_36518` force INDEX (`idx06`) where `table0014_18466_1_36519`.`col25` = `table0033_18466_0_36518`.`col25` and `table0014_18466_1_36519`.`col28` = `table0033_18466_0_36518`.`col28` and `table0014_18466_1_36519`.`col34` = `table0033_18466_0_36518`.`col34` and `table0014_18466_1_36519`.`col35` = `table0033_18466_0_36518`.`col35` and `table0014_18466_1_36519`.`col56` = `table0033_18466_0_36518`.`col56` and `table0014_18466_1_36519`.`col67` = `table0033_18466_0_36518`.`col67` and (`table0033_18466_0_36518`.`col75`,`table0014_18466_1_36519`.`col68`) <=(`table0014_18466_1_36519`.`col11`,`table0014_18466_1_36519`.`col11`) and `table0014_18466_1_36519`.`col00` = `table0033_18466_0_36518`.`col00` and `table0014_18466_1_36519`.`col01` = `table0033_18466_0_36518`.`col01` and `table0014_18466_1_36519`.`col02` = `table0033_18466_0_36518`.`col02` and `table0014_18466_1_36519`.`col03` = `table0033_18466_0_36518`.`col03` and `table0014_18466_1_36519`.`col04` = `table0033_18466_0_36518`.`col04` and `table0014_18466_1_36519`.`col05` = `table0033_18466_0_36518`.`col05` and `table0014_18466_1_36519`.`col06` = `table0033_18466_0_36518`.`col06` and `table0014_18466_1_36519`.`col07` = `table0033_18466_0_36518`.`col07` and `table0014_18466_1_36519`.`col08` = `table0033_18466_0_36518`.`col08` and `table0014_18466_1_36519`.`col09` = `table0033_18466_0_36518`.`col09` and `table0014_18466_1_36519`.`col10` = `table0033_18466_0_36518`.`col10` and `table0014_18466_1_36519`.`col11` = `table0033_18466_0_36518`.`col11` and `table0014_18466_1_36519`.`col12` = `table0033_18466_0_36518`.`col12` and `table0014_18466_1_36519`.`col13` = `table0033_18466_0_36518`.`col13` and `table0014_18466_1_36519`.`col14` = `table0033_18466_0_36518`.`col14` and `table0014_18466_1_36519`.`col15` = `table0033_18466_0_36518`.`col15` and `table0014_18466_1_36519`.`col16` = `table0033_18466_0_36518`.`col16` and `table0014_18466_1_36519`.`col17` = `table0033_18466_0_36518`.`col17` and `table0014_18466_1_36519`.`col18` = `table0033_18466_0_36518`.`col18` and `table0014_18466_1_36519`.`col19` = `table0033_18466_0_36518`.`col19` and `table0014_18466_1_36519`.`col20` = `table0033_18466_0_36518`.`col20` and `table0014_18466_1_36519`.`col21` = `table0033_18466_0_36518`.`col21` and `table0014_18466_1_36519`.`col22` = `table0033_18466_0_36518`.`col22` and `table0014_18466_1_36519`.`col23` = `table0033_18466_0_36518`.`col23` and `table0014_18466_1_36519`.`col24` = `table0033_18466_0_36518`.`col24` and `table0014_18466_1_36519`.`col26` = `table0033_18466_0_36518`.`col26` and `table0014_18466_1_36519`.`col27` = `table0033_18466_0_36518`.`col27` and `table0014_18466_1_36519`.`col29` = `table0033_18466_0_36518`.`col29` and `table0014_18466_1_36519`.`col30` = `table0033_18466_0_36518`.`col30` and `table0014_18466_1_36519`.`col31` = `table0033_18466_0_36518`.`col31` and `table0014_18466_1_36519`.`col32` = `table0033_18466_0_36518`.`col32` and `table0014_18466_1_36519`.`col33` = `table0033_18466_0_36518`.`col33` and `table0014_18466_1_36519`.`col36` = `table0033_18466_0_36518`.`col36` and `table0014_18466_1_36519`.`col37` = `table0033_18466_0_36518`.`col37` and `table0014_18466_1_36519`.`col38` = `table0033_18466_0_36518`.`col38` and `table0014_18466_1_36519`.`col39` = `table0033_18466_0_36518`.`col39` and `table0014_18466_1_36519`.`col40` = `table0033_18466_0_36518`.`col40` and `table0014_18466_1_36519`.`col41` = `table0033_18466_0_36518`.`col41` and `table0014_18466_1_36519`.`col42` = `table0033_18466_0_36518`.`col42` and `table0014_18466_1_36519`.`col43` = `table0033_18466_0_36518`.`col43` and `table0014_18466_1_36519`.`col44` = `table0033_18466_0_36518`.`col44` and `table0014_18466_1_36519`.`col45` = `table0033_18466_0_36518`.`col45` and `table0014_18466_1_36519`.`col46` = `table0033_18466_0_36518`.`col46` and `table0014_18466_1_36519`.`col47` = `table0033_18466_0_36518`.`col47` and `table0014_18466_1_36519`.`col48` = `table0033_18466_0_36518`.`col48` and `table0014_18466_1_36519`.`col49` = `table0033_18466_0_36518`.`col49` and `table0014_18466_1_36519`.`col50` = `table0033_18466_0_36518`.`col50` and `table0014_18466_1_36519`.`col51` = `table0033_18466_0_36518`.`col51` and `table0014_18466_1_36519`.`col52` = `table0033_18466_0_36518`.`col52` and `table0014_18466_1_36519`.`col53` = `table0033_18466_0_36518`.`col53` and `table0014_18466_1_36519`.`col54` = `table0033_18466_0_36518`.`col54` and `table0014_18466_1_36519`.`col55` = `table0033_18466_0_36518`.`col55` and `table0014_18466_1_36519`.`col57` = `table0033_18466_0_36518`.`col57` and `table0014_18466_1_36519`.`col58` = `table0033_18466_0_36518`.`col58` and `table0014_18466_1_36519`.`col59` = `table0033_18466_0_36518`.`col59` and `table0014_18466_1_36519`.`col60` = `table0033_18466_0_36518`.`col60` and `table0014_18466_1_36519`.`col61` = `table0033_18466_0_36518`.`col61` and `table0014_18466_1_36519`.`col62` = `table0033_18466_0_36518`.`col62` and `table0014_18466_1_36519`.`col63` = `table0033_18466_0_36518`.`col63` and `table0014_18466_1_36519`.`col64` = `table0033_18466_0_36518`.`col64` and `table0014_18466_1_36519`.`col65` = `table0033_18466_0_36518`.`col65` and `table0014_18466_1_36519`.`col66` = `table0033_18466_0_36518`.`col66` and `table0014_18466_1_36519`.`col68` = `table0033_18466_0_36518`.`col68` and `table0014_18466_1_36519`.`col69` = `table0033_18466_0_36518`.`col69` and `table0014_18466_1_36519`.`col70` = `table0033_18466_0_36518`.`col70` and `table0014_18466_1_36519`.`col71` = `table0033_18466_0_36518`.`col71` and `table0014_18466_1_36519`.`col72` = `table0033_18466_0_36518`.`col72` and `table0014_18466_1_36519`.`col73` = `table0033_18466_0_36518`.`col73` and `table0014_18466_1_36519`.`col74` = `table0033_18466_0_36518`.`col74` and `table0014_18466_1_36519`.`col75` = `table0033_18466_0_36518`.`col75` and `table0014_18466_1_36519`.`col76` = `table0033_18466_0_36518`.`col76` group by `table0033_18466_0_36518`.`col67`, `table0014_18466_1_36519`.`col27` ) ) ) group by `table0003_18483_1_36552`.`col01`,`table0033_18483_0_36551`.`col39` ;