List of tracks in BTD5: Difference between revisions

these aren't RBS values I just realized
 
(2 intermediate revisions by one other user not shown)
Line 9: Line 9:
junctions = Junctions,
junctions = Junctions,
water = Water?,
water = Water?,
FORMAT(AVG(btd5_tracks.path_lengths_M__full), 1) = Average RBS,
FORMAT(AVG(btd5_tracks.path_lengths_M__full), 1) = Average path length,
CONCAT(music_M) = Default music,
CONCAT(music_M) = Default music,


Line 16: Line 16:
|order by=(CASE difficulty_M WHEN 'Beginner' THEN 0 WHEN 'Intermediate' THEN 1 WHEN 'Advanced' THEN 2 WHEN 'Expert' THEN 3 WHEN 'Extreme' THEN 4 END),
|order by=(CASE difficulty_M WHEN 'Beginner' THEN 0 WHEN 'Intermediate' THEN 1 WHEN 'Advanced' THEN 2 WHEN 'Expert' THEN 3 WHEN 'Extreme' THEN 4 END),
name_M
name_M
|where=id_M IS NOT NULL AND difficulty_M='Beginner' OR difficulty_M='Intermediate'
|where=id_M IS NOT NULL AND difficulty_M IS NOT NULL
|limit=200
|limit=200
}}</div>
}}</div>
Line 28: Line 28:
junctions = Junctions,
junctions = Junctions,
water = Water?,
water = Water?,
FORMAT(AVG(btd5_tracks.path_lengths_F__full), 1) = Average RBS,
FORMAT(AVG(btd5_tracks.path_lengths_F__full), 1) = Average path length,
CONCAT(music_F) = Default music,
CONCAT(music_F) = Default music,


Line 46: Line 46:
junctions = Junctions,
junctions = Junctions,
water = Water?,
water = Water?,
FORMAT(AVG(btd5_tracks.path_lengths_F__full), 1) = Average RBS,
FORMAT(AVG(btd5_tracks.path_lengths_F__full), 1) = Average path length,
CONCAT(music_F) = Default music,
CONCAT(music_F) = Default music,