SELECT t.id AS torgid, t.result, t.shemaid, t.lotid, t.price, t.minimal_price, t.public_outprice, t.discont, ext.lot, t.requestbegin, t.requestend, t.aucbegin, t.aucend, sc.id, sc.pagetitle AS name, FROM_UNIXTIME(sc.publishedon, '%Y-%m-%d %H:%i:%s') AS publishedon, ext.owner AS owner_id, owners.pagetitle AS owner, ext.region AS region_id, regions.pagetitle AS region, ext.district AS district_id, districts.pagetitle AS district, ext.locality, ext.city, n.nds_s, res.status, sh.shema, ms2.thumb, hitstv.value AS hits FROM modx_auc_torgi t INNER JOIN ( SELECT lotid, MAX(id) AS max_id FROM modx_auc_torgi GROUP BY lotid) AS last_t ON t.id = last_t.max_id INNER JOIN modx_site_content sc ON sc.id = t.lotid LEFT JOIN modx_site_content_extend ext ON ext.id_content = t.lotid LEFT JOIN modx_site_content owners ON owners.id = ext.owner AND owners.template = 15 LEFT JOIN modx_site_content regions ON regions.id = ext.region AND regions.template = 14 LEFT JOIN modx_site_content districts ON districts.id = ext.district AND districts.template = 13 LEFT JOIN modx_auc_nds n ON n.id = t.ndsid LEFT JOIN modx_auc_results res ON res.id = t.result LEFT JOIN modx_auc_shema sh ON sh.id = t.shemaid LEFT JOIN modx_ms2_products ms2 ON ms2.id = sc.id LEFT JOIN modx_site_tmplvar_contentvalues hitstv ON hitstv.contentid = t.lotid AND hitstv.tmplvarid = 33 WHERE sc.template = 4 AND sc.published = 1 AND sc.deleted = 0 AND sc.id IN (2612,2080,2614,2811,3122,3157,3186,3188,122546,4083,3439,3737,588,3780,648,4665,5057,5270,5314,5315,5366,5367,5369,77000,12540,699,78740,77886,701,76302,76303,704,76735,76736,76737,77887,76738,76740,76742,76744,76745,76747,76748,76749,76989,76990,77116,83748,77117,77118,77119,83229,77120,77345,83749,77346,77445,77892,77893,77894,78634,1309,1310,1311,1755,77264,81144,81819,83033,83230,83231,83340,95020,83752,83753,87086,87536,87537,87539,87865,88064,89538,136776,91725,136777,91728,136778,92410,103803,137307,137378,137742,93097,137745,93111,137749,93112,137810,93113,137811,137910,137960,137995,138085,95018,138526,138956,138959,138960,97913,138961,139394,140118,98974,140481,100164,100687,140943,100688,141121,141243,102307,141250,141252,141310,103279,141528,143290,103280,141529,143308,141606,143680,103282,142277,143681,103283,142278,142390,143682,142428,143709,142429,143713,127872,142681,143750,143797,142796,143921,143048,143950,143083,143951,106041,143113,144057,143171,144058,144059,107208,144340,107543,144592,144605,144621,144625,144640,108668,144645,108786,145218,109737,109738,110834,115010,116824,116826,118278,118280,120508,120509,89546,137016,90934,125858,125859,125860,125861,126919,127204,127308,128378,93110,128650,129942,130102,95019,142792,105425,110436,120052)