Problem z dwoma coutami Opcje

[Salon]

Mam problem iż mam 2 county w zapytaniu. Problem polega na tym iż gdy polacze tabele (INNER, LEFT, RIGHT - sprawdzałem) cout zlicza mi nie poprawnie i w dodatku w obu sa te same wartosci. Z jednym joinem/coutem zlicza poprawnie.

Zapytanie:

[SQL] pobierz, plaintext 
	SELECT 
 
		[USER].name AS [Imię],
		[USER].surname AS [Nazwisko],
		count ([PISMA].user_id) AS [Ilość pism],
		count ([KOPERTY].user_id) AS [Ilość kopert]
 
	FROM 
 
 
	[TABELKA_USEROW] AS [USER]
	INNER JOIN [TABELKA_1] AS [PISMA] ON [PISMA].user_id = [USER].user_id
	INNER JOIN [TABELKA_2] AS [KOPERTY] ON [KOPERTY].user_id = [USER].user_id
 
	WHERE 
 
	[USER].usergroup_id = 7
 
	GROUP BY 
 
	[USER].name,[USER].surname,[PISMA].user_id,[KOPERTY].user_id
 
 
	ORDER BY [Nazwisko]
[SQL] pobierz, plaintext 

Ma ktos pomysl bo juz trace sily

[mortus]

COUNT działa trochę inaczej, niż moglibyśmy oczekiwać, dlatego i z jednym złączeniem dane mogą być nieprawidłowe. Chyba bez podzapytań się nie obejdzie:

[SQL] pobierz, plaintext 
	SELECT 
 
		[USER].name AS [Imię],
		[USER].surname AS [Nazwisko],
		[PISMA].number_per_user AS [Ilość pism],
		[KOPERTY].number_per_user AS [Ilość kopert]
 
	FROM 
 
 
	[TABELKA_USEROW] AS [USER]
	LEFT JOIN (SELECT user_id, COUNT(user_id) AS number_per_user FROM [TABELKA_1] GROUP BY user_id) AS [PISMA] ON [PISMA].user_id = [USER].user_id
	LEFT JOIN (SELECT user_id, COUNT(user_id) AS number_per_user FROM [TABELKA_2] GROUP BY user_id) AS [KOPERTY] ON [KOPERTY].user_id = [USER].user_id
 
	WHERE 
 
	[USER].usergroup_id = 7
 
	GROUP BY 
 
	[USER].name,[USER].surname,[PISMA].user_id,[KOPERTY].user_id
 
 
	ORDER BY [Nazwisko]
[SQL] pobierz, plaintext 

lub

[SQL] pobierz, plaintext 
	SELECT 
 
		[USER].name AS [Imię],
		[USER].surname AS [Nazwisko],
                (SELECT COUNT(*) FROM [TABELKA_1] AS [PISMA] WHERE [PISMA].user_id = [USER].user_id) AS [Ilość pism],
                (SELECT COUNT(*) FROM [TABELKA_2] AS [KOPERTY] WHERE [KOPERTY].user_id = [USER].user_id) AS [Ilość kopert]
 
	FROM 
 
 
	[TABELKA_USEROW] AS [USER]
 
	WHERE 
 
	[USER].usergroup_id = 7
 
	GROUP BY 
 
	[USER].name,[USER].surname,[PISMA].user_id,[KOPERTY].user_id
 
 
	ORDER BY [Nazwisko]
[SQL] pobierz, plaintext 

Nie wiem, które będzie szybsze, czy oba są optymalne i czy na 100% działają, bo pisałem z głowy.