| 3 |
0.16 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','fleischart_15470','verpackung_37215','coolbox_filter_1','family_1078','netto_gewicht_filter_4','vendor_531','netto_gewicht_filter_3','fleischart_15474','netto_gewicht_filter_5','art_39784','family_685','fleischart_47539','art_2163','art_30399','verpackung_3840','verpackung_36357','vendor_42','family_1260','family_920','verpackung_2870','netto_gewicht_filter_6','pastete_sorten_29718','sorte_39243','vendor_224','verpackung_3948','netto_gewicht_filter_1','art_54194','art_56221','family_935','serie_39534','vendor_751','vendor_357','vendor_402','art_39778','family_1080','freezebox_filter_2','pastete_sorten_29724','art_37170','family_1129','fleischart_47119','fleischart_54889','vendor_1318','vendor_386','verpackung_24689','family_1106','fleischart_54883','getreideart_15473','serie_39536','serie_41382','serie_55241','vendor_348','vendor_458','art_54199','pastete_sorten_29726','vendor_1390','vendor_404','vendor_637','art_37185','art_39785','family_1173','getreideart_15476','serie_39537','serie_39538','serie_44736','vendor_752','verpackung_3609','art_37171','family_1118','fleischart_15475','fleischart_30153','getreideart_23671','netto_gewicht_filter_2','netto_gewicht_filter_7','serie_39540','sorte_39254','vendor_1322','vendor_412','vendor_874','verpackung_3121','verpackung_42548','art_35238','art_37849','art_37854','art_41586','art_54195','art_56010','getreideart_25278','serie_27405','serie_37454','serie_39539','serie_52845','vendor_1035','vendor_1173','vendor_118','vendor_1224','vendor_1464','vendor_565','vendor_750','vendor_753','vendor_775','vendor_88','verpackung_35918') 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',
'fleischart_15470', 'verpackung_37215',
'coolbox_filter_1', 'family_1078',
'netto_gewicht_filter_4', 'vendor_531',
'netto_gewicht_filter_3', 'fleischart_15474',
'netto_gewicht_filter_5', 'art_39784',
'family_685', 'fleischart_47539',
'art_2163', 'art_30399', 'verpackung_3840',
'verpackung_36357', 'vendor_42',
'family_1260', 'family_920', 'verpackung_2870',
'netto_gewicht_filter_6', 'pastete_sorten_29718',
'sorte_39243', 'vendor_224', 'verpackung_3948',
'netto_gewicht_filter_1', 'art_54194',
'art_56221', 'family_935', 'serie_39534',
'vendor_751', 'vendor_357', 'vendor_402',
'art_39778', 'family_1080', 'freezebox_filter_2',
'pastete_sorten_29724', 'art_37170',
'family_1129', 'fleischart_47119',
'fleischart_54889', 'vendor_1318',
'vendor_386', 'verpackung_24689',
'family_1106', 'fleischart_54883',
'getreideart_15473', 'serie_39536',
'serie_41382', 'serie_55241', 'vendor_348',
'vendor_458', 'art_54199', 'pastete_sorten_29726',
'vendor_1390', 'vendor_404', 'vendor_637',
'art_37185', 'art_39785', 'family_1173',
'getreideart_15476', 'serie_39537',
'serie_39538', 'serie_44736', 'vendor_752',
'verpackung_3609', 'art_37171',
'family_1118', 'fleischart_15475',
'fleischart_30153', 'getreideart_23671',
'netto_gewicht_filter_2', 'netto_gewicht_filter_7',
'serie_39540', 'sorte_39254', 'vendor_1322',
'vendor_412', 'vendor_874', 'verpackung_3121',
'verpackung_42548', 'art_35238',
'art_37849', 'art_37854', 'art_41586',
'art_54195', 'art_56010', 'getreideart_25278',
'serie_27405', 'serie_37454', 'serie_39539',
'serie_52845', 'vendor_1035', 'vendor_1173',
'vendor_118', 'vendor_1224', 'vendor_1464',
'vendor_565', 'vendor_750', 'vendor_753',
'vendor_775', 'vendor_88', 'verpackung_35918'
)
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','fleischart_15470','verpackung_37215','coolbox_filter_1','family_1078','netto_gewicht_filter_4','vendor_531','netto_gewicht_filter_3','fleischart_15474','netto_gewicht_filter_5','art_39784','family_685','fleischart_47539','art_2163','art_30399','verpackung_3840','verpackung_36357','vendor_42','family_1260','family_920','verpackung_2870','netto_gewicht_filter_6','pastete_sorten_29718','sorte_39243','vendor_224','verpackung_3948','netto_gewicht_filter_1','art_54194','art_56221','family_935','serie_39534','vendor_751','vendor_357','vendor_402','art_39778','family_1080','freezebox_filter_2','pastete_sorten_29724','art_37170','family_1129','fleischart_47119','fleischart_54889','vendor_1318','vendor_386','verpackung_24689','family_1106','fleischart_54883','getreideart_15473','serie_39536','serie_41382','serie_55241','vendor_348','vendor_458','art_54199','pastete_sorten_29726','vendor_1390','vendor_404','vendor_637','art_37185','art_39785','family_1173','getreideart_15476','serie_39537','serie_39538','serie_44736','vendor_752','verpackung_3609','art_37171','family_1118','fleischart_15475','fleischart_30153','getreideart_23671','netto_gewicht_filter_2','netto_gewicht_filter_7','serie_39540','sorte_39254','vendor_1322','vendor_412','vendor_874','verpackung_3121','verpackung_42548','art_35238','art_37849','art_37854','art_41586','art_54195','art_56010','getreideart_25278','serie_27405','serie_37454','serie_39539','serie_52845','vendor_1035','vendor_1173','vendor_118','vendor_1224','vendor_1464','vendor_565','vendor_750','vendor_753','vendor_775','vendor_88','verpackung_35918') AND a.is_filterable = true;
|