string(954) "SELECT COUNT(*) FROM #__k2_items as i RIGHT JOIN #__k2_categories c ON c.id = i.catid WHERE i.published = 1 AND i.sizes != '' AND i.size_range !='' AND i.access IN(1,1,5) AND i.trash = 0 AND c.published = 1 AND c.access IN(1,1,5) AND c.trash = 0 AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2024-07-16 03:20:00' ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-07-16 03:20:00' ) AND c.id IN (29,32,38,39,40,41,45,53,54,65,69) AND ( (i.`color_id` LIKE '%,27,%' OR i.`color_id` = 27) OR (i.`color_id` LIKE '%,29,%' OR i.`color_id` = 29) OR (i.`color_id` LIKE '%,30,%' OR i.`color_id` = 30) ) AND ( (i.`style_id` LIKE '%,54,%' OR i.`style_id` = 54) OR (i.`style_id` LIKE '%,58,%' OR i.`style_id` = 58) OR (i.`style_id` LIKE '%,60,%' OR i.`style_id` = 60) ) AND ( i.sizes LIKE '%44%' OR i.sizes LIKE '%48%' OR i.sizes LIKE '%50%' OR i.sizes LIKE '%52%' ) AND i.material IN (7,8,9,10,11,20,23,24,28,29)"