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 6677ce89 Can we please get an approve button always available for admin? #hastext; #hastitle; #signed 1 FDD14CF95929EB67 5 - - 100
approve; flag; meta +cart 3f4a3505 https://youtu.be/B63whNtp4qc #hastext; #hastitle; #signed; #https 1 5D45F72CF5E0A359 18007 - - 129
approve; flag; meta +cart 740cf7bf https://youtu.be/B63whNtp4qc #hastext; #hastitle; #signed; #https 1 5D45F72CF5E0A359 18007 - - 61
approve; flag; meta +cart f31cdacc https://youtu.be/B63whNtp4qc #hastext; #hastitle; #signed; #https 1 5D45F72CF5E0A359 18007 - - 65
approve; flag; meta +cart 676712cb Anonymous supporter in Boston area shared their access with me, #gratitude; #hastext; #hastitle; #hasvote; #signed; #hashtag 1 5D45F72CF5E0A359 18007 - - 114
approve; flag; meta +cart 877b5d14 Anonymous supporter in Boston area shared their access with me, #gratitude; #hastext; #hastitle; #hasvote; #signed; #hashtag 1 5D45F72CF5E0A359 18007 - - 132
approve; flag; meta +cart 0e727653 Verry tirrd but still did oh and going to the mass lobby #hastext; #hastitle; #signed 1 DE8CC8E13499CE72 9 - - 106
approve; flag; meta +cart c68eef35 Verry tirrd but still did oh and going to the mass lobby #hastext; #hastitle; #signed 1 DE8CC8E13499CE72 9 - - 107
approve; flag; meta +cart a76ce6ca Anonymous supporter in New Jersey area housed and fed me for ap #gratitude; #hastext; #hastitle; #hasvote; #signed; #hashtag 1 FDD14CF95929EB67 5 - - 148
approve; flag; meta +cart 9925e599 #like #hasvote; #notext; #signed; #hashtag; #parent 1 FDD14CF95929EB67 5 1 - 89
approve; flag; meta +cart 5e152dc0 Thank you for free software foundation for recognizing divestos #hastext; #hastitle; #signed 1 DE8CC8E13499CE72 9 - - 123
approve; flag; meta +cart eb1ffcd2 Thank you for free software foundation for recognizing divestos #hastext; #hastitle; #signed 1 DE8CC8E13499CE72 9 - - 20
approve; flag; meta +cart 96459ad6 https://tryquiet.org/ #hastext; #hastitle; #signed; #https 1 FDD14CF95929EB67 5 - - 90
approve; flag; meta +cart 426e1fbd [Puzzle Solved] #notext; #signed; #puzzle 9001 5D45F72CF5E0A359 18007 - - 88
approve; flag; meta +cart e149df1d [Puzzle Solved] #notext; #signed; #puzzle 9001 5D45F72CF5E0A359 18007 - - 74
approve; flag; meta +cart 03268a00 YouretheMadest and the best..may the muse always be with you..j #hastext; #hastitle; #signed 1 C4735929A14FBE34 10 - - 128
approve; flag; meta +cart 033270bb YouretheMadest and the best..may the muse always be with you..j #hastext; #hastitle; #signed 1 C4735929A14FBE34 10 - - 69
approve; flag; meta +cart 28e8d9c8 YouretheMadest and the best..may the muse always be with you..j #hastext; #hastitle; #signed 1 C4735929A14FBE34 10 - - 136
approve; flag; meta +cart 53a20c95 YouretheMadest and the best..may the muse always be with you..j #hastext; #hastitle; #signed 1 C4735929A14FBE34 10 - - 112
approve; flag; meta +cart 60d5b67c YouretheMadest and the best..may the muse always be with you..j #hastext; #hastitle; #signed 1 C4735929A14FBE34 10 - - 63
approve; flag; meta +cart 99098073 YouretheMadest and the best..may the muse always be with you..j #hastext; #hastitle; #signed 1 C4735929A14FBE34 10 - - 135
approve; flag; meta +cart b27353c6 YouretheMadest and the best..may the muse always be with you..j #hastext; #hastitle; #signed 1 C4735929A14FBE34 10 - - 66
approve; flag; meta +cart b3f24bf1 YouretheMadest and the best..may the muse always be with you..j #hastext; #hastitle; #signed 1 C4735929A14FBE34 10 - - 104
approve; flag; meta +cart caa45f44 YouretheMadest and the best..may the muse always be with you..j #hastext; #hastitle; #signed 1 C4735929A14FBE34 10 - - 154
approve; flag; meta +cart d306b9bf YouretheMadest and the best..may the muse always be with you..j #hastext; #hastitle; #signed 1 C4735929A14FBE34 10 - - 111

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:27.

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: