MySQL - CONSULTA COUNT GROUP BY

+----------------+--------------+------+-----+---------+-------+

| Field          | Type         | Null | Key | Default | Extra |

+----------------+--------------+------+-----+---------+-------+

| idnew          | varchar(50)  | NO   | PRI | NULL    |       |

| titulonew      | varchar(500) | NO   |     | NULL    |       |

| rutanew        | varchar(500) | NO   |     | NULL    |       |

| fechanew       | varchar(20)  | NO   |     | NULL    |       |

| horanew        | varchar(20)  | NO   |     | NULL    |       |

| utcnew         | varchar(15)  | NO   |     | NULL    |       |

| wordkeynew     | varchar(200) | NO   |     | NULL    |       |

| directorio     | varchar(10)  | NO   |     | NULL    |       |

| descripcionnew | varchar(500) | NO   |     | NULL    |       |

| countvisitas   | int(11)      | NO   |     | NULL    |       |

+----------------+--------------+------+-----+---------+-------+

+---------+-------------+------+-----+---------+-------+

| Field   | Type        | Null | Key | Default | Extra |

+---------+-------------+------+-----+---------+-------+

| idnew   | varchar(50) | NO   | MUL | NULL    |       |

| idcmnew | varchar(20) | NO   | MUL | NULL    |       |

+---------+-------------+------+-----+---------+-------+

select A.idnew,A.titulonew,A.fechanew,A.descripcionnew,A.countvisitas, count(B.idnew) from tbnews A,tbnwscmnws B where A.idnew = B.idnew group by B.idnew order by A.utcnew asc limit 0,5;

...

FROM tabla1, tabla2, WHERE tabla1.campo = tabla2.campo

...

...

FROM tabla1 INNER JOIN tabla2 ON tabla1.campo = tabla2.campo

...

select A.idnew,A.titulonew,A.fechanew,A.descripcionnew,A.countvisitas,count(B.idnew) from tbnews A left join tbnwscmnws B on A.idnew = B.idnew group by A.idnew order by A.utcnew desc;