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 (5141,78640,78642,78643,78644,78645,78646,78647,78648,78649,78650,78651,78652,78653,78654,78655,78656,78657,78659,78660,78661,78662,78663,78664,78665,78666,78706,78708,78709,78710,78711,78712,78713,78714,78715,78716,78717,78718,82124,132692,132693,132868,132869,132870,132871,132872,132934,133386,133416,133916,133922,134007,134008,134009,134010,134011,134012,134013,134048,134049,134050,134412,135554,135604,135722,135725,136852,136853,136854,136855,136856,136857,136858,136859,136860,136861,136862,136863,136864,136865,136866,136867,136868,136869,136870,136871,136872,136873,136874,136875,136876,136877,136878,136879,136880,136881,136882,136883,136884,136885,136886,136887,136888,136889,143267,143294,143301,143340,143341,143342,143343,143344,143345,143346,143347,143348,143349,143350,143351,143352,143353,143354,143355,143378,143382,143383,137058,143384,137267,143385,137303,143386,137304,143387,137305,143388,137396,143389,137503,143390,137504,143391,137505,143392,137506,143393,138003,143394,138021,143395,138022,143396,138023,143397,138024,143398,138025,143399,138026,143400,138027,143401,138028,143402,138029,143403,138030,143404,138031,143405,138032,143406,138033,143407,138034,143408,138035,143409,138036,143410,138038,143411,138068,143412,138446,143413,138582,143414,138762,143415,138776,143416,138777,143417,138778,143418,138779,143419,138780,143420,138781,143421,138782,143422,138806,143423,138807,143424,138808,143425,138809,143426,138810,143427,138811,143428,138812,143429,140115,143430,140243,143431,140418,143432,140419,143433,140446,143434,140447,143435,140448,143436,140449,143437,140450,143438,140519,143439,140520,143440,140521,143441,140522,143442,140523,143443,140538,143444,140539,143445,140540,143446,140541,143447,140542,143448,140567,143449,140652,143450,140653,143451,140977,143452,140978,143453,140979,143454,140980,143455,140981,143456,140982,143457,141013,143458,141014,143459,141015,143460,141016,143461,141017,143472,141018,143473,141019,143474,141020,143475,141021,143491,141022,141023,143683,141024,143684,141025,143685,141026,143686,141027,143696,141028,143726,141029,143730,141030,143975,141031,144084,141032,144085,141033,144086,141181,144087,141182,144088,141183,144089,141184,144090,141185,144091,141186,144092,141187,144093,141188,144094,141189,144095,100114,141190,144096,141191,144097,141192,144098,141193,144099,141194,144134,141195,144135,141196,144136,141197,144137,141198,144138,141199,144139,141200,144140,141201,144141,141202,144142,141220,144143,141221,144144,141411,144145,141415,144146,141483,144147,141649,144148,141650,144149,141719,144150,141775,144151,101598,141776,144152,101599,141777,144153,142423,144154,142424,144155,142479,144156,142480,144157,142481,144158,142482,144159,142483,144160,142484,144170,142498,144187,144188,142500,144189,142501,144190,142608,144191,142849,144192,142850,144193,142851,144342,142880,144344,142881,144345,142882,144346,142883,144347,142884,144348,142885,144349,142886,144350,142906,144351,142907,144352,142908,144353,142909,144354,142910,144355,142911,144356,142912,144357,142913,144358,142914,144359,142915,144360,142916,144361,142917,144362,142935,144363,143018,144364,143061,144365,143062,144366,143063,144367,143129,144368,143130,144369,143131,144370,110291,143149,144371,143154,144372,143155,144373,143156,144374,111129,143157,144375,143204,144376,143207,144377,143208,144378,144379,144380,144381,144382,144383,144384,144385,144386,144387,144388,144562,144563,144564,144584,144663,144664,144678,144679,144680,144681,144682,144683,144684,144685,144686,144687,144688,144689,144690,144691,144692,144693,144694,144695,144696,144697,144698,144699,144897,144898,144899,144900,144901,144902,144903,144904,144905,144906,144910,144911,145064,145065,145114,145115,145116,145117,145118,145119,145304,145311,145312,145313,112973,113745,113746,114683,115810,121104,121105,121106,121107,121108,123933,123936,124078,125133,125398,125399,125400,125401,125445,125570,125571,125572,128731,128927,130106,130107,130108,130109,130110,130111,130112,130113,130114,130115,130116,130117,130118,130119,130120,130121,130122,130123,130124,130125,130126,130127,130128,130129,130130,130131,130132,130133,130134,130135,130136,130137,130138,130139,130140,130141,130142,130143,130144,130145,130146,130147,130148,130149,130150,130151,130152,130965,131187,131633,131634,131873,132305,132336)