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 (80515,80516,80540,83261,84465,5039,88600,88601,88602,88603,88604,88605,90916,90917,90918,90927,133138,133139,133146,133205,133206,133207,133208,134095,134126,134134,134159,134160,134161,134179,134180,134181,134182,134183,134184,134189,134190,134197,134202,134203,134204,134205,137669,137670,137671,137672,137673,137674,137675,137676,137677,137678,107016,137679,107017,140784,140785,140786,140815,140816,140817,140818,140819,140820,140844,140849,140851,140866,140871,141458,141459,141460,141837,141838,141839,141842,141848,141849,115498,141850,115499,141851,115500,141852,141853,141887,141889,141890,141891,141892,141893,141894,141895,141896,119867,141897,121003,141898,121004,141899,121005,141900,141901,121360,141902,125851,141903,141904,141905,129947,141906,129948,141907,129949,141910,132006,141911,141912,141913,141914,141915,141916,141917,141918,141919,141927,141928,141929,141931,141932,141934,141935,141936,141937,141938,141939,141940,141941,141942,143569,141943,144132,144918,141944,145228,141945,143476,141946,143477,141947,141952,138163,87657)