• 타석스크린골프
  • 야외스크린골프
  • 실내스크린골프

베스트 파온샷

    DB ERROR (GetRs)
    QUERY :
    select TOP 4 SHNO, MS.SCORE_NO, IMG_FILE, HIT, RECOMM, MYREGDATE, (SELECT TOP 1 BRANCH_NAME FROM BRANCH with (nolock) WHERE BRANCH_NO= SB.BRANCH_NO AND BRANCH_DISPLAY='Y' ) BRANCH_NAME, (SELECT TOP 1 COURSE_NAME FROM COURSE with (nolock) WHERE COURSE_NO= SB.COURSE_NO ) COURSE_NAME, (SELECT TOP 1 MEMBER_NICK FROM MEMBER_BASE with (nolock) WHERE MEMBER_ID= SB.MEMBER_ID ) MEMBER_NICK from dbo.SCORE_BASE SB with (nolock) join MYSHOT MS with (nolock) on SB.SCORE_NO = MS.SCORE_NO where OPENYN='Y' AND convert(varchar(6),myregdate,112) >= convert(varchar(6),DATEADD(month, -6, GETDATE()),112) ORDER BY RECOMM DESC, HIT DESC;
    시간 제한이 만료되었습니다.