从2个数据库表中获取结果[关闭]

i need some help getting the most commented post. There are 2 tables, one have the posts web_content and the other table have the comments web_jcomments.

I need to get the most commented post and the number of comments. The web_content.ID = web_jcomments.object_id. The datebase is in MYSQL.

Please can some one help with the SQL code? Thank you for reading

SELECT 
       wc.ID,
       wj.Total
FROM web_content as wc
LEFT JOIN (
          SELECT 
                object_id,
                count(object_id)   as Total 
) as  wj on wc.ID = wj.object_id
ORDER BY wi.Total DESC

long time since I've written MySQL..

something like:

SELECT  
        web_content.ID, 
        COUNT(*) 
FROM web_content.ID 
LEFT JOIN web_jcomments ON (web_content.ID = web_jcomments.object_id)