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 (1071,86372,12560,108375,85299,85300,85741,85992,86167,86332,86478,86479,86480,87381,83898,87777,88609,88612,88613,88614,88615,88617,93196,93197,93198,93199,93201,93204,93205,93208,97721,97724,98841,98909,98911,100149,100152,100153,100154,100155,100156,100330,106388,106389,106398,106399,106400,106869,107484,132837,107485,132838,109169,135165,109170,137684,109171,138487,109172,138488,109173,138492,109177,139478,109178,140234,140235,109181,140885,109182,140886,109183,140887,140890,109185,140894,109186,140992,109187,140993,109188,140994,109191,140995,109243,140996,140997,109245,140998,141737,140999,109247,141000,109248,141001,141003,109250,141006,141009,109252,141168,109253,141169,109256,141327,109257,141358,109258,141359,141360,110537,141445,110538,110539,142727,110540,142728,110541,142729,142730,142731,142732,112769,142733,142734,142735,142736,112986,142737,112987,142738,113384,142748,143591,113385,142760,143592,142947,143596,116399,143602,122548,142949,143611,143615,143616,143863,143864,122585,143865,143866,122587,143867,122588,143868,143869,122590,143877,126724,143880,121674,122594,129526,143882,121675,130097,143883,130098,143884,132056,143885,132057,143886,132058,143887,143888,143889,143890,143993,143995,143996,143998,143999,144000,144006,144007,144118,144334,144406,144408,144429,144440,144477,144654,145068,145223,145224,145225,4157,4158,4159,4160,110424,110425,110426)