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
41 1 Barnyards 1 Lobby Aug 10th 2010, 06:16 Aug 10th 2010, 06:16
29 1 Barnyards 1 Lobby Apr 8th 2010, 06:02 Apr 8th 2010, 06:02
28 1 Barnyards 1 Main Hall Apr 8th 2010, 06:01 Apr 8th 2010, 06:01
27 1 Barnyards 1 Lobby Mar 31st 2010, 20:47 Mar 31st 2010, 20:47
26 1 Barnyards 1 Lobby Mar 8th 2010, 06:21 Mar 8th 2010, 06:21
55 1 Barnyards 1 Lobby Apr 25th 2011, 14:07 Apr 25th 2011, 14:07
24 1 Barnyards 1 Lobby Feb 24th 2010, 13:56 Feb 24th 2010, 13:56
56 1 Barnyards 1 Lobby Apr 26th 2011, 16:58 Apr 26th 2011, 16:58
57 1 Barnyards 1 Lobby Jun 22nd 2011, 11:31 Jun 22nd 2011, 11:31
30 1 Barnyards 1 Lobby Apr 29th 2010, 13:04 Apr 29th 2010, 13:04
53 1 Barnyards 1 Lobby Jan 15th 2011, 15:08 Jan 15th 2011, 15:08
40 1 Barnyards 1 Lobby Aug 10th 2010, 06:02 Aug 10th 2010, 06:02
39 1 Barnyards 1 Lobby Jul 16th 2010, 08:10 Jul 16th 2010, 08:10
38 1 Barnyards 1 Lobby Jun 23rd 2010, 01:43 Jun 23rd 2010, 01:43
46 1 Barnyards 1 Lobby Sep 10th 2010, 07:34 Sep 10th 2010, 07:34
35 1 Barnyards 1 Lobby Jun 1st 2010, 08:54 Jun 1st 2010, 08:54
47 1 Barnyards 1 Lobby Sep 10th 2010, 21:02 Sep 10th 2010, 21:02
43 1 Barnyards 1 Lobby Aug 17th 2010, 10:12 Aug 17th 2010, 10:12
32 1 Barnyards 1 Lobby May 17th 2010, 17:27 May 17th 2010, 17:27
59 1 Barnyards 1 Lobby Jun 23rd 2011, 00:24 Jun 23rd 2011, 00:24
<< previous
| 1 | 2 | 3 | 4 | 5 next >>
(default) 8 queries took 28 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `animals_rooms`10101
2DESCRIBE `animal_relations`661
3DESCRIBE `rooms`220
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 118
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_id` asc LIMIT 20202015