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 (466,660,661,662,1869,663,1873,1981,1241,1308,1330,1419,3075,3076,3077,1471,1549,1551,78782,1973,1974,1759,2092,2093,2269,124963,2299,2300,3256,2482,2494,2942,2943,2944,3038,3039,3079,3160,3164,127854,127855,3267,3404,3421,76689,3422,3423,137775,3424,3425,3426,3427,3428,76797,3576,3667,3669,77129,3697,3732,4097,4631,4632,4633,4639,4642,4643,4666,4644,4668,4854,4857,4920,5260,7721,76349,76350,76351,76417,76419,76493,76699,76700,76917,76701,76921,76857,76932,76933,76884,76934,76860,76885,76935,76936,76937,77041,77047,77048,77049,77053,77127,77057,77226,77227,77228,77229,77230,77231,77234,77235,77236,77237,77242,77246,77247,77248,77249,77251,77255,77281,77397,77398,77400,77406,77888,77889,77898,77908,77926,77927,77984,78206,78208,78211,78213,78216,78303,78314,78354,78356,78357,78358,78359,78360,78361,78362,78363,78364,78365,78366,78367,78368,78369,78370,78374,78375,78376,78377,78378,78379,78380,78381,78382,78383,78384,78385,78386,78439,78605,78606,78683,78684,78685,78690,78691,78692,78693,78694,78695,78696,78697,78698,78743,78789,78790,78931,79008,79012,79110,80346,80347,80348,80349,80350,80351,80353,80356,80357,80583,81373,81383,81384,81385,81386,81387,81388,81390,81394,81395,81438,81448,81453,81454,81455,81764,81853,81854,81859,81863,81983,82213,82214,82215,82216,82217,82219,82284,82285,82286,82845,83375,83379,84417,83824,85295,85296,85297,85390,85391,85392,85400,85404,86628,86755,87059,87073,87101,87148,87400,87401,87402,87403,87404,87518,87519,87520,87522,87523,87524,87525,87526,88066,88128,88229,88395,88883,89860,89861,90241,90242,90244,90245,90246,90247,126421,90528,90550,90857,127259,91455,92117,92246,92675,92888,92889,92891,92892,92893,92894,92896,92898,92900,92903,93173,93455,93457,93458,93459,93745,93746,93747,93748,94286,94287,1710,1711,1712,1713,94885,95112,97641,97643,97644,97712,98038,98039,98040,98056,98855,98862,98865,98869,98917,98918,98919,98979,100130,100137,100141,100158,100917,100918,101203,102161,102162,102563,102564,102568,102569,102586,102587,102588,102590,102591,102593,103262,103269,103811,104214,104215,104216,104217,104218,104219,104221,104222,104375,104376,104377,104378,104769,104913,104914,105031,105205,105206,105207,106226,106393,132907,106397,132908,107491,132928,132929,132930,107899,133092,133613,108201,133614,133615,108205,133616,133617,133677,133808,109268,133811,109270,133817,109275,133845,134577,109284,134578,109285,134579,134581,134582,109386,134583,134584,134585,110694,134586,110697,134587,110827,134588,110845,134589,110846,134590,110847,134591,110848,134592,110849,110850,134594,110853,134595,110856,134596,110859,110860,134598,110872,134600,134601,110917,134602,111061,134603,111062,134604,111063,134605,134606,112001,134607,112002,112777,134609,113220,134610,134611,113868,134612,134613,114917,134614,115229,134615,115801,134616,134617,116700,134623,116865,134624,134625,117167,117330,134626,117403,134627,117404,134629,117405,134630,117406,134631,134632,117916,134633,117917,134634,118072,134635,119184,134636,119185,134637,119186,134638,119187,134639,119188,134640,119191,134641,119192,134642,119471,134643,134644,134645,120251,134646,120459,134647,120460,134648,120462,134649,120576,134650,120577,134651,120582,134652,121079,134653,121101,134654,121102,134655,121345,134656,121347,134657,121489,134658,121491,134659,121492,134660,121494,134661,121495,134662,121496,134663,134849,135381,122251,136771,136902,122253,136903,137212,137005,137027,137216,122578,137028,137218,122595,137029,137246,123219,137247,124675,137258,137287,137288,137341,137433,126518,137741,126519,137774,137782,137783,127708,137784,127709,127856,137793,127857,127858,127859,137814,137815,127916,137816,137927,128183,137928,128322,137954,128324,138175,128337,128338,138316,128967,138180,138336,129287,138343,129288,138352,130292,138353,131292,138567,131293,138791,131294,138792,131335,138795,138838,131459,138839,131485,138855,131722,138856,131769,139307,132432,139308,139477,132433,139309,139809,132434,139810,132435,139905,132499,140092,140250,140433,140434,140435,140444,140508,140509,140897,140949,140963,141106,141108,141111,141112,141113,141118,141219,141318,141452,141476,141498,141503,141543,141544,141545,141546,141547,141548,141549,141550,141551,141552,141553,141554,141555,141556,141646,141675,141695,141696,141697,141702,141703,141748,141751,141782,141783,141784,142283,142569,142572,142691,142832,142868,142888,142889,142890,142932,142943,142958,142960,142961,142962,142963,142969,142988,142989,143015,143041,143019,143042,143044,143630,143045,143631,143086,143632,143090,143689,143091,143716,143092,143746,143102,143747,143191,143752,143192,143761,143194,143782,143195,143783,143196,143787,143234,143810,143811,143835,143843,143900,143968,144002,144034,144035,144036,144037,144055,144082,144237,144280,144284,144285,144289,144290,144291,144292,144293,144299,144300,144302,144313,144390,144395,144511,144650,144727,144960,144997,144999,145000,145010,145011,145012,145013,145026,145027,145028,145029,145030,145031,145032,145103,145107,145171,145180,145201,145203,145207,145214,145248,145250,145259,145272,145273,145277,145281,145282,145283,145315)