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