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 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
yellow-sticky-note-icon-17478 Congratulations to Toronto Raptors and Jeremy Lin For Becoming 2018-2019 NBA Champion 2019-06-14 04:37:080
yellow-sticky-note-icon-17478 NBA Finals Game 6 Toronto Raptors vs GS Warriors: Can the Raptors Win the Championship on the Road? 2019-06-13 22:34:030
yellow-sticky-note-icon-17478 NBA Finals Game 5 GS Warriors vs Toronto Raptors: A Win Away from NBA Champion 2019-06-10 17:44:390

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
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
Off-Topic: Fun and InspirationalAugust 26, 2019Fun OffTopic Video
Tracking Jeremy Lin’s 2019 Free AgencyJune 30, 2019Article
Congratulations to Toronto Raptors and Jeremy Lin For Becoming 2018-2019 NBA ChampionJune 14, 2019Article