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 (769,1126,1345,1346,1423,1480,1518,1481,1543,1553,1555,1757,1896,1971,1972,2266,2301,1976,2307,2350,2551,2968,2969,3011,3078,3730,3567,3731,2357,2403,3812,3939,4093,4647,4651,4797,4868,130104,5198,7682,7735,7736,7737,76691,76692,76694,76695,76696,76698,76796,76855,76856,76861,76979,77097,77104,77209,77210,77214,77305,77401,77402,77515,77931,4640,77952,78036,78207,78267,78347,78435,78436,78442,78783,80576,80584,80585,81341,81555,81847,81848,81849,81850,81851,81852,81857,82212,82283,82578,82843,82844,82911,83374,85388,85389,87071,87407,87408,76697,88388,89306,89609,89613,89698,76820,89995,90248,90249,90250,90251,90252,90253,90254,90255,90256,90257,90258,90530,90531,90532,90535,90537,90607,90652,90653,90654,90655,90656,90657,90658,90862,78506,78508,78681,78682,78734,78736,78787,1704,1708,90941,91661,92058,92126,92127,92128,92248,92249,92250,92251,92252,92253,92254,92255,92256,92257,92258,92259,92260,92261,92262,92885,93177,93456,94528,94529,94530,94531,94532,95109,95110,95363,96075,96775,98715,98716,98774,98775,98776,98847,98858,98859,98876,98877,98952,98976,98977,98980,100299,100300,100302,100306,100316,100350,101596,102493,102494,102501,103387,103391,103393,103569,103570,104482,105030,105041,105042,105043,105401,105403,105404,105405,105406,105512,105513,105514,105515,105516,105517,105518,106374,106958,107545,108377,108378,108379,108380,108382,108383,108384,108385,108387,108388,108389,108390,108391,108644,108645,108646,108885,109139,109278,110692,110693,110699,110700,110840,110841,110842,110843,110844,110854,110855,111093,111926,112329,112761,112774,112899,113682,113866,113867,114329,114330,114331,114332,114333,114411,114918,114978,116093,116094,117119,116096,117163,117164,117165,117297,117329,117638,117639,118073,118219,118372,119428,120011,120215,120335,120336,120521,121077,121488,121490,132682,121493,132909,121720,132910,121722,132911,133096,122562,133214,133215,123837,133652,124947,133653,124948,133779,124949,133780,124950,134313,124951,134405,124952,134406,124953,134407,124954,134408,124966,134409,124968,134410,124969,134416,124970,134508,124971,134922,124972,134959,124973,134961,124974,134962,124975,135040,124976,135065,125126,135346,125127,135598,125128,135599,125391,135843,125948,136919,136926,126892,126893,126894,137050,137051,127978,137106,127979,137228,128966,137229,129126,137420,137442,129286,137443,129291,137444,129802,137445,130579,137446,131484,137447,131584,137462,131731,137779,131877,137813,131878,137882,131879,137897,131880,138079,131881,138314,131972,138323,138341,138385,138584,138701,138793,138854,139390,139391,139392,139439,139440,139464,139863,140257,140281,140326,140330,140514,140525,140883,141098,141114,141258,141259,141325,141337,141339,141477,141525,141559,141569,141596,141633,141724,141781,141787,141788,141803,141965,142185,142193,142394,142395,142396,142397,142402,142403,142447,142448,142452,142473,142523,142524,142563,142570,142571,142612,142676,142703,142704,142742,142743,142744,142805,142869,142953,142976,142977,143002,143087,143098,143100,143103,143253,143109,143265,143338,143132,143497,143166,143527,143169,143529,143210,143540,143213,143563,143214,143564,143215,143587,143216,143661,143232,143701,143233,143703,143753,143754,143760,143772,143780,143781,143828,109137,143829,143830,143845,143899,143901,143913,143914,143956,144033,144080,144102,144121,144122,144123,144163,144164,144168,144199,134593,144200,144201,144202,144233,134597,144281,144286,134599,144287,144288,144307,144324,144393,144397,144398,144571,144582,134608,144586,144590,144648,144649,144653,144655,144656,144666,144961,144963,144993,145014,117127,145037,145056,145067,145198,145208,142865,143001)