SELECT DISTINCT pp.id, pp.name, pp.slug
FROM kalinin_product_property pp
INNER JOIN kalinin_product_specifics ps ON ps.id_property = pp.id
WHERE pp.filter = 1
AND ps.id_product IN (26,35,39,40,41,42,43,44,45,47,48,49,53,54,55,56,57,58,59,60,61,62,63,64,66,68,69,70,71,72,73,74,75,76,77,78,79,80,81,84,85,86,87,88,89,90,92,93,94,95,99,100,101,102,103,104,105,106,107,108,109,110,112,113,117,121,122,1468,1486,1506,1534,1542,1555,1557,1...