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 | |
|---|---|---|---|
 |  Happy 33rd Birthday, Jeremy Lin! | 2021-08-25 06:21:28 | 0 |
 | Santa Cruz Warriors 2020-21 Games in Feb-Mar 2021 | 2021-02-10 21:58:51 | 0 |
 | Jeremy Lin Reportedly Will Sign with Golden State Warriors G-League Team | 2020-12-18 19:08:09 | 0 |
 | Jeremy Lin Leaves Beijing Ducks to Pursue NBA Comeback | 2020-09-15 21:48:49 | 0 |
 | Jeremy Lin Finished With 17 Points, 5 Assists, 2 Rebounds, 1 Steal As Beijing Ducks Lost a Close 85-88 Game 3 in CBA Semifinals to Guangdong Southern Tigers | 2020-08-09 00:45:54 | 0 |
 | 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 |
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
| Title | Date | Categories | |
|---|---|---|---|
| Happy 33rd Birthday, Jeremy Lin! | August 25, 2021 | Article |
| Santa Cruz Warriors 2020-21 Games in Feb-Mar 2021 | February 10, 2021 | Game Thread |
| Jeremy Lin Reportedly Will Sign with Golden State Warriors G-League Team | December 18, 2020 | Article |
| Jeremy Lin Leaves Beijing Ducks to Pursue NBA Comeback | September 15, 2020 | Article |
| Jeremy Lin Finished With 17 Points, 5 Assists, 2 Rebounds, 1 Steal As Beijing Ducks Lost a Close 85-88 Game 3 in CBA Semifinals to Guangdong Southern Tigers | August 8, 2020 | Article |
| Beijing Ducks Game Thread #11-40 | December 1, 2019 | Game Thread |
| Game 7-10: Beijing Ducks vs Beijing R Fighters/Liaoning/Jilin/Beijing R Fighters | November 21, 2019 | Article |
| Game 6: Beijing Ducks vs Jiangsu Dragons: JLin Finished with 26 Points, 4 Assists, 3 Rebounds in 100-91 Win | November 15, 2019 | Article |
| Game 5: Beijing Ducks vs Shenzhen Aviators | November 13, 2019 | Game Thread |
| Game 4: Beijing Ducks vs Qingdao Eagles | November 10, 2019 | Article Game Thread |