SQLs - lekanteto/KB-API GitHub Wiki

General info

When filtering climbgs for specific board, then filter for dimensions within "product_sizes" dimensions for desired wall. For example 0 < x < 144, 0 < y < 156

Kilters BMs

SELECT climbs.name, climbs.setter_username, difficulty_grades.boulder_name FROM climb_stats
JOIN difficulty_grades ON difficulty_grades.difficulty=climb_stats.benchmark_difficulty
JOIN climbs ON climbs.uuid=climb_stats.climb_uuid
WHERE climb_stats.angle=40 AND benchmark_difficulty IS NOT NULL
ORDER BY climb_stats.benchmark_difficulty