Welcome ; Write ; Threads ; New(1) ; Image(1) ; Links ; Upload ; Calendar ; #HumanTalk ; #ToiletTalk ; Search ; Settings ; Stats ; Session ; Authors(45) ; People(1) ; Scores ; Labels(17) ; Data ; Chain(125) ; Help
Welcome

Raw
tagset_compost cart file_hash item_title labels_list item_score author_key author_score parent_count child_count add_timestamp item_sequence
approve; flag; meta +cart 11afccd3 hike set python3/enable 1 #hastext; #hastitle - - - - 158
approve; flag; meta +cart 34e93139 34e93139.. #notext - - - - 151
approve; flag; meta +cart 88036bfb 88036bfb.. - - - - - 142
approve; flag; meta +cart 21726a92 21726a92.. #notext - - - - 141
approve; flag; meta +cart 30e55de7 Public Key for Guest #notext; #pubkey 2 E4EA4ECD898A496F 2 - - 134
approve; flag; meta +cart db0f8d83 db0f8d83.. #notext - - - - 131
approve; flag; meta +cart 8d477783 8d477783.. #notext - - - - 130
approve; flag; meta +cart f8b67417 hike set adminless #hastext; #hastitle; #parent - - 1 - 125
approve; flag; meta +cart 9048a75e hike set zip/enable 1 #hastext; #hastitle - - - - 122
approve; flag; meta +cart 82bb2254 https://en.m.wikipedia.org/wiki/Vilna_Gaon #hastext; #hastitle; #https - - - - 95
approve; flag; meta +cart 751923f0 hike set python3/enable 1 #hastext; #hastitle - - - - 84
approve; flag; meta +cart 701c0e95 hike set operator_please 1 #hastext; #hastitle - - - - 81
approve; flag; meta +cart a7c08039 a7c08039.. #notext - - - - 60
approve; flag; meta +cart de8ec1de operator, please make me admin #hastext; #hastitle - - - - 49
approve; flag; meta +cart dd01d0e3 hike set upload 1 #hastext; #hastitle - - - - 44
approve; flag; meta +cart 07c491c1 07c491c1.. #notext - - - - 37
approve; flag; meta +cart 192a88b6 192a88b6.. #notext - - - - 36
approve; flag; meta +cart 82fc00ee 82fc00ee.. #notext - - - - 32
approve; flag; meta +cart 66ad55d5 66ad55d5.. #notext - - - - 30
approve; flag; meta +cart 99ddfe1d Public Key for Guest #notext; #pubkey 2 5EEBFB77711F8B0A 2 - - 22
approve; flag; meta +cart 1e54337f Public Key for Guest #notext; #pubkey 2 1CF263AE5795AAF3 2 1 - 18
approve(1); flag; meta +cart a74f7c57 Public Key for ilyag #notext; #pubkey; #approve 12 F04901006DB264E5 13 - - 15
approve; flag; meta +cart 7c2b0c72 Public Key for Guest #notext; #pubkey 2 D4EF2AC8870DF794 2 - - 14
approve; flag; meta +cart dcdfe3bd Public Key for Guest #notext; #pubkey 2 6D518C53F12F8091 2 1 - 13
approve; flag; meta +cart 0e275cdf Public Key for Guest #notext; #pubkey 2 717A0D28DCFE56D9 5 1 - 10
approve; flag; meta +cart c0451223 Software Updated to Version ca628ee5.. #changelog; #hastext; #hastitle; #hasvote; #hashtag - - - - 9
approve; flag; meta +cart a2ac9c77 Software Updated to Version 6a6ab3b4.. #changelog; #hastext; #hastitle; #hasvote; #hashtag - - - - 8
approve; flag; meta +cart 81c74760 image #image - - - - 6
approve; flag; meta +cart e57e42ca https://lobste.rs/s/d1n9k6/kind_websites_i_like #hastext; #hastitle; #signed; #https 1 717A0D28DCFE56D9 5 - - 17
approve; flag; meta +cart 7a3c8881 I like how people in comments are keen to change the world, but #hastext; #hastitle; #signed; #https 1 F04901006DB264E5 13 - - 16
approve; flag; meta +cart 4c98e0ce https://apnews.com/article/catholic-benedictine-nuns-esg-shareh #hastext; #hastitle; #signed; #https 1 717A0D28DCFE56D9 5 - - 12
approve; flag; meta +cart 18cc28a9 https://stackoverflow.blog/2022/03/03/stop-aggregating-away-the #hastext; #hastitle; #signed; #https 1 717A0D28DCFE56D9 5 - - 11
approve; flag; meta +cart 4e76d2ba Software Updated to Version da11a56e.. #changelog; #hastext; #hastitle; #hasvote; #hashtag - - - - -
approve; flag; meta +cart 074e558d Notice: Content was archived by the operator at 1724364095 #hastext; #hastitle - - - - 1
approve; flag; meta +cart 70e05bdc title: LinkedIn #hastext; #hastitle; #signed; #parent; #title 1 3E9A1122FF1F8974 1 1 - 42
approve; flag; meta +cart 4c0077e0 Yes #hastext; #hastitle; #signed 1 FF8F030C8E67171B 2 - - 31
approve; flag; meta +cart f77df523 Yes #hastext; #hastitle; #signed 1 FF8F030C8E67171B 2 - - 48
approve; flag; meta +cart cf5d8ccf #like #hasvote; #notext; #signed; #hashtag; #parent 1 9B2AB02333C65FF7 1 1 - 55
approve; flag; meta +cart 2bd07de3 #flag #hasvote; #notext; #signed; #hashtag; #parent 1 E47E5390FE825DF4 1 1 - 153
approve; flag; meta +cart 74063209 https://en.m.wikipedia.org/wiki/Black_Perl #hastext; #hastitle; #signed; #https 1 A908C543EC340BC8 1 - - 117
approve; flag; meta +cart 3c103eb2 consensus between multichains is pissible using monochains cont #hastext; #hastitle; #signed 1 01A17870B9FDBAB3 2 - - 93
approve; flag; meta +cart 659bb836 consensus between multichains is pissible using monochains cont #hastext; #hastitle; #signed 1 01A17870B9FDBAB3 2 - - 21
approve; flag; meta +cart 08f1bf86 https://news.ycombinator.com/item?id=39995886 #hastext; #hastitle; #signed; #https 1 626E770B84F361CC 2 - - 51
approve; flag; meta +cart c9e98cdb https://news.ycombinator.com/item?id=39995886 #hastext; #hastitle; #signed; #https 1 626E770B84F361CC 2 - - 56
approve; flag; meta +cart e3385463 [declined: #admin] #declined; #notext; #signed; #hashtag; #parent 1 5691516A87116262 1 1 - 139
approve; flag; meta +cart 891153b5 #like #hasvote; #notext; #signed; #hashtag; #parent 1 4B38BE30A388AAFE 1 1 - 19
approve; flag; meta +cart f6e717f0 #like #hasvote; #notext; #signed; #hashtag; #parent 1 66507FD64A09EA09 1 1 - 23
approve; flag; meta +cart 114a7510 https://en.m.wikipedia.org/wiki/Logic_Theorist#:~:text=Logic%20 #hastext; #hastitle; #signed; #https 1 A6D8DFBE96EC644C 1 - - 156
approve; flag; meta +cart 25ffccdb #like #hasvote; #notext; #signed; #hashtag; #parent 1 4730E6BFDDFAA0EC 3 1 - 41
approve; flag; meta +cart 5f8cc8ec #like #hasvote; #notext; #signed; #hashtag; #parent 1 4730E6BFDDFAA0EC 3 1 - 143
approve; flag; meta +cart 65a0a5d1 #like #hasvote; #notext; #signed; #hashtag; #parent 1 4730E6BFDDFAA0EC 3 1 - 45
approve; flag; meta +cart df5aaf27 there should be bookmarklets for all the common ui functions (e #hastext; #hastitle; #signed; #parent 1 F6CB695CCE004ED8 1 1 - 152
approve; flag; meta +cart 430e33e4 #like #hasvote; #notext; #signed; #hashtag; #parent 1 B535B22C660880F4 2 1 - 50
approve; flag; meta +cart 366be2be #like #hasvote; #notext; #signed; #hashtag; #parent 1 B535B22C660880F4 2 1 - 43
approve; flag; meta +cart 083c4489 #like #hasvote; #notext; #signed; #hashtag; #parent 1 0FDFCEB1FE6DCE7A 1 - - 52
approve; flag; meta +cart 35acf786 mongolian yurt always has door facing south #hastext; #hastitle; #signed 1 869F87496E0ABB14 1 - - 126
approve; flag; meta +cart 00f0c285 operator, please turn off javascript #hastext; #hastitle; #signed; #parent 1 0F78DE6248FCF3AC 1 1 - 102
approve; flag; meta +cart 0daaf5a5 #like #hasvote; #notext; #signed; #hashtag; #parent 1 8DECB0CB9F3B55E1 2 1 - 79
approve; flag; meta +cart 4daad43e https://www.youtube.com/watch?v=PZHESOq-Gkw #hastext; #hastitle; #signed; #https 1 704B4C9891B5A87A 5 - - 157
approve; flag; meta +cart be3ee42a https://www.facebook.com/reel/9156145781122263 #hastext; #hastitle; #signed; #https; #parent 1 704B4C9891B5A87A 5 1 - 92
approve; flag; meta +cart 70db444a https://www.facebook.com/reel/1383459302440706 #hastext; #hastitle; #signed; #https; #parent 1 704B4C9891B5A87A 5 - - 87
approve; flag; meta +cart 3990c44e https://www.facebook.com/reel/891830991870283 #hastext; #hastitle; #signed; #https 1 704B4C9891B5A87A 5 - - 35
approve; flag; meta +cart ac0a417c #like #hasvote; #notext; #signed; #hashtag; #parent 1 C57441E62D8927BC 1 1 - 25
approve; flag; meta +cart 9b279ac7 ilyag has self-identified #notext; #signed; #my_name_is; #parent 1 8DECB0CB9F3B55E1 2 1 - 68
approve; flag; meta +cart 4ed231e4 ilyag has self-identified #notext; #signed; #my_name_is 1 ADFEEE0C0461F3C5 1 - - 101
approve; flag; meta +cart d006dd80 #like #hasvote; #notext; #signed; #hashtag; #parent 1 704B4C9891B5A87A 5 1 - 58
approve; flag; meta +cart d1105a02 pale moon browser here #hastext; #hastitle; #signed; #parent 1 407754470680E454 1 1 - 83
approve; flag; meta +cart 5fc8d1af Thanks #hastext; #hastitle; #signed 1 3569E4F3A73A8325 5 - - 105
approve; flag; meta +cart 92847187 Thanks #hastext; #hastitle; #signed 1 3569E4F3A73A8325 5 - - 133
approve; flag; meta +cart f3cae7a3 Thanks #hastext; #hastitle; #signed 1 3569E4F3A73A8325 5 - - 82
approve; flag; meta +cart 1d20a249 for example, i can say: #hastext; #hastitle; #signed; #my_name_is 1 86E9C2EA15BBDE45 1 - - 40
approve; flag; meta +cart b69c802a why would i post something i don't like? #hastext; #hastitle; #signed; #parent 1 F3533C3CE466DDD8 2 1 - 27
approve; flag; meta +cart c067179b why would i post something i don't like? #hastext; #hastitle; #signed; #parent 1 F3533C3CE466DDD8 2 1 - 39
approve; flag; meta +cart ef5b6c54 hike set menu_top 0 #hastext; #hastitle; #signed; #parent 1 30A5E4600C831FA6 1 1 - 137
approve; flag; meta +cart 9bf271b7 When in doubt, make art #hastext; #hastitle; #signed 1 17E5CAF848441F0B 3 - - 103
approve; flag; meta +cart bb1508bb Thank you for this amazing weekend! #hastext; #hastitle; #signed 1 2EBEC833E0D90ADB 2 - - 73
approve; flag; meta +cart 34734a73 hike set operator_please 1 #hastext; #hastitle; #signed 1 7606120DC6825A0E 6 - - 77
approve; flag; meta +cart 44f12b6c hike set operator_please 1 #hastext; #hastitle; #signed 1 7606120DC6825A0E 6 - - 70
approve; flag; meta +cart 5fe04b74 hike set operator_please 1 #hastext; #hastitle; #signed 1 7606120DC6825A0E 6 - - 99
approve; flag; meta +cart b7033de1 hike set operator_please 1 #hastext; #hastitle; #signed 1 7606120DC6825A0E 6 - - 96
approve; flag; meta +cart bc2153ae hike set operator_please 1 #hastext; #hastitle; #signed 1 7606120DC6825A0E 6 - - 85
approve; flag; meta +cart faf34c9f hike set operator_please 1 #hastext; #hastitle; #signed 1 7606120DC6825A0E 6 - - 150
approve; flag; meta +cart 998da354 [Puzzle Solved] #notext; #signed; #puzzle 9001 67353CE208C07C6B 18002 - - 98
approve; flag; meta +cart c8347225 [Puzzle Solved] #notext; #signed; #puzzle 9001 67353CE208C07C6B 18002 - - 24
approve; flag; meta +cart 88886ef8 hike set #hastext; #hastitle; #signed; #parent 1 ED1B133BC71CA1E6 1 1 - 144
approve; flag; meta +cart 4a8ae3f2 https://en.m.wikipedia.org/wiki/BitGive_Foundation #hastext; #hastitle; #signed; #https 1 17E5CAF848441F0B 3 - - 67
approve; flag; meta +cart b894c7d6 https://en.m.wikipedia.org/wiki/BitGive_Foundation #hastext; #hastitle; #signed; #https 1 17E5CAF848441F0B 3 - - 86
approve; flag; meta +cart cd78e909 Walks I have been taken on by Marley the dog #hastext; #hastitle; #signed 1 2EBEC833E0D90ADB 2 - - 29
approve; flag; meta +cart 02c09f80 computer, please switch to information manager style #hastext; #hastitle; #signed 1 5C10434AA5801EDE 1 - - 76
approve; flag; meta +cart 19d83e15 How many times per day do you clear all tabs? #hastext; #hastitle; #signed 1 3569E4F3A73A8325 5 - - 108
approve; flag; meta +cart ff765ba6 Thank you #hastext; #hastitle; #signed 1 3569E4F3A73A8325 5 - - 109
approve; flag; meta +cart 881372b7 The top reason I love Android 4 is the Menu button. #hastext; #hastitle; #signed; #parent 1 1C756AE41110EDA4 2 1 - 149
approve; flag; meta +cart 81c2c218 I Love My New Android 4 Phone #hastext; #hastitle; #signed 1 1C756AE41110EDA4 2 - - 72
approve; flag; meta +cart 6846f06e [Puzzle Solved] #notext; #signed; #puzzle 9001 2E1C58D8F56B7FD5 9001 - - 80
approve; flag; meta +cart c0936f39 Hi from North Station #hastext; #hastitle; #signed 1 DE8CC8E13499CE72 9 - - 34
approve; flag; meta +cart 9a7b0268 Afterwards, I noticed a plate of matzos being discarded... #hastext; #hastitle; #signed 1 DE8CC8E13499CE72 9 - - 115
approve; flag; meta +cart bf1683dd Afterwards, I noticed a plate of matzos being discarded... #hastext; #hastitle; #signed 1 DE8CC8E13499CE72 9 - - 28
approve; flag; meta +cart 22135ce6 Good morning! #hastext; #hastitle; #signed 1 DE8CC8E13499CE72 9 - - 121
approve; flag; meta +cart 42c5927a Good morning! #hastext; #hastitle; #signed 1 DE8CC8E13499CE72 9 - - 120
approve; flag; meta +cart d200bb78 https://docs.google.com/forms/d/e/1FAIpQLScnwOSxzCI0YNamgykwu5P #hastext; #hastitle; #signed; #https 1 FDD14CF95929EB67 5 - - 71

Pages
1 2
Cart
Paste
Clear
Add All
raw.sql

SELECT
	'' AS tagset_compost,
	'' AS cart,
	file_hash,
	item_title,
	labels_list,
	item_score,
	item_flat.author_key AS author_key,
	author_score,
	parent_count,
	child_count,
	add_timestamp,
	item_sequence
FROM
	item_flat
	LEFT JOIN author_score ON (author_score.author_key = item_flat.author_key)
ORDER BY add_timestamp DESC


PrintedInfo #

Q: When was this page printed?
Printed: November 10 2024 23:32:26.

Q: How old was the page when downloaded?
Age: Fresh!
pollyanna:

Q: How can I get a fresher copy?
A: Ask the server to

JavaScript
Concept
concept Raw_Page
  purpose display a detailed output of recent server activity for the operator.

  state
    item_result: Resultset of items
      file_hash: String
      item_title: String
      labels_list: String (comma-separated List)
      item_score: Integer
      author_key: String
      author_score: Integer
      parent_count: Integer
      child_count: Integer
      add_timestamp: Timestamp
      item_sequence: Integer

  operational principle
    Retrieve data from the "item_flat" table with details on recent server activity.
    Join the "author_score" table to fetch additional author-related information.
    Order the results by the timestamp of item addition in descending order.

  Additional Considerations:
  - The Raw Page is designed to present detailed information about recent server activity.
  - Attributes include information about the item, author, and related metrics.
  - The SQL query performs a LEFT JOIN with the "author_score" table to enrich the data.
  - Results are ordered based on the timestamp of item addition in descending order.
PageMap
Welcome ; Write ; Threads ; New(1) ; Image(1) ; Links ; Upload ; Calendar ; #HumanTalk ; #ToiletTalk ; Search ; Settings ; Stats ; Session ; Authors(45) ; People(1) ; Scores ; Labels(17) ; Data ; Chain(125) ; Help
Expand; Minimal; Reprint; Cascade; Arrange; Float; Reset
CookieInfo #

You are signed in as Guest
Cookie: none
Alias: Guest
Score: 0
Avatar: