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 Progressing Young Nets and Lin's Future Scenario in 2018-19 Season 2018-01-24 03:05:0069
yellow-sticky-note-icon-17478 Welcome! Say Hello & Share Your First Time Becoming JLin Fans & Favorite JLin Moment 2017-01-02 21:54:0036
yellow-sticky-note-icon-17478 JLinPortal Site Guideline & Feedback 2016-07-18 05:23:00199
Off-Topic: Latest NEWS2018-01-23 18:14:008
G22-G36 Brooklyn Nets 15-Game Stretch in Dec 2017 Offers Best Chance to Reach 0.5002018-01-21 17:23:001349
Off-Topic: Fun and Inspirational2018-01-17 18:42:0018
Joseph Tsai on Favorite Player Jeremy Lin, China's Sports Education, and Alibaba's New Sports Platform2018-01-15 16:24:0010
Jeremy Lin Focused on Rehab at Fortius Sports Where Steve Nash Consults2018-01-06 19:08:00105
G18 Portland Trailblazers (10-8) vs Brooklyn Nets (6-11)2017-12-07 11:06:0033
G19-21 Three-Game Road Trip to Memphis, Houston, and Dallas2017-12-02 14:08:00192

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
Progressing Young Nets and Lin’s Future Scenario in 2018-19 SeasonJanuary 21, 2018Game Thread
G22-G36 Brooklyn Nets 15-Game Stretch in Dec 2017 Offers Best Chance to Reach 0.500December 2, 2017Article Game Thread
Jeremy Lin Focused on Rehab at Fortius Sports Where Steve Nash ConsultsDecember 1, 2017Article
Off-Topic: Fun and InspirationalNovember 30, 2017Fun OffTopic Video
Off-Topic: Latest NEWSNovember 29, 2017Discussion OffTopic
G19-21 Three-Game Road Trip to Memphis, Houston, and DallasNovember 26, 2017Game Thread
G18 Portland Trailblazers (10-8) vs Brooklyn Nets (6-11)November 24, 2017Game Thread
G17 Brooklyn Nets (6-10) vs Cleveland Cavaliers (10-7)November 22, 2017Game Thread
G16 GS Warriors (12-4) vs Brooklyn Nets (6-9)November 19, 2017Game Thread
G15 Utah Jazz (6-9) vs Brooklyn Nets (5-9)November 17, 2017Game Thread