Stuff

mysql> show create view locations; 
+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| View      | Create View                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| locations | CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `est8net`.`locations` AS select `p`.`location_id` AS `id`,`lc`.`FULL_NAME_ND` AS `name`,`lcc`.`FULL_NAME_ND` AS `department` from ((`est8net`.`property` `p` join `engine`.`load_coordinates` `lc`) join `engine`.`load_coordinates` `lcc`) where ((`p`.`location_id` = `lc`.`id`) and (`lcc`.`id` = `lc`.`ADM2`)) group by `p`.`location_id` order by `lcc`.`FULL_NAME_ND`,`lc`.`FULL_NAME_ND` |
+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set, 1 warning (0.00 sec)