SQL fails

[Sama34]

I see, do you think this would work?

PHP Code:

1 2 3 4 5 6

$query = $db->query("SELECT t.subject, t.tid, t.views, t.icon, t.prefix, l.installs FROM ".TABLE_PREFIX."threads t LEFT JOIN (SELECT pid, COUNT(lid) AS installs FROM ".TABLE_PREFIX."ratemf_log WHERE rid='1' GROUP BY pid) l ON (l.pid=t.firstpost) WHERE t.visible = '1' {$where} AND t.closed NOT LIKE 'moved|%' ORDER BY l.installs DESC, t.views DESC LIMIT 0,{$limit};");

---

$where holds the disabled forums list.

There are no visible errors now, just need to wait for posts being rated as installed.