INSERT INTO `profi_audit`.`user`
SELECT
	`u`.`id`
	,`u`.`lastname`
	,`u`.`name`
	,IF(`u`.`sex`=1,'male',IF(`u`.`sex`=2,'female',null)) AS `gender`
	,TIMESTAMPDIFF(
		YEAR,
		CONCAT_WS('-',YEAR(`u`.`birthday`),IF(MONTH(`u`.`birthday`),MONTH(`u`.`birthday`),'01'),IF(DAY(`u`.`birthday`),DAY(`u`.`birthday`),'01')),
		CURDATE()
	) AS `age`
	,`u`.`city`
	,concat('{"0":"',`u`.`phone`,'"}') AS `phones`
	,100 AS `karma`
	,'' AS `extra`
FROM	`profi_research`.`user` AS `u`
WHERE	`u`.`id` IN (111);


INSERT INTO `profi_audit`.`answer`
SELECT
	`a`.`user`,`a`.`research` AS `survey`,`a`.`question`,`a`.`answer`
FROM	`profi_research`.`survey_answer` AS `a`
WHERE	`a`.`research`	= 3286
AND		`a`.`user`		IN (SELECT `id` FROM `profi_audit`.`user`)
AND		`a`.`question`	IN (96,3432,3433,3434,3435,3436,3437,3438,3439,3440,3441,3442,3443,3452,3453)