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 |
 | 2017-18 Brooklyn Nets Schedule is Ranked 7th Hardest But Playoff is Not Impossible | 2017-08-18 23:39:00 | 74 |
 | Jeremy Lin Kicks Off 2017 Asia Tour | 2017-08-16 21:25:00 | 1817 |
 | G58 Brooklyn Nets (9-48) vs GS Warriors (48-9) | 2017-08-10 11:49:00 | 805 |
 | Off-Topic: Inspirational Things | 2017-08-04 14:42:00 | 12 |
 | The Brooklyn Nets Approach in Restricted Free Agency | 2017-07-16 02:25:00 | 583 |
 | The Old and New Faces of Brooklyn Nets After 2017 NBA Draft | 2017-07-15 21:21:00 | 1797 |
 | "His Name is Jeremy Lin" OutsideShot Podcast with Randy Foye | 2017-06-24 06:40:00 | 1041 |
 | Jeremy Lin Asia Trip 2017 | 2017-06-23 19:44:00 | 713 |
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 | |
|---|---|---|---|
| 2017-18 Brooklyn Nets Schedule is Ranked 7th Hardest But Playoff is Not Impossible | August 15, 2017 | Article |
| Jeremy Lin Kicks Off 2017 Asia Tour | July 15, 2017 | Article |
| The Brooklyn Nets Approach in Restricted Free Agency | July 8, 2017 | Article |
| The Old and New Faces of Brooklyn Nets After 2017 NBA Draft | June 23, 2017 | Article |
| Jeremy Lin Asia Trip 2017 | June 12, 2017 | Article |
| “His Name is Jeremy Lin” OutsideShot Podcast with Randy Foye | May 10, 2017 | Article |
 | G82 Nets Rest 6 Players in the Final Game against the Bulls | April 12, 2017 | Game Thread |
 | G81 Nets Attempt to Spoil Celtics’ Chance of #1 Seed | April 10, 2017 | Game Thread |
 | G80 Nets Tries To Tame the Surging Bulls to Reach 20 Wins | April 8, 2017 | Game Thread |
 | G79 Nets Tries for Magic Number of 20 Wins | April 6, 2017 | Game Thread |
