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 (1,3,4,6,8,9,10,11,12,13,14,22,23,24,27,29,30,31,35,69,92,104,107,121,123,125,127,128,129,130,131,132,136,137,140,143,145,147,148,149,153,156,157,163,168,170,177,179,184,189,190,194,200,201,203,208,211,212,217,221,222,224,226,228,230,235,243,248,249,250,...