3
0.23 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 ('handelsform_3534' , 'verpackung_2954' , 'family_281' , 'netto_gewicht_filter_1' , 'coolbox_filter_0' , 'freezebox_filter_3' , 'family_376' , 'vendor_900' , 'netto_gewicht_filter_2' , 'sorte_26188' , 'netto_gewicht_filter_3' , 'handelsform_3535' , 'vendor_745' , 'verpackung_2870' , 'vendor_1135' , 'serie_37942' , 'verwendungszweck_4520' , 'vendor_1016' , 'sorte_15484' , 'netto_gewicht_filter_4' , 'verwendungszweck_135' , 'vendor_414' , 'family_886' , 'art_52277' , 'vendor_1394' , 'verpackung_45261' , 'aroma_3546' , 'art_30642' , 'art_30644' , 'art_30645' , 'art_30648' , 'art_30663' , 'art_30672' , 'vendor_1133' , 'vendor_474' , 'verwendungszweck_4215' , 'art_2163' , 'art_30636' , 'art_30641' , 'art_30649' , 'art_30650' , 'art_30681' , 'art_30687' , 'art_53064' , 'vendor_743' , 'verpackung_4003' , 'verwendungszweck_152' , 'verwendungszweck_2240' , 'verwendungszweck_6814' , 'art_30630' , 'art_30684' , 'art_54105' , 'family_1075' , 'vendor_1624' , 'vendor_744' , 'verwendungszweck_2258' , 'verwendungszweck_2259' , 'art_30632' , 'art_30634' , 'art_30651' , 'art_38567' , 'art_41081' , 'family_926' , 'vendor_386' , 'verwendungszweck_6536' , 'verwendungszweck_9715' , 'aroma_3539' , 'art_30633' , 'art_30635' , 'art_30643' , 'art_30646' , 'art_30647' , 'art_30652' , 'art_30654' , 'art_30656' , 'art_30657' , 'art_30659' , 'art_30661' , 'art_30662' , 'art_30666' , 'art_30668' , 'art_30669' , 'art_30671' , 'art_30673' , 'art_30680' , 'art_30682' , 'art_30688' , 'art_30689' , 'art_30693' , 'art_45780' , 'art_52272' , 'art_52274' , 'art_52275' , 'art_52276' , 'art_52280' , 'art_56138' , 'art_56844' , 'art_57404' , 'family_699' , 'handelsform_35601' , 'netto_gewicht_filter_6' , 'sorte_45806' , 'typ_54760' , 'vendor_1091' , 'vendor_1137' , 'vendor_1140' , 'vendor_1252' , 'vendor_159' , 'vendor_49' , 'verpackung_30361' , 'verpackung_5933' , 'verwendungszweck_17634' , 'verwendungszweck_2256' , 'verwendungszweck_34164' , 'verwendungszweck_34170' , 'verwendungszweck_6537' , 'verwendungszweck_7976' , 'verwendungszweck_8025' ) 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 (
'handelsform_3534' , 'verpackung_2954' ,
'family_281' , 'netto_gewicht_filter_1' ,
'coolbox_filter_0' , 'freezebox_filter_3' ,
'family_376' , 'vendor_900' , 'netto_gewicht_filter_2' ,
'sorte_26188' , 'netto_gewicht_filter_3' ,
'handelsform_3535' , 'vendor_745' ,
'verpackung_2870' , 'vendor_1135' ,
'serie_37942' , 'verwendungszweck_4520' ,
'vendor_1016' , 'sorte_15484' , 'netto_gewicht_filter_4' ,
'verwendungszweck_135' , 'vendor_414' ,
'family_886' , 'art_52277' , 'vendor_1394' ,
'verpackung_45261' , 'aroma_3546' ,
'art_30642' , 'art_30644' , 'art_30645' ,
'art_30648' , 'art_30663' , 'art_30672' ,
'vendor_1133' , 'vendor_474' , 'verwendungszweck_4215' ,
'art_2163' , 'art_30636' , 'art_30641' ,
'art_30649' , 'art_30650' , 'art_30681' ,
'art_30687' , 'art_53064' , 'vendor_743' ,
'verpackung_4003' , 'verwendungszweck_152' ,
'verwendungszweck_2240' , 'verwendungszweck_6814' ,
'art_30630' , 'art_30684' , 'art_54105' ,
'family_1075' , 'vendor_1624' , 'vendor_744' ,
'verwendungszweck_2258' , 'verwendungszweck_2259' ,
'art_30632' , 'art_30634' , 'art_30651' ,
'art_38567' , 'art_41081' , 'family_926' ,
'vendor_386' , 'verwendungszweck_6536' ,
'verwendungszweck_9715' , 'aroma_3539' ,
'art_30633' , 'art_30635' , 'art_30643' ,
'art_30646' , 'art_30647' , 'art_30652' ,
'art_30654' , 'art_30656' , 'art_30657' ,
'art_30659' , 'art_30661' , 'art_30662' ,
'art_30666' , 'art_30668' , 'art_30669' ,
'art_30671' , 'art_30673' , 'art_30680' ,
'art_30682' , 'art_30688' , 'art_30689' ,
'art_30693' , 'art_45780' , 'art_52272' ,
'art_52274' , 'art_52275' , 'art_52276' ,
'art_52280' , 'art_56138' , 'art_56844' ,
'art_57404' , 'family_699' , 'handelsform_35601' ,
'netto_gewicht_filter_6' , 'sorte_45806' ,
'typ_54760' , 'vendor_1091' , 'vendor_1137' ,
'vendor_1140' , 'vendor_1252' , 'vendor_159' ,
'vendor_49' , 'verpackung_30361' ,
'verpackung_5933' , 'verwendungszweck_17634' ,
'verwendungszweck_2256' , 'verwendungszweck_34164' ,
'verwendungszweck_34170' , 'verwendungszweck_6537' ,
'verwendungszweck_7976' , 'verwendungszweck_8025'
)
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 ('handelsform_3534' , 'verpackung_2954' , 'family_281' , 'netto_gewicht_filter_1' , 'coolbox_filter_0' , 'freezebox_filter_3' , 'family_376' , 'vendor_900' , 'netto_gewicht_filter_2' , 'sorte_26188' , 'netto_gewicht_filter_3' , 'handelsform_3535' , 'vendor_745' , 'verpackung_2870' , 'vendor_1135' , 'serie_37942' , 'verwendungszweck_4520' , 'vendor_1016' , 'sorte_15484' , 'netto_gewicht_filter_4' , 'verwendungszweck_135' , 'vendor_414' , 'family_886' , 'art_52277' , 'vendor_1394' , 'verpackung_45261' , 'aroma_3546' , 'art_30642' , 'art_30644' , 'art_30645' , 'art_30648' , 'art_30663' , 'art_30672' , 'vendor_1133' , 'vendor_474' , 'verwendungszweck_4215' , 'art_2163' , 'art_30636' , 'art_30641' , 'art_30649' , 'art_30650' , 'art_30681' , 'art_30687' , 'art_53064' , 'vendor_743' , 'verpackung_4003' , 'verwendungszweck_152' , 'verwendungszweck_2240' , 'verwendungszweck_6814' , 'art_30630' , 'art_30684' , 'art_54105' , 'family_1075' , 'vendor_1624' , 'vendor_744' , 'verwendungszweck_2258' , 'verwendungszweck_2259' , 'art_30632' , 'art_30634' , 'art_30651' , 'art_38567' , 'art_41081' , 'family_926' , 'vendor_386' , 'verwendungszweck_6536' , 'verwendungszweck_9715' , 'aroma_3539' , 'art_30633' , 'art_30635' , 'art_30643' , 'art_30646' , 'art_30647' , 'art_30652' , 'art_30654' , 'art_30656' , 'art_30657' , 'art_30659' , 'art_30661' , 'art_30662' , 'art_30666' , 'art_30668' , 'art_30669' , 'art_30671' , 'art_30673' , 'art_30680' , 'art_30682' , 'art_30688' , 'art_30689' , 'art_30693' , 'art_45780' , 'art_52272' , 'art_52274' , 'art_52275' , 'art_52276' , 'art_52280' , 'art_56138' , 'art_56844' , 'art_57404' , 'family_699' , 'handelsform_35601' , 'netto_gewicht_filter_6' , 'sorte_45806' , 'typ_54760' , 'vendor_1091' , 'vendor_1137' , 'vendor_1140' , 'vendor_1252' , 'vendor_159' , 'vendor_49' , 'verpackung_30361' , 'verpackung_5933' , 'verwendungszweck_17634' , 'verwendungszweck_2256' , 'verwendungszweck_34164' , 'verwendungszweck_34170' , 'verwendungszweck_6537' , 'verwendungszweck_7976' , 'verwendungszweck_8025' ) AND a . is_filterable = true ;
Copy