| 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','anwendungsgebiet_30906','family_238','netto_fuellmenge_filter_3','netto_fuellmenge_filter_1','family_491','netto_fuellmenge_filter_2','vendor_46','anwendungsgebiet_30919','vendor_879','hauttyp_353','netto_fuellmenge_filter_4','anwendungsgebiet_30918','vendor_476','family_255','hauttyp_2285','vendor_1434','hauttyp_357','hauttyp_355','vendor_873','family_270','family_291','family_231','serie_29565','vendor_137','vendor_1399','vendor_29','netto_fuellmenge_filter_5','vendor_1469','family_970','hauttyp_354','serie_54615','serie_56621','vendor_1040','vendor_469','family_250','family_525','serie_53220','vendor_1098','anwendungsgebiet_30890','serie_54623','vendor_840','vendor_847','anwendungsgebiet_30905','family_233','family_242','haar_typ_1819','vendor_1425','vendor_1468','anwendungsgebiet_37352','family_217','family_290','serie_50789','vendor_849','family_237','family_243','family_245','family_253','family_306','family_418','serie_56311','serie_56317','vendor_1042','vendor_16','vendor_1613','vendor_1647','vendor_1653','anwendungsgebiet_30908','anwendungsgebiet_30912','anwendungsgebiet_37078','anwendungsgebiet_38538','family_1207','family_292','hauttyp_352','serie_45475','serie_56316','serie_57369','vendor_1209','vendor_1335','vendor_1625','vendor_1628','vendor_43','vendor_710','family_222','hauttyp_360','serie_48829','serie_53022','serie_55819','serie_55822','serie_56160','vendor_1062','vendor_1401','vendor_1502','vendor_1599','vendor_546','vendor_56','vendor_878','anwendungsgebiet_30909','anwendungsgebiet_36414','family_230','family_244','family_459','family_474','family_985','serie_43553','serie_48828','serie_53032','serie_54616','serie_54815','serie_56190','serie_56314','serie_56315','serie_56974','vendor_1101','vendor_1244','vendor_1391','vendor_1454','vendor_1571','vendor_1614','vendor_388','vendor_676','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', 'hauttyp_351',
'anwendungsgebiet_30910', 'anwendungsgebiet_30906',
'family_238', 'netto_fuellmenge_filter_3',
'netto_fuellmenge_filter_1', 'family_491',
'netto_fuellmenge_filter_2', 'vendor_46',
'anwendungsgebiet_30919', 'vendor_879',
'hauttyp_353', 'netto_fuellmenge_filter_4',
'anwendungsgebiet_30918', 'vendor_476',
'family_255', 'hauttyp_2285', 'vendor_1434',
'hauttyp_357', 'hauttyp_355', 'vendor_873',
'family_270', 'family_291', 'family_231',
'serie_29565', 'vendor_137', 'vendor_1399',
'vendor_29', 'netto_fuellmenge_filter_5',
'vendor_1469', 'family_970', 'hauttyp_354',
'serie_54615', 'serie_56621', 'vendor_1040',
'vendor_469', 'family_250', 'family_525',
'serie_53220', 'vendor_1098', 'anwendungsgebiet_30890',
'serie_54623', 'vendor_840', 'vendor_847',
'anwendungsgebiet_30905', 'family_233',
'family_242', 'haar_typ_1819', 'vendor_1425',
'vendor_1468', 'anwendungsgebiet_37352',
'family_217', 'family_290', 'serie_50789',
'vendor_849', 'family_237', 'family_243',
'family_245', 'family_253', 'family_306',
'family_418', 'serie_56311', 'serie_56317',
'vendor_1042', 'vendor_16', 'vendor_1613',
'vendor_1647', 'vendor_1653', 'anwendungsgebiet_30908',
'anwendungsgebiet_30912', 'anwendungsgebiet_37078',
'anwendungsgebiet_38538', 'family_1207',
'family_292', 'hauttyp_352', 'serie_45475',
'serie_56316', 'serie_57369', 'vendor_1209',
'vendor_1335', 'vendor_1625', 'vendor_1628',
'vendor_43', 'vendor_710', 'family_222',
'hauttyp_360', 'serie_48829', 'serie_53022',
'serie_55819', 'serie_55822', 'serie_56160',
'vendor_1062', 'vendor_1401', 'vendor_1502',
'vendor_1599', 'vendor_546', 'vendor_56',
'vendor_878', 'anwendungsgebiet_30909',
'anwendungsgebiet_36414', 'family_230',
'family_244', 'family_459', 'family_474',
'family_985', 'serie_43553', 'serie_48828',
'serie_53032', 'serie_54616', 'serie_54815',
'serie_56190', 'serie_56314', 'serie_56315',
'serie_56974', 'vendor_1101', 'vendor_1244',
'vendor_1391', 'vendor_1454', 'vendor_1571',
'vendor_1614', 'vendor_388', 'vendor_676',
'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','hauttyp_351','anwendungsgebiet_30910','anwendungsgebiet_30906','family_238','netto_fuellmenge_filter_3','netto_fuellmenge_filter_1','family_491','netto_fuellmenge_filter_2','vendor_46','anwendungsgebiet_30919','vendor_879','hauttyp_353','netto_fuellmenge_filter_4','anwendungsgebiet_30918','vendor_476','family_255','hauttyp_2285','vendor_1434','hauttyp_357','hauttyp_355','vendor_873','family_270','family_291','family_231','serie_29565','vendor_137','vendor_1399','vendor_29','netto_fuellmenge_filter_5','vendor_1469','family_970','hauttyp_354','serie_54615','serie_56621','vendor_1040','vendor_469','family_250','family_525','serie_53220','vendor_1098','anwendungsgebiet_30890','serie_54623','vendor_840','vendor_847','anwendungsgebiet_30905','family_233','family_242','haar_typ_1819','vendor_1425','vendor_1468','anwendungsgebiet_37352','family_217','family_290','serie_50789','vendor_849','family_237','family_243','family_245','family_253','family_306','family_418','serie_56311','serie_56317','vendor_1042','vendor_16','vendor_1613','vendor_1647','vendor_1653','anwendungsgebiet_30908','anwendungsgebiet_30912','anwendungsgebiet_37078','anwendungsgebiet_38538','family_1207','family_292','hauttyp_352','serie_45475','serie_56316','serie_57369','vendor_1209','vendor_1335','vendor_1625','vendor_1628','vendor_43','vendor_710','family_222','hauttyp_360','serie_48829','serie_53022','serie_55819','serie_55822','serie_56160','vendor_1062','vendor_1401','vendor_1502','vendor_1599','vendor_546','vendor_56','vendor_878','anwendungsgebiet_30909','anwendungsgebiet_36414','family_230','family_244','family_459','family_474','family_985','serie_43553','serie_48828','serie_53032','serie_54616','serie_54815','serie_56190','serie_56314','serie_56315','serie_56974','vendor_1101','vendor_1244','vendor_1391','vendor_1454','vendor_1571','vendor_1614','vendor_388','vendor_676','vendor_712','vendor_886') AND a.is_filterable = true;
|