[Koha-bugs] [Bug 24148] black magic in Circulation/Returns.t

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24148

--- Comment #3 from Jonathan Druart <jonathan.druart at bugs.koha-community.org> ---
MariaDB [koha_kohadev]> SELECT  `type`, `itemnumber`  FROM `statistics` WHERE (
( `branch` = 'iObbbKovf' AND `itemnumber` = 1087 AND `type` = 'return' ) )
ORDER BY `datetime` ASC;
+--------+------------+
| type   | itemnumber |
+--------+------------+
| return |       1087 |
+--------+------------+
1 row in set (0.00 sec)

MariaDB [koha_kohadev]> SELECT  `type`, `itemnumber`, `other`  FROM
`statistics` WHERE ( ( `branch` = 'iObbbKovf' AND `itemnumber` = 1087 AND
`type` = 'return' ) ) ORDER BY `datetime` ASC;
Empty set (0.00 sec)

MariaDB [koha_kohadev]> SELECT  `type`, `itemnumber`, `borrowernumber`  FROM
`statistics` WHERE ( ( `branch` = 'iObbbKovf' AND `itemnumber` = 1087 AND
`type` = 'return' ) ) ORDER BY `datetime` ASC;
+--------+------------+----------------+
| type   | itemnumber | borrowernumber |
+--------+------------+----------------+
| return |       1087 |            122 |
+--------+------------+----------------+
1 row in set (0.00 sec)

MariaDB [koha_kohadev]> SELECT  `type`, `itemnumber`, `itemtype`  FROM
`statistics` WHERE ( ( `branch` = 'iObbbKovf' AND `itemnumber` = 1087 AND
`type` = 'return' ) ) ORDER BY `datetime` ASC;
+--------+------------+----------+
| type   | itemnumber | itemtype |
+--------+------------+----------+
| return |       1087 | SgqzzzD  |
+--------+------------+----------+
1 row in set (0.00 sec)

MariaDB [koha_kohadev]> SELECT  `type`, `itemnumber`, `other`  FROM
`statistics` WHERE ( ( `branch` = 'iObbbKovf' AND `itemnumber` = 1087 AND
`type` = 'return' ) ) ORDER BY `itemnumber` ASC;
+--------+------------+-------+
| type   | itemnumber | other |
+--------+------------+-------+
| return |       1087 |       |
+--------+------------+-------+
1 row in set (0.00 sec)

MariaDB [koha_kohadev]> SELECT  `type`, `itemnumber`, `other`  FROM
`statistics` WHERE ( ( `branch` = 'iObbbKovf' AND `itemnumber` = 1087 AND
`type` = 'return' ) ) ORDER BY `borrowernumber` ASC;
Empty set (0.00 sec)

-- 
You are receiving this mail because:
You are watching all bug changes.