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 (2,5,7,20,25,28,69,92,104,107,136,137,140,145,149,157,163,168,170,177,179,189,190,200,208,215,217,219,222,224,226,228,230,235,236,243,246,248,249,250,252,256,257,269,271,272,274,276,278,280,290,292,294,296,299,301,325,346,360,366,373,381,385,390,400,401,...