| 3 |
0.18 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_1','freezebox_filter_3','sparset_filter_0','fleischart_15470','vendor_531','family_1078','family_1286','family_1072','vendor_42','family_1035','family_1101','fischart_29660','vendor_751','fischart_29998','family_1080','family_1106','family_1220','fleischart_15474','serie_44736','vendor_1255','vendor_357','vendor_666','family_1074','family_1225','family_1266','serie_27405','vendor_1555','vendor_1577','vendor_224','vendor_752','family_1173','family_1226','family_1246','family_1265','fischart_36125','fischart_37803','fischart_43299','fischart_54243','fischart_54516','fischart_54769','fleischart_30153','fleischart_47539','netto_fuellmenge_filter_5','serie_39534','serie_39537','serie_39540','serie_41382','serie_55386','vendor_1141','vendor_1179','vendor_1316','vendor_1383','vendor_1463','vendor_1506','vendor_1660','vendor_519','vendor_621','vendor_664','vendor_750','vendor_874','vendor_914','vendor_981') 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_1', 'freezebox_filter_3',
'sparset_filter_0', 'fleischart_15470',
'vendor_531', 'family_1078', 'family_1286',
'family_1072', 'vendor_42', 'family_1035',
'family_1101', 'fischart_29660',
'vendor_751', 'fischart_29998',
'family_1080', 'family_1106', 'family_1220',
'fleischart_15474', 'serie_44736',
'vendor_1255', 'vendor_357', 'vendor_666',
'family_1074', 'family_1225', 'family_1266',
'serie_27405', 'vendor_1555', 'vendor_1577',
'vendor_224', 'vendor_752', 'family_1173',
'family_1226', 'family_1246', 'family_1265',
'fischart_36125', 'fischart_37803',
'fischart_43299', 'fischart_54243',
'fischart_54516', 'fischart_54769',
'fleischart_30153', 'fleischart_47539',
'netto_fuellmenge_filter_5', 'serie_39534',
'serie_39537', 'serie_39540', 'serie_41382',
'serie_55386', 'vendor_1141', 'vendor_1179',
'vendor_1316', 'vendor_1383', 'vendor_1463',
'vendor_1506', 'vendor_1660', 'vendor_519',
'vendor_621', 'vendor_664', 'vendor_750',
'vendor_874', 'vendor_914', 'vendor_981'
)
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_1','freezebox_filter_3','sparset_filter_0','fleischart_15470','vendor_531','family_1078','family_1286','family_1072','vendor_42','family_1035','family_1101','fischart_29660','vendor_751','fischart_29998','family_1080','family_1106','family_1220','fleischart_15474','serie_44736','vendor_1255','vendor_357','vendor_666','family_1074','family_1225','family_1266','serie_27405','vendor_1555','vendor_1577','vendor_224','vendor_752','family_1173','family_1226','family_1246','family_1265','fischart_36125','fischart_37803','fischart_43299','fischart_54243','fischart_54516','fischart_54769','fleischart_30153','fleischart_47539','netto_fuellmenge_filter_5','serie_39534','serie_39537','serie_39540','serie_41382','serie_55386','vendor_1141','vendor_1179','vendor_1316','vendor_1383','vendor_1463','vendor_1506','vendor_1660','vendor_519','vendor_621','vendor_664','vendor_750','vendor_874','vendor_914','vendor_981') AND a.is_filterable = true;
|