| 1 | SHOW FULL COLUMNS FROM `aros` | | 7 | 7 | 5 |
| 2 | SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci'; | | 1 | 1 | 4 |
| 3 | SHOW FULL COLUMNS FROM `acos` | | 7 | 7 | 4 |
| 4 | SHOW FULL COLUMNS FROM `aros_acos` | | 7 | 7 | 1 |
| 5 | SHOW FULL COLUMNS FROM `waypoints` | | 7 | 7 | 3 |
| 6 | SHOW FULL COLUMNS FROM `quests` | | 5 | 5 | 2 |
| 7 | SHOW FULL COLUMNS FROM `users` | | 9 | 9 | 3 |
| 8 | SHOW FULL COLUMNS FROM `groups` | | 4 | 4 | 1 |
| 9 | SELECT COUNT(*) AS `count` FROM `waypoints` AS `Waypoint` LEFT JOIN `quests` AS `Quest` ON (`Waypoint`.`quest_id` = `Quest`.`id`) WHERE 1 = 1 | | 1 | 1 | 2 |
| 10 | SELECT `Waypoint`.`id`, `Waypoint`.`title`, `Waypoint`.`quest_id`, `Waypoint`.`lat`, `Waypoint`.`lon`, `Waypoint`.`order`, `Waypoint`.`lnglat`, `Quest`.`id`, `Quest`.`title`, `Quest`.`description`, `Quest`.`user_id`, `Quest`.`type` FROM `waypoints` AS `Waypoint` LEFT JOIN `quests` AS `Quest` ON (`Waypoint`.`quest_id` = `Quest`.`id`) WHERE 1 = 1 ORDER BY `Waypoint`.`title` asc LIMIT 20 | | 4 | 4 | 1 |
| 11 | SELECT COUNT(*) AS `count` FROM `waypoints` AS `Waypoint` LEFT JOIN `quests` AS `Quest` ON (`Waypoint`.`quest_id` = `Quest`.`id`) WHERE 1 = 1 | | 1 | 1 | 0 |
| 12 | SELECT `Waypoint`.`id`, `Waypoint`.`title`, `Waypoint`.`quest_id`, `Waypoint`.`lat`, `Waypoint`.`lon`, `Waypoint`.`order`, `Waypoint`.`lnglat`, `Quest`.`id`, `Quest`.`title`, `Quest`.`description`, `Quest`.`user_id`, `Quest`.`type` FROM `waypoints` AS `Waypoint` LEFT JOIN `quests` AS `Quest` ON (`Waypoint`.`quest_id` = `Quest`.`id`) WHERE 1 = 1 ORDER BY `Waypoint`.`title` asc LIMIT 20 | | 4 | 4 | 0 |
| 13 | SELECT COUNT(*) AS `count` FROM `waypoints` AS `Waypoint` LEFT JOIN `quests` AS `Quest` ON (`Waypoint`.`quest_id` = `Quest`.`id`) WHERE 1 = 1 | | 1 | 1 | 0 |
| 14 | SELECT `Waypoint`.`id`, `Waypoint`.`title`, `Waypoint`.`quest_id`, `Waypoint`.`lat`, `Waypoint`.`lon`, `Waypoint`.`order`, `Waypoint`.`lnglat`, `Quest`.`id`, `Quest`.`title`, `Quest`.`description`, `Quest`.`user_id`, `Quest`.`type` FROM `waypoints` AS `Waypoint` LEFT JOIN `quests` AS `Quest` ON (`Waypoint`.`quest_id` = `Quest`.`id`) WHERE 1 = 1 ORDER BY `Waypoint`.`title` asc LIMIT 20 | | 4 | 4 | 0 |
| 15 | SELECT COUNT(*) AS `count` FROM `quests` AS `Quest` LEFT JOIN `users` AS `User` ON (`Quest`.`user_id` = `User`.`id`) WHERE 1 = 1 | | 1 | 1 | 2 |
| 16 | SELECT `Quest`.`id`, `Quest`.`title`, `Quest`.`description`, `Quest`.`user_id`, `Quest`.`type`, `User`.`id`, `User`.`created`, `User`.`modified`, `User`.`lastlogin`, `User`.`name`, `User`.`email`, `User`.`username`, `User`.`password`, `User`.`group_id` FROM `quests` AS `Quest` LEFT JOIN `users` AS `User` ON (`Quest`.`user_id` = `User`.`id`) WHERE 1 = 1 LIMIT 5 | | 4 | 4 | 0 |