count: 127, time: 0.013551950454712
, sql: SELECT `modx_site_content`.`id` as `cid`,`modx_site_content`.`parent`,`cats`.`pagetitle` as `category`,`modx_site_content_tmc`.`sku` as `tmcsku`,`modx_site_content_tmc`.`manuf`,`modx_site_content_params`.*,`modx_site_content_sklad`.* FROM `modx_site_content` JOIN `modx_site_content_tmc` ON `modx_site_content_tmc`.`resource` = `modx_site_content`.`id` LEFT JOIN `modx_site_content_params` ON `modx_site_content_params`.`sku` = `modx_site_content_tmc`.`sku` LEFT JOIN `modx_site_content_sklad` ON `modx_site_content_sklad`.`sku` = `modx_site_content_tmc`.`sku` LEFT JOIN (SELECT `modx_site_content`.`pagetitle`,`modx_site_content`.`parent`,`modx_site_content`.`id` FROM `modx_site_content` WHERE `template`=3) as `cats` ON `cats`.`id` = `modx_site_content`.`parent` WHERE `published`=1 AND `deleted`=0 AND `modx_site_content`.`id` IN (721802,721997,722018,722057,722102,722515,722603,721631,722667,722668,722669,722670,722671,722672,722791,723164,723380,723664,725230,725707,726236,726531,726532,726533,726534,726559,726560,726563,726564,726565,727787,714708,714767,715185,715732,715735,715737,715738,715739,715740,715741,715742,717730,715745,715746,715747,715748,715749,718448,715750,715751,715752,719492,715753,715759,715767,715768,715769,715770,716416,716750,717629,710383,666558,669496,672009,673405,674447,676138,677901,678737,699776,699862,700108,700126,700335,700797,708126,708172,708559,708726,708958,709504,709537,710192,710193,710194,710195,710196,710198,710199,710200,710208,710209,710210,710211,710212,710213,710214,710215,710216,710217,710218,710219,710220,710221,710337,710339,710340,710353,710354,710355,710377,710380,710381,710706,711022,711023,711024,711069,711155,711824,712011,712639,713898,714059,714352), array:
