https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23991
Tomás Cohen Arazi <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Needs Signoff |BLOCKED --- Comment #20 from Tomás Cohen Arazi <[email protected]> --- Looking. I'm investigating this query log differences: before: 242 Query select DISTINCT(STATUS) as value, count(*) as cnt from suggestions group by value order by STATUS 242 Query SELECT COUNT( * ) FROM `suggestions` `me` WHERE ( ( `STATUS` = 'ASKED' AND `archived` = '0' AND `branchcode` = 'CPL' ) ) 242 Query select DISTINCT(managedby) as value, count(*) as cnt from suggestions group by value order by managedby 242 Query select DISTINCT(acceptedby) as value, count(*) as cnt from suggestions group by value order by acceptedby 242 Query select DISTINCT(suggestedby) as value, count(*) as cnt from suggestions group by value order by suggestedby 242 Query select DISTINCT(budgetid) as value, count(*) as cnt from suggestions group by value order by budgetid after: 242 Query select DISTINCT(STATUS) as value, count(*) as cnt from suggestions group by value order by STATUS 242 Query SELECT COUNT( * ) FROM `suggestions` `me` WHERE ( ( `STATUS` = 'ASKED' AND `archived` = '0' AND `branchcode` = 'CPL' ) ) 242 Query select DISTINCT(managedby) as value, count(*) as cnt from suggestions group by value order by managedby 242 Query select DISTINCT(acceptedby) as value, count(*) as cnt from suggestions group by value order by acceptedby 242 Query select DISTINCT(suggestedby) as value, count(*) as cnt from suggestions group by value order by suggestedby 242 Query select DISTINCT(budgetid) as value, count(*) as cnt from suggestions group by value order by budgetid 242 Query SELECT COUNT( * ) FROM `suggestions` `me` WHERE ( ( `STATUS` = 'ASKED' AND `archived` = '0' AND `branchcode` = 'CPL' ) ) 242 Query SELECT COUNT( * ) FROM `suggestions` `me` WHERE ( ( `STATUS` = 'ASKED' AND `archived` = '0' AND `branchcode` = 'CPL' ) ) 242 Query SELECT `me`.`suggestionid`, `me`.`suggestedby`, `me`.`suggesteddate`, `me`.`managedby`, `me`.`manageddate`, `me`.`acceptedby`, `me`.`accepteddate`, `me`.`rejectedby`, `me`.`rejecteddate`, `me`.`lastmodificationby`, `me`.`lastmodificationdate`, `me`.`STATUS`, `me`.`archived`, `me`.`note`, `me`.`author`, `me`.`title`, `me`.`copyrightdate`, `me`.`publishercode`, `me`.`date`, `me`.`volumedesc`, `me`.`publicationyear`, `me`.`place`, `me`.`isbn`, `me`.`biblionumber`, `me`.`reason`, `me`.`patronreason`, `me`.`budgetid`, `me`.`branchcode`, `me`.`collectiontitle`, `me`.`itemtype`, `me`.`quantity`, `me`.`currency`, `me`.`price`, `me`.`total` FROM `suggestions` `me` WHERE ( ( `STATUS` = 'ASKED' AND `archived` = '0' AND `branchcode` = 'CPL' ) ) 242 Query SELECT `me`.`module`, `me`.`page`, `me`.`tablename`, `me`.`columnname`, `me`.`cannot_be_toggled`, `me`.`is_hidden` FROM `columns_settings` `me` WHERE ( ( `module` = 'acqui' AND `page` = 'suggestions' AND `tablename` = 'suggestions' ) ) 242 Query SELECT COUNT( * ) FROM `suggestions` `me` WHERE ( ( `STATUS` = 'ASKED' AND `archived` = '0' AND `branchcode` = 'CPL' ) ) -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list [email protected] https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
