| 3 |
0.19 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('freezebox_filter_3','coolbox_filter_0','verpackung_4205','netto_gewicht_filter_4','netto_gewicht_filter_5','verpackung_36357','netto_gewicht_filter_3','verpackung_3840','family_684','family_683','laenderkueche_36352','art_2163','family_920','family_685','vendor_531','art_30399','art_51799','vendor_458','family_1026','vendor_224','fleischart_47539','fleischart_15470','vendor_114','fettanteil_52859','fischart_29659','vendor_386','netto_gewicht_filter_6','coolbox_filter_1','family_1027','family_778','typ_34174','family_986','fischart_29740','laenderkueche_36350','family_1028','fleischart_15474','vendor_1028','art_51800','verpackung_24689','verpackung_3121','pastete_sorten_29718','vendor_1191','fischart_35526','pastete_sorten_29725','family_1044','netto_gewicht_filter_2','serie_55241','vendor_1179','family_1031','family_1072','family_935','serie_39543','verpackung_3948','family_1033','laenderkueche_36354','netto_fuellmenge_filter_5','vendor_1160','vendor_402','vendor_728','pastete_sorten_29724','vendor_227','vendor_431','vendor_637','family_1269','family_1270','fleischart_47119','fleischart_54889','laenderkueche_48797','verpackung_2870','fettanteil_43969','fischart_29661','fleischart_54883','getreideart_15473','vendor_1119','vendor_1208','vendor_1374','vendor_348','vendor_944','art_56215','family_1115','fischart_29658','fischart_29999','pastete_sorten_29726','vendor_1355','vendor_403','vendor_404','vendor_914','family_1046','family_1074','family_686','fischart_29665','fischart_29998','fischart_52914','getreideart_15476','vendor_1025','vendor_1181','vendor_1372','vendor_1381','vendor_457','vendor_484','vendor_699','vendor_922','vendor_952','verpackung_26798','verpackung_27725','art_35238','fettanteil_52299','fettanteil_52300','fettanteil_54188','fettanteil_55626','fischart_30000','fleischart_15475','getreideart_23671','netto_fuellmenge_filter_4','netto_gewicht_filter_7','vendor_1064','vendor_1122','vendor_1322','vendor_1380','vendor_1388','vendor_1463','vendor_151','vendor_383','vendor_412','vendor_459','vendor_511','vendor_513','vendor_717','vendor_834','vendor_869','verpackung_42548','verpackung_4977','family_1030','family_1172','family_1274','fettanteil_53325','fettanteil_56095','fischart_29660','fischart_29663','getreideart_25278','laenderkueche_43012','laenderkueche_50808','netto_fuellmenge_filter_6','pastete_sorten_50587','vendor_1054','vendor_1106','vendor_118','vendor_1224','vendor_1255','vendor_1349','vendor_1353','vendor_1413','vendor_144','vendor_1473','vendor_1477','vendor_204','vendor_277','vendor_280','vendor_481','vendor_635','vendor_679','vendor_775','vendor_779','vendor_782','vendor_783','vendor_835','vendor_836','verpackung_35918','verpackung_5933') 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(
'freezebox_filter_3',
'coolbox_filter_0',
'verpackung_4205',
'netto_gewicht_filter_4',
'netto_gewicht_filter_5',
'verpackung_36357',
'netto_gewicht_filter_3',
'verpackung_3840',
'family_684',
'family_683',
'laenderkueche_36352',
'art_2163',
'family_920',
'family_685',
'vendor_531',
'art_30399',
'art_51799',
'vendor_458',
'family_1026',
'vendor_224',
'fleischart_47539',
'fleischart_15470',
'vendor_114',
'fettanteil_52859',
'fischart_29659',
'vendor_386',
'netto_gewicht_filter_6',
'coolbox_filter_1',
'family_1027',
'family_778',
'typ_34174',
'family_986',
'fischart_29740',
'laenderkueche_36350',
'family_1028',
'fleischart_15474',
'vendor_1028',
'art_51800',
'verpackung_24689',
'verpackung_3121',
'pastete_sorten_29718',
'vendor_1191',
'fischart_35526',
'pastete_sorten_29725',
'family_1044',
'netto_gewicht_filter_2',
'serie_55241',
'vendor_1179',
'family_1031',
'family_1072',
'family_935',
'serie_39543',
'verpackung_3948',
'family_1033',
'laenderkueche_36354',
'netto_fuellmenge_filter_5',
'vendor_1160',
'vendor_402',
'vendor_728',
'pastete_sorten_29724',
'vendor_227',
'vendor_431',
'vendor_637',
'family_1269',
'family_1270',
'fleischart_47119',
'fleischart_54889',
'laenderkueche_48797',
'verpackung_2870',
'fettanteil_43969',
'fischart_29661',
'fleischart_54883',
'getreideart_15473',
'vendor_1119',
'vendor_1208',
'vendor_1374',
'vendor_348',
'vendor_944',
'art_56215',
'family_1115',
'fischart_29658',
'fischart_29999',
'pastete_sorten_29726',
'vendor_1355',
'vendor_403',
'vendor_404',
'vendor_914',
'family_1046',
'family_1074',
'family_686',
'fischart_29665',
'fischart_29998',
'fischart_52914',
'getreideart_15476',
'vendor_1025',
'vendor_1181',
'vendor_1372',
'vendor_1381',
'vendor_457',
'vendor_484',
'vendor_699',
'vendor_922',
'vendor_952',
'verpackung_26798',
'verpackung_27725',
'art_35238',
'fettanteil_52299',
'fettanteil_52300',
'fettanteil_54188',
'fettanteil_55626',
'fischart_30000',
'fleischart_15475',
'getreideart_23671',
'netto_fuellmenge_filter_4',
'netto_gewicht_filter_7',
'vendor_1064',
'vendor_1122',
'vendor_1322',
'vendor_1380',
'vendor_1388',
'vendor_1463',
'vendor_151',
'vendor_383',
'vendor_412',
'vendor_459',
'vendor_511',
'vendor_513',
'vendor_717',
'vendor_834',
'vendor_869',
'verpackung_42548',
'verpackung_4977',
'family_1030',
'family_1172',
'family_1274',
'fettanteil_53325',
'fettanteil_56095',
'fischart_29660',
'fischart_29663',
'getreideart_25278',
'laenderkueche_43012',
'laenderkueche_50808',
'netto_fuellmenge_filter_6',
'pastete_sorten_50587',
'vendor_1054',
'vendor_1106',
'vendor_118',
'vendor_1224',
'vendor_1255',
'vendor_1349',
'vendor_1353',
'vendor_1413',
'vendor_144',
'vendor_1473',
'vendor_1477',
'vendor_204',
'vendor_277',
'vendor_280',
'vendor_481',
'vendor_635',
'vendor_679',
'vendor_775',
'vendor_779',
'vendor_782',
'vendor_783',
'vendor_835',
'vendor_836',
'verpackung_35918',
'verpackung_5933'
)
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('freezebox_filter_3','coolbox_filter_0','verpackung_4205','netto_gewicht_filter_4','netto_gewicht_filter_5','verpackung_36357','netto_gewicht_filter_3','verpackung_3840','family_684','family_683','laenderkueche_36352','art_2163','family_920','family_685','vendor_531','art_30399','art_51799','vendor_458','family_1026','vendor_224','fleischart_47539','fleischart_15470','vendor_114','fettanteil_52859','fischart_29659','vendor_386','netto_gewicht_filter_6','coolbox_filter_1','family_1027','family_778','typ_34174','family_986','fischart_29740','laenderkueche_36350','family_1028','fleischart_15474','vendor_1028','art_51800','verpackung_24689','verpackung_3121','pastete_sorten_29718','vendor_1191','fischart_35526','pastete_sorten_29725','family_1044','netto_gewicht_filter_2','serie_55241','vendor_1179','family_1031','family_1072','family_935','serie_39543','verpackung_3948','family_1033','laenderkueche_36354','netto_fuellmenge_filter_5','vendor_1160','vendor_402','vendor_728','pastete_sorten_29724','vendor_227','vendor_431','vendor_637','family_1269','family_1270','fleischart_47119','fleischart_54889','laenderkueche_48797','verpackung_2870','fettanteil_43969','fischart_29661','fleischart_54883','getreideart_15473','vendor_1119','vendor_1208','vendor_1374','vendor_348','vendor_944','art_56215','family_1115','fischart_29658','fischart_29999','pastete_sorten_29726','vendor_1355','vendor_403','vendor_404','vendor_914','family_1046','family_1074','family_686','fischart_29665','fischart_29998','fischart_52914','getreideart_15476','vendor_1025','vendor_1181','vendor_1372','vendor_1381','vendor_457','vendor_484','vendor_699','vendor_922','vendor_952','verpackung_26798','verpackung_27725','art_35238','fettanteil_52299','fettanteil_52300','fettanteil_54188','fettanteil_55626','fischart_30000','fleischart_15475','getreideart_23671','netto_fuellmenge_filter_4','netto_gewicht_filter_7','vendor_1064','vendor_1122','vendor_1322','vendor_1380','vendor_1388','vendor_1463','vendor_151','vendor_383','vendor_412','vendor_459','vendor_511','vendor_513','vendor_717','vendor_834','vendor_869','verpackung_42548','verpackung_4977','family_1030','family_1172','family_1274','fettanteil_53325','fettanteil_56095','fischart_29660','fischart_29663','getreideart_25278','laenderkueche_43012','laenderkueche_50808','netto_fuellmenge_filter_6','pastete_sorten_50587','vendor_1054','vendor_1106','vendor_118','vendor_1224','vendor_1255','vendor_1349','vendor_1353','vendor_1413','vendor_144','vendor_1473','vendor_1477','vendor_204','vendor_277','vendor_280','vendor_481','vendor_635','vendor_679','vendor_775','vendor_779','vendor_782','vendor_783','vendor_835','vendor_836','verpackung_35918','verpackung_5933') AND a.is_filterable = true;
|