CREATE TABLE `dirty_data` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `date_record` date NOT NULL,
  `date_update` date DEFAULT NULL,
  `year_mon_record` varchar(7) NOT NULL,
  `lic_sch` varchar(16) NOT NULL,
  `fam` varchar(64) DEFAULT NULL,
  `name` varchar(64) DEFAULT NULL,
  `otch` varchar(64) DEFAULT NULL,
  `n_sch` varchar(16) DEFAULT NULL,
  `n_plomb` varchar(16) DEFAULT NULL,
  `dustan` date DEFAULT NULL,
  `town_name` varchar(64) DEFAULT NULL,
  `street_name` varchar(64) DEFAULT NULL,
  `home` varchar(10) DEFAULT NULL,
  `kv` varchar(10) DEFAULT NULL,
  `yearmon` date DEFAULT NULL,
  `data_new` int(12) DEFAULT NULL,
  `data_kon` int(12) DEFAULT NULL,
  `date_kon` date DEFAULT NULL,
  `base` varchar(16) DEFAULT NULL,
  `pred_dostov` tinyint(1) DEFAULT NULL,
  `sled_dostov` tinyint(1) DEFAULT NULL,
  `nalich_lic_sch` tinyint(1) DEFAULT NULL,
  `pred_pokaz` int(12) DEFAULT NULL,
  `sled_pokaz` int(12) DEFAULT NULL,
  `oshibka` tinyint(1) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mon_lic_sch` (`year_mon_record`,`lic_sch`) USING BTREE,
  KEY `yearmon` (`year_mon_record`) USING BTREE,
  KEY `year_base` (`base`,`year_mon_record`) USING BTREE,
  KEY `y_b_o` (`year_mon_record`,`base`,`oshibka`),
  KEY `t_s_h_o` (`town_name`,`street_name`,`home`,`oshibka`)
) ENGINE=MyISAM AUTO_INCREMENT=1241704 DEFAULT CHARSET=utf8;

select * FROM dirty_data
where oshibka>1 and town_name in (SELECT DISTINCT town_name FROM dirty_data where oshibka=0)
and street_name in (SELECT DISTINCT street_name FROM dirty_data where oshibka=0)
and home in (SELECT DISTINCT home FROM dirty_data where oshibka=0)