| 4 |
0.66 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_687','netto_gewicht_filter_3','verpackung_2870','geschmack_36009','vendor_380','coolbox_filter_0','freezebox_filter_3','geschmack_36380','netto_gewicht_filter_4','art_2163','geschmack_23765','geschmack_42730','geschmack_36384','family_693','netto_gewicht_filter_5','verpackung_4003','modelname_40223','geschmack_23781','geschmack_25688','geschmack_29765','geschmack_52741','verpackung_3948','geschmack_26932','fuellung_39485','geschmack_26964','geschmack_54962','netto_gewicht_filter_6','geschmack_23759','geschmack_29768','fuellung_39488','geschmack_26600','family_688','geschmack_23753','family_1000','geschmack_23757','geschmack_42774','art_29792','verpackung_35918','art_55087','family_932','family_1114','verpackung_14402','geschmack_42691','geschmack_38999','fuellung_36388','geschmack_54640','fuellung_39647','family_760','geschmack_31753','geschmack_26601','art_29787') 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_687', 'netto_gewicht_filter_3',
'verpackung_2870', 'geschmack_36009',
'vendor_380', 'coolbox_filter_0',
'freezebox_filter_3', 'geschmack_36380',
'netto_gewicht_filter_4', 'art_2163',
'geschmack_23765', 'geschmack_42730',
'geschmack_36384', 'family_693',
'netto_gewicht_filter_5', 'verpackung_4003',
'modelname_40223', 'geschmack_23781',
'geschmack_25688', 'geschmack_29765',
'geschmack_52741', 'verpackung_3948',
'geschmack_26932', 'fuellung_39485',
'geschmack_26964', 'geschmack_54962',
'netto_gewicht_filter_6', 'geschmack_23759',
'geschmack_29768', 'fuellung_39488',
'geschmack_26600', 'family_688',
'geschmack_23753', 'family_1000',
'geschmack_23757', 'geschmack_42774',
'art_29792', 'verpackung_35918',
'art_55087', 'family_932', 'family_1114',
'verpackung_14402', 'geschmack_42691',
'geschmack_38999', 'fuellung_36388',
'geschmack_54640', 'fuellung_39647',
'family_760', 'geschmack_31753',
'geschmack_26601', 'art_29787'
)
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_687','netto_gewicht_filter_3','verpackung_2870','geschmack_36009','vendor_380','coolbox_filter_0','freezebox_filter_3','geschmack_36380','netto_gewicht_filter_4','art_2163','geschmack_23765','geschmack_42730','geschmack_36384','family_693','netto_gewicht_filter_5','verpackung_4003','modelname_40223','geschmack_23781','geschmack_25688','geschmack_29765','geschmack_52741','verpackung_3948','geschmack_26932','fuellung_39485','geschmack_26964','geschmack_54962','netto_gewicht_filter_6','geschmack_23759','geschmack_29768','fuellung_39488','geschmack_26600','family_688','geschmack_23753','family_1000','geschmack_23757','geschmack_42774','art_29792','verpackung_35918','art_55087','family_932','family_1114','verpackung_14402','geschmack_42691','geschmack_38999','fuellung_36388','geschmack_54640','fuellung_39647','family_760','geschmack_31753','geschmack_26601','art_29787') AND a.is_filterable = true;
|