SELECT * FROM ( SELECT
o.id,
importo,
spese,
destinazione,
to_char(to_timestamp(ora),'DD/MM/YYYY HH24:MI') ora,
trasporto,
note,
source_order,
MAX(data_spedizione) data_evaso_max,
MIN(data_spedizione) data_evaso_min,
SUM(quant) quant,
SUM(stato_os) onstock,
SUM(stato_sh + stato_arc_sh) sh,
SUM(stato_de + stato_arc_de) de,
SUM(stato_bo) bo
FROM ORDINI o
INNER JOIN ordini_articoli oa
ON o.id = oa.idordine
WHERE idcliente = 3492
GROUP BY o.id,
importo,
spese,
destinazione,
to_timestamp(ora),
trasporto,
note,
source_order
ORDER BY o.id desc ) t WHERE quant != (onstock + sh + de + bo) LIMIT 100 OFFSET ((1-1)*100)
No open order
| Ord. No. | Del | BO | In Stock | Ship | Note | Date | Qty | Amount |
|---|---|---|---|---|---|---|---|---|
| 1627886 | 1 | 0 | 0 | 0 | 30/05/2026 14:30 | 1 | € 10,76 | |
| 1627661 | 1 | 0 | 0 | 0 | 29/05/2026 06:57 | 1 | € 3,95 | |
| 1609837 | 2 | 0 | 0 | 0 | 18/01/2026 17:24 | 2 | € 2,50 | |
| 1594690 | 1 | 0 | 0 | 0 | 02/10/2025 17:58 | 1 | € 14,52 | |
| 1585125 | 1 | 0 | 0 | 0 | 12/07/2025 19:23 | 1 | € 5,84 | |
| 1579009 | 1 | 0 | 0 | 0 | 26/05/2025 13:36 | 1 | € 15,22 | |
| 1571759 | 1 | 0 | 0 | 0 | 04/04/2025 12:41 | 1 | € 28,41 | |
| 1555198 | 1 | 0 | 0 | 0 | 17/12/2024 22:56 | 1 | € 16,33 | |
| 1520550 | 1 | 0 | 0 | 0 | 04/05/2024 10:35 | 1 | € 19,48 | |
| 1519464 | 1 | 0 | 0 | 0 | 26/04/2024 13:17 | 1 | € 25,67 | |
| 1517189 | 5 | 0 | 0 | 0 | 11/04/2024 11:55 | 5 | € 36,98 | |
| 1514063 | 1 | 0 | 0 | 0 | 19/03/2024 17:41 | 1 | € 6,29 | |
| 1512390 | 1 | 0 | 0 | 0 | 08/03/2024 00:51 | 1 | € 21,85 | |
| 1493891 | 2 | 0 | 0 | 0 | 16/11/2023 22:41 | 2 | € 52,90 | |
| 1493591 | 1 | 0 | 0 | 0 | 15/11/2023 14:34 | 1 | € 24,61 | |
| 1491892 | 1 | 0 | 0 | 0 | 07/11/2023 16:39 | 1 | € 6,25 | |
| 1489115 | 1 | 0 | 0 | 0 | 23/10/2023 19:32 | 1 | € 8,55 | |
| 1482296 | 1 | 0 | 0 | 0 | 08/09/2023 14:36 | 1 | € 87,19 | |
| 1478187 | 1 | 0 | 0 | 0 | 08/08/2023 17:24 | 1 | € 4,66 | |
| 1477194 | 1 | 0 | 0 | 0 | 01/08/2023 19:17 | 1 | € 10,66 | |
| 1471688 | 3 | 0 | 0 | 0 | 25/06/2023 17:38 | 3 | € 63,06 | |
| 1465894 | 1 | 0 | 0 | 0 | 18/05/2023 11:14 | 1 | € 7,67 | |
| 1447339 | 3 | 0 | 0 | 0 | 1 de cada | 31/01/2023 13:30 | 3 | € 57,21 |
| 1434738 | 1 | 0 | 0 | 0 | 29/11/2022 09:36 | 1 | € 13,41 | |
| 1426553 | 1 | 0 | 0 | 0 | 19/10/2022 20:35 | 1 | € 11,54 | |
| 1411232 | 1 | 0 | 0 | 0 | 16/07/2022 15:14 | 1 | € 10,31 | |
| 1410291 | 2 | 0 | 0 | 0 | 11/07/2022 12:13 | 2 | € 37,99 | |
| 1385256 | 1 | 0 | 0 | 0 | 17/02/2022 21:25 | 1 | € 13,90 | |
| 1379072 | 1 | 0 | 0 | 0 | 19/01/2022 23:30 | 1 | € 31,89 | |
| 1350489 | 5 | 0 | 0 | 0 | 10/08/2021 12:02 | 5 | € 92,67 | |
| 1334345 | 2 | 0 | 0 | 0 | 04/05/2021 18:03 | 2 | € 36,43 | |
| 1330798 | 2 | -1 | 0 | 0 | 14/04/2021 14:57 | 1 | € 30,60 | |
| 1329708 | 2 | -1 | 0 | 0 | 06/04/2021 23:15 | 1 | € 13,24 | |
| 1323296 | 1 | 0 | 0 | 0 | 20/02/2021 18:30 | 1 | € 18,12 |