Трансформаторы, стр. 7

SELECT `modx_site_content_tmc`.*,`modx_site_content`.`pagetitle`,`modx_site_content`.`introtext` FROM `modx_site_content_tmc` LEFT JOIN `modx_site_content` ON `modx_site_content`.`id`=`modx_site_content_tmc`.`resource` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku`=`modx_site_content_tmc`.`sku` LEFT JOIN `modx_site_content_params` ON `modx_site_content_params`.`sku`=`modx_site_content_tmc`.`sku` LEFT JOIN(SELECT SUM(`kol`) as `k`,`sku` FROM `modx_site_content_zakaz` WHERE `status` IN ('В грузе','Передано на склад') AND `rezerv`='Нет' GROUP BY `sku`) AS `zakaz` ON `modx_site_content_tmc`.`sku`=`zakaz`.`sku` WHERE `modx_site_content`.`published` AND `modx_site_content_tmc`.`resource` IN ('170461','215478','232553','232794','238219','238841','238842','238972','239792','240254','240255','240396','240410','240533','240724','240808','240952','240972','241439','241440','241476','242120','242514','242896','243797','243946','244318','244345','244679','244895','245296','245297','245457','245514','246270','248207','248235','248361','248770','248886','248956','249015','249016','249304','249592','249665','249838','249841','250129','250247','250588','251003','251133','251235','251238','251456','251490','251549','251618','251657','251731','251944','252051','253682','254892','255244','255460','255588','256484','256666','256799','256849','256855','256863','261739','262090','262401','263097','263109','263193','263566','263650','264720','264721','264722','264723','264724','264871','265025','265026','265110','265852','265983','266900','266969','267045','267160','267662','267825','267858','268107','268119','268588','269363','269400','273457','273476','273644','273712','273715','273892','275058','276978','275475','277201','275620','277227','275838','277791','275976','277795','276209','277932','278103','278412','279259','280395','280396','280976','281228','281316','281327','281582','282485','282544','282850','283333','284530','284591','284600','284833','285075','285221','286341','286342','287548','288178','288216','288506','288586','148050','148146','151695','151696','153512','153513','153727','154221','154882','155013','157268','157269','157826','158194','158306','158414','158418','158806','158807','159506','159583','159781','159980','160189','160260','160375','160475','161360','162179','162359','162895','163656','164370','164418','164865','165087','165170','165353','165490','166232','166627','166991','167225','167366','167428','167504','167601','167675','168243') ORDER BY `stock_status` ASC LIMIT 32 OFFSET 192