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 (81026,2344,2346,3260,77062,77063,77064,77065,77066,77067,77068,77070,77071,77072,77075,77076,78042,78043,78044,78045,78046,78047,78048,78049,78050,78051,78052,78053,78054,78055,78056,78307,78308,78309,78310,78453,78454,82210,82391,82392,82393,82394,82395,85459,85460,85461,85951,85952,85953,85954,85955,85956,88825,89635,89719,89727,90937,92055,92129,92130,92131,104384,104385,104386,104387,105407,138671,138672,106327,138688,132876,132877,133420,133421,133422,133423,119818,133424,116159,119829,133425,121052,133803,121053,134377,121054,135311,121055,135588,121056,135590,121057,135591,121058,135592,121059,135594,121060,135595,121061,135596,740,121062,135597,741,121063,135708,742,121064,135709,743,121065,135710,121066,135711,121067,135712,121068,135713,121069,135714,121256,135715,121257,135716,121258,135717,121366,135718,121367,135719,121368,135720,121369,137410,121370,137411,121371,137412,124515,137413,124516,137414,124517,137415,124518,137416,137418,138094,126159,138095,126160,138154,127111,138159,127968,138160,127969,138162,127970,138376,127971,138377,127972,138378,127973,127974,138399,127975,128327,132884,128328,128329,138823,138824,138825,138826,138827,138828,138954,139327,139328,139329,139838,140260,140464,140465,140466,140467,140468,140469,140470,140471,140472,140473,140474,141223,141277,141278,141994,141995,142273,143565,142560,143612,142561,143613,142970,143614,143644,143645,143646,143647,143648,143649,143650,143651,143652,143653,143654,143655,143656,143657,143919,143920,144240,144317,144441,144442,144443,144444,144445,144446,144447,144448,144449,144450,144451,144452,144453,144454,144455,144456,144594,144620,144659,144660,1429,1434,1531,1533,1537,1538,5301,76359,76373,76375,93513,138171,105408,105409,105413,105414,105415,105416,105417,105418,105419,105420,105421,105422,105423,105424)