| 3 |
0.13 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('coolbox_filter_0','freezebox_filter_3','sparset_filter_0','family_922','vendor_231','family_1065','vendor_150','laenderkueche_36354','netto_fuellmenge_filter_3','family_691','family_1032','family_752','laenderkueche_36352','netto_fuellmenge_filter_4','laenderkueche_36349','vendor_1187','vendor_386','netto_fuellmenge_filter_2','netto_fuellmenge_filter_5','vendor_508','vendor_534','laenderkueche_43012','vendor_1028','vendor_1218','vendor_535','vendor_608','vendor_892','family_1128','laenderkueche_36350','laenderkueche_43210','laenderkueche_50808','vendor_1374','vendor_1379','vendor_430','vendor_537','vendor_538','laenderkueche_36351','laenderkueche_36360','sparset_filter_1','vendor_1055','vendor_114','vendor_1191','vendor_1283','vendor_1313','vendor_1372','vendor_144','vendor_1514','vendor_1535','vendor_1596','vendor_431','vendor_458','vendor_473','vendor_531','vendor_873','vendor_904') 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(
'coolbox_filter_0', 'freezebox_filter_3',
'sparset_filter_0', 'family_922',
'vendor_231', 'family_1065', 'vendor_150',
'laenderkueche_36354', 'netto_fuellmenge_filter_3',
'family_691', 'family_1032', 'family_752',
'laenderkueche_36352', 'netto_fuellmenge_filter_4',
'laenderkueche_36349', 'vendor_1187',
'vendor_386', 'netto_fuellmenge_filter_2',
'netto_fuellmenge_filter_5', 'vendor_508',
'vendor_534', 'laenderkueche_43012',
'vendor_1028', 'vendor_1218', 'vendor_535',
'vendor_608', 'vendor_892', 'family_1128',
'laenderkueche_36350', 'laenderkueche_43210',
'laenderkueche_50808', 'vendor_1374',
'vendor_1379', 'vendor_430', 'vendor_537',
'vendor_538', 'laenderkueche_36351',
'laenderkueche_36360', 'sparset_filter_1',
'vendor_1055', 'vendor_114', 'vendor_1191',
'vendor_1283', 'vendor_1313', 'vendor_1372',
'vendor_144', 'vendor_1514', 'vendor_1535',
'vendor_1596', 'vendor_431', 'vendor_458',
'vendor_473', 'vendor_531', 'vendor_873',
'vendor_904'
)
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('coolbox_filter_0','freezebox_filter_3','sparset_filter_0','family_922','vendor_231','family_1065','vendor_150','laenderkueche_36354','netto_fuellmenge_filter_3','family_691','family_1032','family_752','laenderkueche_36352','netto_fuellmenge_filter_4','laenderkueche_36349','vendor_1187','vendor_386','netto_fuellmenge_filter_2','netto_fuellmenge_filter_5','vendor_508','vendor_534','laenderkueche_43012','vendor_1028','vendor_1218','vendor_535','vendor_608','vendor_892','family_1128','laenderkueche_36350','laenderkueche_43210','laenderkueche_50808','vendor_1374','vendor_1379','vendor_430','vendor_537','vendor_538','laenderkueche_36351','laenderkueche_36360','sparset_filter_1','vendor_1055','vendor_114','vendor_1191','vendor_1283','vendor_1313','vendor_1372','vendor_144','vendor_1514','vendor_1535','vendor_1596','vendor_431','vendor_458','vendor_473','vendor_531','vendor_873','vendor_904') AND a.is_filterable = true;
|