Array
(
    [status] => `p`.`status` = 1
    [0] => `o`.`status` = 1
    [cat_id] => `p2c`.`category_id` IN(4326)
    [1] => `p`.`quantity` > 0
    [2] => `o`.`type` IN('radio','checkbox','select','image','image_radio')
    [3] => `pov`.`quantity` > 0
)

SELECT DISTINCT
  pov.option_value_id
FROM oc_product_option_value AS pov WHERE 1 AND `pov`.`quantity` > 0
  AND EXISTS (
    SELECT 1
    FROM oc_option AS o
    WHERE o.option_id = pov.option_id AND `o`.`status` = 1 AND `o`.`type` IN('radio','checkbox','select','image','image_radio'))

  AND EXISTS (
    SELECT 1
    FROM oc_product AS p
    WHERE p.product_id = pov.product_id AND `p`.`status` = 1 AND `p`.`quantity` > 0) AND EXISTS (
      SELECT 1
      FROM oc_product_to_category AS p2c
      WHERE p2c.product_id  = pov.product_id AND `p2c`.`category_id` IN(4326)) ORDER BY NULL;