By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
id | contractmfgid | supplierid | rawmaterialid | quantity | dateinserted | datedeleted | isdelete | receiptno | returnid |
---|---|---|---|---|---|---|---|---|---|
209 | 17 | 56 | 151 | 4900 | 2021-02-27 11:56:28 | null | 0 | 259 | 135 |
210 | 17 | 58 | 125 | 58715 | 2021-02-27 11:56:28 | null | 0 | 259 | 135 |
211 | 17 | 56 | 152 | 38930 | 2021-02-27 11:56:28 | null | 0 | 259 | 135 |
212 | 17 | 59 | 173 | 78 | 2021-03-03 09:14:22 | null | 0 | 1 | 140 |
213 | 17 | 59 | 175 | 1427 | 2021-03-03 09:14:22 | null | 0 | 1 | 140 |
214 | 17 | 56 | 150 | 7478 | 2021-03-03 09:14:22 | null | 0 | 1 | 140 |
215 | 17 | 57 | 139 | 1830 | 2021-03-03 09:14:22 | null | 0 | 1 | 140 |
216 | 17 | 65 | 124 | 3498 | 2021-03-03 09:14:22 | null | 0 | 1 | 140 |
217 | 17 | 85 | 208 | 9 | 2021-03-03 09:14:22 | null | 0 | 1 | 140 |
218 | 17 | 59 | 173 | 61 | 2021-03-03 09:20:46 | null | 0 | 2 | 141 |
219 | 17 | 59 | 175 | 494 | 2021-03-03 09:20:46 | null | 0 | 2 | 141 |
220 | 17 | 56 | 150 | 1524 | 2021-03-03 09:20:46 | null | 0 | 2 | 141 |
221 | 17 | 57 | 139 | 220 | 2021-03-03 09:20:46 | null | 0 | 2 | 141 |
222 | 17 | 65 | 124 | 176 | 2021-03-03 09:20:46 | null | 0 | 2 | 141 |
223 | 17 | 85 | 208 | 35 | 2021-03-03 09:20:46 | null | 0 | 2 | 141 |
224 | 17 | 59 | 173 | 95 | 2021-03-03 09:31:04 | null | 0 | 3 | 142 |
225 | 17 | 59 | 175 | 678 | 2021-03-03 09:31:04 | null | 0 | 3 | 142 |
226 | 17 | 56 | 150 | 3006 | 2021-03-03 09:31:04 | null | 0 | 3 | 142 |
227 | 17 | 57 | 139 | 149 | 2021-03-03 09:31:04 | null | 0 | 3 | 142 |
228 | 17 | 65 | 124 | 153 | 2021-03-03 09:31:04 | null | 0 | 3 | 142 |
229 | 17 | 85 | 208 | 14 | 2021-03-03 09:31:04 | null | 0 | 3 | 142 |
230 | 17 | 59 | 174 | 54 | 2021-03-03 10:21:22 | null | 0 | 4 | 143 |
231 | 17 | 59 | 175 | 1961 | 2021-03-03 10:21:22 | null | 0 | 4 | 143 |
232 | 17 | 67 | 149 | 3317 | 2021-03-03 10:21:22 | null | 0 | 4 | 143 |
233 | 17 | 67 | 138 | 415 | 2021-03-03 10:21:22 | null | 0 | 4 | 143 |
234 | 17 | 67 | 123 | 1799 | 2021-03-03 10:21:22 | null | 0 | 4 | 143 |
235 | 17 | 85 | 208 | 22 | 2021-03-03 10:21:22 | null | 0 | 4 | 143 |
236 | 17 | 62 | 165 | 154 | 2021-03-03 10:55:54 | null | 0 | 5 | 144 |
237 | 17 | 87 | 166 | 571 | 2021-03-03 10:55:54 | null | 0 | 5 | 144 |
238 | 17 | 56 | 151 | 9927 | 2021-03-03 10:55:54 | null | 0 | 5 | 144 |
239 | 17 | 57 | 140 | 200 | 2021-03-03 10:55:54 | null | 0 | 5 | 144 |
240 | 17 | 88 | 167 | 67 | 2021-03-03 10:55:54 | null | 0 | 5 | 144 |
241 | 17 | 58 | 125 | 1429 | 2021-03-03 10:55:54 | null | 0 | 5 | 144 |
242 | 17 | 85 | 207 | 42 | 2021-03-03 10:55:54 | null | 0 | 5 | 144 |
243 | 17 | 62 | 165 | 257 | 2021-03-03 10:58:41 | null | 0 | 6 | 145 |
244 | 17 | 87 | 166 | 1500 | 2021-03-03 10:58:41 | null | 0 | 6 | 145 |
245 | 17 | 56 | 151 | 7479 | 2021-03-03 10:58:41 | null | 0 | 6 | 145 |
246 | 17 | 57 | 140 | 1159 | 2021-03-03 10:58:41 | null | 0 | 6 | 145 |
247 | 17 | 88 | 167 | 337 | 2021-03-03 10:58:41 | null | 0 | 6 | 145 |
248 | 17 | 58 | 125 | 5244 | 2021-03-03 10:58:41 | null | 0 | 6 | 145 |
249 | 17 | 85 | 207 | 324 | 2021-03-03 10:58:41 | null | 0 | 6 | 145 |
250 | 17 | 63 | 164 | 601 | 2021-03-03 11:12:25 | null | 0 | 7 | 146 |
251 | 17 | 87 | 166 | 1790 | 2021-03-03 11:12:25 | null | 0 | 7 | 146 |
252 | 17 | 56 | 152 | 13192 | 2021-03-03 11:12:25 | null | 0 | 7 | 146 |
253 | 17 | 57 | 142 | 2283 | 2021-03-03 11:12:25 | null | 0 | 7 | 146 |
254 | 17 | 88 | 167 | 544 | 2021-03-03 11:12:25 | null | 0 | 7 | 146 |
255 | 17 | 58 | 127 | 13979 | 2021-03-03 11:12:25 | null | 0 | 7 | 146 |
256 | 17 | 82 | 206 | 522 | 2021-03-03 11:12:25 | null | 0 | 7 | 146 |
257 | 17 | 58 | 132 | 762 | 2021-03-03 11:49:27 | null | 0 | 8 | 147 |
258 | 17 | 66 | 147 | 515 | 2021-03-03 11:49:27 | null | 0 | 8 | 147 |
259 | 17 | 85 | 209 | 3 | 2021-03-03 11:49:27 | null | 0 | 8 | 147 |
260 | 17 | 67 | 126 | 1720 | 2021-03-03 11:51:13 | null | 0 | 9 | 148 |
261 | 17 | 67 | 141 | 85 | 2021-03-03 11:51:13 | null | 0 | 9 | 148 |
262 | 17 | 65 | 128 | 895 | 2021-03-03 11:52:53 | null | 0 | 10 | 149 |
263 | 17 | 57 | 143 | 432 | 2021-03-03 11:52:53 | null | 0 | 10 | 149 |
264 | 17 | 85 | 209 | 10 | 2021-03-03 11:52:53 | null | 0 | 10 | 149 |
265 | 16 | 84 | 210 | 510 | 2021-03-16 13:49:57 | null | 1 | 11 | 150 |
266 | 16 | 64 | 168 | 850 | 2021-03-16 13:49:57 | null | 1 | 11 | 150 |
267 | 16 | 64 | 169 | 169 | 2021-03-16 13:49:57 | null | 1 | 11 | 150 |
268 | 16 | 64 | 172 | 4241 | 2021-03-16 13:49:57 | null | 1 | 11 | 150 |
269 | 16 | 80 | 205 | 55 | 2021-03-16 13:49:57 | null | 1 | 11 | 150 |
270 | 16 | 80 | 205 | 10 | 2021-03-16 13:54:02 | null | 0 | 12 | 151 |
271 | 16 | 64 | 172 | 1455 | 2021-03-16 13:54:02 | null | 0 | 12 | 151 |
272 | 16 | 64 | 170 | 174 | 2021-03-16 13:54:02 | null | 0 | 12 | 151 |
273 | 16 | 64 | 169 | 150 | 2021-03-16 13:54:02 | null | 0 | 12 | 151 |
274 | 16 | 80 | 205 | 26 | 2021-03-16 13:59:51 | null | 0 | 12 | 152 |
275 | 16 | 64 | 168 | 950 | 2021-03-16 13:59:51 | null | 0 | 12 | 152 |
276 | 16 | 64 | 172 | 4755 | 2021-03-16 13:59:51 | null | 0 | 12 | 152 |
277 | 16 | 84 | 210 | 82 | 2021-03-16 13:59:51 | null | 0 | 12 | 152 |
278 | 16 | 64 | 171 | 140 | 2021-03-16 14:04:31 | null | 0 | 13 | 153 |
279 | 16 | 64 | 170 | 186 | 2021-03-16 14:04:31 | null | 0 | 13 | 153 |
280 | 16 | 64 | 172 | 1723 | 2021-03-16 14:04:31 | null | 0 | 13 | 153 |
281 | 16 | 80 | 205 | 15 | 2021-03-16 14:04:31 | null | 0 | 13 | 153 |
282 | 16 | 64 | 168 | 1097 | 2021-03-16 14:07:02 | null | 0 | 14 | 154 |
283 | 16 | 64 | 172 | 4606 | 2021-03-16 14:07:02 | null | 0 | 14 | 154 |
284 | 16 | 80 | 205 | 18 | 2021-03-16 14:07:02 | null | 0 | 14 | 154 |
285 | 16 | 64 | 172 | 4235 | 2021-03-17 09:19:52 | null | 0 | 15 | 155 |
286 | 16 | 64 | 168 | 552 | 2021-03-17 09:19:52 | null | 0 | 15 | 155 |
287 | 16 | 64 | 169 | 192 | 2021-03-17 09:19:52 | null | 0 | 15 | 155 |
288 | 16 | 80 | 205 | 51 | 2021-03-17 09:19:52 | null | 0 | 15 | 155 |
289 | 16 | 64 | 168 | 285 | 2021-03-17 09:23:03 | null | 0 | 16 | 156 |
290 | 16 | 64 | 172 | 2159 | 2021-03-17 09:23:03 | null | 0 | 16 | 156 |
291 | 16 | 80 | 205 | 27 | 2021-03-17 09:23:03 | null | 0 | 16 | 156 |
292 | 16 | 84 | 210 | 1200 | 2021-03-17 09:23:03 | null | 0 | 16 | 156 |
293 | 16 | 80 | 205 | 59 | 2021-03-17 09:46:11 | null | 0 | 17 | 157 |
294 | 16 | 64 | 172 | 403 | 2021-03-17 09:46:11 | null | 0 | 17 | 157 |
295 | 16 | 64 | 168 | 149 | 2021-03-17 09:46:11 | null | 0 | 17 | 157 |
296 | 16 | 84 | 210 | 306 | 2021-03-17 09:46:11 | null | 0 | 17 | 157 |
297 | 16 | 64 | 168 | 24 | 2021-03-17 12:10:11 | null | 0 | 18 | 158 |
298 | 16 | 64 | 172 | 40 | 2021-03-17 12:10:11 | null | 0 | 18 | 158 |
299 | 16 | 80 | 205 | 2 | 2021-03-17 12:10:11 | null | 0 | 18 | 158 |
300 | 16 | 64 | 168 | 450 | 2021-03-17 12:13:54 | null | 0 | 19 | 159 |
301 | 16 | 64 | 172 | 2217 | 2021-03-17 12:13:54 | null | 0 | 19 | 159 |
302 | 16 | 84 | 210 | 48 | 2021-03-17 12:13:54 | null | 0 | 19 | 159 |
303 | 16 | 80 | 205 | 59 | 2021-03-17 12:13:54 | null | 0 | 19 | 159 |
304 | 16 | 64 | 169 | 255 | 2021-04-07 09:31:44 | null | 0 | 20 | 160 |
305 | 16 | 64 | 170 | 230 | 2021-04-07 09:31:44 | null | 0 | 20 | 160 |
306 | 16 | 64 | 172 | 2915 | 2021-04-07 09:31:44 | null | 0 | 20 | 160 |
307 | 16 | 80 | 205 | 20 | 2021-04-07 09:31:44 | null | 0 | 20 | 160 |
308 | 16 | 84 | 210 | 510 | 2021-04-07 09:35:08 | null | 0 | 21 | 161 |
309 | 16 | 64 | 168 | 850 | 2021-04-07 09:35:08 | null | 0 | 21 | 161 |
310 | 16 | 64 | 169 | 169 | 2021-04-07 09:35:08 | null | 0 | 21 | 161 |
311 | 16 | 64 | 172 | 4241 | 2021-04-07 09:35:08 | null | 0 | 21 | 161 |
312 | 16 | 80 | 205 | 55 | 2021-04-07 09:35:08 | null | 0 | 21 | 161 |
313 | 0 | 58 | 127 | 2529 | 2021-04-27 14:08:35 | null | 0 | 177 | 150 |
314 | 0 | 58 | 125 | 29035 | 2021-04-27 14:08:35 | null | 0 | 177 | 150 |
rawmaterialid | SUM(iwr.quantity) |
---|---|
151 | 22306 |
125 | 94423 |
152 | 52122 |
173 | 234 |
175 | 4560 |
150 | 12008 |
139 | 2199 |
124 | 3827 |
208 | 80 |
174 | 54 |
149 | 3317 |
138 | 415 |
123 | 1799 |
165 | 411 |
166 | 3861 |
140 | 1359 |
167 | 948 |
207 | 366 |
164 | 601 |
142 | 2283 |
127 | 16508 |
206 | 522 |
132 | 762 |
147 | 515 |
209 | 13 |
126 | 1720 |
141 | 85 |
128 | 895 |
143 | 432 |
205 | 342 |
172 | 28749 |
170 | 590 |
169 | 766 |
168 | 4357 |
210 | 2146 |
171 | 140 |