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 = 118 AND ad.location_zip in (18001,18002,18003,18004,18005,18006,18007,18008,18009,18010,18011,18012,18013,18021,18022,18023,18024,18025,18026,18049,18050,18051,18053,18055,18057,18059,18061,18062,18063,18064,18069,18071,18072,18073,18074,18075,18076,18077,18078,18083,18084,18085,18086,18087,18089,18090,18091,18106,18107,18109,18111,18112,18113,18114,18115,18119,18120,18121,18122,18123,18124,18125,18126,18131,18132,18133,18134,18135,18136,18146,18147,18155,18156,18182,18106) GROUP BY a.ad_id ORDER BY a.`cdate` LIMIT 20
Object dump
AdList Object ( [items] => [node] => 118 [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 = 118 AND ad.location_zip in (18001,18002,18003,18004,18005,18006,18007,18008,18009,18010,18011,18012,18013,18021,18022,18023,18024,18025,18026,18049,18050,18051,18053,18055,18057,18059,18061,18062,18063,18064,18069,18071,18072,18073,18074,18075,18076,18077,18078,18083,18084,18085,18086,18087,18089,18090,18091,18106,18107,18109,18111,18112,18113,18114,18115,18119,18120,18121,18122,18123,18124,18125,18126,18131,18132,18133,18134,18135,18136,18146,18147,18155,18156,18182,18106) GROUP BY a.ad_id ORDER BY a.`cdate` LIMIT 20
[have_error] => 1 [page] => 1 [length] => 0 )