New on LowEndTalk? Please Register and read our Community Rules.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
HetrixTools - Blacklist/Uptime Monitors Giveaway for your new Black Friday servers!
This discussion has been closed.
Comments
7d0d7c9c42dd190f622d8108839d0b1b
afd4ec0a7a560c79c3e4b79a87606036
8dcf4d60d13f82aea006ad6a3bc9b689
208e2740acbec61cdfde1d5b932bc84b
27c982f6225884e3cc3e38eb333661da
e5dcbc1fe1d85a2cdda6e96c13feba4b
49e5d41878a5f3b8104ea32509ebae22
d1b3b0aa47505d2456603415709cf19b
a6c05aa59f03cefec729480e94325b13
9d07f3bd06e115830a3a1ba9c705a990
4681d079c4c5a058601d060adaca2b86
yes!
8bf8aea5219d86931cc5ce40801630a1
3330ef151447a9f5f9bca372bcfeaa56
Finally I can rest now...
congrats finally xD
So close. You beat me...
Holy smokes! That's a lot of comments at once
6f238bd5fc6bf4909d465805118beb4e
Hm, how are they going to figure out who posted when? Seems like the times only show for the current day, otherwise it shows the date...
Hover on the time/date
Aha, good call, our wins are preserved for eternity!
Poor Andrei is going to be doing a lot of hovering...
So if I will be ever the nr1 at a full hour, I win and don't need to participate anymore?
Save your energy for the upcoming days. You are doing a great job
I guess @FAT32 can help him out there, with some courtesy of ChatGPT:
SELECT c.CommentID, c.DiscussionID, c.DateInserted, c.Body, u.Name AS PosterName FROM GDN_Comment c JOIN ( SELECT DiscussionID, DATE_FORMAT(DateInserted, '%Y-%m-%d %H:00:00') AS Hour, MIN(DateInserted) AS FirstPostTime FROM GDN_Comment WHERE DiscussionID = 199855 GROUP BY DiscussionID, Hour ) subquery ON c.DiscussionID = subquery.DiscussionID AND c.DateInserted = subquery.FirstPostTime JOIN GDN_User u ON c.InsertUserID = u.UserID WHERE c.DiscussionID = 199855;PS: just to give an idea and totally unchecked, if that actually works! sometimes AI slips ;-)
Now that I win I have time to write the script...
d7ec3c54bd789bdfb817e1927e230987
f646bf09bacf1c1ac0c622bc99b15f9d
Thank you!
c0e9d5b111f20ca30024846a7bacd5c2
2638207893c763e7e40058922d97912a