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 (523,2820,2560,3121,2218,2425,3155,4765,4852,2222,4661,1949,2559,3147,12543,12544,12545,76751,76752,76753,5271,76686,78632,77313,705,77178,709,82875,80894,81095,81311,76750,85418,86000,87085,87387,83751,87504,88880,83341,133057,133068,134272,137120,1242,137123,137891,86002,137933,1245,97910,137959,1246,98594,137984,98681,138708,138860,98852,139923,98853,139930,98897,140084,140928,100271,140933,140934,140935,140936,140937,140938,140984,141124,141128,1402,141132,1403,141133,1404,106228,141134,1405,106229,141135,106577,141136,106870,141137,141138,101544,141139,101545,141216,101546,141241,101547,108214,110351,141242,1426,141312,141618,111591,141619,141669,141729,141811,141820,142312,142409,142411,143245,142412,143258,142432,143376,142506,143469,142698,143561,112475,142837,76306,112426,112476,142938,144060,143050,144064,113288,144108,144173,144638,144647,114000,116864,118574,120046,120453,120461,121342,122431,122577,126430,78633,127309,127867,128381,128424,128803,130955,131452,131929,131930,131967,131968,132272,93102,140552,142431)