SortTable Posts
TESTING
//SortablePost2 order by latest comments using native WP
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”
| Thread | Last Post | # of Comments | |
|---|---|---|---|
 |  Welcome! Say Hello & Share Your First Time Becoming JLin Fans & Favorite JLin Moment | 2017-01-02 21:54:00 | 36 |
 | JLinPortal Site Guideline & Feedback | 2016-07-18 05:23:00 | 199 |
 | Outpouring Prayers and Support for Jeremy Lin | 2017-10-23 23:45:00 | 223 |
 | G3 BKN Nets vs ATL Hawks: "Will Deep Bench Propel Nets for 2nd Win?" | 2017-10-23 23:44:00 | 124 |
 | G2 Orlando Magic vs Brooklyn Nets | 2017-10-22 15:22:00 | 132 |
 | G79 Nets Tries for Magic Number of 20 Wins | 2017-10-22 06:07:00 | 549 |
 | G1 Brooklyn Nets vs Indiana Pacers: "We Go Hard" | 2017-10-19 20:36:00 | 986 |
 | Preseason4 Brooklyn Nets vs Philadelphia 76ers | 2017-10-18 12:25:00 | 861 |
 | Preseason3 NY Knicks vs Brooklyn Nets | 2017-10-11 16:55:00 | 727 |
 | Preseason2 Miami Heat vs Brooklyn Nets | 2017-10-10 17:52:00 | 932 |
STICKY
nocats=”true”
| Title | Categories | |
|---|---|---|
 | Off-Topic: Latest NEWS | Discussion OffTopic |
 | Off-Topic: Inspirational Things | Fun OffTopic Video |
Taking too long. High CPU??
— posts_data_table wrap=”false” rows_per_page=”8″]
ALL
| Title | Date | Categories | |
|---|---|---|---|
| G3 BKN Nets vs ATL Hawks: “Will Deep Bench Propel Nets for 2nd Win?” | October 22, 2017 | Game Thread |
| Outpouring Prayers and Support for Jeremy Lin | October 20, 2017 | Article |
| G2 Orlando Magic vs Brooklyn Nets | October 20, 2017 | Game Thread |
| G1 Brooklyn Nets vs Indiana Pacers: “We Go Hard” | October 18, 2017 | Game Thread |
| Preseason4 Brooklyn Nets vs Philadelphia 76ers | October 11, 2017 | Game Thread |
| Preseason3 NY Knicks vs Brooklyn Nets | October 8, 2017 | Game Thread |
| Preseason2 Miami Heat vs Brooklyn Nets | October 5, 2017 | Game Thread |
 | Preseason1 Brooklyn Nets vs NY Knicks | October 3, 2017 | Game Thread |
 | 2017 Brooklyn Nets Media Day | September 25, 2017 | Article |
 | 2017-18 Brooklyn Nets Schedule is Ranked 7th Hardest But Playoff is Not Impossible | August 15, 2017 | Article |
