in the productoptions table, the the GroupingID column relates to the optionsgroups table OptionGroupID column, and to the ps4_options table OptionGroupID.
look in the optiongroup table and find the OptionGroupID value for the Size OptionGroup Name.
then you can use a JOIN query to return the sizes available for a product using the product ID and the Size options group ID, for example:
SELECT ps4_options.optionName
FROM ps4_options
INNER JOIN ps4_productoptions
ON ps4_options.OptionGroupID = ps4_productoptions.GroupingID
WHERE ps4_options.OptionGroupID = '1' AND ps4_productoptions.ProductID = '1'
GROUP BY ps4_options.optionName
If you need further assistance with this, we can help you in a premiere support appointment.
