home

AnimalsRooms

Page 1 of 4, showing 20 records out of 73 total, starting on record 1, ending on 20

Id Animal Animal Type Animal Relation Room Start Date End Date
1 9 Barnyards 9 Main Hall Dec 10th 2009, 08:41 Dec 10th 2009, 08:41
2 2 Barnyards 2 Main Hall Dec 12th 2009, 09:41 Jan 10th 2010, 09:41
3 8 Jungles 20 Lobby Jan 10th 2009, 09:43 Feb 12th 2009, 09:43
4 8 SeaCreatures 32 West Wing Dec 11th 2009, 18:47 Dec 11th 2009, 18:47
5 10 SeaCreatures 34 East Wing Dec 14th 2009, 09:09 May 14th 2009, 09:09
6 6 Jungles 18 Lobby Feb 14th 2009, 09:10 Nov 14th 2010, 09:10
7 6 SeaCreatures 30 Lobby Jan 20th 2009, 15:23 Aug 20th 2009, 15:23
8 3 Jungles 15 South Wing Feb 27th 2009, 15:23 Apr 27th 2009, 15:23
9 9 Barnyards 9 Lobby Dec 27th 2009, 15:24 Apr 27th 2009, 15:24
10 7 Barnyards 7 South Wing Dec 27th 2009, 15:24 Feb 16th 2009, 15:24
11 12 Barnyards 12 South Wing Dec 27th 2009, 15:24 May 10th 2009, 15:24
12 10 Jungles 22 West Wing Dec 27th 2009, 15:25 Jun 5th 2009, 15:25
13 12 Jungles 24 East Wing Dec 27th 2009, 15:25 Mar 15th 2009, 15:25
14 5 Jungles 17 Lobby Dec 27th 2009, 15:25 Jan 10th 2009, 15:25
15 5 SeaCreatures 29 Lobby Dec 27th 2009, 15:54 Mar 2nd 2009, 15:54
16 8 SeaCreatures 32 West Wing Jan 29th 2010, 09:28 Nov 29th 2010, 09:28
17 1 Barnyards 1 Lobby Dec 29th 2009, 11:08 Dec 29th 2009, 11:08
18 1 Barnyards 1 Main Hall Jan 22nd 2010, 08:01 Jan 22nd 2010, 08:01
19 2 Barnyards 2 Lobby Jan 26th 2010, 02:59 Jan 26th 2010, 02:59
20 1 Barnyards 1 Lobby Feb 9th 2010, 17:19 Feb 9th 2010, 17:19
<< previous
| 1 | 2 | 3 | 4 next >>
(default) 8 queries took 28 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `animals_rooms`10101
2DESCRIBE `animal_relations`661
3DESCRIBE `rooms`220
4DESCRIBE `barnyards`550
5DESCRIBE `jungles`550
6DESCRIBE `sea_creatures`550
7SELECT COUNT(*) AS `count` FROM `animals_rooms` AS `AnimalsRoom` LEFT JOIN `animal_relations` AS `AnimalRelation` ON (`AnimalsRoom`.`animal_relation_id` = `AnimalRelation`.`id`) LEFT JOIN `rooms` AS `Room` ON (`AnimalsRoom`.`room_id` = `Room`.`id`) LEFT JOIN `barnyards` AS `Barnyard` ON (`AnimalsRoom`.`animal_id` = `Barnyard`.`id`) LEFT JOIN `jungles` AS `Jungle` ON (`AnimalsRoom`.`animal_id` = `Jungle`.`id`) LEFT JOIN `sea_creatures` AS `SeaCreature` ON (`AnimalsRoom`.`animal_id` = `SeaCreature`.`id`) WHERE 1 = 1 111
8SELECT `AnimalsRoom`.`id`, `AnimalsRoom`.`animal_id`, `AnimalsRoom`.`animal_type`, `AnimalsRoom`.`animal_relation_id`, `AnimalsRoom`.`room_id`, `AnimalsRoom`.`start_date`, `AnimalsRoom`.`end_date`, `AnimalsRoom`.`priority`, `AnimalsRoom`.`created`, `AnimalsRoom`.`modified`, `AnimalRelation`.`id`, `AnimalRelation`.`animal_id`, `AnimalRelation`.`animal_type`, `AnimalRelation`.`common_name`, `AnimalRelation`.`created`, `AnimalRelation`.`modified`, `Room`.`id`, `Room`.`name`, `Barnyard`.`id`, `Barnyard`.`common_name`, `Barnyard`.`scientific_name`, `Barnyard`.`created`, `Barnyard`.`modified`, `Jungle`.`id`, `Jungle`.`common_name`, `Jungle`.`scientific_name`, `Jungle`.`created`, `Jungle`.`modified`, `SeaCreature`.`id`, `SeaCreature`.`common_name`, `SeaCreature`.`scientific_name`, `SeaCreature`.`created`, `SeaCreature`.`modified` FROM `animals_rooms` AS `AnimalsRoom` LEFT JOIN `animal_relations` AS `AnimalRelation` ON (`AnimalsRoom`.`animal_relation_id` = `AnimalRelation`.`id`) LEFT JOIN `rooms` AS `Room` ON (`AnimalsRoom`.`room_id` = `Room`.`id`) LEFT JOIN `barnyards` AS `Barnyard` ON (`AnimalsRoom`.`animal_id` = `Barnyard`.`id`) LEFT JOIN `jungles` AS `Jungle` ON (`AnimalsRoom`.`animal_id` = `Jungle`.`id`) LEFT JOIN `sea_creatures` AS `SeaCreature` ON (`AnimalsRoom`.`animal_id` = `SeaCreature`.`id`) WHERE 1 = 1 LIMIT 20202025