Thank You Richard! Merci beaucoup.
wConti
Richard-175 wrote:
>
> Hi I think you would do this :
>
> SELECT
> sf_conferences.id,
> sf_conferences.name,
> count(*) AS `count`
> FROM
> ((
> LEFT JOIN sf_forums ON sf_conferences.id=sf_forums.conferenceidfk)
> LEFT sf_threads ON sf_forums.id = sf_t
Hi I think you would do this :
SELECT
sf_conferences.id,
sf_conferences.name,
count(*) AS `count`
FROM
((
LEFT JOIN sf_forums ON sf_conferences.id=sf_forums.conferenceidfk)
LEFT sf_threads ON sf_forums.id = sf_threads.forumidfk)
LEFT JOIN sf_messages ON sf_threads.id = sf_messages.threadidfk
GROU
Is it possible to get the count() for "forums, "threads" and "messages"
extrapolating from the following query? Thanx for helping a newb.
select
sf_conferences.id,
sf_conferences.name
from
((#variables.tableprefix#conferences
left JOIN sf_forums ON sf_conferences.id=sf_forums.conferenceidfk
