| 3 |
0.15 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_30906','hauttyp_351','family_238','netto_fuellmenge_filter_1','netto_fuellmenge_filter_3','vendor_46','family_491','hauttyp_2285','anwendungsgebiet_30910','netto_fuellmenge_filter_2','family_291','hauttyp_353','vendor_1399','vendor_1434','hauttyp_355','vendor_476','vendor_1469','hauttyp_357','family_250','hauttyp_354','serie_53220','vendor_1098','anwendungsgebiet_30905','family_233','family_525','serie_56621','vendor_469','vendor_840','anwendungsgebiet_30919','serie_50789','family_243','family_245','family_253','netto_fuellmenge_filter_4','serie_56311','serie_56317','vendor_1613','vendor_1653','vendor_29','vendor_849','anwendungsgebiet_30908','anwendungsgebiet_30912','anwendungsgebiet_37078','anwendungsgebiet_38538','family_1207','family_242','family_292','family_306','hauttyp_352','serie_56316','serie_57369','vendor_1335','vendor_1625','family_231','hauttyp_360','serie_29565','serie_45475','serie_48829','serie_53022','serie_55819','serie_55822','serie_56160','vendor_1040','vendor_1401','vendor_1599','vendor_56','anwendungsgebiet_30890','anwendungsgebiet_30909','family_255','family_970','family_985','haar_typ_1819','netto_fuellmenge_filter_5','serie_43553','serie_48828','serie_53032','serie_54815','serie_56974','vendor_1244','vendor_137','vendor_1425','vendor_1454','vendor_1614','vendor_676','vendor_710','vendor_878','vendor_879') 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_30906',
'hauttyp_351', 'family_238', 'netto_fuellmenge_filter_1',
'netto_fuellmenge_filter_3', 'vendor_46',
'family_491', 'hauttyp_2285', 'anwendungsgebiet_30910',
'netto_fuellmenge_filter_2', 'family_291',
'hauttyp_353', 'vendor_1399', 'vendor_1434',
'hauttyp_355', 'vendor_476', 'vendor_1469',
'hauttyp_357', 'family_250', 'hauttyp_354',
'serie_53220', 'vendor_1098', 'anwendungsgebiet_30905',
'family_233', 'family_525', 'serie_56621',
'vendor_469', 'vendor_840', 'anwendungsgebiet_30919',
'serie_50789', 'family_243', 'family_245',
'family_253', 'netto_fuellmenge_filter_4',
'serie_56311', 'serie_56317', 'vendor_1613',
'vendor_1653', 'vendor_29', 'vendor_849',
'anwendungsgebiet_30908', 'anwendungsgebiet_30912',
'anwendungsgebiet_37078', 'anwendungsgebiet_38538',
'family_1207', 'family_242', 'family_292',
'family_306', 'hauttyp_352', 'serie_56316',
'serie_57369', 'vendor_1335', 'vendor_1625',
'family_231', 'hauttyp_360', 'serie_29565',
'serie_45475', 'serie_48829', 'serie_53022',
'serie_55819', 'serie_55822', 'serie_56160',
'vendor_1040', 'vendor_1401', 'vendor_1599',
'vendor_56', 'anwendungsgebiet_30890',
'anwendungsgebiet_30909', 'family_255',
'family_970', 'family_985', 'haar_typ_1819',
'netto_fuellmenge_filter_5', 'serie_43553',
'serie_48828', 'serie_53032', 'serie_54815',
'serie_56974', 'vendor_1244', 'vendor_137',
'vendor_1425', 'vendor_1454', 'vendor_1614',
'vendor_676', 'vendor_710', 'vendor_878',
'vendor_879'
)
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_30906','hauttyp_351','family_238','netto_fuellmenge_filter_1','netto_fuellmenge_filter_3','vendor_46','family_491','hauttyp_2285','anwendungsgebiet_30910','netto_fuellmenge_filter_2','family_291','hauttyp_353','vendor_1399','vendor_1434','hauttyp_355','vendor_476','vendor_1469','hauttyp_357','family_250','hauttyp_354','serie_53220','vendor_1098','anwendungsgebiet_30905','family_233','family_525','serie_56621','vendor_469','vendor_840','anwendungsgebiet_30919','serie_50789','family_243','family_245','family_253','netto_fuellmenge_filter_4','serie_56311','serie_56317','vendor_1613','vendor_1653','vendor_29','vendor_849','anwendungsgebiet_30908','anwendungsgebiet_30912','anwendungsgebiet_37078','anwendungsgebiet_38538','family_1207','family_242','family_292','family_306','hauttyp_352','serie_56316','serie_57369','vendor_1335','vendor_1625','family_231','hauttyp_360','serie_29565','serie_45475','serie_48829','serie_53022','serie_55819','serie_55822','serie_56160','vendor_1040','vendor_1401','vendor_1599','vendor_56','anwendungsgebiet_30890','anwendungsgebiet_30909','family_255','family_970','family_985','haar_typ_1819','netto_fuellmenge_filter_5','serie_43553','serie_48828','serie_53032','serie_54815','serie_56974','vendor_1244','vendor_137','vendor_1425','vendor_1454','vendor_1614','vendor_676','vendor_710','vendor_878','vendor_879') AND a.is_filterable = true;
|