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 (78509,121012,1073,14,3312,3314,1063,3973,3974,5033,5038,5040,7660,76402,77417,77526,80431,80519,82314,80543,81194,82326,82329,82332,82333,132690,134312,137372,137427,137692,138232,138415,138442,138783,139293,139312,139330,139331,139678,139679,140120,140402,140405,140406,140650,140674,140675,140703,140728,140729,140745,140746,140747,83667,140748,140749,140750,140751,140752,140753,140754,140787,140812,140813,140842,140846,140853,140874,141281,141969,142466,142575,142580,142713,87382,89730,98997,98998,98999,99000,99002,99004,99005,99006,99009,99011,99015,99019,99025,99029,99030,99033,99034,99035,99036,99042,99043,99044,99047,99049,100199,100200,100201,100247,100870,105993,107200,107201,103898,107202,110422,110423,110581,117366,119773,120890,120892,120893,120894,120938,120939,120941,120942,120943,120944,120946,120949,120953,121010,121364,121365,121372,121373,121374,121375,121499,121835,121836,121837,121838,121839,121840,121841,121842,121843,121844,121845,121846,121847,121848,121849,121850,121851,121852,121853,121854,121855,121857,121858,121859,121860,121861,125870,143478,128864,143518,128865,143566,129670,143936,77073,144596,78513,144597,116136,144598,123938,144599,145237,86333,100148,116702,141799,116703,141800,143198,143199,143200,143201,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,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,719,718,717,716,715,713,125855,125856,125944,113391,118853,118856,118857,118876,119646,119647,124573,119824,119825,119826,119827,119828,139540,132011,139541,139542,139543,139544,139545,139546,139547,139548,139549,139584,139585,139586,139587,139588,139589,139590,139591,139592,139593,139594,139595,139596,139597,139598,139599,139600,139601,139602,139603,139604,139605,139606,139607,139608,139609,139610,139611,139612,139613,139614,139615,139616,139617,139618,139684,139685,139686,139687,139688,139689,139690,139691,139692,139693,139694,139695,139696,139697,139698,139699,139700,139701,139702,139703,139704,139705,139706,139707,139708,139709,139710,139711,139712,139713,139714,139715,139716,139717,139718,139719,139720,139835,141880,141881,141882,141883,141884,141885,142923,143757,143974,116977,116982,116990,117010,117014,117015,117036,117058,117065,117097,117104,117105,117106,117109,117126,117144,117145,117146,117147,117148,117149,117150,117155,117156,117894,117904,117905,117946,117959,117984,117985,117986,117993,118018,118019,138269,138270,138271,138272,138273,138274,138275,138276,138277,138278,138279,138280,138281,138282,138283,138284,138285,138286,138287,138288,138289,138290,138291,138292,138293,138294,138295,138296,138297,138298,79147,138299,138300,138301,138302,138303,138304,138305,138306,138307,138308,138309,80515,80516,80540,83261,84465,5039,88600,88601,88602,88603,88604,88605,90916,90917,90918,90927,133138,133139,133146,133205,133206,133207,133208,134095,134126,134134,134159,134160,134161,134179,134180,134181,134182,134183,134184,134189,134190,134197,134202,134203,134204,134205,137669,137670,137671,137672,137673,137674,137675,137676,137677,137678,107016,137679,107017,140784,140785,140786,140815,140816,140817,140818,140819,140820,140844,140849,140851,140866,140871,141458,141459,141460,141837,141838,141839,141842,141848,141849,115498,141850,115499,141851,115500,141852,141853,141887,141889,141890,141891,141892,141893,141894,141895,141896,119867,141897,121003,141898,121004,141899,121005,141900,141901,121360,141902,125851,141903,141904,141905,129947,141906,129948,141907,129949,141910,132006,141911,141912,141913,141914,141915,141916,141917,141918,141919,141927,141928,141929,141931,141932,141934,141935,141936,141937,141938,141939,141940,141941,141942,143569,141943,144132,144918,141944,145228,141945,143476,141946,143477,141947,141952,138163,87657,113399,135603,140773,121011,140854,140855,140856,140857,140858,140859,140864,140865,140867,140869,140870,144737,144738,144739,144740,144747,144748,144749,144750,144751,144752,144766,100063,141428,137374,137429,142876,142465,87383,87384,87386,119771,132016,121362,121363,126921,126922,129954,138369,139399,140555,140666,140702,140704,140705,140706,140707,140710,140711,140712,140713,140714,140716,140718,140722,140723,140724,140733,140735,140755,140757,140758,140759,140760,140761,140762,140763,140765,140766,140767,140768,140769,140770,140771,140772,140774,140775,140777,140778,140779,140780,140781,140783,140810,143937,143938,143939,143940,143941,143942,143943,143944,143945,143946,143947,144668,144671,144672,144673,144675,144729,144730,144731,144732,144733,144734,144735,144736,144742,144762,144763,144765,144769,144771,144772,100104,100105,100106,100107,100108,100109,137898,138169,117367,117368,117369,117370,117371,117372,117373,117374,117375,117376,117377,117378,117379,117380,117381,117382,117383,117384,117385,117386,117387,117388,117389,117390,117391,117392,117393,117394,117395,117396,117397,117398,117399,117400,117401,117402,120147,120955,120956,120957,120960,121672,134094,138220,140300,140301,140302,140374,140375,140376,140377,140378,140379,140380,140381,140382,140383,140384,140385,140386,140387,140388,140389,140390,140391,140392,140393,140394,140395,140396,145226,140397,141447,142674,140299,119830,119831,119832,119833,119834,119835,119836,119837,119838,119839,119840,119841,119842,119843,119844,119845,119846,119847,119848,119849,119850,119851,119852,119853,119854,119855,119856,119857,119858,119859,119860,119861,119862,119863,119864,119865,119866,143542,143543,143544,143545,143546,143547,143548,143549,143550,143551,143552,133137,101705,107020,141878,141879,142663)