| 3 |
0.14 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','anwendungsgebiet_30910','hauttyp_351','family_238','netto_fuellmenge_filter_3','family_491','vendor_879','netto_fuellmenge_filter_2','netto_fuellmenge_filter_4','family_255','netto_fuellmenge_filter_1','anwendungsgebiet_30906','serie_29565','vendor_137','family_231','netto_fuellmenge_filter_5','family_970','vendor_29','hauttyp_353','anwendungsgebiet_30919','serie_56621','vendor_46','vendor_469','vendor_1040','vendor_1434','vendor_847','vendor_873','hauttyp_357','serie_54615','family_217','family_237','family_306','family_525','vendor_16','vendor_1647','anwendungsgebiet_30890','family_242','hauttyp_355','haar_typ_1819','vendor_1062','vendor_1209','vendor_43','vendor_710','vendor_840','family_230','family_244','family_985','hauttyp_2285','serie_50789','serie_56190','serie_56314','serie_56315','vendor_1244','vendor_1425','vendor_1502','vendor_388','vendor_476','vendor_546','vendor_712','vendor_886') 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', 'anwendungsgebiet_30910',
'hauttyp_351', 'family_238', 'netto_fuellmenge_filter_3',
'family_491', 'vendor_879', 'netto_fuellmenge_filter_2',
'netto_fuellmenge_filter_4', 'family_255',
'netto_fuellmenge_filter_1', 'anwendungsgebiet_30906',
'serie_29565', 'vendor_137', 'family_231',
'netto_fuellmenge_filter_5', 'family_970',
'vendor_29', 'hauttyp_353', 'anwendungsgebiet_30919',
'serie_56621', 'vendor_46', 'vendor_469',
'vendor_1040', 'vendor_1434', 'vendor_847',
'vendor_873', 'hauttyp_357', 'serie_54615',
'family_217', 'family_237', 'family_306',
'family_525', 'vendor_16', 'vendor_1647',
'anwendungsgebiet_30890', 'family_242',
'hauttyp_355', 'haar_typ_1819',
'vendor_1062', 'vendor_1209', 'vendor_43',
'vendor_710', 'vendor_840', 'family_230',
'family_244', 'family_985', 'hauttyp_2285',
'serie_50789', 'serie_56190', 'serie_56314',
'serie_56315', 'vendor_1244', 'vendor_1425',
'vendor_1502', 'vendor_388', 'vendor_476',
'vendor_546', 'vendor_712', 'vendor_886'
)
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','anwendungsgebiet_30910','hauttyp_351','family_238','netto_fuellmenge_filter_3','family_491','vendor_879','netto_fuellmenge_filter_2','netto_fuellmenge_filter_4','family_255','netto_fuellmenge_filter_1','anwendungsgebiet_30906','serie_29565','vendor_137','family_231','netto_fuellmenge_filter_5','family_970','vendor_29','hauttyp_353','anwendungsgebiet_30919','serie_56621','vendor_46','vendor_469','vendor_1040','vendor_1434','vendor_847','vendor_873','hauttyp_357','serie_54615','family_217','family_237','family_306','family_525','vendor_16','vendor_1647','anwendungsgebiet_30890','family_242','hauttyp_355','haar_typ_1819','vendor_1062','vendor_1209','vendor_43','vendor_710','vendor_840','family_230','family_244','family_985','hauttyp_2285','serie_50789','serie_56190','serie_56314','serie_56315','vendor_1244','vendor_1425','vendor_1502','vendor_388','vendor_476','vendor_546','vendor_712','vendor_886') AND a.is_filterable = true;
|