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,3,4,5,6,7,8,9,14,17,20,21,22,23,24,25,26,27,28,29,30,31,32,136,137,140,145,148,149,153,156,157,163,168,170,177,179,189,190,200,208,217,226,235,272,276,280,282,311,325,360,366,373,381,385,390,400,401,403,404,405,406,407,408,409,410,411,412,694,695,696,...