7
0.18 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' , 'family_376' , 'verpackung_2954' , 'handelsform_3535' , 'netto_gewicht_filter_3' , 'netto_gewicht_filter_2' , 'sorte_3536' , 'handelsform_3534' , 'netto_gewicht_filter_1' , 'sorte_26188' , 'family_1073' , 'typ_36792' , 'sorte_15484' , 'family_589' , 'handelsform_5934' , 'verpackung_4003' , 'verpackung_2870' , 'netto_gewicht_filter_4' , 'vendor_1258' , 'art_2163' , 'vendor_482' , 'verpackung_5933' , 'vendor_1135' , 'vendor_1016' , 'verpackung_4205' , 'handelsform_27113' , 'verpackung_35918' , 'netto_gewicht_filter_5' , 'handelsform_5911' , 'vendor_186' , 'family_629' , 'geschmack_24694' , 'family_699' , 'family_886' , 'feiertage_960' , 'netto_gewicht_filter_6' , 'sorte_51687' , 'vendor_486' , 'aroma_7551' , 'vendor_1031' , 'vendor_553' , 'verpackung_3948' , 'anwendungszeit_2288' , 'art_53069' , 'family_418' , 'feiertage_1130' , 'feiertage_819' , 'geschmack_23753' , 'geschmack_23757' , 'vendor_171' , 'vendor_192' , 'geschmack_23765' , 'geschmack_39591' , 'verpackung_3154' , 'anzahl_der_artikel_2679' , 'aroma_3546' , 'geschmack_26612' , 'vendor_1133' , 'vendor_414' , 'vendor_552' , 'vendor_743' , 'vendor_991' , 'verpackung_9455' , 'volumen_2424' , 'geschmack_52741' , 'netto_fuellmenge_filter_3' , 'sorte_45806' , 'vendor_1104' , 'vendor_1422' , 'vendor_772' , 'verpackung_26798' , 'aroma_55191' , 'art_52277' , 'vendor_1289' , 'vendor_1297' , 'vendor_1394' , 'vendor_1483' , 'vendor_1593' , 'vendor_274' , 'vendor_554' , 'verpackung_45261' , 'verpackung_6308' , 'volumen_1460' , 'aroma_4227' , 'art_33908' , 'vendor_1606' , 'vendor_316' , 'verwendungszweck_2256' , 'verwendungszweck_4215' , 'aroma_23887' , 'aroma_26886' , 'aroma_4975' , 'aroma_4976' , 'geschmack_23749' , 'vendor_114' , 'anwendungszeit_9771' , 'aroma_13957' , 'aroma_3539' , 'art_30632' , 'art_30649' , 'vendor_1018' , 'vendor_1302' , 'vendor_1309' , 'vendor_1319' , 'vendor_1624' , 'vendor_166' , 'vendor_225' , 'vendor_744' , 'verpackung_31703' , 'verpackung_38799' , 'verwendungszweck_2240' , 'verwendungszweck_34164' , 'anzahl_der_artikel_2680' , 'aroma_11395' , 'aroma_13964' , 'aroma_17795' , 'aroma_39184' , 'aroma_39201' , 'art_30630' , 'art_30684' , 'art_54105' , 'feiertage_820' , 'geschmack_23754' , 'geschmack_24687' , 'geschmack_31753' , 'geschmack_32270' , 'netto_fuellmenge_filter_4' , 'netto_fuellmenge_filter_5' , 'sorte_19469' , 'vendor_1347' , 'vendor_1440' , 'vendor_438' , 'vendor_551' , 'vendor_745' , 'verpackung_24689' , 'volumen_der_tasse_40912' , 'aroma_13960' , 'aroma_17796' , 'aroma_23893' , 'aroma_30995' , 'aroma_53980' , 'aroma_6917' , 'art_30648' , 'art_30689' , 'art_30692' , 'art_38567' , 'art_41081' , 'art_41586' , 'family_1055' , 'feiertage_825' , 'feiertage_826' , 'geschmack_23755' , 'geschmack_23756' , 'geschmack_23763' , 'handelsform_35601' , 'netto_fuellmenge_filter_6' , 'typ_35555' , 'typ_54760' , 'vendor_1091' , 'vendor_1112' , 'vendor_1138' , 'vendor_1213' , 'vendor_1252' , 'vendor_1299' , 'vendor_1325' , 'vendor_1354' , 'vendor_1441' , 'vendor_1461' , 'vendor_1617' , 'vendor_1620' , 'vendor_187' , 'vendor_256' , 'vendor_291' , 'vendor_785' , 'verpackung_3840' , 'verpackung_39173' , 'verwendungszweck_32164' , 'verwendungszweck_6231' , 'verwendungszweck_6232' , 'verwendungszweck_6536' , 'verwendungszweck_6814' , 'verwendungszweck_6827' , 'verwendungszweck_7976' , 'volumen_7546' ) 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' ,
'family_376' ,
'verpackung_2954' ,
'handelsform_3535' ,
'netto_gewicht_filter_3' ,
'netto_gewicht_filter_2' ,
'sorte_3536' ,
'handelsform_3534' ,
'netto_gewicht_filter_1' ,
'sorte_26188' ,
'family_1073' ,
'typ_36792' ,
'sorte_15484' ,
'family_589' ,
'handelsform_5934' ,
'verpackung_4003' ,
'verpackung_2870' ,
'netto_gewicht_filter_4' ,
'vendor_1258' ,
'art_2163' ,
'vendor_482' ,
'verpackung_5933' ,
'vendor_1135' ,
'vendor_1016' ,
'verpackung_4205' ,
'handelsform_27113' ,
'verpackung_35918' ,
'netto_gewicht_filter_5' ,
'handelsform_5911' ,
'vendor_186' ,
'family_629' ,
'geschmack_24694' ,
'family_699' ,
'family_886' ,
'feiertage_960' ,
'netto_gewicht_filter_6' ,
'sorte_51687' ,
'vendor_486' ,
'aroma_7551' ,
'vendor_1031' ,
'vendor_553' ,
'verpackung_3948' ,
'anwendungszeit_2288' ,
'art_53069' ,
'family_418' ,
'feiertage_1130' ,
'feiertage_819' ,
'geschmack_23753' ,
'geschmack_23757' ,
'vendor_171' ,
'vendor_192' ,
'geschmack_23765' ,
'geschmack_39591' ,
'verpackung_3154' ,
'anzahl_der_artikel_2679' ,
'aroma_3546' ,
'geschmack_26612' ,
'vendor_1133' ,
'vendor_414' ,
'vendor_552' ,
'vendor_743' ,
'vendor_991' ,
'verpackung_9455' ,
'volumen_2424' ,
'geschmack_52741' ,
'netto_fuellmenge_filter_3' ,
'sorte_45806' ,
'vendor_1104' ,
'vendor_1422' ,
'vendor_772' ,
'verpackung_26798' ,
'aroma_55191' ,
'art_52277' ,
'vendor_1289' ,
'vendor_1297' ,
'vendor_1394' ,
'vendor_1483' ,
'vendor_1593' ,
'vendor_274' ,
'vendor_554' ,
'verpackung_45261' ,
'verpackung_6308' ,
'volumen_1460' ,
'aroma_4227' ,
'art_33908' ,
'vendor_1606' ,
'vendor_316' ,
'verwendungszweck_2256' ,
'verwendungszweck_4215' ,
'aroma_23887' ,
'aroma_26886' ,
'aroma_4975' ,
'aroma_4976' ,
'geschmack_23749' ,
'vendor_114' ,
'anwendungszeit_9771' ,
'aroma_13957' ,
'aroma_3539' ,
'art_30632' ,
'art_30649' ,
'vendor_1018' ,
'vendor_1302' ,
'vendor_1309' ,
'vendor_1319' ,
'vendor_1624' ,
'vendor_166' ,
'vendor_225' ,
'vendor_744' ,
'verpackung_31703' ,
'verpackung_38799' ,
'verwendungszweck_2240' ,
'verwendungszweck_34164' ,
'anzahl_der_artikel_2680' ,
'aroma_11395' ,
'aroma_13964' ,
'aroma_17795' ,
'aroma_39184' ,
'aroma_39201' ,
'art_30630' ,
'art_30684' ,
'art_54105' ,
'feiertage_820' ,
'geschmack_23754' ,
'geschmack_24687' ,
'geschmack_31753' ,
'geschmack_32270' ,
'netto_fuellmenge_filter_4' ,
'netto_fuellmenge_filter_5' ,
'sorte_19469' ,
'vendor_1347' ,
'vendor_1440' ,
'vendor_438' ,
'vendor_551' ,
'vendor_745' ,
'verpackung_24689' ,
'volumen_der_tasse_40912' ,
'aroma_13960' ,
'aroma_17796' ,
'aroma_23893' ,
'aroma_30995' ,
'aroma_53980' ,
'aroma_6917' ,
'art_30648' ,
'art_30689' ,
'art_30692' ,
'art_38567' ,
'art_41081' ,
'art_41586' ,
'family_1055' ,
'feiertage_825' ,
'feiertage_826' ,
'geschmack_23755' ,
'geschmack_23756' ,
'geschmack_23763' ,
'handelsform_35601' ,
'netto_fuellmenge_filter_6' ,
'typ_35555' ,
'typ_54760' ,
'vendor_1091' ,
'vendor_1112' ,
'vendor_1138' ,
'vendor_1213' ,
'vendor_1252' ,
'vendor_1299' ,
'vendor_1325' ,
'vendor_1354' ,
'vendor_1441' ,
'vendor_1461' ,
'vendor_1617' ,
'vendor_1620' ,
'vendor_187' ,
'vendor_256' ,
'vendor_291' ,
'vendor_785' ,
'verpackung_3840' ,
'verpackung_39173' ,
'verwendungszweck_32164' ,
'verwendungszweck_6231' ,
'verwendungszweck_6232' ,
'verwendungszweck_6536' ,
'verwendungszweck_6814' ,
'verwendungszweck_6827' ,
'verwendungszweck_7976' ,
'volumen_7546'
)
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' , 'family_376' , 'verpackung_2954' , 'handelsform_3535' , 'netto_gewicht_filter_3' , 'netto_gewicht_filter_2' , 'sorte_3536' , 'handelsform_3534' , 'netto_gewicht_filter_1' , 'sorte_26188' , 'family_1073' , 'typ_36792' , 'sorte_15484' , 'family_589' , 'handelsform_5934' , 'verpackung_4003' , 'verpackung_2870' , 'netto_gewicht_filter_4' , 'vendor_1258' , 'art_2163' , 'vendor_482' , 'verpackung_5933' , 'vendor_1135' , 'vendor_1016' , 'verpackung_4205' , 'handelsform_27113' , 'verpackung_35918' , 'netto_gewicht_filter_5' , 'handelsform_5911' , 'vendor_186' , 'family_629' , 'geschmack_24694' , 'family_699' , 'family_886' , 'feiertage_960' , 'netto_gewicht_filter_6' , 'sorte_51687' , 'vendor_486' , 'aroma_7551' , 'vendor_1031' , 'vendor_553' , 'verpackung_3948' , 'anwendungszeit_2288' , 'art_53069' , 'family_418' , 'feiertage_1130' , 'feiertage_819' , 'geschmack_23753' , 'geschmack_23757' , 'vendor_171' , 'vendor_192' , 'geschmack_23765' , 'geschmack_39591' , 'verpackung_3154' , 'anzahl_der_artikel_2679' , 'aroma_3546' , 'geschmack_26612' , 'vendor_1133' , 'vendor_414' , 'vendor_552' , 'vendor_743' , 'vendor_991' , 'verpackung_9455' , 'volumen_2424' , 'geschmack_52741' , 'netto_fuellmenge_filter_3' , 'sorte_45806' , 'vendor_1104' , 'vendor_1422' , 'vendor_772' , 'verpackung_26798' , 'aroma_55191' , 'art_52277' , 'vendor_1289' , 'vendor_1297' , 'vendor_1394' , 'vendor_1483' , 'vendor_1593' , 'vendor_274' , 'vendor_554' , 'verpackung_45261' , 'verpackung_6308' , 'volumen_1460' , 'aroma_4227' , 'art_33908' , 'vendor_1606' , 'vendor_316' , 'verwendungszweck_2256' , 'verwendungszweck_4215' , 'aroma_23887' , 'aroma_26886' , 'aroma_4975' , 'aroma_4976' , 'geschmack_23749' , 'vendor_114' , 'anwendungszeit_9771' , 'aroma_13957' , 'aroma_3539' , 'art_30632' , 'art_30649' , 'vendor_1018' , 'vendor_1302' , 'vendor_1309' , 'vendor_1319' , 'vendor_1624' , 'vendor_166' , 'vendor_225' , 'vendor_744' , 'verpackung_31703' , 'verpackung_38799' , 'verwendungszweck_2240' , 'verwendungszweck_34164' , 'anzahl_der_artikel_2680' , 'aroma_11395' , 'aroma_13964' , 'aroma_17795' , 'aroma_39184' , 'aroma_39201' , 'art_30630' , 'art_30684' , 'art_54105' , 'feiertage_820' , 'geschmack_23754' , 'geschmack_24687' , 'geschmack_31753' , 'geschmack_32270' , 'netto_fuellmenge_filter_4' , 'netto_fuellmenge_filter_5' , 'sorte_19469' , 'vendor_1347' , 'vendor_1440' , 'vendor_438' , 'vendor_551' , 'vendor_745' , 'verpackung_24689' , 'volumen_der_tasse_40912' , 'aroma_13960' , 'aroma_17796' , 'aroma_23893' , 'aroma_30995' , 'aroma_53980' , 'aroma_6917' , 'art_30648' , 'art_30689' , 'art_30692' , 'art_38567' , 'art_41081' , 'art_41586' , 'family_1055' , 'feiertage_825' , 'feiertage_826' , 'geschmack_23755' , 'geschmack_23756' , 'geschmack_23763' , 'handelsform_35601' , 'netto_fuellmenge_filter_6' , 'typ_35555' , 'typ_54760' , 'vendor_1091' , 'vendor_1112' , 'vendor_1138' , 'vendor_1213' , 'vendor_1252' , 'vendor_1299' , 'vendor_1325' , 'vendor_1354' , 'vendor_1441' , 'vendor_1461' , 'vendor_1617' , 'vendor_1620' , 'vendor_187' , 'vendor_256' , 'vendor_291' , 'vendor_785' , 'verpackung_3840' , 'verpackung_39173' , 'verwendungszweck_32164' , 'verwendungszweck_6231' , 'verwendungszweck_6232' , 'verwendungszweck_6536' , 'verwendungszweck_6814' , 'verwendungszweck_6827' , 'verwendungszweck_7976' , 'volumen_7546' ) AND a . is_filterable = true ;
Copy