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