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 (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,87078,136924,128184)