| 3 |
0.24 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','anwendungsgebiet_30890','netto_fuellmenge_filter_3','netto_fuellmenge_filter_1','vendor_873','haar_typ_1819','family_491','netto_fuellmenge_filter_2','netto_fuellmenge_filter_4','anwendungsgebiet_30919','family_270','netto_fuellmenge_filter_5','vendor_46','family_222','family_526','vendor_879','haar_typ_1823','family_255','vendor_476','vendor_1040','hauttyp_353','vendor_840','anwendungsgebiet_30918','hauttyp_355','family_231','hauttyp_357','family_970','vendor_1434','vendor_598','hauttyp_2285','serie_29565','vendor_137','netto_fuellmenge_filter_6','vendor_1367','serie_50789','family_291','vendor_1425','family_418','haar_typ_2291','vendor_29','family_1155','family_214','serie_54615','vendor_1399','vendor_388','family_250','vendor_1209','vendor_1502','family_230','family_237','family_290','serie_54624','vendor_1469','vendor_546','vendor_847','anwendungsgebiet_44681','family_216','family_217','family_525','serie_54623','vendor_1589','family_675','hauttyp_354','serie_46060','vendor_1335','vendor_469','serie_56621','vendor_1393','family_276','family_997','serie_43553','serie_53220','vendor_1098','vendor_712','vendor_1614','vendor_1626','anwendungsgebiet_30905','family_233','family_242','family_271','family_474','haar_typ_1822','serie_42641','vendor_1468','vendor_1615','anwendungsgebiet_37352','anwendungsgebiet_38538','coolbox_filter_0','family_253','freezebox_filter_3','serie_42639','serie_54622','serie_56953','serie_57779','vendor_1140','vendor_1501','vendor_849','family_243','family_245','family_306','family_629','serie_55385','serie_56311','serie_56317','serie_56832','serie_57082','vendor_1042','vendor_16','vendor_1613','vendor_1625','vendor_1644','vendor_1647','vendor_1653','vendor_422','anwendungsgebiet_30908','anwendungsgebiet_30912','anwendungsgebiet_33918','anwendungsgebiet_36414','anwendungsgebiet_37078','family_1207','family_227','family_292','family_985','haar_typ_36328','hauttyp_352','materialgruppierung_1524','serie_42627','serie_42642','serie_45475','serie_54613','serie_56316','serie_57369','vendor_1101','vendor_1599','vendor_1628','vendor_43','vendor_603','vendor_710','vendor_876','vendor_878','anwendungsgebiet_53765','family_299','family_490','family_575','hauttyp_360','serie_48829','serie_53022','serie_55819','serie_55822','serie_56160','serie_57083','sparset_filter_1','vendor_1062','vendor_1401','vendor_56','vendor_676','anwendungsgebiet_30909','anwendungsgebiet_36174','durchmesser_17523','durchmesser_3495','family_1041','family_190','family_244','family_281','family_325','family_441','family_450','family_459','family_487','family_691','family_714','form_2153','form_2157','grossen_31045','grossen_53509','grossen_53536','grossen_53539','haar_typ_1820','haar_typ_1821','haar_typ_1824','inschrift_47123','materialgruppierung_17837','materialgruppierung_53538','materialgruppierung_5629','materialgruppierung_56713','netto_fuellmenge_filter_7','netto_fuellmenge_filter_8','serie_42658','serie_48828','serie_53032','serie_54616','serie_54815','serie_56190','serie_56314','serie_56315','serie_56974','vendor_1108','vendor_1244','vendor_1391','vendor_1400','vendor_1454','vendor_1571','vendor_1632','vendor_497','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',
'anwendungsgebiet_30890',
'netto_fuellmenge_filter_3',
'netto_fuellmenge_filter_1',
'vendor_873',
'haar_typ_1819',
'family_491',
'netto_fuellmenge_filter_2',
'netto_fuellmenge_filter_4',
'anwendungsgebiet_30919',
'family_270',
'netto_fuellmenge_filter_5',
'vendor_46',
'family_222',
'family_526',
'vendor_879',
'haar_typ_1823',
'family_255',
'vendor_476',
'vendor_1040',
'hauttyp_353',
'vendor_840',
'anwendungsgebiet_30918',
'hauttyp_355',
'family_231',
'hauttyp_357',
'family_970',
'vendor_1434',
'vendor_598',
'hauttyp_2285',
'serie_29565',
'vendor_137',
'netto_fuellmenge_filter_6',
'vendor_1367',
'serie_50789',
'family_291',
'vendor_1425',
'family_418',
'haar_typ_2291',
'vendor_29',
'family_1155',
'family_214',
'serie_54615',
'vendor_1399',
'vendor_388',
'family_250',
'vendor_1209',
'vendor_1502',
'family_230',
'family_237',
'family_290',
'serie_54624',
'vendor_1469',
'vendor_546',
'vendor_847',
'anwendungsgebiet_44681',
'family_216',
'family_217',
'family_525',
'serie_54623',
'vendor_1589',
'family_675',
'hauttyp_354',
'serie_46060',
'vendor_1335',
'vendor_469',
'serie_56621',
'vendor_1393',
'family_276',
'family_997',
'serie_43553',
'serie_53220',
'vendor_1098',
'vendor_712',
'vendor_1614',
'vendor_1626',
'anwendungsgebiet_30905',
'family_233',
'family_242',
'family_271',
'family_474',
'haar_typ_1822',
'serie_42641',
'vendor_1468',
'vendor_1615',
'anwendungsgebiet_37352',
'anwendungsgebiet_38538',
'coolbox_filter_0',
'family_253',
'freezebox_filter_3',
'serie_42639',
'serie_54622',
'serie_56953',
'serie_57779',
'vendor_1140',
'vendor_1501',
'vendor_849',
'family_243',
'family_245',
'family_306',
'family_629',
'serie_55385',
'serie_56311',
'serie_56317',
'serie_56832',
'serie_57082',
'vendor_1042',
'vendor_16',
'vendor_1613',
'vendor_1625',
'vendor_1644',
'vendor_1647',
'vendor_1653',
'vendor_422',
'anwendungsgebiet_30908',
'anwendungsgebiet_30912',
'anwendungsgebiet_33918',
'anwendungsgebiet_36414',
'anwendungsgebiet_37078',
'family_1207',
'family_227',
'family_292',
'family_985',
'haar_typ_36328',
'hauttyp_352',
'materialgruppierung_1524',
'serie_42627',
'serie_42642',
'serie_45475',
'serie_54613',
'serie_56316',
'serie_57369',
'vendor_1101',
'vendor_1599',
'vendor_1628',
'vendor_43',
'vendor_603',
'vendor_710',
'vendor_876',
'vendor_878',
'anwendungsgebiet_53765',
'family_299',
'family_490',
'family_575',
'hauttyp_360',
'serie_48829',
'serie_53022',
'serie_55819',
'serie_55822',
'serie_56160',
'serie_57083',
'sparset_filter_1',
'vendor_1062',
'vendor_1401',
'vendor_56',
'vendor_676',
'anwendungsgebiet_30909',
'anwendungsgebiet_36174',
'durchmesser_17523',
'durchmesser_3495',
'family_1041',
'family_190',
'family_244',
'family_281',
'family_325',
'family_441',
'family_450',
'family_459',
'family_487',
'family_691',
'family_714',
'form_2153',
'form_2157',
'grossen_31045',
'grossen_53509',
'grossen_53536',
'grossen_53539',
'haar_typ_1820',
'haar_typ_1821',
'haar_typ_1824',
'inschrift_47123',
'materialgruppierung_17837',
'materialgruppierung_53538',
'materialgruppierung_5629',
'materialgruppierung_56713',
'netto_fuellmenge_filter_7',
'netto_fuellmenge_filter_8',
'serie_42658',
'serie_48828',
'serie_53032',
'serie_54616',
'serie_54815',
'serie_56190',
'serie_56314',
'serie_56315',
'serie_56974',
'vendor_1108',
'vendor_1244',
'vendor_1391',
'vendor_1400',
'vendor_1454',
'vendor_1571',
'vendor_1632',
'vendor_497',
'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','anwendungsgebiet_30890','netto_fuellmenge_filter_3','netto_fuellmenge_filter_1','vendor_873','haar_typ_1819','family_491','netto_fuellmenge_filter_2','netto_fuellmenge_filter_4','anwendungsgebiet_30919','family_270','netto_fuellmenge_filter_5','vendor_46','family_222','family_526','vendor_879','haar_typ_1823','family_255','vendor_476','vendor_1040','hauttyp_353','vendor_840','anwendungsgebiet_30918','hauttyp_355','family_231','hauttyp_357','family_970','vendor_1434','vendor_598','hauttyp_2285','serie_29565','vendor_137','netto_fuellmenge_filter_6','vendor_1367','serie_50789','family_291','vendor_1425','family_418','haar_typ_2291','vendor_29','family_1155','family_214','serie_54615','vendor_1399','vendor_388','family_250','vendor_1209','vendor_1502','family_230','family_237','family_290','serie_54624','vendor_1469','vendor_546','vendor_847','anwendungsgebiet_44681','family_216','family_217','family_525','serie_54623','vendor_1589','family_675','hauttyp_354','serie_46060','vendor_1335','vendor_469','serie_56621','vendor_1393','family_276','family_997','serie_43553','serie_53220','vendor_1098','vendor_712','vendor_1614','vendor_1626','anwendungsgebiet_30905','family_233','family_242','family_271','family_474','haar_typ_1822','serie_42641','vendor_1468','vendor_1615','anwendungsgebiet_37352','anwendungsgebiet_38538','coolbox_filter_0','family_253','freezebox_filter_3','serie_42639','serie_54622','serie_56953','serie_57779','vendor_1140','vendor_1501','vendor_849','family_243','family_245','family_306','family_629','serie_55385','serie_56311','serie_56317','serie_56832','serie_57082','vendor_1042','vendor_16','vendor_1613','vendor_1625','vendor_1644','vendor_1647','vendor_1653','vendor_422','anwendungsgebiet_30908','anwendungsgebiet_30912','anwendungsgebiet_33918','anwendungsgebiet_36414','anwendungsgebiet_37078','family_1207','family_227','family_292','family_985','haar_typ_36328','hauttyp_352','materialgruppierung_1524','serie_42627','serie_42642','serie_45475','serie_54613','serie_56316','serie_57369','vendor_1101','vendor_1599','vendor_1628','vendor_43','vendor_603','vendor_710','vendor_876','vendor_878','anwendungsgebiet_53765','family_299','family_490','family_575','hauttyp_360','serie_48829','serie_53022','serie_55819','serie_55822','serie_56160','serie_57083','sparset_filter_1','vendor_1062','vendor_1401','vendor_56','vendor_676','anwendungsgebiet_30909','anwendungsgebiet_36174','durchmesser_17523','durchmesser_3495','family_1041','family_190','family_244','family_281','family_325','family_441','family_450','family_459','family_487','family_691','family_714','form_2153','form_2157','grossen_31045','grossen_53509','grossen_53536','grossen_53539','haar_typ_1820','haar_typ_1821','haar_typ_1824','inschrift_47123','materialgruppierung_17837','materialgruppierung_53538','materialgruppierung_5629','materialgruppierung_56713','netto_fuellmenge_filter_7','netto_fuellmenge_filter_8','serie_42658','serie_48828','serie_53032','serie_54616','serie_54815','serie_56190','serie_56314','serie_56315','serie_56974','vendor_1108','vendor_1244','vendor_1391','vendor_1400','vendor_1454','vendor_1571','vendor_1632','vendor_497','vendor_886') AND a.is_filterable = true;
|