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