string(923) "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:58' ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-07-16 03:19:58' ) AND c.id IN (28,31,34,35,36,37,44,50,52,68) AND ( (i.`color_id` LIKE '%,27,%' OR i.`color_id` = 27) OR (i.`color_id` LIKE '%,30,%' OR i.`color_id` = 30) ) AND ( (i.`style_id` LIKE '%,53,%' OR i.`style_id` = 53) OR (i.`style_id` LIKE '%,59,%' OR i.`style_id` = 59) OR (i.`style_id` LIKE '%,60,%' OR i.`style_id` = 60) ) AND ( i.tm='Red-n-Rock\'s') AND ( i.sizes LIKE '%52%' OR i.sizes LIKE '%56%' OR i.sizes LIKE '%62%' OR i.sizes LIKE '%64%' ) AND i.material IN (7,8,9,10,11,20,23,24,28,29)"