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 Game 45 Boston Celtics vs Atlanta Hawks: Jeremy Lin Is Back new_yellow22019-01-20 01:38:00258
yellow-sticky-note-icon-17478 Game 44 OKC Thunder vs Atlanta Hawks: Jeremy Lin is Doubtful, Sacramento Kings Explores Trade for JLin 2019-01-19 19:50:00283
yellow-sticky-note-icon-17478 Game 43 Milwaukee Bucks vs Atlanta Hawk: Jeremy Lin is Probable 2019-01-16 01:14:00379
yellow-sticky-note-icon-17478 Game 42 Atlanta Hawks vs Philadelphia 76ers: Portland Blazers Willing to Give 1st Round Pick for Jeremy Lin Per Source; Pelicans and 76ers Have Linterest 2019-01-13 11:07:00374
yellow-sticky-note-icon-17478 Game 41 Atlanta Hawks vs Brooklyn Nets: Fresh off His Linsanity Starting Role, Jeremy Lin Faces Brooklyn Nets 2019-01-13 01:13:00403
yellow-sticky-note-icon-17478 Game 40 Atlanta Hawks vs Toronto Raptors: Another Audition Chance for Jeremy Lin Among Trade Rumors 2019-01-09 20:34:00858
yellow-sticky-note-icon-17478 Game 39 Miami Heat vs Atlanta Hawks: JLin(IG) Stay The Course. Galatians 6:9 2019-01-08 16:19:00465
yellow-sticky-note-icon-17478 Game 28 Atlanta Hawks vs Boston Celtics: Jeremy Lin is Available 2019-01-08 04:40:00453
yellow-sticky-note-icon-17478 Game 36 Atlanta Hawks vs Indiana Pacers: Orlando Magic's Continuing Interest in Jeremy Lin 2019-01-08 04:40:00317
yellow-sticky-note-icon-17478 Game 38 Atlanta Hawks vs Milwaukee Bucks: Jeremy Lin Places 8th in East All-Star Voting 1st Return and Thanks Fans Support 2019-01-06 15:59:00338

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
Game 45 Boston Celtics vs Atlanta Hawks: Jeremy Lin Is BackJanuary 19, 2019Game Thread
Game 44 OKC Thunder vs Atlanta Hawks: Jeremy Lin is Doubtful, Sacramento Kings Explores Trade for JLinJanuary 15, 2019Game Thread
Game 43 Milwaukee Bucks vs Atlanta Hawk: Jeremy Lin is ProbableJanuary 13, 2019Game Thread
Game 42 Atlanta Hawks vs Philadelphia 76ers: Portland Blazers Willing to Give 1st Round Pick for Jeremy Lin Per Source; Pelicans and 76ers Have LinterestJanuary 11, 2019Game Thread
Game 41 Atlanta Hawks vs Brooklyn Nets: Fresh off His Linsanity Starting Role, Jeremy Lin Faces Brooklyn NetsJanuary 9, 2019Game Thread
Game 40 Atlanta Hawks vs Toronto Raptors: Another Audition Chance for Jeremy Lin Among Trade RumorsJanuary 8, 2019Game Thread
Game 39 Miami Heat vs Atlanta Hawks: JLin(IG) Stay The Course. Galatians 6:9January 6, 2019Game Thread
Game 38 Atlanta Hawks vs Milwaukee Bucks: Jeremy Lin Places 8th in East All-Star Voting 1st Return and Thanks Fans SupportJanuary 4, 2019Game Thread
Game 37 Atlanta Hawks vs Washington Wizards: Despite Bad Referee Calls, Jeremy Lin Still Among Top NBA PGs in Shooting EfficiencyJanuary 2, 2019Game Thread
Game 36 Atlanta Hawks vs Indiana Pacers: Orlando Magic’s Continuing Interest in Jeremy LinDecember 31, 2018Game Thread