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='83' and count_ip='54.172.169.199' and wdate='20240319'