string(728) "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:07' ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-07-16 03:20:07' ) AND c.id IN (34) AND ( (i.`color_id` LIKE '%,26,%' OR i.`color_id` = 26) ) AND ( i.`season_id` = 49) AND ( i.sizes LIKE '%44%' OR i.sizes LIKE '%46%' OR i.sizes LIKE '%52%' OR i.sizes LIKE '%54%' OR i.sizes LIKE '%60%' OR i.sizes LIKE '%62%' OR i.sizes LIKE '%64%' ) AND i.material IN (15,16,17,22,2,3,27)"