Advertisement
AbitDeveloper

Minecraft - Skyblock - Wave select/fill

Jan 18th, 2016
34
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.64 KB | None | 0 0
  1. SELECT
  2.     IF(s.z = s.distance, s.x, s.x+s.z) AS a,
  3.     s.distance
  4. FROM
  5. (
  6.     SELECT
  7.         sb.distance,
  8.         sk.x,
  9.         sk.z
  10.     FROM
  11.     (
  12.         SELECT
  13.             f.distance AS distance
  14.         FROM
  15.         (
  16.             SELECT
  17.                 FLOOR(SQRT(x*x + z*z)) AS distance,
  18.                 COUNT(uuid) AS count,
  19.                 x,
  20.                 z
  21.             FROM skyblock
  22.             WHERE server='skyblock'
  23.                 AND type='void'
  24.             GROUP BY floor(sqrt(x*x + z*z)) ASC
  25.         ) AS f
  26.         WHERE f.count != f.distance * 2 + 1
  27.         LIMIT 1
  28.     ) AS sb
  29.     LEFT JOIN skyblock AS sk
  30.         ON sk.server='skyblock'
  31.             AND sk.type='void'
  32.             AND floor(sqrt(sk.x*sk.x + sk.z*sk.z)) = sb.distance
  33. ) AS s
  34. WHERE FLOOR(SQRT(s.x*s.x + s.z*s.z)) = s.distance
  35. ORDER BY a
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement