| 4 |
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_921','netto_gewicht_filter_1','art_54697','verpackung_2870','handelsform_35601','vendor_413','coolbox_filter_0','freezebox_filter_3','family_682','netto_gewicht_filter_3','art_29690','family_1024','family_1021','netto_gewicht_filter_2','handelsform_27518','family_1011','family_1144','handelsform_35599','laenderkueche_36352','family_1016','family_1019','laenderkueche_36351','family_1067','laenderkueche_36354','family_1012','laenderkueche_43012','family_771','netto_gewicht_filter_4','art_23723','family_759','family_1069','verwendungszweck_36671','typ_35555','verwendungszweck_36655','laenderkueche_50808','verwendungszweck_29892','verwendungszweck_36654','handelsform_3534','family_1068','family_1066','family_1022','verpackung_35918','laenderkueche_36353') 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_921', 'netto_gewicht_filter_1',
'art_54697', 'verpackung_2870',
'handelsform_35601', 'vendor_413',
'coolbox_filter_0', 'freezebox_filter_3',
'family_682', 'netto_gewicht_filter_3',
'art_29690', 'family_1024', 'family_1021',
'netto_gewicht_filter_2', 'handelsform_27518',
'family_1011', 'family_1144', 'handelsform_35599',
'laenderkueche_36352', 'family_1016',
'family_1019', 'laenderkueche_36351',
'family_1067', 'laenderkueche_36354',
'family_1012', 'laenderkueche_43012',
'family_771', 'netto_gewicht_filter_4',
'art_23723', 'family_759', 'family_1069',
'verwendungszweck_36671', 'typ_35555',
'verwendungszweck_36655', 'laenderkueche_50808',
'verwendungszweck_29892', 'verwendungszweck_36654',
'handelsform_3534', 'family_1068',
'family_1066', 'family_1022', 'verpackung_35918',
'laenderkueche_36353'
)
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_921','netto_gewicht_filter_1','art_54697','verpackung_2870','handelsform_35601','vendor_413','coolbox_filter_0','freezebox_filter_3','family_682','netto_gewicht_filter_3','art_29690','family_1024','family_1021','netto_gewicht_filter_2','handelsform_27518','family_1011','family_1144','handelsform_35599','laenderkueche_36352','family_1016','family_1019','laenderkueche_36351','family_1067','laenderkueche_36354','family_1012','laenderkueche_43012','family_771','netto_gewicht_filter_4','art_23723','family_759','family_1069','verwendungszweck_36671','typ_35555','verwendungszweck_36655','laenderkueche_50808','verwendungszweck_29892','verwendungszweck_36654','handelsform_3534','family_1068','family_1066','family_1022','verpackung_35918','laenderkueche_36353') AND a.is_filterable = true;
|