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` WHERE `modx_site_content`.`published` AND `manuf` IN ('KSE') AND `modx_site_content_tmc`.`resource` IN ('281491','286422','286421','286418','286419','286420','288154','294980','294983','294984','295805','202650','215771','241157','244329','248899','249233','250870','251302','251431','254206','262974','265107','265513','279280','280502','281571','281572','281573','281574','281575','283572','286107','286108','286109','286111','162155','162921','164401','165631','165632','166917','299762','201148','299763','215377','215626','215832','238481','240667','240937','240957','241755','241988','242219','242558','243166','243945','244141','244148','244208','244289','244598','245358','245359','245583','246779','247378','248445','248865','248970','251011','251012','251682','253060','253437','255281','255282','257224','262940','265159','265787','265950','267284','267702','269097','274946','275017','275316','275364','276015','279089','279090','281147','281152','283583','285195','285825','285826','146589','153503','157759','158854','160710','161460','161516','162783','163605','163964','164059','164495','167258','167259','167448','291623','294701','295409','295598','297254','170204','170375','232608','240531','243685','243967','244097','245698','246080','246762','246774','248570','249899','250838','251847','253754','253850','256580','266796','269051','277704','281490','281549','281550','281551','281552','281553','281554','281555','281556','281557','281558','281559','281560','281561','281562','281563','281564','281565','281566','281567','281568','281569','281570','281679','143923','153783','153936','157739','160830','160860','161962','162647','167511','292473','292042','293270','243209','250270','261740','265109','266448','268785','274865','278111','279091','279092','281576','281577','281578','281579','281580','163822','164555','166656','168318','169215','170101','170725','232644','238682','238820','239494','243393','245382','245510','245614','246836','247463','247639','247751','248372','248601','249625','250014','288691','289461','292364','293453','294190','252234','294295','298183','253066','298396','253421','299190','253430','299983','300934','255627','256019','257031','262117','262183','262254','263033','263045','263721','264514','265146','265631','267573','267770','268001','268002','268045','268815','269072','273545','274431','275300','278401','279668','281492','281493','281495','281496','281497','281498','281499','281500','281501','281502','281503','281504','281505','281506','281507','281508','281509','281510','281512','281513','281514','281515','281516','281517','281518','281519','281520','281521','281522','281523','281524','281525','281526','281527','281528','281529','281530','281531','281532','281533','281534','281535','281536','281537','281538','281539','281540','281541','281542','281543','281544','281545','281546','281547','281548','281599','282821','285792','143050','143133','143205','143507','146592','151403','151530','151626','154900','157532','157533','157534','157535','157638','158656','159856','160212','160396','160569','160771','160772','160773','160783','163700','163714','163959','164211','165107','165158','165819','166752') ORDER BY `stock_status` ASC LIMIT 32 OFFSET 0
