Historiensuchmaschine wirft Fehler

[roman.karuschka@…]

Fehler!

SELECT h.employee_id, h.itime::timestamp(0) AS itime, h.addition, h.what_done, emp.name, h.snumbers, h.trans_id AS id FROM history_erp h LEFT JOIN employee emp ON (emp.id = h.employee_id) WHERE (trans_id = 1 OR trans_id = 2 OR trans_id = 3 OR trans_id = 4 OR trans_id = 5 OR trans_id = 6 OR trans_id = 7 OR trans_id = 8 OR trans_id = 9 OR trans_id = 10 OR trans_id = 11 OR trans_id = 12 OR trans_id = 13 OR trans_id = 14 OR trans_id = 15 OR trans_id = 16 OR trans_id = 17 OR trans_id = 18 OR trans_id = 19 OR trans_id = 20 OR trans_id = 21 OR trans_id = 22 OR trans_id = 23 OR trans_id = 24 OR trans_id = 25 OR trans_id = 26 OR trans_id = 27 OR trans_id = 28 OR trans_id = 17 OR trans_id = 29 OR trans_id = 30 OR trans_id = 31 OR trans_id = 31 OR trans_id = 30 OR trans_id = 29 OR trans_id = 32 OR trans_id = 33 OR trans_id = 34 OR trans_id = 35 OR trans_id = 36 OR trans_id = 37 OR trans_id = 38 OR trans_id = 39 OR trans_id = 40 OR trans_id = 41 OR trans_id = 42 OR trans_id = 43 OR trans_id = 44 OR trans_id = 45 OR trans_id = 46 OR trans_id = 47 OR trans_id = 48 OR trans_id = 49 OR trans_id = 8 OR trans_id = 50 OR trans_id = 9 OR trans_id = 51 OR trans_id = 51 OR trans_id = 52 OR trans_id = 11 OR trans_id = 53 OR trans_id = 12 OR trans_id = 54 OR trans_id = 10 OR trans_id = 55 OR trans_id = 14 OR trans_id = 56 OR trans_id = 6 OR trans_id = 57 OR trans_id = 58 OR trans_id = 59 OR trans_id = 60 OR trans_id = 61 OR trans_id = 62 OR trans_id = 63 OR trans_id = 64 OR trans_id = 65 OR trans_id = 66 OR trans_id = 67 OR trans_id = 68 OR trans_id = 69 OR trans_id = 70 OR trans_id = 71 OR trans_id = 72 OR trans_id = 73 OR trans_id = 74 OR trans_id = 75 OR trans_id = 76 OR trans_id = 77 OR trans_id = 78 OR trans_id = 79 OR trans_id = 80 OR trans_id = 81 OR trans_id = 82 OR trans_id = 83 OR trans_id = 84 OR trans_id = 59 OR trans_id = 85 OR trans_id = 85 OR trans_id = 72 OR trans_id = 86 OR trans_id = 87 OR trans_id = 88 OR trans_id = 89 OR trans_id = 90 OR trans_id = 91 OR trans_id = 92 OR trans_id = 93 OR trans_id = 94 OR trans_id = 95 OR trans_id = 96 OR trans_id = 97 OR trans_id = 98 OR trans_id = 99 OR trans_id = 100 OR trans_id = 101 OR trans_id = 102 OR trans_id = 103 OR trans_id = 104 OR trans_id = 105 OR trans_id = 106 OR trans_id = 107 OR trans_id = 108 OR trans_id = 109 OR trans_id = 110 OR trans_id = 111 OR trans_id = 112 OR trans_id = 113 OR trans_id = 114 OR trans_id = 103 OR trans_id = 113 OR trans_id = 89 OR trans_id = 101 OR trans_id = 90 OR trans_id = 114 OR trans_id = 104 OR trans_id = 94 OR trans_id = 98 OR trans_id = 97 OR trans_id = 91 OR trans_id = 95 OR trans_id = 93 OR trans_id = 107 OR trans_id = 112 OR trans_id = 108 OR trans_id = 92 OR trans_id = 102 OR trans_id = 110 OR trans_id = 96 OR trans_id = 99 OR trans_id = 106 OR trans_id = 105 OR trans_id = 100 OR trans_id = 109 OR trans_id = 111 OR trans_id = 115 OR trans_id = 116 OR trans_id = 117 OR trans_id = 118 OR trans_id = 119 OR trans_id = 120 OR trans_id = 121 OR trans_id = 122 OR trans_id = 123 OR trans_id = 124 OR trans_id = 125 OR trans_id = 126 OR trans_id = 127 OR trans_id = 128 OR trans_id = 129 OR trans_id = 130 OR trans_id = 131 OR trans_id = 132 OR trans_id = 132 OR trans_id = 130 OR trans_id = 123 OR trans_id = 133 OR trans_id = 134 OR trans_id = 135 OR trans_id = 136 OR trans_id = 137 OR trans_id = 138 OR trans_id = 139 OR trans_id = 140 OR trans_id = 141 OR trans_id = 142 OR trans_id = 143 OR trans_id = 144 OR trans_id = 145 OR trans_id = 146 OR trans_id = 147 OR trans_id = 148 OR trans_id = 149 OR trans_id = 150 OR trans_id = 151 OR trans_id = 152 OR trans_id = 153 OR trans_id = 154 OR trans_id = 155 OR trans_id = 156 OR trans_id = 157 OR trans_id = 158 OR trans_id = 159 OR trans_id = 160 OR trans_id = OR trans_id = 161 OR trans_id = 162 OR trans_id = 163 OR trans_id = 164 OR trans_id = 165 OR trans_id = 166 OR trans_id = 167 OR trans_id = 168 OR trans_id = 169 OR trans_id = 170 OR trans_id = 171 OR trans_id = 172 OR trans_id = 173 OR trans_id = 174 OR trans_id = 169 OR trans_id = 175 OR trans_id = 176 OR trans_id = 177 OR trans_id = 178 OR trans_id = 179 OR trans_id = 180 OR trans_id = 177 OR trans_id = 178 OR trans_id = 179 OR trans_id = 180 OR trans_id = 176 OR trans_id = 181 OR trans_id = 181 OR trans_id = 182 OR trans_id = 183 OR trans_id = 184 OR trans_id = 185 OR trans_id = 186 OR trans_id = 187 OR trans_id = 188 OR trans_id = 189 OR trans_id = 190 OR trans_id = 191 OR trans_id = 192 OR trans_id = 193 OR trans_id = 194 OR trans_id = 195 OR trans_id = 196 OR trans_id = 197 OR trans_id = 198 OR trans_id = 199 OR trans_id = 200 OR trans_id = 201 OR trans_id = 202 OR trans_id = 203 OR trans_id = 204 OR trans_id = 205 OR trans_id = 206 OR trans_id = 207 OR trans_id = 208 OR trans_id = 209 OR trans_id = 210 OR trans_id = 211 OR trans_id = 212 OR trans_id = 213 OR trans_id = 214 OR trans_id = 215 OR trans_id = 216 OR trans_id = 217 OR trans_id = 218 OR trans_id = 219 OR trans_id = 220 OR trans_id = 221 OR trans_id = 222 OR trans_id = 223 OR trans_id = 224 OR trans_id = 225 OR trans_id = 226 OR trans_id = 227 OR trans_id = 228 OR trans_id = 229 OR trans_id = 230 OR trans_id = 231 OR trans_id = 232 OR trans_id = 233 OR trans_id = 234 OR trans_id = 235 OR trans_id = 236 OR trans_id = 237 OR trans_id = 238 OR trans_id = 239 OR trans_id = 240 OR trans_id = 241 OR trans_id = 242 OR trans_id = 243 OR trans_id = 244 OR trans_id = 245 OR trans_id = 246 OR trans_id = 247 OR trans_id = 248 OR trans_id = 249 OR trans_id = 249 OR trans_id = 250 OR trans_id = 251 OR trans_id = 252 OR trans_id = 253 OR trans_id = 254 OR trans_id = 255 OR trans_id = 256 OR trans_id = 257 OR trans_id = 258 OR trans_id = 259 OR trans_id = 260 OR trans_id = 261 OR trans_id = 262 OR trans_id = 263 OR trans_id = 264 OR trans_id = 265 OR trans_id = 265 OR trans_id = 266 OR trans_id = 266 OR trans_id = 267 OR trans_id = 268 OR trans_id = 268 OR trans_id = 269 OR trans_id = 268 OR trans_id = 270 OR trans_id = 269 OR trans_id = 270 OR trans_id = 271 OR trans_id = 272 OR trans_id = 273 OR trans_id = 274 OR trans_id = 275 OR trans_id = 276 OR trans_id = 277 OR trans_id = 278 OR trans_id = 279 OR trans_id = 280 OR trans_id = 281 OR trans_id = 282 OR trans_id = 283 OR trans_id = 284 OR trans_id = 285 OR trans_id = 286 OR trans_id = 287 OR trans_id = 288 OR trans_id = 289 OR trans_id = 290 OR trans_id = 291 OR trans_id = 292 OR trans_id = 293 OR trans_id = 294 OR trans_id = 295 OR trans_id = 296 OR trans_id = 297 OR trans_id = 298 OR trans_id = 299 OR trans_id = 300 OR trans_id = 301 OR trans_id = 302 OR trans_id = 303 OR trans_id = 304 OR trans_id = 305 OR trans_id = 306 OR trans_id = 307 OR trans_id = 308 OR trans_id = 189 OR trans_id = 309 OR trans_id = 310 OR trans_id = 311 OR trans_id = 312 OR trans_id = 313 OR trans_id = 314 OR trans_id = 315 OR trans_id = 316 OR trans_id = 317 OR trans_id = 318 OR trans_id = 319 OR trans_id = 320 OR trans_id = 321 OR trans_id = 322 OR trans_id = 323 OR trans_id = 324 OR trans_id = 325) AND ( addition = 'PAYMENT POSTED') ORDER BY h.itime DESC
FEHLER: Syntaxfehler bei »OR«
LINE 1: ...R trans_id = 159 OR trans_id = 160 OR trans_id = OR trans_i...

Da sollte ich wohl besser mehr zu schreiben

Es geht um den Aufruf der Historie zu Verkaufsrechnungen ohne weitere Spezifikation, bei der mich der der genannte Fehler aufkreuzt

Angesehen, verifiziert.

(und nebenbei besitmmt 20 Sanity verloren)

f3086ca05027abfa6affcc8ffa0fe9f8d096b24a sollte diesen speziellen Bug beheben.

Die Historiensuchmaschine ist aber weiterhin etwas seltsam.