| 3 |
0.18 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_1035','netto_gewicht_filter_1','verpackung_5933','fischart_43299','vendor_1406','coolbox_filter_0','freezebox_filter_3','netto_gewicht_filter_3','art_2163','art_54698','verpackung_2870','fischart_29660','vendor_1032','verpackung_35918','fischart_29740','vendor_679','family_1220','verpackung_3948','fischart_29998','vendor_1255','coolbox_filter_1','art_54697','fischart_54769','vendor_1371','vendor_678','verpackung_37215','fischart_53083','netto_gewicht_filter_4','art_39784','typ_37811','fischart_29999','fischart_52914','fischart_56343','vendor_1179','freezebox_filter_2','vendor_357','fischart_43293','fischart_43320','typ_37822','fischart_43337','fischart_52492','art_54694','verpackung_3121','fischart_29659','vendor_1312','fischart_43325','fischart_36125','vendor_757','art_54695','vendor_910','verpackung_14402','fischart_29663','fischart_37803','vendor_944','netto_gewicht_filter_2') 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_1035', 'netto_gewicht_filter_1',
'verpackung_5933', 'fischart_43299',
'vendor_1406', 'coolbox_filter_0',
'freezebox_filter_3', 'netto_gewicht_filter_3',
'art_2163', 'art_54698', 'verpackung_2870',
'fischart_29660', 'vendor_1032',
'verpackung_35918', 'fischart_29740',
'vendor_679', 'family_1220', 'verpackung_3948',
'fischart_29998', 'vendor_1255',
'coolbox_filter_1', 'art_54697',
'fischart_54769', 'vendor_1371',
'vendor_678', 'verpackung_37215',
'fischart_53083', 'netto_gewicht_filter_4',
'art_39784', 'typ_37811', 'fischart_29999',
'fischart_52914', 'fischart_56343',
'vendor_1179', 'freezebox_filter_2',
'vendor_357', 'fischart_43293',
'fischart_43320', 'typ_37822', 'fischart_43337',
'fischart_52492', 'art_54694', 'verpackung_3121',
'fischart_29659', 'vendor_1312',
'fischart_43325', 'fischart_36125',
'vendor_757', 'art_54695', 'vendor_910',
'verpackung_14402', 'fischart_29663',
'fischart_37803', 'vendor_944',
'netto_gewicht_filter_2'
)
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_1035','netto_gewicht_filter_1','verpackung_5933','fischart_43299','vendor_1406','coolbox_filter_0','freezebox_filter_3','netto_gewicht_filter_3','art_2163','art_54698','verpackung_2870','fischart_29660','vendor_1032','verpackung_35918','fischart_29740','vendor_679','family_1220','verpackung_3948','fischart_29998','vendor_1255','coolbox_filter_1','art_54697','fischart_54769','vendor_1371','vendor_678','verpackung_37215','fischart_53083','netto_gewicht_filter_4','art_39784','typ_37811','fischart_29999','fischart_52914','fischart_56343','vendor_1179','freezebox_filter_2','vendor_357','fischart_43293','fischart_43320','typ_37822','fischart_43337','fischart_52492','art_54694','verpackung_3121','fischart_29659','vendor_1312','fischart_43325','fischart_36125','vendor_757','art_54695','vendor_910','verpackung_14402','fischart_29663','fischart_37803','vendor_944','netto_gewicht_filter_2') AND a.is_filterable = true;
|