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 = 106 AND ad.location_zip in (38001,38002,38003,38004,38005,38006,38007,38008,38009,38010,38011,38012,38013,38014,38015,38016,38017,38018,38019,38020,38021,38022,38023,38024,38025,38026,38027,38028,38029,38030,38031,38032,38033,38034,38035,38036,38037,38038,38039,38049,38051,38052,38053,38055,38057,38058,38059,38083,38084,38085,38090,38091,38092,38093,38094,38095,38096,38100,38102,38104,38106,38108,38110,38112,38114,38116,38118,38120,38122,38124,38126,38130,38131,38132,38133,38140) GROUP BY a.ad_id ORDER BY a.`cdate` LIMIT 20
Object dump
AdList Object ( [items] => [node] => 106 [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 = 106 AND ad.location_zip in (38001,38002,38003,38004,38005,38006,38007,38008,38009,38010,38011,38012,38013,38014,38015,38016,38017,38018,38019,38020,38021,38022,38023,38024,38025,38026,38027,38028,38029,38030,38031,38032,38033,38034,38035,38036,38037,38038,38039,38049,38051,38052,38053,38055,38057,38058,38059,38083,38084,38085,38090,38091,38092,38093,38094,38095,38096,38100,38102,38104,38106,38108,38110,38112,38114,38116,38118,38120,38122,38124,38126,38130,38131,38132,38133,38140) GROUP BY a.ad_id ORDER BY a.`cdate` LIMIT 20
[have_error] => 1 [page] => 1 [length] => 0 )