Корпуса, стр. 17

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 ('170024','170077','170078','170205','170413','170414','170415','170530','170531','170532','170533','170534','170535','170536','170537','170538','170539','170540','170541','170542','170543','185916','210493','210496','210497','210498','210499','210500','210501','210502','210503','210970','210982','210983','211008','211820','211821','211822','211823','211824','211825','211826','211827','211828','211829','211830','211831','211832','211833','211834','211835','211836','211837','211838','211839','211840','211841','211842','211843','211844','211845','211846','211847','211848','211849','211850','211851','211852','211853','211854','211855','211856','211857','211858','211859','211860','211861','211862','211863','211864','211865','211866','211867','211868','211869','211870','211871','211872','211873','211874','211875','211876','215216','215250','215415','215720','216046','216093','219761','232595','232641','232780','238590','239156','239248','239316','239317','240097','240098','240282','240285','240288','240313','240348','240349','240354','240356','240433','240445','240453','240521','240815','240816','240817','240819','240830','240833','240835','240837','240838','241310','241338','241339','241468','241469','241529','241722','241764','241978','242230','242382','242429','242516','242726','242785','242820','243287','243539','243835','243836','244210','244288','244291','245203','245384','245489','245847','246021','246257','246467','246725','246726','246727','246728','246914','246969','247358','247587','247913','248090','248210','248331','248441','248485','248620','248736','248791','248866','249149','249196','249344','249390','249537','249666','249714','249822','249850','249895','250509','250890','250903','251080','251154','251267','251498','251553','251931','251979','252153','252240','253633','253739','253852','253853','254213','254380','254382','254436','254439','254616','254646','254821','254945','254970','255106','255117','255118','255181','255361','255471','255504','255596','255942','255943','255944','255945','255946','255947','256097','256098','256104','256196','256616','256658','256724','256876','257060','257061','257177','261710','261711','261756','261773','262108','262345','262346','262939','263585','264350','264359','264363','264491','265099','265227','265366','265404','265540','265695','265784','265970','266003','266090','266278','266415','266612','266825','266903','266974','266982','267054','267459','267480','267868','268011','268012','268013','268014','268015','268016','268017','268018','268019','268020','268021','268022','268023','268024','268025','268026','268027','264910','268029','264951','268030','264962','268031','264964','268032','268033','268034','268035','268036','268081','265060','268112','268223','268347','268502','268506','268783','268784','268859','268861','269017','269032','269242','269347','269371','269462','269463','269464','269465','269466','273306','273307','273403','273404','273560','273673','273676','273677','273798','273961','274387','274388','274389','274390','274391','274392','274393','274394','274395','274437','274438','274444','274445','274783','275003','275135','275396','275625','275735','276135','276136','276138','276139','276140','276141','276246','276499','276529','276594','276668','276669','276763','276769','277338','277339','277342','277422','277511','277720','277721','277722','277723','277724','277725','277726','277727','277729','277730','277731','277798','277967','278223','278369','278370','278464','278519','278615','278693','278760','278768','278771','279455','279484','279666','279724','279725','279732','279814','280350','280366','280367','280442','280443','280589','280765','280766','280767','280768','280819','280862','280881','280990','281072','281178','281223','281388','281584','281627','282030','282112','282177','282444','282481','282768','282811','283604','284134','284184','284280','284283','284441','284579','284907','285073','285076','285121','285140','285183','285185','285333','285375','285376','285386','285431','285531','285725','285829','285830','285898','285968','286124','286373','286647','287504','287505','287993','288004','288097','288099','288127','288205','288307','288493','288869','288983','143691','143692','144287','149707','149708','150150','150151','151042','151043','151456','151635','151850','151972','151993','153640','153644','155477','155822','156823','156824','156825','156826','156827','156828','156829','156830','156831','157709','158015','158016','158340','158377','158657','158660','158759','159014','159095','159698','159750','159869','160036','160117','160236','160237','160820','161321','161387','161885','162366','162448','162766','162904','162905','163042','163047','163086','163324','163619','163621','163751','163800','163803','164153','164154','164176','164177','164591','164981','165029','165188','165189','165198','165199','165200','165201','165202','165203','165204','165205','165538','165815','165849','166319','166322','166445','166546','166597','166921','167359','167531','167627','167842','167991','168218') ORDER BY `stock_status` ASC LIMIT 32 OFFSET 512