| 3 |
0.19 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','hauttyp_351','anwendungsgebiet_30910','family_238','vendor_879','netto_fuellmenge_filter_2','family_255','netto_fuellmenge_filter_3','family_231','netto_fuellmenge_filter_1','anwendungsgebiet_30918','serie_29565','vendor_137','netto_fuellmenge_filter_4','vendor_1335','vendor_476','anwendungsgebiet_30906','vendor_873','serie_55259','serie_56953','vendor_847','vendor_878','anwendungsgebiet_30919','vendor_1140','vendor_1244','vendor_16','family_491','hauttyp_353','hauttyp_355','vendor_43','anwendungsgebiet_36414','serie_54615','vendor_1062','vendor_1502','vendor_546','vendor_712','anwendungsgebiet_30890','anwendungsgebiet_33918','anwendungsgebiet_38538','netto_fuellmenge_filter_5','sparset_filter_1','vendor_1209','vendor_1571','vendor_1622','vendor_1627','vendor_655','vendor_840','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', 'hauttyp_351',
'anwendungsgebiet_30910', 'family_238',
'vendor_879', 'netto_fuellmenge_filter_2',
'family_255', 'netto_fuellmenge_filter_3',
'family_231', 'netto_fuellmenge_filter_1',
'anwendungsgebiet_30918', 'serie_29565',
'vendor_137', 'netto_fuellmenge_filter_4',
'vendor_1335', 'vendor_476', 'anwendungsgebiet_30906',
'vendor_873', 'serie_55259', 'serie_56953',
'vendor_847', 'vendor_878', 'anwendungsgebiet_30919',
'vendor_1140', 'vendor_1244', 'vendor_16',
'family_491', 'hauttyp_353', 'hauttyp_355',
'vendor_43', 'anwendungsgebiet_36414',
'serie_54615', 'vendor_1062', 'vendor_1502',
'vendor_546', 'vendor_712', 'anwendungsgebiet_30890',
'anwendungsgebiet_33918', 'anwendungsgebiet_38538',
'netto_fuellmenge_filter_5', 'sparset_filter_1',
'vendor_1209', 'vendor_1571', 'vendor_1622',
'vendor_1627', 'vendor_655', 'vendor_840',
'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','hauttyp_351','anwendungsgebiet_30910','family_238','vendor_879','netto_fuellmenge_filter_2','family_255','netto_fuellmenge_filter_3','family_231','netto_fuellmenge_filter_1','anwendungsgebiet_30918','serie_29565','vendor_137','netto_fuellmenge_filter_4','vendor_1335','vendor_476','anwendungsgebiet_30906','vendor_873','serie_55259','serie_56953','vendor_847','vendor_878','anwendungsgebiet_30919','vendor_1140','vendor_1244','vendor_16','family_491','hauttyp_353','hauttyp_355','vendor_43','anwendungsgebiet_36414','serie_54615','vendor_1062','vendor_1502','vendor_546','vendor_712','anwendungsgebiet_30890','anwendungsgebiet_33918','anwendungsgebiet_38538','netto_fuellmenge_filter_5','sparset_filter_1','vendor_1209','vendor_1571','vendor_1622','vendor_1627','vendor_655','vendor_840','vendor_886') AND a.is_filterable = true;
|