lib/cellect/server/adapters/postgres.rb in cellect-server-0.0.7 vs lib/cellect/server/adapters/postgres.rb in cellect-server-0.0.8

@@ -30,10 +30,10 @@
             statement = <<-SQL
               SELECT sms.id as id, sms.priority as priority, sms.subject_set_id as group_id 
               FROM workflows w
               JOIN subject_sets_workflows ssw ON (ssw.workflow_id = w.id) 
               JOIN subject_sets ss ON (ss.id = ssw.subject_set_id) 
-              JOIN set_member_subjects sms ON (s.id = sms.subject_set_id)
+              JOIN set_member_subjects sms ON (ss.id = sms.subject_set_id)
               WHERE w.id = #{ workflow_name } 
             SQL
             pg.exec(statement).collect do |row|
               {
                 'id' => row['id'].to_i,