| 4 |
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('family_685','netto_gewicht_filter_5','art_2163','art_30399','verpackung_36357','fleischart_15470','vendor_458','coolbox_filter_0','freezebox_filter_3','fleischart_15474','family_920','fischart_29659','pastete_sorten_29725','family_971','verpackung_5933','getreideart_15473','netto_gewicht_filter_7','family_690','netto_gewicht_filter_4','verpackung_2954','netto_gewicht_filter_6','family_683','art_51800','art_51799','verpackung_27725','fettanteil_52859','family_1234','verpackung_2870','freezebox_filter_2','netto_gewicht_filter_3','verpackung_24689','family_1212','verpackung_35918','fuellung_51115','fuellung_51125','laenderkueche_36350','verpackung_26798','family_688','geschmack_26601','geschmack_23761','geschmack_26932','geschmack_36009','family_1045','verpackung_4205','family_1233','verpackung_4003','geschmack_23753','family_687','verpackung_3121','geschmack_36384','fuellung_39832','art_29786','family_1211','fleischart_47539','family_1209','netto_fuellmenge_filter_5','family_1210','fuellung_39590','laenderkueche_36352','family_684','fischart_29661','art_29787','family_921','handelsform_3534','serie_54749','family_973','getreideart_15476','fischart_29740','geschmack_43102','family_1049','netto_gewicht_filter_2','geschmack_23770','geschmack_54213','fettanteil_43969','family_689','verpackung_3948','family_693','geschmack_29768','fuellung_36365','anzahl_der_portionen_35938','family_1102','getreideart_23711','geschmack_25688','family_711','family_1213','laenderkueche_36349','geschmack_23783','geschmack_39953','geschmack_52741','netto_fuellmenge_filter_4','geschmack_54341','family_1214','fuellung_51141','laenderkueche_36361','geschmack_23758','family_1215','fuellung_51117','fuellung_52846','family_1254','family_999','art_54870','geschmack_36380','family_755','art_30396','laenderkueche_36355','art_54630','family_1256','art_51286','family_1036','art_14443','family_850','geschmack_29765','art_56215','fettanteil_55626','family_1033','art_54636','fuellung_29777','family_1028','laenderkueche_36354','family_1249','art_29788','fuellung_54104','getreideart_25278','family_1168','fuellung_36388','family_932','geschmack_26605','geschmack_35745','fuellung_39488','family_462','art_37143','verpackung_38799','handelsform_5911','family_1275','fischart_35526','family_1228','netto_gewicht_filter_1','art_54637','fuellung_54798','art_29789','family_1002','art_27151','geschmack_23757','family_789','family_1264','art_55980') 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(
'family_685',
'netto_gewicht_filter_5',
'art_2163',
'art_30399',
'verpackung_36357',
'fleischart_15470',
'vendor_458',
'coolbox_filter_0',
'freezebox_filter_3',
'fleischart_15474',
'family_920',
'fischart_29659',
'pastete_sorten_29725',
'family_971',
'verpackung_5933',
'getreideart_15473',
'netto_gewicht_filter_7',
'family_690',
'netto_gewicht_filter_4',
'verpackung_2954',
'netto_gewicht_filter_6',
'family_683',
'art_51800',
'art_51799',
'verpackung_27725',
'fettanteil_52859',
'family_1234',
'verpackung_2870',
'freezebox_filter_2',
'netto_gewicht_filter_3',
'verpackung_24689',
'family_1212',
'verpackung_35918',
'fuellung_51115',
'fuellung_51125',
'laenderkueche_36350',
'verpackung_26798',
'family_688',
'geschmack_26601',
'geschmack_23761',
'geschmack_26932',
'geschmack_36009',
'family_1045',
'verpackung_4205',
'family_1233',
'verpackung_4003',
'geschmack_23753',
'family_687',
'verpackung_3121',
'geschmack_36384',
'fuellung_39832',
'art_29786',
'family_1211',
'fleischart_47539',
'family_1209',
'netto_fuellmenge_filter_5',
'family_1210',
'fuellung_39590',
'laenderkueche_36352',
'family_684',
'fischart_29661',
'art_29787',
'family_921',
'handelsform_3534',
'serie_54749',
'family_973',
'getreideart_15476',
'fischart_29740',
'geschmack_43102',
'family_1049',
'netto_gewicht_filter_2',
'geschmack_23770',
'geschmack_54213',
'fettanteil_43969',
'family_689',
'verpackung_3948',
'family_693',
'geschmack_29768',
'fuellung_36365',
'anzahl_der_portionen_35938',
'family_1102',
'getreideart_23711',
'geschmack_25688',
'family_711',
'family_1213',
'laenderkueche_36349',
'geschmack_23783',
'geschmack_39953',
'geschmack_52741',
'netto_fuellmenge_filter_4',
'geschmack_54341',
'family_1214',
'fuellung_51141',
'laenderkueche_36361',
'geschmack_23758',
'family_1215',
'fuellung_51117',
'fuellung_52846',
'family_1254',
'family_999',
'art_54870',
'geschmack_36380',
'family_755',
'art_30396',
'laenderkueche_36355',
'art_54630',
'family_1256',
'art_51286',
'family_1036',
'art_14443',
'family_850',
'geschmack_29765',
'art_56215',
'fettanteil_55626',
'family_1033',
'art_54636',
'fuellung_29777',
'family_1028',
'laenderkueche_36354',
'family_1249',
'art_29788',
'fuellung_54104',
'getreideart_25278',
'family_1168',
'fuellung_36388',
'family_932',
'geschmack_26605',
'geschmack_35745',
'fuellung_39488',
'family_462',
'art_37143',
'verpackung_38799',
'handelsform_5911',
'family_1275',
'fischart_35526',
'family_1228',
'netto_gewicht_filter_1',
'art_54637',
'fuellung_54798',
'art_29789',
'family_1002',
'art_27151',
'geschmack_23757',
'family_789',
'family_1264',
'art_55980'
)
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('family_685','netto_gewicht_filter_5','art_2163','art_30399','verpackung_36357','fleischart_15470','vendor_458','coolbox_filter_0','freezebox_filter_3','fleischart_15474','family_920','fischart_29659','pastete_sorten_29725','family_971','verpackung_5933','getreideart_15473','netto_gewicht_filter_7','family_690','netto_gewicht_filter_4','verpackung_2954','netto_gewicht_filter_6','family_683','art_51800','art_51799','verpackung_27725','fettanteil_52859','family_1234','verpackung_2870','freezebox_filter_2','netto_gewicht_filter_3','verpackung_24689','family_1212','verpackung_35918','fuellung_51115','fuellung_51125','laenderkueche_36350','verpackung_26798','family_688','geschmack_26601','geschmack_23761','geschmack_26932','geschmack_36009','family_1045','verpackung_4205','family_1233','verpackung_4003','geschmack_23753','family_687','verpackung_3121','geschmack_36384','fuellung_39832','art_29786','family_1211','fleischart_47539','family_1209','netto_fuellmenge_filter_5','family_1210','fuellung_39590','laenderkueche_36352','family_684','fischart_29661','art_29787','family_921','handelsform_3534','serie_54749','family_973','getreideart_15476','fischart_29740','geschmack_43102','family_1049','netto_gewicht_filter_2','geschmack_23770','geschmack_54213','fettanteil_43969','family_689','verpackung_3948','family_693','geschmack_29768','fuellung_36365','anzahl_der_portionen_35938','family_1102','getreideart_23711','geschmack_25688','family_711','family_1213','laenderkueche_36349','geschmack_23783','geschmack_39953','geschmack_52741','netto_fuellmenge_filter_4','geschmack_54341','family_1214','fuellung_51141','laenderkueche_36361','geschmack_23758','family_1215','fuellung_51117','fuellung_52846','family_1254','family_999','art_54870','geschmack_36380','family_755','art_30396','laenderkueche_36355','art_54630','family_1256','art_51286','family_1036','art_14443','family_850','geschmack_29765','art_56215','fettanteil_55626','family_1033','art_54636','fuellung_29777','family_1028','laenderkueche_36354','family_1249','art_29788','fuellung_54104','getreideart_25278','family_1168','fuellung_36388','family_932','geschmack_26605','geschmack_35745','fuellung_39488','family_462','art_37143','verpackung_38799','handelsform_5911','family_1275','fischart_35526','family_1228','netto_gewicht_filter_1','art_54637','fuellung_54798','art_29789','family_1002','art_27151','geschmack_23757','family_789','family_1264','art_55980') AND a.is_filterable = true;
|