CREATE TABLE `dirty_data` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `date_record` datetime NOT NULL,
  `date1_record` date NOT NULL,
  `lic_sch` varchar(16) DEFAULT NULL,
  `fam` varchar(64) DEFAULT NULL,
  `name` varchar(64) DEFAULT NULL,
  `otch` varchar(64) DEFAULT NULL,
  `kod_st` varchar(8) DEFAULT NULL,
  `kod_tn` varchar(8) DEFAULT NULL,
  `yearmon` date DEFAULT NULL,
  `data_new` int(11) DEFAULT NULL,
  `data_kon` int(11) DEFAULT NULL,
  `date_kon` date DEFAULT NULL,
  `base` varchar(16) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE DEFINER=`Oleg`@`` PROCEDURE `zap_copy`()
BEGIN
INSERT INTO dirty_data
	select 
kartab_askue.lic_sch from kartab_askue
where del=0 ;
END

BEGIN
INSERT INTO dirty_data (date_record,lic_sch,data_kon,date_kon,base,fam,`name`,otch,cod_tn,cod_st,data_new,yearmon)
select 
now() As time1,
kartab_askue.lic_sch,
kartab_askue.data_kon,
kartab_askue.date_kon,
kartab_askue.base,
kartab_askue.fam,
kartab_askue.`name`,
kartab_askue.otch,
kartab_askue.cod_tn,
kartab_askue.cod_st,
t1.data_new,
t1.yearmon
from 
kartab_askue Left JOIN 
(select MAX(kartkvgd_askue.yearmon) As yearmon,
MAX(kartkvgd_askue.data_new) As data_new, 
kartkvgd_askue.lic_sch As lic_sch
from 
kartkvgd_askue
where kartkvgd_askue.del=0
GROUP BY kartkvgd_askue.lic_sch) As t1 
on kartab_askue.lic_sch=t1.lic_sch
where kartab_askue.del=0
END

CREATE TABLE `dirty_data` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `date_record` date NOT NULL,
  `mon_year` varchar(7) NOT NULL,
  `lic_sch` varchar(16) DEFAULT NULL,
  `fam` varchar(64) DEFAULT NULL,
  `name` varchar(64) DEFAULT NULL,
  `otch` varchar(64) DEFAULT NULL,
  `kod_st` varchar(8) DEFAULT NULL,
  `kod_tn` varchar(8) DEFAULT NULL,
  `yearmon` date DEFAULT NULL,
  `data_new` int(11) DEFAULT NULL,
  `data_kon` int(11) DEFAULT NULL,
  `date_kon` date DEFAULT NULL,
  `base` varchar(16) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=196607 DEFAULT CHARSET=utf8;

CREATE DEFINER=`Oleg`@`` PROCEDURE `zap`()
BEGIN
INSERT INTO dirty_data(mon_year,date_record,lic_sch,data_kon,date_kon,base,fam,`name`,otch,kod_tn,kod_st,data_new,yearmon)
	select 
DATE_FORMAT(CURRENT_DATE(),'%c-%Y') As mon_year,
now() As date_record,
kartab_askue.lic_sch,
kartab_askue.data_kon,
kartab_askue.date_kon,
kartab_askue.base,
kartab_askue.fam,
kartab_askue.`name`,
kartab_askue.otch,
kartab_askue.cod_tn,
kartab_askue.cod_st,
t1.data_new,
t1.yearmon
from 
kartab_askue Left JOIN 
(select MAX(kartkvgd_askue.yearmon) As yearmon,
MAX(kartkvgd_askue.data_new) As data_new, 
kartkvgd_askue.lic_sch As lic_sch
from 
kartkvgd_askue
where kartkvgd_askue.del=0
GROUP BY kartkvgd_askue.lic_sch) As t1 
on kartab_askue.lic_sch=t1.lic_sch
where kartab_askue.del=0;

END