| 3 |
0.13 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('coolbox_filter_0','freezebox_filter_3','art_2163','verpackung_2870','art_der_suessigkeiten_46435','family_932','verwendungszweck_46428','netto_gewicht_filter_4','verpackung_2954','netto_gewicht_filter_5','verwendungszweck_4215','netto_gewicht_filter_6','family_716','vendor_762','netto_gewicht_filter_3','vendor_134','geschmack_35867','verpackung_3653','verpackung_3948','geschmack_23781','family_880','netto_gewicht_filter_1','aroma_3539','art_56939','art_56940','family_1077','family_594','family_687','family_693','family_865','geschmack_23756','geschmack_24687','geschmack_26932','netto_gewicht_filter_2','serie_44880','typ_26962','vendor_1113','vendor_196','vendor_380','vendor_716','vendor_738','verpackung_35918','verwendungszweck_135','art_57036','art_der_suessigkeiten_34384','art_der_suessigkeiten_36995','art_der_suessigkeiten_39960','family_1114','family_1168','geschmack_46434','vendor_1582','vendor_162','verpackung_9455','altergruppierung_54019','art_23723','art_der_suessigkeiten_35208','family_1259','family_689','family_695','family_769','fuellung_39488','geschmack_23749','geschmack_23753','geschmack_23755','geschmack_23757','geschmack_23759','geschmack_23761','geschmack_23765','geschmack_24694','geschmack_25688','geschmack_26611','geschmack_26929','geschmack_36009','geschmack_39591','geschmack_45977','geschmack_53895','sorte_3536','sorte_7952','typ_27609','vendor_1125','vendor_1205','vendor_1247','vendor_152','vendor_156','vendor_1618','vendor_177','vendor_216','vendor_221','vendor_259','vendor_467','vendor_529','vendor_531','vendor_946','verpackung_14402','verpackung_37215','verwendungszweck_16237') 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(
'coolbox_filter_0', 'freezebox_filter_3',
'art_2163', 'verpackung_2870', 'art_der_suessigkeiten_46435',
'family_932', 'verwendungszweck_46428',
'netto_gewicht_filter_4', 'verpackung_2954',
'netto_gewicht_filter_5', 'verwendungszweck_4215',
'netto_gewicht_filter_6', 'family_716',
'vendor_762', 'netto_gewicht_filter_3',
'vendor_134', 'geschmack_35867',
'verpackung_3653', 'verpackung_3948',
'geschmack_23781', 'family_880',
'netto_gewicht_filter_1', 'aroma_3539',
'art_56939', 'art_56940', 'family_1077',
'family_594', 'family_687', 'family_693',
'family_865', 'geschmack_23756',
'geschmack_24687', 'geschmack_26932',
'netto_gewicht_filter_2', 'serie_44880',
'typ_26962', 'vendor_1113', 'vendor_196',
'vendor_380', 'vendor_716', 'vendor_738',
'verpackung_35918', 'verwendungszweck_135',
'art_57036', 'art_der_suessigkeiten_34384',
'art_der_suessigkeiten_36995',
'art_der_suessigkeiten_39960',
'family_1114', 'family_1168', 'geschmack_46434',
'vendor_1582', 'vendor_162', 'verpackung_9455',
'altergruppierung_54019', 'art_23723',
'art_der_suessigkeiten_35208',
'family_1259', 'family_689', 'family_695',
'family_769', 'fuellung_39488',
'geschmack_23749', 'geschmack_23753',
'geschmack_23755', 'geschmack_23757',
'geschmack_23759', 'geschmack_23761',
'geschmack_23765', 'geschmack_24694',
'geschmack_25688', 'geschmack_26611',
'geschmack_26929', 'geschmack_36009',
'geschmack_39591', 'geschmack_45977',
'geschmack_53895', 'sorte_3536',
'sorte_7952', 'typ_27609', 'vendor_1125',
'vendor_1205', 'vendor_1247', 'vendor_152',
'vendor_156', 'vendor_1618', 'vendor_177',
'vendor_216', 'vendor_221', 'vendor_259',
'vendor_467', 'vendor_529', 'vendor_531',
'vendor_946', 'verpackung_14402',
'verpackung_37215', 'verwendungszweck_16237'
)
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('coolbox_filter_0','freezebox_filter_3','art_2163','verpackung_2870','art_der_suessigkeiten_46435','family_932','verwendungszweck_46428','netto_gewicht_filter_4','verpackung_2954','netto_gewicht_filter_5','verwendungszweck_4215','netto_gewicht_filter_6','family_716','vendor_762','netto_gewicht_filter_3','vendor_134','geschmack_35867','verpackung_3653','verpackung_3948','geschmack_23781','family_880','netto_gewicht_filter_1','aroma_3539','art_56939','art_56940','family_1077','family_594','family_687','family_693','family_865','geschmack_23756','geschmack_24687','geschmack_26932','netto_gewicht_filter_2','serie_44880','typ_26962','vendor_1113','vendor_196','vendor_380','vendor_716','vendor_738','verpackung_35918','verwendungszweck_135','art_57036','art_der_suessigkeiten_34384','art_der_suessigkeiten_36995','art_der_suessigkeiten_39960','family_1114','family_1168','geschmack_46434','vendor_1582','vendor_162','verpackung_9455','altergruppierung_54019','art_23723','art_der_suessigkeiten_35208','family_1259','family_689','family_695','family_769','fuellung_39488','geschmack_23749','geschmack_23753','geschmack_23755','geschmack_23757','geschmack_23759','geschmack_23761','geschmack_23765','geschmack_24694','geschmack_25688','geschmack_26611','geschmack_26929','geschmack_36009','geschmack_39591','geschmack_45977','geschmack_53895','sorte_3536','sorte_7952','typ_27609','vendor_1125','vendor_1205','vendor_1247','vendor_152','vendor_156','vendor_1618','vendor_177','vendor_216','vendor_221','vendor_259','vendor_467','vendor_529','vendor_531','vendor_946','verpackung_14402','verpackung_37215','verwendungszweck_16237') AND a.is_filterable = true;
|