SELECT i . * , note_sum, comments_count, u.user_name
FROM (
`res_item` i
)
INNER JOIN `fa_user` u ON i.it_us_id = u.id
LEFT JOIN (

SELECT no_it_id, sum( no_note ) AS note_sum
FROM notes
GROUP BY no_it_id
)n ON n.no_it_id = i.it_id
LEFT JOIN (

SELECT co_it_id, count( co_id ) AS comments_count
FROM comments
GROUP BY co_it_id
)co ON co.co_it_id = i.it_id
ORDER BY it_id DESC
LIMIT 10 

id  	 select_type  	 table  	 type  	 possible_keys  	 key  	 key_len  	 ref  	 rows  	 Extra
1 	PRIMARY 	i 	ALL 	NULL 	NULL 	NULL 	NULL 	182850 	Using temporary; Using filesort
1 	PRIMARY 	u 	eq_ref 	PRIMARY 	PRIMARY 	4 	podajcegle_2.i.it_us_id 	1 	Using where
1 	PRIMARY 	<derived2> 	ALL 	NULL 	NULL 	NULL 	NULL 	2 	 
1 	PRIMARY 	<derived3> 	ALL 	NULL 	NULL 	NULL 	NULL 	1 	 
3 	DERIVED 	comments 	ALL 	NULL 	NULL 	NULL 	NULL 	4 	Using temporary; Using filesort
2 	DERIVED 	notes 	ALL 	NULL 	NULL 	NULL 	NULL 	2 	Using temporary; Using filesort