home

AnimalsRooms

Page 1 of 5, showing 20 records out of 82 total, starting on record 1, ending on 20

Id Animal Animal Type Animal Relation Room Start Date End Date
82 5 Barnyards 5 Lobby May 16th, 09:04 May 16th, 09:04
60 1 Barnyards 1 Lobby Jun 23rd 2011, 00:47 Jun 23rd 2011, 00:47
59 1 Barnyards 1 Lobby Jun 23rd 2011, 00:24 Jun 23rd 2011, 00:24
58 7 Barnyards 7 Lobby Jun 22nd 2011, 11:56 Jun 22nd 2011, 11:56
57 1 Barnyards 1 Lobby Jun 22nd 2011, 11:31 Jun 22nd 2011, 11:31
56 1 Barnyards 1 Lobby Apr 26th 2011, 16:58 Apr 26th 2011, 16:58
55 1 Barnyards 1 Lobby Apr 25th 2011, 14:07 Apr 25th 2011, 14:07
53 1 Barnyards 1 Lobby Jan 15th 2011, 15:08 Jan 15th 2011, 15:08
52 3 Barnyards 3 North Wing Nov 23rd 2010, 13:15 Nov 23rd 2010, 13:15
50 2 Barnyards 2 Lobby Oct 6th 2010, 16:35 Oct 6th 2010, 16:35
49 7 Barnyards 7 East Wing Oct 4th 2010, 16:10 Oct 4th 2010, 18:02
48 3 Barnyards 3 North Wing Sep 15th 2010, 21:28 Sep 15th 2010, 21:28
47 1 Barnyards 1 Lobby Sep 10th 2010, 21:02 Sep 10th 2010, 21:02
46 1 Barnyards 1 Lobby Sep 10th 2010, 07:34 Sep 10th 2010, 07:34
45 2 Barnyards 2 Main Hall Sep 7th 2010, 14:28 Sep 7th 2010, 14:28
44 2 Barnyards 2 Lobby Aug 24th 2010, 13:03 Aug 24th 2010, 13:03
43 1 Barnyards 1 Lobby Aug 17th 2010, 10:12 Aug 17th 2010, 10:12
42 1 Barnyards 1 Lobby Aug 17th 2010, 10:04 Aug 17th 2010, 10:04
61 3 Barnyards 3 North Wing Jun 23rd 2011, 01:35 Jun 23rd 2011, 01:35
62 1 Barnyards 1 Lobby Jun 23rd 2011, 09:54 Jun 23rd 2011, 09:54
<< previous
| 1 | 2 | 3 | 4 | 5 next >>
(default) 8 queries took 8 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `animals_rooms`10101
2DESCRIBE `animal_relations`661
3DESCRIBE `rooms`221
4DESCRIBE `barnyards`551
5DESCRIBE `jungles`551
6DESCRIBE `sea_creatures`551
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 ORDER BY `AnimalsRoom`.`animal_type` asc LIMIT 2020201