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 (1914,3310,5031,5032,77531,77532,77533,82307,82308,82309,82310,82311,82312,84439,93522,93524,93525,93526,93527,93528,93529,93532,93533,93535,93537,93538,93539,93540,93541,93542,93543,93544,93546,93547,93549,93551,93552,93555,93556,93557,93558,93559,93561,93562,93563,93564,93567,138665,93568,138666,93569,93570,93571,138669,93572,138670,93573,93574,93575,93576,93577,138675,93578,93579,93580,93581,138679,93583,138680,93584,138681,93585,93586,138683,93587,138684,93588,138685,93589,138686,138687,138689,93593,138690,138691,138692,93596,138693,138694,138120,93601,138121,93602,93604,93605,93606,93607,93608,93823,138161,138164,138165,98737,98738,98739,98740,98741,98742,98743,98744,98745,98746,98747,98748,98749,98750,98757,98760,98764,98766,100159,100240,101682,101693,101694,102657,102658,102659,102660,104849,105033,105034,105036,105037,105038,105040,106677,106678,106679,106680,106681,107014,107015,107018,107326,108094,108095,108096,108097,108098,108099,108100,108101,108102,108103,108104,108105,108106,108107,108108,108109,108110,108111,108112,108113,108114,108115,108116,108117,108118,108119,108120,108121,108122,108123,108124,108125,108126,108127,108128,108129,108130,108131,108132,108133,108134,108135,108136,108137,108138,108139,108140,108141,108142,108143,108144,108145,108146,108147,108148,108149,108150,108152,108153,108157,108164,110078,110079,110082,110083,110084,110085,110086,111544,111545,112281,112284,112286,132762,132763,115228,133449,115338,133450,115339,133685,115340,134090,115341,134091,115342,134155,115343,134156,115344,134157,115345,134158,115346,134162,115352,134163,115353,134164,115354,134165,115355,134166,115356,134167,115357,134168,115358,134192,115359,134207,115360,134208,115361,134211,115362,135388,115363,135389,115364,135390,115365,115366,115367,115368,115369,115370,139296,115371,139297,115372,139298,115373,139299,115374,139300,115375,139301,115376,139302,115377,139303,115378,139304,139305,139306,115381,139339,115382,139340,115383,139341,115384,139342,115385,139343,115386,139344,139345,139346,139347,139348,115391,139349,115392,139350,115393,139351,115394,139352,115395,139353,115396,139354,115397,139355,115398,139356,139357,115400,139358,115401,139359,115402,139360,115403,139361,115404,139362,115405,139363,115406,139364,139365,115408,139366,115409,139367,115410,139368,115411,139369,115412,139370,139371,139372,139373,139374,139375,139376,139377,139378,139379,139380,139381,139467,139468,139469,139470,139471,139472,115430,139473,139474,139475,115433,115434,115435,115436,115437,115450,115452,115453,140365,140366,140367,140410,115457,140731,141146,141175,141176,141177,141178,141179,141265,141266,141417,141418,141469,141859,141860,141861,141862,141863,141865,141866,141867,115478,141868,115479,141870,141871,141872,141873,143488,141874,144310,141920,144860,141921,144919,141922,144920,115487,141953,144921,141957,144922,115489,141958,144923,115490,141959,144924,115491,141960,144925,115492,141961,144926,141962,142517,144927,142670,144928,142706,144929,115496,143122,144930,115497,143125,144931,115512,144932,115513,144933,115514,144934,115515,144935,118795,144936,119868,144937,144938,144939,121285,144940,144941,121361,122773,144943,144944,144945,144946,144947,144948,144949,144950,144951,144952,144953,144954,125640,144955,125641,144956,125829,144957,126111,144958,145073,145074,145075,145076,145086,145088,145091,127283,145210,127284,145239,127285,127286,127305,132008,132013,132015,132017,132123,132124,132125,132126,132127,2336,99850,139860,123942,123946,123948,123952,123953,123954,123955,123956,123957,123958,123959,123981)