Quake 2 Demos

Competition and Season List

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2): SELECT s.*, c.id AS comp_id, c.fullname AS comp_fullname, c.shortname AS comp_shortname, c.description, COUNT(d.id) AS demo_count /* COALESCE(DATE_FORMAT(MAX(d.date_added)),'%b %e, %Y'), 'none yet') AS latest */ FROM season s JOIN competition c ON s.competition = c.id LEFT OUTER JOIN demo d ON d.season = s.id WHERE s.disabled = 0 GROUP BY c.id, s.id ORDER BY c.fullname ASC, s.start_date DESC