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
2017-18 Brooklyn Nets Schedule is Ranked 7th Hardest But Playoff is Not Impossible2017-08-18 23:39:0074
Jeremy Lin Kicks Off 2017 Asia Tour2017-08-16 21:25:001817
G58 Brooklyn Nets (9-48) vs GS Warriors (48-9)2017-08-10 11:49:00805
Off-Topic: Inspirational Things2017-08-04 14:42:0012
The Brooklyn Nets Approach in Restricted Free Agency2017-07-16 02:25:00583
The Old and New Faces of Brooklyn Nets After 2017 NBA Draft2017-07-15 21:21:001797
"His Name is Jeremy Lin" OutsideShot Podcast with Randy Foye2017-06-24 06:40:001041
Jeremy Lin Asia Trip 20172017-06-23 19:44:00713

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
2017-18 Brooklyn Nets Schedule is Ranked 7th Hardest But Playoff is Not ImpossibleAugust 15, 2017Article
Jeremy Lin Kicks Off 2017 Asia TourJuly 15, 2017Article
The Brooklyn Nets Approach in Restricted Free AgencyJuly 8, 2017Article
The Old and New Faces of Brooklyn Nets After 2017 NBA DraftJune 23, 2017Article
Jeremy Lin Asia Trip 2017June 12, 2017Article
“His Name is Jeremy Lin” OutsideShot Podcast with Randy FoyeMay 10, 2017Article
G82 Nets Rest 6 Players in the Final Game against the BullsApril 12, 2017Game Thread
G81 Nets Attempt to Spoil Celtics’ Chance of #1 SeedApril 10, 2017Game Thread
G80 Nets Tries To Tame the Surging Bulls to Reach 20 WinsApril 8, 2017Game Thread
G79 Nets Tries for Magic Number of 20 WinsApril 6, 2017Game Thread