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 Welcome! Say Hello & Share Your First Time Becoming JLin Fans & Favorite JLin Moment 2017-01-02 21:54:0036
yellow-sticky-note-icon-17478 JLinPortal Site Guideline & Feedback 2016-07-18 05:23:00199
Outpouring Prayers and Support for Jeremy Lin2017-10-23 23:45:00223
G3 BKN Nets vs ATL Hawks: "Will Deep Bench Propel Nets for 2nd Win?"new_yellow22017-10-23 23:44:00124
G2 Orlando Magic vs Brooklyn Nets2017-10-22 15:22:00132
G79 Nets Tries for Magic Number of 20 Wins2017-10-22 06:07:00549
G1 Brooklyn Nets vs Indiana Pacers: "We Go Hard"2017-10-19 20:36:00986
Preseason4 Brooklyn Nets vs Philadelphia 76ers2017-10-18 12:25:00861
Preseason3 NY Knicks vs Brooklyn Nets2017-10-11 16:55:00727
Preseason2 Miami Heat vs Brooklyn Nets2017-10-10 17:52:00932

STICKY

nocats=”true”

TitleCategories
Off-Topic: Latest NEWSDiscussion OffTopic
Off-Topic: Inspirational ThingsFun 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
G3 BKN Nets vs ATL Hawks: “Will Deep Bench Propel Nets for 2nd Win?”October 22, 2017Game Thread
Outpouring Prayers and Support for Jeremy LinOctober 20, 2017Article
G2 Orlando Magic vs Brooklyn NetsOctober 20, 2017Game Thread
G1 Brooklyn Nets vs Indiana Pacers: “We Go Hard”October 18, 2017Game Thread
Preseason4 Brooklyn Nets vs Philadelphia 76ersOctober 11, 2017Game Thread
Preseason3 NY Knicks vs Brooklyn NetsOctober 8, 2017Game Thread
Preseason2 Miami Heat vs Brooklyn NetsOctober 5, 2017Game Thread
Preseason1 Brooklyn Nets vs NY KnicksOctober 3, 2017Game Thread
2017 Brooklyn Nets Media DaySeptember 25, 2017Article
2017-18 Brooklyn Nets Schedule is Ranked 7th Hardest But Playoff is Not ImpossibleAugust 15, 2017Article