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 (121362,121363,126921,126922,138369,139399,140555,140666,140702,140704,140705,140706,140707,140710,140711,140712,140713,140714,140716,140718,140722,140723,140724,140733,140735,140755,140757,140758,140759,140760,140761,140762,140763,140765,140766,140767,140768,140769,140770,140771,140772,140774,140775,140777,140778,140779,140780,140781,140783,140810,143937,143938,143939,143940,143941,143942,143943,143944,143945,143946,143947,144668,144671,144672,144673,144675,144729,144730,144731,144732,144733,144734,144735,144736,144742,144762,144763,144765,144769,144771,144772,147853,147854,147855,147856,147857,147858,147859,147860,147861,147862,147863,147864,147865,147866,147867,147868,147869,147870,147871,147872,147873,147874,147875,147876,147877,147878,147879,147880,147881,147882,147883,147884,147885,147886,147887,147888,147889,147890,147891,147892,147893,147894,147895,147896,147897,147898,147899,147900,147901,147902,147903,147904,147905,147906,147907,147908,147909,147910,147911,147912,147913,147914,147915,147916,147917,147918,147919,147920,147921,147922,147923,147924,147925,147926,147927,147928,147930,147931,147933,147934,147937,147938,147939,147940,147941,147942,147943,147944,147945,147946,147947,147948,147949,147950,147951,147952,148470,148471,100104,100105,100106,100107,100108,100109,137898,138169)