SELECT DISTINCT ps4_options.OptionID, OptionName, ps4_optiongroups.GroupIsSimple FROM ps4_options INNER JOIN ps4_optiongroups ON ps4_optiongroups.OptionGroupID = ps4_options.OptionGroupID LEFT OUTER JOIN ps4_productoptions on ps4_options.OptionID = ps4_productoptions.OptionID LEFT OUTER JOIN ps4_products on ps4_products.ProductID = ps4_productoptions.ProductID WHERE ps4_options.OptionGroupID = 184 AND (ps4_products.ProductStartDate IS NULL OR ps4_products.ProductStartDate <= CURDATE()) AND (ps4_products.ProductEndDate IS NULL OR ps4_products.ProductEndDate >= CURDATE()) ORDER BY ps4_options.display_order ASC
checking availability...
