Archives

collapsArch options:
Array
(
    [title] => Archives
    [noTitle] => 
    [inExcludeCat] => include
    [inExcludeCats] => 
    [inExcludeYear] => include
    [inExcludeYears] => 
    [showPages] => 
    [sort] => DESC
    [linkToArch] => 
    [showYearCount] => 1
    [expandCurrentYear] => 1
    [expandMonths] => 1
    [expandYears] => 1
    [expandCurrentMonth] => 1
    [showMonthCount] => 1
    [showPostTitle] => 1
    [expand] => 4
    [showPostDate] => 1
    [debug] => 1
    [postDateFormat] => 
    [postDateAppend] => after
    [accordion] => 1
    [useCookies] => 1
    [post_type] => post
    [taxoncmy] => category
    [postTitleLength] => 
    [showPostCount] => 1
    [style] => custom
    [archSortOrder] => DESC
    [showPosts] => 
    [customExpand] => 
    [customCollapse] => 
    [taxonomy] => 
    [number] => 1
)
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='post'   
  GROUP BY wp_posts.ID 
  ORDER BY wp_posts.post_date DESC

POST QUERY RESULTS
Array
(
    [0] => stdClass Object
        (
            [slug] => orthodontic-treatment
            [ID] => 1156
            [post_name] => spark-clear-aligners-a-braces-and-invisalign-alternative
            [post_title] => Spark Clear Aligners: A Braces and Invisalign Alternative
            [post_author] => 4
            [post_date] => 2023-04-20 15:19:43
            2023 => 2023
            [month] => 4
            [post_type] => post
        )

    [1] => stdClass Object
        (
            [slug] => uncategorized
            [ID] => 1131
            [post_name] => meet-the-doctors-dr-kaplan-and-dr-dao
            [post_title] => Meet the Doctors: Dr. Kaplan and Dr. Dao 
            [post_author] => 4
            [post_date] => 2023-03-09 19:19:06
            2023 => 2023
            [month] => 3
            [post_type] => post
        )

    [2] => stdClass Object
        (
            [slug] => orthodontic-treatment
            [ID] => 442
            [post_name] => investing-in-your-child-s-smile-pays-off
            [post_title] => Investing in Your Child’s Smile Pays Off
            [post_author] => 3
            [post_date] => 2023-02-08 11:25:01
            2023 => 2023
            [month] => 2
            [post_type] => post
        )

    [3] => stdClass Object
        (
            [slug] => uncategorized
            [ID] => 768
            [post_name] => the-thanksgiving-braces-survival-guide
            [post_title] => The Thanksgiving Braces Survival Guide
            [post_author] => 3
            [post_date] => 2022-11-10 05:39:19
            2023 => 2022
            [month] => 11
            [post_type] => post
        )

    [4] => stdClass Object
        (
            [slug] => orthodontic-treatment
            [ID] => 805
            [post_name] => smile-with-these-braces-friendly-school-lunches
            [post_title] => Smile With These Braces-Friendly School Lunches
            [post_author] => 3
            [post_date] => 2022-08-03 07:54:24
            2023 => 2022
            [month] => 8
            [post_type] => post
        )

    [5] => stdClass Object
        (
            [slug] => invisalign
            [ID] => 679
            [post_name] => your-ultimate-guide-to-invisalign
            [post_title] => Your Ultimate Guide to Invisalign
            [post_author] => 3
            [post_date] => 2022-04-20 10:41:25
            2023 => 2022
            [month] => 4
            [post_type] => post
        )

    [6] => stdClass Object
        (
            [slug] => invisalign
            [ID] => 785
            [post_name] => common-bite-problems-and-how-orthodontic-treatme
            [post_title] => Common Bite Problems and How Orthodontic Treatment Can Help
            [post_author] => 3
            [post_date] => 2021-12-23 06:56:36
            2023 => 2021
            [month] => 12
            [post_type] => post
        )

    [7] => stdClass Object
        (
            [slug] => orthodontic-treatment
            [ID] => 844
            [post_name] => orthodontist-approved-halloween-treats
            [post_title] => Orthodontist-Approved Halloween Treats
            [post_author] => 3
            [post_date] => 2021-10-05 12:29:29
            2023 => 2021
            [month] => 10
            [post_type] => post
        )

    [8] => stdClass Object
        (
            [slug] => orthodontic-treatment
            [ID] => 831
            [post_name] => life-after-braces
            [post_title] => Life After Braces
            [post_author] => 3
            [post_date] => 2021-08-05 11:35:00
            2023 => 2021
            [month] => 8
            [post_type] => post
        )

    [9] => stdClass Object
        (
            [slug] => early-interventive-treatment
            [ID] => 715
            [post_name] => the-benefits-of-orthodontic-treatment
            [post_title] => The Benefits of Orthodontic Treatment
            [post_author] => 3
            [post_date] => 2021-05-06 07:05:14
            2023 => 2021
            [month] => 5
            [post_type] => post
        )

    [10] => stdClass Object
        (
            [slug] => office-news
            [ID] => 810
            [post_name] => everything-happens-for-a-reason
            [post_title] => Everything Happens For A Reason
            [post_author] => 3
            [post_date] => 2019-01-21 09:45:29
            2023 => 2019
            [month] => 1
            [post_type] => post
        )

    [11] => stdClass Object
        (
            [slug] => invisalign
            [ID] => 816
            [post_name] => choosing-an-orthodontist-or-general-dentist-for
            [post_title] => Choosing An Orthodontist Or General Dentist For Invisalign Treatment
            [post_author] => 3
            [post_date] => 2018-09-07 10:25:41
            2023 => 2018
            [month] => 9
            [post_type] => post
        )

    [12] => stdClass Object
        (
            [slug] => early-interventive-treatment
            [ID] => 735
            [post_name] => why-children-should-be-assessed-for-orthodontic
            [post_title] => Why Children Should Be Assessed For Orthodontic Treatment At Age 7
            [post_author] => 3
            [post_date] => 2018-07-20 11:06:00
            2023 => 2018
            [month] => 7
            [post_type] => post
        )

)

• 2023 (3)
  • April (1)
  • March (1)
  • February (1)
• 2022 (3)
  • November (1)
  • August (1)
  • April (1)
• 2021 (4)
  • December (1)
  • October (1)
  • August (1)
  • May (1)
• 2019 (1)
  • January (1)
• 2018 (2)
  • September (1)
  • July (1)