| 3 |
0.13 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('freezebox_filter_3','coolbox_filter_0','family_684','netto_gewicht_filter_3','verpackung_36357','laenderkueche_36352','fischart_29659','verpackung_3840','fischart_29740','art_2163','vendor_458','family_920','fischart_35526','pastete_sorten_29725','netto_gewicht_filter_2','vendor_1179','coolbox_filter_1','family_1072','netto_gewicht_filter_4','vendor_114','vendor_728','vendor_227','fischart_29661','netto_gewicht_filter_5','vendor_944','fischart_29658','fischart_29999','serie_55241','vendor_1355','vendor_224','vendor_914','verpackung_3121','fischart_29665','fischart_29998','fischart_52914','laenderkueche_36350','vendor_1181','fischart_30000','vendor_1064','vendor_151','verpackung_4205','fischart_29660','fischart_29663','vendor_1353','vendor_204','vendor_635','vendor_637','vendor_679','verpackung_3948') 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(
'freezebox_filter_3', 'coolbox_filter_0',
'family_684', 'netto_gewicht_filter_3',
'verpackung_36357', 'laenderkueche_36352',
'fischart_29659', 'verpackung_3840',
'fischart_29740', 'art_2163', 'vendor_458',
'family_920', 'fischart_35526',
'pastete_sorten_29725', 'netto_gewicht_filter_2',
'vendor_1179', 'coolbox_filter_1',
'family_1072', 'netto_gewicht_filter_4',
'vendor_114', 'vendor_728', 'vendor_227',
'fischart_29661', 'netto_gewicht_filter_5',
'vendor_944', 'fischart_29658',
'fischart_29999', 'serie_55241',
'vendor_1355', 'vendor_224', 'vendor_914',
'verpackung_3121', 'fischart_29665',
'fischart_29998', 'fischart_52914',
'laenderkueche_36350', 'vendor_1181',
'fischart_30000', 'vendor_1064',
'vendor_151', 'verpackung_4205',
'fischart_29660', 'fischart_29663',
'vendor_1353', 'vendor_204', 'vendor_635',
'vendor_637', 'vendor_679', 'verpackung_3948'
)
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('freezebox_filter_3','coolbox_filter_0','family_684','netto_gewicht_filter_3','verpackung_36357','laenderkueche_36352','fischart_29659','verpackung_3840','fischart_29740','art_2163','vendor_458','family_920','fischart_35526','pastete_sorten_29725','netto_gewicht_filter_2','vendor_1179','coolbox_filter_1','family_1072','netto_gewicht_filter_4','vendor_114','vendor_728','vendor_227','fischart_29661','netto_gewicht_filter_5','vendor_944','fischart_29658','fischart_29999','serie_55241','vendor_1355','vendor_224','vendor_914','verpackung_3121','fischart_29665','fischart_29998','fischart_52914','laenderkueche_36350','vendor_1181','fischart_30000','vendor_1064','vendor_151','verpackung_4205','fischart_29660','fischart_29663','vendor_1353','vendor_204','vendor_635','vendor_637','vendor_679','verpackung_3948') AND a.is_filterable = true;
|