CREATE TABLE `all` (
 `uniq__id` int(10) NOT NULL AUTO_INCREMENT,
 `date` datetime NOT NULL,
 `tel` bigint(15) NOT NULL,
 `tip` int(1) NOT NULL DEFAULT '0',
 `action` int(1) NOT NULL,
 `cost` bigint(15) NOT NULL DEFAULT '0',
 `cntroom` int(1) NOT NULL,
 `area` text NOT NULL,
 `storey` int(2) NOT NULL,
 `maxstorey` int(2) NOT NULL,
 `desc` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
 `name` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
 `link` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
 `address` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
 `s_id` bigint(15) NOT NULL,
 `city` int(2) NOT NULL,
 `remoteid` text NOT NULL,
 `site` int(1) NOT NULL DEFAULT '0',
 `cnt_tel` int(4) NOT NULL,
 PRIMARY KEY (`uniq__id`),
 UNIQUE KEY `avUniq_id` (`s_id`),
 UNIQUE KEY `lnkidx` (`link`(200))
) ENGINE=InnoDB AUTO_INCREMENT=20831 DEFAULT CHARSET=latin1

UPDATE all
SET cnt_tel = (
                      SELECT 1 FROM
                            (
                              SELECT count(*), tel FROM all
                              GROUP BY 1
                            ) as tmp
                     );