NewQuery8.sql

select
	ewf.tagexec,
	evocount.tree_reference,
	evocount.frequency
from
	(
		select
			ewf.ewkfid,
			tree.tree_reference,
			tree.frequency
		from
			(
				select
					distinct evo.tree_reference,
					evo.frequency
				from
					sciphytreeminer.oevotreeparser_{metodo1_metodo2} as evo inner join(
						select
							mevo.tree_reference,
							max( mevo.frequency ) as frequency
						from
							sciphytreeminer.oevotreeparser_{metodo1_metodo2} as mevo
						group by
							mevo.tree_reference
					) as maxevo on
					evo.frequency = maxevo.frequency
			) as tree inner join(
				select
					distinct evo.ewkfid,
					evo.tree_reference
				from
					sciphytreeminer.oevotreeparser_{metodo1_metodo2} as evo
			) as ewf on
			ewf.tree_reference = tree.tree_reference
	) as evocount inner join eworkflow as ewf on
	ewf.ewkfid = evocount.ewkfid