| 3 |
0.88 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_3','art_25334','family_981','verpackung_2870','laenderkueche_43012','teigwarenart_25243','family_850','netto_gewicht_filter_2','art_2163','netto_gewicht_filter_4','netto_gewicht_filter_3','vendor_938','verpackung_4205','geschmack_36938','teigwarenart_38803','netto_gewicht_filter_6','vendor_116','art_35236','laenderkueche_36349','laenderkueche_36350','netto_gewicht_filter_5','geschmack_51194','verpackung_4003','geschmack_51196','vendor_1414','vendor_386','geschmack_51195','vendor_446','verpackung_3948','getreideart_15476','getreideart_23707','getreideart_38553','vendor_1293','vendor_1430','vendor_1444','vendor_154','vendor_159','geschmack_23774','geschmack_54650','laenderkueche_36353','vendor_1191','vendor_1423','vendor_442','vendor_458','verpackung_14402','verpackung_4977','anzahl_der_portionen_35937','fleischart_15470','geschmack_23769','geschmack_23771','geschmack_51197','geschmack_56404','laenderkueche_36352','vendor_1267','vendor_1298','vendor_1374','vendor_444','verpackung_3121','verpackung_35918','anzahl_der_portionen_35935','anzahl_der_portionen_50815','geschmack_26604','getreideart_23671','getreideart_38595','laenderkueche_36351','laenderkueche_36354','laenderkueche_36356','laenderkueche_36361','laenderkueche_43011','netto_gewicht_filter_1','serie_39543','vendor_1106','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(
'coolbox_filter_0', 'freezebox_filter_3',
'art_25334', 'family_981', 'verpackung_2870',
'laenderkueche_43012', 'teigwarenart_25243',
'family_850', 'netto_gewicht_filter_2',
'art_2163', 'netto_gewicht_filter_4',
'netto_gewicht_filter_3', 'vendor_938',
'verpackung_4205', 'geschmack_36938',
'teigwarenart_38803', 'netto_gewicht_filter_6',
'vendor_116', 'art_35236', 'laenderkueche_36349',
'laenderkueche_36350', 'netto_gewicht_filter_5',
'geschmack_51194', 'verpackung_4003',
'geschmack_51196', 'vendor_1414',
'vendor_386', 'geschmack_51195',
'vendor_446', 'verpackung_3948',
'getreideart_15476', 'getreideart_23707',
'getreideart_38553', 'vendor_1293',
'vendor_1430', 'vendor_1444', 'vendor_154',
'vendor_159', 'geschmack_23774',
'geschmack_54650', 'laenderkueche_36353',
'vendor_1191', 'vendor_1423', 'vendor_442',
'vendor_458', 'verpackung_14402',
'verpackung_4977', 'anzahl_der_portionen_35937',
'fleischart_15470', 'geschmack_23769',
'geschmack_23771', 'geschmack_51197',
'geschmack_56404', 'laenderkueche_36352',
'vendor_1267', 'vendor_1298', 'vendor_1374',
'vendor_444', 'verpackung_3121',
'verpackung_35918', 'anzahl_der_portionen_35935',
'anzahl_der_portionen_50815', 'geschmack_26604',
'getreideart_23671', 'getreideart_38595',
'laenderkueche_36351', 'laenderkueche_36354',
'laenderkueche_36356', 'laenderkueche_36361',
'laenderkueche_43011', 'netto_gewicht_filter_1',
'serie_39543', 'vendor_1106', '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('coolbox_filter_0','freezebox_filter_3','art_25334','family_981','verpackung_2870','laenderkueche_43012','teigwarenart_25243','family_850','netto_gewicht_filter_2','art_2163','netto_gewicht_filter_4','netto_gewicht_filter_3','vendor_938','verpackung_4205','geschmack_36938','teigwarenart_38803','netto_gewicht_filter_6','vendor_116','art_35236','laenderkueche_36349','laenderkueche_36350','netto_gewicht_filter_5','geschmack_51194','verpackung_4003','geschmack_51196','vendor_1414','vendor_386','geschmack_51195','vendor_446','verpackung_3948','getreideart_15476','getreideart_23707','getreideart_38553','vendor_1293','vendor_1430','vendor_1444','vendor_154','vendor_159','geschmack_23774','geschmack_54650','laenderkueche_36353','vendor_1191','vendor_1423','vendor_442','vendor_458','verpackung_14402','verpackung_4977','anzahl_der_portionen_35937','fleischart_15470','geschmack_23769','geschmack_23771','geschmack_51197','geschmack_56404','laenderkueche_36352','vendor_1267','vendor_1298','vendor_1374','vendor_444','verpackung_3121','verpackung_35918','anzahl_der_portionen_35935','anzahl_der_portionen_50815','geschmack_26604','getreideart_23671','getreideart_38595','laenderkueche_36351','laenderkueche_36354','laenderkueche_36356','laenderkueche_36361','laenderkueche_43011','netto_gewicht_filter_1','serie_39543','vendor_1106','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;
|