3
0.92 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 ('coolbox_filter_0' , 'freezebox_filter_3' , 'art_2163' , 'netto_gewicht_filter_6' , 'verpackung_36357' , 'verpackung_3840' , 'fleischart_15470' , 'vendor_386' , 'family_683' , 'fleischart_47539' , 'netto_gewicht_filter_4' , 'family_920' , 'fleischart_15474' , 'netto_gewicht_filter_5' , 'art_30399' , 'art_51799' , 'family_684' , 'family_685' , 'family_935' , 'getreideart_15473' , 'getreideart_23671' , 'getreideart_23707' , 'verpackung_4205' , 'family_1026' , 'fettanteil_52859' , 'fischart_29659' , 'fischart_35526' , 'fleischart_47119' , 'pastete_sorten_29724' , 'vendor_404' , 'vendor_531' , 'art_51800' , 'fischart_52914' , 'fleischart_54883' , 'fleischart_54889' , 'laenderkueche_36352' , 'netto_gewicht_filter_7' , 'pastete_sorten_29718' , 'pastete_sorten_29725' , 'serie_55241' , 'vendor_1372' , 'vendor_1374' , 'vendor_1380' , 'vendor_151' , 'vendor_224' , 'vendor_227' , 'vendor_637' , 'vendor_944' , 'verpackung_3121' , 'verpackung_3948' ) 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' ,
'art_2163' , 'netto_gewicht_filter_6' ,
'verpackung_36357' , 'verpackung_3840' ,
'fleischart_15470' , 'vendor_386' ,
'family_683' , 'fleischart_47539' ,
'netto_gewicht_filter_4' , 'family_920' ,
'fleischart_15474' , 'netto_gewicht_filter_5' ,
'art_30399' , 'art_51799' , 'family_684' ,
'family_685' , 'family_935' , 'getreideart_15473' ,
'getreideart_23671' , 'getreideart_23707' ,
'verpackung_4205' , 'family_1026' ,
'fettanteil_52859' , 'fischart_29659' ,
'fischart_35526' , 'fleischart_47119' ,
'pastete_sorten_29724' , 'vendor_404' ,
'vendor_531' , 'art_51800' , 'fischart_52914' ,
'fleischart_54883' , 'fleischart_54889' ,
'laenderkueche_36352' , 'netto_gewicht_filter_7' ,
'pastete_sorten_29718' , 'pastete_sorten_29725' ,
'serie_55241' , 'vendor_1372' , 'vendor_1374' ,
'vendor_1380' , 'vendor_151' , 'vendor_224' ,
'vendor_227' , 'vendor_637' , 'vendor_944' ,
'verpackung_3121' , 'verpackung_3948'
)
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' , 'art_2163' , 'netto_gewicht_filter_6' , 'verpackung_36357' , 'verpackung_3840' , 'fleischart_15470' , 'vendor_386' , 'family_683' , 'fleischart_47539' , 'netto_gewicht_filter_4' , 'family_920' , 'fleischart_15474' , 'netto_gewicht_filter_5' , 'art_30399' , 'art_51799' , 'family_684' , 'family_685' , 'family_935' , 'getreideart_15473' , 'getreideart_23671' , 'getreideart_23707' , 'verpackung_4205' , 'family_1026' , 'fettanteil_52859' , 'fischart_29659' , 'fischart_35526' , 'fleischart_47119' , 'pastete_sorten_29724' , 'vendor_404' , 'vendor_531' , 'art_51800' , 'fischart_52914' , 'fleischart_54883' , 'fleischart_54889' , 'laenderkueche_36352' , 'netto_gewicht_filter_7' , 'pastete_sorten_29718' , 'pastete_sorten_29725' , 'serie_55241' , 'vendor_1372' , 'vendor_1374' , 'vendor_1380' , 'vendor_151' , 'vendor_224' , 'vendor_227' , 'vendor_637' , 'vendor_944' , 'verpackung_3121' , 'verpackung_3948' ) AND a . is_filterable = true ;
Copy