3
0.20 ms
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 ('sparset_filter_0' , 'freezebox_filter_3' , 'coolbox_filter_0' , 'coolbox_filter_1' , 'family_1073' , 'freezebox_filter_2' , 'family_1072' , 'fleischart_15470' , 'family_1152' , 'vendor_482' , 'family_1275' , 'vendor_531' , 'family_376' , 'family_971' , 'getreideart_15473' , 'vendor_357' , 'family_692' , 'vendor_1135' , 'vendor_1298' , 'family_1002' , 'family_685' , 'fleischart_47539' , 'getreideart_25277' , 'family_1101' , 'family_980' , 'family_1078' , 'family_441' , 'family_683' , 'family_684' , 'family_981' , 'vendor_1152' , 'vendor_42' , 'art_der_suessigkeiten_46435' , 'family_920' , 'family_932' , 'fischart_29660' , 'laenderkueche_43012' , 'vendor_458' , 'vendor_486' , 'vendor_895' , 'family_1220' , 'family_716' , 'fischart_29740' , 'fischart_29998' , 'fleischart_15474' , 'serie_51387' , 'vendor_914' , 'family_1106' , 'family_462' , 'family_711' , 'laenderkueche_36352' , 'vendor_114' , 'vendor_159' , 'vendor_386' , 'vendor_402' , 'vendor_762' , 'family_1035' , 'family_1049' , 'family_1077' , 'family_1260' , 'family_594' , 'family_688' , 'family_690' , 'family_752' , 'family_865' , 'fischart_37803' , 'fischart_54823' , 'teigwarenart_25243' , 'vendor_1031' , 'vendor_1216' , 'vendor_1318' , 'vendor_1466' , 'vendor_1476' , 'vendor_150' , 'vendor_165' , 'vendor_178' , 'vendor_449' , 'vendor_477' , 'vendor_489' , 'family_1280' , 'family_629' , 'family_699' , 'family_850' , 'family_880' , 'fischart_35526' , 'fischart_38548' , 'laenderkueche_36350' , 'pastete_sorten_29724' , 'vendor_1310' , 'vendor_1316' , 'vendor_1317' , 'vendor_1337' , 'vendor_134' , 'vendor_1372' , 'vendor_154' , 'vendor_196' , 'vendor_198' , 'vendor_404' , 'vendor_405' , 'vendor_751' , 'vendor_772' , 'vendor_938' , 'family_1000' , 'family_1065' , 'family_1232' , 'family_1234' , 'family_1265' , 'family_1266' , 'family_687' , 'family_689' , 'family_693' , 'family_724' , 'family_978' , 'fischart_29659' , 'fischart_29999' , 'fischart_36125' , 'fischart_43299' , 'getreideart_15480' , 'getreideart_15481' , 'getreideart_23671' , 'laenderkueche_36349' , 'netto_fuellmenge_filter_5' , 'netto_fuellmenge_filter_7' , 'pastete_sorten_29725' , 'serie_44880' , 'serie_55241' , 'vendor_1018' , 'vendor_1020' , 'vendor_1113' , 'vendor_1145' , 'vendor_1158' , 'vendor_1179' , 'vendor_1228' , 'vendor_1247' , 'vendor_1296' , 'vendor_1311' , 'vendor_1455' , 'vendor_1462' , 'vendor_156' , 'vendor_1567' , 'vendor_1574' , 'vendor_1598' , 'vendor_1618' , 'vendor_162' , 'vendor_1621' , 'vendor_170' , 'vendor_224' , 'vendor_231' , 'vendor_499' , 'vendor_500' , 'vendor_621' , 'vendor_678' , 'vendor_716' , 'vendor_728' , 'vendor_862' , 'vendor_897' , 'vendor_924' , 'art_der_beeren_53106' , 'art_der_beeren_53566' , 'art_der_suessigkeiten_34384' , 'art_der_suessigkeiten_35208' , 'family_1026' , 'family_1075' , 'family_1102' , 'family_1131' , 'family_1176' , 'family_1213' , 'family_1215' , 'family_1286' , 'family_1291' , 'family_255' , 'family_682' , 'family_695' , 'family_754' , 'family_756' , 'family_769' , 'family_926' , 'family_936' , 'family_972' , 'family_973' , 'family_975' , 'family_976' , 'family_977' , 'fischart_29664' , 'fischart_29665' , 'fischart_30000' , 'fischart_52914' , 'fleischart_47119' , 'fleischart_54889' , 'getreideart_15476' , 'getreideart_15482' , 'getreideart_23707' , 'getreideart_23709' , 'laenderkueche_36354' , 'laenderkueche_36355' , 'laenderkueche_43127' , 'laenderkueche_51124' , 'netto_fuellmenge_filter_3' , 'netto_fuellmenge_filter_4' , 'netto_fuellmenge_filter_8' , 'pastete_sorten_29718' , 'pastete_sorten_29726' , 'serie_54773' , 'teigwarenart_38803' , 'vendor_1048' , 'vendor_1064' , 'vendor_1112' , 'vendor_1125' , 'vendor_1138' , 'vendor_1147' , 'vendor_116' , 'vendor_1160' , 'vendor_1205' , 'vendor_1241' , 'vendor_1302' , 'vendor_1322' , 'vendor_140' , 'vendor_1406' , 'vendor_1412' , 'vendor_146' , 'vendor_1483' , 'vendor_1496' , 'vendor_152' , 'vendor_1582' , 'vendor_1591' , 'vendor_177' , 'vendor_192' , 'vendor_221' , 'vendor_227' , 'vendor_236' , 'vendor_309' , 'vendor_316' , 'vendor_348' , 'vendor_380' , 'vendor_383' , 'vendor_412' , 'vendor_424' , 'vendor_430' , 'vendor_432' , 'vendor_457' , 'vendor_467' , 'vendor_529' , 'vendor_637' , 'vendor_644' , 'vendor_664' , 'vendor_679' , 'vendor_752' , 'vendor_909' , 'vendor_910' , 'vendor_944' , 'vendor_952' , 'vendor_972' ) 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 (
'sparset_filter_0' ,
'freezebox_filter_3' ,
'coolbox_filter_0' ,
'coolbox_filter_1' ,
'family_1073' ,
'freezebox_filter_2' ,
'family_1072' ,
'fleischart_15470' ,
'family_1152' ,
'vendor_482' ,
'family_1275' ,
'vendor_531' ,
'family_376' ,
'family_971' ,
'getreideart_15473' ,
'vendor_357' ,
'family_692' ,
'vendor_1135' ,
'vendor_1298' ,
'family_1002' ,
'family_685' ,
'fleischart_47539' ,
'getreideart_25277' ,
'family_1101' ,
'family_980' ,
'family_1078' ,
'family_441' ,
'family_683' ,
'family_684' ,
'family_981' ,
'vendor_1152' ,
'vendor_42' ,
'art_der_suessigkeiten_46435' ,
'family_920' ,
'family_932' ,
'fischart_29660' ,
'laenderkueche_43012' ,
'vendor_458' ,
'vendor_486' ,
'vendor_895' ,
'family_1220' ,
'family_716' ,
'fischart_29740' ,
'fischart_29998' ,
'fleischart_15474' ,
'serie_51387' ,
'vendor_914' ,
'family_1106' ,
'family_462' ,
'family_711' ,
'laenderkueche_36352' ,
'vendor_114' ,
'vendor_159' ,
'vendor_386' ,
'vendor_402' ,
'vendor_762' ,
'family_1035' ,
'family_1049' ,
'family_1077' ,
'family_1260' ,
'family_594' ,
'family_688' ,
'family_690' ,
'family_752' ,
'family_865' ,
'fischart_37803' ,
'fischart_54823' ,
'teigwarenart_25243' ,
'vendor_1031' ,
'vendor_1216' ,
'vendor_1318' ,
'vendor_1466' ,
'vendor_1476' ,
'vendor_150' ,
'vendor_165' ,
'vendor_178' ,
'vendor_449' ,
'vendor_477' ,
'vendor_489' ,
'family_1280' ,
'family_629' ,
'family_699' ,
'family_850' ,
'family_880' ,
'fischart_35526' ,
'fischart_38548' ,
'laenderkueche_36350' ,
'pastete_sorten_29724' ,
'vendor_1310' ,
'vendor_1316' ,
'vendor_1317' ,
'vendor_1337' ,
'vendor_134' ,
'vendor_1372' ,
'vendor_154' ,
'vendor_196' ,
'vendor_198' ,
'vendor_404' ,
'vendor_405' ,
'vendor_751' ,
'vendor_772' ,
'vendor_938' ,
'family_1000' ,
'family_1065' ,
'family_1232' ,
'family_1234' ,
'family_1265' ,
'family_1266' ,
'family_687' ,
'family_689' ,
'family_693' ,
'family_724' ,
'family_978' ,
'fischart_29659' ,
'fischart_29999' ,
'fischart_36125' ,
'fischart_43299' ,
'getreideart_15480' ,
'getreideart_15481' ,
'getreideart_23671' ,
'laenderkueche_36349' ,
'netto_fuellmenge_filter_5' ,
'netto_fuellmenge_filter_7' ,
'pastete_sorten_29725' ,
'serie_44880' ,
'serie_55241' ,
'vendor_1018' ,
'vendor_1020' ,
'vendor_1113' ,
'vendor_1145' ,
'vendor_1158' ,
'vendor_1179' ,
'vendor_1228' ,
'vendor_1247' ,
'vendor_1296' ,
'vendor_1311' ,
'vendor_1455' ,
'vendor_1462' ,
'vendor_156' ,
'vendor_1567' ,
'vendor_1574' ,
'vendor_1598' ,
'vendor_1618' ,
'vendor_162' ,
'vendor_1621' ,
'vendor_170' ,
'vendor_224' ,
'vendor_231' ,
'vendor_499' ,
'vendor_500' ,
'vendor_621' ,
'vendor_678' ,
'vendor_716' ,
'vendor_728' ,
'vendor_862' ,
'vendor_897' ,
'vendor_924' ,
'art_der_beeren_53106' ,
'art_der_beeren_53566' ,
'art_der_suessigkeiten_34384' ,
'art_der_suessigkeiten_35208' ,
'family_1026' ,
'family_1075' ,
'family_1102' ,
'family_1131' ,
'family_1176' ,
'family_1213' ,
'family_1215' ,
'family_1286' ,
'family_1291' ,
'family_255' ,
'family_682' ,
'family_695' ,
'family_754' ,
'family_756' ,
'family_769' ,
'family_926' ,
'family_936' ,
'family_972' ,
'family_973' ,
'family_975' ,
'family_976' ,
'family_977' ,
'fischart_29664' ,
'fischart_29665' ,
'fischart_30000' ,
'fischart_52914' ,
'fleischart_47119' ,
'fleischart_54889' ,
'getreideart_15476' ,
'getreideart_15482' ,
'getreideart_23707' ,
'getreideart_23709' ,
'laenderkueche_36354' ,
'laenderkueche_36355' ,
'laenderkueche_43127' ,
'laenderkueche_51124' ,
'netto_fuellmenge_filter_3' ,
'netto_fuellmenge_filter_4' ,
'netto_fuellmenge_filter_8' ,
'pastete_sorten_29718' ,
'pastete_sorten_29726' ,
'serie_54773' ,
'teigwarenart_38803' ,
'vendor_1048' ,
'vendor_1064' ,
'vendor_1112' ,
'vendor_1125' ,
'vendor_1138' ,
'vendor_1147' ,
'vendor_116' ,
'vendor_1160' ,
'vendor_1205' ,
'vendor_1241' ,
'vendor_1302' ,
'vendor_1322' ,
'vendor_140' ,
'vendor_1406' ,
'vendor_1412' ,
'vendor_146' ,
'vendor_1483' ,
'vendor_1496' ,
'vendor_152' ,
'vendor_1582' ,
'vendor_1591' ,
'vendor_177' ,
'vendor_192' ,
'vendor_221' ,
'vendor_227' ,
'vendor_236' ,
'vendor_309' ,
'vendor_316' ,
'vendor_348' ,
'vendor_380' ,
'vendor_383' ,
'vendor_412' ,
'vendor_424' ,
'vendor_430' ,
'vendor_432' ,
'vendor_457' ,
'vendor_467' ,
'vendor_529' ,
'vendor_637' ,
'vendor_644' ,
'vendor_664' ,
'vendor_679' ,
'vendor_752' ,
'vendor_909' ,
'vendor_910' ,
'vendor_944' ,
'vendor_952' ,
'vendor_972'
)
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 ('sparset_filter_0' , 'freezebox_filter_3' , 'coolbox_filter_0' , 'coolbox_filter_1' , 'family_1073' , 'freezebox_filter_2' , 'family_1072' , 'fleischart_15470' , 'family_1152' , 'vendor_482' , 'family_1275' , 'vendor_531' , 'family_376' , 'family_971' , 'getreideart_15473' , 'vendor_357' , 'family_692' , 'vendor_1135' , 'vendor_1298' , 'family_1002' , 'family_685' , 'fleischart_47539' , 'getreideart_25277' , 'family_1101' , 'family_980' , 'family_1078' , 'family_441' , 'family_683' , 'family_684' , 'family_981' , 'vendor_1152' , 'vendor_42' , 'art_der_suessigkeiten_46435' , 'family_920' , 'family_932' , 'fischart_29660' , 'laenderkueche_43012' , 'vendor_458' , 'vendor_486' , 'vendor_895' , 'family_1220' , 'family_716' , 'fischart_29740' , 'fischart_29998' , 'fleischart_15474' , 'serie_51387' , 'vendor_914' , 'family_1106' , 'family_462' , 'family_711' , 'laenderkueche_36352' , 'vendor_114' , 'vendor_159' , 'vendor_386' , 'vendor_402' , 'vendor_762' , 'family_1035' , 'family_1049' , 'family_1077' , 'family_1260' , 'family_594' , 'family_688' , 'family_690' , 'family_752' , 'family_865' , 'fischart_37803' , 'fischart_54823' , 'teigwarenart_25243' , 'vendor_1031' , 'vendor_1216' , 'vendor_1318' , 'vendor_1466' , 'vendor_1476' , 'vendor_150' , 'vendor_165' , 'vendor_178' , 'vendor_449' , 'vendor_477' , 'vendor_489' , 'family_1280' , 'family_629' , 'family_699' , 'family_850' , 'family_880' , 'fischart_35526' , 'fischart_38548' , 'laenderkueche_36350' , 'pastete_sorten_29724' , 'vendor_1310' , 'vendor_1316' , 'vendor_1317' , 'vendor_1337' , 'vendor_134' , 'vendor_1372' , 'vendor_154' , 'vendor_196' , 'vendor_198' , 'vendor_404' , 'vendor_405' , 'vendor_751' , 'vendor_772' , 'vendor_938' , 'family_1000' , 'family_1065' , 'family_1232' , 'family_1234' , 'family_1265' , 'family_1266' , 'family_687' , 'family_689' , 'family_693' , 'family_724' , 'family_978' , 'fischart_29659' , 'fischart_29999' , 'fischart_36125' , 'fischart_43299' , 'getreideart_15480' , 'getreideart_15481' , 'getreideart_23671' , 'laenderkueche_36349' , 'netto_fuellmenge_filter_5' , 'netto_fuellmenge_filter_7' , 'pastete_sorten_29725' , 'serie_44880' , 'serie_55241' , 'vendor_1018' , 'vendor_1020' , 'vendor_1113' , 'vendor_1145' , 'vendor_1158' , 'vendor_1179' , 'vendor_1228' , 'vendor_1247' , 'vendor_1296' , 'vendor_1311' , 'vendor_1455' , 'vendor_1462' , 'vendor_156' , 'vendor_1567' , 'vendor_1574' , 'vendor_1598' , 'vendor_1618' , 'vendor_162' , 'vendor_1621' , 'vendor_170' , 'vendor_224' , 'vendor_231' , 'vendor_499' , 'vendor_500' , 'vendor_621' , 'vendor_678' , 'vendor_716' , 'vendor_728' , 'vendor_862' , 'vendor_897' , 'vendor_924' , 'art_der_beeren_53106' , 'art_der_beeren_53566' , 'art_der_suessigkeiten_34384' , 'art_der_suessigkeiten_35208' , 'family_1026' , 'family_1075' , 'family_1102' , 'family_1131' , 'family_1176' , 'family_1213' , 'family_1215' , 'family_1286' , 'family_1291' , 'family_255' , 'family_682' , 'family_695' , 'family_754' , 'family_756' , 'family_769' , 'family_926' , 'family_936' , 'family_972' , 'family_973' , 'family_975' , 'family_976' , 'family_977' , 'fischart_29664' , 'fischart_29665' , 'fischart_30000' , 'fischart_52914' , 'fleischart_47119' , 'fleischart_54889' , 'getreideart_15476' , 'getreideart_15482' , 'getreideart_23707' , 'getreideart_23709' , 'laenderkueche_36354' , 'laenderkueche_36355' , 'laenderkueche_43127' , 'laenderkueche_51124' , 'netto_fuellmenge_filter_3' , 'netto_fuellmenge_filter_4' , 'netto_fuellmenge_filter_8' , 'pastete_sorten_29718' , 'pastete_sorten_29726' , 'serie_54773' , 'teigwarenart_38803' , 'vendor_1048' , 'vendor_1064' , 'vendor_1112' , 'vendor_1125' , 'vendor_1138' , 'vendor_1147' , 'vendor_116' , 'vendor_1160' , 'vendor_1205' , 'vendor_1241' , 'vendor_1302' , 'vendor_1322' , 'vendor_140' , 'vendor_1406' , 'vendor_1412' , 'vendor_146' , 'vendor_1483' , 'vendor_1496' , 'vendor_152' , 'vendor_1582' , 'vendor_1591' , 'vendor_177' , 'vendor_192' , 'vendor_221' , 'vendor_227' , 'vendor_236' , 'vendor_309' , 'vendor_316' , 'vendor_348' , 'vendor_380' , 'vendor_383' , 'vendor_412' , 'vendor_424' , 'vendor_430' , 'vendor_432' , 'vendor_457' , 'vendor_467' , 'vendor_529' , 'vendor_637' , 'vendor_644' , 'vendor_664' , 'vendor_679' , 'vendor_752' , 'vendor_909' , 'vendor_910' , 'vendor_944' , 'vendor_952' , 'vendor_972' ) AND a . is_filterable = true ;
Copy