Re: select count(). Help-a-newb

[Richard <mysql_list@xxxxxx>]

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
GROUP BY
sf_conferences.id,
sf_conferences.name;

I hope this is what you want :)

contiw a écrit :
> 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) 
> left JOIN sf_threads ON sf_forums.id = sf_threads.forumidfk) 
> left JOIN sf_messages ON sf_threads.id = sf_messages.threadidfk 
> GROUP BY 
> sf_conferences.id, 
> sf_conferences.name


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=royale@xxxxxxxxxx