home

Schedule Manager

Page 1 of 9, showing 10 records out of 82 total, starting on record 1, ending on 10

common_name animal_type room start_date end_date
Anaconda Jungles Lobby Dec 27th 2009, 15:25 Jan 10th 2009, 15:25
Giraffe Jungles Lobby Jan 10th 2009, 09:43 Feb 12th 2009, 09:43
Cat Barnyards South Wing Dec 27th 2009, 15:24 Feb 16th 2009, 15:24
Angel Fish SeaCreatures Lobby Dec 27th 2009, 15:54 Mar 2nd 2009, 15:54
Sloth Jungles East Wing Dec 27th 2009, 15:25 Mar 15th 2009, 15:25
Rhinoceros Jungles South Wing Feb 27th 2009, 15:23 Apr 27th 2009, 15:23
Turkey Barnyards Lobby Dec 27th 2009, 15:24 Apr 27th 2009, 15:24
Rooster Barnyards South Wing Dec 27th 2009, 15:24 May 10th 2009, 15:24
Whale SeaCreatures East Wing Dec 14th 2009, 09:09 May 14th 2009, 09:09
Cheetah Jungles West Wing Dec 27th 2009, 15:25 Jun 5th 2009, 15:25
<< previous
| 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 next >>
(default) 9 queries took 9 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `animal_relations`663
2DESCRIBE `animals_rooms`10101
3DESCRIBE `rooms`221
4DESCRIBE `barnyards`551
5DESCRIBE `jungles`551
6DESCRIBE `sea_creatures`551
7SELECT DISTINCT SUBSTRING(AnimalRelation.common_name, 1, 1) FROM `animal_relations` AS `AnimalRelation` WHERE 1 = 1 ORDER BY `AnimalRelation`.`common_name` asc 16160
8SELECT COUNT(*) AS `count` FROM `animals_rooms` AS `AnimalsRoom` inner JOIN animal_relations AS `Anim_Rel` ON (`AnimalsRoom`.`animal_relation_id` = `Anim_Rel`.`id` AND `Anim_Rel`.`common_name` LIKE '%') LEFT JOIN `animal_relations` AS `AnimalRelation` ON (`AnimalsRoom`.`animal_relation_id` = `AnimalRelation`.`id`) LEFT JOIN `rooms` AS `Room` ON (`AnimalsRoom`.`room_id` = `Room`.`id`) WHERE 1 = 1 111
9SELECT `AnimalsRoom`.`id`, `AnimalsRoom`.`animal_id`, `AnimalsRoom`.`animal_type`, `AnimalsRoom`.`animal_relation_id`, `AnimalsRoom`.`room_id`, `AnimalsRoom`.`start_date`, `AnimalsRoom`.`end_date`, `AnimalsRoom`.`priority`, `AnimalRelation`.`common_name`, `Room`.`name`, `AnimalRelation`.`id`, `Room`.`id` FROM `animals_rooms` AS `AnimalsRoom` inner JOIN animal_relations AS `Anim_Rel` ON (`AnimalsRoom`.`animal_relation_id` = `Anim_Rel`.`id` AND `Anim_Rel`.`common_name` LIKE '%') LEFT JOIN `animal_relations` AS `AnimalRelation` ON (`AnimalsRoom`.`animal_relation_id` = `AnimalRelation`.`id`) LEFT JOIN `rooms` AS `Room` ON (`AnimalsRoom`.`room_id` = `Room`.`id`) WHERE 1 = 1 ORDER BY `AnimalsRoom`.`end_date` asc LIMIT 1010100