| 4 |
0.11 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','family_760','freezebox_filter_3','art_der_suessigkeiten_34102','netto_gewicht_filter_3','verpackung_2870','geschmack_23762','verpackung_3121','geschmack_23759','geschmack_23757','verpackung_35918','geschmack_23753','vendor_989','vendor_196','vendor_386','geschmack_23756','geschmack_23765','geschmack_23763','geschmack_26611','netto_gewicht_filter_2','netto_gewicht_filter_5','vendor_881','art_2163','geschmack_23754','geschmack_26612','vendor_1232','vendor_406','verpackung_2954','geschmack_23747','geschmack_23760','geschmack_26964','geschmack_31753','geschmack_32270','geschmack_42691','geschmack_52741','netto_gewicht_filter_4','vendor_135','vendor_1508','vendor_156','vendor_179','geschmack_23755','geschmack_23764','geschmack_24687','geschmack_26600','netto_gewicht_filter_6','vendor_1124','vendor_221','vendor_265','vendor_380','vendor_529','vendor_860','vendor_880','verpackung_14402') 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', 'family_760',
'freezebox_filter_3', 'art_der_suessigkeiten_34102',
'netto_gewicht_filter_3', 'verpackung_2870',
'geschmack_23762', 'verpackung_3121',
'geschmack_23759', 'geschmack_23757',
'verpackung_35918', 'geschmack_23753',
'vendor_989', 'vendor_196', 'vendor_386',
'geschmack_23756', 'geschmack_23765',
'geschmack_23763', 'geschmack_26611',
'netto_gewicht_filter_2', 'netto_gewicht_filter_5',
'vendor_881', 'art_2163', 'geschmack_23754',
'geschmack_26612', 'vendor_1232',
'vendor_406', 'verpackung_2954',
'geschmack_23747', 'geschmack_23760',
'geschmack_26964', 'geschmack_31753',
'geschmack_32270', 'geschmack_42691',
'geschmack_52741', 'netto_gewicht_filter_4',
'vendor_135', 'vendor_1508', 'vendor_156',
'vendor_179', 'geschmack_23755',
'geschmack_23764', 'geschmack_24687',
'geschmack_26600', 'netto_gewicht_filter_6',
'vendor_1124', 'vendor_221', 'vendor_265',
'vendor_380', 'vendor_529', 'vendor_860',
'vendor_880', 'verpackung_14402'
)
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','family_760','freezebox_filter_3','art_der_suessigkeiten_34102','netto_gewicht_filter_3','verpackung_2870','geschmack_23762','verpackung_3121','geschmack_23759','geschmack_23757','verpackung_35918','geschmack_23753','vendor_989','vendor_196','vendor_386','geschmack_23756','geschmack_23765','geschmack_23763','geschmack_26611','netto_gewicht_filter_2','netto_gewicht_filter_5','vendor_881','art_2163','geschmack_23754','geschmack_26612','vendor_1232','vendor_406','verpackung_2954','geschmack_23747','geschmack_23760','geschmack_26964','geschmack_31753','geschmack_32270','geschmack_42691','geschmack_52741','netto_gewicht_filter_4','vendor_135','vendor_1508','vendor_156','vendor_179','geschmack_23755','geschmack_23764','geschmack_24687','geschmack_26600','netto_gewicht_filter_6','vendor_1124','vendor_221','vendor_265','vendor_380','vendor_529','vendor_860','vendor_880','verpackung_14402') AND a.is_filterable = true;
|