create table tmp_(SELECT
				*
			FROM
				shzy.social_qd_db_all_dxy a 
			WHERE
				1 = 1 
			and pz_date >= DATE_FORMAT('2019-03-25 10:01:01','%Y-%m-%d %H:%i:%s') 
			and pz_date <= DATE_FORMAT('2019-03-25 10:15:00','%Y-%m-%d %H:%i:%s') 
			);

select a.* from tmp_ a ,tmp_ b where a.cph!=b.cph 
and 0 < TIMESTAMPDIFF(MINUTE, a.pz_date, b.pz_date)<10
and 0 < TIMESTAMPDIFF(MINUTE, a.mz_date, b.mz_date)<10
and 0 < a.mz - b.mz <500;

drop table shzy.tmp_;