Держатели SIM карт и карт памяти, стр. 3

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 ('215795','215896','216091','232421','239222','240395','240563','240943','240944','241516','241672','242159','242160','242161','242162','242163','242515','243426','244049','244050','245228','246567','246731','246732','246824','248360','248718','248768','252047','252110','253483','266118','266429','266460','267108','267757','273787','273937','274492','275614','277808','278475','278506','278834','279377','279694','280531','281396','282908','285984','286939','288101','288109','287202','142230','150464','150772','150841','151637','151642','158445','160180','161886','163793','163895','164733','166561','167106','167833') ORDER BY `stock_status` ASC LIMIT 32 OFFSET 64