3
0.17 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' , 'muster_473' , 'beschriftungssprache_25379' , 'muster_474' , 'serie_37737' , 'serie_55705' , 'form_2151' , 'inschrift_22366' , 'modelname_22803' , 'modelname_24034' , 'modelname_24744' , 'modelname_25152' , 'modelname_25364' , 'modelname_26466' , 'modelname_30310' , 'modelname_34287' , 'modelname_36719' , 'modelname_37713' , 'modelname_37745' , 'modelname_37747' , 'modelname_38189' , 'modelname_38194' , 'modelname_38195' , 'modelname_42679' , 'modelname_44174' , 'modelname_50806' , 'modelname_52072' , 'modelname_53400' , 'modelname_53401' , 'modelname_53404' , 'modelname_53406' , 'modelname_53408' , 'modelname_53412' , 'modelname_53413' , 'modelname_53415' , 'modelname_53744' , 'modelname_53745' , 'modelname_53746' , 'modelname_53747' , 'modelname_54220' , 'modelname_54221' , 'modelname_54504' , 'modelname_54505' , 'modelname_54506' , 'modelname_54511' , 'modelname_54512' , 'modelname_54517' , 'modelname_55013' , 'modelname_55045' , 'modelname_55056' , 'modelname_55066' , 'modelname_55071' , 'modelname_55072' , 'modelname_55078' , 'modelname_55105' , 'modelname_55107' , 'modelname_55310' , 'modelname_55331' , 'modelname_55337' , 'modelname_55340' , 'modelname_55341' , 'modelname_55343' , 'modelname_55345' , 'modelname_55346' , 'modelname_55347' , 'modelname_55350' , 'modelname_55498' , 'modelname_55503' , 'modelname_55504' , 'modelname_55511' , 'modelname_55519' , 'modelname_55523' , 'modelname_55524' , 'modelname_55529' , 'modelname_55531' , 'modelname_55537' , 'modelname_55545' , 'modelname_55549' , 'modelname_55552' , 'modelname_55564' , 'modelname_55571' , 'modelname_55576' , 'modelname_55581' , 'modelname_55584' , 'modelname_55587' , 'modelname_55735' , 'modelname_55736' , 'modelname_55744' , 'modelname_55755' , 'modelname_55756' , 'modelname_55757' , 'modelname_55765' , 'modelname_55950' , 'modelname_56285' , 'muster_475' , 'serie_36316' , 'serie_37711' , 'serie_51454' , 'serie_51455' , 'serie_51456' , 'serie_55565' , 'stil_4873' ) 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' ,
'muster_473' , 'beschriftungssprache_25379' ,
'muster_474' , 'serie_37737' , 'serie_55705' ,
'form_2151' , 'inschrift_22366' ,
'modelname_22803' , 'modelname_24034' ,
'modelname_24744' , 'modelname_25152' ,
'modelname_25364' , 'modelname_26466' ,
'modelname_30310' , 'modelname_34287' ,
'modelname_36719' , 'modelname_37713' ,
'modelname_37745' , 'modelname_37747' ,
'modelname_38189' , 'modelname_38194' ,
'modelname_38195' , 'modelname_42679' ,
'modelname_44174' , 'modelname_50806' ,
'modelname_52072' , 'modelname_53400' ,
'modelname_53401' , 'modelname_53404' ,
'modelname_53406' , 'modelname_53408' ,
'modelname_53412' , 'modelname_53413' ,
'modelname_53415' , 'modelname_53744' ,
'modelname_53745' , 'modelname_53746' ,
'modelname_53747' , 'modelname_54220' ,
'modelname_54221' , 'modelname_54504' ,
'modelname_54505' , 'modelname_54506' ,
'modelname_54511' , 'modelname_54512' ,
'modelname_54517' , 'modelname_55013' ,
'modelname_55045' , 'modelname_55056' ,
'modelname_55066' , 'modelname_55071' ,
'modelname_55072' , 'modelname_55078' ,
'modelname_55105' , 'modelname_55107' ,
'modelname_55310' , 'modelname_55331' ,
'modelname_55337' , 'modelname_55340' ,
'modelname_55341' , 'modelname_55343' ,
'modelname_55345' , 'modelname_55346' ,
'modelname_55347' , 'modelname_55350' ,
'modelname_55498' , 'modelname_55503' ,
'modelname_55504' , 'modelname_55511' ,
'modelname_55519' , 'modelname_55523' ,
'modelname_55524' , 'modelname_55529' ,
'modelname_55531' , 'modelname_55537' ,
'modelname_55545' , 'modelname_55549' ,
'modelname_55552' , 'modelname_55564' ,
'modelname_55571' , 'modelname_55576' ,
'modelname_55581' , 'modelname_55584' ,
'modelname_55587' , 'modelname_55735' ,
'modelname_55736' , 'modelname_55744' ,
'modelname_55755' , 'modelname_55756' ,
'modelname_55757' , 'modelname_55765' ,
'modelname_55950' , 'modelname_56285' ,
'muster_475' , 'serie_36316' , 'serie_37711' ,
'serie_51454' , 'serie_51455' , 'serie_51456' ,
'serie_55565' , 'stil_4873'
)
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' , 'muster_473' , 'beschriftungssprache_25379' , 'muster_474' , 'serie_37737' , 'serie_55705' , 'form_2151' , 'inschrift_22366' , 'modelname_22803' , 'modelname_24034' , 'modelname_24744' , 'modelname_25152' , 'modelname_25364' , 'modelname_26466' , 'modelname_30310' , 'modelname_34287' , 'modelname_36719' , 'modelname_37713' , 'modelname_37745' , 'modelname_37747' , 'modelname_38189' , 'modelname_38194' , 'modelname_38195' , 'modelname_42679' , 'modelname_44174' , 'modelname_50806' , 'modelname_52072' , 'modelname_53400' , 'modelname_53401' , 'modelname_53404' , 'modelname_53406' , 'modelname_53408' , 'modelname_53412' , 'modelname_53413' , 'modelname_53415' , 'modelname_53744' , 'modelname_53745' , 'modelname_53746' , 'modelname_53747' , 'modelname_54220' , 'modelname_54221' , 'modelname_54504' , 'modelname_54505' , 'modelname_54506' , 'modelname_54511' , 'modelname_54512' , 'modelname_54517' , 'modelname_55013' , 'modelname_55045' , 'modelname_55056' , 'modelname_55066' , 'modelname_55071' , 'modelname_55072' , 'modelname_55078' , 'modelname_55105' , 'modelname_55107' , 'modelname_55310' , 'modelname_55331' , 'modelname_55337' , 'modelname_55340' , 'modelname_55341' , 'modelname_55343' , 'modelname_55345' , 'modelname_55346' , 'modelname_55347' , 'modelname_55350' , 'modelname_55498' , 'modelname_55503' , 'modelname_55504' , 'modelname_55511' , 'modelname_55519' , 'modelname_55523' , 'modelname_55524' , 'modelname_55529' , 'modelname_55531' , 'modelname_55537' , 'modelname_55545' , 'modelname_55549' , 'modelname_55552' , 'modelname_55564' , 'modelname_55571' , 'modelname_55576' , 'modelname_55581' , 'modelname_55584' , 'modelname_55587' , 'modelname_55735' , 'modelname_55736' , 'modelname_55744' , 'modelname_55755' , 'modelname_55756' , 'modelname_55757' , 'modelname_55765' , 'modelname_55950' , 'modelname_56285' , 'muster_475' , 'serie_36316' , 'serie_37711' , 'serie_51454' , 'serie_51455' , 'serie_51456' , 'serie_55565' , 'stil_4873' ) AND a . is_filterable = true ;
Copy