Climb
Location | select lc_wall.wall_id,wall_color_rgb,lc_group_color,group_color_rgb,climb_id,climb_liveclimbvid_id, climb_image.image_path_sm,wall_image.image_path_sm as wall_image_sm, wall_name, climb_active, climb_setter_difficulty, climb_wall_position, date_sub(curdate(),interval 5 day) < climb_creation_date as climb_new from lc_wall left join lc_video on climb_liveclimbvid_id=lc_video.video_id left join lc_climb on lc_wall.wall_id=lc_climb.climb_wall_id left join lc_image as climb_image on lc_climb.climb_tag = climb_image.image_id left join lc_image as wall_image on lc_wall.wall_3d_map=wall_image.image_id left join lc_vlevel_group on lc_vlevel_group.group_color_id=lc_climb.lc_group_color where wall_active and lc_wall.gym_id=12 and lc_climb.climb_vlevel=3 and climb_active and lc_climb.climb_vlevel_unset=0 order by wall_sequence asc,climb_wall_position asc Column 'climb_id' in field list is ambiguous
|
