| 3 |
0.20 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_30890','family_238','haar_typ_1819','netto_fuellmenge_filter_3','vendor_873','family_270','anwendungsgebiet_30919','vendor_476','anwendungsgebiet_30906','netto_fuellmenge_filter_4','family_222','netto_fuellmenge_filter_5','netto_fuellmenge_filter_6','vendor_1367','family_970','netto_fuellmenge_filter_2','serie_54623','serie_54624','vendor_879','haar_typ_1823','anwendungsgebiet_30918','haar_typ_2291','serie_53220','serie_54615','vendor_1098','hauttyp_355','serie_56621','vendor_469','anwendungsgebiet_44681','family_216','family_217','family_237','family_250','hauttyp_353','netto_fuellmenge_filter_1','serie_42641','vendor_1040','vendor_1140','vendor_388','vendor_840','vendor_847','family_1155','family_214','family_231','family_255','family_306','serie_29565','serie_42639','serie_46060','serie_54613','vendor_137','vendor_29','vendor_598','vendor_876','netto_fuellmenge_filter_7','netto_fuellmenge_filter_8') 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_30890',
'family_238', 'haar_typ_1819', 'netto_fuellmenge_filter_3',
'vendor_873', 'family_270', 'anwendungsgebiet_30919',
'vendor_476', 'anwendungsgebiet_30906',
'netto_fuellmenge_filter_4', 'family_222',
'netto_fuellmenge_filter_5', 'netto_fuellmenge_filter_6',
'vendor_1367', 'family_970', 'netto_fuellmenge_filter_2',
'serie_54623', 'serie_54624', 'vendor_879',
'haar_typ_1823', 'anwendungsgebiet_30918',
'haar_typ_2291', 'serie_53220',
'serie_54615', 'vendor_1098', 'hauttyp_355',
'serie_56621', 'vendor_469', 'anwendungsgebiet_44681',
'family_216', 'family_217', 'family_237',
'family_250', 'hauttyp_353', 'netto_fuellmenge_filter_1',
'serie_42641', 'vendor_1040', 'vendor_1140',
'vendor_388', 'vendor_840', 'vendor_847',
'family_1155', 'family_214', 'family_231',
'family_255', 'family_306', 'serie_29565',
'serie_42639', 'serie_46060', 'serie_54613',
'vendor_137', 'vendor_29', 'vendor_598',
'vendor_876', 'netto_fuellmenge_filter_7',
'netto_fuellmenge_filter_8'
)
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_30890','family_238','haar_typ_1819','netto_fuellmenge_filter_3','vendor_873','family_270','anwendungsgebiet_30919','vendor_476','anwendungsgebiet_30906','netto_fuellmenge_filter_4','family_222','netto_fuellmenge_filter_5','netto_fuellmenge_filter_6','vendor_1367','family_970','netto_fuellmenge_filter_2','serie_54623','serie_54624','vendor_879','haar_typ_1823','anwendungsgebiet_30918','haar_typ_2291','serie_53220','serie_54615','vendor_1098','hauttyp_355','serie_56621','vendor_469','anwendungsgebiet_44681','family_216','family_217','family_237','family_250','hauttyp_353','netto_fuellmenge_filter_1','serie_42641','vendor_1040','vendor_1140','vendor_388','vendor_840','vendor_847','family_1155','family_214','family_231','family_255','family_306','serie_29565','serie_42639','serie_46060','serie_54613','vendor_137','vendor_29','vendor_598','vendor_876','netto_fuellmenge_filter_7','netto_fuellmenge_filter_8') AND a.is_filterable = true;
|