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