Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT aqb.budget_name, COUNT(b.biblioitemnumber)
- FROM biblioitems b
- LEFT JOIN aqorders aq ON
- (b.biblionumber=aq.biblionumber)
- LEFT JOIN aqbudgets aqb ON
- (aq.budget_id=aqb.budget_id)
- LEFT JOIN items i ON
- (i.biblionumber=aq.biblionumber)
- WHERE
- DATE(i.dateaccessioned) BETWEEN <<От|date>> AND <<До|date>>
- GROUP BY aqb.budget_name
- ORDER BY COUNT(b.biblionumber) DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement