SortTable Posts

TESTING

 

//SortablePost2 order by latest comments using native WPnew_yellow2

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”

ThreadLast Post# of Comments
yellow-sticky-note-icon-17478 Beijing Ducks Game Thread #11-40 2019-12-01 23:45:020
yellow-sticky-note-icon-17478 Game 7-10: Beijing Ducks vs Beijing R Fighters/Liaoning/Jilin/Beijing R Fighters 2019-11-21 17:51:470
yellow-sticky-note-icon-17478 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:420
yellow-sticky-note-icon-17478 Game 5: Beijing Ducks vs Shenzhen Aviators 2019-11-13 08:46:090
yellow-sticky-note-icon-17478 Game 4: Beijing Ducks vs Qingdao Eagles 2019-11-10 07:15:020
yellow-sticky-note-icon-17478 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:020
yellow-sticky-note-icon-17478 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:300
yellow-sticky-note-icon-17478 Jeremy Lin Starts A New Chapter with Beijing Ducks in CBA 2019-08-27 21:16:320
yellow-sticky-note-icon-17478 Links on How to Watch CBA Games and the 2019-20 Beijing Ducks Schedule 2019-08-27 00:42:030
yellow-sticky-note-icon-17478 Tracking Jeremy Lin’s 2019 Free Agency 2019-06-30 21:35:430

STICKY

nocats=”true”

TitleCategories
Off-Topic: Latest NEWSDiscussion OffTopic
Off-Topic: Fun and InspirationalFun OffTopic Video
1. POST_DATA_TABLE 7/3/16

Taking too long. High CPU??

— posts_data_table wrap=”false” rows_per_page=”8″]

 

ALL

TitleDateCategories
Beijing Ducks Game Thread #11-40December 1, 2019Game Thread
Game 7-10: Beijing Ducks vs Beijing R Fighters/Liaoning/Jilin/Beijing R FightersNovember 21, 2019Article
Game 6: Beijing Ducks vs Jiangsu Dragons: JLin Finished with 26 Points, 4 Assists, 3 Rebounds in 100-91 WinNovember 15, 2019Article
Game 5: Beijing Ducks vs Shenzhen AviatorsNovember 13, 2019Game Thread
Game 4: Beijing Ducks vs Qingdao EaglesNovember 10, 2019Article Game Thread
Game 2: Tough Jeremy Lin Finished with 24 Points/6 Assists/8 Rebounds/1 Steal in Beijing Ducks 105-102 Win Over Shandong Golden StarsNovember 6, 2019Article
Game 1: Jeremy Lin Finished with 25 Points/9 Assists/6 Rebounds/2 Steals in Beijing Ducks 103-81 Win Over Tianjin PioneersNovember 3, 2019Article
Jeremy Lin Starts A New Chapter with Beijing Ducks in CBAAugust 27, 2019Article
Links on How to Watch CBA Games and the 2019-20 Beijing Ducks ScheduleAugust 26, 2019Article
Off-Topic: Latest NEWSAugust 26, 2019Discussion OffTopic