| 3 |
0.14 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('freezebox_filter_3','coolbox_filter_0','coolbox_filter_1','netto_gewicht_filter_3','family_1072','verpackung_4205','art_2163','family_684','verpackung_36357','art_56006','verpackung_2870','netto_gewicht_filter_5','family_1035','family_1220','freezebox_filter_2','netto_gewicht_filter_4','laenderkueche_36352','vendor_357','fischart_29659','netto_gewicht_filter_1','fischart_29660','netto_gewicht_filter_2','fischart_29740','art_55439','vendor_1179','verpackung_3840','vendor_42','art_54697','fischart_54823','vendor_679','art_56007','fischart_36125','fischart_37803','fischart_29999','fischart_35526','fischart_29998','vendor_458','vendor_944','family_920','pastete_sorten_29725','vendor_1462','verpackung_3948','fischart_43299','netto_gewicht_filter_6','fischart_37804','fischart_38548','vendor_114','vendor_678','vendor_728','vendor_914','verpackung_3121','verpackung_37215','art_54698','vendor_1255','vendor_227','verpackung_24689','fischart_29661','vendor_477','vendor_909','verpackung_35918','fischart_43337','family_1227','fischart_29658','fischart_29664','fischart_43320','fischart_43325','fischart_52914','serie_55241','serie_55386','vendor_1032','vendor_1355','vendor_1371','vendor_1406','vendor_1465','vendor_224','vendor_910','verpackung_5933','art_54694','fischart_29665','fischart_30000','fischart_43293','laenderkueche_36350','vendor_1107','vendor_1181','vendor_757','art_39784','fischart_29663','fischart_53820','fischart_54769','vendor_1064','vendor_1311','vendor_1312','vendor_151','vendor_531','vendor_869','vendor_907','art_54695','family_1261','fischart_39433','fischart_52356','fischart_52492','fischart_53083','fischart_55177','fischart_55188','fischart_56343','typ_37811','typ_37822','vendor_1081','vendor_1353','vendor_204','vendor_635','vendor_637','vendor_862','vendor_884','vendor_906','vendor_913','verpackung_14402','verpackung_4003') 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(
'freezebox_filter_3', 'coolbox_filter_0',
'coolbox_filter_1', 'netto_gewicht_filter_3',
'family_1072', 'verpackung_4205',
'art_2163', 'family_684', 'verpackung_36357',
'art_56006', 'verpackung_2870',
'netto_gewicht_filter_5', 'family_1035',
'family_1220', 'freezebox_filter_2',
'netto_gewicht_filter_4', 'laenderkueche_36352',
'vendor_357', 'fischart_29659',
'netto_gewicht_filter_1', 'fischart_29660',
'netto_gewicht_filter_2', 'fischart_29740',
'art_55439', 'vendor_1179', 'verpackung_3840',
'vendor_42', 'art_54697', 'fischart_54823',
'vendor_679', 'art_56007', 'fischart_36125',
'fischart_37803', 'fischart_29999',
'fischart_35526', 'fischart_29998',
'vendor_458', 'vendor_944', 'family_920',
'pastete_sorten_29725', 'vendor_1462',
'verpackung_3948', 'fischart_43299',
'netto_gewicht_filter_6', 'fischart_37804',
'fischart_38548', 'vendor_114',
'vendor_678', 'vendor_728', 'vendor_914',
'verpackung_3121', 'verpackung_37215',
'art_54698', 'vendor_1255', 'vendor_227',
'verpackung_24689', 'fischart_29661',
'vendor_477', 'vendor_909', 'verpackung_35918',
'fischart_43337', 'family_1227',
'fischart_29658', 'fischart_29664',
'fischart_43320', 'fischart_43325',
'fischart_52914', 'serie_55241',
'serie_55386', 'vendor_1032', 'vendor_1355',
'vendor_1371', 'vendor_1406', 'vendor_1465',
'vendor_224', 'vendor_910', 'verpackung_5933',
'art_54694', 'fischart_29665', 'fischart_30000',
'fischart_43293', 'laenderkueche_36350',
'vendor_1107', 'vendor_1181', 'vendor_757',
'art_39784', 'fischart_29663', 'fischart_53820',
'fischart_54769', 'vendor_1064',
'vendor_1311', 'vendor_1312', 'vendor_151',
'vendor_531', 'vendor_869', 'vendor_907',
'art_54695', 'family_1261', 'fischart_39433',
'fischart_52356', 'fischart_52492',
'fischart_53083', 'fischart_55177',
'fischart_55188', 'fischart_56343',
'typ_37811', 'typ_37822', 'vendor_1081',
'vendor_1353', 'vendor_204', 'vendor_635',
'vendor_637', 'vendor_862', 'vendor_884',
'vendor_906', 'vendor_913', 'verpackung_14402',
'verpackung_4003'
)
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('freezebox_filter_3','coolbox_filter_0','coolbox_filter_1','netto_gewicht_filter_3','family_1072','verpackung_4205','art_2163','family_684','verpackung_36357','art_56006','verpackung_2870','netto_gewicht_filter_5','family_1035','family_1220','freezebox_filter_2','netto_gewicht_filter_4','laenderkueche_36352','vendor_357','fischart_29659','netto_gewicht_filter_1','fischart_29660','netto_gewicht_filter_2','fischart_29740','art_55439','vendor_1179','verpackung_3840','vendor_42','art_54697','fischart_54823','vendor_679','art_56007','fischart_36125','fischart_37803','fischart_29999','fischart_35526','fischart_29998','vendor_458','vendor_944','family_920','pastete_sorten_29725','vendor_1462','verpackung_3948','fischart_43299','netto_gewicht_filter_6','fischart_37804','fischart_38548','vendor_114','vendor_678','vendor_728','vendor_914','verpackung_3121','verpackung_37215','art_54698','vendor_1255','vendor_227','verpackung_24689','fischart_29661','vendor_477','vendor_909','verpackung_35918','fischart_43337','family_1227','fischart_29658','fischart_29664','fischart_43320','fischart_43325','fischart_52914','serie_55241','serie_55386','vendor_1032','vendor_1355','vendor_1371','vendor_1406','vendor_1465','vendor_224','vendor_910','verpackung_5933','art_54694','fischart_29665','fischart_30000','fischart_43293','laenderkueche_36350','vendor_1107','vendor_1181','vendor_757','art_39784','fischart_29663','fischart_53820','fischart_54769','vendor_1064','vendor_1311','vendor_1312','vendor_151','vendor_531','vendor_869','vendor_907','art_54695','family_1261','fischart_39433','fischart_52356','fischart_52492','fischart_53083','fischart_55177','fischart_55188','fischart_56343','typ_37811','typ_37822','vendor_1081','vendor_1353','vendor_204','vendor_635','vendor_637','vendor_862','vendor_884','vendor_906','vendor_913','verpackung_14402','verpackung_4003') AND a.is_filterable = true;
|