| 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('family_1118','netto_gewicht_filter_3','art_39784','vendor_42','coolbox_filter_1','freezebox_filter_3','family_1080','netto_gewicht_filter_4','verpackung_37215','vendor_357','family_1225','netto_gewicht_filter_5','verpackung_3121','vendor_1372','family_1101','netto_gewicht_filter_2','verpackung_5933','geschmack_23778','fettanteil_54147','vendor_1505','art_2163','verpackung_24689','family_1072','verpackung_36357','fischart_29740','vendor_757','art_55439','verpackung_4205','fischart_54823','vendor_1462','art_56007','art_56006','vendor_1465','art_54139','verpackung_42548','vendor_1455','geschmack_23770','geschmack_23771','geschmack_55696','fettanteil_52040','vendor_531','geschmack_23775','geschmack_23781','vendor_621','verpackung_3840','vendor_1179','fischart_30000','fettanteil_53700','vendor_1316','fischart_29998','fischart_36125','vendor_477','family_1078','sorte_39243','serie_39540','fleischart_15470','fleischart_15474','fleischart_30153','vendor_88','coolbox_filter_0','fischart_29660','fischart_37803','fischart_37804','netto_gewicht_filter_6','fischart_29999','vendor_1311','fischart_38548','vendor_1255','family_1220','verpackung_3948','vendor_869','family_1265','verpackung_38799','fettanteil_56074','vendor_1476','art_54194','art_54199','art_56221','serie_39534','fettanteil_55872','vendor_1349','art_37171','serie_39538','fleischart_47539','serie_55386','art_54141','verpackung_3609','vendor_679','sorte_39254','vendor_874','art_37170','vendor_224','serie_39536','serie_41382','art_37185','family_1173','vendor_753','art_39778','vendor_751','art_37849','serie_44736','geschmack_23779','geschmack_56650','fettanteil_54814','family_1226','fettanteil_52302','fettanteil_52035','verpackung_2870','vendor_517','netto_gewicht_filter_1','freezebox_filter_2','family_1035','art_54698','art_54140','typ_40821','art_39785','vendor_606','family_1106','fischart_39433','vendor_641','art_56010','serie_39539','vendor_386','vendor_665','vendor_565','vendor_664','serie_39537','serie_52845','vendor_901','vendor_519','vendor_642','art_54195','art_54694','fischart_29659','vendor_1312','family_1074','vendor_484','family_1031','laenderkueche_36352','serie_27405','vendor_1449','fettanteil_56691','art_54695','vendor_910','family_1246','art_56004','serie_37454','vendor_752','art_41586','vendor_1173','vendor_1464','vendor_750','art_37854','vendor_944') 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_1118',
'netto_gewicht_filter_3',
'art_39784',
'vendor_42',
'coolbox_filter_1',
'freezebox_filter_3',
'family_1080',
'netto_gewicht_filter_4',
'verpackung_37215',
'vendor_357',
'family_1225',
'netto_gewicht_filter_5',
'verpackung_3121',
'vendor_1372',
'family_1101',
'netto_gewicht_filter_2',
'verpackung_5933',
'geschmack_23778',
'fettanteil_54147',
'vendor_1505',
'art_2163',
'verpackung_24689',
'family_1072',
'verpackung_36357',
'fischart_29740',
'vendor_757',
'art_55439',
'verpackung_4205',
'fischart_54823',
'vendor_1462',
'art_56007',
'art_56006',
'vendor_1465',
'art_54139',
'verpackung_42548',
'vendor_1455',
'geschmack_23770',
'geschmack_23771',
'geschmack_55696',
'fettanteil_52040',
'vendor_531',
'geschmack_23775',
'geschmack_23781',
'vendor_621',
'verpackung_3840',
'vendor_1179',
'fischart_30000',
'fettanteil_53700',
'vendor_1316',
'fischart_29998',
'fischart_36125',
'vendor_477',
'family_1078',
'sorte_39243',
'serie_39540',
'fleischart_15470',
'fleischart_15474',
'fleischart_30153',
'vendor_88',
'coolbox_filter_0',
'fischart_29660',
'fischart_37803',
'fischart_37804',
'netto_gewicht_filter_6',
'fischart_29999',
'vendor_1311',
'fischart_38548',
'vendor_1255',
'family_1220',
'verpackung_3948',
'vendor_869',
'family_1265',
'verpackung_38799',
'fettanteil_56074',
'vendor_1476',
'art_54194',
'art_54199',
'art_56221',
'serie_39534',
'fettanteil_55872',
'vendor_1349',
'art_37171',
'serie_39538',
'fleischart_47539',
'serie_55386',
'art_54141',
'verpackung_3609',
'vendor_679',
'sorte_39254',
'vendor_874',
'art_37170',
'vendor_224',
'serie_39536',
'serie_41382',
'art_37185',
'family_1173',
'vendor_753',
'art_39778',
'vendor_751',
'art_37849',
'serie_44736',
'geschmack_23779',
'geschmack_56650',
'fettanteil_54814',
'family_1226',
'fettanteil_52302',
'fettanteil_52035',
'verpackung_2870',
'vendor_517',
'netto_gewicht_filter_1',
'freezebox_filter_2',
'family_1035',
'art_54698',
'art_54140',
'typ_40821',
'art_39785',
'vendor_606',
'family_1106',
'fischart_39433',
'vendor_641',
'art_56010',
'serie_39539',
'vendor_386',
'vendor_665',
'vendor_565',
'vendor_664',
'serie_39537',
'serie_52845',
'vendor_901',
'vendor_519',
'vendor_642',
'art_54195',
'art_54694',
'fischart_29659',
'vendor_1312',
'family_1074',
'vendor_484',
'family_1031',
'laenderkueche_36352',
'serie_27405',
'vendor_1449',
'fettanteil_56691',
'art_54695',
'vendor_910',
'family_1246',
'art_56004',
'serie_37454',
'vendor_752',
'art_41586',
'vendor_1173',
'vendor_1464',
'vendor_750',
'art_37854',
'vendor_944'
)
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_1118','netto_gewicht_filter_3','art_39784','vendor_42','coolbox_filter_1','freezebox_filter_3','family_1080','netto_gewicht_filter_4','verpackung_37215','vendor_357','family_1225','netto_gewicht_filter_5','verpackung_3121','vendor_1372','family_1101','netto_gewicht_filter_2','verpackung_5933','geschmack_23778','fettanteil_54147','vendor_1505','art_2163','verpackung_24689','family_1072','verpackung_36357','fischart_29740','vendor_757','art_55439','verpackung_4205','fischart_54823','vendor_1462','art_56007','art_56006','vendor_1465','art_54139','verpackung_42548','vendor_1455','geschmack_23770','geschmack_23771','geschmack_55696','fettanteil_52040','vendor_531','geschmack_23775','geschmack_23781','vendor_621','verpackung_3840','vendor_1179','fischart_30000','fettanteil_53700','vendor_1316','fischart_29998','fischart_36125','vendor_477','family_1078','sorte_39243','serie_39540','fleischart_15470','fleischart_15474','fleischart_30153','vendor_88','coolbox_filter_0','fischart_29660','fischart_37803','fischart_37804','netto_gewicht_filter_6','fischart_29999','vendor_1311','fischart_38548','vendor_1255','family_1220','verpackung_3948','vendor_869','family_1265','verpackung_38799','fettanteil_56074','vendor_1476','art_54194','art_54199','art_56221','serie_39534','fettanteil_55872','vendor_1349','art_37171','serie_39538','fleischart_47539','serie_55386','art_54141','verpackung_3609','vendor_679','sorte_39254','vendor_874','art_37170','vendor_224','serie_39536','serie_41382','art_37185','family_1173','vendor_753','art_39778','vendor_751','art_37849','serie_44736','geschmack_23779','geschmack_56650','fettanteil_54814','family_1226','fettanteil_52302','fettanteil_52035','verpackung_2870','vendor_517','netto_gewicht_filter_1','freezebox_filter_2','family_1035','art_54698','art_54140','typ_40821','art_39785','vendor_606','family_1106','fischart_39433','vendor_641','art_56010','serie_39539','vendor_386','vendor_665','vendor_565','vendor_664','serie_39537','serie_52845','vendor_901','vendor_519','vendor_642','art_54195','art_54694','fischart_29659','vendor_1312','family_1074','vendor_484','family_1031','laenderkueche_36352','serie_27405','vendor_1449','fettanteil_56691','art_54695','vendor_910','family_1246','art_56004','serie_37454','vendor_752','art_41586','vendor_1173','vendor_1464','vendor_750','art_37854','vendor_944') AND a.is_filterable = true;
|