Zafer Bilim Araştırma ve Kültür Dergisi
SELECT u.*,COUNT(p.id) as postCount FROM users as u LEFT JOIN post as p ON p.userID = u.id and p.status = 1 WHERE u.seo = 'osman-suroglu' GROUP BY u.id