<commit_before>from gittip import db, AMOUNTS
from gittip.networks import github
^L

receivers = db.fetchall("""

    SELECT tippee, claimed_time, sum(amount) AS amount
      FROM (    SELECT DISTINCT ON (tipper, tippee)
                       amount
                     , tippee
                  FROM tips
                  JOIN participants p ON p.id = tipper
                  JOIN social_network_users snu ON snu.participant_id = tippee
                 WHERE last_bill_result = ''
                   AND snu.is_locked = false
              ORDER BY tipper, tippee, mtime DESC
              ) AS foo
      JOIN participants p ON p.id = tippee
  GROUP BY tippee, claimed_time
  ORDER BY amount DESC
  LIMIT 10

""")

givers = db.fetchall("""

    SELECT tipper, anonymous, sum(amount) AS amount
      FROM (    SELECT DISTINCT ON (tipper, tippee)
                       amount
                     , tipper
                  FROM tips
                  JOIN participants p ON p.id = tipper
                  JOIN social_network_users snu ON snu.participant_id = tippee
                 WHERE last_bill_result = ''
                   AND snu.is_locked = false
              ORDER BY tipper, tippee, mtime DESC
              ) AS foo
      JOIN participants p ON p.id = tipper
  GROUP BY tipper, anonymous
  ORDER BY amount DESC
  LIMIT 10

""")
^L
{% extends templates/base.html %}

{% block heading %}

    <p class="below-header">
        <span class="nowrap">Set up recurring gift tips to people who</span>
        <span class="nowrap">make the world better. <a href="/about/">Learn more ...</a></span>
    </p>

    <script>
        $(document).ready(Gittip.initJumpToPerson);
    </script>
    <style>
        #jump {
            width: auto;
        }
        #jump INPUT {
            width: 6em;
        }

        TABLE {
            font: 300 13pt/13pt Lato, sans-serif;
            }
        TD {
            text-align: left;
            vertical-align: top;
            padding: 6pt 12pt 6pt 0;
        }
        TD.amount {
            text-align: right;
        }
        TR.unclaimed,
        TR.unclaimed A {
            color: #B2A196;
        }
        TR.unclaimed TD SPAN {
            font-size: 10pt;
        }
        #givers {
            float: left;
        }
        #receivers {
            float: right;
        }
        H2.clear {
            padding-top: 36pt;
        }<commit_msg>Make the Leaderboard section display nicer on mobile device<commit_after>from gittip import db, AMOUNTS
from gittip.networks import github
^L

receivers = db.fetchall("""

    SELECT tippee, claimed_time, sum(amount) AS amount
      FROM (    SELECT DISTINCT ON (tipper, tippee)
                       amount
                     , tippee
                  FROM tips
                  JOIN participants p ON p.id = tipper
                  JOIN social_network_users snu ON snu.participant_id = tippee
                 WHERE last_bill_result = ''
                   AND snu.is_locked = false
              ORDER BY tipper, tippee, mtime DESC
              ) AS foo
      JOIN participants p ON p.id = tippee
  GROUP BY tippee, claimed_time
  ORDER BY amount DESC
  LIMIT 10

""")

givers = db.fetchall("""

    SELECT tipper, anonymous, sum(amount) AS amount
      FROM (    SELECT DISTINCT ON (tipper, tippee)
                       amount
                     , tipper
                  FROM tips
                  JOIN participants p ON p.id = tipper
                  JOIN social_network_users snu ON snu.participant_id = tippee
                 WHERE last_bill_result = ''
                   AND snu.is_locked = false
              ORDER BY tipper, tippee, mtime DESC
              ) AS foo
      JOIN participants p ON p.id = tipper
  GROUP BY tipper, anonymous
  ORDER BY amount DESC
  LIMIT 10

""")
^L
{% extends templates/base.html %}

{% block heading %}

    <p class="below-header">
        <span class="nowrap">Set up recurring gift tips to people who</span>
        <span class="nowrap">make the world better. <a href="/about/">Learn more ...</a></span>
    </p>

    <script>
        $(document).ready(Gittip.initJumpToPerson);
    </script>
    <style>
        #jump {
            width: auto;
        }
        #jump INPUT {
            width: 6em;
        }

        TABLE {
            font: 300 13pt/13pt Lato, sans-serif;
            }
        TD {
            text-align: left;
            vertical-align: top;
            padding: 6pt 12pt 6pt 0;
        }
        TD.amount {
            text-align: right;
        }
        TR.unclaimed,
        TR.unclaimed A {
            color: #B2A196;
        }
        TR.unclaimed TD SPAN {
            font-size: 10pt;
        }
        #givers {
            float: left;
        }
        #receivers {
            float: right;
        }
        @media screen and (max-width: 640px) {
            #givers, #receivers {
                float: none;
            }
        }
        H2.clear {
            padding-top: 36pt;
        }
{'fraction_non_alphanumeric': 0.08330011956954962, 'fraction_numerical': 0.01096054204862495, 'mean_word_length': 1.3442316674451191, 'pattern_counts': {'":': 0, '<': 25, '<?xml version=': 0, '>': 25, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '1250388', 'n_tokens_mistral': 1587, 'n_tokens_neox': 1422, 'n_words': 423}