WITH prior_select AS (
	SELECT
		vtly_medication_order.vtly_number AS orderNo,
		vtly_medication.vtly_number AS medNo
	FROM
		vtly_medication_order,
		vtly_medication
	WHERE
		vtly_medication_order.fhir_data -> 'patient' @> '{"reference":"http://clinical.vitaly.parsek.com/Patient/VTLYPX-1"}'
	AND vtly_medication.vtly_number IN (
		SELECT
			CAST (
				REPLACE (
					vtly_medication_order.fhir_data -> 'medicationReference' ->> 'reference',
					'http://clinical.vitaly.parsek.com/Medication/VTLYF-',
					''
				) AS INTEGER
			)
	)
	AND vtly_medication.fhir_data -> 'code' ->> 'text' ILIKE '%foobar%'
) SELECT
	fhir_data
FROM
	vtly_medication_order
WHERE
	vtly_number IN (
		SELECT
			orderNo
		FROM
			prior_select
	)
UNION
	SELECT
		fhir_data
	FROM
		vtly_medication
	WHERE
		vtly_number IN (
			SELECT
				medNo
			FROM
				prior_select
		)