mysql> show create view v1\G
*************************** 1. row ***************************
                View: v1
         Create View: CREATE ALGORITHM=UNDEFINED DEFINER=``@`` SQL SECURITY DEFINER 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 (`tab
le0033_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 ((`table001
4_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 (`tab
le0014_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_1
8466_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`.`c
ol55` = `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`) a
nd (`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` = `tab
le0033_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 `ta
ble0033_18466_0_36518`.`col67`,`table0014_18466_1_36519`.`col27`)))) group by `table0003_18483_1_36552`.`col01`,`table0033_18483_0_36551`.`col39`
character_set_client: latin1
collation_connection: latin1_swedish_ci
1 row in set (0.00 sec)