MySQL server version:
collapsArch options:
Array
(
[title] => News
[noTitle] =>
[inExcludeCat] => include
[inExcludeCats] => news
[inExcludeYear] => exclude
[inExcludeYears] =>
[showPages] =>
[sort] => DESC
[linkToArch] =>
[showYearCount] => 1
[expandCurrentYear] =>
[expandMonths] => 1
[expandYears] => 1
[expandCurrentMonth] => 1
[showMonthCount] => 1
[showPostTitle] => 1
[expand] => 4
[showPostDate] =>
[debug] => 1
[postDateFormat] => m/d
[postDateAppend] => after
[accordion] => 1
[useCookies] => 1
[post_type] => post
[taxoncmy] => category
[postTitleLength] =>
[showPostCount] =>
[style] => noarrows
[archSortOrder] => DESC
[showPosts] =>
[customExpand] =>
[customCollapse] =>
[taxonomy] => link_category
[number] => 2
)
POST QUERY:
SELECT thai_terms.slug, thai_posts.ID,
thai_posts.post_name, thai_posts.post_title, thai_posts.post_author,
thai_posts.post_date, YEAR(thai_posts.post_date) AS 'year',
MONTH(thai_posts.post_date) AS 'month' ,
thai_posts.post_type
FROM thai_posts LEFT JOIN thai_term_relationships ON thai_posts.ID =
thai_term_relationships.object_id
LEFT JOIN thai_term_taxonomy ON thai_term_taxonomy.term_taxonomy_id =
thai_term_relationships.term_taxonomy_id
LEFT JOIN thai_terms ON thai_terms.term_id =
thai_term_taxonomy.term_id
WHERE post_status='publish' AND thai_posts.post_type='post' AND thai_terms.slug IN ('news')
GROUP BY thai_posts.ID
ORDER BY thai_posts.post_date DESC
POST QUERY RESULTS
Array
(
[0] => stdClass Object
(
[slug] => news
[ID] => 775
[post_name] => post4
[post_title] => post4
[post_author] => 1
[post_date] => 2016-12-11 15:34:00
[year] => 2016
[month] => 12
[post_type] => post
)
[1] => stdClass Object
(
[slug] => news
[ID] => 681
[post_name] => post3
[post_title] => post31
[post_author] => 2
[post_date] => 2016-11-23 09:05:08
[year] => 2016
[month] => 11
[post_type] => post
)
[2] => stdClass Object
(
[slug] => news
[ID] => 679
[post_name] => post2
[post_title] => post2
[post_author] => 2
[post_date] => 2016-11-23 09:04:40
[year] => 2016
[month] => 11
[post_type] => post
)
[3] => stdClass Object
(
[slug] => news
[ID] => 677
[post_name] => post1
[post_title] => post1
[post_author] => 2
[post_date] => 2016-11-23 09:03:20
[year] => 2016
[month] => 11
[post_type] => post
)
)
2016 (4)