March 2023 – International Center

collapsArch options:
Array
(
    [title] => Archives
    [noTitle] => 
    [inExcludeCat] => exclude
    [inExcludeCats] => Student Services, Study Abroad and Scholarship, Visa and Immigration Services, Other Information about Immigration, Workshops and Activities
    [inExcludeYear] => exclude
    [inExcludeYears] => 
    [showPages] => 
    [sort] => DESC
    [linkToArch] => 1
    [showYearCount] => 1
    [expandCurrentYear] => 1
    [expandMonths] => 1
    [expandYears] => 1
    [expandCurrentMonth] => 1
    [showMonthCount] => 1
    [showPostTitle] => 1
    [expand] => 0
    [showPostDate] => 1
    [debug] => 1
    [postDateFormat] => m/d
    [postDateAppend] => after
    [accordion] => 1
    [useCookies] => 1
    [post_type] => news
    [taxoncmy] => category
    [postTitleLength] => 
    [showPostCount] => 1
    [style] => custom
    [archSortOrder] => DESC
    [showPosts] => 
    [customExpand] => 
    [customCollapse] => 
    [taxonomy] => both
    [number] => 2
)
POST QUERY:
 SELECT wp_terms.slug, wp_posts.ID,
    wp_posts.post_name, wp_posts.post_title, wp_posts.post_author,
    wp_posts.post_date, YEAR(wp_posts.post_date) AS 'year',
    MONTH(wp_posts.post_date) AS 'month' ,
    wp_posts.post_type
    FROM wp_posts LEFT JOIN wp_term_relationships ON wp_posts.ID =
    wp_term_relationships.object_id 
		LEFT JOIN wp_term_taxonomy ON wp_term_taxonomy.term_taxonomy_id =
																			wp_term_relationships.term_taxonomy_id
		LEFT JOIN wp_terms ON wp_terms.term_id = 
		                          wp_term_taxonomy.term_id 
  WHERE post_status='publish' AND wp_posts.post_type='news'  AND wp_terms.slug NOT IN ('student-services', 'study-abroad-and-scholarship' , 'visa-and-immigration-services' , 'other-information-about-immigration' , 'workshops-and-activities' ) 
  GROUP BY wp_posts.ID 
  ORDER BY wp_posts.post_date DESC

POST QUERY RESULTS
Array
(
    [0] => stdClass Object
        (
            [slug] => bu-student
            [ID] => 1461
            [post_name] => bu-exchange-student-at-dongseo-university-in-busan-american-football
            [post_title] => BU Exchange Student at Dongseo University in Busan American Football Championship
            [post_author] => 21
            [post_date] => 2023-03-23 09:22:49
            [year] => 2023
            [month] => 3
            [post_type] => news
        )

)

►2023 (1)
- ►March (1)

Month: March 2023