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
80 4 Barnyards 4 Lobby May 16th, 08:59 May 16th, 08:59
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
50 2 Barnyards 2 Lobby Oct 6th 2010, 16:35 Oct 6th 2010, 16:35
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
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
41 1 Barnyards 1 Lobby Aug 10th 2010, 06:16 Aug 10th 2010, 06:16
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
36 11 Jungles 23 Lobby Jun 2nd 2010, 02:54 Jun 2nd 2010, 02:54
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
58 7 Barnyards 7 Lobby Jun 22nd 2011, 11:56 Jun 22nd 2011, 11:56
79 3 Barnyards 3 Lobby May 16th, 08:56 May 16th, 08:56
78 4 Barnyards 4 Lobby May 16th, 08:56 May 16th, 08:56
77 2 Barnyards 2 Lobby May 16th, 08:24 May 16th, 08:24
<< 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`.`room_id` asc LIMIT 2020201