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 = 402 AND ad.location_zip in (50401,50402,50403,50416,50418,50419,50420,50441,50442,50443,50444,50445,50446,50447,50448,50449,50450,50451,50452,50453,50454,50455,50456,50457,50458,50459,50460,50461,50462,50463,50464,50465,50466,50467,50468,50469,50470,50471,50472,50473,50474,50475,50476,50477,50478,50479,50480,50481,50482,50491,50495,50498,50499,50500,50501,50504,50505,50506,50508,50509,50510,50511,50514,50515,50517,50518,50519,50520,50523,50524,50525,50527,50528,50529,50530,50531,50532,50533,50534,50535,50570,50586,50587,50588,50589,50590,50591,50592,50593,50594,50595,50597,50598,50599,50600,50601,50602,50603,50604,50605,50606,50607,50608,50609,50610,50611,50612,50613,50614,50615,50616,50617,50618,50619,50620,50621,50622,50623,50624,50625,50626,50627,50628,50629,50630,50631,50632,50633,50634,50635,50636,50637,50638,50639,50640,50641,50642,50643,50644,50645,50646,50647,50648,50649,50650,50651,50652,50653,50654,50655,50656,50657,50658,50659,50660,50661,50662,50663,50664,50667,50668,50669,50670,50672,50674,50676,50677,50678,50679,50681,50682,50683,50684,50685,50686,50687,50688,50689,50694,50695,50696,50697,50700,50702,50704,50705,50706,50708,50724,50725,50726,50727,50728,50729,50730,50731,50733,50735,50737,50739,50741,50742,50743,50744,50745,50746,50747,50748,50753,50754,50756,50757,50763,50765,50767,50769,50771,50772,50773,50774,50775,50776,50777,50778,50779,50780,50781,50782,50783,50784,50792,50793,50795,50796,50797,50798,50799,50819,50820,50823,50825,50827,50829,50831,50832,50833,50834,50835,50836,50840,50841,50854,50855,50858,50859,50861,50862,50863,50864,50865,50866,50867,50868,50869,50870,50876,50877,50878,50879,50880,50881,50882,50883,50884,50885,50886,50887,50888,50895,50896,50897,50898,50899,50900,50921,50922,50923,50924,50925,50926,50927,50928,50931,50933,50935,50937,50939,50941,50942,50943,50944,50945,50946,50950,50951,50952,50953,50962,50963,50964,50965,50968,50969,50971,50972,50973,50974,50975,50976,50977,50978,50979,50980,50981,50982,50995,50996,50997,50999,51001,51002,51003,51004,51005,51006,51007,51008,51009,51010,51011,51021,51022,51023,51024,51026,51027,51028,51029,51030,51033,51034,51056,51057,51058,51061,51063,51065,51067,51069,51071,51072,51073,51074,51075,51076,51077,51078,51083,51085,51086,51087,51089,51090,51092,51093,51094,51101,51103,51105,51107,51109,51111,51112,51113,51114,51115,51116,51117,51118,51122,51123,51124,51126,51127,51129,51130,51139,51140,51143,51145,51149,51151,51152,51153,51154,51159,51160,51161,51162,51163,51164,51165,51166,51167,51169,51170) GROUP BY a.ad_id ORDER BY a.`cdate` LIMIT 20
Object dump
AdList Object ( [items] => [node] => 402 [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 = 402 AND ad.location_zip in (50401,50402,50403,50416,50418,50419,50420,50441,50442,50443,50444,50445,50446,50447,50448,50449,50450,50451,50452,50453,50454,50455,50456,50457,50458,50459,50460,50461,50462,50463,50464,50465,50466,50467,50468,50469,50470,50471,50472,50473,50474,50475,50476,50477,50478,50479,50480,50481,50482,50491,50495,50498,50499,50500,50501,50504,50505,50506,50508,50509,50510,50511,50514,50515,50517,50518,50519,50520,50523,50524,50525,50527,50528,50529,50530,50531,50532,50533,50534,50535,50570,50586,50587,50588,50589,50590,50591,50592,50593,50594,50595,50597,50598,50599,50600,50601,50602,50603,50604,50605,50606,50607,50608,50609,50610,50611,50612,50613,50614,50615,50616,50617,50618,50619,50620,50621,50622,50623,50624,50625,50626,50627,50628,50629,50630,50631,50632,50633,50634,50635,50636,50637,50638,50639,50640,50641,50642,50643,50644,50645,50646,50647,50648,50649,50650,50651,50652,50653,50654,50655,50656,50657,50658,50659,50660,50661,50662,50663,50664,50667,50668,50669,50670,50672,50674,50676,50677,50678,50679,50681,50682,50683,50684,50685,50686,50687,50688,50689,50694,50695,50696,50697,50700,50702,50704,50705,50706,50708,50724,50725,50726,50727,50728,50729,50730,50731,50733,50735,50737,50739,50741,50742,50743,50744,50745,50746,50747,50748,50753,50754,50756,50757,50763,50765,50767,50769,50771,50772,50773,50774,50775,50776,50777,50778,50779,50780,50781,50782,50783,50784,50792,50793,50795,50796,50797,50798,50799,50819,50820,50823,50825,50827,50829,50831,50832,50833,50834,50835,50836,50840,50841,50854,50855,50858,50859,50861,50862,50863,50864,50865,50866,50867,50868,50869,50870,50876,50877,50878,50879,50880,50881,50882,50883,50884,50885,50886,50887,50888,50895,50896,50897,50898,50899,50900,50921,50922,50923,50924,50925,50926,50927,50928,50931,50933,50935,50937,50939,50941,50942,50943,50944,50945,50946,50950,50951,50952,50953,50962,50963,50964,50965,50968,50969,50971,50972,50973,50974,50975,50976,50977,50978,50979,50980,50981,50982,50995,50996,50997,50999,51001,51002,51003,51004,51005,51006,51007,51008,51009,51010,51011,51021,51022,51023,51024,51026,51027,51028,51029,51030,51033,51034,51056,51057,51058,51061,51063,51065,51067,51069,51071,51072,51073,51074,51075,51076,51077,51078,51083,51085,51086,51087,51089,51090,51092,51093,51094,51101,51103,51105,51107,51109,51111,51112,51113,51114,51115,51116,51117,51118,51122,51123,51124,51126,51127,51129,51130,51139,51140,51143,51145,51149,51151,51152,51153,51154,51159,51160,51161,51162,51163,51164,51165,51166,51167,51169,51170) GROUP BY a.ad_id ORDER BY a.`cdate` LIMIT 20
[have_error] => 1 [page] => 1 [length] => 0 )