Provides all details to render a shop navigation for the current user or visitor. So result may differ for different caller roles or caller tour assignments.
Group · SubGroup · Assortment · AssortmentGroup · Rubric · Article · Navigation · NavigationDetail · SubGroupMap · RubricMap · AssortmentPosition · FilterGroup · Label
A warehouse category. Any Item is exactly member of one category.
| # | Field | Type | Description | Links |
|---|---|---|---|---|
| 0 | id | int | internal category id | 🔗 group_id |
| 1 | name | string | category name | |
| 2 | description | string | html-ready category description | |
| 3 | count | int | number of child elements in that group | |
| 4 | totalcount | int | number of child items in that group and its subgroups | |
| 5 | label_groups | int[] | applicable label group ids, comma separated list | |
| 6 | image_hash | string | hashcode for the main category image, if any. see image proxy doc on how to obtain the image. | |
| 7 | thumb_hash | string | hashcode for the small category image (for list display), if any. see image proxy doc on how to obtain the image. |
Data (36 records)
| id | name | description | count | totalcount | label_groups | image_hash | thumb_hash |
|---|---|---|---|---|---|---|---|
| 8 →items22 →items23 →items20 →items21 | Eigenes Gemüse vom Glashaus | 9 | 16 | [850, 851, 864, 874, 878, 884, 889, 896, 897, 899, 902, 904, 905, 906, 907, 908, 909, 910, 911, 912, 914, 917, 918, 937, 938, 946] | 0 | 0 | |
| 9 →items22 →items23 →items20 →items21 | Eigenes Gemüse | 14 | 22 | [611, 878, 884, 889, 896, 899, 906, 907, 908, 909, 910, 911, 912, 938] | 588129273f0751c563a4a817ee5d82d1 | 0 | |
| 25 →items22 →items23 →items20 →items21 | Frisches Gemüse der Jahreszeit | 44 | 72 | [850, 874, 878, 884, 889, 896, 897, 899, 902, 903, 904, 905, 906, 907, 908, 909, 910, 911, 912, 914, 917, 937, 938] | 191b93765815858f431cd23c97923606 | 0 | |
| 26 →items22 →items23 →items20 →items21 | Frisches Obst der Jahreszeit | 35 | 31 | [847, 850, 852, 853, 874, 886, 887, 890, 896, 897, 902, 903, 904, 905, 906, 907, 908, 909, 910, 911, 912, 914, 917, 918] | 2d6e416c4a7a34d7e3042599bd79650d | 0 | |
| 79 →items22 →items23 →items20 →items21 | aus unserem Obstgarten | 2 | 0 | [850, 874, 906, 907, 908, 909, 910, 911, 912] | f4a9b6dc1b327f1e578f668d3a794f69 | 0 | |
| 67 →items22 →items23 →items20 →items21 | Backwaren | 23 | 20 | [611, 843, 844, 845, 847, 849, 850, 851, 853, 854, 855, 857, 858, 859, 860, 862, 863, 864, 865, 866, 867, 868, 869, 870, 872, 874, 883, 886, 889, 892, 896, 897, 899, 902, 904, 905, 906, 907, 908, 909, 910, 911, 912, 914, 917, 918, 936, 937, 946, 969] | cadfca9dcc49c9b74860eb7d42426fbc | 0 | |
| 94 →items22 →items23 →items20 →items21 | Kühltheke | 46 | 45 | [611, 843, 844, 845, 846, 847, 848, 849, 850, 851, 852, 853, 854, 855, 856, 857, 858, 859, 860, 861, 862, 863, 864, 865, 866, 867, 868, 869, 870, 871, 872, 874, 875, 876, 879, 880, 881, 882, 883, 884, 886, 887, 888, 889, 890, 892, 893, 894, 895, 896, 897, 899, 901, 902, 903, 904, 905, 906, 907, 908, 909, 910, 911, 912, 913, 914, 917, 918, 936, 937, 938, 945, 946, 950, 951, 952, 971, 985, 986, 987] | 8b9e780d99c006aa0adad5485c65b5de | 0 | |
| 123 →items22 →items23 →items20 →items21 | Käse | 43 | 31 | [611, 843, 844, 845, 846, 847, 848, 849, 850, 851, 852, 853, 854, 855, 856, 857, 858, 859, 860, 862, 863, 864, 865, 866, 867, 868, 869, 870, 872, 874, 878, 880, 881, 882, 883, 884, 886, 887, 888, 889, 890, 892, 896, 897, 899, 901, 902, 904, 905, 906, 907, 908, 909, 910, 911, 912, 913, 914, 917, 918, 936, 937, 946, 950, 951, 952, 985, 987] | f9d166032f097b05750f2d9b0d638451 | 0 | |
| 134 →items22 →items23 →items20 →items21 | Milch- und Fleischersatz | 6 | 16 | [611, 844, 847, 851, 852, 853, 854, 855, 858, 860, 863, 864, 865, 866, 867, 896, 897, 899, 901, 904, 905, 906, 907, 908, 909, 910, 911, 912, 913, 914, 918, 936, 937, 938, 946, 950, 951, 952, 985, 986, 987] | 58423a2b63a62e9a0ed73ad9ea9ebd6d | 0 | |
| 19 →items22 →items23 →items20 →items21 | Fleisch & Wurst | 60 | 50 | [611, 844, 846, 849, 850, 851, 852, 853, 854, 856, 857, 864, 865, 866, 867, 868, 869, 870, 872, 874, 875, 876, 883, 886, 888, 889, 896, 897, 899, 901, 902, 903, 904, 905, 906, 907, 908, 909, 910, 911, 912, 914, 917, 918, 937, 946] | 023c6a9be4a9b1827bc267378f201ad6 | 0 | |
| 97 →items22 →items23 →items20 →items21 | Getreide,Hülsenfrüchte,Nüsse | 40 | 31 | [611, 844, 845, 847, 849, 850, 851, 852, 853, 854, 855, 858, 859, 860, 861, 862, 863, 864, 865, 866, 867, 868, 869, 870, 871, 872, 874, 876, 877, 880, 881, 883, 886, 887, 888, 889, 890, 892, 895, 896, 897, 899, 901, 902, 903, 904, 905, 906, 907, 908, 909, 910, 911, 912, 913, 914, 917, 918, 937, 945, 946, 952, 969, 971] | e51c14a2c98ae7de4d7f5816c8e05142 | 0 | |
| 115 →items22 →items23 →items20 →items21 | Nudeln, Trockenfr., Müsli | 45 | 41 | [611, 844, 845, 847, 849, 850, 851, 852, 853, 854, 855, 858, 859, 860, 861, 862, 863, 864, 865, 866, 867, 868, 869, 870, 871, 872, 874, 880, 881, 883, 886, 887, 888, 889, 890, 892, 896, 897, 899, 901, 902, 903, 904, 905, 906, 907, 908, 909, 910, 911, 912, 913, 914, 917, 918, 937, 945, 946, 969, 971] | d1bf33d368a3f4e8227d17fa454b7102 | 0 | |
| 100 →items22 →items23 →items20 →items21 | Aufstriche süß & pikant | 40 | 35 | [611, 843, 844, 845, 847, 849, 850, 851, 852, 853, 854, 855, 858, 860, 862, 863, 864, 865, 866, 867, 870, 871, 872, 874, 879, 880, 881, 883, 884, 885, 888, 889, 890, 892, 895, 896, 897, 899, 901, 902, 903, 904, 905, 906, 907, 908, 909, 910, 911, 912, 914, 917, 918, 936, 937, 938, 946, 950, 951, 952, 971] | af7b1fc262ba1bc063d3af7e8682d2e9 | 0 | |
| 98 →items22 →items23 →items20 →items21 | Kochhilfsmittel | 148 | 130 | [611, 844, 845, 846, 847, 848, 849, 850, 851, 852, 853, 854, 855, 856, 857, 858, 859, 860, 861, 862, 863, 864, 865, 866, 867, 868, 869, 870, 871, 872, 874, 875, 876, 878, 879, 880, 881, 883, 885, 886, 887, 888, 889, 890, 891, 892, 893, 895, 896, 897, 899, 901, 902, 903, 904, 905, 906, 907, 908, 909, 910, 911, 912, 913, 914, 917, 918, 936, 937, 938, 945, 946, 950, 951, 952, 971, 985, 986] | 892291f20966ebb897451214a8c2d307 | 0 | |
| 99 →items22 →items23 →items20 →items21 | zum Schlecken und Knabbern | 75 | 72 | [611, 843, 844, 845, 846, 847, 848, 849, 850, 851, 852, 853, 854, 855, 856, 857, 858, 859, 860, 861, 862, 863, 864, 865, 866, 867, 868, 869, 870, 871, 872, 874, 876, 877, 879, 880, 881, 882, 883, 886, 887, 888, 889, 890, 891, 892, 895, 896, 897, 899, 901, 902, 904, 905, 906, 907, 908, 909, 910, 911, 912, 913, 914, 917, 918, 936, 937, 938, 945, 946, 950, 951, 952, 971, 987] | 4734a71b6b4a0077825c1e8fdc0aaf86 | 0 | |
| 96 →items22 →items23 →items20 →items21 | Getränke zum Aufgießen | 42 | 35 | [611, 844, 845, 846, 847, 848, 849, 850, 851, 852, 853, 854, 855, 856, 857, 858, 859, 860, 861, 862, 863, 864, 865, 866, 867, 868, 869, 870, 872, 874, 880, 881, 883, 886, 888, 889, 890, 895, 896, 897, 899, 901, 902, 904, 905, 906, 907, 908, 909, 910, 911, 912, 914, 917, 918, 937, 945, 946, 950, 951, 952, 971] | 764271ca7f3874cab67109d16ad9fe15 | 0 | |
| 20 →items22 →items23 →items20 →items21 | Getränke in der Flasche | 91 | 91 | [611, 843, 844, 845, 846, 847, 848, 849, 850, 851, 852, 853, 854, 855, 856, 857, 858, 859, 860, 862, 863, 864, 865, 866, 867, 868, 869, 870, 872, 874, 880, 883, 886, 889, 890, 892, 895, 896, 897, 899, 901, 902, 903, 904, 905, 906, 907, 908, 909, 910, 911, 912, 913, 914, 917, 918, 936, 937, 938, 945, 946, 950, 951, 952, 971, 985, 986, 987, 1079] | 3049faef6abca4a497c9ee9266adeb5c | 0 | |
| 101 →items22 →items23 →items20 →items21 | Kosmetik | 34 | 30 | [611, 896, 904, 958, 959, 960, 961, 962, 963, 964, 965, 966, 976, 977] | b6922fe3e699ef50651334df21e2aa6e | 0 | |
| 102 →items22 →items23 →items20 →items21 | Reinigungsmittel | 33 | 25 | [611, 896, 904, 958, 959, 960, 961, 962, 963, 964, 965, 966, 977, 978] | d40b5d9a6e822693838bc73171b040e5 | 0 | |
| 103 →items22 →items23 →items20 →items21 | Non Food (Haushaltswaren) | 23 | 11 | [611, 847, 850, 853, 863, 874, 896, 897, 902, 903, 904, 906, 907, 908, 909, 910, 911, 912, 917, 958, 959, 960, 961, 962, 963, 964, 965, 966] | 789a4c86a8a58d8e72282964af6ec22b | 0 | |
| 109 →items22 →items23 →items20 →items21 | Rezepte | 56 | 61 | [611, 847, 850, 851, 859, 860, 863, 865, 867, 869, 870, 874, 880, 881, 883, 886, 890, 896, 897, 902, 904, 906, 907, 908, 909, 910, 911, 912, 913, 917] | 0 | 0 | |
| 23 →items22 →items23 →items20 →items21 | Gemüsepflanzen | 0 | 0 | [] | 0 | 0 | |
| 24 →items22 →items23 →items20 →items21 | Balkon und Beetflor | 0 | 0 | [] | 0 | 0 | |
| 73 →items22 →items23 →items20 →items21 | Gebinde | 0 | 0 | [611, 845, 846, 847, 850, 851, 852, 853, 854, 855, 858, 859, 860, 862, 863, 864, 865, 866, 867, 868, 869, 870, 872, 874, 880, 881, 883, 886, 888, 889, 892, 896, 897, 899, 901, 902, 903, 904, 905, 906, 907, 908, 909, 910, 911, 912, 914, 917, 918, 936, 937, 946, 950, 951, 952] | 0 | 0 | |
| 78 →items22 →items23 →items20 →items21 | Dienstleistungen | 0 | 0 | [611, 844, 845, 847, 850, 851, 854, 855, 858, 859, 860, 861, 862, 863, 864, 865, 866, 867, 868, 869, 870, 872, 874, 880, 881, 886, 889, 890, 895, 896, 897, 899, 902, 904, 905, 906, 907, 908, 909, 910, 911, 912, 917, 936, 937, 938, 945, 946, 950, 951, 960] | 0 | 0 | |
| 93 →items22 →items23 →items20 →items21 | Platznutzung | 0 | 0 | [] | 0 | 0 | |
| 121 →items22 →items23 →items20 →items21 | Tiefkühl,Konserven & Fertigpro | 0 | 0 | [611, 844, 845, 847, 850, 851, 852, 853, 854, 855, 858, 859, 860, 862, 863, 864, 865, 866, 867, 868, 869, 870, 872, 874, 880, 881, 886, 888, 890, 892, 895, 896, 897, 899, 901, 902, 903, 904, 905, 906, 907, 908, 909, 910, 911, 912, 914, 917, 918, 936, 937, 945, 946] | 0 | 0 | |
| 125 →items22 →items23 →items20 →items21 | Nebenkosten | 0 | 0 | [] | 0 | 0 | |
| 126 →items22 →items23 →items20 →items21 | XX Hartkäse | 0 | 0 | [] | 0 | 0 | |
| 127 →items22 →items23 →items20 →items21 | XXSchaf- und Ziegenkäse | 0 | 0 | [] | 0 | 0 | |
| 128 →items22 →items23 →items20 →items21 | Freie Arbeiten | 0 | 0 | [] | 0 | 0 | |
| 129 →items22 →items23 →items20 →items21 | Organisation 19 % | 0 | 0 | [] | 0 | 0 | |
| 130 →items22 →items23 →items20 →items21 | XXGeflügel | 0 | 0 | [] | 0 | 0 | |
| 131 →items22 →items23 →items20 →items21 | Großpackung | 0 | 0 | [611, 844, 845, 846, 847, 850, 851, 852, 853, 854, 855, 858, 859, 860, 862, 863, 864, 865, 866, 867, 868, 869, 870, 872, 874, 880, 881, 883, 886, 888, 889, 890, 892, 895, 896, 897, 899, 901, 902, 903, 904, 905, 906, 907, 908, 909, 910, 911, 912, 913, 914, 917, 918, 936, 937, 945, 946, 952, 958, 959, 960, 961, 962, 963, 964, 965, 966, 971] | 0 | 0 | |
| 132 →items22 →items23 →items20 →items21 | Reinigungsleistung | 0 | 0 | [] | 0 | 0 | |
| 135 →items22 →items23 →items20 →items21 | Café -Sortiment | 0 | 0 | [611, 844, 845, 850, 851, 854, 855, 864, 865, 866, 867, 868, 869, 870, 872, 874, 880, 895, 896, 902, 904, 905, 906, 907, 908, 909, 910, 911, 912, 913, 946] | 0 | 0 |
A warehouse category subgroup. An Item can be in multiple subgroups.
| # | Field | Type | Description | Links |
|---|---|---|---|---|
| 0 | id | int | internal subgroup id | 🔗 subgroup_id |
| 1 | name | string | subgroup name | |
| 2 | group_id | int | reference to the warehouse category this group is part | 🔗 group_id |
| 3 | count | int | number of child elements in that subgroup | |
| 4 | image_hash | string | hashcode for the main subgroup image, if any. see image proxy doc on how to obtain the image. | |
| 5 | thumb_hash | string | hashcode for the small subgroup image (for list display), if any. see image proxy doc on how to obtain the image. | |
| 6 | description | string | html-ready category description |
Data (110 records)
An assortment is a temporary collection of items, presented and delivered as one box (aka Abobox). This record describes that box itself.
| # | Field | Type | Description | Links |
|---|---|---|---|---|
| 0 | id | int | internal id | 🔗 assortment_id |
| 1 | name | string | assortment name | |
| 2 | description | string | html-ready longer description | |
| 3 | persons | int | the intended number of persons to consume it | |
| 4 | price | double | target price for this assortment | |
| 5 | planned | bool | if true, thus flag tells if the assortment was already planned in detail (items are assigned) | |
| 6 | image_hash | string | hashcode for the image, if any. see image proxy doc on how to obtain the image. | |
| 7 | planned_from | date | Date range start if the assortment is planned | |
| 8 | planned_until | date | Date range end if the assortment is planned | |
| 9 | items | int | Number of items in this assortment, if planned | |
| 10 | abogroupid | int | reference to an abogroup type this assortment belongs to | |
| 11 | variantid | int | reference to an abogroup variant this assortment belongs to | |
| 12 | containerid | int | reference to an abogroup container this assortment belongs to | |
| 13 | short_description | string | html-ready short description | |
| 14 | hidden | bool | this assortment is currently not visible if true | |
| 15 | packstation | int | reference to an packing station. Needed if it comes to minimum order value calculation | |
| 16 | thumb_hash | string | hashcode for the small image (for list display), if any. see image proxy doc on how to obtain the image. | |
| 17 | noabo | bool | if true, this assortment is not available for subscriptions |
Data (36 records)
| id | name | description | persons | price | planned | image_hash | planned_from | planned_until | items | abogroupid | variantid | containerid | short_description | hidden | packstation | thumb_hash | noabo | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 38 →assortment13 | Bürokiste gemischt | mit versch. Obst + Gemüse, ohne aufwendige Zubereitung verzehrbar | 6 | 25.0 | true | -1821035497 | 2026-11-23 | 2026-11-29 | 4 | 7 | 0 | 19 | false | 0 | false | |||
| 39 →assortment13 | Bürokiste Obst | mit verschiedene Obstsorten, ohne aufwendige Zubereitung verzehrbar | 6 | 25.0 | true | -1817341413 | 2026-11-23 | 2026-11-29 | 3 | 7 | 0 | 20 | false | 0 | false | |||
| 7 →assortment13 | Standardkiste groß | Gemüse, Salat und Obst<br class="wikibr1"/> | 4 | 30.0 | true | -1901381824 | 2026-11-23 | 2026-11-29 | 9 | 1 | 15 | 19 | false | 0 | false | |||
| 9 →assortment13 | Kochkiste groß | mit verschiedenen Kochgemüsen der Saison | 4 | 30.0 | true | -1878293799 | 2026-11-23 | 2026-11-29 | 7 | 2 | 15 | 21 | false | 0 | false | |||
| 12 →assortment13 | Schonkostkiste groß | mit Gemüse und Salat ohne treibende und blähende Arten | 4 | 30.0 | true | -1874599715 | 2026-11-23 | 2026-11-29 | 7 | 3 | 15 | 21 | false | 0 | false | |||
| 14 →assortment13 | Rohkostkiste groß | mit Gemüse für die schnelle, kalte Küche und reichlich Salat | 4 | 30.0 | true | -1813647329 | 2026-11-23 | 2026-11-29 | 6 | 4 | 15 | 21 | false | 0 | false | |||
| 18 →assortment13 | Regionalkiste groß | mit Gemüse und Salat aus eigener oder regionaler Produktion | 4 | 30.0 | true | -1847817606 | 2026-11-23 | 2026-11-29 | 6 | 5 | 15 | 21 | false | 0 | false | |||
| 16 →assortment13 | Obstkiste groß | mit Obst aus der Region und Südfrüchten der Saison<br class="wikibr1"/> | 6 | 30.0 | true | -1844123522 | 2026-11-23 | 2026-11-29 | 5 | 6 | 15 | 20 | false | 0 | false | |||
| 20 →assortment13 | Käsepaket groß | mit 4-5 wechselnden Käsesorten<br class="wikibr1"/> <br class="wikibr1"/><P class="wikip"></p> | 4 | 18.0 | true | -1707038462 | 2026-11-23 | 2026-11-29 | 5 | 8 | 15 | 22 | false | 0 | false | |||
| 42 →assortment13 | Wurstpaket groß | 4 | 17.5 | true | 1972397000 | 2026-11-23 | 2026-11-29 | 3 | 9 | 15 | 25 | false | 0 | false | ||||
| 3 →assortment13 | Standardkiste mittel | Gemüse, Salat und Obst<br class="wikibr1"/> | 2 | 25.0 | true | -1786865220 | 2026-11-23 | 2026-11-29 | 9 | 1 | 14 | 19 | false | 0 | false | |||
| 1 →assortment13 | Kochkiste mittel | mit verschiedenen Kochgemüsen der Saison | 2 | 25.0 | true | -1158870940 | 2026-11-23 | 2026-11-29 | 6 | 2 | 14 | 21 | false | 0 | false | |||
| 11 →assortment13 | Schonkostkiste mittel | mit Gemüse und Salat ohne treibende und blähende Arten | 2 | 25.0 | true | -1105306722 | 2026-11-23 | 2026-11-29 | 7 | 3 | 14 | 21 | false | 0 | false | |||
| 13 →assortment13 | Rohkostkiste mittel | mit Gemüse für die schnelle, kalte Küche und reichlich Salat | 2 | 25.0 | true | -1097918554 | 2026-11-23 | 2026-11-29 | 6 | 4 | 14 | 21 | false | 0 | false | |||
| 17 →assortment13 | Regionalkiste mittel | mit Gemüse und Salat aus eigener oder regionaler Produktion | 2 | 25.0 | true | -1048048420 | 2026-11-23 | 2026-11-29 | 6 | 5 | 14 | 21 | false | 0 | false | |||
| 15 →assortment13 | Obstkiste mittel | mit Obst aus der Region und Südfrüchten der Saison<br class="wikibr1"/> | 4 | 25.0 | true | -1017572227 | 2026-11-23 | 2026-11-29 | 5 | 6 | 14 | 20 | false | 0 | false | |||
| 6 →assortment13 | Standardkiste klein | Gemüse, Salat und Obst<br class="wikibr1"/> | 1 | 20.0 | true | -1790559304 | 2026-11-23 | 2026-11-29 | 7 | 1 | 13 | 19 | false | 0 | false | |||
| 8 →assortment13 | Kochkiste klein | verschiedene Kochgemüse der Saison | 1 | 20.0 | true | -1162565024 | 2026-11-23 | 2026-11-29 | 6 | 2 | 13 | 21 | false | 0 | false | |||
| 10 →assortment13 | Schonkostkiste klein | mit Gemüse und Salat ohne treibende und blähende Arten | 1 | 20.0 | true | -1132088831 | 2026-11-23 | 2026-11-29 | 6 | 3 | 13 | 21 | false | 0 | false | |||
| 5 →assortment13 | Rohkostkiste klein | Gemüse für die schnelle kalte Küche mit reichlich Salat | 1 | 20.0 | true | -1101612638 | 2026-11-23 | 2026-11-29 | 6 | 4 | 13 | 21 | false | 0 | false | |||
| 4 →assortment13 | Regionalkiste klein | reichlich Gemüse und Salate aus eigener oder regionaler Produktion | 1 | 20.0 | true | -1071136445 | 2026-11-23 | 2026-11-29 | 6 | 5 | 13 | 21 | false | 0 | false | |||
| 2 →assortment13 | Obstkiste klein | mit Obst aus der Region und Südfrüchten der Saison<br class="wikibr1"/> | 2 | 20.0 | true | -1044354336 | 2026-11-23 | 2026-11-29 | 5 | 6 | 13 | 20 | false | 0 | false | |||
| 19 →assortment13 | Käsepaket klein | mit 3-4 wechselnden Käsesorten<br class="wikibr1"/> | 2 | 12.0 | true | -1155316003 | 2026-11-23 | 2026-11-29 | 4 | 8 | 13 | 22 | false | 0 | false | |||
| 21 →assortment13 | Wurstpaket klein | mit 3-4 wechselnden Wurstsorten | 2 | 10.0 | true | -1622773199 | 2026-11-23 | 2026-11-29 | 2 | 9 | 13 | 25 | false | 0 | false | |||
| 32 →assortment13 | Obstkiste mini | mit Obst aus der Region und Südfrüchten der Saison | 1 | 15.0 | true | -1040660252 | 2026-11-23 | 2026-11-29 | 5 | 6 | 12 | 20 | false | 0 | false | |||
| 33 →assortment13 | Angebotskäse | 200g eines Angebotskäse | 2 | 4.0 | true | -875167603 | 2026-11-23 | 2026-11-29 | 1 | 8 | 16 | 22 | false | 0 | false | |||
| 34 →assortment13 | Angebotswurst | 2 | 4.0 | true | 1333567929 | 2026-11-23 | 2026-11-29 | 1 | 9 | 16 | 25 | false | 0 | false | ||||
| 36 →assortment13 | Weichkäseangebot | 2 | 5.0 | true | -995962048 | 2026-11-23 | 2026-11-29 | 2 | 8 | 23 | 22 | false | 0 | false | ||||
| 29 →assortment13 | Salatkarussell | 1 Salat, versch. Sorten | 2 | 3.2 | true | 1345032539 | 2026-11-23 | 2026-11-29 | 1 | 11 | 18 | 21 | false | 0 | false | |||
| 23 →assortment13 | Brotkarussell | jede Woche 1 Brot und 1-3 Semmeln, versch. Sorten im Wechsel | 2 | 6.5 | true | -309062624 | 2026-11-23 | 2026-11-29 | 2 | 0 | 18 | 27 | false | 0 | false | |||
| 24 →assortment13 | Joghurt-Karussell 1 | 2 versch. Fruchtjoghurt 500g + 200g | 1 | 3.39 | true | 2026-11-23 | 2026-11-29 | 2 | 10 | 29 | 26 | false | 0 | false | ||||
| 25 →assortment13 | Joghurt-Karussell 2 | 2 versch. Fruchtjoghurt 500g + 200g | 1 | 3.39 | true | 2026-11-23 | 2026-11-29 | 2 | 10 | 30 | 26 | false | 0 | false | ||||
| 27 →assortment13 | Joghurt-Karussell 3 | 1 x 500g Fruchtjoghurt im Glas, verschiedene Sorten | 1 | 2.39 | true | 1542446122 | 2026-11-23 | 2026-11-29 | 1 | 10 | 31 | 26 | false | 0 | false | |||
| 28 →assortment13 | Joghurt-Karussell 4 | 1 x Fruchtjoghurt im 200g Becher, versch. Sorten | 1 | 1.0 | true | 1671528841 | 2026-11-23 | 2026-11-29 | 1 | 10 | 32 | 26 | false | 0 | false | |||
| 30 →assortment13 | Joghurt-Karussell 5 | 1 x 500g Fruchtjoghurt im Glas, versch. Sorten | 1 | 2.39 | true | 2026-11-23 | 2026-11-29 | 1 | 10 | 33 | 26 | false | 0 | false | ||||
| 45 →assortment13 | Fruchtquark- Karussel | 1 | 1.0 | true | -405008778 | 2026-11-23 | 2026-11-29 | 1 | 10 | 34 | 26 | false | 0 | false |
Assortments are usually groups (in types or sizes)
| # | Field | Type | Description |
|---|---|---|---|
| 0 | id | int | internal id |
| 1 | name | string | assortment name |
| 2 | description | string | html-ready longer description |
| 3 | cnt | int | child count |
| 4 | type | int | Group type: 0 (Boxtype, e.g. Family-Fruits), 2 (Grouing, e.g. Family Boxes), 1 (Size, e.g. small) |
| 5 | image_hash | string | hashcode for the main image, if any. see image proxy doc on how to obtain the image. |
| 6 | thumb_hash | string | hashcode for the small image (for list display), if any. see image proxy doc on how to obtain the image. |
| 7 | search | string | additional search terms for the shop search |
| 8 | hidden | bool | if true, currently not to be shown |
Data (31 records)
| id | name | description | cnt | type | image_hash | thumb_hash | search | hidden |
|---|---|---|---|---|---|---|---|---|
| 1 | Standardkiste | 3 | 0 | 7614e4e1c7b6071a918bbdb5e9e929c0 | 0 | false | ||
| 2 | Kochkiste | 3 | 0 | 4d4bb5c01b46d5083bba8dbf54159b1e | 0 | false | ||
| 3 | Schonkostkiste | 3 | 0 | fdd4bd71a38abc8cb6286db615576209 | 0 | false | ||
| 4 | Rohkostkiste | 3 | 0 | 40f24e5c4c94528aadbfcc5ee3f67b12 | 0 | false | ||
| 5 | Regionalkiste | 3 | 0 | 783f7434eb4088546bcc0b2f3453104f | 0 | false | ||
| 6 | Obstkiste | 4 | 0 | ff4b3cb74a4648c85ee4bbd16ff6b98b | 0 | false | ||
| 7 | Bürokiste | 2 | 0 | 171577b8d81813f55db23934d80c76e1 | 0 | false | ||
| 11 | Salatkarusell | 1 | 0 | dda0da202d6aa7e956f7127145e34d6d | 0 | false | ||
| 8 | Käsepaket | 4 | 0 | a9516d3fc68fd2848cc9a644f4e8861f | 0 | false | ||
| 9 | Wurstpaket | 3 | 0 | a7fabcf28da672c71850b8d9cc03b9f0 | 0 | false | ||
| 10 | Joghurtkarussell | 6 | 0 | 48f3846690d2fbf7364e92880ff2cdb5 | 0 | false | ||
| 15 | groß | 8 | 1 | 0 | 0 | false | ||
| 14 | mittel | 6 | 1 | 0 | 0 | false | ||
| 13 | klein | 8 | 1 | 0 | 0 | false | ||
| 12 | mini | 1 | 1 | 0 | 0 | false | ||
| 16 | angebot | 2 | 1 | 0 | 0 | false | ||
| 23 | Weichkäse | 1 | 1 | 0 | 0 | false | ||
| 18 | Karuselle | 2 | 1 | 0 | 0 | false | ||
| 29 | Variante 1 Glas 500g + Becher 200g | 1 | 1 | 0 | 0 | false | ||
| 30 | Variante 2 Glas 500g + Becher 200g | 1 | 1 | 0 | 0 | false | ||
| 31 | Variante 3 Glas 500g | 1 | 1 | 0 | 0 | false | ||
| 32 | Variante 4 Becher 200g | 1 | 1 | 0 | 0 | false | ||
| 33 | Variante 5 Glas 500g | 1 | 1 | 0 | 0 | false | ||
| 34 | Quark 150g | 1 | 1 | 0 | 0 | false | ||
| 19 | Ökokisten mit Obst & Gemüse | 4 | 2 | fce087f92fcca709c521b8e0434b29fd | 0 | false | ||
| 21 | Ökokisten mit Gemüse | 13 | 2 | 0f5fc76626c614cecb28c90a26d384b3 | 0 | false | ||
| 20 | Ökokisten mit Obst | 5 | 2 | ac9897ab3cbc12e3f643658871e69ad1 | 0 | false | ||
| 22 | Abos mit Käse | 4 | 2 | 984949c0cc8d2c5147aec199aed4cc35 | 0 | false | ||
| 27 | Abos mit Brot & Backwaren | 1 | 2 | a08ba7b8cbc732b9dc98b46bc1cdbd12 | 0 | false | ||
| 26 | Abos mit Milchprodukte | 6 | 2 | 1202557b5361b4604b2a8c3bca632c26 | 0 | false | ||
| 25 | Abos mit Wurst & Fleisch | 3 | 2 | cc18c74167b4d8d5a4d6206ab8fbdd62 | 0 | false |
A warehouse rubric, often that is a internal price list. An Item can be in multiple rubrics.
| # | Field | Type | Description | Links |
|---|---|---|---|---|
| 0 | id | int | internal rubric id | 🔗 rubric_id |
| 1 | name | string | rubric name | |
| 2 | description | string | html-ready category description | |
| 3 | count | int | number of child elements in that rubric | |
| 4 | special | bool | if true, this rubric is marked as special (offering) rubric | |
| 5 | image_hash | string | hashcode for the main category image, if any. see image proxy doc on how to obtain the image. | |
| 6 | thumb_hash | string | hashcode for the small category image (for list display), if any. see image proxy doc on how to obtain the image. |
Data (14 records)
| id | name | description | count | special | image_hash | thumb_hash |
|---|---|---|---|---|---|---|
| 59 →items22 →items23 →items20 →items21 | Solange der Vorrat reicht | 62 | false | 0 | 0 | |
| 44 →items22 →items23 →items20 →items21 | Joghurt & Käse 30.11. - 6.12. | 8 | false | 0ce20c8b2bd635a958b27ac3d3e02985 | 0 | |
| 42 →items22 →items23 →items20 →items21 | Joghurt & Käse 23.- 29.11. | 8 | true | 0ce20c8b2bd635a958b27ac3d3e02985 | 0 | |
| 38 →items22 →items23 →items20 →items21 | Wir empfehlen im November | 23 | true | 0 | 0 | |
| 25 →items22 →items23 →items20 →items21 | Aus dem Hofladen | 561 | false | 0 | 0 | |
| 15 →items22 →items23 →items20 →items21 | Adventsleckereien | 43 | true | f332bea8b1d821b04d7c073c59aaee70 | 0 | |
| 26 →items22 →items23 →items20 →items21 | Kühltheke | 45 | false | 0 | 0 | |
| 5 →items22 →items23 →items20 →items21 | Fleischangebot | 35 | false | cd84636ef6a48df1f45f73c4fc257201 | 0 | |
| 60 →items22 →items23 →items20 →items21 | Geflügelangebot | 11 | false | 5c8586969714020874850bd41d3de535 | 0 | |
| 94 →items22 →items23 →items20 →items21 | Für unsere Firmenkunden | 50 | false | 0 | 0 | |
| 70 →items22 →items23 →items20 →items21 | Fleischangebot für Weihnachten | 14 | false | 1ed5831359952ac99367450b6daa255e | 0 | |
| 84 →items22 →items23 →items20 →items21 | Rezepte | 55 | false | 0 | 0 | |
| 93 →items22 →items23 →items20 →items21 | Geschenkgutscheine | 12 | false | 0 | 0 | |
| 53 →items22 →items23 →items20 →items21 | Bienenwachskerzen | 0 | false |
Text snippets
| # | Field | Type | Description |
|---|---|---|---|
| 0 | id | int | internal article id |
| 1 | type | string | article type: article, profile |
| 2 | shortname | string | article unique short name |
| 3 | infotxt | string | long text |
| 4 | lastChanged | datetime | last changed timestamp |
| 5 | keywords | string | keywords that may be used for matching or searching, space delimited |
| 6 | format | string | format identifier |
| 7 | url | string | optional URL |
| 8 | image | bool | true/1 if it has an image |
| 9 | icon | bool | true/1 if it has an icon |
| 10 | hidden | bool | currently hidden for users and visitors |
Data (35 records)
| id | type | shortname | infotxt | lastChanged | keywords | format | url | image | icon | hidden | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | article | Newsletter Herbst 2025 | 2013-02-19T00:00:00+0100 | u | false | false | false | ||||
| 2 | profile | Höhenberger | Bio bringts! | 2013-02-19T09:04:14+0100 | hoehenberg | u | http://www.biokiste-höhenberg.de | true | true | false | |
| 3 | article | Biobauer Toni Wollschläger | Getreide, Kartoffeln, Rindfleisch, Eier aus der Region Freising Landshut | 2013-02-28T08:42:46+0100 | Wollschläger | u | false | false | false | ||
| 4 | profile | Biohof Bursch | DE-ÖKO-006 | 2013-02-28T08:45:20+0100 | u | http://www.biohof-bursch.de/biohof_bursch/home/hofportrait.cfm | false | false | false | ||
| 6 | article | Hofleben | Regional-Logo | 2013-03-07T06:35:42+0100 | std-navi | u | false | false | false | ||
| 8 | article | Aktuelles | Kontakt-Seite im CMS-Beispiel | 2014-03-23T17:17:37+0100 | std-navi | u | false | false | false | ||
| 10 | article | Über uns | Kontakt-Seite im CMS-Beispiel | 2014-03-23T17:24:33+0100 | std-navi | u | false | false | false | ||
| 12 | article | cmswirbieten | Kurzinfo über unser Angebot im CMS Beispiel | 2014-03-23T17:36:23+0100 | u | false | false | false | |||
| 13 | article | test | 2019-01-02T00:00:00+0100 | u | false | false | false | ||||
| 31 | article | std-header | 2019-08-26T13:54:34+0200 | u | false | false | false | ||||
| 23 | article | Produkt Newsletter | 2019-08-26T00:00:00+0200 | u | false | false | false | ||||
| 84 | article | Wir empfehlen im Februar | 2023-01-02T00:00:00+0100 | u | false | false | false | ||||
| 88 | article | Anschreiben Wertgutschein | 2023-01-04T00:00:00+0100 | u | false | false | false | ||||
| 90 | article | Wir empfehlen im Januar | 2023-01-27T00:00:00+0100 | u | false | false | false | ||||
| 100 | article | Newsletter 2/23 | 2023-04-03T00:00:00+0200 | u | false | false | false | ||||
| 112 | article | Homepage Ansicht | 2024-01-16T00:00:00+0100 | u | false | false | false | ||||
| 116 | article | Öffnungszeiten Hofladen & Hofcafe 2024 | 2024-01-16T00:00:00+0100 | u | false | false | false | ||||
| 120 | article | kulturland | 2024-07-10T00:00:00+0200 | u | false | false | false | ||||
| 128 | article | Wir empfehlen im Mai | 2025-03-04T00:00:00+0100 | u | false | false | false | ||||
| 132 | article | Wir empfehlen im April | 2025-03-18T00:00:00+0100 | u | false | false | false | ||||
| 47 | article | Zukunftshof | 2022-06-28T00:00:00+0200 | u | false | false | false | ||||
| 124 | article | testbob | 2025-01-09T00:00:00+0100 | u | false | false | false | ||||
| 104 | article | Befragung Uni Kassel | 2023-05-09T00:00:00+0200 | u | false | false | false | ||||
| 108 | article | Der Sommer ist da | 2023-06-05T00:00:00+0200 | u | false | false | false | ||||
| 52 | article | Newsletter 3+4/23 (juni/juli/August/september) | 2022-09-29T00:00:00+0200 | u | false | false | false | ||||
| 60 | article | Newsletter 6/22 | 2022-12-02T00:00:00+0100 | u | false | false | false | ||||
| 64 | article | Betriebsurlaub | 2022-12-05T00:00:00+0100 | u | false | false | false | ||||
| 68 | article | Dürfen wir Sie wieder beliefern? 10 % | 2022-12-09T00:00:00+0100 | u | false | false | false | ||||
| 76 | article | Geschenkkörbe | 2022-12-13T00:00:00+0100 | u | false | false | false | ||||
| 80 | article | Weinhachtswünsche | 2022-12-16T00:00:00+0100 | u | false | false | false | ||||
| 92 | article | Kistenpreiserhöhung | 2023-01-30T00:00:00+0100 | u | false | false | false | ||||
| 96 | article | Newsletter 1/23 | 2023-02-06T00:00:00+0100 | u | false | false | false | ||||
| 136 | article | Wir empfehlen im Juni | 2025-05-13T00:00:00+0200 | u | false | false | false | ||||
| 140 | article | Wir empfehlen im Juli | 2025-06-24T00:00:00+0200 | u | false | false | false | ||||
| 148 | article | Newsletter November 2025 | 2025-11-18T00:00:00+0100 | u | false | false | false |
Top Level Navigation entries
| # | Field | Type | Description |
|---|---|---|---|
| 0 | id | int | internal navigation id |
| 1 | name | string | name of this toplevel menu entry |
| 2 | title | string | title or alt text |
| 3 | thumb_hash | string | hashcode for the small navigation image (for list display), if any. see image proxy doc on how to obtain the image. |
| 4 | special | bool | navigation entry has a special meaning, its not to be displayed in a regular menu |
| 5 | image_hash | string | hashcode for the main category image, if any. see image proxy doc on how to obtain the image. |
| 6 | sorting | int | sorting sequence |
| 7 | link_url | string | link url. If it exists and no elements are under this menu point, its a direct link |
| 8 | count | int | number of child elements |
| 9 | nav_groups | string | a comma separated list of navigation groups (0,1,2,3) this menu entry is part of, 0 is default and means all. |
| 10 | search | string | a space separated list of search keywords for this navigation entry to be found |
| 11 | parent_id | int | if > 0, it might point to another navigation record as parent |
| 12 | gsort | int | if != 0, this int forms a global sort id for entries combined from Navigation and NavigationDetail |
Data (15 records)
| id | name | title | thumb_hash | special | image_hash | sorting | link_url | count | nav_groups | search | parent_id | gsort | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| -2 | Bisherige Lieferungen | 0 | false | 0 | -2 | 6 | 0 | 0 | 0 | ||||
| -3 | Meine Merkliste | 0 | false | 0 | -3 | 6 | 0 | 0 | 0 | ||||
| -1 | Suche | 0 | false | 0 | -1 | 1 | 0 | 0 | 0 | ||||
| 10 | Obst und Gemüse | 0 | false | 1 | 1 | 8 | 0 | 0 | 0 | ||||
| 13 | Aus der Kühltheke | 0 | false | 1 | 2 | 27 | 0 | 0 | 0 | ||||
| 12 | Aus dem Hofladen | 0 | false | 1 | 3 | 16 | 0 | 0 | 0 | ||||
| 11 | Sonderangebote | 0 | false | 1 | 4 | 13 | 0 | 0 | 0 | ||||
| 19 | Weihnachtszeit | 0 | false | 1 | 5 | 3 | 0 | 0 | 0 | ||||
| 15 | Abokisten | 0 | false | 1 | 6 | 3 | 0 | 0 | 0 | ||||
| 14 | Fürs Büro | 0 | false | 1 | 7 | 23 | 0 | 0 | 0 | ||||
| 16 | Rezepte | 0 | false | 1 | 8 | 1 | 0 | 0 | 0 | ||||
| 18 | Gutscheine | 0 | false | 1 | 9 | 12 | 0 | 0 | 0 | ||||
| 17 | Über uns | 0 | false | 1 | 10 | 4 | 0 | 0 | 0 | ||||
| 8 | Ticker Starprodukte | 0 | true | 1 | 11 | 8 | 0 | 0 | 0 | ||||
| 9 | Ticker Hauptseite | 0 | true | 1 | 12 | 4 | 0 | 0 | 0 |
Navigation Child Levels
| # | Field | Type | Description |
|---|---|---|---|
| 0 | entity | string | Object type to Link to |
| 1 | entityid | string | Object reference to Link to |
| 2 | sorting | int | sorting sequence within parent |
| 3 | navigationid | int | reference to parent |
| 4 | name | string | entry name (overrides entity's name if set) |
| 5 | id | int | internal record id, e.g. needed for image lookup |
| 6 | thumb_url | string | url for the small navigation image (for list display), if any. see image proxy doc on how to obtain the image. |
| 7 | search | string | search terms to support finding this menu level |
| 8 | gsort | int | global sorting, currently unused |
| 9 | shown_from | date | optional time frame to show this menu entry |
| 10 | shown_until | date | optional time frame to show this menu entry |
Data (125 records)
| entity | entityid | sorting | navigationid | name | id | thumb_url | search | gsort | shown_from | shown_until | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Order | 0 | -2 | 0 | 0 | |||||||
| Favourite | 0 | -3 | 0 | 0 | |||||||
| Search | 0 | -1 | 0 | 0 | |||||||
| Rubric | 37 | 1 | 8 | 105 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Rubric | 38 | 2 | 8 | 106 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Group | 25 | 2 | 10 | 129 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Group | 9 | 1 | 10 | 128 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Rubric | 32 | 1 | 11 | 213 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Rubric | 46 | 4 | 8 | 113 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Rubric | 47 | 5 | 8 | 127 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Rubric | 49 | 6 | 8 | 126 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Rubric | 42 | 7 | 8 | 125 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Rubric | 44 | 8 | 8 | 124 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Rubric | 45 | 9 | 8 | 123 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Item | 12070 | 0 | 9 | 119 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Item | 12075 | 0 | 9 | 120 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Item | 12076 | 0 | 9 | 121 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Item | 12077 | 0 | 9 | 122 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Group | 26 | 4 | 10 | 130 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Group | 79 | 3 | 10 | 131 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Rubric | 96 | 12 | 11 | Highlights der Woche | 132 | 0 | 2026-11-21 | 2027-11-22 | |||
| Rubric | 97 | 13 | 11 | Highlights der Woche | 133 | 0 | 2026-11-21 | 2027-11-22 | |||
| Rubric | 45 | 6 | 11 | 134 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Rubric | 46 | 7 | 11 | 135 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Rubric | 47 | 8 | 11 | 136 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Rubric | 49 | 9 | 11 | 137 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Rubric | 44 | 11 | 11 | 138 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Rubric | 42 | 10 | 11 | 139 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Rubric | 38 | 5 | 11 | 140 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Rubric | 37 | 4 | 11 | 141 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Rubric | 87 | 3 | 11 | 142 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Group | 134 | 4 | 12 | 143 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Group | 97 | 3 | 12 | 144 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Group | 115 | 5 | 12 | 145 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Group | 100 | 6 | 12 | 146 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Group | 98 | 7 | 12 | 147 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Group | 99 | 8 | 12 | 148 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Group | 121 | 9 | 12 | 149 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Group | 96 | 10 | 12 | 150 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Group | 20 | 11 | 12 | 151 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Group | 101 | 12 | 12 | 152 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Group | 135 | 13 | 12 | 153 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Group | 102 | 14 | 12 | 154 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Group | 103 | 15 | 12 | 155 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Group | 67 | 2 | 12 | 156 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Group | 94 | 12 | 13 | Milch, Milchprodukte & Co | 157 | 0 | 2026-11-21 | 2027-11-22 | |||
| Group | 123 | 13 | 13 | 158 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Group | 134 | 14 | 13 | 159 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Group | 19 | 15 | 13 | 160 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Rubric | 45 | 16 | 13 | 161 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Rubric | 46 | 17 | 13 | 162 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Rubric | 47 | 18 | 13 | 163 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Rubric | 49 | 19 | 13 | 164 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Rubric | 44 | 21 | 13 | 165 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Rubric | 42 | 20 | 13 | 166 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Rubric | 5 | 22 | 13 | 167 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Rubric | 60 | 23 | 13 | 168 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Rubric | 70 | 24 | 13 | 169 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Rubric | 94 | 22 | 14 | 170 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Rubric | 93 | 23 | 14 | 171 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Assortment | 38 | 19 | 14 | 172 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Assortment | 39 | 20 | 14 | 173 | 0 | 2026-11-21 | 2027-11-22 | ||||
| AssortmentGroup | 0 | 2 | 15 | 177 | 0 | 2026-11-21 | 2027-11-22 | ||||
| AssortmentContainer | 0 | 1 | 15 | 178 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Group | 109 | 0 | 16 | 179 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Assortment | 23 | 16 | 12 | 180 | 0 | 2026-11-21 | 2027-11-22 | ||||
| AssortmentContainer | 19 | 6 | 10 | 182 | 0 | 2026-11-21 | 2027-11-22 | ||||
| AssortmentContainer | 21 | 7 | 10 | 183 | 0 | 2026-11-21 | 2027-11-22 | ||||
| AssortmentContainer | 20 | 8 | 10 | 184 | 0 | 2026-11-21 | 2027-11-22 | ||||
| AssortmentContainer | 22 | 25 | 13 | 185 | 0 | 2026-11-21 | 2027-11-22 | ||||
| AssortmentContainer | 26 | 26 | 13 | 186 | 0 | 2026-11-21 | 2027-11-22 | ||||
| AssortmentContainer | 25 | 27 | 13 | 187 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Item | 1200 | 5 | 14 | 188 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Item | 1201 | 6 | 14 | 189 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Item | 1212 | 1 | 14 | 190 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Item | 1215 | 2 | 14 | 191 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Item | 1217 | 3 | 14 | 192 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Item | 1220 | 4 | 14 | 193 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Item | 1347 | 7 | 14 | 194 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Item | 1382 | 8 | 14 | 195 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Item | 1410 | 9 | 14 | 196 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Item | 1411 | 10 | 14 | 197 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Item | 1420 | 11 | 14 | 198 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Item | 1432 | 12 | 14 | 199 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Item | 1433 | 13 | 14 | 200 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Item | 1435 | 14 | 14 | 201 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Item | 1441 | 15 | 14 | 202 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Item | 1458 | 16 | 14 | 203 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Item | 1461 | 17 | 14 | 204 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Item | 1462 | 18 | 14 | 205 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Rubric | 59 | 2 | 11 | 211 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Webpage | https://schoenegge.de/naturkindergarten | 0 | 17 | Naturkindergarten | 208 | 0 | 2026-11-21 | 2027-11-22 | |||
| Webpage | https://schoenegge.de/erna | 0 | 17 | Erlebnis Naturgarten | 209 | 0 | 2026-11-21 | 2027-11-22 | |||
| Webpage | https://schoenegge.de/gaertnerei | 0 | 17 | Gärtnerei | 210 | 0 | 2026-11-21 | 2027-11-22 | |||
| Webpage | https://schoenegge.de/erna/ferienangebote | 0 | 17 | pädagogische Angebote und Kurse | 212 | 0 | 2026-11-21 | 2027-11-22 | |||
| Rubric | 32 | 1 | 12 | 215 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Rubric | 90 | 12 | 18 | 216 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Item | 20101 | 1 | 18 | 219 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Rubric | 90 | 21 | 14 | 218 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Item | 20110 | 2 | 18 | 220 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Item | 20115 | 3 | 18 | 221 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Item | 20120 | 4 | 18 | 222 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Item | 20125 | 5 | 18 | 223 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Item | 20130 | 6 | 18 | 224 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Item | 20140 | 7 | 18 | 225 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Item | 20150 | 8 | 18 | 226 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Item | 20160 | 9 | 18 | 227 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Item | 20180 | 10 | 18 | 228 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Item | 20190 | 11 | 18 | 229 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Item | 2002 | 2 | 13 | 230 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Item | 2013 | 1 | 13 | 232 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Item | 2003 | 8 | 13 | 233 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Item | 2004 | 10 | 13 | 234 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Item | 2005 | 9 | 13 | 235 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Item | 2008 | 7 | 13 | 236 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Item | 2011 | 11 | 13 | 237 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Item | 2017 | 5 | 13 | 239 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Item | 2020 | 6 | 13 | 240 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Item | 2035 | 4 | 13 | 241 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Item | 2037 | 3 | 13 | 242 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Rubric | 70 | 3 | 19 | 251 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Rubric | 53 | 2 | 19 | 252 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Rubric | 2 | 5 | 10 | 248 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Assortment | 23 | 3 | 15 | 249 | 0 | 2026-11-21 | 2027-11-22 | ||||
| Rubric | 15 | 1 | 19 | 250 | 0 | 2026-11-21 | 2027-11-22 |
Item-to-Subgroup Mapping
| # | Field | Type | Description |
|---|---|---|---|
| 0 | gid | int | subgroup reference |
| 1 | iid | int[] | item references, these items are in that SubGroup |
Data (127 records)
| gid | iid |
|---|---|
| 1 | [932, 220, 221, 222, 223, 224, 225, 226, 227, 228, 218, 291, 293, 294, 296, 298, 299, 297, 112, 118, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 191, 193, 196, 197, 198, 199, 130, 920, 195, 934, 933, 931, 930, 929, 928, 20257, 894, 324, 325, 327, 890, 892, 899, 893, 896, 891, 328, 320, 321, 322, 323, 326, 329, 391, 396, 398, 399] |
| 2 | [210, 211, 212, 213, 214, 215, 216, 217, 218, 219, 271, 272, 273, 274, 275, 111, 171, 172, 173, 112, 330, 318, 884, 371, 317, 319, 374, 310, 311, 312, 313, 314, 315, 316, 372, 373] |
| 3 | [600, 231, 232, 233, 234, 235, 236, 249, 133, 135, 132, 134, 131, 394, 330, 336, 364, 335, 331, 332, 333, 334, 390, 897, 898, 397, 391] |
| 4 | [231, 250, 251, 252, 254, 255, 256, 257, 259, 260, 261, 263, 258, 758, 144, 145, 146, 147, 148, 140, 151, 153, 364, 820, 361, 362, 750, 350, 359, 853, 360, 363, 344, 345, 349, 340, 346, 347, 348, 351, 353, 354, 355, 357, 358] |
| 5 | [237, 242, 243, 281, 282, 283, 284, 285, 286, 287, 288, 292, 294, 181, 183, 185, 371, 374, 384, 389, 337, 376, 388, 881, 372, 373, 381, 382, 383, 385, 386, 387, 880] |
| 6 | [410, 412, 414, 415, 423, 424, 425, 426, 427, 464, 413, 417, 419, 421, 411, 416, 418, 422, 428] |
| 7 | [456, 457, 454, 455, 458, 450, 451, 452, 453, 459] |
| 8 | [470, 476, 482, 472, 475, 480, 471, 478, 461, 462, 467, 468, 473] |
| 9 | [430, 434, 435, 436, 437, 438, 431, 432, 433] |
| 10 | [874, 441, 442, 443, 474, 479, 467] |
| 11 | [460, 466, 463, 465, 477] |
| 12 | [460, 464, 470, 478, 468] |
| 14 | [1048, 1049, 1047, 1054, 1023, 1020, 1021, 1022, 1024, 1025, 1026, 1028, 1041, 1029, 1040, 20301] |
| 15 | [1055, 1058, 1015, 1016, 1017, 1027, 20301] |
| 16 | [1057, 1023, 1039, 20301] |
| 17 | [2001, 2035, 2013, 2002, 2031, 2017, 2037, 2019] |
| 18 | [2199, 2292, 2202, 2201, 2212, 2232, 2298, 2278, 2005, 2004, 2052, 2283, 2247, 2277, 2257, 2215, 2217, 2420, 2421, 2021, 2254, 2195, 2241, 2219, 2296, 2216, 2006, 2000, 2410, 2411, 2413, 2043, 2050, 2196, 2244, 2044, 2412, 2218, 2240, 2256, 2210, 2204] |
| 19 | [2018, 2011, 2022, 2014, 2015, 2008, 2003, 2025, 2039, 2030, 2012] |
| 20 | [2046, 2051, 2057, 2059, 2070, 2071, 2041, 2009, 2032, 2033, 2034, 2036, 2029, 2448, 2028, 2010, 2449, 2450] |
| 21 | [2973, 2062, 2063, 2064, 2058, 2631, 2049, 2044, 2442, 2441, 2440, 2439, 2961] |
| 22 | [2796, 2797, 2840, 2839, 2838, 2799, 2798, 2845, 2843, 2846, 2836, 2847, 2496, 2848, 2827, 2812, 2795, 2794, 2793, 1050, 1051, 2811, 2820, 2821, 2800, 2806, 2818, 2802, 2803, 2810, 2815, 2808, 2813] |
| 23 | [2819, 2655, 2625, 2429, 2650, 2664, 2632, 2432, 2622, 2435, 2430, 2663, 2433, 2070, 2071, 2665, 2408, 2627, 2654, 2656, 2437, 2436, 2620, 2657, 2621] |
| 24 | [2091, 2090, 2094, 2093] |
| 25 | [20258, 195, 190, 112, 121, 118, 123, 122, 124, 127, 125, 129, 191, 120, 197, 199, 920, 126, 198, 130, 128, 193, 196] |
| 26 | [20258, 112, 172, 111, 173, 171] |
| 27 | [20258, 132, 133, 135] |
| 28 | [20258, 148, 162, 131, 140, 147, 134, 157, 144, 145, 160, 146, 143, 142, 155, 151, 153, 154] |
| 29 | [20258, 181, 185, 183] |
| 30 | [118, 112, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 191, 193, 196, 197, 198, 199, 130, 920, 195, 934, 933, 931, 930, 929, 928, 927, 926, 925, 924, 923, 922, 921, 932, 290, 218, 224, 227, 225, 226, 228, 294, 293, 296, 298, 220, 221, 222, 223, 291, 297, 299] |
| 31 | [111, 171, 172, 173, 112, 218, 213, 212, 272, 219, 217, 271, 273, 210, 214, 215, 216, 274, 275, 211] |
| 32 | [133, 135, 132, 131, 134, 234, 600, 249, 232, 231, 233, 235, 236] |
| 33 | [158, 144, 145, 146, 147, 148, 140, 151, 153, 261, 260, 250, 758, 255, 257, 259, 258, 256, 252, 254, 251, 263, 231] |
| 34 | [181, 183, 185, 294, 281, 282, 242, 243, 285, 292, 283, 284, 237, 286, 288, 287] |
| 36 | [4638, 4654, 4770, 4002, 4003, 4771, 4774] |
| 37 | [4640, 4546, 4612, 4652, 4653, 4506, 4509, 4631, 4770, 4873, 4876, 4888, 4878, 4889, 4879, 4872, 4871] |
| 38 | [4608, 4609, 4643, 4646, 4578, 4644, 4647, 4532, 4648, 4642, 4611, 4649, 4638, 4640, 4546, 4612, 4652, 4500, 4653, 4654, 4506, 4509, 4655, 4636, 4656, 4631, 4554, 4561, 4562, 4533, 4555, 4580, 4577, 4581, 4508, 4510, 4632, 4488, 4535, 4592, 4534, 4560, 4567, 4635, 4531, 4604, 4522, 4524, 4573, 4566, 4556, 4637, 4650, 4552, 4550, 4486, 4485, 4639, 4551, 4482, 4634, 4568, 4565, 4563] |
| 39 | [4793, 4792, 4791, 4062, 4060, 4703, 4700, 4701, 4702, 4986, 4001, 4770, 4002, 4003, 4771, 4774, 4873, 4876, 4888, 4878, 4889, 4879, 4872, 4871, 4786, 4979, 4980, 4981, 4994, 4995] |
| 41 | [6053, 6340, 6358, 6357, 6356, 6355, 6313, 6332, 6327, 6330, 6321, 6342, 6329, 6315, 6335, 6337, 6352, 6349, 6348, 6336, 6314, 6331, 6311, 6318, 6350, 6316, 6312, 6319, 6322, 6339, 6338] |
| 42 | [6034, 6011, 6003, 6010, 6015, 6032, 6025, 6026, 6000, 6001, 6009, 6014, 6038, 6039, 6012, 6018, 6029, 6016, 6040, 6035, 6031, 6041, 6005, 6043, 6004, 6002, 6033, 6049, 6050, 6017, 6019, 6045, 6054, 6056, 6055, 6008, 6020, 6052, 6006, 6013] |
| 43 | [6806, 6808, 6814, 6817, 6802, 6805, 6813, 6801, 6812, 6809, 6800] |
| 44 | [7803, 7805, 7807, 7800, 7801, 7815, 7809, 7817, 7814, 7816, 7811, 7802, 7804, 7806, 7812] |
| 45 | [7027, 7034, 7035, 7043, 7044, 7011, 7007, 7000, 7002, 7008, 7413, 7401, 7412, 7018, 7019, 7010, 7039] |
| 46 | [7815, 7006, 7032, 7031, 7005, 7037, 7004] |
| 47 | [7363, 7020, 7334, 7367, 7333, 7332, 7343, 7344, 7311, 7359, 7340, 7338, 7342] |
| 48 | [8053, 8019, 8023, 8050, 8051, 8052, 8000, 8152, 8002, 8007, 8036, 8037, 8004, 8042, 8046, 8043, 8008, 8009, 8006, 8047, 8010, 8045, 8013, 8059, 8012, 8014, 8044, 8016, 8018, 8041, 8020, 8022, 8024, 8028, 8030, 8003, 8011, 8032, 8034, 8039, 8038, 8143, 8144, 8146, 8145, 8150, 8148] |
| 50 | [8161, 8166, 8168, 8160, 8154, 8156, 8157, 8155] |
| 51 | [8405, 6839, 8407, 8406, 8365, 7998, 8572, 8573, 8254, 8203, 8399, 8575, 2495, 8363, 8355, 8354, 6832, 8556, 6828, 8367, 8376, 8388, 8375, 8377, 8379, 8596, 8250, 8378, 8248, 8249, 8246, 8385, 6821, 8371, 8382, 8384, 8356, 8200, 8202, 8586, 8201, 8205, 8585, 8584, 8372, 8374, 8513, 8510, 8512, 8511, 8514, 8361, 6831, 6825, 8360, 6826, 8362, 8524, 8525, 8592, 8593] |
| 52 | [8351, 8439, 8338, 8577, 8411, 8342, 8445, 8434, 8436, 8522, 8438, 8582, 8442, 8447, 8518, 8446, 8580, 8440, 8516, 8523, 8526, 8444, 8352, 8353, 8579, 8392, 8015, 8565, 21112, 8347, 8346, 8578, 8390, 8349, 8344, 8350, 8391] |
| 53 | [8328, 7335, 2024, 8130, 8163, 8479, 8494, 8340, 8493, 8327, 8326, 8339, 8332, 8456, 8460, 8496, 2060, 8466, 8468, 8476, 8478, 8472, 8608, 8470] |
| 54 | [6837, 8454, 8130, 8483, 8425, 6839, 7335, 8455, 8453, 8424, 8423, 8412, 6833, 8399, 8363, 8355, 8354, 6832, 6830, 8356, 8426, 8430, 8431, 8428, 8429, 8434, 8436, 8433, 8590, 8589, 26101, 8542, 8591, 8450, 8458, 8448, 8449, 8420, 8421, 8432, 8538, 8484, 8482, 8452, 8361, 6831, 6827, 8360, 8362, 8427, 8588] |
| 55 | [8459, 8492, 8491, 8490, 8465, 8494, 8340, 8493, 8468, 8604, 8480, 8461, 8464, 8462, 8463, 8467] |
| 56 | [6839, 8130, 8335, 8386, 5246, 8576, 8336, 8337, 8574, 8333, 8334, 8607, 8608] |
| 57 | [9159, 9187, 9267, 9149, 9195, 9186, 9194, 9196, 9191, 9183, 9935, 9193, 9079, 9129, 9084, 9188, 9189, 9192, 9177, 9184, 9114, 9151, 9150, 9152, 9153, 9154, 9190, 9174, 9175, 9176, 9178, 9179, 9180, 9049, 9050, 9051, 9940, 9941, 9910, 9197, 9198, 9199, 9111, 9115, 9200, 9201, 9107, 9911, 9901, 9085, 9087, 9086, 9073, 9012, 9231, 9232, 9278, 9924, 9922, 9043, 9923, 9048, 9276, 9279, 9236, 9071, 9010, 9014, 9020, 9023, 9024, 9021, 9245, 9046, 9058, 9230, 9277, 9042, 9044, 9235, 9926, 9068, 9920, 9921] |
| 58 | [9729, 9721, 9715, 9728, 9738, 8306, 9731, 9732, 9733, 9734, 9740, 9736, 9737, 9727, 9741, 9742, 9722, 9030, 9719, 9726, 9701, 9743, 9723, 9036, 9714, 9712] |
| 59 | [9181, 9088, 9710, 9097, 9095, 9083, 9350, 9098, 9101, 9351, 9005, 9032, 9002, 9031, 9015, 9013, 9270, 9004, 9799] |
| 60 | [9054, 9057, 9904, 9267, 9276, 9261, 9782, 9783, 9007, 9061, 9062, 9065, 9265, 9792, 9791, 9798, 9796, 9005, 9032, 9026, 9055] |
| 61 | [9029, 9149, 9103, 9145, 9146, 11045, 9900, 11046, 9925, 9028, 9177, 9056, 9174, 9175, 9176, 9940, 9941, 9910, 9111, 9115, 9200, 9201, 9107, 9911, 9901, 9904, 9924, 9922, 9923, 9064, 9913, 9914, 9912, 9909, 9903, 9919, 9908, 9906, 9905, 9920, 9921] |
| 62 | [9196, 9183, 9181, 9168, 9169, 9170, 9178, 9177, 9187, 9189, 9171, 9186, 9184, 9150, 9151, 9152, 9153, 9154, 9179, 9180, 9159, 9201, 9068, 9065] |
| 63 | [9035, 9702, 9056, 9705, 9350, 9015, 9351, 9706, 9707, 9708, 9798, 9005, 9032, 9031, 9799, 9701] |
| 64 | [11062, 11031, 11061, 11046, 11004, 11051, 11045, 11084, 11052, 11060, 11003, 11083, 11005, 11025, 11053, 11196, 11013, 11054, 11055, 11043, 11057, 11056, 11193, 11008, 11041, 11000, 11001, 11002, 11006, 11007, 11009, 11010, 11011, 11012, 11014, 11016, 11017, 11018, 11019, 11020, 11022, 11024, 11026, 11027, 11028, 11033, 11034, 11038, 11039, 11050, 11183, 11192, 11200] |
| 65 | [11347, 11332, 11348, 11342, 11339, 11337, 11345, 11331, 11335, 11336, 11338, 11340] |
| 66 | [11231, 9929, 9928, 9927, 11230] |
| 67 | [12025, 12140, 12024, 12023, 12020, 12002, 12000, 12021, 12003, 12001] |
| 68 | [12027, 12077, 12076, 12075, 12074, 12071, 12070, 12054, 12053, 12051, 12047, 12036, 12032, 12028, 12017, 12013, 12050, 12015, 12040, 12019, 12031, 12035, 12037, 12044, 12055, 12060, 12061, 12030, 12062, 12095, 12096, 12039, 12048, 12067, 12046, 12045, 12005, 12018, 12041, 12008, 12010, 12038, 12006, 12042, 12022, 12026, 12033, 12014, 12007, 12011, 12016, 12049, 12029] |
| 69 | [12948, 12940, 12939, 12915, 12916, 12950, 12945, 12941, 12924, 12923, 12922, 12919, 12918, 12914, 12927, 12925, 12944, 12943, 12908, 12911, 12229, 12920, 12900, 29948, 12902, 12949, 12912, 12901, 12906, 12909, 12904, 12905, 12921, 12903, 12907, 12910] |
| 70 | [12404, 12416, 12417, 12392, 12338, 12346, 12220, 12221, 12421, 12337, 12383, 12380, 12300, 12384, 12325, 12326, 12301, 12390, 12333, 12327, 12328, 12330, 12332, 12335, 12388, 12389, 12415, 12387, 12365, 12381, 12341, 12407, 12382, 12395, 12401, 12403, 12405, 12406, 12408, 12425, 12409, 12410, 12411, 12412, 12342, 12343, 12413, 12433, 12739, 12340, 12302, 12400, 12391, 12329, 12334, 12345, 12414, 12386, 12420, 12348, 12357, 12360, 12352, 12358, 12351, 12364, 12069, 12324, 12344] |
| 71 | [12110, 12111, 12117, 12079, 12078, 12214, 12363, 12362, 12361, 12356, 12355, 12350, 12211, 12208, 12207, 12125, 12119, 12118, 12113, 12106, 12105, 12089, 12034, 12140, 12927, 12210, 12121, 12122, 12925, 12126, 12127, 12108, 12090, 12086, 12091, 12226, 12088, 12087, 12083, 12085, 12084, 12080, 12213, 12206, 12200, 12203, 12204, 12209, 12202, 12109, 12212, 12082, 12058, 12115, 12059, 12057, 12218, 12229, 12116, 12920, 12707, 12703, 12704, 12702, 12700, 12701] |
| 72 | [14028, 14006, 14010, 14019, 14226, 14222, 14041, 14040, 14218, 14042, 14043, 14023, 14030, 14029, 14031, 14216, 14219] |
| 73 | [14050, 14229, 14230, 14051, 14249, 14248, 15332, 15340, 15336, 15338, 14039, 14045] |
| 74 | [14003, 14025, 14001, 14016, 14015, 14017, 14026, 14228, 14013, 14022, 14208, 14000, 14231] |
| 75 | [14234, 14245, 14246, 14247, 14217, 14214, 14233] |
| 76 | [14204, 14205, 14208, 14232, 14241] |
| 77 | [14021, 14235, 14014, 14243, 14244, 14250, 14236] |
| 78 | [15209, 15229, 15350, 15351, 15353, 15354, 15234, 15235, 15337, 15240, 15212, 15213, 15214, 15215, 15217, 15220, 15222, 15223] |
| 79 | [15023, 15304, 15300, 15301, 15302, 15303, 15310, 15311, 26251, 15305, 15338, 15022, 15208, 15020, 15200, 15202, 15203, 15204, 15206] |
| 80 | [15320, 15321, 15323, 15326, 15327, 15221, 15233, 15022, 15208, 15216, 15219, 15230] |
| 81 | [16016, 16017, 16020, 16021, 16022, 16023, 16024, 16025, 16008, 16009, 16004, 16005, 16006, 16007, 16010, 16026, 16011, 16027, 16012, 16028, 16013, 16029, 16018, 16019, 16054, 16053, 16014, 16015, 16055, 16056, 16066, 16067, 16068] |
| 82 | [21041, 21035, 21036, 21037, 21038] |
| 83 | [14259, 14254, 14258, 14255, 14257] |
| 85 | [5008, 5271, 5272, 5273, 5274, 5277, 5278, 5263, 5264, 5972, 5973, 5976, 5977, 26009, 5974, 5975, 5978, 5261, 5260, 5258, 5135, 5988, 5989] |
| 89 | [341, 301, 302, 342, 343] |
| 90 | [394, 392, 393, 895, 395] |
| 91 | [3932, 3933, 3962, 3949, 3420, 3950, 3416, 3430, 3415, 3418, 3411, 3407, 3427, 3400, 3401, 3423, 3953, 2030] |
| 92 | [3560, 3534, 3566, 3500, 3501, 3503, 3504, 3505, 3506, 3509, 3510, 3511, 3513, 3514, 3515, 3516, 3517, 3519, 3522, 3524, 3526, 3529, 3531, 3538, 3542, 3550, 3552, 3557, 3559, 3525, 3539, 3502, 3562, 3543, 3545, 3546, 3570, 3535, 3582, 3573, 3561, 3596, 3586, 3583, 3565, 3419, 3547, 3549] |
| 93 | [3633, 3601, 3691, 3631, 3674, 3645, 3664, 3766, 3640, 3841, 3652, 3751, 3638, 3624, 3678, 3670, 3605, 3615, 3619, 3672, 3781, 3788, 3858, 3682, 3621, 3540, 3572, 3690, 3703, 3807, 3606, 3609, 3611, 3616, 3617, 3625, 3628, 3630, 3634, 3635, 3644, 3650, 3655, 3660, 3661, 3646, 3669, 3676, 3681, 3684, 3687, 3694, 3697, 3806, 3809, 21126, 3701, 3663] |
| 94 | [3842, 3855, 3824, 3847, 3801, 3804, 3835, 3836, 3843, 3852, 3745] |
| 96 | [12004, 12068, 12066, 12065, 12072, 12073, 12052, 12063, 12058, 12059, 12057, 12056] |
| 98 | [9039, 8996, 8994, 8995, 8993, 9027, 9025, 9003] |
| 99 | [20270, 20258, 926, 931, 923, 924, 925, 933, 927, 922, 921, 928, 929, 930, 934] |
| 100 | [3944, 3930, 3931, 3962, 3949, 3950, 3936, 3961, 3964, 3966, 3970, 3972, 3973, 3975, 3979, 3952, 3953, 3958, 3946, 3967, 3938, 3959, 3976] |
| 101 | [3936, 3924, 3997, 3965, 3988, 3980, 3985, 3987, 3938, 2497] |
| 102 | [2455, 2829, 2653, 2973, 2432, 2024, 2988, 2655, 2458, 2409, 2430, 2469, 2063, 2064, 2058, 2500, 2501, 2433, 2425, 2965, 2847, 2496, 2480, 2464, 2481, 2812, 2408, 2429, 2426, 2427, 2474, 2420, 2421, 2410, 2411, 2413, 2015, 2437, 2436, 2446, 2412, 2447, 2453, 2489, 2459, 2462, 2463, 2466, 2468, 2471, 2472, 2473, 2478, 2470, 2952, 2980, 2984, 2981] |
| 105 | [20254, 20256, 20258, 20260] |
| 106 | [20255, 20257, 20260] |
| 107 | [20262, 20263] |
| 108 | [20265, 20266, 20267, 20268] |
| 109 | [20261] |
| 110 | [20254, 20259, 20260] |
| 111 | [20262, 20263, 20264] |
| 112 | [5154, 5012, 5015, 5016, 5021, 5024, 5010, 5018, 5017, 5601, 5604, 5605, 5606, 5156, 5159, 5158, 5157, 8244, 5141, 5152, 8251, 5161, 8250, 8247, 8249, 8246] |
| 114 | [5149, 5602, 5004, 5603, 5610, 5601, 5593, 5604, 5605, 5592, 5560, 5583, 5582, 5581, 5589] |
| 117 | [4975, 4976, 4978, 4977, 4655, 0, 4986, 4979, 4980, 4981, 4982, 4983, 4984, 4985, 4994, 4995, 4997] |
| 118 | [10101, 10100] |
| 119 | [10401, 10400, 10402, 10409, 10412, 10416, 10413, 10411, 10410, 10414, 10418, 10419, 10450, 10451, 10452, 10454] |
| 120 | [10511, 10510] |
| 121 | [10300] |
| 122 | [10200, 10201] |
| 125 | [37026, 31314, 31310, 32702, 34305, 37004, 37002, 31315, 37023, 35007, 37303, 37302, 34307, 37021, 36708, 31322, 34317, 36710] |
| 126 | [31300, 34304, 31102, 31701, 31312, 31311, 37017, 38303, 32706, 31105, 36706] |
| 127 | [31100, 37003, 31306, 37008, 37007, 37024, 31307, 37013, 38307, 31304, 35009, 31319, 34309, 36000, 36004, 39305, 31320, 37022, 31106, 36005] |
| 129 | [32705, 33001, 31301, 37008, 32700, 36709, 37005, 37011, 37302, 34701, 35000, 35010, 36701, 36702, 31321, 34316] |
| 130 | [32703, 34304, 31309, 37006, 37014, 37016, 37018, 37020, 37300, 37301, 37304, 38306, 39300, 36707, 34306, 34308, 34313, 34314, 34700, 34702, 35002, 31700, 35003, 35004, 36001, 36003, 32706, 31320, 31105, 32707, 34310, 34315] |
| 131 | [31305, 36705, 37001, 31308, 32701, 37009, 38301, 38305, 39301, 39302, 31317, 33004, 31318, 34312, 35001] |
| 132 | [31104, 31316, 35008, 34303, 31313, 31103, 37010, 38308, 39304, 34311] |
| 133 | [37000, 36703, 33002, 36706, 31101, 37015, 37019, 37302, 37303, 38309, 35003, 35004, 35006, 36700, 36005] |
| 134 | [33003, 31302, 34300, 36704, 34302, 37012, 38300, 38302, 39303, 31701, 34313, 35000, 35005, 36002, 34316, 34318, 36005] |
| 135 | [31303, 37006, 32704, 37013, 38306, 34309, 36000, 36004, 37025] |
| 137 | [33000, 34301, 38304] |
| 138 | [2426, 2427, 2417, 2015, 2024, 2409, 2410, 2411, 2412, 2413, 2414, 2415, 2416, 2659, 2660, 2420, 2421, 2422, 2423, 2425, 2430, 2431, 2434, 2435, 2436, 2653, 2655, 2819, 2433, 2961, 2962, 2963, 2964, 2967, 2966, 2973, 2977, 2968, 2965, 2971, 2976, 2972, 2970, 2063, 2064, 2058, 2500, 2501] |
| 139 | [2980, 2447, 2982, 2985, 2984, 2981, 2983, 2473, 2472, 2476, 2952, 2804, 2458, 2465, 2467, 2471, 2831, 2817, 2479, 2829, 2830, 2482, 2834, 2446, 2453, 2491, 2470, 2460, 2462, 2468, 2989, 2466, 2452, 2459, 2478, 2487, 2489, 2469, 2988, 2463, 2833] |
| 140 | [12222, 12466, 12451, 12453, 12454, 12455, 12456, 12457, 12458, 12459, 12460, 12461, 12462, 12463, 12464, 12465, 12467, 12468] |
| 141 | [2904, 10516] |
| 142 | [20269, 20293, 20292, 20291, 20290, 20289, 20288, 20270] |
| 143 | [15254, 15255, 15256, 15269, 15257, 15258, 15259, 15262, 15263, 15264, 15265, 15266, 15267, 15268, 15253, 15252, 15251, 15250, 15249, 15248, 15247, 15246, 15245, 15244, 15243, 15242, 15241] |
| 144 | [1055, 1046, 1056, 1057, 1058] |
| 145 | [7042, 7030, 7017, 7028] |
| 117877440 | [2025] |
Item-to-Rubric Mapping
| # | Field | Type | Description |
|---|---|---|---|
| 0 | rid | int | rubric reference |
| 1 | iid | int[] | item reference, these items are in that subgroup |
Data (16 records)
| rid | iid |
|---|---|
| 2 | [477, 3543, 481, 475, 2091, 347, 428, 2090, 144, 3694, 393, 253, 351, 461, 399, 397, 395, 392, 390, 3526, 471, 898, 465, 2274, 462, 419, 228, 451, 349, 345, 257, 314, 611, 421, 346, 415, 348, 2036, 332, 329, 457, 319, 467, 333, 443, 389, 453, 442, 388, 318, 256, 193, 340, 302, 342, 315, 353, 880, 418, 301, 473, 387, 112, 224, 331, 452, 285, 881, 463, 456, 255, 344, 414, 317, 891, 130, 897, 133, 382, 258, 226, 895, 613, 313, 128, 211, 210, 316, 190, 283, 468, 286, 219, 343, 459, 458, 196, 354, 127, 312, 450] |
| 5 | [4560, 4524, 4578, 4523, 4573, 4551, 4500, 4567, 4772, 4485, 4565, 4504, 4505, 4536, 4533, 4566, 4531, 4787, 4503, 4876, 4522, 4512, 4510, 4508, 4507, 4535, 4782, 4871, 4872, 4873, 4878, 4889, 4781, 4774, 4789] |
| 15 | [12356, 9200, 8163, 9201, 9911, 9199, 12362, 8339, 9190, 8059, 9908, 6031, 11008, 9907, 9935, 12940, 11041, 8340, 9160, 9930, 9119, 9905, 9901, 12939, 9115, 9064, 9111, 5600, 9107, 9934, 9900, 5610, 5264, 11034, 9931, 12357, 5263, 9941, 9912, 21042, 9925, 5601, 9932] |
| 25 | [6325, 14218, 9701, 15299, 9726, 6335, 14204, 15217, 12920, 12918, 12907, 12906, 12904, 12903, 12900, 12415, 12413, 12405, 12395, 12390, 12384, 12382, 12354, 12353, 12347, 12343, 12342, 12341, 12340, 12335, 12333, 12332, 12220, 15354, 12085, 12084, 12083, 12082, 5009, 12080, 12067, 12059, 12058, 12057, 12056, 12053, 12049, 12048, 8028, 12046, 1024, 12041, 12038, 15325, 12014, 12013, 12011, 7006, 12008, 12005, 12003, 12002, 12001, 12000, 11342, 12044, 11335, 11331, 1025, 15308, 9719, 11050, 7370, 20215, 11037, 11030, 11028, 11027, 9004, 11024, 11018, 11017, 11016, 11015, 9750, 15234, 11011, 11010, 2973, 11006, 11004, 11002, 20214, 11000, 9796, 20205, 15206, 15221, 8446, 8342, 5154, 9052, 15225, 14245, 14236, 14235, 14234, 14233, 14232, 14231, 14230, 14228, 14226, 1015, 1017, 1016, 6010, 5143, 1020, 1021, 14016, 1023, 1022, 14010, 14007, 14006, 14002, 12949, 12921, 6332, 6330, 6313, 12075, 12209, 6315, 6314, 6050, 6020, 6019, 6013, 8406, 5972, 5261, 5260, 5258, 5157, 5152, 5150, 5039, 5021, 9015, 2277, 1041, 2043, 2090, 2037, 5246, 8439, 9271, 8483, 9238, 1026, 9236, 9235, 9232, 9113, 9112, 6329, 9261, 9083, 5243, 9077, 8339, 7338, 9062, 9047, 9046, 9044, 9043, 5242, 9032, 9031, 9030, 9026, 6006, 6045, 14216, 9021, 11013, 12060, 9011, 8429, 8039, 3658, 9005, 1043, 9003, 8594, 6349, 6827, 8592, 8589, 8588, 8586, 2965, 5988, 12070, 11338, 2244, 2469, 1047, 8584, 8583, 1045, 7367, 8577, 8168, 8571, 6300, 8556, 8524, 8514, 8510, 8497, 8362, 8496, 8494, 8484, 8482, 8166, 8480, 8473, 8470, 8008, 2017, 8468, 1027, 8461, 8460, 6026, 8458, 15338, 8452, 8000, 8450, 8448, 8444, 8440, 8438, 8437, 8434, 8997, 12943, 2035, 3762, 5156, 8389, 8376, 8373, 8372, 8003, 15341, 8364, 8360, 8355, 6052, 8354, 8353, 7004, 8352, 8351, 6011, 2060, 7000, 20020, 5583, 5587, 5592, 5595, 5600, 5606, 6800, 6801, 6802, 6805, 6814, 6817, 2018, 6039, 7326, 11339, 6025, 12096, 8341, 8340, 2012, 5601, 8591, 2966, 8337, 5161, 6352, 8334, 8332, 2964, 2002, 5135, 5593, 8329, 8325, 8324, 8251, 7018, 9035, 8141, 5586, 2015, 2963, 6339, 15306, 6015, 9934, 5015, 5263, 14219, 15353, 5139, 8249, 6034, 7037, 2025, 8244, 5004, 7816, 1028, 8160, 8252, 8011, 15351, 6032, 8038, 11052, 11025, 6316, 11031, 12218, 8156, 7804, 5018, 15209, 7017, 7016, 7363, 7800, 8154, 8152, 8150, 8148, 9931, 8146, 8004, 15350, 6001, 8144, 8143, 15342, 7005, 7002, 8037, 12066, 12035, 3938, 3415, 3416, 3430, 8047, 8023, 3684, 9935, 8380, 9743, 7801, 8046, 2981, 2005, 8045, 3745, 2011, 9097, 3856, 8044, 12086, 15310, 8399, 2091, 8379, 2003, 7344, 8016, 15220, 16003, 8431, 2446, 8018, 8019, 3519, 14023, 6317, 2972, 1040, 20204, 3573, 16001, 7340, 12109, 15327, 7031, 7030, 6000, 12380, 15326, 8014, 7817, 8557, 7032, 7807, 2804, 1039, 8575, 8012, 11231, 8459, 8030, 3522, 6312, 3562, 8006, 14013, 9240, 8010, 8024, 8032, 9702, 2010, 16000, 11014, 8365, 8426, 11353, 12010, 12338, 21022, 8253, 2453, 9350, 2008, 7028, 6319, 2654, 2052, 7020, 11084, 7043, 8060, 14000, 8022, 8385, 8034, 6340, 8040, 7311, 3631, 2009, 12927, 8492, 7369, 11083, 15230, 12020, 6323, 8026, 6003, 3635, 12392, 9751, 8042, 8027, 1053, 8020, 3836, 8161, 2980, 2462, 3936, 3924, 8350, 7035, 8002, 7342, 9022, 11039, 11003, 15321, 15320, 15311, 12912, 9741, 9000, 8007, 11336, 15332, 12071, 8402, 15229, 8254, 9710, 8454, 11349, 3638, 5581, 13992, 5278, 5277, 15305, 15343, 16096, 8427, 15323, 8203, 12076, 12212, 14217, 8445, 7368, 15340, 15331, 8328, 15329, 15303, 15300, 8378, 7034, 14001, 7044, 7998, 9930, 11053, 8370, 9932, 15301, 8386, 6837, 8994, 8158, 3964, 8200, 1046, 14040, 21033, 8403, 4644] |
| 26 | [3745, 8363, 3936, 3924, 3635, 3631, 2018, 2002, 2025, 3522, 3519, 3418, 3416, 2052, 2015, 2012, 2011, 2010, 2009, 2008, 2005, 3822, 2013, 2804, 2017, 3562, 2244, 2035, 2462, 2654, 3430, 2446, 8452, 2981, 3684, 2980, 2037, 2003, 2043, 3659, 3509, 2277, 3658, 3938, 4644] |
| 38 | [12075, 12074, 3425, 2965, 15341, 15217, 2815, 14235, 14001, 12070, 11345, 11030, 9351, 9198, 9197, 1058, 8389, 8364, 2650, 12071, 3711, 12076, 2430] |
| 42 | [2272, 3667, 3508, 3682, 2232, 3510, 2209, 2033] |
| 44 | [3526, 3543, 2203, 3662, 3694, 2234, 2036, 2274] |
| 53 | [16027, 16012, 16026, 16025, 16011, 16010, 16024, 16023, 16022, 16021, 16028, 16014, 16020, 16009, 16019, 16018, 16017, 16008, 16004, 16016, 16015, 16056, 16007, 16055, 16053, 16029, 16013, 16006, 16054, 16005] |
| 59 | [12092, 6016, 8141, 4644, 15026, 12055, 2431, 15264, 8583, 15259, 12468, 14017, 11043, 15258, 12108, 15257, 7039, 15253, 15252, 2033, 2257, 9721, 15251, 15249, 15240, 7019, 7413, 15248, 9728, 14044, 15242, 15241, 14030, 3674, 12063, 6838, 7010, 9101, 8051, 12052, 3691, 12927, 2051, 3639, 12331, 3586, 12404, 12022, 3701, 14246, 8412, 2211, 3561, 12093, 7042, 16096, 3622, 2032, 3548, 2632, 8993, 12062] |
| 60 | [4995, 4985, 4984, 4983, 4979, 4982, 4981, 4980, 4978, 4977, 4976] |
| 70 | [4990, 4901, 4900, 4879, 4992, 4870, 4789, 4788, 4542, 4062, 4998, 4997, 4996, 4991] |
| 71 | [20256, 20258, 20264, 20255, 20288, 20289, 20290, 20291, 20292, 20293, 20294, 20295, 20296, 20297, 20298, 20299, 20300, 20254, 20262, 20257, 20268, 20267, 20266, 20260, 20265, 20259] |
| 84 | [31311, 32705, 37301, 31300, 35003, 39303, 31308, 31319, 33000, 34307, 35005, 36710, 32704, 31320, 36709, 34318, 37025, 36703, 33005, 39305, 36708, 32706, 36004, 39300, 38304, 34300, 37006, 31100, 37001, 37004, 31322, 35010, 37022, 37014, 37305, 38302, 34702, 37021, 37011, 37012, 38306, 35006, 36006, 34301, 38303, 31305, 34312, 36005, 31314, 39302, 32701, 36001, 35004, 34308, 37026, 37304, 36003, 38308, 35002, 34316, 31307, 36706, 35001, 32707, 31105, 31106, 34314, 31700, 32703, 34317, 31301] |
| 93 | [20180, 20120, 20115, 20170, 20140, 20130, 20160, 20150, 20190, 20101, 20125, 20110] |
| 94 | [12001, 2013, 16003, 9719, 1411, 12000, 9350, 11339, 11017, 11003, 11331, 1212, 2012, 2017, 6814, 16001, 9710, 15332, 15331, 11030, 5592, 9083, 9031, 9030, 5595, 9015, 11028, 1347, 8480, 9750, 12067, 12020, 12003, 8461, 12002, 11344, 1462, 8459, 1461, 1215, 6805, 6801, 1200, 11024, 2973, 1220, 9702, 1410, 9097, 11352] |
Item-to-Assortment Mapping incl. amounts
| # | Field | Type | Description |
|---|---|---|---|
| 0 | aboboxenid | int | abobox reference |
| 1 | iid | int | item reference |
| 2 | amount | double | amount in units |
| 3 | unit | string | unit clear text name (translatable) |
| 4 | discount | int | idiscount percentage |
Data (156 records)
| aboboxenid | iid | amount | unit | discount |
|---|---|---|---|---|
| 38 | 353 | 2.0 | Stück | 0 |
| 38 | 382 | 1.0 | kg | 0 |
| 38 | 428 | 1.25 | kg | 0 |
| 38 | 458 | 1.3 | kg | 0 |
| 39 | 419 | 1.55 | kg | 0 |
| 39 | 428 | 1.5 | kg | 0 |
| 39 | 458 | 1.5 | kg | 0 |
| 7 | 112 | 1.0 | 100g | 0 |
| 7 | 224 | 1.0 | Stück | 0 |
| 7 | 210 | 1.0 | kg | 0 |
| 7 | 286 | 0.5 | kg | 0 |
| 7 | 345 | 0.35 | kg | 0 |
| 7 | 353 | 1.0 | Stück | 0 |
| 7 | 428 | 0.6 | kg | 0 |
| 7 | 458 | 0.6 | kg | 0 |
| 7 | 467 | 1.0 | Stück | 0 |
| 9 | 253 | 1.5 | kg | 0 |
| 9 | 210 | 1.2 | kg | 0 |
| 9 | 285 | 1.0 | kg | 0 |
| 9 | 286 | 0.5 | kg | 0 |
| 9 | 345 | 0.35 | kg | 0 |
| 9 | 317 | 0.4 | kg | 0 |
| 9 | 382 | 0.75 | kg | 0 |
| 12 | 253 | 1.4 | kg | 0 |
| 12 | 224 | 1.0 | Stück | 0 |
| 12 | 210 | 1.0 | kg | 0 |
| 12 | 286 | 0.7 | kg | 0 |
| 12 | 345 | 0.5 | kg | 0 |
| 12 | 353 | 1.0 | Stück | 0 |
| 12 | 382 | 1.2 | kg | 0 |
| 14 | 112 | 1.6 | 100g | 0 |
| 14 | 224 | 1.0 | Stück | 0 |
| 14 | 340 | 0.8 | kg | 0 |
| 14 | 345 | 0.5 | kg | 0 |
| 14 | 353 | 2.0 | Stück | 0 |
| 14 | 382 | 1.0 | kg | 0 |
| 18 | 112 | 1.8 | 100g | 0 |
| 18 | 228 | 1.0 | Stück | 0 |
| 18 | 285 | 1.2 | kg | 0 |
| 18 | 286 | 0.75 | kg | 0 |
| 18 | 317 | 0.6 | kg | 0 |
| 18 | 382 | 1.2 | kg | 0 |
| 16 | 419 | 1.5 | kg | 0 |
| 16 | 428 | 1.2 | kg | 0 |
| 16 | 458 | 1.0 | kg | 0 |
| 16 | 461 | 1.0 | kg | 0 |
| 16 | 467 | 2.0 | Stück | 0 |
| 20 | 3682 | 1.5 | 100g | 0 |
| 20 | 3508 | 1.5 | 100g | 0 |
| 20 | 3667 | 1.5 | 100g | 0 |
| 20 | 3510 | 1.1 | 100g | 0 |
| 20 | 3836 | 1.2 | 100g | 0 |
| 42 | 4500 | 0.15 | kg | 0 |
| 42 | 4508 | 1.0 | Stück | 0 |
| 42 | 4524 | 1.0 | Stück | 0 |
| 3 | 112 | 0.9 | 100g | 0 |
| 3 | 226 | 1.0 | Stück | 0 |
| 3 | 219 | 0.35 | kg | 0 |
| 3 | 286 | 0.35 | kg | 0 |
| 3 | 345 | 0.25 | kg | 0 |
| 3 | 353 | 1.0 | Stück | 0 |
| 3 | 428 | 0.5 | kg | 0 |
| 3 | 458 | 0.5 | kg | 0 |
| 3 | 467 | 1.0 | Stück | 0 |
| 1 | 253 | 1.4 | kg | 0 |
| 1 | 210 | 1.0 | kg | 0 |
| 1 | 285 | 1.0 | kg | 0 |
| 1 | 286 | 0.5 | kg | 0 |
| 1 | 345 | 0.35 | kg | 0 |
| 1 | 382 | 1.0 | kg | 0 |
| 11 | 253 | 1.3 | kg | 0 |
| 11 | 224 | 1.0 | Stück | 0 |
| 11 | 210 | 0.8 | kg | 0 |
| 11 | 286 | 0.5 | kg | 0 |
| 11 | 345 | 0.4 | kg | 0 |
| 11 | 353 | 1.0 | Stück | 0 |
| 11 | 382 | 0.85 | kg | 0 |
| 13 | 112 | 1.5 | 100g | 0 |
| 13 | 224 | 1.0 | Stück | 0 |
| 13 | 340 | 0.6 | kg | 0 |
| 13 | 345 | 0.5 | kg | 0 |
| 13 | 353 | 1.0 | Stück | 0 |
| 13 | 382 | 1.0 | kg | 0 |
| 17 | 112 | 1.6 | 100g | 0 |
| 17 | 228 | 1.0 | Stück | 0 |
| 17 | 285 | 1.0 | kg | 0 |
| 17 | 286 | 0.5 | kg | 0 |
| 17 | 317 | 0.5 | kg | 0 |
| 17 | 382 | 1.0 | kg | 0 |
| 15 | 419 | 1.3 | kg | 0 |
| 15 | 428 | 1.0 | kg | 0 |
| 15 | 458 | 1.0 | kg | 0 |
| 15 | 461 | 1.0 | kg | 0 |
| 15 | 467 | 1.0 | Stück | 0 |
| 6 | 253 | 1.2 | kg | 0 |
| 6 | 224 | 1.0 | Stück | 0 |
| 6 | 345 | 0.25 | kg | 0 |
| 6 | 353 | 1.0 | Stück | 0 |
| 6 | 428 | 0.4 | kg | 0 |
| 6 | 458 | 0.4 | kg | 0 |
| 6 | 467 | 1.0 | Stück | 0 |
| 8 | 253 | 1.2 | kg | 0 |
| 8 | 210 | 0.7 | kg | 0 |
| 8 | 285 | 0.8 | kg | 0 |
| 8 | 286 | 0.4 | kg | 0 |
| 8 | 345 | 0.35 | kg | 0 |
| 8 | 382 | 0.65 | kg | 0 |
| 10 | 253 | 1.2 | kg | 0 |
| 10 | 224 | 1.0 | Stück | 0 |
| 10 | 286 | 0.5 | kg | 0 |
| 10 | 345 | 0.4 | kg | 0 |
| 10 | 353 | 1.0 | Stück | 0 |
| 10 | 382 | 0.7 | kg | 0 |
| 5 | 112 | 1.0 | 100g | 0 |
| 5 | 224 | 1.0 | Stück | 0 |
| 5 | 340 | 0.5 | kg | 0 |
| 5 | 345 | 0.35 | kg | 0 |
| 5 | 353 | 1.0 | Stück | 0 |
| 5 | 382 | 0.75 | kg | 0 |
| 4 | 112 | 1.0 | 100g | 0 |
| 4 | 228 | 1.0 | Stück | 0 |
| 4 | 285 | 0.8 | kg | 0 |
| 4 | 286 | 0.45 | kg | 0 |
| 4 | 317 | 0.4 | kg | 0 |
| 4 | 382 | 0.8 | kg | 0 |
| 2 | 419 | 1.0 | kg | 0 |
| 2 | 428 | 0.8 | kg | 0 |
| 2 | 458 | 0.75 | kg | 0 |
| 2 | 461 | 0.8 | kg | 0 |
| 2 | 467 | 1.0 | Stück | 0 |
| 19 | 3682 | 1.3 | 100g | 0 |
| 19 | 3508 | 1.3 | 100g | 0 |
| 19 | 3667 | 1.0 | 100g | 0 |
| 19 | 3510 | 1.0 | 100g | 0 |
| 21 | 4508 | 1.0 | Stück | 0 |
| 21 | 4524 | 1.0 | Stück | 0 |
| 32 | 419 | 0.75 | kg | 0 |
| 32 | 428 | 0.6 | kg | 0 |
| 32 | 458 | 0.5 | kg | 0 |
| 32 | 461 | 0.5 | kg | 0 |
| 32 | 467 | 1.0 | Stück | 0 |
| 33 | 3682 | 1.65 | 100g | 0 |
| 34 | 4500 | 0.11 | kg | 0 |
| 36 | 3508 | 0.9 | 100g | 0 |
| 36 | 3510 | 0.9 | 100g | 0 |
| 29 | 228 | 1.0 | Stück | 0 |
| 23 | 1016 | 2.0 | Stück | 0 |
| 23 | 1028 | 1.0 | Stück | 0 |
| 24 | 2209 | 1.0 | 150g | 0 |
| 24 | 2272 | 1.0 | 500g | 0 |
| 25 | 2209 | 1.0 | 150g | 0 |
| 25 | 2232 | 1.0 | 500g | 0 |
| 27 | 2272 | 1.0 | 500g | 0 |
| 28 | 2209 | 1.0 | 150g | 0 |
| 30 | 2232 | 1.0 | 500g | 0 |
| 45 | 2033 | 1.0 | Stück | 0 |
Labels are part of a filter group (aka LabelGroup)
| # | Field | Type | Description |
|---|---|---|---|
| 0 | id | int | label group internal id |
| 1 | name | string | name of this label group |
| 2 | type | string | type of this label group: one of 'L' (Label for Display), 'F' (positive attribute, usually for labeling , such as 'is vegetarian'), 'N' negative attribute (such as 'contains milk: no') |
| 3 | content | int | content: 1: allergy values, 2: dietary values, 4 LMIV related, 5: analysis/nutrition, 6: packaging |
| 4 | visible | bool | if true, this filter is visible to all, not only admin |
Data (3 records)
| id | name | type | content | visible |
|---|---|---|---|---|
| 0 | Herkunft | F | 0 | true |
| 1 | Allergieinformation | N | 1 | true |
| 3 | Diäthinweise | F | 2 | true |
Arbitrary Labels for items. Depending on the labels group a label may have a positive ('ITEM X HAS...'), a negative ('ITEM X HAS NOT..') or just a informative meaning. Groups have label assignments too; labels may be relevant to items only if they are assigned to their groups. This is important when filtering for (positive) labels, as not all items will have ubiquitous labels assigned (greens are vegetarian by all means).
| # | Field | Type | Description |
|---|---|---|---|
| 0 | id | int | label internal id |
| 1 | lgid | int | belongs to this label group |
| 2 | implies | int[] | list of other labels, which is implied if this label is set. |
| 3 | name | string | name of this label group |
| 4 | hidden | bool | A label might be marked hidden - its meaning varies, but typically it means that it should not be offered for filtering (e.g. in labelgroup 0 - origin) |
| 5 | lmv | bool | true, if this label is relevant for the LMV (Lebensmittelverordnung) |
Data (179 records)
| id | lgid | implies | name | hidden | lmv |
|---|---|---|---|---|---|
| 0 | 0 | [3, 13, 39] | Regional | false | false |
| 844 | 1 | [] | Eier | false | false |
| 845 | 1 | [] | Erdnuss | false | false |
| 846 | 1 | [] | Fisch | true | false |
| 847 | 1 | [] | Gluten | false | false |
| 848 | 1 | [] | Krebstier | true | false |
| 849 | 1 | [] | Lupine | false | false |
| 850 | 1 | [] | Milch | false | false |
| 851 | 1 | [] | Schalenfrüchte | false | false |
| 852 | 1 | [] | Sellerie | false | false |
| 853 | 1 | [] | Senf | false | false |
| 854 | 1 | [] | Sesam | false | false |
| 855 | 1 | [] | SOJA | false | false |
| 856 | 1 | [] | Schwefeldioxid und Sulfite > 10mg/kg | false | false |
| 857 | 1 | [] | Weichtier | true | false |
| 858 | 1 | [] | Dinkel | false | false |
| 859 | 1 | [] | Gerste | false | false |
| 860 | 1 | [] | Hafer | false | false |
| 861 | 1 | [] | Kamut | true | false |
| 862 | 1 | [] | Roggen | false | false |
| 863 | 1 | [] | Weizen | false | false |
| 864 | 1 | [] | CASHEWNUSS | false | false |
| 865 | 1 | [] | Haselnuss | false | false |
| 866 | 1 | [] | Macadamianuss | false | false |
| 867 | 1 | [] | Mandeln | false | false |
| 868 | 1 | [] | Paranuss | false | false |
| 869 | 1 | [] | Pecanuss | false | false |
| 870 | 1 | [] | Pistazie | false | false |
| 872 | 1 | [] | Walnuss | false | false |
| 874 | 1 | [] | MILCHEIWEISS | false | false |
| 875 | 1 | [] | RIND | true | false |
| 876 | 1 | [] | SCHWEIN | true | false |
| 877 | 1 | [] | ANIS | true | false |
| 878 | 1 | [] | DILL | true | false |
| 879 | 1 | [] | FENCHEL | true | false |
| 880 | 1 | [] | FRUCTOSE | false | false |
| 881 | 1 | [] | KAKAO | false | false |
| 882 | 1 | [] | KERBEL | true | false |
| 883 | 1 | [] | KORIANDER | false | false |
| 884 | 1 | [] | Kümmel | true | false |
| 885 | 1 | [] | LIEBSTOECKEL | true | false |
| 886 | 1 | [] | MAIS | false | false |
| 887 | 1 | [] | PETERSILIE | true | false |
| 888 | 1 | [] | Pfeffer | true | false |
| 889 | 1 | [] | Umbelliferae | true | false |
| 890 | 1 | [] | ZIMT | false | false |
| 891 | 1 | [] | GLUTAMAT | true | false |
| 892 | 1 | [] | HEFE | false | false |
| 895 | 1 | [] | VANILLIN | true | false |
| 896 | 3 | [] | vegan | false | false |
| 897 | 3 | [] | glutenfrei | false | false |
| 899 | 3 | [] | laktosefrei | false | false |
| 901 | 3 | [] | Lebensmittel gentechnikfrei | true | false |
| 902 | 1 | [] | LACTOSE | false | false |
| 903 | 3 | [] | Rohkostqualität | false | false |
| 904 | 8 | [] | Pfandartikel Stück | false | false |
| 913 | 3 | [] | koscher | false | false |
| 914 | 3 | [] | ungesüßt | false | false |
| 917 | 1 | [] | Kuhmilcheiweiß | false | false |
| 918 | 3 | [] | Rohstoffe nicht jodiert | false | false |
| 938 | 1 | [] | KAROTTE | false | false |
| 945 | 1 | [] | sonstiges glutenhaltiges Getreide | true | false |
| 946 | 3 | [] | alkoholfrei | true | false |
| 971 | 3 | [] | streng natriumarm (<40 mg / 100g) | true | false |
| 611 | 3 | [] | vegetarisch | false | false |
| 907 | 6 | [] | Energie kJ / kcal | false | true |
| 908 | 6 | [] | Fett | false | true |
| 909 | 6 | [] | davon gesättigte Fettsäuren | false | true |
| 910 | 6 | [] | Kohlenhydrate | false | true |
| 912 | 6 | [] | davon Zucker | false | true |
| 906 | 6 | [] | Eiweiß | false | true |
| 911 | 6 | [] | Salz | false | true |
| 57 | 0 | [] | RC | false | false |
| 58 | 0 | [] | CI | false | false |
| 59 | 0 | [] | Italiene | false | false |
| 60 | 0 | [] | DSH | false | false |
| 61 | 0 | [] | DE - Baden Würtenberg | false | false |
| 62 | 0 | [] | DE - Tagwerkregion | false | false |
| 63 | 0 | [] | DNI | false | false |
| 64 | 0 | [61, 62] | DE - Bayern | false | false |
| 65 | 0 | [] | RA | false | false |
| 66 | 0 | [] | ZA | false | false |
| 67 | 0 | [] | PK | false | false |
| 68 | 0 | [] | K | false | false |
| 69 | 0 | [] | UA | false | false |
| 70 | 0 | [] | CDN | false | false |
| 71 | 0 | [] | DZ | false | false |
| 72 | 0 | [] | BG | false | false |
| 73 | 0 | [] | RO | false | false |
| 74 | 0 | [] | AUS | false | false |
| 75 | 0 | [] | J | false | false |
| 76 | 0 | [] | CO | false | false |
| 77 | 0 | [] | MOC | false | false |
| 78 | 0 | [] | PY | false | false |
| 79 | 0 | [] | GH | false | false |
| 80 | 0 | [] | LV | false | false |
| 81 | 0 | [] | PL | false | false |
| 82 | 0 | [] | FR | false | false |
| 83 | 0 | [] | DHE | false | false |
| 84 | 0 | [] | CM | false | false |
| 85 | 0 | [] | Honduras | false | false |
| 86 | 0 | [] | P | false | false |
| 87 | 0 | [] | PT | false | false |
| 88 | 0 | [] | BE | false | false |
| 89 | 0 | [] | Australien | false | false |
| 90 | 0 | [] | LI | false | false |
| 91 | 0 | [] | IE | false | false |
| 92 | 0 | [] | TH | false | false |
| 93 | 0 | [] | IN | false | false |
| 94 | 0 | [] | LT | false | false |
| 95 | 0 | [] | SK | false | false |
| 96 | 0 | [] | AZ | false | false |
| 97 | 0 | [] | CA | false | false |
| 98 | 0 | [] | UZ | false | false |
| 99 | 0 | [] | MG | false | false |
| 100 | 0 | [] | LK | false | false |
| 101 | 0 | [] | EAK | false | false |
| 102 | 0 | [] | DE - aus der Region | false | false |
| 103 | 0 | [] | DNW | false | false |
| 104 | 0 | [] | RCH | false | false |
| 105 | 0 | [] | CR | false | false |
| 106 | 0 | [] | CY | false | false |
| 107 | 0 | [] | PH | false | false |
| 108 | 0 | [] | XD | false | false |
| 109 | 0 | [] | UG | false | false |
| 110 | 0 | [] | FL | false | false |
| 111 | 0 | [] | DO | false | false |
| 112 | 0 | [] | Saudi Arabien | false | false |
| 113 | 0 | [] | RM | false | false |
| 114 | 0 | [] | MX | false | false |
| 115 | 0 | [] | DBB | false | false |
| 116 | 0 | [] | VN | false | false |
| 1 | 0 | [] | Österreich | false | false |
| 3 | 0 | [39] | DE - Bayern | false | false |
| 4 | 0 | [] | Baden-Württemberg | false | false |
| 5 | 0 | [] | Italien | false | false |
| 6 | 0 | [] | Holland | false | false |
| 7 | 0 | [] | Belgien | false | false |
| 8 | 0 | [] | Frankreich | false | false |
| 9 | 0 | [] | Spanien | false | false |
| 10 | 0 | [] | Ägypten | false | false |
| 11 | 0 | [] | Israel | false | false |
| 12 | 0 | [] | Marokko | false | false |
| 14 | 0 | [] | Vereinigten Staaten | false | false |
| 15 | 0 | [] | Bolivien | false | false |
| 16 | 0 | [] | Türkei | false | false |
| 20 | 0 | [] | Griechenland | false | false |
| 21 | 0 | [] | Rumänien | false | false |
| 54 | 0 | [] | Moldawien | false | false |
| 55 | 0 | [] | Tschechische Republik | false | false |
| 22 | 0 | [] | Dänemark | false | false |
| 24 | 0 | [] | Schweiz | false | false |
| 25 | 0 | [] | Gross-Britannien | false | false |
| 26 | 0 | [] | Irland | false | false |
| 27 | 0 | [] | Venezuela | false | false |
| 28 | 0 | [] | Argentinien | false | false |
| 29 | 0 | [] | Uganda | false | false |
| 30 | 0 | [] | Bulgarien | false | false |
| 31 | 0 | [] | Dominikanische Republik | false | false |
| 32 | 0 | [] | Kenia | false | false |
| 33 | 0 | [] | Indien | false | false |
| 34 | 0 | [] | Sri Lanka | false | false |
| 36 | 0 | [] | Elfenbeinküste | false | false |
| 37 | 0 | [3, 4, 64] | Deutschland | false | false |
| 38 | 0 | [] | Brasilien | false | false |
| 39 | 0 | [] | DE eigener Anbau | false | false |
| 56 | 0 | [] | Tunesien | false | false |
| 40 | 0 | [] | Ecuador | false | false |
| 41 | 0 | [] | Neuseeland | false | false |
| 42 | 0 | [] | Mexiko | false | false |
| 43 | 0 | [] | Südafrika | false | false |
| 44 | 0 | [] | Peru | false | false |
| 45 | 0 | [] | B.Faso | false | false |
| 46 | 0 | [] | Äthiopien | false | false |
| 47 | 0 | [] | China | false | false |
| 48 | 0 | [] | Chile | false | false |
| 49 | 0 | [] | Senegal | false | false |
| 50 | 0 | [] | Ungarn | false | false |
| 53 | 0 | [1, 5, 7, 8, 9, 20, 22, 24, 25, 26, 30, 37, 50] | Europa | false | false |