home

AnimalsRooms

Page 4 of 5, showing 20 records out of 82 total, starting on record 61, ending on 80

Id Animal Animal Type Animal Relation Room Start Date End Date
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
63 1 Barnyards 1 Lobby Aug 30th 2011, 19:34 Aug 30th 2011, 19:34
64 1 Barnyards 1 Main Hall Aug 30th 2011, 19:34 Aug 30th 2011, 19:34
65 2 Barnyards 2 North Wing Aug 30th 2011, 21:27 Aug 30th 2011, 21:27
66 1 Barnyards 1 Lobby Aug 30th 2011, 22:30 Aug 30th 2011, 22:30
67 2 Barnyards 2 Main Hall Oct 5th 2011, 04:38 Oct 5th 2011, 04:38
68 1 Barnyards 1 Lobby Nov 13th 2011, 12:26 Nov 13th 2011, 12:26
69 1 Barnyards 1 Lobby Dec 15th 2011, 02:11 Dec 15th 2011, 02:11
70 2 Barnyards 2 Main Hall Jan 9th 2023, 02:06 Oct 19th 2025, 06:10
71 10 Barnyards 10 Main Hall Jan 18th, 17:59 Jan 18th, 17:59
72 2 Barnyards 2 Main Hall Jan 18th, 17:59 Jan 18th, 17:59
73 12 Barnyards 12 Lobby Jan 18th, 18:00 Jan 18th, 18:00
74 1 Barnyards 1 Lobby Feb 27th, 03:54 Feb 27th, 03:54
75 1 Barnyards 1 Lobby Feb 27th, 03:55 Feb 27th, 03:55
76 2 Barnyards 2 North Wing Nov 2nd, 04:04 May 2nd, 04:04
77 2 Barnyards 2 Lobby May 16th, 08:24 May 16th, 08:24
78 4 Barnyards 4 Lobby May 16th, 08:56 May 16th, 08:56
79 3 Barnyards 3 Lobby May 16th, 08:56 May 16th, 08:56
80 4 Barnyards 4 Lobby May 16th, 08:59 May 16th, 08:59
<< previous | 1 | 2 | 3 | 4 | 5 next >>
(default) 8 queries took 17 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `animals_rooms`10103
2DESCRIBE `animal_relations`662
3DESCRIBE `rooms`221
4DESCRIBE `barnyards`551
5DESCRIBE `jungles`551
6DESCRIBE `sea_creatures`555
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 60, 2020203