Statistika fondu pro regionální knihovny

SELECT i.itype, i.ccode, 
  (SELECT COUNT(*) FROM items i2 WHERE i2.dateaccessioned < @From AND i2.homebranch = @Library AND i2.ccode = i.ccode) AS "Počátek", 
  COUNT(*) AS "Přírůstek", 
  (SELECT COUNT(*) FROM items i3 WHERE i3.withdrawn_on BETWEEN @From AND @To AND i3.homebranch = @Library AND i3.ccode = i.ccode) AS "Úbytek",
  (SELECT COUNT(*) FROM items i4 WHERE i4.dateaccessioned <= @To AND i4.homebranch = @Library AND i4.ccode = i.ccode) AS Konec
FROM items i
JOIN (SELECT @Library:=<<Knihovna|branches>> COLLATE utf8_unicode_ci, @From:=<<Od|date>>, @To:=<<Do|date>>) as vars
WHERE i.homebranch = @Library
AND i.dateaccessioned BETWEEN @From AND @To
GROUP BY i.itype, i.ccode