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 (1148,1424,1546,2919,2981,4801,5352,77307,77447,78212,78687,78892,80820,80821,80895,81371,81864,81865,81866,81867,81868,81869,81870,82765,82874,82912,87079,87406,87779,87782,87783,88129,113683,89615,89718,90849,90850,90853,90855,93178,93179,93190,93192,93194,93460,95116,96778,96779,98668,98669,98670,98673,98674,98676,98772,98912,98913,98942,98943,98944,98945,98946,98948,100134,100327,100333,102562,102580,102581,102582,102583,104919,106378,106382,106383,106384,106391,106392,108828,109142,109143,109144,109145,109146,109147,109148,109149,109150,109151,109152,109153,109154,109155,109156,109158,109159,109161,109162,109163,109164,109165,109167,109741,109742,110531,110532,110533,112653,112654,112762,112763,112764,113685,113686,116097,116098,132833,116099,133774,116401,133812,119485,135384,121081,137256,121082,137279,121661,137289,121662,137290,122583,137337,122934,137348,124827,137682,125393,137683,128812,137789,128813,138217,128814,138944,128815,139424,128816,140263,128817,140264,128818,140265,128819,140429,130621,140623,130622,141104,131343,141115,131345,141116,131590,141161,132054,141162,141760,142197,142203,142437,142438,142439,142440,142441,142442,142525,142679,142715,142716,142826,142827,142828,143038,143040,143251,143554,143617,143634,143635,143791,143792,143793,143794,143795,143853,143854,143855,143856,143898,144027,144112,144113,144114,144274,144275,144321,144336,144337,144400,144401,144402,144403,144404,144405,144421,144422,144423,144424,144568,144623,144896,144907,145174)