====1,1413855787,SELECT+q.id%2C+q.pet_code%2C+q.user_id%2C+q.guest%2C+q.pet_id%2C+q.question%2C+q.details%2C+%0A%09%09%09%09%09%09q.tags%2C+q.category_id%2C+q.answer_id%2C+q.vote%2C+q.closed%2C+q.rating%2C+q.created%2C+%0A%09%09%09%09%09%090+AS+answers_count%0A%09%09%09%09%09FROM+ans_question+AS+q%0A%09%09%09%09%09LEFT+OUTER+JOIN+ans_answer+AS+a%0A%09%09%09%09%09%09ON+q.id+%3D+a.question_id%0A%09%09%09%09%09WHERE+a.question_id+IS+null%0A%09%09%09%09%09%09AND+q.closed+IS+NULL%0A%09%09%09%09%09%09AND+q.pet_code+%3D+%27d%27%0A%09%09%09%09%09%09AND+q.approved+%3D+1+GROUP+BY+q.id%0A%09%09%09%09%09ORDER+BY+answers_count+DESC%2C+q.created+DESC+LIMIT+592%2C8 O:18:"ADORecordSet_array":37:{s:12:"databaseType";s:5:"array";s:6:"_array";a:8:{i:0;a:15:{s:2:"id";s:5:"65238";s:8:"pet_code";s:1:"d";s:7:"user_id";s:6:"495017";s:5:"guest";s:1:"0";s:6:"pet_id";s:6:"614878";s:8:"question";s:50:"Hi Dogster, Where are the Rose zealies?????????";s:7:"details";s:0:"";s:4:"tags";s:0:"";s:11:"category_id";s:1:"5";s:9:"answer_id";N;s:4:"vote";N;s:6:"closed";N;s:6:"rating";N;s:7:"created";s:19:"2012-10-03 10:02:12";s:13:"answers_count";s:1:"0";}i:1;a:15:{s:2:"id";s:5:"65226";s:8:"pet_code";s:1:"d";s:7:"user_id";s:7:"1133962";s:5:"guest";s:1:"1";s:6:"pet_id";s:1:"0";s:8:"question";s:65:"my dog is eating stag beetle larva, would this cause any illness?";s:7:"details";s:0:"";s:4:"tags";s:0:"";s:11:"category_id";s:3:"561";s:9:"answer_id";N;s:4:"vote";N;s:6:"closed";N;s:6:"rating";N;s:7:"created";s:19:"2012-10-02 22:58:11";s:13:"answers_count";s:1:"0";}i:2;a:15:{s:2:"id";s:5:"65198";s:8:"pet_code";s:1:"d";s:7:"user_id";s:7:"1133818";s:5:"guest";s:1:"1";s:6:"pet_id";s:1:"0";s:8:"question";s:115:"My dog seems terrified of other dogs when they are at a distance, but super excited to play when close. What gives?";s:7:"details";s:1000:"I have a 1 year old beagle rescue. When another dog comes within sight (or if we are walking somewhere like the woods and meet someone unexpectedly) she goes absolutely nuts. She starts howling, pulling at her leash, the hair on her back stands up, and she makes these weird sounds like she can't even get it together enough to vocalize properly. It is impossible to distract her with anything-- she just totally loses control. However, as soon as she gets close enough to sniff the other dog, she becomes overwhelmingly happy, excited, and just wants to play. I'm unsure if this is fear-based or if she just gets so excited that she doesn't know how to control herself. I know she needs better socialization, but when she reacts like that to other dogs they justifiably don't want to interact with her. She's well-trained and obeys when not in this situation. What can I do to help this situation? It's gotten to the point that I can't take her out in public much for fear that we'll meet another do";s:4:"tags";s:38:"socialization,training,fear,aggression";s:11:"category_id";s:2:"48";s:9:"answer_id";N;s:4:"vote";N;s:6:"closed";N;s:6:"rating";N;s:7:"created";s:19:"2012-10-02 08:55:04";s:13:"answers_count";s:1:"0";}i:3;a:15:{s:2:"id";s:5:"65192";s:8:"pet_code";s:1:"d";s:7:"user_id";s:7:"1133814";s:5:"guest";s:1:"0";s:6:"pet_id";N;s:8:"question";N;s:7:"details";N;s:4:"tags";s:0:"";s:11:"category_id";s:1:"0";s:9:"answer_id";N;s:4:"vote";N;s:6:"closed";N;s:6:"rating";N;s:7:"created";s:19:"2012-10-02 08:09:13";s:13:"answers_count";s:1:"0";}i:4;a:15:{s:2:"id";s:5:"65178";s:8:"pet_code";s:1:"d";s:7:"user_id";s:7:"1058571";s:5:"guest";s:1:"0";s:6:"pet_id";s:7:"1209412";s:8:"question";s:112:"can a cyst be found between the shoulder blades that is seeping fluid. My 1yr.old Newfoundland has a tender lump";s:7:"details";s:448:"My dog Charlie has been to the vet June 4th for his shots.I called the vet today(October 1st) and asked if the shots could have caused the lump but the office help said no,because it would have been too long ago to have caused the lump and I'm sure I might have missed the lump if it was a lot smaller. He doesn't seem to be in pain but it's a little red and he's is somewhat sensitive when I put pressure on it.Could it be a spider or insect bite?";s:4:"tags";s:5:"lumps";s:11:"category_id";s:2:"26";s:9:"answer_id";N;s:4:"vote";N;s:6:"closed";N;s:6:"rating";N;s:7:"created";s:19:"2012-10-01 19:35:40";s:13:"answers_count";s:1:"0";}i:5;a:15:{s:2:"id";s:5:"65158";s:8:"pet_code";s:1:"d";s:7:"user_id";s:7:"1133648";s:5:"guest";s:1:"1";s:6:"pet_id";s:1:"0";s:8:"question";s:99:"How can i train my dog to stop barking at everything and everyone? People, leaves, cars, dogs, etc.";s:7:"details";s:721:"My yorkie is 1 year and 5 months old. Her name is Bella and she is playful and adorable, but as soon as we unlock he door and she storms out, she becomes ferocious and viscious (but she never bites anyone. Some say we need to buy her a muzzle, but i would never want to do such a thing. We have tried saying "no" sternly; we have tried training her with treats; we have tried standing in front of her sternly to blockade whatever or whoever she is barking at..and shouwing her we are serious does not do a thing! I even tried spraying her with water, but she loves it.. I don't know what to do but need to train her a.s.a.p because she just had puppies and this will be a really bad influence on them. Please help me..";s:4:"tags";s:17:"stopbarking,train";s:11:"category_id";s:2:"48";s:9:"answer_id";N;s:4:"vote";N;s:6:"closed";N;s:6:"rating";N;s:7:"created";s:19:"2012-10-01 07:56:51";s:13:"answers_count";s:1:"0";}i:6;a:15:{s:2:"id";s:5:"65148";s:8:"pet_code";s:1:"d";s:7:"user_id";s:7:"1133618";s:5:"guest";s:1:"0";s:6:"pet_id";N;s:8:"question";N;s:7:"details";N;s:4:"tags";s:0:"";s:11:"category_id";s:1:"0";s:9:"answer_id";N;s:4:"vote";N;s:6:"closed";N;s:6:"rating";N;s:7:"created";s:19:"2012-09-30 22:52:38";s:13:"answers_count";s:1:"0";}i:7;a:15:{s:2:"id";s:5:"65144";s:8:"pet_code";s:1:"d";s:7:"user_id";s:7:"1133592";s:5:"guest";s:1:"0";s:6:"pet_id";N;s:8:"question";s:106:"My Pomchi is 4lbs 8oz at 21 weeks old. How big will she be full grown? And how old will she be full grown?";s:7:"details";s:0:"";s:4:"tags";s:0:"";s:11:"category_id";s:2:"90";s:9:"answer_id";N;s:4:"vote";N;s:6:"closed";N;s:6:"rating";N;s:7:"created";s:19:"2012-09-30 21:52:49";s:13:"answers_count";s:1:"0";}}s:6:"_types";N;s:9:"_colnames";N;s:9:"_skiprow1";b:0;s:13:"_fieldobjects";a:15:{i:0;O:8:"stdClass":14:{s:4:"name";s:2:"id";s:5:"table";s:1:"q";s:3:"def";s:0:"";s:10:"max_length";i:10;s:8:"not_null";i:1;s:11:"primary_key";i:0;s:12:"multiple_key";i:0;s:10:"unique_key";i:0;s:7:"numeric";i:1;s:4:"blob";i:0;s:4:"type";s:3:"int";s:8:"unsigned";i:1;s:8:"zerofill";i:0;s:6:"binary";b:0;}i:1;O:8:"stdClass":14:{s:4:"name";s:8:"pet_code";s:5:"table";s:1:"q";s:3:"def";s:0:"";s:10:"max_length";i:3;s:8:"not_null";i:0;s:11:"primary_key";i:0;s:12:"multiple_key";i:0;s:10:"unique_key";i:0;s:7:"numeric";i:0;s:4:"blob";i:0;s:4:"type";s:6:"string";s:8:"unsigned";i:0;s:8:"zerofill";i:0;s:6:"binary";b:0;}i:2;O:8:"stdClass":14:{s:4:"name";s:7:"user_id";s:5:"table";s:1:"q";s:3:"def";s:0:"";s:10:"max_length";i:11;s:8:"not_null";i:0;s:11:"primary_key";i:0;s:12:"multiple_key";i:0;s:10:"unique_key";i:0;s:7:"numeric";i:1;s:4:"blob";i:0;s:4:"type";s:3:"int";s:8:"unsigned";i:0;s:8:"zerofill";i:0;s:6:"binary";b:0;}i:3;O:8:"stdClass":14:{s:4:"name";s:5:"guest";s:5:"table";s:1:"q";s:3:"def";s:0:"";s:10:"max_length";i:1;s:8:"not_null";i:1;s:11:"primary_key";i:0;s:12:"multiple_key";i:0;s:10:"unique_key";i:0;s:7:"numeric";i:1;s:4:"blob";i:0;s:4:"type";s:3:"int";s:8:"unsigned";i:0;s:8:"zerofill";i:0;s:6:"binary";b:0;}i:4;O:8:"stdClass":14:{s:4:"name";s:6:"pet_id";s:5:"table";s:1:"q";s:3:"def";s:0:"";s:10:"max_length";i:11;s:8:"not_null";i:0;s:11:"primary_key";i:0;s:12:"multiple_key";i:0;s:10:"unique_key";i:0;s:7:"numeric";i:1;s:4:"blob";i:0;s:4:"type";s:3:"int";s:8:"unsigned";i:0;s:8:"zerofill";i:0;s:6:"binary";b:0;}i:5;O:8:"stdClass":14:{s:4:"name";s:8:"question";s:5:"table";s:1:"q";s:3:"def";s:0:"";s:10:"max_length";i:196605;s:8:"not_null";i:0;s:11:"primary_key";i:0;s:12:"multiple_key";i:0;s:10:"unique_key";i:0;s:7:"numeric";i:0;s:4:"blob";i:1;s:4:"type";s:4:"blob";s:8:"unsigned";i:0;s:8:"zerofill";i:0;s:6:"binary";b:0;}i:6;O:8:"stdClass":14:{s:4:"name";s:7:"details";s:5:"table";s:1:"q";s:3:"def";s:0:"";s:10:"max_length";i:196605;s:8:"not_null";i:0;s:11:"primary_key";i:0;s:12:"multiple_key";i:0;s:10:"unique_key";i:0;s:7:"numeric";i:0;s:4:"blob";i:1;s:4:"type";s:4:"blob";s:8:"unsigned";i:0;s:8:"zerofill";i:0;s:6:"binary";b:0;}i:7;O:8:"stdClass":14:{s:4:"name";s:4:"tags";s:5:"table";s:1:"q";s:3:"def";s:0:"";s:10:"max_length";i:765;s:8:"not_null";i:0;s:11:"primary_key";i:0;s:12:"multiple_key";i:0;s:10:"unique_key";i:0;s:7:"numeric";i:0;s:4:"blob";i:0;s:4:"type";s:6:"string";s:8:"unsigned";i:0;s:8:"zerofill";i:0;s:6:"binary";b:0;}i:8;O:8:"stdClass":14:{s:4:"name";s:11:"category_id";s:5:"table";s:1:"q";s:3:"def";s:0:"";s:10:"max_length";i:10;s:8:"not_null";i:0;s:11:"primary_key";i:0;s:12:"multiple_key";i:0;s:10:"unique_key";i:0;s:7:"numeric";i:1;s:4:"blob";i:0;s:4:"type";s:3:"int";s:8:"unsigned";i:0;s:8:"zerofill";i:0;s:6:"binary";b:0;}i:9;O:8:"stdClass":14:{s:4:"name";s:9:"answer_id";s:5:"table";s:1:"q";s:3:"def";s:0:"";s:10:"max_length";i:10;s:8:"not_null";i:0;s:11:"primary_key";i:0;s:12:"multiple_key";i:0;s:10:"unique_key";i:0;s:7:"numeric";i:1;s:4:"blob";i:0;s:4:"type";s:3:"int";s:8:"unsigned";i:0;s:8:"zerofill";i:0;s:6:"binary";b:0;}i:10;O:8:"stdClass":14:{s:4:"name";s:4:"vote";s:5:"table";s:1:"q";s:3:"def";s:0:"";s:10:"max_length";i:19;s:8:"not_null";i:0;s:11:"primary_key";i:0;s:12:"multiple_key";i:0;s:10:"unique_key";i:0;s:7:"numeric";i:0;s:4:"blob";i:0;s:4:"type";s:8:"datetime";s:8:"unsigned";i:0;s:8:"zerofill";i:0;s:6:"binary";b:1;}i:11;O:8:"stdClass":14:{s:4:"name";s:6:"closed";s:5:"table";s:1:"q";s:3:"def";s:0:"";s:10:"max_length";i:19;s:8:"not_null";i:0;s:11:"primary_key";i:0;s:12:"multiple_key";i:0;s:10:"unique_key";i:0;s:7:"numeric";i:0;s:4:"blob";i:0;s:4:"type";s:8:"datetime";s:8:"unsigned";i:0;s:8:"zerofill";i:0;s:6:"binary";b:1;}i:12;O:8:"stdClass":14:{s:4:"name";s:6:"rating";s:5:"table";s:1:"q";s:3:"def";s:0:"";s:10:"max_length";i:10;s:8:"not_null";i:0;s:11:"primary_key";i:0;s:12:"multiple_key";i:0;s:10:"unique_key";i:0;s:7:"numeric";i:1;s:4:"blob";i:0;s:4:"type";s:3:"int";s:8:"unsigned";i:0;s:8:"zerofill";i:0;s:6:"binary";b:0;}i:13;O:8:"stdClass":14:{s:4:"name";s:7:"created";s:5:"table";s:1:"q";s:3:"def";s:0:"";s:10:"max_length";i:19;s:8:"not_null";i:1;s:11:"primary_key";i:0;s:12:"multiple_key";i:0;s:10:"unique_key";i:0;s:7:"numeric";i:0;s:4:"blob";i:0;s:4:"type";s:8:"datetime";s:8:"unsigned";i:0;s:8:"zerofill";i:0;s:6:"binary";b:1;}i:14;O:8:"stdClass":14:{s:4:"name";s:13:"answers_count";s:5:"table";s:0:"";s:3:"def";s:0:"";s:10:"max_length";i:1;s:8:"not_null";i:1;s:11:"primary_key";i:0;s:12:"multiple_key";i:0;s:10:"unique_key";i:0;s:7:"numeric";i:1;s:4:"blob";i:0;s:4:"type";s:3:"int";s:8:"unsigned";i:0;s:8:"zerofill";i:0;s:6:"binary";b:1;}}s:7:"canSeek";b:1;s:12:"affectedrows";b:0;s:8:"insertid";b:0;s:3:"sql";s:467:"SELECT q.id, q.pet_code, q.user_id, q.guest, q.pet_id, q.question, q.details, q.tags, q.category_id, q.answer_id, q.vote, q.closed, q.rating, q.created, 0 AS answers_count FROM ans_question AS q LEFT OUTER JOIN ans_answer AS a ON q.id = a.question_id WHERE a.question_id IS null AND q.closed IS NULL AND q.pet_code = 'd' AND q.approved = 1 GROUP BY q.id ORDER BY answers_count DESC, q.created DESC LIMIT 592,8";s:6:"compat";b:0;s:12:"dataProvider";s:6:"native";s:6:"fields";a:15:{s:2:"id";s:5:"65238";s:8:"pet_code";s:1:"d";s:7:"user_id";s:6:"495017";s:5:"guest";s:1:"0";s:6:"pet_id";s:6:"614878";s:8:"question";s:50:"Hi Dogster, Where are the Rose zealies?????????";s:7:"details";s:0:"";s:4:"tags";s:0:"";s:11:"category_id";s:1:"5";s:9:"answer_id";N;s:4:"vote";N;s:6:"closed";N;s:6:"rating";N;s:7:"created";s:19:"2012-10-03 10:02:12";s:13:"answers_count";s:1:"0";}s:8:"blobSize";i:100;s:3:"EOF";b:0;s:14:"emptyTimeStamp";s:6:" ";s:9:"emptyDate";s:6:" ";s:5:"debug";b:0;s:11:"timeCreated";i:1413855787;s:4:"bind";b:0;s:9:"fetchMode";i:2;s:10:"connection";b:0;s:10:"_numOfRows";i:8;s:12:"_numOfFields";i:15;s:8:"_queryID";i:1;s:11:"_currentRow";i:0;s:7:"_closed";b:0;s:7:"_inited";b:1;s:4:"_obj";N;s:6:"_names";N;s:12:"_currentPage";i:-1;s:12:"_atFirstPage";b:0;s:11:"_atLastPage";b:0;s:11:"_lastPageNo";i:-1;s:15:"_maxRecordCount";i:0;s:8:"datetime";b:0;s:11:"oldProvider";s:5:"mysql";}