| 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','family_1078','fleischart_15470','verpackung_37215','coolbox_filter_1','art_39784','netto_gewicht_filter_4','vendor_531','fleischart_15474','netto_gewicht_filter_5','netto_gewicht_filter_3','sorte_39243','coolbox_filter_0','art_54194','art_56221','serie_39534','vendor_42','vendor_751','art_39778','art_37170','vendor_357','art_54199','serie_39536','serie_41382','art_37185','art_39785','family_1173','serie_39537','serie_39538','serie_44736','verpackung_3609','art_37171','fleischart_30153','fleischart_47539','serie_39540','sorte_39254','vendor_752','vendor_874','verpackung_3948','art_2163','art_37849','art_37854','art_41586','art_54195','art_56010','netto_gewicht_filter_6','serie_27405','serie_37454','serie_39539','serie_52845','vendor_1173','vendor_1464','vendor_224','vendor_565','vendor_753','vendor_88') 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', 'family_1078',
'fleischart_15470', 'verpackung_37215',
'coolbox_filter_1', 'art_39784',
'netto_gewicht_filter_4', 'vendor_531',
'fleischart_15474', 'netto_gewicht_filter_5',
'netto_gewicht_filter_3', 'sorte_39243',
'coolbox_filter_0', 'art_54194',
'art_56221', 'serie_39534', 'vendor_42',
'vendor_751', 'art_39778', 'art_37170',
'vendor_357', 'art_54199', 'serie_39536',
'serie_41382', 'art_37185', 'art_39785',
'family_1173', 'serie_39537', 'serie_39538',
'serie_44736', 'verpackung_3609',
'art_37171', 'fleischart_30153',
'fleischart_47539', 'serie_39540',
'sorte_39254', 'vendor_752', 'vendor_874',
'verpackung_3948', 'art_2163', 'art_37849',
'art_37854', 'art_41586', 'art_54195',
'art_56010', 'netto_gewicht_filter_6',
'serie_27405', 'serie_37454', 'serie_39539',
'serie_52845', 'vendor_1173', 'vendor_1464',
'vendor_224', 'vendor_565', 'vendor_753',
'vendor_88'
)
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','family_1078','fleischart_15470','verpackung_37215','coolbox_filter_1','art_39784','netto_gewicht_filter_4','vendor_531','fleischart_15474','netto_gewicht_filter_5','netto_gewicht_filter_3','sorte_39243','coolbox_filter_0','art_54194','art_56221','serie_39534','vendor_42','vendor_751','art_39778','art_37170','vendor_357','art_54199','serie_39536','serie_41382','art_37185','art_39785','family_1173','serie_39537','serie_39538','serie_44736','verpackung_3609','art_37171','fleischart_30153','fleischart_47539','serie_39540','sorte_39254','vendor_752','vendor_874','verpackung_3948','art_2163','art_37849','art_37854','art_41586','art_54195','art_56010','netto_gewicht_filter_6','serie_27405','serie_37454','serie_39539','serie_52845','vendor_1173','vendor_1464','vendor_224','vendor_565','vendor_753','vendor_88') AND a.is_filterable = true;
|