Advertisement
EntropyStarRover

koha sql acquisition grouped by aq budget between date range

Mar 6th, 2025 (edited)
426
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.38 KB | None | 0 0
  1. SELECT aqb.budget_name, COUNT(b.biblioitemnumber)
  2. FROM biblioitems b
  3. LEFT JOIN aqorders aq ON
  4. (b.biblionumber=aq.biblionumber)
  5. LEFT JOIN aqbudgets aqb ON
  6. (aq.budget_id=aqb.budget_id)
  7. LEFT JOIN items i ON
  8. (i.biblionumber=aq.biblionumber)
  9.  
  10. WHERE
  11.    DATE(i.dateaccessioned) BETWEEN  <<От|date>>  AND  <<До|date>>
  12. GROUP BY aqb.budget_name
  13. ORDER BY COUNT(b.biblionumber) DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement