SELECT `k-ts`.`s` slovo, count( * ) kol
FROM `k-t_s` 
JOIN `k-ts` ON `k-t_s`.`id_s` = `k-ts`.`ids` 
WHERE `k-ts`.`f` =0
GROUP BY `k-t_s`.`id_s` 
ORDER BY count( `k-t_s`.`id_s` ) DESC 
LIMIT 1

--
-- Структура таблицы `k-ts`
--

CREATE TABLE IF NOT EXISTS `k-ts` (
  `ids` int(10) unsigned zerofill NOT NULL AUTO_INCREMENT,
  `s` varchar(60) NOT NULL,
  `f` tinyint(3) unsigned NOT NULL COMMENT 'Состояние',
  PRIMARY KEY (`ids`),
  UNIQUE KEY `s` (`s`),
  KEY `f` (`f`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Слова на кириллице' AUTO_INCREMENT=5049383 ;

-- --------------------------------------------------------

--
-- Структура таблицы `k-t_s`
--

CREATE TABLE IF NOT EXISTS `k-t_s` (
  `id_sv` int(10) unsigned zerofill NOT NULL AUTO_INCREMENT,
  `id_n` int(10) unsigned zerofill NOT NULL,
  `id_s` int(10) unsigned zerofill NOT NULL,
  PRIMARY KEY (`id_sv`),
  KEY `id_s` (`id_s`),
  KEY `id_n` (`id_n`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Связи для кириллицы' AUTO_INCREMENT=5043234 ;

GROUP BY 1 
ORDER BY 3

SELECT `k-ts`.`ids` slovo,  count(1) kol 
	FROM `k-t_s`
	join `k-ts` on `k-t_s`.`id_s` = `k-ts`.`ids`
	where `k-ts`.`f` = 0
	GROUP BY 1
	ORDER BY count(`k-t_s`.`id_s`) DESC
	LIMIT 1

SELECT `id_s` , count( * ) 
FROM `k-t_s` 
GROUP BY (`id_s` 
)

update `k-ts`, `k-t_s` set `k-ts`.`kol` =
(
SELECT count(*)
FROM `k-t_s`
group by `k-t_s`.`id_s`
)
where `k-t_s`.`id_s` = `k-ts`.`ids`

SELECT count(*)
FROM `k-t_s`
group by `k-t_s`.`id_s`

update `k-ts`, `k-t_s` set `k-ts`.`kol` =
(
SELECT count(`k-t_s`.`id_s`)
FROM `k-t_s`
where `k-t_s`.`id_s` = `k-ts`.`ids`
)

update `k-ts`
set `k-ts`.`kol` =
(
SELECT count(*)
FROM `k-t_s`
where `k-t_s`.`id_s` = `k-ts`.`ids`)

CREATE INDEX id_s ON k-t_s(id_s);

update `k-ts`
set `k-ts`.`kol` =
(
SELECT count(*)
FROM `k-t_s`
where `k-t_s`.`id_s` = `k-ts`.`ids`)