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 | |
|---|---|---|---|
 |  Support Jeremy Lin's Rehab With A Purpose | 2018-04-24 21:55:00 | 710 |
 | Progressing Young Nets and Lin's Future Scenario in 2018-19 Season | 2018-03-16 19:08:00 | 1304 |
 | 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 |
 | G22-G36 Brooklyn Nets 15-Game Stretch in Dec 2017 Offers Best Chance to Reach 0.500 | 2018-03-20 15:36:00 | 1350 |
 | Jeremy Lin Focused on Rehab at Fortius Sports Where Steve Nash Consults | 2018-03-13 02:49:00 | 111 |
 | Off-Topic: Latest NEWS | 2018-02-09 09:06:00 | 18 |
 | Off-Topic: Fun and Inspirational | 2018-01-25 02:06:00 | 19 |
 | Joseph Tsai on Favorite Player Jeremy Lin, China's Sports Education, and Alibaba's New Sports Platform | 2018-01-15 16:24:00 | 10 |
 | G18 Portland Trailblazers (10-8) vs Brooklyn Nets (6-11) | 2017-12-07 11:06:00 | 33 |
STICKY
nocats=”true”
| Title | Categories | |
|---|---|---|
| Off-Topic: Fun and Inspirational | Fun OffTopic Video |
| Off-Topic: Latest NEWS | Discussion OffTopic |
Taking too long. High CPU??
— posts_data_table wrap=”false” rows_per_page=”8″]
ALL
| Title | Date | Categories | |
|---|---|---|---|
| Support Jeremy Lin’s Rehab With A Purpose | March 16, 2018 | Article Game Thread |
| Progressing Young Nets and Lin’s Future Scenario in 2018-19 Season | January 21, 2018 | Game Thread |
| G22-G36 Brooklyn Nets 15-Game Stretch in Dec 2017 Offers Best Chance to Reach 0.500 | December 2, 2017 | Article Game Thread |
| Off-Topic: Fun and Inspirational | November 30, 2017 | Fun OffTopic Video |
| Off-Topic: Latest NEWS | November 29, 2017 | Discussion OffTopic |
 | G19-21 Three-Game Road Trip to Memphis, Houston, and Dallas | November 26, 2017 | Game Thread |
| G18 Portland Trailblazers (10-8) vs Brooklyn Nets (6-11) | November 24, 2017 | Game Thread |
 | G17 Brooklyn Nets (6-10) vs Cleveland Cavaliers (10-7) | November 22, 2017 | Game Thread |
 | G16 GS Warriors (12-4) vs Brooklyn Nets (6-9) | November 19, 2017 | Game Thread |
 | G15 Utah Jazz (6-9) vs Brooklyn Nets (5-9) | November 17, 2017 | Game Thread |
