| 3 |
0.17 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','coolbox_filter_0','freezebox_filter_3','family_1152','freezebox_filter_2','coolbox_filter_1','family_1101','family_683','sparset_filter_1','vendor_531','serie_51387','vendor_1507','vendor_862','vendor_1372','vendor_1317','vendor_1316','vendor_1330','vendor_1476','vendor_386','family_1266','vendor_1598','vendor_458','vendor_621','vendor_664','family_1225','family_1265','vendor_1119','vendor_114','family_1291','vendor_1160','vendor_1455','vendor_1608','vendor_1621','vendor_642','vendor_1380','vendor_1381','vendor_519','vendor_666','family_1226','serie_54773','vendor_1449','vendor_1505','vendor_630','vendor_665','vendor_972','netto_fuellmenge_filter_5','serie_36417','vendor_144','vendor_1463','vendor_1477','vendor_1506','vendor_1592','vendor_1660','vendor_224','vendor_517','vendor_637','vendor_641','vendor_901') 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', 'coolbox_filter_0',
'freezebox_filter_3', 'family_1152',
'freezebox_filter_2', 'coolbox_filter_1',
'family_1101', 'family_683', 'sparset_filter_1',
'vendor_531', 'serie_51387', 'vendor_1507',
'vendor_862', 'vendor_1372', 'vendor_1317',
'vendor_1316', 'vendor_1330', 'vendor_1476',
'vendor_386', 'family_1266', 'vendor_1598',
'vendor_458', 'vendor_621', 'vendor_664',
'family_1225', 'family_1265', 'vendor_1119',
'vendor_114', 'family_1291', 'vendor_1160',
'vendor_1455', 'vendor_1608', 'vendor_1621',
'vendor_642', 'vendor_1380', 'vendor_1381',
'vendor_519', 'vendor_666', 'family_1226',
'serie_54773', 'vendor_1449', 'vendor_1505',
'vendor_630', 'vendor_665', 'vendor_972',
'netto_fuellmenge_filter_5', 'serie_36417',
'vendor_144', 'vendor_1463', 'vendor_1477',
'vendor_1506', 'vendor_1592', 'vendor_1660',
'vendor_224', 'vendor_517', 'vendor_637',
'vendor_641', 'vendor_901'
)
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','coolbox_filter_0','freezebox_filter_3','family_1152','freezebox_filter_2','coolbox_filter_1','family_1101','family_683','sparset_filter_1','vendor_531','serie_51387','vendor_1507','vendor_862','vendor_1372','vendor_1317','vendor_1316','vendor_1330','vendor_1476','vendor_386','family_1266','vendor_1598','vendor_458','vendor_621','vendor_664','family_1225','family_1265','vendor_1119','vendor_114','family_1291','vendor_1160','vendor_1455','vendor_1608','vendor_1621','vendor_642','vendor_1380','vendor_1381','vendor_519','vendor_666','family_1226','serie_54773','vendor_1449','vendor_1505','vendor_630','vendor_665','vendor_972','netto_fuellmenge_filter_5','serie_36417','vendor_144','vendor_1463','vendor_1477','vendor_1506','vendor_1592','vendor_1660','vendor_224','vendor_517','vendor_637','vendor_641','vendor_901') AND a.is_filterable = true;
|