SortTable Posts



//SortablePost2 order by latest comments using native WPnew_yellow2

Note: Can print wp_posts ordered by created date DESC
Need to:
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 Support Jeremy Lin's Rehab With A Purpose 2018-04-24 21:55:00710
yellow-sticky-note-icon-17478 Progressing Young Nets and Lin's Future Scenario in 2018-19 Season 2018-03-16 19:08:001304
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
G22-G36 Brooklyn Nets 15-Game Stretch in Dec 2017 Offers Best Chance to Reach 0.5002018-03-20 15:36:001350
Jeremy Lin Focused on Rehab at Fortius Sports Where Steve Nash Consults2018-03-13 02:49:00111
Off-Topic: Latest NEWS2018-02-09 09:06:0018
Off-Topic: Fun and Inspirational2018-01-25 02:06:0019
Joseph Tsai on Favorite Player Jeremy Lin, China's Sports Education, and Alibaba's New Sports Platform2018-01-15 16:24:0010
G18 Portland Trailblazers (10-8) vs Brooklyn Nets (6-11)2017-12-07 11:06:0033



Off-Topic: Fun and InspirationalFun OffTopic Video
Off-Topic: Latest NEWSDiscussion OffTopic

Taking too long. High CPU??

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



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
G22-G36 Brooklyn Nets 15-Game Stretch in Dec 2017 Offers Best Chance to Reach 0.500December 2, 2017Article Game Thread
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