SortTable Posts

TESTING

 

//SortablePost2 order by latest comments using native WPnew_yellow2

SortTablePost1
Note: Can print wp_posts ordered by created date DESC
Need to:
7/4
1. Join to wp_comments to get max(comment_date) whose ID are in the last MONTH? DONE
2. Add links to actual posts/comments DONE
3. Fix 1 bug of inspirational videos DONE exclude POST_ID
3a. Add link for disqus last_comment (#disqus_thread)
3b. Change color of header
4. Add NEW for new threads created in past 2 days
5 Check other forums for title for “Last comment Date”

ThreadLast Post# of Comments
yellow-sticky-note-icon-17478 Preseason Game 5: Atlanta Hawks vs Miami Heat 2018-10-15 10:53:00490
No Imageyellow-sticky-note-icon-17478 Preseason Game 4: San Antonio Spurs vs Atlanta Hawks 2018-10-14 00:31:00387
No Imageyellow-sticky-note-icon-17478 Preseason Game 3: Atlanta Hawks vs OKC Thunder 2018-10-10 22:05:0077
No Imageyellow-sticky-note-icon-17478 Preseason Game 2: Atlanta Hawks vs Memphis Grizzlies 2018-10-07 19:24:00233
yellow-sticky-note-icon-17478 Preseason Game 1: New Orleans Pelicans vs Atlanta Hawks 2018-10-05 13:38:00320
yellow-sticky-note-icon-17478 Atlanta Hawks 2018-19 Media Day and Training Camp 2018-10-01 23:40:00394
yellow-sticky-note-icon-17478 Jeremy Lin on Hawks Plan To Play Him and Trae Young Together 2018-09-20 11:28:00720
yellow-sticky-note-icon-17478 When Would JLIN Play His First Game in 2018-19 Season? 2018-09-19 23:26:00128
yellow-sticky-note-icon-17478 Brooklyn Nets Trade Jeremy Lin to Atlanta Hawks 2018-08-10 15:10:002056
yellow-sticky-note-icon-17478 Getting to Know Ex-Golden State Warriors Staff in Atlanta Hawks 2018-08-10 02:43:0017

STICKY

nocats=”true”

TitleCategories
Off-Topic: Fun and InspirationalFun OffTopic Video
Off-Topic: Latest NEWSDiscussion OffTopic
1. POST_DATA_TABLE 7/3/16

Taking too long. High CPU??

— posts_data_table wrap=”false” rows_per_page=”8″]

 

ALL

TitleDateCategories
Preseason Game 5: Atlanta Hawks vs Miami HeatOctober 12, 2018Game Thread
No ImagePreseason Game 4: San Antonio Spurs vs Atlanta HawksOctober 10, 2018Game Thread
No ImagePreseason Game 3: Atlanta Hawks vs OKC ThunderOctober 7, 2018Game Thread
No ImagePreseason Game 2: Atlanta Hawks vs Memphis GrizzliesOctober 5, 2018Game Thread
Preseason Game 1: New Orleans Pelicans vs Atlanta HawksOctober 1, 2018Game Thread
Atlanta Hawks 2018-19 Media Day and Training CampSeptember 19, 2018Article Discussion
When Would JLIN Play His First Game in 2018-19 Season?September 6, 2018Article Discussion
Jeremy Lin on Hawks Plan To Play Him and Trae Young TogetherAugust 7, 2018Article
Jeremy Lin, Steve Nash, and Mark Cuban Invested in The iPhone App Making the NBA Smarter With Artificial IntelligenceJuly 17, 2018Article
Atlanta Hawks Fan Sites and Social Media LinksJuly 16, 2018Article