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 (80342,80344,3955,88599,88619,2660,3915,3916,3917,12532,76334,76335,76337,76338,76341,76830,76831,76833,77273,78077,78078,78079,78154,78155,78156,128808,80345,81773,81814,81815,82012,82013,82452,83078,83079,83080,83081,83897,84212,84310,85742,85993,86125,88618,88625,88611,88620,93185,88621,93186,93188,93191,95543,98910,98949,98950,100328,102209,106387,106574,106575,106576,106823,106864,132723,132724,108825,132725,108827,132836,109190,133362,109254,133363,110399,133680,110530,133681,110535,133775,110536,133776,112655,134270,113370,134443,113371,134619,115336,134620,117287,134621,118320,134924,135004,122592,135164,123887,135238,123888,135239,137240,124829,137241,137252,127350,127351,137381,127574,137382,127575,137466,137685,130496,137806,130497,137807,130619,137917,130620,138197,131288,138485,131712,138486,132053,138489,132055,138490,132059,138491,138819,139851,139852,140231,140232,140233,140266,140658,140881,140882,141508,140884,141509,140888,141510,140889,140891,140892,140954,140991,141004,141005,141055,141326,141354,141506,141507,141522,141601,141622,141657,141658,141733,141735,141736,142199,142294,142444,142468,142469,142470,142476,143593,142761,143594,143073,143711,143074,143732,143740,143774,143776,143777,143778,143779,143862,143870,143871,143873,143874,143875,143876,144117,144418,144419,144420,144434,144435,144888,144908,145154,145172,145212,145220,4005,76361,78749)