select * from verkaufsregel where id_promotion = 677 and end_datum = '2012-12-31'44 - 2958
46 - 2959
47 - 2960
48 - 2961
49 - 2962
54 - 2963
56 - 2964
58 - 2965
60 - 2966
61 - 2967
62 - 2968
63 - 2969
64 - 2970
65 - 2971
66 - 2972
67 - 2973
71 - 2974
73 - 2975
76 - 2976
77 - 2977
78 - 2978
79 - 2979
80 - 2980
81 - 2981
82 - 2982
83 - 2983
84 - 2984
85 - 2985
88 - 2986
90 - 2987