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 = 91029 AND ad.location_zip in (24011,24012,24013,24014,24015,24016,24017,24018,24019,24020,24021,24022,24023,24024,24025,24026,24027,24028,24029,24030,24031,24032,24033,24034,24035,24036,24037,24038,24039,24040,24041,24042,24043,24044,24046,24047,24048,24049,24062,24063,24065,24083,24084,24094,24095,24096,24097,24098,24099,24100,24103,24105,24106,24107,24109,24111,24113,24114,24116,24118,24119,24120,24121,24122,24123,24124,24125,24126,24143,24145,24146,24147,24148,24149,24151,24152,24154,24157,24159,24170,24171,24180) GROUP BY a.ad_id ORDER BY a.`cdate` LIMIT 20
Object dump
AdList Object ( [items] => [node] => 91029 [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 = 91029 AND ad.location_zip in (24011,24012,24013,24014,24015,24016,24017,24018,24019,24020,24021,24022,24023,24024,24025,24026,24027,24028,24029,24030,24031,24032,24033,24034,24035,24036,24037,24038,24039,24040,24041,24042,24043,24044,24046,24047,24048,24049,24062,24063,24065,24083,24084,24094,24095,24096,24097,24098,24099,24100,24103,24105,24106,24107,24109,24111,24113,24114,24116,24118,24119,24120,24121,24122,24123,24124,24125,24126,24143,24145,24146,24147,24148,24149,24151,24152,24154,24157,24159,24170,24171,24180) GROUP BY a.ad_id ORDER BY a.`cdate` LIMIT 20
[have_error] => 1 [page] => 1 [length] => 0 )