Stuff

 ActiveRecord::StatementInvalid in MainController#index

Mysql::Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(
        select
                pe.id as person_id
		,
sum(case when zg.id=14 t' at line 17: select
        pe.id as person_id,
        pl.name as player_name,
        pl.id as id,
        pl.className as class_name,
        ranks.name as rank_name,
	(case when num_raids.raid_count is not null then num_raids.raid_count else 0 end) as raid_count
	,
(earned.dkp_earned_14 - case when spent.dkp_spent_14 is not null then spent.dkp_spent_14 else 0 end) as dkp_14,
(earned.dkp_earned_17 - case when spent.dkp_spent_17 is not null then spent.dkp_spent_17 else 0 end) as dkp_17,
(earned.dkp_earned_16 - case when spent.dkp_spent_16 is not null then spent.dkp_spent_16 else 0 end) as dkp_16,
(earned.dkp_earned_11 - case when spent.dkp_spent_11 is not null then spent.dkp_spent_11 else 0 end) as dkp_11,
(earned.dkp_earned_19 - case when spent.dkp_spent_19 is not null then spent.dkp_spent_19 else 0 end) as dkp_19,
(earned.dkp_earned_18 - case when spent.dkp_spent_18 is not null then spent.dkp_spent_18 else 0 end) as dkp_18,
(earned.dkp_earned_10 - case when spent.dkp_spent_10 is not null then spent.dkp_spent_10 else 0 end) as dkp_10
from ( players p1, people pe )
(
        select
                pe.id as person_id
		,
sum(case when zg.id=14 then rdkp.dkp else 0 end) as dkp_earned_14,
sum(case when zg.id=17 then rdkp.dkp else 0 end) as dkp_earned_17,
sum(case when zg.id=16 then rdkp.dkp else 0 end) as dkp_earned_16,
sum(case when zg.id=11 then rdkp.dkp else 0 end) as dkp_earned_11,
sum(case when zg.id=19 then rdkp.dkp else 0 end) as dkp_earned_19,
sum(case when zg.id=18 then rdkp.dkp else 0 end) as dkp_earned_18,
sum(case when zg.id=10 then rdkp.dkp else 0 end) as dkp_earned_10
        from ( people pe, players pl, zones z, zone_groups zg, raids r )
        left join per_raid_dkp rdkp on rdkp.player_id = pl.id
        where
                pe.id = pl.person_id
                and
                r.id = rdkp.raid_id
                and
                r.zone_id = z.id
                and
                z.zone_group_id = zg.id
        group by
                pe.id
        order by
                pe.id,
                zg.id
) earned
left join
(
        select tmpcount.person_id as person_id, count(tmpcount.raid_id) as raid_count from (
	  select
  	    pe.id as person_id,
  	    raids.id as raid_id
	  from (players pl, people pe, raids, per_raid_dkp rdkp)
	  where
  	    pl.person_id = pe.id
  	    and
  	    rdkp.player_id = pl.id
	  
  	    /* minimum dkp */
  	    and
  	    rdkp.dkp >= (select max(dkp) * 0.6 from per_raid_dkp where id = rdkp.id)
  
  	    and
  	    rdkp.raid_id = raids.id
  	    and
  	    raids.start_time >= '2007-07-03 06:00'
  
    	    /* Only include raids that should count towards the weekly count */
    	    and
    	    raids.add_to_weekly_count = 1
  
	  group by
  	    pe.id, raids.id
    	) tmpcount group by tmpcount.person_id
) num_raids on (earned.person_id = num_raids.person_id)
left join
(
        select
                person_id
		,
sum(case when zone_group_id=14 then sdkp.dkp_spent else 0 end) as dkp_spent_14,
sum(case when zone_group_id=17 then sdkp.dkp_spent else 0 end) as dkp_spent_17,
sum(case when zone_group_id=16 then sdkp.dkp_spent else 0 end) as dkp_spent_16,
sum(case when zone_group_id=11 then sdkp.dkp_spent else 0 end) as dkp_spent_11,
sum(case when zone_group_id=19 then sdkp.dkp_spent else 0 end) as dkp_spent_19,
sum(case when zone_group_id=18 then sdkp.dkp_spent else 0 end) as dkp_spent_18,
sum(case when zone_group_id=10 then sdkp.dkp_spent else 0 end) as dkp_spent_10
        from
                spent_dkp sdkp
        group by
                person_id
) spent on (earned.person_id = spent.person_id)
left join ranks on pe.rank_id = ranks.id

WHERE
  earned.person_id = pe.id
  AND
  pe.id = pl.person_id
  AND
  pl.alternate = 0
  AND
  pe.active = 1
ORDER BY
  player_name