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 (779,780,781,782,783,2519,2520,1103,2681,2918,2975,92245,7688,1151,76688,76918,76919,77039,77040,77124,77132,1384,77895,78214,1539,78301,81025,82225,1552,1556,82481,83862,87094,87100,87102,90538,90539,102566,103263,104839,106042,106233,109135,109166,109300,109318,110864,113768,116124,116656,116657,116658,116659,116682,116683,116684,116985,116991,117023,117842,117843,117844,117846,117853,117854,117856,117859,117863,117869,117872,117873,117874,117879,117887,117902,117908,117914,117919,117931,117934,117938,117957,117996,118007,118014,118021,118022,118026,118794,118797,118798,118799,118800,118801,118802,118803,118804,118806,118808,118812,118828,119621,119622,119623,119624,119628,119639,119642,119643,119644,119648,119655,119659,119660,119661,119662,119663,119664,133797,119665,133802,119666,133805,119667,133806,119668,120587,121083,136894,121343,136895,136896,122009,136906,122101,136907,122102,136922,122107,122120,137259,122121,137322,122122,137336,123811,137706,123812,138339,123825,138344,138345,138351,138796,127844,138799,127845,138800,127846,138801,127847,138829,127964,138878,127965,138879,129289,138880,129754,138881,129755,138882,129756,138883,129757,138884,129758,138885,129759,138886,129760,138887,129761,138888,131032,138889,131058,138890,131059,138891,131720,138892,131721,138893,138894,138895,138896,138897,138898,138899,138900,138901,138902,138903,138904,138905,138906,138907,138908,138909,138910,138911,138912,138913,138914,138915,138916,138917,138918,138919,138920,138921,138922,138923,138924,138946,138947,139405,139832,140422,140423,140431,141502,143637,141727,144029,141986,144273,142001,144276,142339,144277,142340,144278,144465,144466,144627,144628,144708,144798,144822,144861,144862,144863,144864,144880,144881,144914,145047,145048,145049,145050,145128,145181,145195,145196,145197,145301,5333,76411,77488,133800,133801,136893,123826,123827)