SELECT e3.primaryid,
	e2.some_column
FROM entity3 AS e3
INNER JOIN entity2 AS e2 ON e3.entity2id = e2.primaryid
INNER JOIN entity1 AS e1 ON e2.entity1id = e1.primaryid
INNER JOIN entity0 AS e0 ON e1.entity0id = e0.primaryid
WHERE e2.primaryid IN (
		SELECT _e2.primaryid
		FROM entity2 AS _e2
		INNER JOIN entity1 AS _e1 ON _e2.entity1id = _e1.primaryid
		INNER JOIN entity0 AS _e0 ON _e1.entity0id = _e0.primaryid
		WHERE _e2.some_column = 948370000 --PicklistType
			AND (
				_e0.some_column = 0
				OR _e2.some_column IN ('xxx')
				)
		);