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 (3,6,8,9,10,11,22,23,24,27,29,35,69,81,92,104,107,121,123,125,127,128,129,130,131,132,135,136,137,145,149,157,163,170,200,208,217,224,226,235,243,250,269,272,280,282,290,292,294,296,301,307,309,311,313,315,316,320,323,324,325,360,366,371,373,379,381,384,...