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