-- create table sel(id int identity primary key, id_name int, id_val int);
-- insert sel (id_name,id_val)values(2,41),(3,46),(4,62),(5,65);

-- set statistics io,time on
SELECT r.message_id
	FROM jos_md_catalog_message_criterions r with(index(0))
	join sel s on s.id_name=r.id_criterions_name and s.id_val=r.id_criterions_values
	GROUP BY r.message_id
	HAVING count(distinct s.id) = (select COUNT(*) from sel)
SELECT r.message_id
	FROM jos_md_catalog_message_criterions r with(index=IX_MessNameCrit)
	join sel s on s.id_name=r.id_criterions_name and s.id_val=r.id_criterions_values
	GROUP BY r.message_id
	HAVING count(distinct s.id) = (select COUNT(*) from sel)
SELECT r.message_id
	FROM jos_md_catalog_message_criterions r with(index=IX_NameCrit)
	join sel s on s.id_name=r.id_criterions_name and s.id_val=r.id_criterions_values
	GROUP BY r.message_id
	HAVING count(distinct s.id) = (select COUNT(*) from sel)
SELECT r.message_id
	FROM jos_md_catalog_message_criterions r with(index=IX_NameCritMess)
	join sel s on s.id_name=r.id_criterions_name and s.id_val=r.id_criterions_values
	GROUP BY r.message_id
	HAVING count(distinct s.id) = (select COUNT(*) from sel)

SELECT r.message_id
	FROM jos_md_catalog_message_criterions r with(index(0))
	where 
		r.id_criterions_name=2 and r.id_criterions_values=41 or
		r.id_criterions_name=3 and r.id_criterions_values=46 or
		r.id_criterions_name=4 and r.id_criterions_values=62 or
		r.id_criterions_name=5 and r.id_criterions_values=65
	GROUP BY r.message_id
	HAVING count(distinct r.id_criterions_name*100+r.id_criterions_values) = 4
SELECT r.message_id
	FROM jos_md_catalog_message_criterions r with(index=IX_MessNameCrit)
	where 
		r.id_criterions_name=2 and r.id_criterions_values=41 or
		r.id_criterions_name=3 and r.id_criterions_values=46 or
		r.id_criterions_name=4 and r.id_criterions_values=62 or
		r.id_criterions_name=5 and r.id_criterions_values=65
	GROUP BY r.message_id
	HAVING count(distinct r.id_criterions_name*100+r.id_criterions_values) = 4
SELECT r.message_id
	FROM jos_md_catalog_message_criterions r with(index=IX_NameCrit)
	where 
		r.id_criterions_name=2 and r.id_criterions_values=41 or
		r.id_criterions_name=3 and r.id_criterions_values=46 or
		r.id_criterions_name=4 and r.id_criterions_values=62 or
		r.id_criterions_name=5 and r.id_criterions_values=65
	GROUP BY r.message_id
	HAVING count(distinct r.id_criterions_name*100+r.id_criterions_values) = 4
SELECT r.message_id
	FROM jos_md_catalog_message_criterions r with(index=IX_NameCritMess)
	where 
		r.id_criterions_name=2 and r.id_criterions_values=41 or
		r.id_criterions_name=3 and r.id_criterions_values=46 or
		r.id_criterions_name=4 and r.id_criterions_values=62 or
		r.id_criterions_name=5 and r.id_criterions_values=65
	GROUP BY r.message_id
	HAVING count(distinct r.id_criterions_name*100+r.id_criterions_values) = 4

-- set statistics io,time off