SQL fails

[Sama34]

I'm trying to fetch the most popular threads to show them in the portal, this is the query I have:

SQL Code

1 2 3 4 5 6

SELECT t.subject, t.tid, t.views, t.icon, t.prefix FROM ".TABLE_PREFIX."threads t LEFT JOIN ".TABLE_PREFIX."ratemf_log l ON (l.pid=t.firstpost) WHERE t.visible='1' {$overview_unviewwhere} AND t.closed NOT LIKE 'moved|%' ORDER BY t.views DESC LIMIT 0, {$settings['overview_max']};

---

As you can see, I'm joining a different tables to order the threads by the number of "rates" the thread has had. In the above I just joined, the query still works as usual. The problem comes here:

SQL Code

1 2 3 4 5 6

SELECT t.subject, t.tid, t.views, t.icon, t.prefix, COUNT(l.uid) AS logs FROM ".TABLE_PREFIX."threads t LEFT JOIN ".TABLE_PREFIX."ratemf_log l ON (l.pid=t.firstpost) WHERE t.visible='1' {$overview_unviewwhere} AND t.closed NOT LIKE 'moved|%' ORDER BY t.views DESC LIMIT 0, {$settings['overview_max']};

---

I added:

SQL Code

, COUNT(l.uid) AS logs , COUNT(l.pid) AS logs , COUNT(l.lid) AS logs

---

That is suppose to count the number of rows for that thread, but that alone shouldn't affect the query at all, just that it does, the thread being pulled are no the same as the one before adding that piece of code.

This doesn't seem to work either.

SQL Code

, COUNT(l.*) AS logs

---

But ", l.lid", ", l.*", or ", l.pid" does

Any clue?