Filter ideas

Filter by

• quality range slider

• grade range slider

• grade deviation range slider

• min number of ascents 0, 5, 10, 25, 50, 100

• my ascents

  • only my ascents, don't care, exclude my ascents

• my tries

  • only my tries, don't care, exclude my tries

• only ascents by people I follow

• only set by people I follow

• only climbs in circuit X

• only with selected holds

Order by

• rating
• newest
• easiest
• most repeats

SELECT 
  name, setter_username, climb_stats.ascensionist_count, difficulty_grades.boulder_name AS grade, 
  climb_stats.difficulty_average - round(climb_stats.difficulty_average) AS grade_deviation, 
  climb_stats.quality_average
FROM climbs
JOIN climb_stats on climb_stats.climb_uuid=climbs.uuid
JOIN difficulty_grades on difficulty_grades.difficulty=round(climb_stats.difficulty_average)
WHERE 
	layout_id=1 AND
	climbs.is_listed=1 AND
	is_draft=0 AND
	frames_count=1 AND
	edge_left > 0 AND
	edge_bottom > 0 AND
	edge_right < 144 AND
	edge_top < 156 AND
	climb_stats.angle=40 AND
	-- filters
	climb_stats.quality_average BETWEEN 1 AND 3 AND    -- min/max rating
	
	climb_stats.display_difficulty BETWEEN 4 AND 30 AND -- min/max difficulty
	
	(climb_stats.difficulty_average - round(climb_stats.difficulty_average)) BETWEEN -0.5 AND 0.5 AND -- min/max grade deviation
	
	climb_stats.ascensionist_count >= 5 AND    -- min num of ascents
	
	climbs.setter_username="kilterjackie"
ORDER BY climb_stats.quality_average DESC, climb_stats.ascensionist_count DESC
LIMIT 100