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 (81862,77082,89618,3683,98867,102595,102597,102599,102600,105212,105213,104389,1844,109314,109321,113376,113377,1843,113378,113379,121501,124676,1838,124955,1839,124956,1840,124957,1841,124958,1842,124959,124960,124961,124962,127967,128323,121729,138356,128372,140331,128373,140411,128374,141713,128375,142965,142966,142967,142968,84478,132924,138092,144043,77074,128357,128358,77069,98856,140455,132500,88834,76352,78372,78373,3177,81399,87056,90243,94884,95696,119194,137214,128809,78371,120578,120579,120581,131295,131296,131297,132841,137000,104379,104380,104381,104382,1878,4695,83376,3699,4803,77399,90548,77913,93171,90547,101204,109313,109740,1329,110868,119429,137698,121088,142341,143101,144183,144396,144432,2484,3080,78774,78785,76443,81400,82922,82923,1469,82924,82925,83377,86625,90522,90523,90524,90546,95113,97642,98041,98042,98043,98044,98045,98046,98047,98048,98049,98050,98051,98052,98053,98054,98659,102565,102598,141759,102602,141761,102603,143833,104918,143836,106687,106690,125395,125396,125827,131344,131889,131890,664,666,1102,3040,3041,3431,78755,81277,81389,1297,92118,98921,1326,92119,1327,76494,76915,76916,1464,80354,4098,80824,81391,81397,81401,81412,81413,4807,81441,76920,81442,81443,83380,87057,87527,87528,88067,88884,92120,92121,92122,92123,95114,95115,98920,113374,134703,137213,117408,137924,137925,98870,125392,137926,127724,137929,138573,141107,141752,141786,142692,142693,142705,142834,145018,145019,145020,145021,145022,145023,145024,145025,665,3698,4637,77056,77128,2495,85398,1239,85403,2921,3429,142188,3430,3432,3433,4645,4646,4724,1554,4798,4799,77897,78215,78313,78608,78637,79010,81392,81393,81396,81398,89611,89717,93174,98860,98866,100131,102570,102596,104916,104917,133814,105211,134774,136912,109387,137217,110869,137324,112985,137327,117407,137334,119190,120337,137792,139476,141218,121085,141347,141478,121093,121094,143095,143844,122597,143097,144041,122599,144042,127860,144056,128353,144266,128354,144267,128355,144583,128356,145003,131486,145005,131716,145017,145040,1721,669,3299,85548,108202,133815,2496,143043,144008,128370,144263,128371,145041,131462,131729,1719,1482,1483,4667,4669,81402,81403,81404,81405,81406,81407,81408,81409,81410,92899,82871,85292,90545,106396,109280,109289,109290,133846,109291,135304,135305,135306,109315,135307,110870,137021,111998,138011,111999,138012,112000,140453,120143,140454,122598,141160,127861,141164,127862,141165,131488,141479,131717,142187,131718,142200,142445,142511,142745,142746,142747,142824,143639,143788,143789,144120,144392,144394,144430,144431,145039,145101,145102)