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 (670,1977,2221,2481,2552,2600,2924,2945,3037,4099,84418,4573,4574,4575,1107,4576,91712,1120,4577,97717,98991,4579,98992,4581,4582,4585,4777,4785,4805,4855,7723,12556,76912,76975,1421,1422,77054,77055,1547,78235,78302,78450,78686,78744,78791,78794,78795,80661,80822,80823,81155,81338,81339,81340,81879,82122,82220,82472,82620,82908,82913,82914,83787,85396,85452,85453,85463,85551,85830,86946,87077,87393,88050,88393,88394,88607,88608,89543,89614,89616,89637,89733,91101,91730,93462,93681,94886,95185,95628,97709,98664,98842,98868,100160,100323,100324,102549,102571,102579,102605,105215,105784,105977,106379,106380,106960,106968,107213,107483,108607,108608,108609,108610,108611,108826,109009,109176,109197,109292,109320,110320,110861,110862,111547,112004,113386,113389,113757,116402,117162,117444,117848,117977,118071,118075,118076,118077,118078,118079,118180,118223,119189,119195,119780,120010,120148,120658,121095,132657,121862,132764,133654,133655,134044,135134,125783,127053,136911,126561,127055,136923,127202,137053,127258,137054,127516,137439,127517,137540,128303,137790,128348,137791,128349,138187,128376,138470,138539,129201,138786,129290,138941,130960,138943,131453,139007,131454,140239,131458,140252,131460,140253,131461,140254,131466,140255,131467,140256,131468,140510,131469,140532,131470,140533,131471,140534,131472,140620,131473,140631,131474,141102,131475,141163,131476,141213,131477,141500,131671,141501,132279,141691,141708,141743,142300,142416,142443,143252,142755,143257,143502,142864,143557,143034,143558,143812,143813,143840,143916,143972,143973,143977,144032,144119,144248,144249,144250,144251,144311,144433,144703,144996,145173,76974,78389,78391,143971)