Fotografija
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
)
)