select e.* from 
	entities as e
inner join 
	(widgets as w inner join 
		(widget_attributes as wa inner join widget_attribute_values_varchar as wavv on wavv.attribute_id=wa.id)
	on wa.widget_id=w.id
	)
	on w.entity_id=e.id
where wa.id=w.attribute_id and wavv.value like '%тестовый%'