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