| 4 |
0.68 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','vendor_114','netto_gewicht_filter_4','verpackung_4205','netto_gewicht_filter_3','netto_gewicht_filter_5','verpackung_36357','laenderkueche_36350','verpackung_2870','art_2163','family_684','family_1002','fischart_29740','art_27151','family_683','family_711','family_1027','family_1031','family_376','family_986','laenderkueche_36352','sorte_3536','art_51799','art_56215','family_1028','family_920','fettanteil_43969','fischart_29658','handelsform_3534','netto_gewicht_filter_6','pastete_sorten_29725','verpackung_3840','art_23067','art_29787','family_1128','family_577','family_688','family_778','family_850','fischart_29659','fuellung_29777','geschmack_23761','geschmack_23782','geschmack_35867','geschmack_36380','getreideart_15476','handelsform_27113','handelsform_3535','typ_34174','verpackung_24689','verpackung_2954') 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',
'vendor_114', 'netto_gewicht_filter_4',
'verpackung_4205', 'netto_gewicht_filter_3',
'netto_gewicht_filter_5', 'verpackung_36357',
'laenderkueche_36350', 'verpackung_2870',
'art_2163', 'family_684', 'family_1002',
'fischart_29740', 'art_27151', 'family_683',
'family_711', 'family_1027', 'family_1031',
'family_376', 'family_986', 'laenderkueche_36352',
'sorte_3536', 'art_51799', 'art_56215',
'family_1028', 'family_920', 'fettanteil_43969',
'fischart_29658', 'handelsform_3534',
'netto_gewicht_filter_6', 'pastete_sorten_29725',
'verpackung_3840', 'art_23067',
'art_29787', 'family_1128', 'family_577',
'family_688', 'family_778', 'family_850',
'fischart_29659', 'fuellung_29777',
'geschmack_23761', 'geschmack_23782',
'geschmack_35867', 'geschmack_36380',
'getreideart_15476', 'handelsform_27113',
'handelsform_3535', 'typ_34174',
'verpackung_24689', 'verpackung_2954'
)
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','vendor_114','netto_gewicht_filter_4','verpackung_4205','netto_gewicht_filter_3','netto_gewicht_filter_5','verpackung_36357','laenderkueche_36350','verpackung_2870','art_2163','family_684','family_1002','fischart_29740','art_27151','family_683','family_711','family_1027','family_1031','family_376','family_986','laenderkueche_36352','sorte_3536','art_51799','art_56215','family_1028','family_920','fettanteil_43969','fischart_29658','handelsform_3534','netto_gewicht_filter_6','pastete_sorten_29725','verpackung_3840','art_23067','art_29787','family_1128','family_577','family_688','family_778','family_850','fischart_29659','fuellung_29777','geschmack_23761','geschmack_23782','geschmack_35867','geschmack_36380','getreideart_15476','handelsform_27113','handelsform_3535','typ_34174','verpackung_24689','verpackung_2954') AND a.is_filterable = true;
|