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 (3411,3412,78800,82872,78801,82873,78802,2014,2986,2015,2987,3224,4802,7690,2016,78688,81195,1153,2017,3700,78689,77922,76428,131457,102601,102604,131481,1489,1544,80896,80897,81449,81871,81872,81873,81874,81875,81876,81877,82759,83865,86166,86627,86977,87409,88616,88623,88624,88627,93461,94521,94522,94523,94524,94525,94526,98677,98678,98679,98773,98947,98981,100150,100325,100326,100329,100331,100332,106385,106386,106390,106962,109168,109189,109196,109198,109199,109200,109201,109202,109203,109204,109241,109259,109260,109261,109262,109273,109274,109293,110542,110543,110544,112770,112771,112772,112786,119486,132835,121660,132926,132927,122547,133582,122549,133682,122550,133683,133684,122556,133816,134016,122558,137282,122559,137323,122560,137332,122593,131455,138945,131456,139310,131479,139849,131480,139850,140249,140624,140893,141734,142198,142739,142740,143599,142741,143605,143878,143891,143892,143979,143989,143990,143991,144003,144004,144005,144247,144257,144258,144259,144333,144720,144721,144722,145033,145042)