-- try something like:

SELECT i.sku, tov.value
FROM
	type_option_values tov,
	type_options to,
	items i
WHERE tov.value = 'garden_flowers'
AND to.option_name = 'unit_color'
AND tov.option_id = to.option_id
AND i.sku = tov.sku;

-- it would be more helpful to have the output of SHOW CREATE TABLE... available so we could copy-and-paste and test it live in mysql
-- Love, pizza