ANIMAL IN SHELTER UPDATER (NON-ADOPTABLE):
Total animals in shelter: 106
# | Name | Animal ID | Coming Soon | Featured | Shelter Location | Display Location | Last Change Date |
1 | Amelia | 14114 | 0 | 0 | Quarantine 1 | Foster | 2023-09-08 21:28:50.780218 |
2 | Astillada | 14181 | 0 | 0 | Adoption Floor | Adoption Floor | 2023-09-25 12:52:31.771070 |
3 | Bam Bam | 14266 | 0 | 0 | Adoption Floor | Adoption Floor | 2023-09-24 12:12:37.047000 |
4 | Béchamel | 14284 | 0 | 0 | Bullpen | Bullpen | 2023-09-25 13:49:01.438386 |
5 | Bedelia | 13805 | 0 | 0 | Quarantine 1 | Foster | 2023-09-19 13:47:47.673123 |
6 | Bernaise | 14286 | 0 | 0 | Bullpen | Bullpen | 2023-09-25 13:51:08.145284 |
7 | Big Mac | 14281 | 0 | 0 | Quarantine 1 | Quarantine 1 | 2023-09-25 11:02:10.251038 |
8 | Billie | 10632 | 0 | 0 | Foster | Permanent Foster | 2023-01-31 14:19:06.476113 |
9 | Brandi | 12768 | 0 | 0 | Bullpen | Permanent Foster | 2023-07-06 11:09:42 |
10 | Bratwurst Pinkerton III | 14252 | 0 | 0 | Adoption Floor | Adoption Floor | 2023-09-23 11:05:23.277420 |
11 | Cadbury | 11210 | 0 | 0 | Quarantine 1 | Quarantine 1 | 2023-09-20 10:18:34.153973 |
12 | Cantlay | 14271 | 0 | 0 | Office Locations | Foster | 2023-09-19 19:57:07 |
13 | Cascade | 14235 | 0 | 0 | Quarantine 1 | Quarantine 1 | 2023-09-19 19:58:20 |
14 | Charlee | 13924 | 0 | 0 | Permanent Resident - Office | Permanent Resident - Office | 2023-09-05 07:12:10.116625 |
15 | Cheech | 14231 | 0 | 0 | Adoption Floor | Adoption Floor | 2023-09-25 12:50:59.606895 |
16 | Cheeko | 14184 | 0 | 0 | Quarantine 1 | Foster | 2023-08-31 09:40:21.251665 |
17 | Cheesecloth | 13567 | 0 | 0 | Permanent Resident - Office | Permanent Resident - Office | 2023-08-14 07:37:16.554914 |
18 | Chikfila | 14147 | 0 | 0 | Quarantine 1 | Quarantine 1 | 2023-09-25 11:01:31.130158 |
19 | Chocolate Milk | 14146 | 0 | 0 | Quarantine 1 | Quarantine 1 | 2023-09-16 13:11:44.643829 |
20 | Cleetus | 14253 | 0 | 0 | Quarantine 1 | Quarantine 1 | 2023-09-20 07:20:04.775599 |
21 | Coca Cola | 14280 | 0 | 0 | Foster | Foster | 2023-09-22 17:16:22.044958 |
22 | Copper coin | 14251 | 0 | 0 | Shelter | Foster | 2023-09-19 19:57:07 |
23 | Country Club | 13941 | 0 | 0 | Foster | Foster | 2023-09-24 08:12:59.433937 |
24 | Crescent Moon | 14171 | 0 | 0 | Adoption Floor | Adoption Floor | 2023-09-25 07:55:56.218683 |
25 | Crocs | 14105 | 0 | 0 | Foster | Foster | 2023-08-15 05:51:16.100400 |
26 | Crunch | 14259 | 0 | 0 | Adoption Floor | Adoption Floor | 2023-09-23 13:17:02.883774 |
27 | Daphnis | 14119 | 0 | 0 | Purr Cup Cafe | Purr Cup Cafe | 2023-09-01 12:13:32.718521 |
28 | Desiree | 3969 | 0 | 0 | Bullpen | Foster | 2023-07-06 11:09:42 |
29 | Dexter | 10332 | 0 | 0 | Hospice | Permanent Foster | 2023-02-13 12:15:42.165203 |
30 | Dil Pickles | 12694 | 0 | 0 | Adoption Floor | Adoption Floor | 2023-09-19 11:13:15.700148 |
31 | Dinglehopper | 14229 | 0 | 0 | Adoption Floor | Adoption Floor | 2023-09-17 12:20:28.714126 |
32 | Doctor Pepper | 14277 | 0 | 0 | Foster | Foster | 2023-09-22 17:13:59.892963 |
33 | Donnelly | 14236 | 0 | 0 | Quarantine 1 | Quarantine 1 | 2023-09-19 19:57:07 |
34 | Espagnole | 14287 | 0 | 0 | Bullpen | Bullpen | 2023-09-25 13:52:09.748692 |
35 | Eunice | 14158 | 0 | 0 | Quarantine 1 | Foster | 2023-08-23 13:19:29.841647 |
36 | Evelyn | 13980 | 0 | 0 | Adoption Floor | Foster | 2023-07-16 11:33:34.097750 |
37 | Franzia | 14269 | 0 | 0 | Adoption Floor | Adoption Floor | 2023-09-24 11:58:56.560483 |
38 | Gahan | 13616 | 0 | 0 | Imaginary Cats - TRAINING PURPOSES ONLY | Imaginary Cats - TRAINING PURPOSES ONLY | 2023-09-15 16:51:24.167493 |
39 | Gelatin | 14207 | 0 | 0 | Quarantine 1 | Quarantine 1 | 2023-09-25 11:02:30.511660 |
40 | Ginger Ale | 14274 | 0 | 0 | Foster | Foster | 2023-09-25 13:29:17.428184 |
41 | Glow Stick | 14258 | 0 | 0 | Adoption Floor | Adoption Floor | 2023-09-25 12:52:03.615492 |
42 | Jade Vine | 14263 | 0 | 0 | Adoption Floor | Adoption Floor | 2023-09-23 18:29:54.225800 |
43 | Jello | 14206 | 0 | 0 | Adoption Floor | Foster | 2023-09-20 11:00:52.357920 |
44 | Joe DiMeowgio | 14198 | 0 | 0 | Adoption Floor | Adoption Floor | 2023-09-25 14:06:56.740263 |
45 | Kazoo | 14267 | 0 | 0 | Adoption Floor | Adoption Floor | 2023-09-24 12:28:09.420396 |
46 | Kia | 8484 | 0 | 0 | Bullpen | Permanent Foster | 2023-07-06 11:10:05.011288 |
47 | Koepka | 14273 | 0 | 0 | Office Locations | Foster | 2023-09-19 19:57:07 |
48 | Kooskia | 14239 | 0 | 0 | Quarantine 1 | Quarantine 1 | 2023-09-19 19:57:07 |
49 | Kumquat | 13879 | 0 | 0 | Foster | Foster | 2023-09-13 11:49:59.519778 |
50 | Kylo | 14076 | 0 | 0 | Purr Cup Cafe | Purr Cup Cafe | 2023-08-29 07:31:29.695546 |
51 | Lenni | 13384 | 0 | 0 | Quarantine 1 | Quarantine 1 | 2023-09-14 12:49:27.763553 |
52 | Lil' Guy | 14260 | 0 | 0 | Adoption Floor | Adoption Floor | 2023-09-24 10:40:44.360498 |
53 | Lil Missy | 14098 | 0 | 0 | Adoption Floor | Foster | 2023-09-21 09:44:49.440605 |
54 | Maeby | 14130 | 0 | 0 | Foster | Foster | 2023-09-21 12:48:30.436313 |
55 | Mama Sauce | 14282 | 0 | 0 | Quarantine 1 | Quarantine 1 | 2023-09-25 13:33:07.304127 |
56 | Maple Sugar | 13779 | 0 | 0 | Purr Cup Cafe | Purr Cup Cafe | 2023-08-17 13:55:11.153401 |
57 | Marlin | 14216 | 0 | 0 | Quarantine 2 | Quarantine 2 | 2023-09-21 11:25:25.444508 |
58 | McCall | 14238 | 0 | 0 | Quarantine 1 | Quarantine 1 | 2023-09-19 19:57:07 |
59 | Miss Doubtfire | 14031 | 0 | 0 | Adoption Floor | Adoption Floor | 2023-09-10 13:43:43.012434 |
60 | Miss Gladys | 14156 | 0 | 0 | Adoption Floor | Foster | 2023-08-27 12:30:09.472049 |
61 | Misty | 14265 | 0 | 0 | Adoption Floor | Adoption Floor | 2023-09-24 11:55:28.655271 |
62 | Moena | 13001 | 0 | 0 | Quarantine 1 | Quarantine 1 | 2023-09-12 11:56:23.199074 |
63 | Moogie | 14224 | 0 | 0 | Adoption Floor | Adoption Floor | 2023-09-25 12:50:29.027714 |
64 | Moonlight | 14110 | 0 | 0 | Adoption Floor | Adoption Floor | 2023-09-21 20:08:53.255646 |
65 | Morikawa | 14270 | 0 | 0 | Office Locations | Foster | 2023-09-19 19:57:38 |
66 | Morlo | 14136 | 0 | 0 | Adoption Floor | Foster | 2023-09-04 23:53:13.964187 |
67 | Morrigan | 8585 | 0 | 0 | Hospice | Permanent Foster | 2023-07-06 11:12:16.499000 |
68 | Moth | 14199 | 0 | 0 | Bullpen | Bullpen | 2023-09-19 19:57:07 |
69 | Mountain Dew | 14275 | 0 | 0 | Foster | Foster | 2023-09-22 17:07:01.282022 |
70 | Mousse | 14209 | 0 | 0 | Quarantine 1 | Quarantine 1 | 2023-09-25 11:03:03.449762 |
71 | Neon | 14257 | 0 | 0 | Adoption Floor | Adoption Floor | 2023-09-25 12:51:28.899437 |
72 | Opie | 14247 | 0 | 0 | Adoption Floor | Adoption Floor | 2023-09-25 14:33:01.396552 |
73 | Pasta Salad | 14243 | 0 | 0 | Adoption Floor | Adoption Floor | 2023-09-22 14:41:10.872337 |
74 | Payette | 14241 | 0 | 0 | Quarantine 1 | Quarantine 1 | 2023-09-19 19:57:07 |
75 | Peppermint | 14125 | 0 | 0 | Purr Cup Cafe | Purr Cup Cafe | 2023-08-29 14:47:47.141055 |
76 | Pepsi Cola | 14278 | 0 | 0 | Foster | Foster | 2023-09-22 17:14:53.845915 |
77 | Pocatello | 14240 | 0 | 0 | Quarantine 1 | Quarantine 1 | 2023-09-19 19:57:07 |
78 | Popeyes | 14149 | 0 | 0 | Quarantine 1 | Quarantine 1 | 2023-09-25 11:03:19.691323 |
79 | Possum | 14227 | 0 | 0 | Quarantine 2 | Quarantine 2 | 2023-09-19 19:57:07 |
80 | Pound Cake | 14208 | 0 | 0 | Adoption Floor | Foster | 2023-09-20 11:01:14.676455 |
81 | Root Beer | 14279 | 0 | 0 | Foster | Foster | 2023-09-22 17:15:38.774705 |
82 | Rosalina | 13719 | 0 | 0 | Foster | Foster | 2023-07-28 10:18:38.357463 |
83 | Rosegold | 14248 | 0 | 0 | Shelter | Foster | 2023-09-19 19:57:07 |
84 | Salum | 13865 | 0 | 0 | Adoption Floor | Permanent Foster | 2023-08-10 10:55:10.508399 |
85 | Sandpoint | 14237 | 0 | 0 | Quarantine 1 | Quarantine 1 | 2023-09-19 19:57:07 |
86 | Silver | 14250 | 0 | 0 | Shelter | Foster | 2023-09-19 19:57:07 |
87 | Skittle | 14246 | 0 | 0 | Quarantine 1 | Quarantine 1 | 2023-09-19 19:58:20 |
88 | Skooter | 14196 | 0 | 0 | Adoption Floor | Adoption Floor | 2023-09-24 12:17:52.222507 |
89 | Speith | 14272 | 0 | 0 | Office Locations | Foster | 2023-09-19 19:57:07 |
90 | Spork | 14176 | 0 | 0 | Quarantine 1 | Foster | 2023-08-30 10:15:11.541268 |
91 | Sprite | 14276 | 0 | 0 | Foster | Foster | 2023-09-22 17:13:05.131409 |
92 | Spunky | 14254 | 0 | 0 | Quarantine 1 | Quarantine 1 | 2023-09-20 07:17:05.698951 |
93 | Stormie | 14223 | 0 | 0 | Adoption Floor | Foster | 2023-09-17 13:04:52.696748 |
94 | Supernova | 14111 | 0 | 0 | Adoption Floor | Adoption Floor | 2023-09-25 13:06:55.786240 |
95 | Talmadge | 7585 | 0 | 0 | Hospice | Permanent Foster | 2023-07-06 11:12:30.764168 |
96 | Thomathy | 14212 | 0 | 0 | Quarantine 1 | Foster | 2023-09-19 12:50:53.009620 |
97 | Tobie | 7587 | 0 | 0 | Adoption Floor | Adoption Floor | 2023-08-14 11:15:56.174271 |
98 | Toby | 5683 | 0 | 0 | Adoption Floor | Permanent Foster | 2023-07-25 13:50:12.506426 |
99 | Tomato Sauce | 14285 | 0 | 0 | Bullpen | Bullpen | 2023-09-25 13:50:06.562091 |
100 | Training Cat 1 | 14049 | 0 | 0 | Imaginary Cats - TRAINING PURPOSES ONLY | Imaginary Cats - TRAINING PURPOSES ONLY | 2023-09-15 16:51:53.618992 |
101 | Velouté | 14283 | 0 | 0 | Bullpen | Bullpen | 2023-09-25 13:40:55.004439 |
102 | White gold | 14249 | 0 | 0 | Shelter | Foster | 2023-09-19 19:57:07 |
103 | Woozel | 14264 | 0 | 0 | Quarantine 1 | Quarantine 1 | 2023-09-25 13:26:35.657517 |
104 | Zanna | 7040 | 0 | 0 | Foster | Permanent Foster | 2023-09-19 14:48:27.351922 |
105 | Zaxbys | 14145 | 0 | 0 | Quarantine 1 | Quarantine 1 | 2023-09-25 11:02:45.039246 |
106 | Zoogie | 14226 | 0 | 0 | Adoption Floor | Adoption Floor | 2023-09-25 12:49:55.837034 |
ANIMAL DETAILS FROM DB:
Row ID: 5746
Name: Amelia
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 5813
Name: Astillada
Adoptable: 1
Animal adoptable, IGNORE
ANIMAL DETAILS FROM DB:
Row ID: 5897
Name: Bam Bam
Adoptable: 1
Animal adoptable, IGNORE
ANIMAL DETAILS FROM DB:
Row ID: 0
Name:
Adoptable: 0
Change date changed
Old Date Last Changed:
New Date Last Changed: 2023-09-25 13:49:01.438386
Website Media date changed
Old Date Website Media Changed:
New Date Website Media Changed: null
ANIMAL DETAILS FROM SM:
Animal Name: Béchamel
Animal ID: 14284
Adoptable:
In Shelter:
Recently Adopted:
Coming Soon: 0
Featured on Home Page: 0
Shelter Location: Bullpen
Display Location: Bullpen
Age: 10 weeks.
Age Group: Kitten
Altered: No
Shelter Code: C20237170
Shelter Short Code: 7170C
Breed: Domestic Medium Hair
Coat Type: Short
Base Color: Torbie
Gender: Female
Good with Cats? Unknown
Good wity Dogs? Unknown
Good with Kids? Unknown
Declawed: No
Comments:
Entry Category: Transfer from Municipal Shelter
Entry Description: Transfer from Municipal Shelter
Time on Shelter: 0 days.
Total Time on Shelter: 0 days.
Days in Shelter: 0
Total Days in Shelter: 0
Last Change Date: 2023-09-25 13:49:01.438386
Website Media Date: null
Doc Media Date: null
Adopt Date:
Date of Birth: 2023-07-17 00:00:00
Date Brought In: 2023-09-25 00:00:00
Created Date: 2023-09-25 13:46:54.591427
Most Recent Entry Date: 2023-09-25 00:00:00
Combi Test Date: 2023-09-25 00:00:00
Identi Chip Date: null
Neutered Date: null
Adopt Movement Date:
Adopt Created Date:
Animal Type/Return Reason: C (County Shelter Cat)
Animal Size: Medium
Has Special Needs? No
Special Needs Behavior: 0
Special Needs Meds: 0
Weight: 1.32
Adoption Fee: 0
Images Available: 0
UPDATE ANIMAL TABLE:
Query result: SUCCESS
INSERT into cats (animal_id, adopt_id, animal_name, adoptable, in_shelter, recently_adopted, coming_soon, featured_home, adoption_fee, age, age_group, altered, shelter_code, shelter_short_code, breed, coat_type, base_color, declawed, comments, entry_category, entry_description, gender, good_w_cats, good_w_dogs, good_w_kids, shelter_location, display_location, animal_type, animal_size, has_special_needs, special_needs_behavior, special_needs_meds, weight, time_on_shelter, time_total_on_shelter, days_on_shelter, days_total_on_shelter, date_brought_in, date_most_recent_entry, date_of_birth, date_created, date_adopt_movement, date_adopt_created, date_adopt_last_changed, date_combi_test, date_identi_chip, date_neutered, date_doc_media, date_website_media, date_last_changed, image_count ) VALUES ('14284','0','Béchamel','0','1','0','0','0','0','10 weeks.','Kitten','No','C20237170','7170C','Domestic Medium Hair','Short','Torbie','No','','Transfer from Municipal Shelter','Transfer from Municipal Shelter','Female','Unknown','Unknown','Unknown','Bullpen','Bullpen','C (County Shelter Cat)','Medium','No','0','0','1.32','0 days.','0 days.','0','0','2023-09-25 00:00:00','2023-09-25 00:00:00','2023-07-17 00:00:00','2023-09-25 13:46:54.591427','','','','2023-09-25 00:00:00','null','null','null','null','2023-09-25 13:49:01.438386','0');
NO IMAGES TO DOWNLOAD:
UPDATE HISTORY
Query result: SUCCESS
INSERT into update_history (animal_id, animal_name, old_date_last_changed, new_date_last_changed, date_changed, old_date_adopt, new_date_adopt, adopt_date_changed, old_date_website_media, new_date_website_media, website_media_changed, action ) VALUES ('14284','Béchamel','','2023-09-25 13:49:01.438386','1','','','0','','null','1','SHELTER-INSERT');
ANIMAL DETAILS FROM DB:
Row ID: 5431
Name: Bedelia
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 0
Name:
Adoptable: 0
Change date changed
Old Date Last Changed:
New Date Last Changed: 2023-09-25 13:51:08.145284
Website Media date changed
Old Date Website Media Changed:
New Date Website Media Changed: null
ANIMAL DETAILS FROM SM:
Animal Name: Bernaise
Animal ID: 14286
Adoptable:
In Shelter:
Recently Adopted:
Coming Soon: 0
Featured on Home Page: 0
Shelter Location: Bullpen
Display Location: Bullpen
Age: 10 weeks.
Age Group: Kitten
Altered: No
Shelter Code: C20237172
Shelter Short Code: 7172C
Breed: Domestic Medium Hair
Coat Type: Short
Base Color: Brown Tabby
Gender: Female
Good with Cats? Unknown
Good wity Dogs? Unknown
Good with Kids? Unknown
Declawed: No
Comments:
Entry Category: Transfer from Municipal Shelter
Entry Description: Transfer from Municipal Shelter
Time on Shelter: 0 days.
Total Time on Shelter: 0 days.
Days in Shelter: 0
Total Days in Shelter: 0
Last Change Date: 2023-09-25 13:51:08.145284
Website Media Date: null
Doc Media Date: null
Adopt Date:
Date of Birth: 2023-07-17 00:00:00
Date Brought In: 2023-09-25 00:00:00
Created Date: 2023-09-25 13:47:12.816569
Most Recent Entry Date: 2023-09-25 00:00:00
Combi Test Date: 2023-09-25 00:00:00
Identi Chip Date: null
Neutered Date: null
Adopt Movement Date:
Adopt Created Date:
Animal Type/Return Reason: C (County Shelter Cat)
Animal Size: Medium
Has Special Needs? No
Special Needs Behavior: 0
Special Needs Meds: 0
Weight: 1.24
Adoption Fee: 0
Images Available: 0
UPDATE ANIMAL TABLE:
Query result: SUCCESS
INSERT into cats (animal_id, adopt_id, animal_name, adoptable, in_shelter, recently_adopted, coming_soon, featured_home, adoption_fee, age, age_group, altered, shelter_code, shelter_short_code, breed, coat_type, base_color, declawed, comments, entry_category, entry_description, gender, good_w_cats, good_w_dogs, good_w_kids, shelter_location, display_location, animal_type, animal_size, has_special_needs, special_needs_behavior, special_needs_meds, weight, time_on_shelter, time_total_on_shelter, days_on_shelter, days_total_on_shelter, date_brought_in, date_most_recent_entry, date_of_birth, date_created, date_adopt_movement, date_adopt_created, date_adopt_last_changed, date_combi_test, date_identi_chip, date_neutered, date_doc_media, date_website_media, date_last_changed, image_count ) VALUES ('14286','0','Bernaise','0','1','0','0','0','0','10 weeks.','Kitten','No','C20237172','7172C','Domestic Medium Hair','Short','Brown Tabby','No','','Transfer from Municipal Shelter','Transfer from Municipal Shelter','Female','Unknown','Unknown','Unknown','Bullpen','Bullpen','C (County Shelter Cat)','Medium','No','0','0','1.24','0 days.','0 days.','0','0','2023-09-25 00:00:00','2023-09-25 00:00:00','2023-07-17 00:00:00','2023-09-25 13:47:12.816569','','','','2023-09-25 00:00:00','null','null','null','null','2023-09-25 13:51:08.145284','0');
NO IMAGES TO DOWNLOAD:
UPDATE HISTORY
Query result: SUCCESS
INSERT into update_history (animal_id, animal_name, old_date_last_changed, new_date_last_changed, date_changed, old_date_adopt, new_date_adopt, adopt_date_changed, old_date_website_media, new_date_website_media, website_media_changed, action ) VALUES ('14286','Bernaise','','2023-09-25 13:51:08.145284','1','','','0','','null','1','SHELTER-INSERT');
ANIMAL DETAILS FROM DB:
Row ID: 5913
Name: Big Mac
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 2344
Name: Billie
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 4442
Name: Brandi
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 5885
Name: Bratwurst Pinkerton III
Adoptable: 1
Animal adoptable, IGNORE
ANIMAL DETAILS FROM DB:
Row ID: 2924
Name: Cadbury
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 5902
Name: Cantlay
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 5861
Name: Cascade
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 5554
Name: Charlee
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 5862
Name: Cheech
Adoptable: 1
Animal adoptable, IGNORE
ANIMAL DETAILS FROM DB:
Row ID: 5816
Name: Cheeko
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 5195
Name: Cheesecloth
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 5776
Name: Chikfila
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 5777
Name: Chocolate Milk
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 5886
Name: Cleetus
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 5906
Name: Coca Cola
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 5880
Name: Copper coin
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 5576
Name: Country Club
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 5803
Name: Crescent Moon
Adoptable: 1
Animal adoptable, IGNORE
ANIMAL DETAILS FROM DB:
Row ID: 5739
Name: Crocs
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 5888
Name: Crunch
Adoptable: 1
Animal adoptable, IGNORE
ANIMAL DETAILS FROM DB:
Row ID: 5747
Name: Daphnis
Adoptable: 1
Animal adoptable, IGNORE
ANIMAL DETAILS FROM DB:
Row ID: 2445
Name: Desiree
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 2041
Name: Dexter
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 4369
Name: Dil Pickles
Adoptable: 1
Animal adoptable, IGNORE
ANIMAL DETAILS FROM DB:
Row ID: 5863
Name: Dinglehopper
Adoptable: 1
Animal adoptable, IGNORE
ANIMAL DETAILS FROM DB:
Row ID: 5907
Name: Doctor Pepper
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 5864
Name: Donnelly
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 0
Name:
Adoptable: 0
Change date changed
Old Date Last Changed:
New Date Last Changed: 2023-09-25 13:52:09.748692
Website Media date changed
Old Date Website Media Changed:
New Date Website Media Changed: null
ANIMAL DETAILS FROM SM:
Animal Name: Espagnole
Animal ID: 14287
Adoptable:
In Shelter:
Recently Adopted:
Coming Soon: 0
Featured on Home Page: 0
Shelter Location: Bullpen
Display Location: Bullpen
Age: 10 weeks.
Age Group: Kitten
Altered: No
Shelter Code: C20237173
Shelter Short Code: 7173C
Breed: Domestic Medium Hair
Coat Type: Short
Base Color: Black and White
Gender: Female
Good with Cats? Unknown
Good wity Dogs? Unknown
Good with Kids? Unknown
Declawed: No
Comments:
Entry Category: Transfer from Municipal Shelter
Entry Description: Transfer from Municipal Shelter
Time on Shelter: 0 days.
Total Time on Shelter: 0 days.
Days in Shelter: 0
Total Days in Shelter: 0
Last Change Date: 2023-09-25 13:52:09.748692
Website Media Date: null
Doc Media Date: null
Adopt Date:
Date of Birth: 2023-07-17 00:00:00
Date Brought In: 2023-09-25 00:00:00
Created Date: 2023-09-25 13:47:16.399755
Most Recent Entry Date: 2023-09-25 00:00:00
Combi Test Date: 2023-09-25 00:00:00
Identi Chip Date: null
Neutered Date: null
Adopt Movement Date:
Adopt Created Date:
Animal Type/Return Reason: C (County Shelter Cat)
Animal Size: Medium
Has Special Needs? No
Special Needs Behavior: 0
Special Needs Meds: 0
Weight: 1.14
Adoption Fee: 0
Images Available: 0
UPDATE ANIMAL TABLE:
Query result: SUCCESS
INSERT into cats (animal_id, adopt_id, animal_name, adoptable, in_shelter, recently_adopted, coming_soon, featured_home, adoption_fee, age, age_group, altered, shelter_code, shelter_short_code, breed, coat_type, base_color, declawed, comments, entry_category, entry_description, gender, good_w_cats, good_w_dogs, good_w_kids, shelter_location, display_location, animal_type, animal_size, has_special_needs, special_needs_behavior, special_needs_meds, weight, time_on_shelter, time_total_on_shelter, days_on_shelter, days_total_on_shelter, date_brought_in, date_most_recent_entry, date_of_birth, date_created, date_adopt_movement, date_adopt_created, date_adopt_last_changed, date_combi_test, date_identi_chip, date_neutered, date_doc_media, date_website_media, date_last_changed, image_count ) VALUES ('14287','0','Espagnole','0','1','0','0','0','0','10 weeks.','Kitten','No','C20237173','7173C','Domestic Medium Hair','Short','Black and White','No','','Transfer from Municipal Shelter','Transfer from Municipal Shelter','Female','Unknown','Unknown','Unknown','Bullpen','Bullpen','C (County Shelter Cat)','Medium','No','0','0','1.14','0 days.','0 days.','0','0','2023-09-25 00:00:00','2023-09-25 00:00:00','2023-07-17 00:00:00','2023-09-25 13:47:16.399755','','','','2023-09-25 00:00:00','null','null','null','null','2023-09-25 13:52:09.748692','0');
NO IMAGES TO DOWNLOAD:
UPDATE HISTORY
Query result: SUCCESS
INSERT into update_history (animal_id, animal_name, old_date_last_changed, new_date_last_changed, date_changed, old_date_adopt, new_date_adopt, adopt_date_changed, old_date_website_media, new_date_website_media, website_media_changed, action ) VALUES ('14287','Espagnole','','2023-09-25 13:52:09.748692','1','','','0','','null','1','SHELTER-INSERT');
ANIMAL DETAILS FROM DB:
Row ID: 5789
Name: Eunice
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 5614
Name: Evelyn
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 5898
Name: Franzia
Adoptable: 1
Animal adoptable, IGNORE
ANIMAL DETAILS FROM DB:
Row ID: 5245
Name: Gahan
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 5838
Name: Gelatin
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 5908
Name: Ginger Ale
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 5889
Name: Glow Stick
Adoptable: 1
Animal adoptable, IGNORE
ANIMAL DETAILS FROM DB:
Row ID: 5895
Name: Jade Vine
Adoptable: 1
Animal adoptable, IGNORE
ANIMAL DETAILS FROM DB:
Row ID: 5839
Name: Jello
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 5827
Name: Joe DiMeowgio
Adoptable: 1
Animal adoptable, IGNORE
ANIMAL DETAILS FROM DB:
Row ID: 5899
Name: Kazoo
Adoptable: 1
Animal adoptable, IGNORE
ANIMAL DETAILS FROM DB:
Row ID: 543
Name: Kia
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 5903
Name: Koepka
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 5865
Name: Kooskia
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 5519
Name: Kumquat
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 5714
Name: Kylo
Adoptable: 1
Animal adoptable, IGNORE
ANIMAL DETAILS FROM DB:
Row ID: 5017
Name: Lenni
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 5890
Name: Lil' Guy
Adoptable: 1
Animal adoptable, IGNORE
ANIMAL DETAILS FROM DB:
Row ID: 5737
Name: Lil Missy
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 5762
Name: Maeby
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 5914
Name: Mama Sauce
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 5413
Name: Maple Sugar
Adoptable: 1
Animal adoptable, IGNORE
ANIMAL DETAILS FROM DB:
Row ID: 5847
Name: Marlin
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 5866
Name: McCall
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 5666
Name: Miss Doubtfire
Adoptable: 1
Animal adoptable, IGNORE
ANIMAL DETAILS FROM DB:
Row ID: 5790
Name: Miss Gladys
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 5900
Name: Misty
Adoptable: 1
Animal adoptable, IGNORE
ANIMAL DETAILS FROM DB:
Row ID: 4679
Name: Moena
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 5855
Name: Moogie
Adoptable: 1
Animal adoptable, IGNORE
ANIMAL DETAILS FROM DB:
Row ID: 5740
Name: Moonlight
Adoptable: 1
Animal adoptable, IGNORE
ANIMAL DETAILS FROM DB:
Row ID: 5904
Name: Morikawa
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 5766
Name: Morlo
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 188
Name: Morrigan
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 5833
Name: Moth
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 5909
Name: Mountain Dew
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 5840
Name: Mousse
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 5892
Name: Neon
Adoptable: 1
Animal adoptable, IGNORE
ANIMAL DETAILS FROM DB:
Row ID: 5879
Name: Opie
Adoptable: 1
Animal adoptable, IGNORE
ANIMAL DETAILS FROM DB:
Row ID: 5876
Name: Pasta Salad
Adoptable: 1
Animal adoptable, IGNORE
ANIMAL DETAILS FROM DB:
Row ID: 5868
Name: Payette
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 5759
Name: Peppermint
Adoptable: 1
Animal adoptable, IGNORE
ANIMAL DETAILS FROM DB:
Row ID: 5910
Name: Pepsi Cola
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 5869
Name: Pocatello
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 5779
Name: Popeyes
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 5859
Name: Possum
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 5841
Name: Pound Cake
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 5911
Name: Root Beer
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 5351
Name: Rosalina
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 5881
Name: Rosegold
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 5502
Name: Salum
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 5871
Name: Sandpoint
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 5882
Name: Silver
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 5877
Name: Skittle
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 5830
Name: Skooter
Adoptable: 1
Animal adoptable, IGNORE
ANIMAL DETAILS FROM DB:
Row ID: 5905
Name: Speith
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 5808
Name: Spork
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 5912
Name: Sprite
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 5887
Name: Spunky
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 5857
Name: Stormie
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 5743
Name: Supernova
Adoptable: 1
Animal adoptable, IGNORE
ANIMAL DETAILS FROM DB:
Row ID: 586
Name: Talmadge
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 5844
Name: Thomathy
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 5374
Name: Tobie
Adoptable: 1
Animal adoptable, IGNORE
ANIMAL DETAILS FROM DB:
Row ID: 5462
Name: Toby
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 0
Name:
Adoptable: 0
Change date changed
Old Date Last Changed:
New Date Last Changed: 2023-09-25 13:50:06.562091
Website Media date changed
Old Date Website Media Changed:
New Date Website Media Changed: null
ANIMAL DETAILS FROM SM:
Animal Name: Tomato Sauce
Animal ID: 14285
Adoptable:
In Shelter:
Recently Adopted:
Coming Soon: 0
Featured on Home Page: 0
Shelter Location: Bullpen
Display Location: Bullpen
Age: 10 weeks.
Age Group: Kitten
Altered: No
Shelter Code: C20237171
Shelter Short Code: 7171C
Breed: Domestic Medium Hair
Coat Type: Short
Base Color: Brown Tabby and White
Gender: Male
Good with Cats? Unknown
Good wity Dogs? Unknown
Good with Kids? Unknown
Declawed: No
Comments:
Entry Category: Transfer from Municipal Shelter
Entry Description: Transfer from Municipal Shelter
Time on Shelter: 0 days.
Total Time on Shelter: 0 days.
Days in Shelter: 0
Total Days in Shelter: 0
Last Change Date: 2023-09-25 13:50:06.562091
Website Media Date: null
Doc Media Date: null
Adopt Date:
Date of Birth: 2023-07-17 00:00:00
Date Brought In: 2023-09-25 00:00:00
Created Date: 2023-09-25 13:47:09.476857
Most Recent Entry Date: 2023-09-25 00:00:00
Combi Test Date: 2023-09-25 00:00:00
Identi Chip Date: null
Neutered Date: null
Adopt Movement Date:
Adopt Created Date:
Animal Type/Return Reason: C (County Shelter Cat)
Animal Size: Medium
Has Special Needs? No
Special Needs Behavior: 0
Special Needs Meds: 0
Weight: 1.5
Adoption Fee: 0
Images Available: 0
UPDATE ANIMAL TABLE:
Query result: SUCCESS
INSERT into cats (animal_id, adopt_id, animal_name, adoptable, in_shelter, recently_adopted, coming_soon, featured_home, adoption_fee, age, age_group, altered, shelter_code, shelter_short_code, breed, coat_type, base_color, declawed, comments, entry_category, entry_description, gender, good_w_cats, good_w_dogs, good_w_kids, shelter_location, display_location, animal_type, animal_size, has_special_needs, special_needs_behavior, special_needs_meds, weight, time_on_shelter, time_total_on_shelter, days_on_shelter, days_total_on_shelter, date_brought_in, date_most_recent_entry, date_of_birth, date_created, date_adopt_movement, date_adopt_created, date_adopt_last_changed, date_combi_test, date_identi_chip, date_neutered, date_doc_media, date_website_media, date_last_changed, image_count ) VALUES ('14285','0','Tomato Sauce','0','1','0','0','0','0','10 weeks.','Kitten','No','C20237171','7171C','Domestic Medium Hair','Short','Brown Tabby and White','No','','Transfer from Municipal Shelter','Transfer from Municipal Shelter','Male','Unknown','Unknown','Unknown','Bullpen','Bullpen','C (County Shelter Cat)','Medium','No','0','0','1.5','0 days.','0 days.','0','0','2023-09-25 00:00:00','2023-09-25 00:00:00','2023-07-17 00:00:00','2023-09-25 13:47:09.476857','','','','2023-09-25 00:00:00','null','null','null','null','2023-09-25 13:50:06.562091','0');
NO IMAGES TO DOWNLOAD:
UPDATE HISTORY
Query result: SUCCESS
INSERT into update_history (animal_id, animal_name, old_date_last_changed, new_date_last_changed, date_changed, old_date_adopt, new_date_adopt, adopt_date_changed, old_date_website_media, new_date_website_media, website_media_changed, action ) VALUES ('14285','Tomato Sauce','','2023-09-25 13:50:06.562091','1','','','0','','null','1','SHELTER-INSERT');
ANIMAL DETAILS FROM DB:
Row ID: 5684
Name: Training Cat 1
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 5915
Name: Velouté
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 5883
Name: White gold
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 5901
Name: Woozel
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 595
Name: Zanna
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 5782
Name: Zaxbys
Adoptable: 0
Change date UNCHANGED
Website Media date UNCHANGED
ANIMAL DETAILS FROM DB:
Row ID: 5858
Name: Zoogie
Adoptable: 1
Animal adoptable, IGNORE
CLEANUP
UPDATE cats SET in_shelter = 1 WHERE animal_id IN (14114, 14284, 13805, 14286, 14281, 10632, 12768, 11210, 14271, 14235, 13924, 14184, 13567, 14147, 14146, 14253, 14280, 14251, 13941, 14105, 3969, 10332, 14277, 14236, 14287, 14158, 13980, 13616, 14207, 14274, 14206, 8484, 14273, 14239, 13879, 13384, 14098, 14130, 14282, 14216, 14238, 14156, 13001, 14270, 14136, 8585, 14199, 14275, 14209, 14241, 14278, 14240, 14149, 14227, 14208, 14279, 13719, 14248, 13865, 14237, 14250, 14246, 14272, 14176, 14276, 14254, 14223, 7585, 14212, 5683, 14285, 14049, 14283, 14249, 14264, 7040, 14145)
Query fail: NO
UPDATE cats SET in_shelter = 0 WHERE animal_id NOT IN (14114, 14284, 13805, 14286, 14281, 10632, 12768, 11210, 14271, 14235, 13924, 14184, 13567, 14147, 14146, 14253, 14280, 14251, 13941, 14105, 3969, 10332, 14277, 14236, 14287, 14158, 13980, 13616, 14207, 14274, 14206, 8484, 14273, 14239, 13879, 13384, 14098, 14130, 14282, 14216, 14238, 14156, 13001, 14270, 14136, 8585, 14199, 14275, 14209, 14241, 14278, 14240, 14149, 14227, 14208, 14279, 13719, 14248, 13865, 14237, 14250, 14246, 14272, 14176, 14276, 14254, 14223, 7585, 14212, 5683, 14285, 14049, 14283, 14249, 14264, 7040, 14145)
Query fail: NO
SAVE HISTORY:
INSERT INTO cats_metrics ( execution_time, total_cats, process ) VALUES ( '11.37','106','in shelter')
Query result: SUCCESS
Total Time: 11.37 seconds
XML Get Time: 9.25 seconds
HTML Create Time: 0 seconds