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 (530,643,703,2609,3485,3738,3851,3852,3853,3854,3855,3856,3857,3858,3859,3860,3861,3862,1158,3863,1159,3864,3865,3866,3867,3868,3869,3870,3871,3872,4085,4693,4839,4841,4842,4850,4955,1485,1521,1522,88392,1523,1524,1525,1526,1527,1528,1529,4988,4989,4990,4991,4992,4993,4994,4995,4996,4997,4998,4999,5000,5001,5002,5003,5004,5005,5006,5007,5008,5009,5010,5363,133647,136779,76554,137224,76555,138076,76556,138952,76557,140551,76558,141215,76559,141812,76560,141813,76561,141814,76562,141815,76563,141816,76564,141817,143720,142616,144061,144063,76567,144065,76568,144644,76569,144646,76570,76571,76572,76573,76574,76575,76576,76577,76578,76579,76580,76581,76582,76583,76584,76585,76586,76587,76588,76589,76590,76591,76592,76593,76594,76595,76596,76597,76598,76599,76600,76601,76602,76604,76605,76607,76608,76609,76611,76612,76613,76614,76615,76616,76617,76618,76619,76620,76621,76622,76623,76624,76625,76626,76627,76628,76629,76630,76631,76633,76634,76635,76636,76639,76640,76642,76643,76645,76646,76647,76650,76649,76651,76653,76656,76660,76663,76664,76666,76687,76729,76730,76731,76732,77386,77389,77390,77391,78239,78240,83750,87075,87531,87867,89992,90933,93103,95368,95369,95370,95371,98908,100272,105028,108210,111589,111592,115957,119680,123414,125857,128383,129713,129714)