`id_product_attribute` int UNSIGNED NOT NULL,

`id_product` int UNSIGNED NOT NULL,

`quantity` int NOT NULL DEFAULT '0'

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

INSERT INTO `psfr_product_attribute` (`id_product_attribute`, `id_product`, `quantity`) VALUES

(195, 59, 5),

(196, 59, 0),

(197, 59, 5),

(198, 59, 0),

(199, 59, 5),

(200, 59, 5),

(201, 59, 5),

(202, 59, 5);

CREATE TABLE `psfr_product_attribute_combination` (

`id_attribute` int UNSIGNED NOT NULL,

`id_product_attribute` int UNSIGNED NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

INSERT INTO `psfr_product_attribute_combination` (`id_attribute`, `id_product_attribute`) VALUES

(2, 195),

(10, 195),

(2, 196),

(11, 196),

(3, 197),

(10, 197),

(3, 198),

(11, 198),

(4, 199),

(10, 199),

(4, 200),

(11, 200),

(1, 201),

al1.name size,

al2.name color

FROM psfr_product_attribute pa

JOIN psfr_product_attribute_combination pac1 ON pa.id_product_attribute = pac1.id_product_attribute

JOIN psfr_attribute_lang al1 ON pac1.id_attribute = al1.id_attribute

JOIN psfr_product_attribute_combination pac2 ON pa.id_product_attribute = pac2.id_product_attribute

JOIN psfr_attribute_lang al2 ON pac2.id_attribute = al2.id_attribute

WHERE pa.id_product = 59

AND al1.id_attribute IN (1,2,3,4)

AND al2.id_attribute IN (10,11)

AND al1.id_lang = 1

AND al2.id_lang = 1

AND pa.quantity > 0