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 = 102 AND ad.location_zip in (65001,65002,65003,65004,65005,65006,65007,65008,65009,65010,65011,65012,65013,65014,65015,65016,65017,65018,65019,65020,65021,65022,65023,65024,65025,65026,65027,65028,65029,65030,65031,65032,65033,65034,65035,65036,65037,65038,65039,65040,65041,65042,65043,65044,65045,65046,65047,65048,65049,65050,65051,65052,65079,65080,65081,65082,65083,65084,65085,65089,65090,65091,65102,65103,65139,65140,65141,65142,65143,65144,65145,65146,65147,65148,65149,65150,65151,65152,65153,65154,65155,65156,65157,65158,65159,65160,65161,65162,65163,65164,65165,65166,65167,65168,65169,65173,65174,65175,65176,65177,65178,65179,65180,65181,65183,65185,65187,65189,65191,65193,65195,65197,65199,65201,65203,65205,65207,65208,65212,65218) GROUP BY a.ad_id ORDER BY a.`cdate` LIMIT 20
Object dump
AdList Object ( [items] => [node] => 102 [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 = 102 AND ad.location_zip in (65001,65002,65003,65004,65005,65006,65007,65008,65009,65010,65011,65012,65013,65014,65015,65016,65017,65018,65019,65020,65021,65022,65023,65024,65025,65026,65027,65028,65029,65030,65031,65032,65033,65034,65035,65036,65037,65038,65039,65040,65041,65042,65043,65044,65045,65046,65047,65048,65049,65050,65051,65052,65079,65080,65081,65082,65083,65084,65085,65089,65090,65091,65102,65103,65139,65140,65141,65142,65143,65144,65145,65146,65147,65148,65149,65150,65151,65152,65153,65154,65155,65156,65157,65158,65159,65160,65161,65162,65163,65164,65165,65166,65167,65168,65169,65173,65174,65175,65176,65177,65178,65179,65180,65181,65183,65185,65187,65189,65191,65193,65195,65197,65199,65201,65203,65205,65207,65208,65212,65218) GROUP BY a.ad_id ORDER BY a.`cdate` LIMIT 20
[have_error] => 1 [page] => 1 [length] => 0 )