Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT complete.foofactor, complete.foo_count AS complete_count, fail.foo_count AS fail_count
- FROM (SELECT (lol.moves - lol.start_moves) AS foofactor, COUNT(lol.reason) AS foo_count
- FROM level_op_log lol
- WHERE lol.reason = 'COMPLETE' and lol.moves > lol.start_moves and lol.version >= '2017-01-01'
- 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
- GROUP BY foofactor
- ORDER BY foofactor) complete
- JOIN (SELECT (lol.moves - lol.start_moves) AS foofactor, COUNT(lol.reason) AS foo_count
- FROM level_op_log lol
- WHERE lol.reason = 'FAIL' and lol.moves > lol.start_moves and lol.version >= '2017-01-01'
- 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
- GROUP BY foofactor
- ORDER BY foofactor) fail ON complete.foofactor = fail.foofactor
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement