SELECT

`invision_tbl_news`.`id`,
`invision_tbl_news`.`parent`,
`invision_tbl_news`.`userid`,
`invision_tbl_news`.`title`,
`invision_tbl_news`.`text`,
`invision_tbl_news`.`date`,
`invision_tbl_news`.`views`,
`invision_tbl_news`.`featured`,
`invision_tbl_news_cat`.`id`,
`invision_tbl_news_cat`.`category`,
count(`invision_tbl_news_replies`.`id`) as `count`,
`invision_tbl_news_replies`.`parent`
FROM
`invision_tbl_news` ,
`invision_tbl_news_cat` ,
`invision_tbl_news_replies`
WHERE
`invision_tbl_news`.`parent` = `invision_tbl_news_cat`.`id`
and
--`invision_tbl_news_replies`.`id` = `invision_tbl_news`.`id`