SELECT DISTINCT `name`, `short_description`, `options`, `related_products_keywords`, display_cat_prd.`id_product` as `display_category_product_id`, `product_id` as `display_product_id`, `products_keywords`, `is_keywords_rules_active`, `is_keywords_rules_reference`, `is_keywords_rules_name`, `is_keywords_rules_description`, `order_display` FROM `peadditionalproducttabs` apt LEFT JOIN `category_product` apt_cat ON (apt_cat.`id_category` = apt.`category_id`) LEFT JOIN `category_shop` as apt_cat_shop ON (apt_cat.`id_category` = apt_cat_shop.`id_category` AND apt_cat_shop.`id_shop` = 1) LEFT JOIN `category_product` display_cat_prd ON (display_cat_prd.`id_category` = apt.`category_products_id`) LEFT JOIN `category_shop` as display_cat_prd_shop ON (display_cat_prd.`id_category` = display_cat_prd_shop.`id_category` AND display_cat_prd_shop.`id_shop` = 1) WHERE ((apt.`id_shop_group` is null and apt.`id_shop` is null) or (apt.`id_shop_group` = 1 and apt.`id_shop` is null) or (apt.`id_shop` = 1)) AND (NULLIF(apt.`hooks`, '') IS NULL OR apt.`hooks` LIKE ('%OCL%')) AND ( ( apt.`category_id` is null AND apt.`related_product_id` is null AND `related_products_keywords` is null )OR ( apt.`category_id` is not null AND apt_cat.`id_product` in (9666) ) OR ( apt.`related_product_id` is not null AND apt.`related_product_id` in (9666) ) ) UNION SELECT DISTINCT `name`, `short_description`, `options`, `related_products_keywords`, null as `display_category_product_id`, `related_product_id` as `display_product_id`, `products_keywords`, `is_keywords_rules_active`, `is_keywords_rules_reference`, `is_keywords_rules_name`, `is_keywords_rules_description`, `order_display` FROM `peadditionalproducttabs` apt WHERE ((apt.`id_shop_group` is null and apt.`id_shop` is null) or (apt.`id_shop_group` = 1 and apt.`id_shop` is null) or (apt.`id_shop` = 1)) AND (NULLIF(apt.`hooks`, '') IS NULL OR apt.`hooks` LIKE ('%OCL%')) AND apt.`is_reciprocity` = 1 AND apt.`related_product_id` is not null AND apt.`product_id` is not null AND apt.`product_id` in (9666) ORDER BY `order_display` ASC