Index: trunk/SQL/StoredProcedures/sp_GetListaReklamNaWydanie.txt
===================================================================
--- trunk/SQL/StoredProcedures/sp_GetListaReklamNaWydanie.txt (revision 732)
+++ trunk/SQL/StoredProcedures/sp_GetListaReklamNaWydanie.txt (revision 734)
@@ -69,5 +69,7 @@
 	R.[RABAT WARTOÆ], 
 	dbo.[UKA¯E SIÊ W NR].netto AS nettoZEmisji, 
-	dbo.[UKA¯E SIÊ W NR].zafakturowana
+	dbo.[UKA¯E SIÊ W NR].zafakturowana,
+	D.Name AS Dzial,
+	Roz.Name AS Rozdzial
 		
 	FROM dbo.AGENCI AS A2 
@@ -79,4 +81,6 @@
 	LEFT OUTER JOIN dbo.[LISTA TYTU£ÓW] AS T ON R.TYTU£ = T.SYMB
 	LEFT OUTER JOIN dbo.ReklamaLokalizacja AS L ON L.ID = R.AdLocationId
+	LEFT OUTER JOIN dbo.Dzial AS D ON R.ogl_dzial = D.Id
+	LEFT OUTER JOIN dbo.Rozdzial AS Roz ON R.ogl_rozdzial = Roz.Id
 	WHERE 
 	(R.[ZATWIERDZONO DO DRUKU] = 1) 
