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 (2554,2953,2135,2423,4079,2630,3130,3134,4369,3135,3463,3464,76304,3831,3842,4088,76889,76669,4753,76670,77300,77312,7663,7664,77491,77880,78638,7665,7666,7728,702,7729,7730,7733,7734,76521,1075,1077,76988,76997,76998,76999,77933,77934,77935,78250,1112,83637,78549,78726,78742,78907,137121,78921,81818,83237,84284,84286,87864,90260,90938,90939,90940,91713,91714,93388,94044,102709,1444,98898,98899,98900,103058,1479,98901,98902,98903,98904,98905,136774,112472,112473,112474,100274,100318,102306,1750,106876,1751,107579,120149,140545,107901,1753,108886,120456,109005,120885,109006,109007,109102,122580,124612,111307,132271,112689,112785,114919,114920,114921,114922,114923,114924,114925,114926,114927,114928,1848,114929,114930,115305,116375,116376,116377,116378,116379,88402,116380,88403,116381,116382,116383,116384,116385,116386,116387,132839,116388,116389,116390,132623,116391,132624,116392,132625,116393,116394,133055,116395,133063,116827,133064,116828,133065,116829,133328,116830,133547,134732,134957,118318,135132,118319,118324,137722,119669,137975,119670,137991,119671,137992,119672,137993,119673,137994,140296,119675,137997,119676,137998,119677,137999,119678,138192,119679,138193,119682,138789,119683,139335,119684,140102,119685,140615,119778,140957,141315,141320,120884,141329,141334,121281,141345,121458,141346,141623,121459,141625,121460,141626,121461,141794,121462,141795,143372,121463,142206,143466,121464,142279,143467,121465,142371,143504,121466,143506,121467,142702,143663,121468,142788,143670,121469,142812,143722,144230,121470,144301,121471,142997,144513,121472,143006,144642,121473,143007,145007,121474,143104,145008,121475,143105,121476,143128,121477,121478,121479,121480,121481,121482,121483,121484,121485,121486,121487,121502,122432,122579,123882,125290,125291,125292,125945,127205,127206,127207,127208,127209,127210,128027,128030,130022,130103,131592,131706,132282)