| 4 |
0.15 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_850','coolbox_filter_0','freezebox_filter_3','verpackung_4205','netto_gewicht_filter_4','netto_gewicht_filter_3','verpackung_2870','art_35236','laenderkueche_36349','laenderkueche_36350','getreideart_23707','netto_gewicht_filter_2','vendor_386','vendor_446','verpackung_35918','anzahl_der_portionen_50815','art_2163','getreideart_15476','getreideart_38553','vendor_159','verpackung_3948','laenderkueche_36353','netto_gewicht_filter_6','vendor_1191','vendor_442','vendor_458','anzahl_der_portionen_35937','fleischart_15470','laenderkueche_36352','netto_gewicht_filter_5','vendor_1298','vendor_1374','vendor_444','anzahl_der_portionen_35935','getreideart_23671','getreideart_38595','laenderkueche_36351','laenderkueche_36354','laenderkueche_36356','laenderkueche_36361','laenderkueche_43011','serie_39543','vendor_114','vendor_1157','vendor_1206','vendor_224','vendor_278','vendor_295','vendor_514','vendor_531','vendor_922','verpackung_5933','verpackung_9455') 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_850', 'coolbox_filter_0',
'freezebox_filter_3', 'verpackung_4205',
'netto_gewicht_filter_4', 'netto_gewicht_filter_3',
'verpackung_2870', 'art_35236',
'laenderkueche_36349', 'laenderkueche_36350',
'getreideart_23707', 'netto_gewicht_filter_2',
'vendor_386', 'vendor_446', 'verpackung_35918',
'anzahl_der_portionen_50815', 'art_2163',
'getreideart_15476', 'getreideart_38553',
'vendor_159', 'verpackung_3948',
'laenderkueche_36353', 'netto_gewicht_filter_6',
'vendor_1191', 'vendor_442', 'vendor_458',
'anzahl_der_portionen_35937', 'fleischart_15470',
'laenderkueche_36352', 'netto_gewicht_filter_5',
'vendor_1298', 'vendor_1374', 'vendor_444',
'anzahl_der_portionen_35935', 'getreideart_23671',
'getreideart_38595', 'laenderkueche_36351',
'laenderkueche_36354', 'laenderkueche_36356',
'laenderkueche_36361', 'laenderkueche_43011',
'serie_39543', 'vendor_114', 'vendor_1157',
'vendor_1206', 'vendor_224', 'vendor_278',
'vendor_295', 'vendor_514', 'vendor_531',
'vendor_922', 'verpackung_5933',
'verpackung_9455'
)
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_850','coolbox_filter_0','freezebox_filter_3','verpackung_4205','netto_gewicht_filter_4','netto_gewicht_filter_3','verpackung_2870','art_35236','laenderkueche_36349','laenderkueche_36350','getreideart_23707','netto_gewicht_filter_2','vendor_386','vendor_446','verpackung_35918','anzahl_der_portionen_50815','art_2163','getreideart_15476','getreideart_38553','vendor_159','verpackung_3948','laenderkueche_36353','netto_gewicht_filter_6','vendor_1191','vendor_442','vendor_458','anzahl_der_portionen_35937','fleischart_15470','laenderkueche_36352','netto_gewicht_filter_5','vendor_1298','vendor_1374','vendor_444','anzahl_der_portionen_35935','getreideart_23671','getreideart_38595','laenderkueche_36351','laenderkueche_36354','laenderkueche_36356','laenderkueche_36361','laenderkueche_43011','serie_39543','vendor_114','vendor_1157','vendor_1206','vendor_224','vendor_278','vendor_295','vendor_514','vendor_531','vendor_922','verpackung_5933','verpackung_9455') AND a.is_filterable = true;
|