| 4 |
0.12 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_1220','coolbox_filter_0','freezebox_filter_2','verpackung_2870','netto_gewicht_filter_5','coolbox_filter_1','freezebox_filter_3','fischart_29659','fischart_29998','netto_gewicht_filter_3','verpackung_3121','netto_gewicht_filter_4','vendor_944','fischart_29664','fischart_29999','vendor_914','verpackung_3948','art_54694','art_54695','fischart_43337','art_2163','netto_gewicht_filter_6','vendor_909','vendor_1107','vendor_1255','vendor_1312','verpackung_35918','fischart_35526','fischart_36125','fischart_43320','fischart_55177','vendor_1179','vendor_1386','vendor_1546','vendor_531','vendor_907','fischart_52356','fischart_52490','fischart_52492','fischart_53820','netto_gewicht_filter_7','vendor_1027','vendor_1182','vendor_1557','vendor_458','vendor_677','vendor_862','vendor_884','vendor_906','vendor_908','vendor_910','vendor_981') 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_1220', 'coolbox_filter_0',
'freezebox_filter_2', 'verpackung_2870',
'netto_gewicht_filter_5', 'coolbox_filter_1',
'freezebox_filter_3', 'fischart_29659',
'fischart_29998', 'netto_gewicht_filter_3',
'verpackung_3121', 'netto_gewicht_filter_4',
'vendor_944', 'fischart_29664',
'fischart_29999', 'vendor_914',
'verpackung_3948', 'art_54694',
'art_54695', 'fischart_43337', 'art_2163',
'netto_gewicht_filter_6', 'vendor_909',
'vendor_1107', 'vendor_1255', 'vendor_1312',
'verpackung_35918', 'fischart_35526',
'fischart_36125', 'fischart_43320',
'fischart_55177', 'vendor_1179',
'vendor_1386', 'vendor_1546', 'vendor_531',
'vendor_907', 'fischart_52356',
'fischart_52490', 'fischart_52492',
'fischart_53820', 'netto_gewicht_filter_7',
'vendor_1027', 'vendor_1182', 'vendor_1557',
'vendor_458', 'vendor_677', 'vendor_862',
'vendor_884', 'vendor_906', 'vendor_908',
'vendor_910', 'vendor_981'
)
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_1220','coolbox_filter_0','freezebox_filter_2','verpackung_2870','netto_gewicht_filter_5','coolbox_filter_1','freezebox_filter_3','fischart_29659','fischart_29998','netto_gewicht_filter_3','verpackung_3121','netto_gewicht_filter_4','vendor_944','fischart_29664','fischart_29999','vendor_914','verpackung_3948','art_54694','art_54695','fischart_43337','art_2163','netto_gewicht_filter_6','vendor_909','vendor_1107','vendor_1255','vendor_1312','verpackung_35918','fischart_35526','fischart_36125','fischart_43320','fischart_55177','vendor_1179','vendor_1386','vendor_1546','vendor_531','vendor_907','fischart_52356','fischart_52490','fischart_52492','fischart_53820','netto_gewicht_filter_7','vendor_1027','vendor_1182','vendor_1557','vendor_458','vendor_677','vendor_862','vendor_884','vendor_906','vendor_908','vendor_910','vendor_981') AND a.is_filterable = true;
|