MySQL 5.7

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE oc_product (
  product_id int(11) NOT NULL,
  model varchar(64) NOT NULL,
  quantity int(11)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


INSERT INTO `oc_product` (`product_id`, `model`, `quantity`) VALUES
(1, '8010054', 4),
(2, '803330054', 5);
CREATE TABLE oc_product_attribute (
  product_id int(11) NOT NULL,
  attribute_id int(11) NOT NULL,
  language_id int(11) NOT NULL,
  text text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

INSERT INTO `oc_product_attribute` (`product_id`, `attribute_id`, `language_id`, `text`) VALUES
(1, 1, 1, 'бриллиант'),
(1, 6, 1, 'жемчуг'),
(1, 5, 1, 'Красное'),
(2, 5, 1, 'Красное'),
(1, 7, 1, 'Белое'),
(2, 7, 1, 'Белое'),
(1, 3, 1, 'Для женщин'),
(1, 2, 1, 'белый'),
(2, 2, 1, 'белый'),
(1, 8, 1, 'Золото 585'),
(1, 9, 1, '17 р.'),
(1, 10, 1, 'хризолит');
-- How attrs counts before HAVING applied
SELECT p.product_id, MIN(p.model) model, GROUP_CONCAT(attr.attribute_id order by attr.attribute_id ASC)
, SUM(attr.attribute_id IN (5)) a5
, SUM(attr.attribute_id IN (6)) a6
, SUM(attr.attribute_id IN (7)) a7
FROM oc_product p 
INNER JOIN oc_product_attribute attr ON attr.product_id = p.product_id
WHERE p.quantity > 0
GROUP BY p.product_id 


product_id
model
GROUP_CONCAT(attr.attribute_id order by attr.attribute_id ASC)
a5
a6
a7


1
8010054
1,2,3,5,6,7,8,9,10
1
1
1

2
803330054
2,5,7
1
0
1


SELECT p.product_id, MIN(p.model) model, GROUP_CONCAT(attr.attribute_id)
FROM oc_product p 
INNER JOIN oc_product_attribute attr ON attr.product_id = p.product_id
WHERE p.quantity > 0
GROUP BY p.product_id 
HAVING SUM(attr.attribute_id IN (5)) > 0
  AND  SUM(attr.attribute_id IN (6)) > 0
  AND  SUM(attr.attribute_id IN (7)) > 0


product_id
model
GROUP_CONCAT(attr.attribute_id)


1
8010054
7,9,8,5,6,2,1,3,10


 SELECT p.model,
         p.product_id
            
FROM oc_product p
WHERE p.quantity > 0
  AND EXISTS(SELECT 1 FROM oc_product_attribute WHERE 
    product_id=p.product_id and attribute_id IN (5))
  AND EXISTS(SELECT 1 FROM oc_product_attribute WHERE 
    product_id=p.product_id and attribute_id IN (6))
  AND EXISTS(SELECT 1 FROM oc_product_attribute WHERE 
    product_id=p.product_id and attribute_id IN (7));


model
product_id


8010054
1


 SELECT p.model,
         p.product_id
            
FROM oc_product p
JOIN oc_product_attribute a1 ON a1.product_id=p.product_id AND a1.attribute_id IN (5)
JOIN oc_product_attribute a2 ON a2.product_id=p.product_id AND a2.attribute_id IN (6)
JOIN oc_product_attribute a3 ON a3.product_id=p.product_id AND a3.attribute_id IN (7)
WHERE p.quantity > 0


model
product_id


8010054
1


-- Original one

 SELECT p.model,
         p.product_id
            
FROM oc_product p
JOIN oc_product_attribute a1 ON a1.product_id=p.product_id
JOIN oc_product_attribute a2 ON a2.product_id=p.product_id
JOIN oc_product_attribute a3 ON a3.product_id=p.product_id
WHERE p.quantity > 0
 AND a1.attribute_id IN (5)
 AND a2.attribute_id IN (6)
 AND a3.attribute_id IN (7)


model
product_id


8010054
1