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 (484,2087,3185,2277,2365,2366,2404,4082,4918,5139,4084,5291,587,5295,5296,589,5361,642,77446,80613,80614,700,2613,78073,78080,2926,707,710,711,3448,3672,3717,83339,1244,140482,140483,140484,140485,140486,140487,1250,140488,1312,3845,1314,141057,4095,1406,4662,1407,4664,1408,1409,1410,1411,5187,5188,5189,5190,5322,5370,5371,5372,103801,76305,76307,76308,76309,76680,76811,1727,77077,77433,77991,78487,78516,122649,81342,86127,87074,87087,87089,87090,87092,87093,87095,87098,87863,1850,87866,87868,87869,87870,88062,88063,88072,88073,88542,132686,89259,133060,89260,133359,133646,133912,134271,134273,137102,89692,137377,90235,137436,137965,90237,138082,138549,138564,91726,138709,91727,138950,92133,138951,138953,138955,138958,92616,138962,143607,92617,138963,143621,92674,138964,143688,139398,143756,93210,140317,143768,93375,140332,143858,93454,140462,143949,93114,140499,144020,144062,144225,95119,144241,95120,144561,144572,95876,144591,95877,144593,144626,140554,144636,140564,144637,97727,140569,144641,97911,141071,144643,97912,141099,144890,98714,141217,145097,98718,141249,145217,98954,141251,145258,141473,145265,141538,145266,100685,141539,145268,100689,141574,141580,102259,141584,141766,141768,141769,141770,141796,141810,142275,102710,142331,142407,142408,142413,142430,142457,142708,104822,142773,142778,142854,143020,143137,143218,143219,105356,106037,106038,106040,107210,107211,107495,107496,107497,107498,107902,108784,110704,109927,111094,111097,114001,116825,118082,119520,119521,120254,120879,121097,121341,121647,122054,122383,124387,125298,126165,126722,127211,127212,127706,128182,128380,128384,128385,128386,128387,128646,128647,128648,128649,130101,130537,130540,130541,130542,130953,130954,131290,131595,132273,98851)