SELECT Yonetici,(SELECT COUNT(*) FROM haber WHERE insert_user_id=user.id) AS ekledigi_haber,(SELECT COUNT(*) FROM yorum WHERE update_user=user.kadi AND durum=1) AS onayladigi_yorum,(SELECT COUNT(*) FROM yorum WHERE update_user=user.kadi AND durum=2) AS sildigi_yorum FROM `user`