AdList::randomChilds SELECT a.*, ac.*, c.category_id, c.parent_id, c.ad_count, c.title category, c.title, c.description, c.latest_date, c.image_name, (select p.pic_name from pics p where p.ad_id=a.ad_id limit 1) tmb_name FROM ad a INNER JOIN ad2category ac ON a.ad_id=ac.ad_id INNER JOIN category c ON c.category_id=ac.category_id WHERE c. parent_id = 421 AND ad.location_zip in (60001,60002,60003,60004,60005,60006,60007,60008,60009,60010,60011,60012,60013,60014,60015,60016,60017,60018,60019,60020,60021,60022,60023,60024,60036,60037,60038,60039,60040,60041,60042,60043,60044,60045,60046,60047,60048,60049,60050,60051,60052,60053,60054,60055,60061,60062,60063,60064,60065,60066,60067,60068,60069,60070,60071,60075,60076,60077,60078,60079,60082,60083,60084,60085,60088,60089,60090,60091,60101,60102,60103,60107,60108,60109,60132,60133,60134,60135,60136,60137,60138,60139,60140,60141,60142,60143,60144,60145,60146,60147,60148,60149,60150,60151,60152,60153,60154,60155,60156,60157,60158,60159,60160,60161,60162,60163,60164,60165,60166,60167,60168,60169,60170,60171,60172,60173,60174,60175,60176,60177,60178,60179,60180,60181,60182,60183,60184,60185,60186,60187,60188,60189,60190,60191,60192,60193,60194,60195,60196,60197,60198,60199,60200,60201,60202,60203,60204,60205,60206,60222,60232,60252,60253,60254,60255,60256,60257,60258,60259,60260,60261,60262,60263,60264,60265,60266,60267,60268,60269,60270,60271,60272,60273,60274,60275,60276,60277,60278,60279,60280,60281,60282,60283,60284,60285,60286,60287,60288,60291,60292,60293,60295,60296,60297,60298,60299,60300,60301,60302,60303,60304,60305,60307,60308,60311,60313,60314,60316,60318,60320,60322,60323,60325,60326,60327,60329,60331,60332,60333,60334,60335,60336,60337,60338,60343,60344,60345,60346,60347,60348,60350,60351,60352,60353,60355,60356,60357,60358,60378,60380,60381,60382,60383,60385,60386,60388,60389,60391,60392,60393,60394,60395,60396,60400,60401,60402,60403,60404,60406,60407,60423,60424,60425,60426,60427,60428,60431,60433,60435,60437,60439,60441,60442,60443,60444,60445,60446,60447,60448,60449,60450,60456,60457,60459,60460,60461,60477,60478,60479,60480,60481,60483,60484,60486,60487,60488,60489,60491,60492,60493,60494,60495,60496,60497,60498,60503,60504,60505,60507,60508,60519,60522,60523,60524,60525,60528,60529,60531,60532,60533,60534,60544,60545,60546,60547,60549,60551,60552,60553,60554,60555,60556,60557,60558,60559,60560,60561,60562,60567,60568,60569,60570,60578,60579,60580,60581,60582,60583,60584,60585,60589,60590,60591,60594,60596,60598,60599,60605,60606,60607,60608,60609,60610,60611,60612,60613,60614,60615,60641,60642,60643,60644,60645,60646,60651,60652,60653,60656,60657,60658,60659,60663,60664,60665,65901,65902,65903,65904,65905,65906,65907,65908,65913,65914,65915,65916,65917,65924,65925,65926,65929,65931,65933,65934,65936) GROUP BY a.ad_id ORDER BY a.`cdate` LIMIT 20
Object dump
AdList Object ( [items] => [node] => 421 [error] => [no_items] => 1 [ads_title] => [pages] => Array ( [0] => Array ( [id] => 1 [title] => 1 ) ) [current_page] => 1 [total] => 0 [start_offset] => 0 [end_offset] => [next_page] => [prev_page] => [object_state] => AdList::randomChilds SELECT a.*, ac.*, c.category_id, c.parent_id, c.ad_count, c.title category, c.title, c.description, c.latest_date, c.image_name, (select p.pic_name from pics p where p.ad_id=a.ad_id limit 1) tmb_name FROM ad a INNER JOIN ad2category ac ON a.ad_id=ac.ad_id INNER JOIN category c ON c.category_id=ac.category_id WHERE c. parent_id = 421 AND ad.location_zip in (60001,60002,60003,60004,60005,60006,60007,60008,60009,60010,60011,60012,60013,60014,60015,60016,60017,60018,60019,60020,60021,60022,60023,60024,60036,60037,60038,60039,60040,60041,60042,60043,60044,60045,60046,60047,60048,60049,60050,60051,60052,60053,60054,60055,60061,60062,60063,60064,60065,60066,60067,60068,60069,60070,60071,60075,60076,60077,60078,60079,60082,60083,60084,60085,60088,60089,60090,60091,60101,60102,60103,60107,60108,60109,60132,60133,60134,60135,60136,60137,60138,60139,60140,60141,60142,60143,60144,60145,60146,60147,60148,60149,60150,60151,60152,60153,60154,60155,60156,60157,60158,60159,60160,60161,60162,60163,60164,60165,60166,60167,60168,60169,60170,60171,60172,60173,60174,60175,60176,60177,60178,60179,60180,60181,60182,60183,60184,60185,60186,60187,60188,60189,60190,60191,60192,60193,60194,60195,60196,60197,60198,60199,60200,60201,60202,60203,60204,60205,60206,60222,60232,60252,60253,60254,60255,60256,60257,60258,60259,60260,60261,60262,60263,60264,60265,60266,60267,60268,60269,60270,60271,60272,60273,60274,60275,60276,60277,60278,60279,60280,60281,60282,60283,60284,60285,60286,60287,60288,60291,60292,60293,60295,60296,60297,60298,60299,60300,60301,60302,60303,60304,60305,60307,60308,60311,60313,60314,60316,60318,60320,60322,60323,60325,60326,60327,60329,60331,60332,60333,60334,60335,60336,60337,60338,60343,60344,60345,60346,60347,60348,60350,60351,60352,60353,60355,60356,60357,60358,60378,60380,60381,60382,60383,60385,60386,60388,60389,60391,60392,60393,60394,60395,60396,60400,60401,60402,60403,60404,60406,60407,60423,60424,60425,60426,60427,60428,60431,60433,60435,60437,60439,60441,60442,60443,60444,60445,60446,60447,60448,60449,60450,60456,60457,60459,60460,60461,60477,60478,60479,60480,60481,60483,60484,60486,60487,60488,60489,60491,60492,60493,60494,60495,60496,60497,60498,60503,60504,60505,60507,60508,60519,60522,60523,60524,60525,60528,60529,60531,60532,60533,60534,60544,60545,60546,60547,60549,60551,60552,60553,60554,60555,60556,60557,60558,60559,60560,60561,60562,60567,60568,60569,60570,60578,60579,60580,60581,60582,60583,60584,60585,60589,60590,60591,60594,60596,60598,60599,60605,60606,60607,60608,60609,60610,60611,60612,60613,60614,60615,60641,60642,60643,60644,60645,60646,60651,60652,60653,60656,60657,60658,60659,60663,60664,60665,65901,65902,65903,65904,65905,65906,65907,65908,65913,65914,65915,65916,65917,65924,65925,65926,65929,65931,65933,65934,65936) GROUP BY a.ad_id ORDER BY a.`cdate` LIMIT 20
[have_error] => 1 [page] => 1 [length] => 0 )