We use cookies for various purposes including analytics. By continuing to use this demo, you agree to our use of cookies.
Cookies Policy
.
OK, I Understand
PixiePaste
Archive
Syntax languages
API
Login
Sign up
paste
New Paste
SELECT u.id, u.name, COUNT(p.id) AS paste_count, COALESCE(SUM(p.views), 0) AS total_views FROM users u LEFT JOIN pastes p ON p.user_id = u.id GROUP BY u.id, u.name HAVING paste_count > 0 ORDER BY total_views DESC LIMIT 25;
Optional Paste Settings
Category:
None
Cryptocurrency
Cybersecurity
Fixit
Food
Gaming
Haiku
Help
History
Housing
Jokes
Legal
Money
Movies
Music
Pets
Photo
Science
Software
Source Code
Spirit
Sports
Travel
TV
Writing
Weather
Tags:
Syntax Highlighting:
None
Bash
C
C++
C#
CSS
Diff
Go
HTML
INI
Java
JavaScript
JSON
Kotlin
Lua
Markdown
Objective C
Perl
PHP
Python
Ruby
Rust
SQL
Swift
XML
YAML
Paste Expiration:
Never
10 minutes
1 hour
1 day
1 week
2 weeks
1 month
1 year
Paste Exposure:
Public
Unlisted
Private (members only)
Password:
Burn after read:
Disabled
Delete after first read
Paste Name / Title:
Create New Paste
You are currently not logged in, this means you can not edit or delete anything you paste.
Sign Up
or
Login