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 Brooklyn Nets Trade Jeremy Lin to Atlanta Hawks 2018-07-22 12:31:001135
yellow-sticky-note-icon-17478 Getting to Know Atlanta Hawks Players 2018-07-21 20:08:009
yellow-sticky-note-icon-17478 Say Your Encouraging Words to Jeremy Lin Post-Trade 2018-07-21 19:47:0025
yellow-sticky-note-icon-17478 Getting to Know Ex-Golden State Warriors Staff in Atlanta Hawks 2018-07-20 12:53:009
yellow-sticky-note-icon-17478 Jeremy Lin, Steve Nash, and Mark Cuban Invested in The iPhone App Making the NBA Smarter With Artificial Intelligence 2018-07-17 22:01:001
yellow-sticky-note-icon-17478 LeBron Signs with the Lakers; Jeremy Lin Reunited with Ed Davis 2018-07-16 23:26:001067
yellow-sticky-note-icon-17478 Atlanta Hawks Fan Sites and Social Media Links 2018-07-16 17:26:003
yellow-sticky-note-icon-17478 Jeremy Lin: "Who Powered My Dream?" 2018-07-03 19:03:001144
yellow-sticky-note-icon-17478 Support Jeremy Lin's Rehab With A Purpose 2018-06-05 10:59:001050
yellow-sticky-note-icon-17478 Progressing Young Nets and Lin's Future Scenario in 2018-19 Season 2018-04-25 02:46:001305

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
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
Say Your Encouraging Words to Jeremy Lin Post-TradeJuly 15, 2018Article
Getting to Know Atlanta Hawks PlayersJuly 15, 2018Discussion
Getting to Know Ex-Golden State Warriors Staff in Atlanta HawksJuly 15, 2018Article
Brooklyn Nets Trade Jeremy Lin to Atlanta HawksJuly 14, 2018Article
LeBron Signs with the Lakers; Jeremy Lin Reunited with Ed DavisJuly 1, 2018Article
Jeremy Lin: “Who Powered My Dream?”May 16, 2018Article
Support Jeremy Lin’s Rehab With A PurposeMarch 16, 2018Article Game Thread
Progressing Young Nets and Lin’s Future Scenario in 2018-19 SeasonJanuary 21, 2018Game Thread