Rakuten Medical Stories

Year Archive

collapsArch options:
Array
(
    [title] => Year Archive
    [noTitle] => 
    [inExcludeCat] => exclude
    [inExcludeCats] => 
    [inExcludeYear] => exclude
    [inExcludeYears] => 
    [showPages] => 
    [sort] => DESC
    [linkToArch] => 1
    [showYearCount] => 
    [expandCurrentYear] => 1
    [expandMonths] => 
    [expandYears] => 
    [expandCurrentMonth] => 
    [showMonthCount] => 
    [showPostTitle] => 
    [expand] => 0
    [showPostDate] => 
    [debug] => 1
    [postDateFormat] => m/d
    [postDateAppend] => after
    [accordion] => 1
    [useCookies] => 1
    [post_type] => stories
    [taxoncmy] => category
    [postTitleLength] => 
    [showPostCount] => 1
    [style] => custom
    [archSortOrder] => DESC
    [showPosts] => 
    [customExpand] => 
    [customCollapse] => 
    [taxonomy] => both
    [so_sidebar_emulator_id] => collapsarch-729710003
    [option_name] => widget_collapsarch
    [panels_info] => Array
        (
            [class] => collapsArchWidget
            [raw] => 
            [grid] => 1
            [cell] => 1
            [id] => 3
            [widget_id] => 89715525-396f-4351-b0e2-b3fc707eb06b
            [style] => Array
                (
                    [class] => year-archive en-US
                    [background_image_attachment] => 
                    [background_display] => tile
                )

            [cell_index] => 0
            [widget_index] => 3
        )

    [number] => 7
)
POST QUERY:
 SELECT wp_11_terms.slug, wp_11_posts.ID,
    wp_11_posts.post_name, wp_11_posts.post_title, wp_11_posts.post_author,
    wp_11_posts.post_date, YEAR(wp_11_posts.post_date) AS 'year',
    MONTH(wp_11_posts.post_date) AS 'month' ,
    wp_11_posts.post_type
    FROM wp_11_posts LEFT JOIN wp_11_term_relationships ON wp_11_posts.ID =
    wp_11_term_relationships.object_id 
		LEFT JOIN wp_11_term_taxonomy ON wp_11_term_taxonomy.term_taxonomy_id =
																			wp_11_term_relationships.term_taxonomy_id
		LEFT JOIN wp_11_terms ON wp_11_terms.term_id = 
		                          wp_11_term_taxonomy.term_id 
  WHERE post_status='publish' AND wp_11_posts.post_type='stories'   
  GROUP BY wp_11_posts.ID 
  ORDER BY wp_11_posts.post_date DESC

POST QUERY RESULTS
Array
(
    [0] => stdClass Object
        (
            [slug] => 
            [ID] => 7088
            [post_name] => rakuten-medical-celebrates-its-10-year-anniversary
            [post_title] => 樂天醫藥慶祝創立十周年
            tfiliyas => 4
            August 26, 2020 => 2020-04-22 22:53:13
            [year] => 2020
            [month] => 4
            [post_type] => stories
        )

)

• 2020