3
1.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' , 'sparset_filter_0' , 'family_376' , 'family_1073' , 'family_589' , 'vendor_1258' , 'vendor_482' , 'vendor_1135' , 'vendor_1016' , 'family_699' , 'family_629' , 'family_886' , 'vendor_486' , 'vendor_186' , 'vendor_1031' , 'vendor_192' , 'vendor_553' , 'vendor_171' , 'vendor_1133' , 'vendor_316' , 'vendor_743' , 'vendor_1104' , 'vendor_1422' , 'vendor_414' , 'vendor_991' , 'vendor_1289' , 'vendor_1297' , 'vendor_1593' , 'vendor_1606' , 'vendor_552' , 'vendor_772' , 'netto_fuellmenge_filter_3' , 'vendor_1483' , 'vendor_166' , 'vendor_274' , 'vendor_745' , 'netto_fuellmenge_filter_5' , 'vendor_1018' , 'vendor_114' , 'vendor_1302' , 'vendor_554' , 'vendor_744' , 'vendor_1138' , 'vendor_1309' , 'vendor_1319' , 'vendor_1347' , 'vendor_1440' , 'vendor_1624' , 'vendor_187' , 'family_1055' , 'netto_fuellmenge_filter_4' , 'netto_fuellmenge_filter_6' , 'sparset_filter_1' , 'vendor_1091' , 'vendor_1112' , 'vendor_1213' , 'vendor_1299' , 'vendor_1354' , 'vendor_1358' , 'vendor_1394' , 'vendor_1441' , 'vendor_1461' , 'vendor_1617' , 'vendor_212' , 'vendor_225' , 'vendor_256' , 'vendor_291' , 'vendor_438' , 'vendor_551' , 'vendor_785' ) 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' ,
'sparset_filter_0' , 'family_376' ,
'family_1073' , 'family_589' , 'vendor_1258' ,
'vendor_482' , 'vendor_1135' , 'vendor_1016' ,
'family_699' , 'family_629' , 'family_886' ,
'vendor_486' , 'vendor_186' , 'vendor_1031' ,
'vendor_192' , 'vendor_553' , 'vendor_171' ,
'vendor_1133' , 'vendor_316' , 'vendor_743' ,
'vendor_1104' , 'vendor_1422' , 'vendor_414' ,
'vendor_991' , 'vendor_1289' , 'vendor_1297' ,
'vendor_1593' , 'vendor_1606' , 'vendor_552' ,
'vendor_772' , 'netto_fuellmenge_filter_3' ,
'vendor_1483' , 'vendor_166' , 'vendor_274' ,
'vendor_745' , 'netto_fuellmenge_filter_5' ,
'vendor_1018' , 'vendor_114' , 'vendor_1302' ,
'vendor_554' , 'vendor_744' , 'vendor_1138' ,
'vendor_1309' , 'vendor_1319' , 'vendor_1347' ,
'vendor_1440' , 'vendor_1624' , 'vendor_187' ,
'family_1055' , 'netto_fuellmenge_filter_4' ,
'netto_fuellmenge_filter_6' , 'sparset_filter_1' ,
'vendor_1091' , 'vendor_1112' , 'vendor_1213' ,
'vendor_1299' , 'vendor_1354' , 'vendor_1358' ,
'vendor_1394' , 'vendor_1441' , 'vendor_1461' ,
'vendor_1617' , 'vendor_212' , 'vendor_225' ,
'vendor_256' , 'vendor_291' , 'vendor_438' ,
'vendor_551' , 'vendor_785'
)
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' , 'sparset_filter_0' , 'family_376' , 'family_1073' , 'family_589' , 'vendor_1258' , 'vendor_482' , 'vendor_1135' , 'vendor_1016' , 'family_699' , 'family_629' , 'family_886' , 'vendor_486' , 'vendor_186' , 'vendor_1031' , 'vendor_192' , 'vendor_553' , 'vendor_171' , 'vendor_1133' , 'vendor_316' , 'vendor_743' , 'vendor_1104' , 'vendor_1422' , 'vendor_414' , 'vendor_991' , 'vendor_1289' , 'vendor_1297' , 'vendor_1593' , 'vendor_1606' , 'vendor_552' , 'vendor_772' , 'netto_fuellmenge_filter_3' , 'vendor_1483' , 'vendor_166' , 'vendor_274' , 'vendor_745' , 'netto_fuellmenge_filter_5' , 'vendor_1018' , 'vendor_114' , 'vendor_1302' , 'vendor_554' , 'vendor_744' , 'vendor_1138' , 'vendor_1309' , 'vendor_1319' , 'vendor_1347' , 'vendor_1440' , 'vendor_1624' , 'vendor_187' , 'family_1055' , 'netto_fuellmenge_filter_4' , 'netto_fuellmenge_filter_6' , 'sparset_filter_1' , 'vendor_1091' , 'vendor_1112' , 'vendor_1213' , 'vendor_1299' , 'vendor_1354' , 'vendor_1358' , 'vendor_1394' , 'vendor_1441' , 'vendor_1461' , 'vendor_1617' , 'vendor_212' , 'vendor_225' , 'vendor_256' , 'vendor_291' , 'vendor_438' , 'vendor_551' , 'vendor_785' ) AND a . is_filterable = true ;
Copy