 its popular mountains, the company shared with Travel + Leisure, giving skiers and riders more time to hit the slopes before spring.
The company will keep several mountains across the country open longer, in Colorado, New York, Vermont, California, Ohio, and Washington state. All extended openings will be dependent on weather and snow conditions.
"No one likes to see the ski and ride season come to an end, and thanks to our incredible employees who have worked so hard this season, we will be able to enjoy time on the snow a little longer this year," James O'Donnell, Vail Resorts' mountain division president, said in a statement provided to T+L. "We are grateful to all of our pass holders and guests for their loyalty and passion, and we are pleased to be able to offer them a few more opportunities to ski and ride this winter season."
Colorado's Vail Mountain, California's Kirkwood, and Washington's Stevens Pass will stay open until May 1, according to the company, after all three were set to close in April. Heavenly, in California's Lake Tahoe, will now stay open until April 24 after it was originally slated to close April 17, and New York's Hunter Mountain will stay open an extra week until April 10.
In Vermont, Mount Snow's Carinthia terrain park area will remain open until April 24, past its original closing date of April 17. And in the Midwest, Ohio's Boston Mills will stay open through March 20 after it was initially expected to close after this weekend.
Beyond the extended seasons, Vail plans to keep Breckenridge in Colorado and Whistler Blackcomb in British Columbia open through late May, as initially planned. Breckenridge will remain open through Memorial Day, and Whistler Blackcomb will remain open until May 23.
Vail Resorts has run its gondolas and lifts at full capacity and has not required mountain reservations this year.<filename>server/services/mysql-queries-provider.js
/**
 * Created by yotam on 30/08/2016.
 */

var mySqlQueriesProvider = {

  topCommentingMKByCategory : "SELECT \n"+
  " u.*, IFNULL(comments_counts.count, 0) as commentsCount\n"+
  "FROM\n"+
  " user u\n"+
  " INNER JOIN\n"+
  " RoleMapping r ON u.id = r.principalId\n"+
  " JOIN\n"+
  " Role ON r.roleId = Role.id\n"+
  " AND Role.name =? \n"+
  " JOIN\n"+
  " (SELECT \n"+
  " c.creatorId, COUNT(p.id) count\n"+
  " FROM\n"+
  " Post p\n"+
  " JOIN CategoryPost cp ON cp.postId = p.id AND categoryId =? \n"+
  " JOIN Comment c ON c.postId = p.id\n"+
  " GROUP BY creatorId) AS comments_counts ON comments_counts.creatorId = u.id\n"+
  "ORDER BY count DESC LIMIT?;",

  mostUpvotedByCategory : "SELECT \n"+
  " IFNULL(upvotedCount.count, 0) as upvotedCount,\n"+
  " IFNULL(comments_counts.count, 0) as comments_counts,\n"+
  " u.*\n"+
  " FROM\n"+
  " user u\n"+
  " INNER JOIN\n"+
  " RoleMapping r ON u.id = r.principalId\n"+
  " JOIN\n"+
  " Role ON r.roleId = Role.id\n"+
  " AND Role.name!= \'mk\'" +
  " JOIN\n"+
  " (SELECT \n"+
  " creatorId, COUNT(c.creatorId) count \n"+
  " FROM\n"+
  " Post p\n"+
  " JOIN CategoryPost cp ON cp.postId = p.id AND p.customerId =? AND categoryId =?\n"+
  " JOIN Comment c ON c.postId = p.id\n"+
  " GROUP BY c.creatorId) AS comments_counts ON comments_counts.creatorId = u.id\n"+
  " LEFT JOIN"+
  " (SELECT \n"+
  " u.userId, COUNT(u.id) count, c.creatorId \n"+
  " FROM\n"+
  " Post p\n"+
  " JOIN CategoryPost cp ON cp.postId = p.id AND p.customerId =? AND categoryId =?\n"+
  " JOIN Comment c ON c.postId = p.id\n"+
  " JOIN Upvote u ON c.id=u.commentId\n"+
  " GROUP BY c.creatorId) AS upvotedCount ON upvotedCount.creatorId = u.id\n"+
  " ORDER BY upvotedCount DESC, comments_counts DESC LIMIT?;",

  topCommentingUserByRole : "SELECT \n"+
  " u.*, IFNULL(comments_counts.count, 0) as commentsCount\n"+
  "FROM\n"+
  " user u\n"+
  " INNER JOIN\n"+
  " RoleMapping r ON u.id = r.principalId\n"+
  " JOIN\n"+
  " Role ON r.roleId = Role.id\n"+
  " AND Role.name =? \n"+
  " JOIN\n"+
  " (SELECT \n"+
  " c.creatorId, COUNT(p.id) count\n"+
  " FROM\n"+
  " Post p\n"+
  " JOIN Comment c ON c.postId = p.id AND p.customerId =? \n"+
  " GROUP BY creatorId) AS comments_counts ON comments_counts.creatorId = u.id\n"+
  "ORDER BY count DESC LIMIT?;",

  usersByCateories : "select u.* from user u\n"+
  "join \n"+
  "RoleMapping r\n"+
  "on u.id=r.principalId \n"+
  "join Role \n"+
  "on r.roleId=Role.id and Role.name=? \n"+
  "join \n"+
  "userCategory uc\n"+
  "on u.id=uc.userId and uc.categoryId in (?) group by u.id;\n",

  // get all the active posts ordered by the user preference and date relevance.
  getTopPostsByUser : "select distinct p.id \n"+
  "from (select * from Post where reviewStatus='APPROVED' and status='PUBLISHED' and customerId=? \n" +
  "and migrationStatus = 'NORMAL' and endDate > UTC_TIMESTAMP()) p \n"+
  "left join\n"+
  "CategoryPost cp\n"+
  "on p.id = cp.postId \n"+
  "left join\n"+
  "userCategory uc\n"+
  "on uc.categoryId = cp.categoryId and userId=?  \n"+
  "order by uc.userId DESC, p.endDate ASC LIMIT?,?;",

  // get the last posts that the user has commented on.
  getPostsByCommentingUser : "select p.*\n"+
  "from Post p\n"+
  "join\n"+
  "Comment c on \n"+
  "p.id = c.postId AND p.customerId =? AND p.status=\'PUBLISHED\' \n"+
  "and p.migrationStatus = \'NORMAL\' AND c.deleted=0 AND c.creatorId =? \n"+
  "group by p.id \n"+
  "order by p.endDate DESC LIMIT?,?;",

  getPostsByCategories : "select distinct p.id from Post p \n"+
  "join CategoryPost cp\n"+
  "on p.id=cp.postId and p.customerId =? and p.endDate > UTC_TIMESTAMP() and p.reviewStatus='APPROVED' and p.status='PUBLISHED' and cp.categoryId in (?)\n"+
  " order by p.endDate ASC LIMIT?,?;",

  incrementPollAnswerVotes : "UPDATE PollAnswer SET votes = votes + 1 WHERE id =?;",

  getPostsByMk : "SELECT * FROM \n"+
  "( select p.* from \n"+
  "Committeeuser cu \n"+
  "join user u \n"+
  "on u.id=cu.userId \n"+
  "join PostCommittee pc \n"+
  "on pc.committeeId=cu.committeeId \n