mysql (UM1)> 

with 

	table2 as (select id_col,column1,column2 from location where column1='123456789AB-1001-A01-A-A1'), 

	cands as( select 

			ident,sum(if(column2<0.005,abs(a.column1-b.column1),0)) as val1,

			sum(if(column2>=0.005 and column2<0.2,if(abs(a.column1-b.column1)=0,1,0),0)) as val2,

			count(*) as total 

		from 

			test_quorum a,

			table2 b 

		where 

			a.id_col=b.id_col 

		group by ident 

		having val1<3 and val2<3 and total>40), 

	data as ( select 

			column2,

			abs(a.column1-b.column1) as column1,

			b.ident as ident 

		from 

			table2 a,

			test_quorum b 

		where 

			a.id_col=b.id_col 

		and b.ident in (select distinct ident from cands) 

		and column2<0.2 

		order by b.ident,column2), 

	curve as ( select 

			ident,

			column1,

			lag(column1) over(partition by ident order by column2) as lg 

		from data) 

select 

	a.ident,

	sum(if(ifnull(lg,0)<=column1,0,1)) as factor,

	b.val1,

	b.val2 

from 

	curve a,

	cands b 

where 

	a.ident=b.ident 

group by 

	ident,

	val1,

	sum2 

having 

	factor<=1; 

+------------+-------------------+-----------+-----------+

| ident | factor | val1 | val2 |

+------------+-------------------+-----------+-----------+

| 833NN98765 | 1 | 2 | 0 |

| 133NN43210 | 1 | 0 | 1 |

+------------+-------------------+-----------+-----------+

2 rows in set

Time: 0.718s

mysql (UM2)> 

with 

	table2 as (select id_col,column1,column2 from location where column1='123456789AB-1001-A01-A-A1'), 

	cands as(select 

			ident,

			sum(if(column2<0.005,abs(a.column1-b.column1),0)) as val1, 

			sum(if(column2>=0.005 and column2<0.2,if(abs(a.column1-b.column1)=0,1,0),0)) as val2,

			count(*) as total 

		from 

			test_quorum a,

			table2 b 

		where a.id_col=b.id_col group by ident having val1<3 and val2<3 and total>40), 

	data as (select 

			column2,

			abs(a.column1-b.column1) as column1,

			b.ident as ident 

		from 

			table2 a,

			test_quorum b 

		where 

			a.id_col=b.id_col 

		and b.ident in (select distinct ident from cands) 

		and column2<0.2 order by b.ident,column2), 

	curve as ( select 

			ident,column1,

			lag(column1) over(partition by ident order by column2) as lg 

		from data) 

select 

	a.ident,

	sum(if(ifnull(lg,0)<=column1,0,1)) as factor,

	b.val1,

	b.val2 

from 

	curve a,

	cands b 

where 

	a.ident=b.ident 

group by 

	ident,

	val1,

	sum2 

having factor<=1; 

+------------+-------------------+-----------+-----------+

| ident | factor | val1 | val2 |

+------------+-------------------+-----------+-----------+

| 133NN43210 | 1 | 0 | 1 |

+------------+-------------------+-----------+-----------+

1 row in set

Time: 0.691s