Olympiad Stress Web

datotula

Vagabond
"getOlympiad" => "
SELECT oly_nobles.char_name, oly_nobles.points_current, oly_nobles.comp_done, char_templates.ClassName, characters.sex
FROM oly_nobles
LEFT JOIN char_templates ON oly_nobles.class_id = char_templates.ClassId
LEFT JOIN characters ON oly_nobles.char_id = characters.obj_Id
ORDER BY oly_nobles.class_id, oly_nobles.points_current DESC",

Hello I need in this select make so than kan see only one player with most 'points_current' in 'class_id' that have "comp_done" > 10

Can help me?
 
just add AND for 'class_id' that have "comp_done" > 10
like - SELECT * FROM characters where accessLevel > 100 AND sex = 1;
 
Back
Top