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