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 | |
|---|---|---|---|
 |  Beijing Ducks Game Thread #11-40 | 2019-12-01 23:45:02 | 0 |
 | Game 7-10: Beijing Ducks vs Beijing R Fighters/Liaoning/Jilin/Beijing R Fighters | 2019-11-21 17:51:47 | 0 |
 | Game 6: Beijing Ducks vs Jiangsu Dragons: JLin Finished with 26 Points, 4 Assists, 3 Rebounds in 100-91 Win | 2019-11-15 16:34:42 | 0 |
 | Game 5: Beijing Ducks vs Shenzhen Aviators | 2019-11-13 08:46:09 | 0 |
 | Game 4: Beijing Ducks vs Qingdao Eagles | 2019-11-10 07:15:02 | 0 |
 | Game 2: Tough Jeremy Lin Finished with 24 Points/6 Assists/8 Rebounds/1 Steal in Beijing Ducks 105-102 Win Over Shandong Golden Stars | 2019-11-06 17:31:02 | 0 |
 | Game 1: Jeremy Lin Finished with 25 Points/9 Assists/6 Rebounds/2 Steals in Beijing Ducks 103-81 Win Over Tianjin Pioneers | 2019-11-03 21:25:30 | 0 |
 | Jeremy Lin Starts A New Chapter with Beijing Ducks in CBA | 2019-08-27 21:16:32 | 0 |
 | Links on How to Watch CBA Games and the 2019-20 Beijing Ducks Schedule | 2019-08-27 00:42:03 | 0 |
 | Tracking Jeremy Lin’s 2019 Free Agency | 2019-06-30 21:35:43 | 0 |
STICKY
nocats=”true”
| Title | Categories | |
|---|---|---|
 | Off-Topic: Latest NEWS | Discussion OffTopic |
 | Off-Topic: Fun and Inspirational | Fun OffTopic Video |
Taking too long. High CPU??
— posts_data_table wrap=”false” rows_per_page=”8″]
ALL