| 3 |
0.23 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('sparset_filter_0','freezebox_filter_3','coolbox_filter_1','coolbox_filter_0','family_1072','family_1220','family_684','freezebox_filter_2','family_1035','fischart_29998','fischart_29659','laenderkueche_36352','vendor_42','vendor_1179','vendor_357','fischart_29660','fischart_29999','vendor_944','fischart_29740','fischart_36125','fischart_54823','sparset_filter_1','vendor_679','vendor_728','vendor_914','fischart_37803','vendor_1255','vendor_477','vendor_1027','fischart_43299','vendor_1462','vendor_458','vendor_910','family_1227','family_920','fischart_35526','fischart_38548','fischart_43337','pastete_sorten_29725','vendor_909','fischart_29661','fischart_29664','fischart_43325','fischart_54769','vendor_1311','vendor_227','vendor_678','fischart_43320','vendor_114','vendor_1406','fischart_30000','fischart_45346','fischart_52914','laenderkueche_36350','serie_55386','vendor_1107','vendor_1312','vendor_1355','fischart_52490','fischart_52858','fischart_53820','fischart_54243','fischart_55177','fischart_57425','serie_55241','vendor_1181','vendor_1262','vendor_151','vendor_1658','vendor_224','vendor_531','vendor_869','vendor_907','family_1043','fischart_29658','fischart_29663','fischart_29665','fischart_37804','fischart_38327','fischart_39433','fischart_43277','fischart_43293','fischart_52356','fischart_52492','fischart_54516','fischart_54979','fischart_56343','fischart_57452','fischart_57685','laenderkueche_43127','vendor_1064','vendor_1081','vendor_1141','vendor_1182','vendor_1371','vendor_1386','vendor_1526','vendor_1546','vendor_1557','vendor_204','vendor_402','vendor_635','vendor_637','vendor_677','vendor_757','vendor_884','vendor_908','vendor_981','vendor_983') 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(
'sparset_filter_0', 'freezebox_filter_3',
'coolbox_filter_1', 'coolbox_filter_0',
'family_1072', 'family_1220', 'family_684',
'freezebox_filter_2', 'family_1035',
'fischart_29998', 'fischart_29659',
'laenderkueche_36352', 'vendor_42',
'vendor_1179', 'vendor_357', 'fischart_29660',
'fischart_29999', 'vendor_944',
'fischart_29740', 'fischart_36125',
'fischart_54823', 'sparset_filter_1',
'vendor_679', 'vendor_728', 'vendor_914',
'fischart_37803', 'vendor_1255',
'vendor_477', 'vendor_1027', 'fischart_43299',
'vendor_1462', 'vendor_458', 'vendor_910',
'family_1227', 'family_920', 'fischart_35526',
'fischart_38548', 'fischart_43337',
'pastete_sorten_29725', 'vendor_909',
'fischart_29661', 'fischart_29664',
'fischart_43325', 'fischart_54769',
'vendor_1311', 'vendor_227', 'vendor_678',
'fischart_43320', 'vendor_114',
'vendor_1406', 'fischart_30000',
'fischart_45346', 'fischart_52914',
'laenderkueche_36350', 'serie_55386',
'vendor_1107', 'vendor_1312', 'vendor_1355',
'fischart_52490', 'fischart_52858',
'fischart_53820', 'fischart_54243',
'fischart_55177', 'fischart_57425',
'serie_55241', 'vendor_1181', 'vendor_1262',
'vendor_151', 'vendor_1658', 'vendor_224',
'vendor_531', 'vendor_869', 'vendor_907',
'family_1043', 'fischart_29658',
'fischart_29663', 'fischart_29665',
'fischart_37804', 'fischart_38327',
'fischart_39433', 'fischart_43277',
'fischart_43293', 'fischart_52356',
'fischart_52492', 'fischart_54516',
'fischart_54979', 'fischart_56343',
'fischart_57452', 'fischart_57685',
'laenderkueche_43127', 'vendor_1064',
'vendor_1081', 'vendor_1141', 'vendor_1182',
'vendor_1371', 'vendor_1386', 'vendor_1526',
'vendor_1546', 'vendor_1557', 'vendor_204',
'vendor_402', 'vendor_635', 'vendor_637',
'vendor_677', 'vendor_757', 'vendor_884',
'vendor_908', 'vendor_981', 'vendor_983'
)
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('sparset_filter_0','freezebox_filter_3','coolbox_filter_1','coolbox_filter_0','family_1072','family_1220','family_684','freezebox_filter_2','family_1035','fischart_29998','fischart_29659','laenderkueche_36352','vendor_42','vendor_1179','vendor_357','fischart_29660','fischart_29999','vendor_944','fischart_29740','fischart_36125','fischart_54823','sparset_filter_1','vendor_679','vendor_728','vendor_914','fischart_37803','vendor_1255','vendor_477','vendor_1027','fischart_43299','vendor_1462','vendor_458','vendor_910','family_1227','family_920','fischart_35526','fischart_38548','fischart_43337','pastete_sorten_29725','vendor_909','fischart_29661','fischart_29664','fischart_43325','fischart_54769','vendor_1311','vendor_227','vendor_678','fischart_43320','vendor_114','vendor_1406','fischart_30000','fischart_45346','fischart_52914','laenderkueche_36350','serie_55386','vendor_1107','vendor_1312','vendor_1355','fischart_52490','fischart_52858','fischart_53820','fischart_54243','fischart_55177','fischart_57425','serie_55241','vendor_1181','vendor_1262','vendor_151','vendor_1658','vendor_224','vendor_531','vendor_869','vendor_907','family_1043','fischart_29658','fischart_29663','fischart_29665','fischart_37804','fischart_38327','fischart_39433','fischart_43277','fischart_43293','fischart_52356','fischart_52492','fischart_54516','fischart_54979','fischart_56343','fischart_57452','fischart_57685','laenderkueche_43127','vendor_1064','vendor_1081','vendor_1141','vendor_1182','vendor_1371','vendor_1386','vendor_1526','vendor_1546','vendor_1557','vendor_204','vendor_402','vendor_635','vendor_637','vendor_677','vendor_757','vendor_884','vendor_908','vendor_981','vendor_983') AND a.is_filterable = true;
|