Error
SQL query: Documentation
SELECT pe.id AS person_id, pl.name AS player_name, pl.id AS player_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
FROM players pl
JOIN people pe ON pe.id = pl.person_id(
SELECT pe.id AS person_id
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
AND rdkp.dkp >= (
SELECT max( dkp ) *
WHERE id = rdkp.id )
AND rdkp.raid_id = raids.id
AND raids.start_time >= '#{start_date.to_formatted_s(:db)} 06:00'
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
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 ON earned.person_id = pe.id
AND pl.alternate =0
AND pe.active =1
ORDER BY END
LIMIT 0 , 30
MySQL said: Documentation
#1064 - 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 from people pe , players pl , zones z , zone_g' at line 1