| 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('coolbox_filter_0','freezebox_filter_2','netto_gewicht_filter_4','family_1212','laenderkueche_36350','fleischart_15470','verpackung_2870','vendor_531','verpackung_3121','verpackung_35918','family_1215','fuellung_51141','fuellung_51115','laenderkueche_50808','netto_gewicht_filter_3','fleischart_15474','art_2163','fuellung_51125','fleischart_47539','fuellung_51117','laenderkueche_51124','netto_gewicht_filter_5','vendor_458','vendor_639','art_51126','fuellung_52898','vendor_1070','family_1253','fuellung_51140','typ_55388','vendor_1157','art_41586','fuellung_51114','fuellung_52846','fuellung_55875','laenderkueche_36349','vendor_1540','vendor_850','verpackung_4003','family_1251','fuellung_51108','fuellung_51109','fuellung_54834','laenderkueche_36354','laenderkueche_36355','netto_gewicht_filter_6','vendor_1547','vendor_851','vendor_972','verpackung_37215') 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_2',
'netto_gewicht_filter_4', 'family_1212',
'laenderkueche_36350', 'fleischart_15470',
'verpackung_2870', 'vendor_531',
'verpackung_3121', 'verpackung_35918',
'family_1215', 'fuellung_51141',
'fuellung_51115', 'laenderkueche_50808',
'netto_gewicht_filter_3', 'fleischart_15474',
'art_2163', 'fuellung_51125', 'fleischart_47539',
'fuellung_51117', 'laenderkueche_51124',
'netto_gewicht_filter_5', 'vendor_458',
'vendor_639', 'art_51126', 'fuellung_52898',
'vendor_1070', 'family_1253', 'fuellung_51140',
'typ_55388', 'vendor_1157', 'art_41586',
'fuellung_51114', 'fuellung_52846',
'fuellung_55875', 'laenderkueche_36349',
'vendor_1540', 'vendor_850', 'verpackung_4003',
'family_1251', 'fuellung_51108',
'fuellung_51109', 'fuellung_54834',
'laenderkueche_36354', 'laenderkueche_36355',
'netto_gewicht_filter_6', 'vendor_1547',
'vendor_851', 'vendor_972', 'verpackung_37215'
)
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_2','netto_gewicht_filter_4','family_1212','laenderkueche_36350','fleischart_15470','verpackung_2870','vendor_531','verpackung_3121','verpackung_35918','family_1215','fuellung_51141','fuellung_51115','laenderkueche_50808','netto_gewicht_filter_3','fleischart_15474','art_2163','fuellung_51125','fleischart_47539','fuellung_51117','laenderkueche_51124','netto_gewicht_filter_5','vendor_458','vendor_639','art_51126','fuellung_52898','vendor_1070','family_1253','fuellung_51140','typ_55388','vendor_1157','art_41586','fuellung_51114','fuellung_52846','fuellung_55875','laenderkueche_36349','vendor_1540','vendor_850','verpackung_4003','family_1251','fuellung_51108','fuellung_51109','fuellung_54834','laenderkueche_36354','laenderkueche_36355','netto_gewicht_filter_6','vendor_1547','vendor_851','vendor_972','verpackung_37215') AND a.is_filterable = true;
|