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 (1836,1837,1832,1833,87340,1834,88597,1835,88598,88606,96216,96777,100322,142945,106867,109174,109175,109294,110546,110547,112344,140230,112773,140236,112780,140237,112781,140238,113372,140240,113373,141061,141170,141357,113999,141365,116398,142750,143595,118321,143728,143790,143796,143893,144325,122565,144326,131336,144327,131337,144328,144604,121673,2916,2917,112775,1071,86372,12560,108375,85299,85300,85741,85992,86167,86332,86478,86479,86480,87381,83898,87777,88609,88612,88613,88614,88615,88617,93196,93197,93198,93199,93201,93204,93205,93208,97721,97724,98841,98909,98911,100149,100152,100153,100154,100155,100156,100330,106388,106389,106398,106399,106400,106869,107484,132837,107485,132838,109169,135165,109170,137684,109171,138487,109172,138488,109173,138492,109177,139478,109178,140234,140235,109181,140885,109182,140886,109183,140887,140890,109185,140894,109186,140992,109187,140993,109188,140994,109191,140995,109243,140996,140997,109245,140998,141737,140999,109247,141000,109248,141001,141003,109250,141006,141009,109252,141168,109253,141169,109256,141327,109257,141358,109258,141359,141360,110537,141445,110538,110539,142727,110540,142728,110541,142729,142730,142731,142732,112769,142733,142734,142735,142736,112986,142737,112987,142738,113384,142748,143591,113385,142760,143592,142947,143596,116399,143602,122548,142949,143611,143615,143616,143863,143864,122585,143865,143866,122587,143867,122588,143868,143869,122590,143877,126724,143880,121674,122594,129526,143882,121675,130097,143883,130098,143884,132056,143885,132057,143886,132058,143887,143888,143889,143890,143993,143995,143996,143998,143999,144000,144006,144007,144118,144334,144406,144408,144429,144440,144477,144654,145068,4157,4158,4159,4160,110424,110425,110426,3411,3412,78800,82872,78801,82873,78802,2014,2986,2015,2987,3224,4802,7690,2016,78688,81195,1153,2017,3700,78689,77922,76428,131457,102601,102604,131481,1489,1544,80896,80897,81449,81871,81872,81873,81874,81875,81876,81877,82759,83865,86166,86627,86977,87409,88616,88623,88624,88627,93461,94521,94522,94523,94524,94525,94526,98677,98678,98679,98773,98947,98981,100150,100325,100326,100329,100331,100332,106385,106386,106390,106962,109168,109189,109196,109198,109199,109200,109201,109202,109203,109204,109241,109259,109260,109261,109262,109273,109274,109293,110542,110543,110544,112770,112771,112772,112786,119486,132835,121660,132926,132927,122547,133582,122549,133682,122550,133683,133684,122556,133816,134016,122558,137282,122559,137323,122560,137332,122593,131455,138945,131456,139310,131479,139849,131480,139850,140249,140624,140893,141734,142198,142739,142740,143599,142741,143605,143878,143891,143892,143979,143989,143990,143991,144003,144004,144005,144247,144257,144258,144259,144333,144720,144721,144722,145033,145042,1148,1424,1546,2919,2981,4801,5352,77307,77447,78212,78687,78892,80820,80821,80895,81371,81864,81865,81866,81867,81868,81869,81870,82765,82874,82912,87079,87406,87779,87782,87783,88129,113683,89615,89718,90849,90850,90853,90855,93178,93179,93190,93192,93194,93460,95116,96778,96779,98668,98669,98670,98673,98674,98676,98772,98912,98913,98942,98943,98944,98945,98946,98948,100134,100327,100333,102562,102580,102581,102582,102583,104919,106378,106382,106383,106384,106391,106392,108828,109142,109143,109144,109145,109146,109147,109148,109149,109150,109151,109152,109153,109154,109155,109156,109158,109159,109161,109162,109163,109164,109165,109167,109741,109742,110531,110532,110533,112653,112654,112762,112763,112764,113685,113686,116097,116098,132833,116099,133774,116401,133812,119485,135384,121081,137256,121082,137279,121661,137289,121662,137290,122583,137337,122934,137348,124827,137682,125393,137683,128812,137789,128813,138217,128814,138944,128815,139424,128816,140263,128817,140264,128818,140265,128819,140429,130621,140623,130622,141104,131343,141115,131345,141116,131590,141161,132054,141162,141760,142197,142203,142437,142438,142439,142440,142441,142442,142525,142679,142715,142716,142826,142827,142828,143038,143040,143251,143554,143617,143634,143635,143791,143792,143793,143794,143795,143853,143854,143855,143856,143898,144027,144112,144113,144114,144274,144275,144321,144336,144337,144400,144401,144402,144403,144404,144405,144421,144422,144423,144424,144568,144623,144896,144907,145174,106866,109141,110545,112765,1154,112767,1155,112768,123879,123880,141007,141008,142723,142724,142725,142726,143879,143992,144116,144332,144436,88626,80342,80344,3955,88599,88619,2660,3915,3916,3917,12532,76334,76335,76337,76338,76341,76830,76831,76833,77273,78077,78078,78079,78154,78155,78156,128808,80345,81773,81814,81815,82012,82013,82452,83078,83079,83080,83081,83897,84212,84310,85742,85993,86125,88618,88625,88611,88620,93185,88621,93186,93188,93191,95543,98910,98949,98950,100328,102209,106387,106574,106575,106576,106823,106864,132723,132724,108825,132725,108827,132836,109190,133362,109254,133363,110399,133680,110530,133681,110535,133775,110536,133776,112655,134270,113370,134443,113371,134619,115336,134620,117287,134621,118320,134924,135004,122592,135164,123887,135238,123888,135239,137240,124829,137241,137252,127350,127351,137381,127574,137382,127575,137466,137685,130496,137806,130497,137807,130619,137917,130620,138197,131288,138485,131712,138486,132053,138489,132055,138490,132059,138491,138819,139851,139852,140231,140232,140233,140266,140658,140881,140882,141508,140884,141509,140888,141510,140889,140891,140892,140954,140991,141004,141005,141055,141326,141354,141506,141507,141522,141601,141622,141657,141658,141733,141735,141736,142199,142294,142444,142468,142469,142470,142476,143593,142761,143594,143073,143711,143074,143732,143740,143774,143776,143777,143778,143779,143862,143870,143871,143873,143874,143875,143876,144117,144418,144419,144420,144434,144435,144888,144908,145154,145172,145212,145220,4005,76361,78749,86626,87397,88622,97719,97723,98843,98844,100151,100321,109192,109194,142717,109195,142718,110534,142719,112766,142720,130099,142721,142722,142759,143598,143603,143604,143881,143997,144115,144329,144330,144407,144409,144425,144426,144427,144428,144622,145044,88628,88629,142946,122834,113954,113955,113956)