string(1189) "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:19:55' ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-07-16 03:19:55' ) AND c.id IN (29,32,38,39,40,41,45,53,54,65,69) AND ( i.`collection_id` = 48) AND ( (i.`color_id` LIKE '%,26,%' OR i.`color_id` = 26) OR (i.`color_id` LIKE '%,28,%' OR i.`color_id` = 28) OR (i.`color_id` LIKE '%,29,%' OR i.`color_id` = 29) OR (i.`color_id` LIKE '%,32,%' OR i.`color_id` = 32) OR (i.`color_id` LIKE '%,38,%' OR i.`color_id` = 38) OR (i.`color_id` LIKE '%,39,%' OR i.`color_id` = 39) ) AND ( i.`season_id` = 5 OR i.`season_id` = 6 OR i.`season_id` = 49) AND ( (i.`style_id` LIKE '%,53,%' OR i.`style_id` = 53) OR (i.`style_id` LIKE '%,58,%' OR i.`style_id` = 58) ) AND ( i.sizes LIKE '%42%' OR i.sizes LIKE '%46%' OR i.sizes LIKE '%52%' OR i.sizes LIKE '%54%' OR i.sizes LIKE '%58%' ) AND i.material IN (7,8,9,10,11,20,23,24,28,29)"