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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=24148 --- Comment #3 from Jonathan Druart <jonathan.druart@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.