3
0.14 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_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_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_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_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_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_55763' , 'modelname_55765' , 'modelname_55771' , 'modelname_55772' , 'serie_55565' , 'serie_55705' ) AND a . is_filterable = true ;
Copy