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 (2933,4763,4871,5011,77304,81310,81554,82841,87838,93022,93024,96705,101474,101475,101476,101477,101478,101481,101484,101485,101486,101534,102708,103275,105169,109299,110382,110383,110384,110388,110389,116540,118369,121648,78081,121649,121650,121651,121652,121653,121654,121655,121656,121657,121658,121659,124301,83823,125725,125726,125727,125728,125729,125730,137017,125731,125732,125733,125734,125735,125736,125737,125738,125739,125740,125741,125946,126678,126679,126680,126681,126682,126683,126684,126685,126686,126687,126688,126689,126690,126691,126692,126693,126694,126695,126696,126697,126698,126699,126700,126701,126702,143381,126703,143471,126704,144629,126705,144630,126706,144631,126707,142333,144632,126708,142334,144633,126709,144634,126710,144635,126711,137122,145109,126712,137407,126713,137408,126714,137409,126715,137894,126716,139858,126717,141594,126718,141624,128180,141670,128249,141699,128250,142303,128251,142304,128252,142305,128253,128254,128255,143057,128256,128257,128258,128259,130539,131862,131863,131864,132463,1895,135387)