ERROR: function listall(bigint) does not exist LINE 1: ...LESCE(rcount,0) AS rcount,listall(bmost) AS bmost,listall(bf... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
SELECT COALESCE(ccount,0) AS ccount,COALESCE(ncount,0) AS ncount,COALESCE(scount,0) AS scount,COALESCE(slcount,0) AS slcount,COALESCE(tcount,0) AS tcount,COALESCE(rcount,0) AS rcount,listall(bmost) AS bmost,listall(bfreq) AS bfreq FROM ( SELECT COUNT(DISTINCT club_id) AS ccount FROM club JOIN night USING (club_id) JOIN set USING (night_id) WHERE dj_id=1 AND night.date
Music Database (DJ)

Music Database


NameThe DJ of Bath and Wells
AKA
Clubs Played
Nights Played
Sets Played
Setlists Filed
Past sets The Calling  Tuesday 19th October 2010  21:00-02:00  (No setlist available.)
The Calling  Tuesday 5th October 2010  01:30-03:00  (20 tracks.)
The Calling  Tuesday 15th June 2010  00:20-02:00  (22 tracks.)
The Calling  Tuesday 1st June 2010  00:20-02:00  (24 tracks.)
The Calling  Tuesday 20th April 2010  00:20-02:00  (22 tracks.)
View All