| 3 |
0.12 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_270','anwendungsgebiet_30919','vendor_1040','netto_fuellmenge_filter_4','vendor_873','anwendungsgebiet_30890','family_491','haar_typ_1819','netto_fuellmenge_filter_5','family_230','serie_54623','hauttyp_355','serie_54615','vendor_1367','netto_fuellmenge_filter_3','vendor_1615','vendor_1209','anwendungsgebiet_30906','family_231','hauttyp_357','vendor_546','hauttyp_353','netto_fuellmenge_filter_6','serie_54613','vendor_1101','vendor_876','vendor_1434','vendor_1647','vendor_29','anwendungsgebiet_36174','family_325','form_2157','grossen_53509','hauttyp_354','inschrift_47123','netto_fuellmenge_filter_1','serie_54616','sparset_filter_1','vendor_1042','vendor_1108','vendor_1425','vendor_469','vendor_676') 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_270',
'anwendungsgebiet_30919', 'vendor_1040',
'netto_fuellmenge_filter_4', 'vendor_873',
'anwendungsgebiet_30890', 'family_491',
'haar_typ_1819', 'netto_fuellmenge_filter_5',
'family_230', 'serie_54623', 'hauttyp_355',
'serie_54615', 'vendor_1367', 'netto_fuellmenge_filter_3',
'vendor_1615', 'vendor_1209', 'anwendungsgebiet_30906',
'family_231', 'hauttyp_357', 'vendor_546',
'hauttyp_353', 'netto_fuellmenge_filter_6',
'serie_54613', 'vendor_1101', 'vendor_876',
'vendor_1434', 'vendor_1647', 'vendor_29',
'anwendungsgebiet_36174', 'family_325',
'form_2157', 'grossen_53509', 'hauttyp_354',
'inschrift_47123', 'netto_fuellmenge_filter_1',
'serie_54616', 'sparset_filter_1',
'vendor_1042', 'vendor_1108', 'vendor_1425',
'vendor_469', 'vendor_676'
)
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_270','anwendungsgebiet_30919','vendor_1040','netto_fuellmenge_filter_4','vendor_873','anwendungsgebiet_30890','family_491','haar_typ_1819','netto_fuellmenge_filter_5','family_230','serie_54623','hauttyp_355','serie_54615','vendor_1367','netto_fuellmenge_filter_3','vendor_1615','vendor_1209','anwendungsgebiet_30906','family_231','hauttyp_357','vendor_546','hauttyp_353','netto_fuellmenge_filter_6','serie_54613','vendor_1101','vendor_876','vendor_1434','vendor_1647','vendor_29','anwendungsgebiet_36174','family_325','form_2157','grossen_53509','hauttyp_354','inschrift_47123','netto_fuellmenge_filter_1','serie_54616','sparset_filter_1','vendor_1042','vendor_1108','vendor_1425','vendor_469','vendor_676') AND a.is_filterable = true;
|