Query opzioni prodotti opencart

option_value_opencart.sql

SELECT   `oc_option_value`.`option_value_id` 
        , `oc_product_option_value`.`product_option_value_id`
        , `oc_option_description`.`name`
FROM
    `oc_product_option_value`
LEFT JOIN `oc_option_value`
    ON
    `oc_option_value`.`option_value_id` = `oc_product_option_value`.`option_value_id`
LEFT JOIN `oc_option`
    ON    
    `oc_option`.`option_id` = `oc_option_value`.`option_id`
LEFT JOIN `oc_option_description`
    ON 
    `oc_option_description`.`option_id` = `oc_option`.`option_id`
LEFT JOIN `oc_product_option`
    ON 
    `oc_product_option`.`product_option_id` = `oc_product_option_value`.`product_option_id`
WHERE 1=1

GROUP BY `oc_product_option_value`.`option_value_id`