Something

SELECT items.sku, type_option_values.valueFROM `items`INNER JOIN `types` ON types.type_id = items.type_idINNER JOIN `type_option_values` ON type_option_values.sku = items.skuINNER JOIN `type_options` ON type_options.option_id = type_option_values.option_idWHERE (types.type_name = 'page'OR types.type_name = 'clearpak'OR types.type_name = 'megapak')AND type_options.option_name IN ('category','color')AND type_option_values.value = 'garden_flowers'AND ((active =1)OR (active =0AND discontinue_date >1124999045))ORDER BY items.description ASC , items.type_id, items.item_number ASCLIMIT 0 , 30