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 (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)