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