Advertisement
KVT36

Untitled

Jun 23rd, 2017
57
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.94 KB | None | 0 0
  1. SELECT complete.foofactor, complete.foo_count AS complete_count, fail.foo_count AS fail_count
  2. FROM (SELECT (lol.moves - lol.start_moves) AS foofactor, COUNT(lol.reason) AS foo_count
  3. FROM level_op_log lol
  4. WHERE lol.reason = 'COMPLETE' and lol.moves > lol.start_moves and lol.version >= '2017-01-01'
  5. and (SELECT COUNT(*) FROM ad_op_log aol WHERE aol.lvl = aol.lvl and aol.reason = 'OUT_OF_MOVES' and aol.session_id = lol.session_id) = 0
  6. GROUP BY foofactor
  7. ORDER BY foofactor) complete
  8. JOIN (SELECT (lol.moves - lol.start_moves) AS foofactor, COUNT(lol.reason) AS foo_count
  9. FROM level_op_log lol
  10. WHERE lol.reason = 'FAIL' and lol.moves > lol.start_moves and lol.version >= '2017-01-01'
  11. and (SELECT COUNT(*) FROM ad_op_log aol WHERE aol.lvl = aol.lvl and aol.reason = 'OUT_OF_MOVES' and aol.session_id = lol.session_id) = 0
  12. GROUP BY foofactor
  13. ORDER BY foofactor) fail ON complete.foofactor = fail.foofactor
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement