| 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_30890','haar_typ_1819','family_222','haar_typ_1823','netto_fuellmenge_filter_3','netto_fuellmenge_filter_5','vendor_873','family_491','netto_fuellmenge_filter_4','vendor_840','family_970','haar_typ_2291','netto_fuellmenge_filter_2','netto_fuellmenge_filter_6','family_214','serie_50789','vendor_388','vendor_1367','serie_54624','anwendungsgebiet_44681','family_216','vendor_1502','hauttyp_351','anwendungsgebiet_30910','serie_43553','serie_54615','vendor_1614','vendor_1626','vendor_476','family_217','family_250','haar_typ_1822','serie_42641','vendor_1425','serie_42639','serie_55385','serie_56832','serie_57082','serie_57779','vendor_1140','vendor_1501','vendor_1644','family_227','haar_typ_36328','netto_fuellmenge_filter_1','serie_42627','serie_42642','family_230','family_490','family_525','hauttyp_353','hauttyp_357','materialgruppierung_1524','serie_57083','vendor_1040','vendor_1434','anwendungsgebiet_30906','anwendungsgebiet_30908','anwendungsgebiet_30909','anwendungsgebiet_33918','durchmesser_17523','durchmesser_3495','family_253','family_255','family_281','haar_typ_1820','haar_typ_1821','haar_typ_1824','netto_fuellmenge_filter_7','netto_fuellmenge_filter_8','serie_29565','serie_42658','vendor_1042','vendor_137','vendor_1469','vendor_1625','vendor_1632','vendor_847') 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_30890',
'haar_typ_1819', 'family_222', 'haar_typ_1823',
'netto_fuellmenge_filter_3', 'netto_fuellmenge_filter_5',
'vendor_873', 'family_491', 'netto_fuellmenge_filter_4',
'vendor_840', 'family_970', 'haar_typ_2291',
'netto_fuellmenge_filter_2', 'netto_fuellmenge_filter_6',
'family_214', 'serie_50789', 'vendor_388',
'vendor_1367', 'serie_54624', 'anwendungsgebiet_44681',
'family_216', 'vendor_1502', 'hauttyp_351',
'anwendungsgebiet_30910', 'serie_43553',
'serie_54615', 'vendor_1614', 'vendor_1626',
'vendor_476', 'family_217', 'family_250',
'haar_typ_1822', 'serie_42641',
'vendor_1425', 'serie_42639', 'serie_55385',
'serie_56832', 'serie_57082', 'serie_57779',
'vendor_1140', 'vendor_1501', 'vendor_1644',
'family_227', 'haar_typ_36328',
'netto_fuellmenge_filter_1', 'serie_42627',
'serie_42642', 'family_230', 'family_490',
'family_525', 'hauttyp_353', 'hauttyp_357',
'materialgruppierung_1524', 'serie_57083',
'vendor_1040', 'vendor_1434', 'anwendungsgebiet_30906',
'anwendungsgebiet_30908', 'anwendungsgebiet_30909',
'anwendungsgebiet_33918', 'durchmesser_17523',
'durchmesser_3495', 'family_253',
'family_255', 'family_281', 'haar_typ_1820',
'haar_typ_1821', 'haar_typ_1824',
'netto_fuellmenge_filter_7', 'netto_fuellmenge_filter_8',
'serie_29565', 'serie_42658', 'vendor_1042',
'vendor_137', 'vendor_1469', 'vendor_1625',
'vendor_1632', 'vendor_847'
)
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_30890','haar_typ_1819','family_222','haar_typ_1823','netto_fuellmenge_filter_3','netto_fuellmenge_filter_5','vendor_873','family_491','netto_fuellmenge_filter_4','vendor_840','family_970','haar_typ_2291','netto_fuellmenge_filter_2','netto_fuellmenge_filter_6','family_214','serie_50789','vendor_388','vendor_1367','serie_54624','anwendungsgebiet_44681','family_216','vendor_1502','hauttyp_351','anwendungsgebiet_30910','serie_43553','serie_54615','vendor_1614','vendor_1626','vendor_476','family_217','family_250','haar_typ_1822','serie_42641','vendor_1425','serie_42639','serie_55385','serie_56832','serie_57082','serie_57779','vendor_1140','vendor_1501','vendor_1644','family_227','haar_typ_36328','netto_fuellmenge_filter_1','serie_42627','serie_42642','family_230','family_490','family_525','hauttyp_353','hauttyp_357','materialgruppierung_1524','serie_57083','vendor_1040','vendor_1434','anwendungsgebiet_30906','anwendungsgebiet_30908','anwendungsgebiet_30909','anwendungsgebiet_33918','durchmesser_17523','durchmesser_3495','family_253','family_255','family_281','haar_typ_1820','haar_typ_1821','haar_typ_1824','netto_fuellmenge_filter_7','netto_fuellmenge_filter_8','serie_29565','serie_42658','vendor_1042','vendor_137','vendor_1469','vendor_1625','vendor_1632','vendor_847') AND a.is_filterable = true;
|