====1,1413606678,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%09COUNT%28a.id%29+AS+answers_count%0A%09%09%09%09%09FROM+ans_question+AS+q%0A%09%09%09%09%09%09JOIN+ans_answer+AS+a%0A%09%09%09%09%09WHERE+a.question_id+%3D+q.id%0A%09%09%09%09%09%09AND+q.pet_code+%3D+%27d%27%0A%09%09%09%09%09%09AND+q.created+%3E+DATE_SUB%28NOW%28%29%2C+INTERVAL+12+MONTH%29%0A%09%09%09%09%09%09AND+q.approved+%3D+1+AND+q.category_id+IN+%283%2C85%2C164%2C165%2C166%2C167%2C168%2C169%2C170%2C171%2C172%2C173%2C174%2C175%2C176%2C177%2C178%2C179%2C180%2C181%2C182%2C183%2C184%2C185%2C186%2C187%2C188%2C189%2C190%2C191%2C192%2C193%2C194%2C195%2C196%2C197%2C198%2C199%2C200%2C201%2C202%2C203%2C204%2C205%2C206%2C207%2C208%2C209%2C210%2C211%2C212%2C213%2C214%2C215%2C216%2C217%2C218%2C219%2C220%2C221%2C222%2C223%2C224%2C225%2C227%2C228%2C229%2C230%2C231%2C232%2C233%2C86%2C234%2C235%2C236%2C237%2C238%2C239%2C240%2C241%2C242%2C243%2C244%2C245%2C247%2C248%2C249%2C250%2C251%2C252%2C253%2C254%2C255%2C256%2C257%2C258%2C259%2C260%2C261%2C262%2C263%2C264%2C265%2C266%2C267%2C268%2C269%2C270%2C271%2C272%2C273%2C274%2C275%2C276%2C277%2C278%2C279%2C280%2C281%2C282%2C283%2C284%2C285%2C286%2C287%2C288%2C289%2C290%2C291%2C292%2C293%2C294%2C87%2C295%2C296%2C297%2C298%2C299%2C300%2C301%2C302%2C303%2C304%2C305%2C306%2C307%2C308%2C309%2C310%2C311%2C312%2C313%2C314%2C315%2C316%2C317%2C318%2C319%2C320%2C321%2C322%2C323%2C324%2C325%2C326%2C327%2C328%2C329%2C330%2C331%2C332%2C333%2C334%2C335%2C336%2C337%2C338%2C339%2C340%2C341%2C342%2C343%2C344%2C345%2C346%2C347%2C348%2C349%2C350%2C351%2C352%2C353%2C354%2C355%2C356%2C357%2C358%2C359%2C360%2C361%2C362%2C363%2C93%2C364%2C365%2C366%2C367%2C368%2C369%2C370%2C371%2C372%2C373%2C374%2C375%2C376%2C377%2C378%2C379%2C380%2C381%2C382%2C383%2C384%2C385%2C386%2C387%2C388%2C389%2C390%2C391%2C392%2C393%2C394%2C395%2C396%2C397%2C398%2C399%2C400%2C401%2C402%2C403%2C404%2C405%2C406%2C407%2C408%2C409%2C410%2C411%2C412%2C413%2C414%2C94%2C415%2C416%2C417%2C418%2C419%2C420%2C421%2C422%2C423%2C424%2C425%2C426%2C427%2C428%2C429%2C430%2C431%2C432%2C433%2C434%2C435%2C436%2C437%2C438%2C439%2C440%2C441%2C442%2C443%2C444%2C445%2C446%2C447%2C448%2C449%2C450%2C451%2C452%2C453%2C454%2C455%2C456%2C457%2C458%2C459%2C460%2C461%2C462%2C463%2C464%2C465%2C466%2C467%2C468%2C469%2C470%2C471%2C472%2C473%2C84%2C474%2C475%2C476%2C477%2C478%2C479%2C480%2C481%2C482%2C483%2C484%2C485%2C486%2C487%2C488%2C489%2C490%2C491%2C492%2C493%2C494%2C495%2C496%2C497%2C498%2C499%2C500%2C501%2C502%2C503%2C504%2C90%29+GROUP+BY+q.id%0A%09%09%09%09%09ORDER+BY+answers_count+DESC%2C+q.created+DESC+LIMIT+104%2C8 O:18:"ADORecordSet_array":37:{s:12:"databaseType";s:5:"array";s:6:"_array";a: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:21;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;}}s:7:"canSeek";b:1;s:12:"affectedrows";b:0;s:8:"insertid";b:0;s:3:"sql";s:1868:"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, COUNT(a.id) AS answers_count FROM ans_question AS q JOIN ans_answer AS a WHERE a.question_id = q.id AND q.pet_code = 'd' AND q.created > DATE_SUB(NOW(), INTERVAL 12 MONTH) AND q.approved = 1 AND q.category_id IN (3,85,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,227,228,229,230,231,232,233,86,234,235,236,237,238,239,240,241,242,243,244,245,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,87,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,93,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,94,415,416,417,418,419,420,421,422,423,424,425,426,427,428,429,430,431,432,433,434,435,436,437,438,439,440,441,442,443,444,445,446,447,448,449,450,451,452,453,454,455,456,457,458,459,460,461,462,463,464,465,466,467,468,469,470,471,472,473,84,474,475,476,477,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,494,495,496,497,498,499,500,501,502,503,504,90) GROUP BY q.id ORDER BY answers_count DESC, q.created DESC LIMIT 104,8";s:6:"compat";b:0;s:12:"dataProvider";s:6:"native";s:6:"fields";b:0;s:8:"blobSize";i:100;s:3:"EOF";b:1;s:14:"emptyTimeStamp";s:6:" ";s:9:"emptyDate";s:6:" ";s:5:"debug";b:0;s:11:"timeCreated";i:1413606678;s:4:"bind";b:0;s:9:"fetchMode";i:2;s:10:"connection";b:0;s:10:"_numOfRows";i:0;s:12:"_numOfFields";i:15;s:8:"_queryID";i:1;s:11:"_currentRow";i:-1;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";}