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 (2529,2955,3419,3477,3578,3666,3673,3674,3675,4086,5191,5210,5364,5377,5378,77139,77309,79050,79142,79051,77885,78703,81139,77374,78727,77932,78729,81143,82121,82766,83032,83232,86471,134448,134700,84285,85283,134926,83828,85285,137081,85286,137972,85287,138563,85289,138866,85290,138867,138868,138869,139924,144639,87530,140548,144669,140553,144670,87534,140556,140557,88065,140558,140974,140975,141517,141607,141608,141609,142462,142875,93100,93101,93819,143134,143202,100167,100273,100319,102608,102662,103055,103056,103057,103060,105029,1917,112164,1915,1916,113400,1918,1919,115800,1920,115955,1945,1936,118038,118085,121279,121280,121282,122006,122545,127868,127869,127870,127871,127873,128807,129245,143803,2306,144674,141214,144676,144677,126923,132883,116123,2554,2953,2135,2423,4079,2630,3130,3134,4369,3135,3463,3464,76304,3831,3842,4088,76889,76669,4753,76670,77300,77312,7663,7664,77491,77880,78638,7665,7666,7728,702,7729,7730,7733,7734,76521,1075,1077,76988,76997,76998,76999,77933,77934,77935,78250,1112,83637,78549,78726,78742,78907,137121,78921,81818,83237,84284,84286,87864,90260,90938,90939,90940,91713,91714,93388,94044,102709,1444,98898,98899,98900,103058,1479,98901,98902,98903,98904,98905,136774,112472,112473,112474,100274,100318,102306,1750,106876,1751,107579,120149,140545,107901,1753,108886,120456,109005,120885,109006,109007,109102,122580,124612,111307,132271,112689,112785,114919,114920,114921,114922,114923,114924,114925,114926,114927,114928,1848,114929,114930,115305,116375,116376,116377,116378,116379,88402,116380,88403,116381,116382,116383,116384,116385,116386,116387,132839,116388,116389,116390,132623,116391,132624,116392,132625,116393,116394,133055,116395,133063,116827,133064,116828,133065,116829,133328,116830,133547,134732,134957,118318,135132,118319,118324,137722,119669,137975,119670,137991,119671,137992,119672,137993,119673,137994,140296,119675,137997,119676,137998,119677,137999,119678,138192,119679,138193,119682,138789,119683,139335,119684,140102,119685,140615,119778,140957,141315,141320,120884,141329,141334,121281,141345,121458,141346,141623,121459,141625,121460,141626,121461,141794,121462,141795,143372,121463,142206,143466,121464,142279,143467,121465,142371,143504,121466,143506,121467,142702,143663,121468,142788,143670,121469,142812,143722,144230,121470,144301,121471,142997,144513,121472,143006,144642,121473,143007,145007,121474,143104,145008,121475,143105,121476,143128,121477,121478,121479,121480,121481,121482,121483,121484,121485,121486,121487,121502,122432,122579,123882,125290,125291,125292,125945,127205,127206,127207,127208,127209,127210,128027,128030,130022,130103,131592,131706,132282,523,2820,2560,3121,2218,2425,3155,4765,4852,2222,4661,1949,2559,3147,12543,12544,12545,76751,76752,76753,5271,76686,78632,77313,705,77178,709,82875,80894,81095,81311,76750,85418,86000,87085,87387,83751,87504,88880,83341,133057,133068,134272,137120,1242,137123,137891,86002,137933,1245,97910,137959,1246,98594,137984,98681,138708,138860,98852,139923,98853,139930,98897,140084,140928,100271,140933,140934,140935,140936,140937,140938,140984,141124,141128,1402,141132,1403,141133,1404,106228,141134,1405,106229,141135,106577,141136,106870,141137,141138,101544,141139,101545,141216,101546,141241,101547,108214,110351,141242,1426,141312,141618,111591,141619,141669,141729,141811,141820,142312,142409,142411,143245,142412,143258,142432,143376,142506,143469,142698,143561,112475,142837,76306,112426,112476,142938,144060,143050,144064,113288,144108,144173,144638,144647,114000,116864,118574,120046,120453,120461,121342,122431,122577,126430,78633,127309,127867,128381,128424,128803,130955,131452,131929,131930,131967,131968,132272,93102,140552,142431,484,2087,3185,2277,2365,2366,2404,4082,4918,5139,4084,5291,587,5295,5296,589,5361,642,77446,80613,80614,700,2613,78073,78080,2926,707,710,711,3448,3672,3717,83339,1244,140482,140483,140484,140485,140486,140487,1250,140488,1312,3845,1314,141057,4095,1406,4662,1407,4664,1408,1409,1410,1411,5187,5188,5189,5190,5322,5370,5371,5372,103801,76305,76307,76308,76309,76680,76811,1727,77077,77433,77991,78487,78516,122649,81342,86127,87074,87087,87089,87090,87092,87093,87095,87098,87863,1850,87866,87868,87869,87870,88062,88063,88072,88073,88542,132686,89259,133060,89260,133359,133646,133912,134271,134273,137102,89692,137377,90235,137436,137965,90237,138082,138549,138564,91726,138709,91727,138950,92133,138951,138953,138955,138958,92616,138962,143607,92617,138963,143621,92674,138964,143688,139398,143756,93210,140317,143768,93375,140332,143858,93454,140462,143949,93114,140499,144020,144062,144225,95119,144241,95120,144561,144572,95876,144591,95877,144593,144626,140554,144636,140564,144637,97727,140569,144641,97911,141071,144643,97912,141099,144890,98714,141217,145097,98718,141249,145217,98954,141251,141473,141538,100685,141539,100689,141574,141580,102259,141584,141766,141768,141769,141770,141796,141810,142275,102710,142331,142407,142408,142413,142430,142457,142708,104822,142773,142778,142854,143020,143137,143218,143219,105356,106037,106038,106040,107210,107211,107495,107496,107497,107498,107902,108784,110704,109927,111094,111097,114001,116825,118082,119520,119521,120254,120879,121097,121341,121647,122054,122383,124387,125298,126165,126722,127211,127212,127706,128182,128380,128384,128385,128386,128387,128646,128647,128648,128649,130101,130537,130540,130541,130542,130953,130954,131290,131595,132273,98851,2612,2080,2614,2811,3122,3157,3186,3188,122546,4083,3439,3737,588,3780,648,4665,5057,5270,5314,5315,5366,5367,5369,77000,12540,699,78740,77886,701,76302,76303,704,76735,76736,76737,77887,76738,76740,76742,76744,76745,76747,76748,76749,76989,76990,77116,83748,77117,77118,77119,83229,77120,77345,83749,77346,77445,77892,77893,77894,78634,1309,1310,1311,1755,77264,81144,81819,83033,83230,83231,83340,95020,83752,83753,87086,87536,87537,87539,87865,88064,89538,136776,91725,136777,91728,136778,92410,103803,137307,137378,137742,93097,137745,93111,137749,93112,137810,93113,137811,137910,137960,137995,138085,95018,138526,138956,138959,138960,97913,138961,139394,140118,98974,140481,100164,100687,140943,100688,141121,141243,102307,141250,141252,141310,103279,141528,143290,103280,141529,143308,141606,143680,103282,142277,143681,103283,142278,142390,143682,142428,143709,142429,143713,127872,142681,143750,143797,142796,143921,143048,143950,143083,143951,106041,143113,144057,143171,144058,144059,107208,144340,107543,144592,144605,144621,144625,144640,108668,144645,108786,145218,109737,109738,110834,115010,116824,116826,118278,118280,120508,120509,89546,137016,90934,125858,125859,125860,125861,126919,127204,127308,128378,93110,128650,129942,130102,95019,142792,105425,110436,120052,530,643,703,2609,3485,3738,3851,3852,3853,3854,3855,3856,3857,3858,3859,3860,3861,3862,1158,3863,1159,3864,3865,3866,3867,3868,3869,3870,3871,3872,4085,4693,4839,4841,4842,4850,4955,1485,1521,1522,88392,1523,1524,1525,1526,1527,1528,1529,4988,4989,4990,4991,4992,4993,4994,4995,4996,4997,4998,4999,5000,5001,5002,5003,5004,5005,5006,5007,5008,5009,5010,5363,133647,136779,76554,137224,76555,138076,76556,138952,76557,140551,76558,141215,76559,141812,76560,141813,76561,141814,76562,141815,76563,141816,76564,141817,143720,142616,144061,144063,76567,144065,76568,144644,76569,144646,76570,76571,76572,76573,76574,76575,76576,76577,76578,76579,76580,76581,76582,76583,76584,76585,76586,76587,76588,76589,76590,76591,76592,76593,76594,76595,76596,76597,76598,76599,76600,76601,76602,76604,76605,76607,76608,76609,76611,76612,76613,76614,76615,76616,76617,76618,76619,76620,76621,76622,76623,76624,76625,76626,76627,76628,76629,76630,76631,76633,76634,76635,76636,76639,76640,76642,76643,76645,76646,76647,76650,76649,76651,76653,76656,76660,76663,76664,76666,76687,76729,76730,76731,76732,77386,77389,77390,77391,78239,78240,83750,87075,87531,87867,89992,90933,93103,95368,95369,95370,95371,98908,100272,105028,108210,111589,111592,115957,119680,123414,125857,128383,129713,129714,2933,4763,4871,5011,77304,81310,81554,82841,87838,93022,93024,96705,101474,101475,101476,101477,101478,101481,101484,101485,101486,101534,102708,103275,105169,109299,110382,110383,110384,110388,110389,116540,118369,121648,78081,121649,121650,121651,121652,121653,121654,121655,121656,121657,121658,121659,124301,83823,125725,125726,125727,125728,125729,125730,137017,125731,125732,125733,125734,125735,125736,125737,125738,125739,125740,125741,125946,126678,126679,126680,126681,126682,126683,126684,126685,126686,126687,126688,126689,126690,126691,126692,126693,126694,126695,126696,126697,126698,126699,126700,126701,126702,143381,126703,143471,126704,144629,126705,144630,126706,144631,126707,142333,144632,126708,142334,144633,126709,144634,126710,144635,126711,137122,145109,126712,137407,126713,137408,126714,137409,126715,137894,126716,139858,126717,141594,126718,141624,128180,141670,128249,141699,128250,142303,128251,142304,128252,142305,128253,128254,128255,143057,128256,128257,128258,128259,130539,131862,131863,131864,132463,1895,135387,3437,93099,134834,137450,116512,137451,138957,141597,143009,121283,143010,128304,129712,129715,1243,93109,78628,12541,134278,93104,93105,107207,78629,116056,3751,12535,83342,85698,89560,93107,119364,140333,142841,143243,93098,93106)