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 (1826,1953,1829,1823,4770,1824,1828,4629,1827,1863,4828,77081,1825,78779,87515,92036,98854,135449,102584,102585,102589,103806,103807,103809,103810,143099,104434,110863,112932,118322,4628,4823,1830,138178,138179,138183,138184,138185,670,1977,2221,2481,2552,2600,2924,2945,3037,4099,84418,4573,4574,4575,1107,4576,91712,1120,4577,97717,98991,4579,98992,4581,4582,4585,4777,4785,4805,4855,7723,12556,76912,76975,1421,1422,77054,77055,1547,78235,78302,78450,78686,78744,78791,78794,78795,80661,80822,80823,81155,81338,81339,81340,81879,82122,82220,82472,82620,82908,82913,82914,83787,85396,85452,85453,85463,85551,85830,86946,87077,87393,88050,88393,88394,88607,88608,89543,89614,89616,89637,89733,91101,91730,93462,93681,94886,95185,95628,97709,98664,98842,98868,100160,100323,100324,102549,102571,102579,102605,105215,105784,105977,106379,106380,106960,106968,107213,107483,108607,108608,108609,108610,108611,108826,109009,109176,109197,109292,109320,110320,110861,110862,111547,112004,113386,113389,113757,116402,117162,117444,117848,117977,118071,118075,118076,118077,118078,118079,118180,118223,119189,119195,119780,120010,120148,120658,121095,132657,121862,132764,133654,133655,134044,135134,125783,127053,136911,126561,127055,136923,127202,137053,127258,137054,127516,137439,127517,137540,128303,137790,128348,137791,128349,138187,128376,138470,138539,129201,138786,129290,138941,130960,138943,131453,139007,131454,140239,131458,140252,131460,140253,131461,140254,131466,140255,131467,140256,131468,140510,131469,140532,131470,140533,131471,140534,131472,140620,131473,140631,131474,141102,131475,141163,131476,141213,131477,141500,131671,141501,132279,141691,141708,141743,142300,142416,142443,143252,142755,143257,143502,142864,143557,143034,143558,143812,143813,143840,143916,143972,143973,143977,144032,144119,144248,144249,144250,144251,144311,144433,144703,144996,145173,145287,145288,145309,76974,78389,78391,143971,1874,1865,77125,77126,77495,77923,82473,82474,83861,85395,90542,90543,78796,90544,132882,91102,132931,95364,133810,136913,137046,137255,112988,137291,118222,137312,137794,121092,138798,121259,138939,121260,138940,141149,143636,127114,142418,143638,127115,144030,128346,144031,131714,144252,131715,144253,144254,144255,144295,144415,145006,145045,145194,145286,122584,2368,3094,2706,1465,76390,1941,78781,78761,78769,78770,78758,78763,78780,78760,78762,78767,78772,78766,78768,78771,103567,124631,78882,82915,82916,82917,82918,82919,82920,82921,86624,87781,87784,87785,87786,125394,87787,90519,90520,90521,90533,90915,95117,95118,98029,98030,98031,98032,98033,98034,98035,98036,98037,98656,98657,98658,98662,98663,98667,98671,100297,100298,100734,102552,102578,102592,103270,103271,104721,104912,104722,106683,106686,106688,106691,143814,143834,132834,143837,113381,140425,113382,141067,113387,141758,114252,114253,117197,120580,125070,125071,125072,125073,125074,125075,127977,131346,131586,131727,131887,131888,77213,131342,124964,124965,141648,76414,779,780,781,782,783,2519,2520,1103,2681,2918,2975,92245,7688,1151,76688,76918,76919,77039,77040,77124,77132,1384,77895,78214,1539,78301,81025,82225,1552,1556,82481,83862,87094,87100,87102,90538,90539,102566,103263,104839,106042,106233,109135,109166,109300,109318,110864,113768,116124,116656,116657,116658,116659,116682,116683,116684,116985,116991,117023,117842,117843,117844,117846,117853,117854,117856,117859,117863,117869,117872,117873,117874,117879,117887,117902,117908,117914,117919,117931,117934,117938,117957,117996,118007,118014,118021,118022,118026,118794,118797,118798,118799,118800,118801,118802,118803,118804,118806,118808,118812,118828,119621,119622,119623,119624,119628,119639,119642,119643,119644,119648,119655,119659,119660,119661,119662,119663,119664,133797,119665,133802,119666,133805,119667,133806,119668,120587,121083,136894,121343,136895,136896,122009,136906,122101,136907,122102,136922,122107,122120,137259,122121,137322,122122,137336,123811,137706,123812,138339,123825,138344,138345,138351,138796,127844,138799,127845,138800,127846,138801,127847,138829,127964,138878,127965,138879,129289,138880,129754,138881,129755,138882,129756,138883,129757,138884,129758,138885,129759,138886,129760,138887,129761,138888,131032,138889,131058,138890,131059,138891,131720,138892,131721,138893,138894,138895,138896,138897,138898,138899,138900,138901,138902,138903,138904,138905,138906,138907,138908,138909,138910,138911,138912,138913,138914,138915,138916,138917,138918,138919,138920,138921,138922,138923,138924,138946,138947,139405,139832,140422,140423,140431,141502,143637,141727,144029,141986,144273,142001,144276,142339,144277,142340,144278,144465,144466,144627,144628,144708,144798,144822,144861,144862,144863,144864,144880,144881,144914,145047,145048,145049,145050,145128,145181,145195,145196,145197,145301,5333,76411,77488,133800,133801,136893,123826,123827,2267,2553,1880,2974,3069,4636,4649,78777,1550,4652,4653,1104,4771,4772,4780,76929,76930,76931,77046,77061,1156,77087,1306,77295,77502,78311,78312,78438,78778,80352,80355,81445,81446,81447,81451,81856,81860,82482,82870,83077,85291,85294,85393,85402,85831,85832,85833,85834,85835,87076,87080,87385,87788,89610,89638,89639,89640,89641,90852,90854,91729,92890,92895,92897,92901,93987,93988,95360,98857,103268,103388,103389,104768,106381,106685,106689,107205,107490,109269,109272,109282,109283,109286,109287,109288,109930,109932,110852,110857,110858,111986,111987,111988,111989,111990,111991,111992,111993,111994,111995,111996,111997,113289,115230,116400,116978,117166,117409,117410,117411,117412,117413,76858,119230,76859,120334,121080,121089,121346,122596,123889,124513,77050,126517,127710,132914,127711,132915,127712,132916,127713,132917,127714,133809,127715,133813,127716,133847,127717,134848,127718,135064,127719,135382,127720,135383,127721,136892,127722,136904,127723,136905,128024,136917,128185,137020,128186,137219,128187,137249,128339,137286,128340,137292,128341,137755,128342,137758,128343,137776,128344,137777,131487,137778,131723,138338,131724,138357,131725,138797,131726,140989,141002,141109,141110,141156,141157,141158,141159,141474,141475,141480,141492,141493,141494,141495,141496,141497,141612,141709,141744,77910,142002,142510,142541,142822,142823,143690,143089,143727,143160,143784,143193,143785,143786,143819,143820,144038,144039,144040,144053,144256,144260,144261,144262,144264,144265,144279,144282,144391,144416,144600,144701,145016,145038,145204,145274,145284,145285,145306,145307,87078,136924,128184,1101,2371,2665,77296,78231,78773,82910,78306,87084,98861,101595,102567,102572,102573,102574,102576,107390,110838,117907,134381,137052,137211,137707,77297,137785,138354,143640,120524,138362,144702,121084,138575,144995,121344,138576,145054,140424,145213,124512,141499,145256,127843,77052,78210,110871,118074,126891,78861,2970,4638,4630,4800,1540,3073,121087,1717,77130,1718,78786,81855,85550,87411,87412,101597,90525,90526,102497,102594,132918,132919,109271,132920,109279,127725,137210,127726,137215,127727,137787,131728,138355,138358,139096,139403,139848,140511,140990,141166,141167,141420,142825,143088,143093,143094,143618,144331,144399,144588,144998,145001,145002,145179,78433,4808,4809,93193,137786,76887,1877,88784,89476,102575,102577,106692,107198,108054,108055,120583,108666,113957,138469,141436,141437,128870,125120,131047,131052,142948,122586,122589,122591,1344,1534,1535,2493,3088,3694,5036,76681,78868,95097,99821,142584,143152,121070,121071,121072,128361,77896,81411,85401,87511,4773,4774,90549,4775,95358,4776,77298,95359,98892,103264,127841,132912,127842,132913,136897,136918,137759,137788,138566,138574,142540,143641,144268,144269,128352,144294,144915,118229,145104,145105,145106,145253,145254,145255,137795,137796,76938,78304,137802,145052,127848,78233,78234,78256,132923,142549,121091,142564,121096,128347,77042,77043,77044,77045,1975,76685,4804,4806,76914,76924,76925,76928,77134,86716,87082,87083,87508,105085,108663,108664,109385,109523,109678,109743,110866,110873,110874,110875,110876,110877,118225,1430,1432,119193,133620,121090,133804,1541,121261,133807,121262,134782,127849,136908,1548,128350,136909,128351,136910,128359,136914,131463,136915,131464,136916,131465,136920,131719,136921,137257,137333,137770,138937,138938,138942,139904,140421,140426,140430,140535,140536,141148,141150,141151,141152,141421,141701,142419,142534,142562,143815,143012,144242,143046,144243,144244,144245,144246,144569,145100,108665,127966,104383,134380,140512,140574,142749,143206,128345,144601,144602,107199,139818,139844,117840,3696,76911,2369,76913,76922,76923,76926,1545,76927,77058,2922,77059,77060,77499,82483,85397,141351,89715,141985,90551,100135,144028,87405,127850,3695)