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 (84447,84448,84460,84462,88533,88534,88540,90919,93530,93531,93553,93566,95464,95466,95467,95468,95469,95470,95471,95472,95473,95474,95475,133241,95562,134852,137547,135160,137548,137549,137550,137551,137552,137553,137554,137555,137586,137587,137588,137589,137603,137604,137605,137642,137643,137644,137645,137646,137647,96708,137648,98765,137649,98964,137650,137651,137652,137653,137833,137834,137835,101473,137836,101929,137837,137838,137839,137840,137841,137842,137843,137844,137850,137852,137853,137854,137855,137856,137857,137858,137859,137860,137861,137862,137863,137864,137865,106590,137866,106591,137867,137868,137869,137870,137871,137872,137946,138105,138112,138113,106601,138125,106605,138131,107019,138132,138137,138139,108053,138141,108056,138142,110406,138146,110407,138480,110408,138251,138252,110410,138253,138254,138255,138256,138257,138258,138259,138260,138261,138262,112175,138263,112176,138264,138265,138266,138267,138268,119822,138310,119823,138320,120299,138397,120300,138398,138401,125622,138402,125633,138403,125639,125785,138494,138495,138496,125833,138497,125842,138498,138499,138500,126874,138501,138502,126876,138503,126877,138504,127302,138505,127304,138506,129516,138507,129517,138508,129518,138509,129519,138510,129520,138511,129521,138512,129522,138513,129523,138514,138515,132132,138516,132133,138517,132134,138518,132135,138519,132136,138520,138521,138522,138523,138524,138525,138932,139408,139422,140298,140308,140309,140310,140311,140312,140313,140314,140315,140606,140898,140899,140900,140901,140902,140903,140904,140905,140906,140907,140908,140909,140910,140911,140912,140913,140914,140915,140916,140917,140918,140919,140920,140921,141432,141442,141443,141444,141446,141824,141856,141924,141925,141950,142373,142374,142375,142376,142377,142378,142379,142380,142381,142488,142489,142491,142492,143362,143479,142668,143480,142877,143481,142878,143482,142879,143483,142985,143484,143485,144133,144540,144541,144805,144814,144835,145133,145148,145149,142494,100007,100008,100009,138151,138152,138153)