3
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 ('family_61' , 'hoehe_3085' , 'materialgruppierung_1535' , 'sparset_filter_0' , 'serie_53664' , 'form_2151' , 'modelname_30310' , 'modelname_53400' , 'modelname_53401' , 'modelname_53404' , 'modelname_53406' , 'modelname_53408' , 'modelname_53412' , 'modelname_53413' , 'modelname_53415' , 'modelname_53422' , 'modelname_53428' , 'modelname_53430' , 'modelname_53431' , 'modelname_53732' , 'modelname_53733' , 'modelname_53736' , 'modelname_53741' , 'modelname_53744' , 'modelname_53745' , 'modelname_53746' , 'modelname_53747' , 'modelname_54220' , 'modelname_54221' , 'modelname_54224' , 'modelname_54504' , 'modelname_54505' , 'modelname_54506' , 'modelname_54511' , 'modelname_54512' , 'modelname_54517' , 'modelname_54532' , 'modelname_54534' , 'modelname_55013' , 'modelname_55017' , 'modelname_55018' , 'modelname_55021' , 'modelname_55025' , 'modelname_55026' , 'modelname_55027' , 'modelname_55028' , 'modelname_55029' , 'modelname_55036' , 'modelname_55039' , 'modelname_55045' , 'modelname_55056' , 'modelname_55066' , 'modelname_55071' , 'modelname_55072' , 'modelname_55078' , 'modelname_55105' , 'modelname_55107' , 'modelname_55109' , 'modelname_55321' , 'modelname_55329' , 'modelname_55331' , 'modelname_55337' , 'modelname_55340' , 'modelname_55341' , 'modelname_55343' , 'modelname_55345' , 'modelname_55346' , 'modelname_55347' , 'modelname_55350' , 'modelname_55355' , 'modelname_55362' , 'modelname_55364' , 'modelname_55498' , 'modelname_55499' , 'modelname_55503' , 'modelname_55504' , 'modelname_55506' , 'modelname_55511' , 'modelname_55519' , 'modelname_55523' , 'modelname_55524' , 'modelname_55526' , 'modelname_55529' , 'modelname_55531' , 'modelname_55534' , 'modelname_55537' , 'modelname_55545' , 'modelname_55548' , 'modelname_55549' , 'modelname_55552' , 'modelname_55564' , 'modelname_55571' , 'modelname_55581' , 'modelname_55584' , 'modelname_55587' , 'modelname_55728' , 'modelname_55735' , 'modelname_55736' , 'modelname_55744' , 'modelname_55755' , 'modelname_55756' , 'modelname_55757' , 'modelname_55763' , 'modelname_55765' , 'modelname_55771' , 'modelname_55772' , 'serie_55565' , 'serie_55705' ) 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 (
'family_61' , 'hoehe_3085' , 'materialgruppierung_1535' ,
'sparset_filter_0' , 'serie_53664' ,
'form_2151' , 'modelname_30310' ,
'modelname_53400' , 'modelname_53401' ,
'modelname_53404' , 'modelname_53406' ,
'modelname_53408' , 'modelname_53412' ,
'modelname_53413' , 'modelname_53415' ,
'modelname_53422' , 'modelname_53428' ,
'modelname_53430' , 'modelname_53431' ,
'modelname_53732' , 'modelname_53733' ,
'modelname_53736' , 'modelname_53741' ,
'modelname_53744' , 'modelname_53745' ,
'modelname_53746' , 'modelname_53747' ,
'modelname_54220' , 'modelname_54221' ,
'modelname_54224' , 'modelname_54504' ,
'modelname_54505' , 'modelname_54506' ,
'modelname_54511' , 'modelname_54512' ,
'modelname_54517' , 'modelname_54532' ,
'modelname_54534' , 'modelname_55013' ,
'modelname_55017' , 'modelname_55018' ,
'modelname_55021' , 'modelname_55025' ,
'modelname_55026' , 'modelname_55027' ,
'modelname_55028' , 'modelname_55029' ,
'modelname_55036' , 'modelname_55039' ,
'modelname_55045' , 'modelname_55056' ,
'modelname_55066' , 'modelname_55071' ,
'modelname_55072' , 'modelname_55078' ,
'modelname_55105' , 'modelname_55107' ,
'modelname_55109' , 'modelname_55321' ,
'modelname_55329' , 'modelname_55331' ,
'modelname_55337' , 'modelname_55340' ,
'modelname_55341' , 'modelname_55343' ,
'modelname_55345' , 'modelname_55346' ,
'modelname_55347' , 'modelname_55350' ,
'modelname_55355' , 'modelname_55362' ,
'modelname_55364' , 'modelname_55498' ,
'modelname_55499' , 'modelname_55503' ,
'modelname_55504' , 'modelname_55506' ,
'modelname_55511' , 'modelname_55519' ,
'modelname_55523' , 'modelname_55524' ,
'modelname_55526' , 'modelname_55529' ,
'modelname_55531' , 'modelname_55534' ,
'modelname_55537' , 'modelname_55545' ,
'modelname_55548' , 'modelname_55549' ,
'modelname_55552' , 'modelname_55564' ,
'modelname_55571' , 'modelname_55581' ,
'modelname_55584' , 'modelname_55587' ,
'modelname_55728' , 'modelname_55735' ,
'modelname_55736' , 'modelname_55744' ,
'modelname_55755' , 'modelname_55756' ,
'modelname_55757' , 'modelname_55763' ,
'modelname_55765' , 'modelname_55771' ,
'modelname_55772' , 'serie_55565' ,
'serie_55705'
)
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 ('family_61' , 'hoehe_3085' , 'materialgruppierung_1535' , 'sparset_filter_0' , 'serie_53664' , 'form_2151' , 'modelname_30310' , 'modelname_53400' , 'modelname_53401' , 'modelname_53404' , 'modelname_53406' , 'modelname_53408' , 'modelname_53412' , 'modelname_53413' , 'modelname_53415' , 'modelname_53422' , 'modelname_53428' , 'modelname_53430' , 'modelname_53431' , 'modelname_53732' , 'modelname_53733' , 'modelname_53736' , 'modelname_53741' , 'modelname_53744' , 'modelname_53745' , 'modelname_53746' , 'modelname_53747' , 'modelname_54220' , 'modelname_54221' , 'modelname_54224' , 'modelname_54504' , 'modelname_54505' , 'modelname_54506' , 'modelname_54511' , 'modelname_54512' , 'modelname_54517' , 'modelname_54532' , 'modelname_54534' , 'modelname_55013' , 'modelname_55017' , 'modelname_55018' , 'modelname_55021' , 'modelname_55025' , 'modelname_55026' , 'modelname_55027' , 'modelname_55028' , 'modelname_55029' , 'modelname_55036' , 'modelname_55039' , 'modelname_55045' , 'modelname_55056' , 'modelname_55066' , 'modelname_55071' , 'modelname_55072' , 'modelname_55078' , 'modelname_55105' , 'modelname_55107' , 'modelname_55109' , 'modelname_55321' , 'modelname_55329' , 'modelname_55331' , 'modelname_55337' , 'modelname_55340' , 'modelname_55341' , 'modelname_55343' , 'modelname_55345' , 'modelname_55346' , 'modelname_55347' , 'modelname_55350' , 'modelname_55355' , 'modelname_55362' , 'modelname_55364' , 'modelname_55498' , 'modelname_55499' , 'modelname_55503' , 'modelname_55504' , 'modelname_55506' , 'modelname_55511' , 'modelname_55519' , 'modelname_55523' , 'modelname_55524' , 'modelname_55526' , 'modelname_55529' , 'modelname_55531' , 'modelname_55534' , 'modelname_55537' , 'modelname_55545' , 'modelname_55548' , 'modelname_55549' , 'modelname_55552' , 'modelname_55564' , 'modelname_55571' , 'modelname_55581' , 'modelname_55584' , 'modelname_55587' , 'modelname_55728' , 'modelname_55735' , 'modelname_55736' , 'modelname_55744' , 'modelname_55755' , 'modelname_55756' , 'modelname_55757' , 'modelname_55763' , 'modelname_55765' , 'modelname_55771' , 'modelname_55772' , 'serie_55565' , 'serie_55705' ) AND a . is_filterable = true ;
Copy