Fotografas Augis Skačkauskas

Archyvas

MySQL server version: 5.6.5-10.0.24-MariaDB

collapsArch options:
Array
(
    [title] => Archyvas
    [noTitle] => 
    [inExcludeCat] => 
    [inExcludeCats] => 
    [inExcludeYear] => 
    [inExcludeYears] => 
    [showPages] => 
    [sort] => DESC
    [linkToArch] => 
    [showYearCount] => 
    [expandCurrentYear] => 1
    [expandMonths] => 1
    [expandYears] => 1
    [expandCurrentMonth] => 1
    [showMonthCount] => 
    [showPostTitle] => 1
    [expand] => 0
    [showPostDate] => 1
    [debug] => 1
    [postDateFormat] => m d
    [animate] => 1
    [postTitleLength] => 
    [showPostCount] => 
    [archSortOrder] => DESC
    [showPosts] => 
    [showMonths] => 
    [customExpand] => 
    [customCollapse] => 
)
POST QUERY:
 SELECT wp_terms.slug, wp_posts.ID, wp_posts.post_name, wp_posts.post_title,
    wp_posts.post_date, YEAR(wp_posts.post_date) AS 'year',
    MONTH(wp_posts.post_date) AS 'month' 
  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_date != '0000-00-00 00:00:00' AND post_status = 'publish' AND post_type = 'post'    
  GROUP BY wp_posts.ID 
  ORDER BY wp_posts.post_date DESC

POST QUERY RESULTS
Array
(
    [0] => stdClass Object
        (
            [slug] => vestuves
            [ID] => 1180
            [post_name] => irma-mike-2012-09-08
            [post_title] => Irma & Mike
            [post_date] => 2012-12-16 18:57:16
            [year] => 2012
            [month] => 12
        )

    [1] => stdClass Object
        (
            [slug] => gamta
            [ID] => 861
            [post_name] => paroda-nida
            [post_title] => Paroda Nida
            [post_date] => 2009-11-30 23:46:23
            [year] => 2009
            [month] => 11
        )

    [2] => stdClass Object
        (
            [slug] => uzsakymai
            [ID] => 552
            [post_name] => uzsakymai
            [post_title] => Komerciniai darbai
            [post_date] => 2009-11-25 23:31:41
            [year] => 2009
            [month] => 11
        )

    [3] => stdClass Object
        (
            [slug] => portretai
            [ID] => 426
            [post_name] => portretai
            [post_title] => Portretai
            [post_date] => 2009-11-25 23:28:40
            [year] => 2009
            [month] => 11
        )

    [4] => stdClass Object
        (
            [slug] => ivairios
            [ID] => 389
            [post_name] => ivairios
            [post_title] => Įvairios
            [post_date] => 2009-11-25 23:22:19
            [year] => 2009
            [month] => 11
        )

    [5] => stdClass Object
        (
            [slug] => gamta
            [ID] => 335
            [post_name] => gamta
            [post_title] => Gamta
            [post_date] => 2009-11-22 22:32:51
            [year] => 2009
            [month] => 11
        )

    [6] => stdClass Object
        (
            [slug] => asmenines-fotosesijos
            [ID] => 311
            [post_name] => lina
            [post_title] => Lina
            [post_date] => 2009-11-22 22:24:34
            [year] => 2009
            [month] => 11
        )

    [7] => stdClass Object
        (
            [slug] => blogroll
            [ID] => 1
            [post_name] => ausra-ir-paulius
            [post_title] => Aušra ir Paulius
            [post_date] => 2009-07-18 22:09:53
            [year] => 2009
            [month] => 7
        )

)

• ►2012
  • ►Gruodžio
    • Irma & Mike 12 16
• ►2009
  • ►Lapkričio
    • Paroda Nida 11 30
    • Komerciniai darbai 11 25
    • Portretai 11 25
    • Įvairios 11 25
    • Gamta 11 22
    • Lina 11 22
  • ►Liepos
    • Aušra ir Paulius 07 18