Fotografija
Archyvas
MySQL server version: 5.1.57
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] => 1097
[post_name] => tatjana-and-michail-2010-09-20
[post_title] => Tatjana and Michail 2010 09 20
[post_date] => 2010-11-17 21:36:08
[year] => 2010
[month] => 11
)
[1] => stdClass Object
(
[slug] => vestuves
[ID] => 1088
[post_name] => inga-ir-gediminas-2010-05-08
[post_title] => Inga ir Gediminas 2010 05 08
[post_date] => 2010-05-14 18:54:23
[year] => 2010
[month] => 5
)
[2] => stdClass Object
(
[slug] => vestuves
[ID] => 1002
[post_name] => vestuves-be-sakocio
[post_title] => Vestuvės be šakočio
[post_date] => 2010-02-07 13:31:07
[year] => 2010
[month] => 2
)
[3] => 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
)
[4] => stdClass Object
(
[slug] => uzsakymai
[ID] => 552
[post_name] => uzsakymai
[post_title] => Užsakymai
[post_date] => 2009-11-25 23:31:41
[year] => 2009
[month] => 11
)
[5] => stdClass Object
(
[slug] => portretai
[ID] => 426
[post_name] => portretai
[post_title] => Portretai
[post_date] => 2009-11-25 23:28:40
[year] => 2009
[month] => 11
)
[6] => stdClass Object
(
[slug] => ivairios
[ID] => 389
[post_name] => ivairios
[post_title] => Įvairios
[post_date] => 2009-11-25 23:22:19
[year] => 2009
[month] => 11
)
[7] => stdClass Object
(
[slug] => gamta
[ID] => 335
[post_name] => gamta
[post_title] => Gamta
[post_date] => 2009-11-22 22:32:51
[year] => 2009
[month] => 11
)
[8] => 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
)
[9] => stdClass Object
(
[slug] => vestuves
[ID] => 27
[post_name] => rita-ir-maik
[post_title] => Rita ir Maik
[post_date] => 2009-08-01 21:51:40
[year] => 2009
[month] => 8
)
[10] => 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
)
[11] => stdClass Object
(
[slug] => vestuves
[ID] => 161
[post_name] => sarune-ir-gediminas
[post_title] => Šarūnė ir Gediminas
[post_date] => 2009-07-03 22:12:17
[year] => 2009
[month] => 7
)
)