11.95 ms
1
SELECT a . id as group_id , a . code , a . name_ru , a . name_de , a . sort ,
a . is_metric , a . is_deeplink , a . is_filterable , a . use_deeplink_code ,
a . group_sort , a . group_name_ru , a . group_name_de ,
av . uid as value_id , av . name_ru as value_ru , av . name_de as value_de
FROM attribute_value AS av
JOIN attribute AS a on a . code = av . code
WHERE av . uid IN ('coolbox_filter_0' , 'freezebox_filter_3' , 'netto_gewicht_filter_3' , 'verpackung_2870' , 'netto_gewicht_filter_4' , 'netto_gewicht_filter_5' , 'art_2163' , 'freezebox_filter_2' , 'family_693' , 'verpackung_2954' , 'netto_gewicht_filter_2' , 'verpackung_4205' , 'netto_gewicht_filter_1' , 'coolbox_filter_1' , 'verpackung_3121' , 'netto_gewicht_filter_6' , 'verpackung_3948' , 'art_der_suessigkeiten_34384' , 'verpackung_35918' , 'fleischart_15470' , 'family_376' , 'vendor_531' , 'family_688' , 'verpackung_4003' , 'verpackung_37215' , 'handelsform_3535' , 'verpackung_36357' , 'geschmack_26932' , 'vendor_458' , 'laenderkueche_36352' , 'family_1072' , 'family_932' , 'verpackung_24689' , 'laenderkueche_36350' , 'family_1275' , 'art_25334' , 'handelsform_3534' , 'sorte_3536' , 'geschmack_23761' , 'family_1152' , 'vendor_386' , 'fleischart_15474' , 'fuellung_36388' , 'family_981' , 'family_1078' , 'vendor_196' , 'vendor_357' , 'geschmack_23757' , 'family_692' , 'geschmack_29765' , 'sorte_26188' , 'art_der_suessigkeiten_42806' , 'family_921' , 'geschmack_23765' , 'getreideart_15473' , 'netto_fuellmenge_filter_5' , 'verpackung_3840' , 'family_716' , 'geschmack_36384' , 'family_1073' , 'family_999' , 'family_922' , 'family_971' , 'art_15477' , 'art_39784' , 'fleischart_47539' , 'vendor_1232' , 'verpackung_5933' , 'family_684' , 'fuellung_36365' , 'verpackung_27725' , 'art_der_suessigkeiten_34102' , 'family_1002' , 'typ_36792' , 'verpackung_14402' , 'getreideart_25277' , 'laenderkueche_43012' , 'family_850' , 'vendor_1298' , 'art_56006' , 'geschmack_29768' , 'vendor_529' , 'family_724' , 'geschmack_23753' , 'geschmack_23781' , 'family_760' , 'art_56994' , 'art_der_suessigkeiten_39611' , 'family_1101' , 'family_1220' , 'geschmack_23759' , 'laenderkueche_36354' , 'family_980' , 'sorte_15484' , 'family_1211' , 'family_589' , 'family_687' , 'geschmack_26601' , 'handelsform_5934' , 'art_der_suessigkeiten_40017' , 'family_683' , 'teigwarenart_25243' , 'vendor_42' , 'handelsform_35601' , 'feiertage_819' , 'laenderkueche_36349' , 'family_1035' , 'vendor_380' , 'family_865' , 'vendor_114' , 'family_685' , 'fischart_29659' , 'geschmack_25688' , 'vendor_159' , 'verpackung_9455' , 'handelsform_5911' , 'vendor_231' , 'family_1213' , 'feiertage_960' , 'geschmack_36009' , 'art_54870' , 'vendor_1258' , 'art_30399' , 'art_der_suessigkeiten_46435' , 'family_1228' , 'family_577' , 'geschmack_23762' , 'netto_fuellmenge_filter_4' , 'vendor_1409' , 'vendor_156' , 'vendor_158' , 'verwendungszweck_4215' , 'family_1232' , 'family_880' , 'family_920' , 'getreideart_23707' , 'verwendungszweck_46428' , 'art_der_suessigkeiten_35208' , 'art_der_suessigkeiten_40018' , 'family_1026' , 'family_711' , 'geschmack_23756' , 'geschmack_23774' , 'family_594' , 'geschmack_24694' , 'fuellung_51141' , 'getreideart_23671' , 'vendor_1152' , 'vendor_150' , 'vendor_224' , 'family_689' , 'fuellung_39590' , 'art_29786' , 'art_56995' , 'art_der_suessigkeiten_36995' , 'feiertage_820' , 'geschmack_42730' , 'vendor_216' , 'fischart_29660' , 'vendor_482' , 'vendor_716' , 'art_51799' , 'geschmack_23778' , 'getreideart_15476' , 'vendor_135' , 'vendor_198' , 'art_29787' , 'family_1212' , 'family_1241' , 'feiertage_1130' , 'typ_26962' , 'vendor_1395' , 'art_55439' , 'art_56940' , 'family_1286' , 'family_418' , 'geschmack_23770' , 'vendor_1135' , 'vendor_752' , 'family_1044' , 'fleischart_47119' , 'fuellung_46951' , 'fuellung_51117' , 'netto_gewicht_filter_7' , 'vendor_1313' , 'vendor_404' , 'vendor_923' , 'verpackung_3653' , 'art_der_suessigkeiten_39960' , 'family_1168' , 'family_462' , 'fischart_29740' , 'geschmack_35867' , 'vendor_1016' , 'anzahl_der_portionen_35937' , 'getreideart_23711' , 'vendor_895' , 'verpackung_26798' , 'art_54139' , 'art_der_suessigkeiten_56942' , 'family_1231' , 'family_771' , 'fischart_29998' , 'geschmack_52741' , 'handelsform_27113' , 'netto_fuellmenge_filter_3' , 'vendor_881' , 'verpackung_38799' , 'verpackung_42548' , 'art_56007' , 'fettanteil_52859' , 'geschmack_23755' , 'modelname_40223' , 'vendor_1179' , 'vendor_179' , 'vendor_221' , 'vendor_489' , 'art_54631' , 'family_1049' , 'family_1065' , 'family_1080' , 'family_1234' , 'family_691' , 'family_867' , 'laenderkueche_50808' , 'vendor_134' , 'vendor_1377' , 'vendor_860' , 'vendor_938' , 'art_27151' , 'family_1027' , 'family_1114' , 'family_1210' , 'family_1233' , 'family_629' , 'family_682' , 'family_973' , 'family_986' , 'fischart_37803' , 'fischart_54823' , 'geschmack_23747' , 'geschmack_26600' , 'geschmack_39591' , 'geschmack_43102' , 'serie_44880' , 'serie_51387' , 'typ_23685' , 'vendor_1521' , 'vendor_165' , 'vendor_922' , 'art_57036' , 'art_der_suessigkeiten_40113' , 'family_778' , 'geschmack_23764' , 'vendor_1027' , 'vendor_1292' , 'vendor_1348' , 'vendor_1373' , 'vendor_186' , 'vendor_381' , 'vendor_424' , 'vendor_725' , 'vendor_762' , 'art_29791' , 'art_54697' , 'family_1054' , 'family_1118' , 'family_789' , 'family_854' , 'family_975' , 'family_978' , 'fischart_29999' , 'fischart_36125' , 'fuellung_51115' , 'geschmack_23776' , 'geschmack_26612' , 'geschmack_32270' , 'manufacturer_53914' , 'vendor_679' , 'vendor_897' , 'vendor_944' , 'verpackung_3154' , 'verwendungszweck_2755' , 'volumen_2424' , 'art_23066' , 'art_54632' , 'art_55436' , 'family_1028' , 'family_441' , 'family_935' , 'geschmack_23763' , 'geschmack_36938' , 'getreideart_15480' , 'getreideart_15481' , 'handelsform_6235' , 'teigwarenart_38803' , 'vendor_1028' , 'vendor_1191' , 'vendor_1330' , 'vendor_1412' , 'vendor_1593' , 'vendor_751' , 'verpackung_4977' , 'verwendungszweck_5081' , 'verwendungszweck_7957' , 'anwendungszeit_2288' , 'art_51800' , 'art_56939' , 'family_1077' , 'family_699' , 'family_886' , 'family_977' , 'fischart_35526' , 'fischart_38548' , 'fuellung_52550' , 'fuellung_53397' , 'sorte_51687' , 'typ_27609' , 'typ_35555' , 'vendor_1214' , 'vendor_1216' , 'vendor_1228' , 'vendor_1317' , 'vendor_1374' , 'vendor_162' , 'vendor_171' , 'vendor_402' , 'vendor_499' , 'vendor_834' , 'aroma_3539' , 'art_29796' , 'art_37185' , 'family_1129' , 'family_1260' , 'family_1280' , 'family_754' , 'fischart_43299' , 'fuellung_36847' , 'fuellung_54431' , 'geschmack_23775' , 'geschmack_24687' , 'geschmack_36380' , 'sorte_7952' , 'vendor_1462' , 'vendor_149' , 'vendor_486' , 'vendor_759' , 'vendor_962' , 'verpackung_3609' , 'weinart_53885' , 'aroma_7551' , 'art_36372' , 'art_39785' , 'family_1000' , 'family_690' , 'fettanteil_54147' , 'fischart_37812' , 'fuellung_51760' , 'geschmack_23749' , 'geschmack_23766' , 'geschmack_31753' , 'geschmack_35745' , 'laenderkueche_36355' , 'netto_fuellmenge_filter_2' , 'pastete_sorten_29724' , 'pastete_sorten_29725' , 'serie_39543' , 'vendor_1031' , 'vendor_1226' , 'vendor_1255' , 'vendor_1476' , 'vendor_413' , 'vendor_477' , 'vendor_511' , 'vendor_553' , 'vendor_721' , 'vendor_724' , 'vendor_728' , 'art_39778' , 'art_53069' , 'art_54199' , 'family_1102' , 'family_1106' , 'family_1167' , 'family_1215' , 'family_1219' , 'family_752' , 'feiertage_825' , 'fuellung_39832' , 'geschmack_23779' , 'geschmack_26602' , 'geschmack_26929' , 'geschmack_36155' , 'geschmack_53621' , 'getreideart_23709' , 'laenderkueche_43013' , 'serie_39534' , 'typ_34174' , 'vendor_1113' , 'vendor_1383' , 'vendor_177' , 'vendor_192' , 'vendor_309' , 'vendor_579' , 'vendor_637' , 'vendor_914' , 'vendor_960' , 'verpackung_6308' , 'anzahl_der_portionen_35938' , 'aroma_3546' , 'art_23067' , 'art_7540' , 'family_1169' , 'family_976' , 'fleischart_30153' , 'fuellung_39485' , 'fuellung_39488' , 'geschmack_23783' , 'geschmack_45116' , 'geschmack_51195' , 'serie_55241' , 'sorte_39243' , 'vendor_111' , 'vendor_1125' , 'vendor_1173' , 'vendor_1296' , 'vendor_1316' , 'vendor_140' , 'vendor_1507' , 'vendor_227' , 'vendor_743' , 'vendor_954' , 'vendor_989' , 'verwendungszweck_2752' , 'verwendungszweck_35606' , 'volumen_1460' , 'altergruppierung_54019' , 'altergruppierung_6272' , 'anzahl_der_artikel_2679' , 'art_23723' , 'art_37143' , 'art_56221' , 'art_der_beeren_53100' , 'family_1226' , 'family_686' , 'family_756' , 'family_769' , 'family_770' , 'feiertage_821' , 'feiertage_826' , 'fettanteil_53700' , 'fischart_43325' , 'fuellung_39647' , 'fuellung_39651' , 'fuellung_51842' , 'fuellung_52241' , 'geschmack_23754' , 'geschmack_26611' , 'geschmack_26964' , 'geschmack_36921' , 'geschmack_38999' , 'geschmack_39836' , 'geschmack_39953' , 'pastete_sorten_29718' , 'serie_53575' , 'vendor_1015' , 'vendor_1070' , 'vendor_1133' , 'vendor_1153' , 'vendor_1158' , 'vendor_1218' , 'vendor_1318' , 'vendor_1422' , 'vendor_1466' , 'vendor_1472' , 'vendor_1508' , 'vendor_1540' , 'vendor_1598' , 'vendor_414' , 'vendor_430' , 'vendor_441' , 'vendor_449' , 'vendor_457' , 'vendor_552' , 'vendor_639' , 'vendor_641' , 'vendor_681' , 'vendor_755' , 'vendor_862' , 'vendor_991' , 'verwendungszweck_6088' , 'art_33908' , 'art_35238' , 'art_37170' , 'art_54194' , 'family_1009' , 'family_1031' , 'family_1074' , 'family_1214' , 'family_757' , 'family_974' , 'feiertage_823' , 'fettanteil_51891' , 'fuellung_29777' , 'fuellung_36364' , 'fuellung_52846' , 'geschmack_23758' , 'geschmack_23782' , 'geschmack_36940' , 'geschmack_54329' , 'getreideart_15482' , 'sorte_45806' , 'teigwarenart_25246' , 'vendor_1104' , 'vendor_1106' , 'vendor_116' , 'vendor_1240' , 'vendor_1328' , 'vendor_1372' , 'vendor_1394' , 'vendor_1406' , 'vendor_1433' , 'vendor_1459' , 'vendor_1464' , 'vendor_1496' , 'vendor_1529' , 'vendor_1545' , 'vendor_178' , 'vendor_267' , 'vendor_431' , 'vendor_533' , 'vendor_772' , 'verpackung_31703' , 'verwendungszweck_135' , 'anzahl_der_portionen_50815' , 'aroma_55191' , 'art_14443' , 'art_35236' , 'art_39627' , 'art_52277' , 'art_53592' , 'art_54630' , 'art_54638' , 'art_56253' , 'art_der_beeren_53103' , 'family_1032' , 'family_1033' , 'family_697' , 'family_773' , 'family_972' , 'fischart_29664' , 'fischart_54769' , 'fuellung_42734' , 'fuellung_51125' , 'fuellung_51170' , 'fuellung_51734' , 'fuellung_55934' , 'geschlecht_65' , 'geschmack_23760' , 'geschmack_26605' , 'geschmack_39002' , 'geschmack_39945' , 'grossen_38388' , 'materialgruppierung_33495' , 'netto_gewicht_filter_9' , 'serie_34905' , 'serie_54773' , 'typ_55466' , 'vendor_1025' , 'vendor_1165' , 'vendor_1187' , 'vendor_1205' , 'vendor_1289' , 'vendor_1297' , 'vendor_1337' , 'vendor_1376' , 'vendor_1483' , 'vendor_1495' , 'vendor_153' , 'vendor_1549' , 'vendor_1582' , 'vendor_1595' , 'vendor_274' , 'vendor_277' , 'vendor_537' , 'vendor_554' , 'vendor_608' , 'vendor_685' , 'vendor_785' , 'vendor_852' , 'vendor_861' , 'vendor_869' , 'vendor_924' , 'vendor_980' , 'verpackung_45261' , 'verpackung_46731' , 'verwendungszweck_17979' , 'verwendungszweck_2256' , 'verwendungszweck_29892' , 'verwendungszweck_41370' , 'aroma_26886' , 'aroma_4227' , 'aroma_4975' , 'aroma_4976' , 'art_36368' , 'art_37171' , 'art_37854' , 'art_54635' , 'art_54694' , 'art_54695' , 'art_55179' , 'art_56419' , 'art_der_beeren_53566' , 'art_der_beeren_54072' , 'art_der_beeren_54397' , 'extract_53040' , 'family_1120' , 'family_1131' , 'family_1229' , 'family_1249' , 'family_755' , 'fettanteil_43969' , 'fettanteil_52040' , 'fischart_43320' , 'fischart_43337' , 'fischart_52914' , 'fuellung_52898' , 'geschlecht_66' , 'geschmack_36935' , 'geschmack_44672' , 'geschmack_51196' , 'geschmack_54650' , 'laenderkueche_51124' , 'manufacturer_53916' , 'manufacturer_57302' , 'serie_36417' , 'serie_44736' , 'teigwarenart_25230' , 'typ_48885' , 'vendor_1018' , 'vendor_1160' , 'vendor_1207' , 'vendor_1342' , 'vendor_1350' , 'vendor_1410' , 'vendor_1435' , 'vendor_1455' , 'vendor_1456' , 'vendor_1555' , 'vendor_1588' , 'vendor_1597' , 'vendor_1606' , 'vendor_166' , 'vendor_170' , 'vendor_316' , 'vendor_405' , 'vendor_432' , 'vendor_438' , 'vendor_519' , 'vendor_528' , 'vendor_621' , 'vendor_984' , 'verwendungszweck_6536' , 'verwendungszweck_9603' , 'volumen_2365' , 'weinart_53876' , 'aroma_13964' , 'aroma_17796' , 'aroma_23887' , 'aroma_23893' , 'art_22870' , 'art_22876' , 'art_29788' , 'art_29790' , 'art_29792' , 'art_41586' , 'art_51126' , 'art_54141' , 'art_54633' , 'art_54637' , 'art_54715' , 'art_der_beeren_53106' , 'art_der_beeren_56092' , 'extract_53033' , 'family_1021' , 'family_1030' , 'family_1036' , 'family_1046' , 'family_1100' , 'family_1128' , 'family_1176' , 'family_1209' , 'family_1227' , 'family_1238' , 'family_1240' , 'family_1254' , 'family_1269' , 'family_1270' , 'family_1273' , 'family_526' , 'family_926' , 'farbgruppierung_579' , 'fettanteil_52035' , 'fettanteil_52299' , 'fischart_29661' , 'fischart_37804' , 'fleischart_15475' , 'fleischart_54883' , 'fleischart_54889' , 'fuellung_51114' , 'fuellung_55175' , 'geschmack_23771' , 'geschmack_23777' , 'geschmack_26604' , 'geschmack_36669' , 'geschmack_36851' , 'geschmack_46434' , 'geschmack_53803' , 'getreideart_23708' , 'laenderkueche_47654' , 'laenderkueche_48797' , 'manufacturer_55474' , 'netto_fuellmenge_filter_6' , 'netto_gewicht_filter_8' , 'serie_33808' , 'serie_37454' , 'serie_41382' , 'serie_51965' , 'serie_55386' , 'teigwarenart_25229' , 'teigwarenart_56421' , 'typ_55388' , 'vendor_1054' , 'vendor_1119' , 'vendor_1146' , 'vendor_1157' , 'vendor_1206' , 'vendor_1261' , 'vendor_1277' , 'vendor_1300' , 'vendor_1311' , 'vendor_1355' , 'vendor_1357' , 'vendor_1380' , 'vendor_1385' , 'vendor_1450' , 'vendor_1457' , 'vendor_1481' , 'vendor_152' , 'vendor_1534' , 'vendor_154' , 'vendor_1542' , 'vendor_1563' , 'vendor_1567' , 'vendor_1568' , 'vendor_1621' , 'vendor_164' , 'vendor_181' , 'vendor_265' , 'vendor_444' , 'vendor_500' , 'vendor_535' , 'vendor_538' , 'vendor_547' , 'vendor_582' , 'vendor_642' , 'vendor_644' , 'vendor_738' , 'vendor_767' , 'vendor_770' , 'vendor_851' , 'vendor_855' , 'vendor_873' , 'vendor_896' , 'vendor_909' , 'vendor_910' , 'vendor_928' , 'vendor_967' , 'vendor_972' , 'vendor_979' , 'verwendungszweck_2248' , 'verwendungszweck_6827' , 'volumen_37380' , 'weinart_53872' , 'anwendungszeit_9771' , 'aroma_13957' , 'aroma_24235' , 'art_22724' , 'art_22832' , 'art_22836' , 'art_30396' , 'art_30632' , 'art_30649' , 'art_30666' , 'art_33919' , 'art_54198' , 'art_54636' , 'art_54739' , 'art_55667' , 'art_56215' , 'art_56255' , 'art_56257' , 'art_57225' , 'art_der_beeren_54286' , 'art_der_beeren_54717' , 'art_der_suessigkeiten_39991' , 'extract_53002' , 'family_1024' , 'family_1045' , 'family_1075' , 'family_1225' , 'family_1253' , 'family_1262' , 'family_1266' , 'family_1279' , 'family_695' , 'family_759' , 'family_868' , 'feiertage_822' , 'fuellung_51140' , 'fuellung_51969' , 'fuellung_52598' , 'fuellung_54104' , 'fuellung_54798' , 'fuellung_55875' , 'geschmack_26599' , 'geschmack_26607' , 'geschmack_36932' , 'geschmack_37738' , 'geschmack_42691' , 'geschmack_53895' , 'geschmack_54213' , 'geschmack_56818' , 'getreideart_25279' , 'getreideart_38595' , 'handelsform_5910' , 'manufacturer_57065' , 'netto_gewicht_filter_11' , 'netto_gewicht_filter_13' , 'serie_39536' , 'serie_39538' , 'serie_55666' , 'sorte_19469' , 'typ_16198' , 'vendor_1007' , 'vendor_1020' , 'vendor_1033' , 'vendor_1037' , 'vendor_1055' , 'vendor_1107' , 'vendor_1195' , 'vendor_1241' , 'vendor_1247' , 'vendor_1254' , 'vendor_1260' , 'vendor_1302' , 'vendor_1307' , 'vendor_1309' , 'vendor_1312' , 'vendor_1319' , 'vendor_1371' , 'vendor_1375' , 'vendor_1378' , 'vendor_138' , 'vendor_1386' , 'vendor_1423' , 'vendor_143' , 'vendor_1458' , 'vendor_1477' , 'vendor_1482' , 'vendor_1486' , 'vendor_1487' , 'vendor_1492' , 'vendor_1494' , 'vendor_1505' , 'vendor_151' , 'vendor_1520' , 'vendor_1527' , 'vendor_1528' , 'vendor_1535' , 'vendor_1543' , 'vendor_1554' , 'vendor_157' , 'vendor_1578' , 'vendor_1580' , 'vendor_1581' , 'vendor_1587' , 'vendor_1605' , 'vendor_1624' , 'vendor_223' , 'vendor_225' , 'vendor_251' , 'vendor_295' , 'vendor_296' , 'vendor_346' , 'vendor_403' , 'vendor_406' , 'vendor_459' , 'vendor_490' , 'vendor_527' , 'vendor_573' , 'vendor_577' , 'vendor_609' , 'vendor_630' , 'vendor_744' , 'vendor_814' , 'vendor_883' , 'vendor_946' , 'vendor_992' , 'verwendungszweck_16237' , 'verwendungszweck_2240' , 'verwendungszweck_34164' , 'verwendungszweck_35571' , 'verwendungszweck_6814' , 'volumen_32280' , 'volumen_41001' , 'volumen_41002' , 'volumen_5235' , 'weinart_57300' , 'anzahl_der_artikel_2680' , 'anzahl_der_portionen_35920' , 'anzahl_der_portionen_35933' , 'aroma_11395' , 'aroma_17795' , 'aroma_22670' , 'aroma_39184' , 'aroma_39201' , 'aroma_4224' , 'aroma_4974' , 'aroma_6917' , 'art_15478' , 'art_22663' , 'art_22806' , 'art_22810' , 'art_22844' , 'art_22868' , 'art_29789' , 'art_30630' , 'art_30684' , 'art_36390' , 'art_40602' , 'art_51286' , 'art_54105' , 'art_54140' , 'art_54455' , 'art_54738' , 'art_55008' , 'art_56993' , 'art_57203' , 'art_der_beeren_54004' , 'art_der_beeren_56099' , 'art_der_suessigkeiten_52757' , 'extract_53001' , 'extract_53015' , 'family_1011' , 'family_1016' , 'family_1023' , 'family_1115' , 'family_1259' , 'family_723' , 'family_758' , 'family_858' , 'family_936' , 'farbgruppierung_578' , 'fettanteil_53325' , 'fettanteil_54814' , 'fettanteil_55626' , 'fettanteil_55845' , 'fettanteil_56075' , 'fischart_29665' , 'fischart_43293' , 'fischart_45346' , 'fischart_52492' , 'fischart_52858' , 'fischart_55177' , 'fischart_57425' , 'fuellung_36367' , 'fuellung_39661' , 'fuellung_55123' , 'fuellung_55170' , 'fuellung_55284' , 'fuellung_55786' , 'geschmack_23748' , 'geschmack_23769' , 'geschmack_26329' , 'geschmack_29525' , 'geschmack_36381' , 'geschmack_39167' , 'geschmack_42774' , 'geschmack_45977' , 'geschmack_51197' , 'geschmack_54330' , 'geschmack_54443' , 'geschmack_54962' , 'getreideart_25278' , 'handelsform_27518' , 'handelsform_35599' , 'laenderkueche_36351' , 'laenderkueche_36353' , 'laenderkueche_43127' , 'manufacturer_53918' , 'manufacturer_55475' , 'manufacturer_56718' , 'manufacturer_56721' , 'manufacturer_56723' , 'manufacturer_57094' , 'pastete_sorten_29726' , 'serie_32988' , 'serie_53680' , 'sorte_27412' , 'sorte_39254' , 'typ_33892' , 'typ_40821' , 'vendor_1035' , 'vendor_1048' , 'vendor_1051' , 'vendor_1064' , 'vendor_1077' , 'vendor_1085' , 'vendor_1088' , 'vendor_1112' , 'vendor_1114' , 'vendor_112' , 'vendor_1121' , 'vendor_1145' , 'vendor_1147' , 'vendor_1181' , 'vendor_1197' , 'vendor_1215' , 'vendor_125' , 'vendor_1276' , 'vendor_1281' , 'vendor_1293' , 'vendor_1315' , 'vendor_1327' , 'vendor_1333' , 'vendor_1346' , 'vendor_1347' , 'vendor_1379' , 'vendor_1381' , 'vendor_1388' , 'vendor_1390' , 'vendor_1414' , 'vendor_1432' , 'vendor_144' , 'vendor_1440' , 'vendor_1449' , 'vendor_1463' , 'vendor_1465' , 'vendor_1470' , 'vendor_1478' , 'vendor_1479' , 'vendor_1484' , 'vendor_1512' , 'vendor_1522' , 'vendor_1533' , 'vendor_1536' , 'vendor_1546' , 'vendor_1547' , 'vendor_1552' , 'vendor_1558' , 'vendor_1575' , 'vendor_1577' , 'vendor_1591' , 'vendor_1610' , 'vendor_1612' , 'vendor_1618' , 'vendor_1629' , 'vendor_1631' , 'vendor_1634' , 'vendor_200' , 'vendor_207' , 'vendor_248' , 'vendor_259' , 'vendor_347' , 'vendor_412' , 'vendor_467' , 'vendor_514' , 'vendor_534' , 'vendor_551' , 'vendor_636' , 'vendor_664' , 'vendor_665' , 'vendor_666' , 'vendor_678' , 'vendor_689' , 'vendor_700' , 'vendor_745' , 'vendor_821' , 'vendor_836' , 'vendor_850' , 'vendor_907' , 'vendor_956' , 'vendor_958' , 'vendor_961' , 'verpackung_39173' , 'verwendungszweck_36655' , 'verwendungszweck_52782' , 'verwendungszweck_52792' , 'volumen_1461' , 'volumen_1462' , 'volumen_2366' , 'volumen_43345' , 'volumen_7546' , 'volumen_der_tasse_40912' , 'aroma_13960' , 'aroma_17731' , 'aroma_30995' , 'aroma_4380' , 'aroma_4973' , 'aroma_53980' , 'art_14447' , 'art_22813' , 'art_22815' , 'art_22848' , 'art_22921' , 'art_23546' , 'art_23722' , 'art_30395' , 'art_30648' , 'art_30689' , 'art_30692' , 'art_33928' , 'art_36991' , 'art_37210' , 'art_37849' , 'art_37853' , 'art_38567' , 'art_38894' , 'art_38895' , 'art_40589' , 'art_41081' , 'art_53588' , 'art_53590' , 'art_53591' , 'art_53766' , 'art_54195' , 'art_54284' , 'art_54693' , 'art_54698' , 'art_55980' , 'art_56004' , 'art_56010' , 'art_56254' , 'art_56675' , 'art_6091' , 'art_der_beeren_56094' , 'art_der_beeren_56097' , 'art_der_beeren_56100' , 'duft_31347' , 'duft_36386' , 'extract_53029' , 'extract_53035' , 'family_1015' , 'family_1018' , 'family_1019' , 'family_1020' , 'family_1022' , 'family_1034' , 'family_1043' , 'family_1055' , 'family_1066' , 'family_1067' , 'family_1099' , 'family_1142' , 'family_1144' , 'family_1172' , 'family_1223' , 'family_1239' , 'family_1246' , 'family_1250' , 'family_1251' , 'family_1264' , 'family_1265' , 'family_1267' , 'family_1271' , 'family_1274' , 'family_1287' , 'family_1291' , 'family_1292' , 'family_255' , 'family_866' , 'farbgruppierung_586' , 'fettanteil_52046' , 'fettanteil_52300' , 'fettanteil_52303' , 'fettanteil_54188' , 'fettanteil_54437' , 'fettanteil_56070' , 'fettanteil_56074' , 'fettanteil_56076' , 'fettanteil_56744' , 'fischart_29658' , 'fischart_29663' , 'fischart_43277' , 'fischart_52356' , 'fischart_52490' , 'fischart_53820' , 'fischart_54516' , 'fischart_56343' , 'fischart_57014' , 'fischart_57452' , 'fuellung_39210' , 'fuellung_39649' , 'fuellung_51108' , 'fuellung_51109' , 'fuellung_52410' , 'fuellung_52596' , 'fuellung_52816' , 'fuellung_54361' , 'fuellung_54834' , 'fuellung_55407' , 'fuellung_56012' , 'fuellung_56653' , 'fuellung_56743' , 'fuellung_57524' , 'geschmack_24711' , 'geschmack_36387' , 'geschmack_39555' , 'geschmack_42722' , 'geschmack_45473' , 'geschmack_46433' , 'geschmack_47953' , 'geschmack_51194' , 'geschmack_54341' , 'geschmack_54640' , 'geschmack_54643' , 'geschmack_54709' , 'geschmack_54744' , 'geschmack_54799' , 'geschmack_56404' , 'geschmack_56650' , 'geschmack_56714' , 'geschmack_57342' , 'geschmack_57392' , 'geschmack_57615' , 'geschmack_57616' , 'getreideart_38553' , 'laenderkueche_36360' , 'laenderkueche_36361' , 'laenderkueche_43129' , 'laenderkueche_43210' , 'manufacturer_53919' , 'manufacturer_55471' , 'manufacturer_56717' , 'manufacturer_56720' , 'manufacturer_57095' , 'modelname_52509' , 'netto_fuellmenge_filter_7' , 'netto_fuellmenge_filter_8' , 'netto_gewicht_filter_10' , 'pastete_sorten_50587' , 'serie_39537' , 'serie_39539' , 'serie_39540' , 'serie_45257' , 'serie_52845' , 'serie_54749' , 'serie_55669' , 'typ_33917' , 'typ_37811' , 'typ_54760' , 'typ_7530' , 'vendor_1000' , 'vendor_1022' , 'vendor_1032' , 'vendor_1049' , 'vendor_1063' , 'vendor_1065' , 'vendor_1072' , 'vendor_1087' , 'vendor_1091' , 'vendor_1103' , 'vendor_1124' , 'vendor_1138' , 'vendor_1140' , 'vendor_1149' , 'vendor_1162' , 'vendor_118' , 'vendor_1182' , 'vendor_1186' , 'vendor_1190' , 'vendor_1208' , 'vendor_1213' , 'vendor_1224' , 'vendor_1229' , 'vendor_1234' , 'vendor_1252' , 'vendor_1283' , 'vendor_1291' , 'vendor_1299' , 'vendor_1310' , 'vendor_1322' , 'vendor_1325' , 'vendor_1326' , 'vendor_1331' , 'vendor_1340' , 'vendor_1352' , 'vendor_1354' , 'vendor_1382' , 'vendor_1387' , 'vendor_139' , 'vendor_141' , 'vendor_1416' , 'vendor_1417' , 'vendor_1436' , 'vendor_1441' , 'vendor_1451' , 'vendor_146' , 'vendor_1460' , 'vendor_1461' , 'vendor_1474' , 'vendor_1488' , 'vendor_1491' , 'vendor_1497' , 'vendor_1506' , 'vendor_1509' , 'vendor_1514' , 'vendor_1515' , 'vendor_1524' , 'vendor_1526' , 'vendor_1530' , 'vendor_1531' , 'vendor_1532' , 'vendor_1537' , 'vendor_1541' , 'vendor_1544' , 'vendor_1548' , 'vendor_1556' , 'vendor_1557' , 'vendor_1561' , 'vendor_1562' , 'vendor_1572' , 'vendor_1579' , 'vendor_1585' , 'vendor_1586' , 'vendor_1590' , 'vendor_1592' , 'vendor_1596' , 'vendor_1617' , 'vendor_1619' , 'vendor_1620' , 'vendor_1623' , 'vendor_1633' , 'vendor_187' , 'vendor_203' , 'vendor_204' , 'vendor_230' , 'vendor_232' , 'vendor_235' , 'vendor_236' , 'vendor_240' , 'vendor_256' , 'vendor_261' , 'vendor_271' , 'vendor_280' , 'vendor_282' , 'vendor_291' , 'vendor_305' , 'vendor_313' , 'vendor_336' , 'vendor_348' , 'vendor_353' , 'vendor_383' , 'vendor_408' , 'vendor_409' , 'vendor_437' , 'vendor_442' , 'vendor_446' , 'vendor_448' , 'vendor_473' , 'vendor_481' , 'vendor_484' , 'vendor_508' , 'vendor_513' , 'vendor_518' , 'vendor_521' , 'vendor_558' , 'vendor_565' , 'vendor_566' , 'vendor_570' , 'vendor_580' , 'vendor_581' , 'vendor_617' , 'vendor_635' , 'vendor_649' , 'vendor_677' , 'vendor_695' , 'vendor_699' , 'vendor_715' , 'vendor_717' , 'vendor_750' , 'vendor_757' , 'vendor_758' , 'vendor_779' , 'vendor_786' , 'vendor_832' , 'vendor_835' , 'vendor_845' , 'vendor_872' , 'vendor_880' , 'vendor_884' , 'vendor_886' , 'vendor_893' , 'vendor_901' , 'vendor_902' , 'vendor_904' , 'vendor_906' , 'vendor_908' , 'vendor_915' , 'vendor_919' , 'vendor_929' , 'vendor_937' , 'vendor_964' , 'vendor_968' , 'vendor_981' , 'vendor_983' , 'vendor_987' , 'verwendungszweck_2316' , 'verwendungszweck_2721' , 'verwendungszweck_32164' , 'verwendungszweck_34356' , 'verwendungszweck_4742' , 'verwendungszweck_48981' , 'verwendungszweck_5001' , 'verwendungszweck_5053' , 'verwendungszweck_53177' , 'verwendungszweck_6042' , 'verwendungszweck_6231' , 'verwendungszweck_6232' , 'verwendungszweck_7976' , 'volumen_2368' , 'volumen_2411' , 'volumen_2463' , 'volumen_3001' , 'volumen_3283' , 'volumen_3732' , 'volumen_41815' , 'volumen_4942' , 'volumen_51890' , 'volumen_56310' , 'volumen_9140' , 'volumen_9651' , 'volumen_9913' , 'weinart_53910' ) AND a . is_filterable = true
SELECT
a . id as group_id ,
a . code ,
a . name_ru ,
a . name_de ,
a . sort ,
a . is_metric ,
a . is_deeplink ,
a . is_filterable ,
a . use_deeplink_code ,
a . group_sort ,
a . group_name_ru ,
a . group_name_de ,
av . uid as value_id ,
av . name_ru as value_ru ,
av . name_de as value_de
FROM
attribute_value AS av
JOIN attribute AS a on a . code = av . code
WHERE
av . uid IN (
'coolbox_filter_0' ,
'freezebox_filter_3' ,
'netto_gewicht_filter_3' ,
'verpackung_2870' ,
'netto_gewicht_filter_4' ,
'netto_gewicht_filter_5' ,
'art_2163' ,
'freezebox_filter_2' ,
'family_693' ,
'verpackung_2954' ,
'netto_gewicht_filter_2' ,
'verpackung_4205' ,
'netto_gewicht_filter_1' ,
'coolbox_filter_1' ,
'verpackung_3121' ,
'netto_gewicht_filter_6' ,
'verpackung_3948' ,
'art_der_suessigkeiten_34384' ,
'verpackung_35918' ,
'fleischart_15470' ,
'family_376' ,
'vendor_531' ,
'family_688' ,
'verpackung_4003' ,
'verpackung_37215' ,
'handelsform_3535' ,
'verpackung_36357' ,
'geschmack_26932' ,
'vendor_458' ,
'laenderkueche_36352' ,
'family_1072' ,
'family_932' ,
'verpackung_24689' ,
'laenderkueche_36350' ,
'family_1275' ,
'art_25334' ,
'handelsform_3534' ,
'sorte_3536' ,
'geschmack_23761' ,
'family_1152' ,
'vendor_386' ,
'fleischart_15474' ,
'fuellung_36388' ,
'family_981' ,
'family_1078' ,
'vendor_196' ,
'vendor_357' ,
'geschmack_23757' ,
'family_692' ,
'geschmack_29765' ,
'sorte_26188' ,
'art_der_suessigkeiten_42806' ,
'family_921' ,
'geschmack_23765' ,
'getreideart_15473' ,
'netto_fuellmenge_filter_5' ,
'verpackung_3840' ,
'family_716' ,
'geschmack_36384' ,
'family_1073' ,
'family_999' ,
'family_922' ,
'family_971' ,
'art_15477' ,
'art_39784' ,
'fleischart_47539' ,
'vendor_1232' ,
'verpackung_5933' ,
'family_684' ,
'fuellung_36365' ,
'verpackung_27725' ,
'art_der_suessigkeiten_34102' ,
'family_1002' ,
'typ_36792' ,
'verpackung_14402' ,
'getreideart_25277' ,
'laenderkueche_43012' ,
'family_850' ,
'vendor_1298' ,
'art_56006' ,
'geschmack_29768' ,
'vendor_529' ,
'family_724' ,
'geschmack_23753' ,
'geschmack_23781' ,
'family_760' ,
'art_56994' ,
'art_der_suessigkeiten_39611' ,
'family_1101' ,
'family_1220' ,
'geschmack_23759' ,
'laenderkueche_36354' ,
'family_980' ,
'sorte_15484' ,
'family_1211' ,
'family_589' ,
'family_687' ,
'geschmack_26601' ,
'handelsform_5934' ,
'art_der_suessigkeiten_40017' ,
'family_683' ,
'teigwarenart_25243' ,
'vendor_42' ,
'handelsform_35601' ,
'feiertage_819' ,
'laenderkueche_36349' ,
'family_1035' ,
'vendor_380' ,
'family_865' ,
'vendor_114' ,
'family_685' ,
'fischart_29659' ,
'geschmack_25688' ,
'vendor_159' ,
'verpackung_9455' ,
'handelsform_5911' ,
'vendor_231' ,
'family_1213' ,
'feiertage_960' ,
'geschmack_36009' ,
'art_54870' ,
'vendor_1258' ,
'art_30399' ,
'art_der_suessigkeiten_46435' ,
'family_1228' ,
'family_577' ,
'geschmack_23762' ,
'netto_fuellmenge_filter_4' ,
'vendor_1409' ,
'vendor_156' ,
'vendor_158' ,
'verwendungszweck_4215' ,
'family_1232' ,
'family_880' ,
'family_920' ,
'getreideart_23707' ,
'verwendungszweck_46428' ,
'art_der_suessigkeiten_35208' ,
'art_der_suessigkeiten_40018' ,
'family_1026' ,
'family_711' ,
'geschmack_23756' ,
'geschmack_23774' ,
'family_594' ,
'geschmack_24694' ,
'fuellung_51141' ,
'getreideart_23671' ,
'vendor_1152' ,
'vendor_150' ,
'vendor_224' ,
'family_689' ,
'fuellung_39590' ,
'art_29786' ,
'art_56995' ,
'art_der_suessigkeiten_36995' ,
'feiertage_820' ,
'geschmack_42730' ,
'vendor_216' ,
'fischart_29660' ,
'vendor_482' ,
'vendor_716' ,
'art_51799' ,
'geschmack_23778' ,
'getreideart_15476' ,
'vendor_135' ,
'vendor_198' ,
'art_29787' ,
'family_1212' ,
'family_1241' ,
'feiertage_1130' ,
'typ_26962' ,
'vendor_1395' ,
'art_55439' ,
'art_56940' ,
'family_1286' ,
'family_418' ,
'geschmack_23770' ,
'vendor_1135' ,
'vendor_752' ,
'family_1044' ,
'fleischart_47119' ,
'fuellung_46951' ,
'fuellung_51117' ,
'netto_gewicht_filter_7' ,
'vendor_1313' ,
'vendor_404' ,
'vendor_923' ,
'verpackung_3653' ,
'art_der_suessigkeiten_39960' ,
'family_1168' ,
'family_462' ,
'fischart_29740' ,
'geschmack_35867' ,
'vendor_1016' ,
'anzahl_der_portionen_35937' ,
'getreideart_23711' ,
'vendor_895' ,
'verpackung_26798' ,
'art_54139' ,
'art_der_suessigkeiten_56942' ,
'family_1231' ,
'family_771' ,
'fischart_29998' ,
'geschmack_52741' ,
'handelsform_27113' ,
'netto_fuellmenge_filter_3' ,
'vendor_881' ,
'verpackung_38799' ,
'verpackung_42548' ,
'art_56007' ,
'fettanteil_52859' ,
'geschmack_23755' ,
'modelname_40223' ,
'vendor_1179' ,
'vendor_179' ,
'vendor_221' ,
'vendor_489' ,
'art_54631' ,
'family_1049' ,
'family_1065' ,
'family_1080' ,
'family_1234' ,
'family_691' ,
'family_867' ,
'laenderkueche_50808' ,
'vendor_134' ,
'vendor_1377' ,
'vendor_860' ,
'vendor_938' ,
'art_27151' ,
'family_1027' ,
'family_1114' ,
'family_1210' ,
'family_1233' ,
'family_629' ,
'family_682' ,
'family_973' ,
'family_986' ,
'fischart_37803' ,
'fischart_54823' ,
'geschmack_23747' ,
'geschmack_26600' ,
'geschmack_39591' ,
'geschmack_43102' ,
'serie_44880' ,
'serie_51387' ,
'typ_23685' ,
'vendor_1521' ,
'vendor_165' ,
'vendor_922' ,
'art_57036' ,
'art_der_suessigkeiten_40113' ,
'family_778' ,
'geschmack_23764' ,
'vendor_1027' ,
'vendor_1292' ,
'vendor_1348' ,
'vendor_1373' ,
'vendor_186' ,
'vendor_381' ,
'vendor_424' ,
'vendor_725' ,
'vendor_762' ,
'art_29791' ,
'art_54697' ,
'family_1054' ,
'family_1118' ,
'family_789' ,
'family_854' ,
'family_975' ,
'family_978' ,
'fischart_29999' ,
'fischart_36125' ,
'fuellung_51115' ,
'geschmack_23776' ,
'geschmack_26612' ,
'geschmack_32270' ,
'manufacturer_53914' ,
'vendor_679' ,
'vendor_897' ,
'vendor_944' ,
'verpackung_3154' ,
'verwendungszweck_2755' ,
'volumen_2424' ,
'art_23066' ,
'art_54632' ,
'art_55436' ,
'family_1028' ,
'family_441' ,
'family_935' ,
'geschmack_23763' ,
'geschmack_36938' ,
'getreideart_15480' ,
'getreideart_15481' ,
'handelsform_6235' ,
'teigwarenart_38803' ,
'vendor_1028' ,
'vendor_1191' ,
'vendor_1330' ,
'vendor_1412' ,
'vendor_1593' ,
'vendor_751' ,
'verpackung_4977' ,
'verwendungszweck_5081' ,
'verwendungszweck_7957' ,
'anwendungszeit_2288' ,
'art_51800' ,
'art_56939' ,
'family_1077' ,
'family_699' ,
'family_886' ,
'family_977' ,
'fischart_35526' ,
'fischart_38548' ,
'fuellung_52550' ,
'fuellung_53397' ,
'sorte_51687' ,
'typ_27609' ,
'typ_35555' ,
'vendor_1214' ,
'vendor_1216' ,
'vendor_1228' ,
'vendor_1317' ,
'vendor_1374' ,
'vendor_162' ,
'vendor_171' ,
'vendor_402' ,
'vendor_499' ,
'vendor_834' ,
'aroma_3539' ,
'art_29796' ,
'art_37185' ,
'family_1129' ,
'family_1260' ,
'family_1280' ,
'family_754' ,
'fischart_43299' ,
'fuellung_36847' ,
'fuellung_54431' ,
'geschmack_23775' ,
'geschmack_24687' ,
'geschmack_36380' ,
'sorte_7952' ,
'vendor_1462' ,
'vendor_149' ,
'vendor_486' ,
'vendor_759' ,
'vendor_962' ,
'verpackung_3609' ,
'weinart_53885' ,
'aroma_7551' ,
'art_36372' ,
'art_39785' ,
'family_1000' ,
'family_690' ,
'fettanteil_54147' ,
'fischart_37812' ,
'fuellung_51760' ,
'geschmack_23749' ,
'geschmack_23766' ,
'geschmack_31753' ,
'geschmack_35745' ,
'laenderkueche_36355' ,
'netto_fuellmenge_filter_2' ,
'pastete_sorten_29724' ,
'pastete_sorten_29725' ,
'serie_39543' ,
'vendor_1031' ,
'vendor_1226' ,
'vendor_1255' ,
'vendor_1476' ,
'vendor_413' ,
'vendor_477' ,
'vendor_511' ,
'vendor_553' ,
'vendor_721' ,
'vendor_724' ,
'vendor_728' ,
'art_39778' ,
'art_53069' ,
'art_54199' ,
'family_1102' ,
'family_1106' ,
'family_1167' ,
'family_1215' ,
'family_1219' ,
'family_752' ,
'feiertage_825' ,
'fuellung_39832' ,
'geschmack_23779' ,
'geschmack_26602' ,
'geschmack_26929' ,
'geschmack_36155' ,
'geschmack_53621' ,
'getreideart_23709' ,
'laenderkueche_43013' ,
'serie_39534' ,
'typ_34174' ,
'vendor_1113' ,
'vendor_1383' ,
'vendor_177' ,
'vendor_192' ,
'vendor_309' ,
'vendor_579' ,
'vendor_637' ,
'vendor_914' ,
'vendor_960' ,
'verpackung_6308' ,
'anzahl_der_portionen_35938' ,
'aroma_3546' ,
'art_23067' ,
'art_7540' ,
'family_1169' ,
'family_976' ,
'fleischart_30153' ,
'fuellung_39485' ,
'fuellung_39488' ,
'geschmack_23783' ,
'geschmack_45116' ,
'geschmack_51195' ,
'serie_55241' ,
'sorte_39243' ,
'vendor_111' ,
'vendor_1125' ,
'vendor_1173' ,
'vendor_1296' ,
'vendor_1316' ,
'vendor_140' ,
'vendor_1507' ,
'vendor_227' ,
'vendor_743' ,
'vendor_954' ,
'vendor_989' ,
'verwendungszweck_2752' ,
'verwendungszweck_35606' ,
'volumen_1460' ,
'altergruppierung_54019' ,
'altergruppierung_6272' ,
'anzahl_der_artikel_2679' ,
'art_23723' ,
'art_37143' ,
'art_56221' ,
'art_der_beeren_53100' ,
'family_1226' ,
'family_686' ,
'family_756' ,
'family_769' ,
'family_770' ,
'feiertage_821' ,
'feiertage_826' ,
'fettanteil_53700' ,
'fischart_43325' ,
'fuellung_39647' ,
'fuellung_39651' ,
'fuellung_51842' ,
'fuellung_52241' ,
'geschmack_23754' ,
'geschmack_26611' ,
'geschmack_26964' ,
'geschmack_36921' ,
'geschmack_38999' ,
'geschmack_39836' ,
'geschmack_39953' ,
'pastete_sorten_29718' ,
'serie_53575' ,
'vendor_1015' ,
'vendor_1070' ,
'vendor_1133' ,
'vendor_1153' ,
'vendor_1158' ,
'vendor_1218' ,
'vendor_1318' ,
'vendor_1422' ,
'vendor_1466' ,
'vendor_1472' ,
'vendor_1508' ,
'vendor_1540' ,
'vendor_1598' ,
'vendor_414' ,
'vendor_430' ,
'vendor_441' ,
'vendor_449' ,
'vendor_457' ,
'vendor_552' ,
'vendor_639' ,
'vendor_641' ,
'vendor_681' ,
'vendor_755' ,
'vendor_862' ,
'vendor_991' ,
'verwendungszweck_6088' ,
'art_33908' ,
'art_35238' ,
'art_37170' ,
'art_54194' ,
'family_1009' ,
'family_1031' ,
'family_1074' ,
'family_1214' ,
'family_757' ,
'family_974' ,
'feiertage_823' ,
'fettanteil_51891' ,
'fuellung_29777' ,
'fuellung_36364' ,
'fuellung_52846' ,
'geschmack_23758' ,
'geschmack_23782' ,
'geschmack_36940' ,
'geschmack_54329' ,
'getreideart_15482' ,
'sorte_45806' ,
'teigwarenart_25246' ,
'vendor_1104' ,
'vendor_1106' ,
'vendor_116' ,
'vendor_1240' ,
'vendor_1328' ,
'vendor_1372' ,
'vendor_1394' ,
'vendor_1406' ,
'vendor_1433' ,
'vendor_1459' ,
'vendor_1464' ,
'vendor_1496' ,
'vendor_1529' ,
'vendor_1545' ,
'vendor_178' ,
'vendor_267' ,
'vendor_431' ,
'vendor_533' ,
'vendor_772' ,
'verpackung_31703' ,
'verwendungszweck_135' ,
'anzahl_der_portionen_50815' ,
'aroma_55191' ,
'art_14443' ,
'art_35236' ,
'art_39627' ,
'art_52277' ,
'art_53592' ,
'art_54630' ,
'art_54638' ,
'art_56253' ,
'art_der_beeren_53103' ,
'family_1032' ,
'family_1033' ,
'family_697' ,
'family_773' ,
'family_972' ,
'fischart_29664' ,
'fischart_54769' ,
'fuellung_42734' ,
'fuellung_51125' ,
'fuellung_51170' ,
'fuellung_51734' ,
'fuellung_55934' ,
'geschlecht_65' ,
'geschmack_23760' ,
'geschmack_26605' ,
'geschmack_39002' ,
'geschmack_39945' ,
'grossen_38388' ,
'materialgruppierung_33495' ,
'netto_gewicht_filter_9' ,
'serie_34905' ,
'serie_54773' ,
'typ_55466' ,
'vendor_1025' ,
'vendor_1165' ,
'vendor_1187' ,
'vendor_1205' ,
'vendor_1289' ,
'vendor_1297' ,
'vendor_1337' ,
'vendor_1376' ,
'vendor_1483' ,
'vendor_1495' ,
'vendor_153' ,
'vendor_1549' ,
'vendor_1582' ,
'vendor_1595' ,
'vendor_274' ,
'vendor_277' ,
'vendor_537' ,
'vendor_554' ,
'vendor_608' ,
'vendor_685' ,
'vendor_785' ,
'vendor_852' ,
'vendor_861' ,
'vendor_869' ,
'vendor_924' ,
'vendor_980' ,
'verpackung_45261' ,
'verpackung_46731' ,
'verwendungszweck_17979' ,
'verwendungszweck_2256' ,
'verwendungszweck_29892' ,
'verwendungszweck_41370' ,
'aroma_26886' ,
'aroma_4227' ,
'aroma_4975' ,
'aroma_4976' ,
'art_36368' ,
'art_37171' ,
'art_37854' ,
'art_54635' ,
'art_54694' ,
'art_54695' ,
'art_55179' ,
'art_56419' ,
'art_der_beeren_53566' ,
'art_der_beeren_54072' ,
'art_der_beeren_54397' ,
'extract_53040' ,
'family_1120' ,
'family_1131' ,
'family_1229' ,
'family_1249' ,
'family_755' ,
'fettanteil_43969' ,
'fettanteil_52040' ,
'fischart_43320' ,
'fischart_43337' ,
'fischart_52914' ,
'fuellung_52898' ,
'geschlecht_66' ,
'geschmack_36935' ,
'geschmack_44672' ,
'geschmack_51196' ,
'geschmack_54650' ,
'laenderkueche_51124' ,
'manufacturer_53916' ,
'manufacturer_57302' ,
'serie_36417' ,
'serie_44736' ,
'teigwarenart_25230' ,
'typ_48885' ,
'vendor_1018' ,
'vendor_1160' ,
'vendor_1207' ,
'vendor_1342' ,
'vendor_1350' ,
'vendor_1410' ,
'vendor_1435' ,
'vendor_1455' ,
'vendor_1456' ,
'vendor_1555' ,
'vendor_1588' ,
'vendor_1597' ,
'vendor_1606' ,
'vendor_166' ,
'vendor_170' ,
'vendor_316' ,
'vendor_405' ,
'vendor_432' ,
'vendor_438' ,
'vendor_519' ,
'vendor_528' ,
'vendor_621' ,
'vendor_984' ,
'verwendungszweck_6536' ,
'verwendungszweck_9603' ,
'volumen_2365' ,
'weinart_53876' ,
'aroma_13964' ,
'aroma_17796' ,
'aroma_23887' ,
'aroma_23893' ,
'art_22870' ,
'art_22876' ,
'art_29788' ,
'art_29790' ,
'art_29792' ,
'art_41586' ,
'art_51126' ,
'art_54141' ,
'art_54633' ,
'art_54637' ,
'art_54715' ,
'art_der_beeren_53106' ,
'art_der_beeren_56092' ,
'extract_53033' ,
'family_1021' ,
'family_1030' ,
'family_1036' ,
'family_1046' ,
'family_1100' ,
'family_1128' ,
'family_1176' ,
'family_1209' ,
'family_1227' ,
'family_1238' ,
'family_1240' ,
'family_1254' ,
'family_1269' ,
'family_1270' ,
'family_1273' ,
'family_526' ,
'family_926' ,
'farbgruppierung_579' ,
'fettanteil_52035' ,
'fettanteil_52299' ,
'fischart_29661' ,
'fischart_37804' ,
'fleischart_15475' ,
'fleischart_54883' ,
'fleischart_54889' ,
'fuellung_51114' ,
'fuellung_55175' ,
'geschmack_23771' ,
'geschmack_23777' ,
'geschmack_26604' ,
'geschmack_36669' ,
'geschmack_36851' ,
'geschmack_46434' ,
'geschmack_53803' ,
'getreideart_23708' ,
'laenderkueche_47654' ,
'laenderkueche_48797' ,
'manufacturer_55474' ,
'netto_fuellmenge_filter_6' ,
'netto_gewicht_filter_8' ,
'serie_33808' ,
'serie_37454' ,
'serie_41382' ,
'serie_51965' ,
'serie_55386' ,
'teigwarenart_25229' ,
'teigwarenart_56421' ,
'typ_55388' ,
'vendor_1054' ,
'vendor_1119' ,
'vendor_1146' ,
'vendor_1157' ,
'vendor_1206' ,
'vendor_1261' ,
'vendor_1277' ,
'vendor_1300' ,
'vendor_1311' ,
'vendor_1355' ,
'vendor_1357' ,
'vendor_1380' ,
'vendor_1385' ,
'vendor_1450' ,
'vendor_1457' ,
'vendor_1481' ,
'vendor_152' ,
'vendor_1534' ,
'vendor_154' ,
'vendor_1542' ,
'vendor_1563' ,
'vendor_1567' ,
'vendor_1568' ,
'vendor_1621' ,
'vendor_164' ,
'vendor_181' ,
'vendor_265' ,
'vendor_444' ,
'vendor_500' ,
'vendor_535' ,
'vendor_538' ,
'vendor_547' ,
'vendor_582' ,
'vendor_642' ,
'vendor_644' ,
'vendor_738' ,
'vendor_767' ,
'vendor_770' ,
'vendor_851' ,
'vendor_855' ,
'vendor_873' ,
'vendor_896' ,
'vendor_909' ,
'vendor_910' ,
'vendor_928' ,
'vendor_967' ,
'vendor_972' ,
'vendor_979' ,
'verwendungszweck_2248' ,
'verwendungszweck_6827' ,
'volumen_37380' ,
'weinart_53872' ,
'anwendungszeit_9771' ,
'aroma_13957' ,
'aroma_24235' ,
'art_22724' ,
'art_22832' ,
'art_22836' ,
'art_30396' ,
'art_30632' ,
'art_30649' ,
'art_30666' ,
'art_33919' ,
'art_54198' ,
'art_54636' ,
'art_54739' ,
'art_55667' ,
'art_56215' ,
'art_56255' ,
'art_56257' ,
'art_57225' ,
'art_der_beeren_54286' ,
'art_der_beeren_54717' ,
'art_der_suessigkeiten_39991' ,
'extract_53002' ,
'family_1024' ,
'family_1045' ,
'family_1075' ,
'family_1225' ,
'family_1253' ,
'family_1262' ,
'family_1266' ,
'family_1279' ,
'family_695' ,
'family_759' ,
'family_868' ,
'feiertage_822' ,
'fuellung_51140' ,
'fuellung_51969' ,
'fuellung_52598' ,
'fuellung_54104' ,
'fuellung_54798' ,
'fuellung_55875' ,
'geschmack_26599' ,
'geschmack_26607' ,
'geschmack_36932' ,
'geschmack_37738' ,
'geschmack_42691' ,
'geschmack_53895' ,
'geschmack_54213' ,
'geschmack_56818' ,
'getreideart_25279' ,
'getreideart_38595' ,
'handelsform_5910' ,
'manufacturer_57065' ,
'netto_gewicht_filter_11' ,
'netto_gewicht_filter_13' ,
'serie_39536' ,
'serie_39538' ,
'serie_55666' ,
'sorte_19469' ,
'typ_16198' ,
'vendor_1007' ,
'vendor_1020' ,
'vendor_1033' ,
'vendor_1037' ,
'vendor_1055' ,
'vendor_1107' ,
'vendor_1195' ,
'vendor_1241' ,
'vendor_1247' ,
'vendor_1254' ,
'vendor_1260' ,
'vendor_1302' ,
'vendor_1307' ,
'vendor_1309' ,
'vendor_1312' ,
'vendor_1319' ,
'vendor_1371' ,
'vendor_1375' ,
'vendor_1378' ,
'vendor_138' ,
'vendor_1386' ,
'vendor_1423' ,
'vendor_143' ,
'vendor_1458' ,
'vendor_1477' ,
'vendor_1482' ,
'vendor_1486' ,
'vendor_1487' ,
'vendor_1492' ,
'vendor_1494' ,
'vendor_1505' ,
'vendor_151' ,
'vendor_1520' ,
'vendor_1527' ,
'vendor_1528' ,
'vendor_1535' ,
'vendor_1543' ,
'vendor_1554' ,
'vendor_157' ,
'vendor_1578' ,
'vendor_1580' ,
'vendor_1581' ,
'vendor_1587' ,
'vendor_1605' ,
'vendor_1624' ,
'vendor_223' ,
'vendor_225' ,
'vendor_251' ,
'vendor_295' ,
'vendor_296' ,
'vendor_346' ,
'vendor_403' ,
'vendor_406' ,
'vendor_459' ,
'vendor_490' ,
'vendor_527' ,
'vendor_573' ,
'vendor_577' ,
'vendor_609' ,
'vendor_630' ,
'vendor_744' ,
'vendor_814' ,
'vendor_883' ,
'vendor_946' ,
'vendor_992' ,
'verwendungszweck_16237' ,
'verwendungszweck_2240' ,
'verwendungszweck_34164' ,
'verwendungszweck_35571' ,
'verwendungszweck_6814' ,
'volumen_32280' ,
'volumen_41001' ,
'volumen_41002' ,
'volumen_5235' ,
'weinart_57300' ,
'anzahl_der_artikel_2680' ,
'anzahl_der_portionen_35920' ,
'anzahl_der_portionen_35933' ,
'aroma_11395' ,
'aroma_17795' ,
'aroma_22670' ,
'aroma_39184' ,
'aroma_39201' ,
'aroma_4224' ,
'aroma_4974' ,
'aroma_6917' ,
'art_15478' ,
'art_22663' ,
'art_22806' ,
'art_22810' ,
'art_22844' ,
'art_22868' ,
'art_29789' ,
'art_30630' ,
'art_30684' ,
'art_36390' ,
'art_40602' ,
'art_51286' ,
'art_54105' ,
'art_54140' ,
'art_54455' ,
'art_54738' ,
'art_55008' ,
'art_56993' ,
'art_57203' ,
'art_der_beeren_54004' ,
'art_der_beeren_56099' ,
'art_der_suessigkeiten_52757' ,
'extract_53001' ,
'extract_53015' ,
'family_1011' ,
'family_1016' ,
'family_1023' ,
'family_1115' ,
'family_1259' ,
'family_723' ,
'family_758' ,
'family_858' ,
'family_936' ,
'farbgruppierung_578' ,
'fettanteil_53325' ,
'fettanteil_54814' ,
'fettanteil_55626' ,
'fettanteil_55845' ,
'fettanteil_56075' ,
'fischart_29665' ,
'fischart_43293' ,
'fischart_45346' ,
'fischart_52492' ,
'fischart_52858' ,
'fischart_55177' ,
'fischart_57425' ,
'fuellung_36367' ,
'fuellung_39661' ,
'fuellung_55123' ,
'fuellung_55170' ,
'fuellung_55284' ,
'fuellung_55786' ,
'geschmack_23748' ,
'geschmack_23769' ,
'geschmack_26329' ,
'geschmack_29525' ,
'geschmack_36381' ,
'geschmack_39167' ,
'geschmack_42774' ,
'geschmack_45977' ,
'geschmack_51197' ,
'geschmack_54330' ,
'geschmack_54443' ,
'geschmack_54962' ,
'getreideart_25278' ,
'handelsform_27518' ,
'handelsform_35599' ,
'laenderkueche_36351' ,
'laenderkueche_36353' ,
'laenderkueche_43127' ,
'manufacturer_53918' ,
'manufacturer_55475' ,
'manufacturer_56718' ,
'manufacturer_56721' ,
'manufacturer_56723' ,
'manufacturer_57094' ,
'pastete_sorten_29726' ,
'serie_32988' ,
'serie_53680' ,
'sorte_27412' ,
'sorte_39254' ,
'typ_33892' ,
'typ_40821' ,
'vendor_1035' ,
'vendor_1048' ,
'vendor_1051' ,
'vendor_1064' ,
'vendor_1077' ,
'vendor_1085' ,
'vendor_1088' ,
'vendor_1112' ,
'vendor_1114' ,
'vendor_112' ,
'vendor_1121' ,
'vendor_1145' ,
'vendor_1147' ,
'vendor_1181' ,
'vendor_1197' ,
'vendor_1215' ,
'vendor_125' ,
'vendor_1276' ,
'vendor_1281' ,
'vendor_1293' ,
'vendor_1315' ,
'vendor_1327' ,
'vendor_1333' ,
'vendor_1346' ,
'vendor_1347' ,
'vendor_1379' ,
'vendor_1381' ,
'vendor_1388' ,
'vendor_1390' ,
'vendor_1414' ,
'vendor_1432' ,
'vendor_144' ,
'vendor_1440' ,
'vendor_1449' ,
'vendor_1463' ,
'vendor_1465' ,
'vendor_1470' ,
'vendor_1478' ,
'vendor_1479' ,
'vendor_1484' ,
'vendor_1512' ,
'vendor_1522' ,
'vendor_1533' ,
'vendor_1536' ,
'vendor_1546' ,
'vendor_1547' ,
'vendor_1552' ,
'vendor_1558' ,
'vendor_1575' ,
'vendor_1577' ,
'vendor_1591' ,
'vendor_1610' ,
'vendor_1612' ,
'vendor_1618' ,
'vendor_1629' ,
'vendor_1631' ,
'vendor_1634' ,
'vendor_200' ,
'vendor_207' ,
'vendor_248' ,
'vendor_259' ,
'vendor_347' ,
'vendor_412' ,
'vendor_467' ,
'vendor_514' ,
'vendor_534' ,
'vendor_551' ,
'vendor_636' ,
'vendor_664' ,
'vendor_665' ,
'vendor_666' ,
'vendor_678' ,
'vendor_689' ,
'vendor_700' ,
'vendor_745' ,
'vendor_821' ,
'vendor_836' ,
'vendor_850' ,
'vendor_907' ,
'vendor_956' ,
'vendor_958' ,
'vendor_961' ,
'verpackung_39173' ,
'verwendungszweck_36655' ,
'verwendungszweck_52782' ,
'verwendungszweck_52792' ,
'volumen_1461' ,
'volumen_1462' ,
'volumen_2366' ,
'volumen_43345' ,
'volumen_7546' ,
'volumen_der_tasse_40912' ,
'aroma_13960' ,
'aroma_17731' ,
'aroma_30995' ,
'aroma_4380' ,
'aroma_4973' ,
'aroma_53980' ,
'art_14447' ,
'art_22813' ,
'art_22815' ,
'art_22848' ,
'art_22921' ,
'art_23546' ,
'art_23722' ,
'art_30395' ,
'art_30648' ,
'art_30689' ,
'art_30692' ,
'art_33928' ,
'art_36991' ,
'art_37210' ,
'art_37849' ,
'art_37853' ,
'art_38567' ,
'art_38894' ,
'art_38895' ,
'art_40589' ,
'art_41081' ,
'art_53588' ,
'art_53590' ,
'art_53591' ,
'art_53766' ,
'art_54195' ,
'art_54284' ,
'art_54693' ,
'art_54698' ,
'art_55980' ,
'art_56004' ,
'art_56010' ,
'art_56254' ,
'art_56675' ,
'art_6091' ,
'art_der_beeren_56094' ,
'art_der_beeren_56097' ,
'art_der_beeren_56100' ,
'duft_31347' ,
'duft_36386' ,
'extract_53029' ,
'extract_53035' ,
'family_1015' ,
'family_1018' ,
'family_1019' ,
'family_1020' ,
'family_1022' ,
'family_1034' ,
'family_1043' ,
'family_1055' ,
'family_1066' ,
'family_1067' ,
'family_1099' ,
'family_1142' ,
'family_1144' ,
'family_1172' ,
'family_1223' ,
'family_1239' ,
'family_1246' ,
'family_1250' ,
'family_1251' ,
'family_1264' ,
'family_1265' ,
'family_1267' ,
'family_1271' ,
'family_1274' ,
'family_1287' ,
'family_1291' ,
'family_1292' ,
'family_255' ,
'family_866' ,
'farbgruppierung_586' ,
'fettanteil_52046' ,
'fettanteil_52300' ,
'fettanteil_52303' ,
'fettanteil_54188' ,
'fettanteil_54437' ,
'fettanteil_56070' ,
'fettanteil_56074' ,
'fettanteil_56076' ,
'fettanteil_56744' ,
'fischart_29658' ,
'fischart_29663' ,
'fischart_43277' ,
'fischart_52356' ,
'fischart_52490' ,
'fischart_53820' ,
'fischart_54516' ,
'fischart_56343' ,
'fischart_57014' ,
'fischart_57452' ,
'fuellung_39210' ,
'fuellung_39649' ,
'fuellung_51108' ,
'fuellung_51109' ,
'fuellung_52410' ,
'fuellung_52596' ,
'fuellung_52816' ,
'fuellung_54361' ,
'fuellung_54834' ,
'fuellung_55407' ,
'fuellung_56012' ,
'fuellung_56653' ,
'fuellung_56743' ,
'fuellung_57524' ,
'geschmack_24711' ,
'geschmack_36387' ,
'geschmack_39555' ,
'geschmack_42722' ,
'geschmack_45473' ,
'geschmack_46433' ,
'geschmack_47953' ,
'geschmack_51194' ,
'geschmack_54341' ,
'geschmack_54640' ,
'geschmack_54643' ,
'geschmack_54709' ,
'geschmack_54744' ,
'geschmack_54799' ,
'geschmack_56404' ,
'geschmack_56650' ,
'geschmack_56714' ,
'geschmack_57342' ,
'geschmack_57392' ,
'geschmack_57615' ,
'geschmack_57616' ,
'getreideart_38553' ,
'laenderkueche_36360' ,
'laenderkueche_36361' ,
'laenderkueche_43129' ,
'laenderkueche_43210' ,
'manufacturer_53919' ,
'manufacturer_55471' ,
'manufacturer_56717' ,
'manufacturer_56720' ,
'manufacturer_57095' ,
'modelname_52509' ,
'netto_fuellmenge_filter_7' ,
'netto_fuellmenge_filter_8' ,
'netto_gewicht_filter_10' ,
'pastete_sorten_50587' ,
'serie_39537' ,
'serie_39539' ,
'serie_39540' ,
'serie_45257' ,
'serie_52845' ,
'serie_54749' ,
'serie_55669' ,
'typ_33917' ,
'typ_37811' ,
'typ_54760' ,
'typ_7530' ,
'vendor_1000' ,
'vendor_1022' ,
'vendor_1032' ,
'vendor_1049' ,
'vendor_1063' ,
'vendor_1065' ,
'vendor_1072' ,
'vendor_1087' ,
'vendor_1091' ,
'vendor_1103' ,
'vendor_1124' ,
'vendor_1138' ,
'vendor_1140' ,
'vendor_1149' ,
'vendor_1162' ,
'vendor_118' ,
'vendor_1182' ,
'vendor_1186' ,
'vendor_1190' ,
'vendor_1208' ,
'vendor_1213' ,
'vendor_1224' ,
'vendor_1229' ,
'vendor_1234' ,
'vendor_1252' ,
'vendor_1283' ,
'vendor_1291' ,
'vendor_1299' ,
'vendor_1310' ,
'vendor_1322' ,
'vendor_1325' ,
'vendor_1326' ,
'vendor_1331' ,
'vendor_1340' ,
'vendor_1352' ,
'vendor_1354' ,
'vendor_1382' ,
'vendor_1387' ,
'vendor_139' ,
'vendor_141' ,
'vendor_1416' ,
'vendor_1417' ,
'vendor_1436' ,
'vendor_1441' ,
'vendor_1451' ,
'vendor_146' ,
'vendor_1460' ,
'vendor_1461' ,
'vendor_1474' ,
'vendor_1488' ,
'vendor_1491' ,
'vendor_1497' ,
'vendor_1506' ,
'vendor_1509' ,
'vendor_1514' ,
'vendor_1515' ,
'vendor_1524' ,
'vendor_1526' ,
'vendor_1530' ,
'vendor_1531' ,
'vendor_1532' ,
'vendor_1537' ,
'vendor_1541' ,
'vendor_1544' ,
'vendor_1548' ,
'vendor_1556' ,
'vendor_1557' ,
'vendor_1561' ,
'vendor_1562' ,
'vendor_1572' ,
'vendor_1579' ,
'vendor_1585' ,
'vendor_1586' ,
'vendor_1590' ,
'vendor_1592' ,
'vendor_1596' ,
'vendor_1617' ,
'vendor_1619' ,
'vendor_1620' ,
'vendor_1623' ,
'vendor_1633' ,
'vendor_187' ,
'vendor_203' ,
'vendor_204' ,
'vendor_230' ,
'vendor_232' ,
'vendor_235' ,
'vendor_236' ,
'vendor_240' ,
'vendor_256' ,
'vendor_261' ,
'vendor_271' ,
'vendor_280' ,
'vendor_282' ,
'vendor_291' ,
'vendor_305' ,
'vendor_313' ,
'vendor_336' ,
'vendor_348' ,
'vendor_353' ,
'vendor_383' ,
'vendor_408' ,
'vendor_409' ,
'vendor_437' ,
'vendor_442' ,
'vendor_446' ,
'vendor_448' ,
'vendor_473' ,
'vendor_481' ,
'vendor_484' ,
'vendor_508' ,
'vendor_513' ,
'vendor_518' ,
'vendor_521' ,
'vendor_558' ,
'vendor_565' ,
'vendor_566' ,
'vendor_570' ,
'vendor_580' ,
'vendor_581' ,
'vendor_617' ,
'vendor_635' ,
'vendor_649' ,
'vendor_677' ,
'vendor_695' ,
'vendor_699' ,
'vendor_715' ,
'vendor_717' ,
'vendor_750' ,
'vendor_757' ,
'vendor_758' ,
'vendor_779' ,
'vendor_786' ,
'vendor_832' ,
'vendor_835' ,
'vendor_845' ,
'vendor_872' ,
'vendor_880' ,
'vendor_884' ,
'vendor_886' ,
'vendor_893' ,
'vendor_901' ,
'vendor_902' ,
'vendor_904' ,
'vendor_906' ,
'vendor_908' ,
'vendor_915' ,
'vendor_919' ,
'vendor_929' ,
'vendor_937' ,
'vendor_964' ,
'vendor_968' ,
'vendor_981' ,
'vendor_983' ,
'vendor_987' ,
'verwendungszweck_2316' ,
'verwendungszweck_2721' ,
'verwendungszweck_32164' ,
'verwendungszweck_34356' ,
'verwendungszweck_4742' ,
'verwendungszweck_48981' ,
'verwendungszweck_5001' ,
'verwendungszweck_5053' ,
'verwendungszweck_53177' ,
'verwendungszweck_6042' ,
'verwendungszweck_6231' ,
'verwendungszweck_6232' ,
'verwendungszweck_7976' ,
'volumen_2368' ,
'volumen_2411' ,
'volumen_2463' ,
'volumen_3001' ,
'volumen_3283' ,
'volumen_3732' ,
'volumen_41815' ,
'volumen_4942' ,
'volumen_51890' ,
'volumen_56310' ,
'volumen_9140' ,
'volumen_9651' ,
'volumen_9913' ,
'weinart_53910'
)
AND a . is_filterable = true Copy
SELECT a . id as group_id , a . code , a . name_ru , a . name_de , a . sort ,
a . is_metric , a . is_deeplink , a . is_filterable , a . use_deeplink_code ,
a . group_sort , a . group_name_ru , a . group_name_de ,
av . uid as value_id , av . name_ru as value_ru , av . name_de as value_de
FROM attribute_value AS av
JOIN attribute AS a on a . code = av . code
WHERE av . uid IN ('coolbox_filter_0' , 'freezebox_filter_3' , 'netto_gewicht_filter_3' , 'verpackung_2870' , 'netto_gewicht_filter_4' , 'netto_gewicht_filter_5' , 'art_2163' , 'freezebox_filter_2' , 'family_693' , 'verpackung_2954' , 'netto_gewicht_filter_2' , 'verpackung_4205' , 'netto_gewicht_filter_1' , 'coolbox_filter_1' , 'verpackung_3121' , 'netto_gewicht_filter_6' , 'verpackung_3948' , 'art_der_suessigkeiten_34384' , 'verpackung_35918' , 'fleischart_15470' , 'family_376' , 'vendor_531' , 'family_688' , 'verpackung_4003' , 'verpackung_37215' , 'handelsform_3535' , 'verpackung_36357' , 'geschmack_26932' , 'vendor_458' , 'laenderkueche_36352' , 'family_1072' , 'family_932' , 'verpackung_24689' , 'laenderkueche_36350' , 'family_1275' , 'art_25334' , 'handelsform_3534' , 'sorte_3536' , 'geschmack_23761' , 'family_1152' , 'vendor_386' , 'fleischart_15474' , 'fuellung_36388' , 'family_981' , 'family_1078' , 'vendor_196' , 'vendor_357' , 'geschmack_23757' , 'family_692' , 'geschmack_29765' , 'sorte_26188' , 'art_der_suessigkeiten_42806' , 'family_921' , 'geschmack_23765' , 'getreideart_15473' , 'netto_fuellmenge_filter_5' , 'verpackung_3840' , 'family_716' , 'geschmack_36384' , 'family_1073' , 'family_999' , 'family_922' , 'family_971' , 'art_15477' , 'art_39784' , 'fleischart_47539' , 'vendor_1232' , 'verpackung_5933' , 'family_684' , 'fuellung_36365' , 'verpackung_27725' , 'art_der_suessigkeiten_34102' , 'family_1002' , 'typ_36792' , 'verpackung_14402' , 'getreideart_25277' , 'laenderkueche_43012' , 'family_850' , 'vendor_1298' , 'art_56006' , 'geschmack_29768' , 'vendor_529' , 'family_724' , 'geschmack_23753' , 'geschmack_23781' , 'family_760' , 'art_56994' , 'art_der_suessigkeiten_39611' , 'family_1101' , 'family_1220' , 'geschmack_23759' , 'laenderkueche_36354' , 'family_980' , 'sorte_15484' , 'family_1211' , 'family_589' , 'family_687' , 'geschmack_26601' , 'handelsform_5934' , 'art_der_suessigkeiten_40017' , 'family_683' , 'teigwarenart_25243' , 'vendor_42' , 'handelsform_35601' , 'feiertage_819' , 'laenderkueche_36349' , 'family_1035' , 'vendor_380' , 'family_865' , 'vendor_114' , 'family_685' , 'fischart_29659' , 'geschmack_25688' , 'vendor_159' , 'verpackung_9455' , 'handelsform_5911' , 'vendor_231' , 'family_1213' , 'feiertage_960' , 'geschmack_36009' , 'art_54870' , 'vendor_1258' , 'art_30399' , 'art_der_suessigkeiten_46435' , 'family_1228' , 'family_577' , 'geschmack_23762' , 'netto_fuellmenge_filter_4' , 'vendor_1409' , 'vendor_156' , 'vendor_158' , 'verwendungszweck_4215' , 'family_1232' , 'family_880' , 'family_920' , 'getreideart_23707' , 'verwendungszweck_46428' , 'art_der_suessigkeiten_35208' , 'art_der_suessigkeiten_40018' , 'family_1026' , 'family_711' , 'geschmack_23756' , 'geschmack_23774' , 'family_594' , 'geschmack_24694' , 'fuellung_51141' , 'getreideart_23671' , 'vendor_1152' , 'vendor_150' , 'vendor_224' , 'family_689' , 'fuellung_39590' , 'art_29786' , 'art_56995' , 'art_der_suessigkeiten_36995' , 'feiertage_820' , 'geschmack_42730' , 'vendor_216' , 'fischart_29660' , 'vendor_482' , 'vendor_716' , 'art_51799' , 'geschmack_23778' , 'getreideart_15476' , 'vendor_135' , 'vendor_198' , 'art_29787' , 'family_1212' , 'family_1241' , 'feiertage_1130' , 'typ_26962' , 'vendor_1395' , 'art_55439' , 'art_56940' , 'family_1286' , 'family_418' , 'geschmack_23770' , 'vendor_1135' , 'vendor_752' , 'family_1044' , 'fleischart_47119' , 'fuellung_46951' , 'fuellung_51117' , 'netto_gewicht_filter_7' , 'vendor_1313' , 'vendor_404' , 'vendor_923' , 'verpackung_3653' , 'art_der_suessigkeiten_39960' , 'family_1168' , 'family_462' , 'fischart_29740' , 'geschmack_35867' , 'vendor_1016' , 'anzahl_der_portionen_35937' , 'getreideart_23711' , 'vendor_895' , 'verpackung_26798' , 'art_54139' , 'art_der_suessigkeiten_56942' , 'family_1231' , 'family_771' , 'fischart_29998' , 'geschmack_52741' , 'handelsform_27113' , 'netto_fuellmenge_filter_3' , 'vendor_881' , 'verpackung_38799' , 'verpackung_42548' , 'art_56007' , 'fettanteil_52859' , 'geschmack_23755' , 'modelname_40223' , 'vendor_1179' , 'vendor_179' , 'vendor_221' , 'vendor_489' , 'art_54631' , 'family_1049' , 'family_1065' , 'family_1080' , 'family_1234' , 'family_691' , 'family_867' , 'laenderkueche_50808' , 'vendor_134' , 'vendor_1377' , 'vendor_860' , 'vendor_938' , 'art_27151' , 'family_1027' , 'family_1114' , 'family_1210' , 'family_1233' , 'family_629' , 'family_682' , 'family_973' , 'family_986' , 'fischart_37803' , 'fischart_54823' , 'geschmack_23747' , 'geschmack_26600' , 'geschmack_39591' , 'geschmack_43102' , 'serie_44880' , 'serie_51387' , 'typ_23685' , 'vendor_1521' , 'vendor_165' , 'vendor_922' , 'art_57036' , 'art_der_suessigkeiten_40113' , 'family_778' , 'geschmack_23764' , 'vendor_1027' , 'vendor_1292' , 'vendor_1348' , 'vendor_1373' , 'vendor_186' , 'vendor_381' , 'vendor_424' , 'vendor_725' , 'vendor_762' , 'art_29791' , 'art_54697' , 'family_1054' , 'family_1118' , 'family_789' , 'family_854' , 'family_975' , 'family_978' , 'fischart_29999' , 'fischart_36125' , 'fuellung_51115' , 'geschmack_23776' , 'geschmack_26612' , 'geschmack_32270' , 'manufacturer_53914' , 'vendor_679' , 'vendor_897' , 'vendor_944' , 'verpackung_3154' , 'verwendungszweck_2755' , 'volumen_2424' , 'art_23066' , 'art_54632' , 'art_55436' , 'family_1028' , 'family_441' , 'family_935' , 'geschmack_23763' , 'geschmack_36938' , 'getreideart_15480' , 'getreideart_15481' , 'handelsform_6235' , 'teigwarenart_38803' , 'vendor_1028' , 'vendor_1191' , 'vendor_1330' , 'vendor_1412' , 'vendor_1593' , 'vendor_751' , 'verpackung_4977' , 'verwendungszweck_5081' , 'verwendungszweck_7957' , 'anwendungszeit_2288' , 'art_51800' , 'art_56939' , 'family_1077' , 'family_699' , 'family_886' , 'family_977' , 'fischart_35526' , 'fischart_38548' , 'fuellung_52550' , 'fuellung_53397' , 'sorte_51687' , 'typ_27609' , 'typ_35555' , 'vendor_1214' , 'vendor_1216' , 'vendor_1228' , 'vendor_1317' , 'vendor_1374' , 'vendor_162' , 'vendor_171' , 'vendor_402' , 'vendor_499' , 'vendor_834' , 'aroma_3539' , 'art_29796' , 'art_37185' , 'family_1129' , 'family_1260' , 'family_1280' , 'family_754' , 'fischart_43299' , 'fuellung_36847' , 'fuellung_54431' , 'geschmack_23775' , 'geschmack_24687' , 'geschmack_36380' , 'sorte_7952' , 'vendor_1462' , 'vendor_149' , 'vendor_486' , 'vendor_759' , 'vendor_962' , 'verpackung_3609' , 'weinart_53885' , 'aroma_7551' , 'art_36372' , 'art_39785' , 'family_1000' , 'family_690' , 'fettanteil_54147' , 'fischart_37812' , 'fuellung_51760' , 'geschmack_23749' , 'geschmack_23766' , 'geschmack_31753' , 'geschmack_35745' , 'laenderkueche_36355' , 'netto_fuellmenge_filter_2' , 'pastete_sorten_29724' , 'pastete_sorten_29725' , 'serie_39543' , 'vendor_1031' , 'vendor_1226' , 'vendor_1255' , 'vendor_1476' , 'vendor_413' , 'vendor_477' , 'vendor_511' , 'vendor_553' , 'vendor_721' , 'vendor_724' , 'vendor_728' , 'art_39778' , 'art_53069' , 'art_54199' , 'family_1102' , 'family_1106' , 'family_1167' , 'family_1215' , 'family_1219' , 'family_752' , 'feiertage_825' , 'fuellung_39832' , 'geschmack_23779' , 'geschmack_26602' , 'geschmack_26929' , 'geschmack_36155' , 'geschmack_53621' , 'getreideart_23709' , 'laenderkueche_43013' , 'serie_39534' , 'typ_34174' , 'vendor_1113' , 'vendor_1383' , 'vendor_177' , 'vendor_192' , 'vendor_309' , 'vendor_579' , 'vendor_637' , 'vendor_914' , 'vendor_960' , 'verpackung_6308' , 'anzahl_der_portionen_35938' , 'aroma_3546' , 'art_23067' , 'art_7540' , 'family_1169' , 'family_976' , 'fleischart_30153' , 'fuellung_39485' , 'fuellung_39488' , 'geschmack_23783' , 'geschmack_45116' , 'geschmack_51195' , 'serie_55241' , 'sorte_39243' , 'vendor_111' , 'vendor_1125' , 'vendor_1173' , 'vendor_1296' , 'vendor_1316' , 'vendor_140' , 'vendor_1507' , 'vendor_227' , 'vendor_743' , 'vendor_954' , 'vendor_989' , 'verwendungszweck_2752' , 'verwendungszweck_35606' , 'volumen_1460' , 'altergruppierung_54019' , 'altergruppierung_6272' , 'anzahl_der_artikel_2679' , 'art_23723' , 'art_37143' , 'art_56221' , 'art_der_beeren_53100' , 'family_1226' , 'family_686' , 'family_756' , 'family_769' , 'family_770' , 'feiertage_821' , 'feiertage_826' , 'fettanteil_53700' , 'fischart_43325' , 'fuellung_39647' , 'fuellung_39651' , 'fuellung_51842' , 'fuellung_52241' , 'geschmack_23754' , 'geschmack_26611' , 'geschmack_26964' , 'geschmack_36921' , 'geschmack_38999' , 'geschmack_39836' , 'geschmack_39953' , 'pastete_sorten_29718' , 'serie_53575' , 'vendor_1015' , 'vendor_1070' , 'vendor_1133' , 'vendor_1153' , 'vendor_1158' , 'vendor_1218' , 'vendor_1318' , 'vendor_1422' , 'vendor_1466' , 'vendor_1472' , 'vendor_1508' , 'vendor_1540' , 'vendor_1598' , 'vendor_414' , 'vendor_430' , 'vendor_441' , 'vendor_449' , 'vendor_457' , 'vendor_552' , 'vendor_639' , 'vendor_641' , 'vendor_681' , 'vendor_755' , 'vendor_862' , 'vendor_991' , 'verwendungszweck_6088' , 'art_33908' , 'art_35238' , 'art_37170' , 'art_54194' , 'family_1009' , 'family_1031' , 'family_1074' , 'family_1214' , 'family_757' , 'family_974' , 'feiertage_823' , 'fettanteil_51891' , 'fuellung_29777' , 'fuellung_36364' , 'fuellung_52846' , 'geschmack_23758' , 'geschmack_23782' , 'geschmack_36940' , 'geschmack_54329' , 'getreideart_15482' , 'sorte_45806' , 'teigwarenart_25246' , 'vendor_1104' , 'vendor_1106' , 'vendor_116' , 'vendor_1240' , 'vendor_1328' , 'vendor_1372' , 'vendor_1394' , 'vendor_1406' , 'vendor_1433' , 'vendor_1459' , 'vendor_1464' , 'vendor_1496' , 'vendor_1529' , 'vendor_1545' , 'vendor_178' , 'vendor_267' , 'vendor_431' , 'vendor_533' , 'vendor_772' , 'verpackung_31703' , 'verwendungszweck_135' , 'anzahl_der_portionen_50815' , 'aroma_55191' , 'art_14443' , 'art_35236' , 'art_39627' , 'art_52277' , 'art_53592' , 'art_54630' , 'art_54638' , 'art_56253' , 'art_der_beeren_53103' , 'family_1032' , 'family_1033' , 'family_697' , 'family_773' , 'family_972' , 'fischart_29664' , 'fischart_54769' , 'fuellung_42734' , 'fuellung_51125' , 'fuellung_51170' , 'fuellung_51734' , 'fuellung_55934' , 'geschlecht_65' , 'geschmack_23760' , 'geschmack_26605' , 'geschmack_39002' , 'geschmack_39945' , 'grossen_38388' , 'materialgruppierung_33495' , 'netto_gewicht_filter_9' , 'serie_34905' , 'serie_54773' , 'typ_55466' , 'vendor_1025' , 'vendor_1165' , 'vendor_1187' , 'vendor_1205' , 'vendor_1289' , 'vendor_1297' , 'vendor_1337' , 'vendor_1376' , 'vendor_1483' , 'vendor_1495' , 'vendor_153' , 'vendor_1549' , 'vendor_1582' , 'vendor_1595' , 'vendor_274' , 'vendor_277' , 'vendor_537' , 'vendor_554' , 'vendor_608' , 'vendor_685' , 'vendor_785' , 'vendor_852' , 'vendor_861' , 'vendor_869' , 'vendor_924' , 'vendor_980' , 'verpackung_45261' , 'verpackung_46731' , 'verwendungszweck_17979' , 'verwendungszweck_2256' , 'verwendungszweck_29892' , 'verwendungszweck_41370' , 'aroma_26886' , 'aroma_4227' , 'aroma_4975' , 'aroma_4976' , 'art_36368' , 'art_37171' , 'art_37854' , 'art_54635' , 'art_54694' , 'art_54695' , 'art_55179' , 'art_56419' , 'art_der_beeren_53566' , 'art_der_beeren_54072' , 'art_der_beeren_54397' , 'extract_53040' , 'family_1120' , 'family_1131' , 'family_1229' , 'family_1249' , 'family_755' , 'fettanteil_43969' , 'fettanteil_52040' , 'fischart_43320' , 'fischart_43337' , 'fischart_52914' , 'fuellung_52898' , 'geschlecht_66' , 'geschmack_36935' , 'geschmack_44672' , 'geschmack_51196' , 'geschmack_54650' , 'laenderkueche_51124' , 'manufacturer_53916' , 'manufacturer_57302' , 'serie_36417' , 'serie_44736' , 'teigwarenart_25230' , 'typ_48885' , 'vendor_1018' , 'vendor_1160' , 'vendor_1207' , 'vendor_1342' , 'vendor_1350' , 'vendor_1410' , 'vendor_1435' , 'vendor_1455' , 'vendor_1456' , 'vendor_1555' , 'vendor_1588' , 'vendor_1597' , 'vendor_1606' , 'vendor_166' , 'vendor_170' , 'vendor_316' , 'vendor_405' , 'vendor_432' , 'vendor_438' , 'vendor_519' , 'vendor_528' , 'vendor_621' , 'vendor_984' , 'verwendungszweck_6536' , 'verwendungszweck_9603' , 'volumen_2365' , 'weinart_53876' , 'aroma_13964' , 'aroma_17796' , 'aroma_23887' , 'aroma_23893' , 'art_22870' , 'art_22876' , 'art_29788' , 'art_29790' , 'art_29792' , 'art_41586' , 'art_51126' , 'art_54141' , 'art_54633' , 'art_54637' , 'art_54715' , 'art_der_beeren_53106' , 'art_der_beeren_56092' , 'extract_53033' , 'family_1021' , 'family_1030' , 'family_1036' , 'family_1046' , 'family_1100' , 'family_1128' , 'family_1176' , 'family_1209' , 'family_1227' , 'family_1238' , 'family_1240' , 'family_1254' , 'family_1269' , 'family_1270' , 'family_1273' , 'family_526' , 'family_926' , 'farbgruppierung_579' , 'fettanteil_52035' , 'fettanteil_52299' , 'fischart_29661' , 'fischart_37804' , 'fleischart_15475' , 'fleischart_54883' , 'fleischart_54889' , 'fuellung_51114' , 'fuellung_55175' , 'geschmack_23771' , 'geschmack_23777' , 'geschmack_26604' , 'geschmack_36669' , 'geschmack_36851' , 'geschmack_46434' , 'geschmack_53803' , 'getreideart_23708' , 'laenderkueche_47654' , 'laenderkueche_48797' , 'manufacturer_55474' , 'netto_fuellmenge_filter_6' , 'netto_gewicht_filter_8' , 'serie_33808' , 'serie_37454' , 'serie_41382' , 'serie_51965' , 'serie_55386' , 'teigwarenart_25229' , 'teigwarenart_56421' , 'typ_55388' , 'vendor_1054' , 'vendor_1119' , 'vendor_1146' , 'vendor_1157' , 'vendor_1206' , 'vendor_1261' , 'vendor_1277' , 'vendor_1300' , 'vendor_1311' , 'vendor_1355' , 'vendor_1357' , 'vendor_1380' , 'vendor_1385' , 'vendor_1450' , 'vendor_1457' , 'vendor_1481' , 'vendor_152' , 'vendor_1534' , 'vendor_154' , 'vendor_1542' , 'vendor_1563' , 'vendor_1567' , 'vendor_1568' , 'vendor_1621' , 'vendor_164' , 'vendor_181' , 'vendor_265' , 'vendor_444' , 'vendor_500' , 'vendor_535' , 'vendor_538' , 'vendor_547' , 'vendor_582' , 'vendor_642' , 'vendor_644' , 'vendor_738' , 'vendor_767' , 'vendor_770' , 'vendor_851' , 'vendor_855' , 'vendor_873' , 'vendor_896' , 'vendor_909' , 'vendor_910' , 'vendor_928' , 'vendor_967' , 'vendor_972' , 'vendor_979' , 'verwendungszweck_2248' , 'verwendungszweck_6827' , 'volumen_37380' , 'weinart_53872' , 'anwendungszeit_9771' , 'aroma_13957' , 'aroma_24235' , 'art_22724' , 'art_22832' , 'art_22836' , 'art_30396' , 'art_30632' , 'art_30649' , 'art_30666' , 'art_33919' , 'art_54198' , 'art_54636' , 'art_54739' , 'art_55667' , 'art_56215' , 'art_56255' , 'art_56257' , 'art_57225' , 'art_der_beeren_54286' , 'art_der_beeren_54717' , 'art_der_suessigkeiten_39991' , 'extract_53002' , 'family_1024' , 'family_1045' , 'family_1075' , 'family_1225' , 'family_1253' , 'family_1262' , 'family_1266' , 'family_1279' , 'family_695' , 'family_759' , 'family_868' , 'feiertage_822' , 'fuellung_51140' , 'fuellung_51969' , 'fuellung_52598' , 'fuellung_54104' , 'fuellung_54798' , 'fuellung_55875' , 'geschmack_26599' , 'geschmack_26607' , 'geschmack_36932' , 'geschmack_37738' , 'geschmack_42691' , 'geschmack_53895' , 'geschmack_54213' , 'geschmack_56818' , 'getreideart_25279' , 'getreideart_38595' , 'handelsform_5910' , 'manufacturer_57065' , 'netto_gewicht_filter_11' , 'netto_gewicht_filter_13' , 'serie_39536' , 'serie_39538' , 'serie_55666' , 'sorte_19469' , 'typ_16198' , 'vendor_1007' , 'vendor_1020' , 'vendor_1033' , 'vendor_1037' , 'vendor_1055' , 'vendor_1107' , 'vendor_1195' , 'vendor_1241' , 'vendor_1247' , 'vendor_1254' , 'vendor_1260' , 'vendor_1302' , 'vendor_1307' , 'vendor_1309' , 'vendor_1312' , 'vendor_1319' , 'vendor_1371' , 'vendor_1375' , 'vendor_1378' , 'vendor_138' , 'vendor_1386' , 'vendor_1423' , 'vendor_143' , 'vendor_1458' , 'vendor_1477' , 'vendor_1482' , 'vendor_1486' , 'vendor_1487' , 'vendor_1492' , 'vendor_1494' , 'vendor_1505' , 'vendor_151' , 'vendor_1520' , 'vendor_1527' , 'vendor_1528' , 'vendor_1535' , 'vendor_1543' , 'vendor_1554' , 'vendor_157' , 'vendor_1578' , 'vendor_1580' , 'vendor_1581' , 'vendor_1587' , 'vendor_1605' , 'vendor_1624' , 'vendor_223' , 'vendor_225' , 'vendor_251' , 'vendor_295' , 'vendor_296' , 'vendor_346' , 'vendor_403' , 'vendor_406' , 'vendor_459' , 'vendor_490' , 'vendor_527' , 'vendor_573' , 'vendor_577' , 'vendor_609' , 'vendor_630' , 'vendor_744' , 'vendor_814' , 'vendor_883' , 'vendor_946' , 'vendor_992' , 'verwendungszweck_16237' , 'verwendungszweck_2240' , 'verwendungszweck_34164' , 'verwendungszweck_35571' , 'verwendungszweck_6814' , 'volumen_32280' , 'volumen_41001' , 'volumen_41002' , 'volumen_5235' , 'weinart_57300' , 'anzahl_der_artikel_2680' , 'anzahl_der_portionen_35920' , 'anzahl_der_portionen_35933' , 'aroma_11395' , 'aroma_17795' , 'aroma_22670' , 'aroma_39184' , 'aroma_39201' , 'aroma_4224' , 'aroma_4974' , 'aroma_6917' , 'art_15478' , 'art_22663' , 'art_22806' , 'art_22810' , 'art_22844' , 'art_22868' , 'art_29789' , 'art_30630' , 'art_30684' , 'art_36390' , 'art_40602' , 'art_51286' , 'art_54105' , 'art_54140' , 'art_54455' , 'art_54738' , 'art_55008' , 'art_56993' , 'art_57203' , 'art_der_beeren_54004' , 'art_der_beeren_56099' , 'art_der_suessigkeiten_52757' , 'extract_53001' , 'extract_53015' , 'family_1011' , 'family_1016' , 'family_1023' , 'family_1115' , 'family_1259' , 'family_723' , 'family_758' , 'family_858' , 'family_936' , 'farbgruppierung_578' , 'fettanteil_53325' , 'fettanteil_54814' , 'fettanteil_55626' , 'fettanteil_55845' , 'fettanteil_56075' , 'fischart_29665' , 'fischart_43293' , 'fischart_45346' , 'fischart_52492' , 'fischart_52858' , 'fischart_55177' , 'fischart_57425' , 'fuellung_36367' , 'fuellung_39661' , 'fuellung_55123' , 'fuellung_55170' , 'fuellung_55284' , 'fuellung_55786' , 'geschmack_23748' , 'geschmack_23769' , 'geschmack_26329' , 'geschmack_29525' , 'geschmack_36381' , 'geschmack_39167' , 'geschmack_42774' , 'geschmack_45977' , 'geschmack_51197' , 'geschmack_54330' , 'geschmack_54443' , 'geschmack_54962' , 'getreideart_25278' , 'handelsform_27518' , 'handelsform_35599' , 'laenderkueche_36351' , 'laenderkueche_36353' , 'laenderkueche_43127' , 'manufacturer_53918' , 'manufacturer_55475' , 'manufacturer_56718' , 'manufacturer_56721' , 'manufacturer_56723' , 'manufacturer_57094' , 'pastete_sorten_29726' , 'serie_32988' , 'serie_53680' , 'sorte_27412' , 'sorte_39254' , 'typ_33892' , 'typ_40821' , 'vendor_1035' , 'vendor_1048' , 'vendor_1051' , 'vendor_1064' , 'vendor_1077' , 'vendor_1085' , 'vendor_1088' , 'vendor_1112' , 'vendor_1114' , 'vendor_112' , 'vendor_1121' , 'vendor_1145' , 'vendor_1147' , 'vendor_1181' , 'vendor_1197' , 'vendor_1215' , 'vendor_125' , 'vendor_1276' , 'vendor_1281' , 'vendor_1293' , 'vendor_1315' , 'vendor_1327' , 'vendor_1333' , 'vendor_1346' , 'vendor_1347' , 'vendor_1379' , 'vendor_1381' , 'vendor_1388' , 'vendor_1390' , 'vendor_1414' , 'vendor_1432' , 'vendor_144' , 'vendor_1440' , 'vendor_1449' , 'vendor_1463' , 'vendor_1465' , 'vendor_1470' , 'vendor_1478' , 'vendor_1479' , 'vendor_1484' , 'vendor_1512' , 'vendor_1522' , 'vendor_1533' , 'vendor_1536' , 'vendor_1546' , 'vendor_1547' , 'vendor_1552' , 'vendor_1558' , 'vendor_1575' , 'vendor_1577' , 'vendor_1591' , 'vendor_1610' , 'vendor_1612' , 'vendor_1618' , 'vendor_1629' , 'vendor_1631' , 'vendor_1634' , 'vendor_200' , 'vendor_207' , 'vendor_248' , 'vendor_259' , 'vendor_347' , 'vendor_412' , 'vendor_467' , 'vendor_514' , 'vendor_534' , 'vendor_551' , 'vendor_636' , 'vendor_664' , 'vendor_665' , 'vendor_666' , 'vendor_678' , 'vendor_689' , 'vendor_700' , 'vendor_745' , 'vendor_821' , 'vendor_836' , 'vendor_850' , 'vendor_907' , 'vendor_956' , 'vendor_958' , 'vendor_961' , 'verpackung_39173' , 'verwendungszweck_36655' , 'verwendungszweck_52782' , 'verwendungszweck_52792' , 'volumen_1461' , 'volumen_1462' , 'volumen_2366' , 'volumen_43345' , 'volumen_7546' , 'volumen_der_tasse_40912' , 'aroma_13960' , 'aroma_17731' , 'aroma_30995' , 'aroma_4380' , 'aroma_4973' , 'aroma_53980' , 'art_14447' , 'art_22813' , 'art_22815' , 'art_22848' , 'art_22921' , 'art_23546' , 'art_23722' , 'art_30395' , 'art_30648' , 'art_30689' , 'art_30692' , 'art_33928' , 'art_36991' , 'art_37210' , 'art_37849' , 'art_37853' , 'art_38567' , 'art_38894' , 'art_38895' , 'art_40589' , 'art_41081' , 'art_53588' , 'art_53590' , 'art_53591' , 'art_53766' , 'art_54195' , 'art_54284' , 'art_54693' , 'art_54698' , 'art_55980' , 'art_56004' , 'art_56010' , 'art_56254' , 'art_56675' , 'art_6091' , 'art_der_beeren_56094' , 'art_der_beeren_56097' , 'art_der_beeren_56100' , 'duft_31347' , 'duft_36386' , 'extract_53029' , 'extract_53035' , 'family_1015' , 'family_1018' , 'family_1019' , 'family_1020' , 'family_1022' , 'family_1034' , 'family_1043' , 'family_1055' , 'family_1066' , 'family_1067' , 'family_1099' , 'family_1142' , 'family_1144' , 'family_1172' , 'family_1223' , 'family_1239' , 'family_1246' , 'family_1250' , 'family_1251' , 'family_1264' , 'family_1265' , 'family_1267' , 'family_1271' , 'family_1274' , 'family_1287' , 'family_1291' , 'family_1292' , 'family_255' , 'family_866' , 'farbgruppierung_586' , 'fettanteil_52046' , 'fettanteil_52300' , 'fettanteil_52303' , 'fettanteil_54188' , 'fettanteil_54437' , 'fettanteil_56070' , 'fettanteil_56074' , 'fettanteil_56076' , 'fettanteil_56744' , 'fischart_29658' , 'fischart_29663' , 'fischart_43277' , 'fischart_52356' , 'fischart_52490' , 'fischart_53820' , 'fischart_54516' , 'fischart_56343' , 'fischart_57014' , 'fischart_57452' , 'fuellung_39210' , 'fuellung_39649' , 'fuellung_51108' , 'fuellung_51109' , 'fuellung_52410' , 'fuellung_52596' , 'fuellung_52816' , 'fuellung_54361' , 'fuellung_54834' , 'fuellung_55407' , 'fuellung_56012' , 'fuellung_56653' , 'fuellung_56743' , 'fuellung_57524' , 'geschmack_24711' , 'geschmack_36387' , 'geschmack_39555' , 'geschmack_42722' , 'geschmack_45473' , 'geschmack_46433' , 'geschmack_47953' , 'geschmack_51194' , 'geschmack_54341' , 'geschmack_54640' , 'geschmack_54643' , 'geschmack_54709' , 'geschmack_54744' , 'geschmack_54799' , 'geschmack_56404' , 'geschmack_56650' , 'geschmack_56714' , 'geschmack_57342' , 'geschmack_57392' , 'geschmack_57615' , 'geschmack_57616' , 'getreideart_38553' , 'laenderkueche_36360' , 'laenderkueche_36361' , 'laenderkueche_43129' , 'laenderkueche_43210' , 'manufacturer_53919' , 'manufacturer_55471' , 'manufacturer_56717' , 'manufacturer_56720' , 'manufacturer_57095' , 'modelname_52509' , 'netto_fuellmenge_filter_7' , 'netto_fuellmenge_filter_8' , 'netto_gewicht_filter_10' , 'pastete_sorten_50587' , 'serie_39537' , 'serie_39539' , 'serie_39540' , 'serie_45257' , 'serie_52845' , 'serie_54749' , 'serie_55669' , 'typ_33917' , 'typ_37811' , 'typ_54760' , 'typ_7530' , 'vendor_1000' , 'vendor_1022' , 'vendor_1032' , 'vendor_1049' , 'vendor_1063' , 'vendor_1065' , 'vendor_1072' , 'vendor_1087' , 'vendor_1091' , 'vendor_1103' , 'vendor_1124' , 'vendor_1138' , 'vendor_1140' , 'vendor_1149' , 'vendor_1162' , 'vendor_118' , 'vendor_1182' , 'vendor_1186' , 'vendor_1190' , 'vendor_1208' , 'vendor_1213' , 'vendor_1224' , 'vendor_1229' , 'vendor_1234' , 'vendor_1252' , 'vendor_1283' , 'vendor_1291' , 'vendor_1299' , 'vendor_1310' , 'vendor_1322' , 'vendor_1325' , 'vendor_1326' , 'vendor_1331' , 'vendor_1340' , 'vendor_1352' , 'vendor_1354' , 'vendor_1382' , 'vendor_1387' , 'vendor_139' , 'vendor_141' , 'vendor_1416' , 'vendor_1417' , 'vendor_1436' , 'vendor_1441' , 'vendor_1451' , 'vendor_146' , 'vendor_1460' , 'vendor_1461' , 'vendor_1474' , 'vendor_1488' , 'vendor_1491' , 'vendor_1497' , 'vendor_1506' , 'vendor_1509' , 'vendor_1514' , 'vendor_1515' , 'vendor_1524' , 'vendor_1526' , 'vendor_1530' , 'vendor_1531' , 'vendor_1532' , 'vendor_1537' , 'vendor_1541' , 'vendor_1544' , 'vendor_1548' , 'vendor_1556' , 'vendor_1557' , 'vendor_1561' , 'vendor_1562' , 'vendor_1572' , 'vendor_1579' , 'vendor_1585' , 'vendor_1586' , 'vendor_1590' , 'vendor_1592' , 'vendor_1596' , 'vendor_1617' , 'vendor_1619' , 'vendor_1620' , 'vendor_1623' , 'vendor_1633' , 'vendor_187' , 'vendor_203' , 'vendor_204' , 'vendor_230' , 'vendor_232' , 'vendor_235' , 'vendor_236' , 'vendor_240' , 'vendor_256' , 'vendor_261' , 'vendor_271' , 'vendor_280' , 'vendor_282' , 'vendor_291' , 'vendor_305' , 'vendor_313' , 'vendor_336' , 'vendor_348' , 'vendor_353' , 'vendor_383' , 'vendor_408' , 'vendor_409' , 'vendor_437' , 'vendor_442' , 'vendor_446' , 'vendor_448' , 'vendor_473' , 'vendor_481' , 'vendor_484' , 'vendor_508' , 'vendor_513' , 'vendor_518' , 'vendor_521' , 'vendor_558' , 'vendor_565' , 'vendor_566' , 'vendor_570' , 'vendor_580' , 'vendor_581' , 'vendor_617' , 'vendor_635' , 'vendor_649' , 'vendor_677' , 'vendor_695' , 'vendor_699' , 'vendor_715' , 'vendor_717' , 'vendor_750' , 'vendor_757' , 'vendor_758' , 'vendor_779' , 'vendor_786' , 'vendor_832' , 'vendor_835' , 'vendor_845' , 'vendor_872' , 'vendor_880' , 'vendor_884' , 'vendor_886' , 'vendor_893' , 'vendor_901' , 'vendor_902' , 'vendor_904' , 'vendor_906' , 'vendor_908' , 'vendor_915' , 'vendor_919' , 'vendor_929' , 'vendor_937' , 'vendor_964' , 'vendor_968' , 'vendor_981' , 'vendor_983' , 'vendor_987' , 'verwendungszweck_2316' , 'verwendungszweck_2721' , 'verwendungszweck_32164' , 'verwendungszweck_34356' , 'verwendungszweck_4742' , 'verwendungszweck_48981' , 'verwendungszweck_5001' , 'verwendungszweck_5053' , 'verwendungszweck_53177' , 'verwendungszweck_6042' , 'verwendungszweck_6231' , 'verwendungszweck_6232' , 'verwendungszweck_7976' , 'volumen_2368' , 'volumen_2411' , 'volumen_2463' , 'volumen_3001' , 'volumen_3283' , 'volumen_3732' , 'volumen_41815' , 'volumen_4942' , 'volumen_51890' , 'volumen_56310' , 'volumen_9140' , 'volumen_9651' , 'volumen_9913' , 'weinart_53910' ) AND a . is_filterable = true ; Copy