Table rebuild required. Please do "ALTER TABLE `rorynews_com.ins_banner_count` FORCE" or dump/reload to fix it! select count(*) from ins_banner_count where banner_uid='95' and count_ip='3.85.63.190' and wdate='20240319'