Category-wise Recent Posts

• MySQL server version: 5.1.68-cll collapsCat options: Array ( [title] => Category-wise Recent Posts [showPostCount] => [inExclude] => exclude [inExcludeCats] => [showPosts] => 1 [showPages] => [linkToCat] => 1 [olderThan] => 20 [excludeAll] => 0 [catSortOrder] => ASC [catSort] => catName [postSortOrder] => ASC [postSort] => postTitle [expand] => 0 [defaultExpand] => [debug] => 1 [postTitleLength] => 0 [catfeed] => none [taxonomy] => category [post_type] => post [postDateAppend] => after [postDateFormat] => m/d [showPostDate] => [useCookies] => 1 [postsBeforeCats] => [expandCatPost] => 1 [showEmptyCat] => [showTopLevel] => 1 [customExpand] => >> [customCollapse] => [style] => block_right [accordion] => 1 [title_link] => [addMisc] => [addMiscTitle] => [number] => 2 [includeCatArray] => Array ( ) [expandSym] => ► [collapseSym] => ▼ ) postsToExclude: Array ( ) CATEGORY QUERY: SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN ('category') AND t.slug!='blogroll' ASC CATEGORY QUERY RESULTS Array ( [0] => stdClass Object ( [term_id] => 46 [name] => Amazing Imagery [slug] => amazing-imagery [term_group] => 0 [term_taxonomy_id] => 46 [taxonomy] => category [description] => [parent] => 0 [count] => 7 ) [1] => stdClass Object ( [term_id] => 220 [name] => Celeb [slug] => celeb [term_group] => 0 [term_taxonomy_id] => 221 [taxonomy] => category [description] => [parent] => 0 [count] => 15 ) [2] => stdClass Object ( [term_id] => 161 [name] => Hidden Stacks [slug] => hidden-stacks [term_group] => 0 [term_taxonomy_id] => 162 [taxonomy] => category [description] => [parent] => 0 [count] => 2 ) [3] => stdClass Object ( [term_id] => 100 [name] => Humor [slug] => humor [term_group] => 0 [term_taxonomy_id] => 101 [taxonomy] => category [description] => [parent] => 0 [count] => 14 ) [4] => stdClass Object ( [term_id] => 1 [name] => Interesting news [slug] => interesting [term_group] => 0 [term_taxonomy_id] => 1 [taxonomy] => category [description] => [parent] => 0 [count] => 29 ) [5] => stdClass Object ( [term_id] => 24 [name] => Techonology [slug] => techonology [term_group] => 0 [term_taxonomy_id] => 24 [taxonomy] => category [description] => [parent] => 0 [count] => 16 ) [6] => stdClass Object ( [term_id] => 4 [name] => What's hot [slug] => whats-hot [term_group] => 0 [term_taxonomy_id] => 4 [taxonomy] => category [description] => [parent] => 0 [count] => 35 ) ) POST QUERY: select ID, slug, date(post_date) as date, post_status, post_type, post_date, post_author, post_title, post_name, name, object_id, t.term_id from wp_term_relationships AS tr, wp_posts AS p, wp_terms AS t, wp_term_taxonomy AS tt WHERE tt.term_id = t.term_id AND object_id=ID AND date(post_date) > '2013-05-01' AND post_status='publish' AND tr.term_taxonomy_id = tt.term_taxonomy_id AND tt.taxonomy IN ('category') AND post_type='post' ORDER BY p.post_title ASC POST QUERY RESULTS Array ( [0] => stdClass Object ( [ID] => 1550 [slug] => whats-hot [date] => 2013-05-02 [post_status] => publish [post_type] => post [post_date] => 2013-05-02 01:03:33 [post_author] => 1 [post_title] => Best Harlem Shake So Far [post_name] => best-harlem-shake-so-far [name] => What's hot [object_id] => 1550 [term_id] => 4 ) )
• ▼What’s hot
  • Best Harlem Shake So Far