:(
15 января, 2010
к сожалению блог чтото отказывается работать так что выкладывать буду как разберусь с ним..
Оставить комментарий
Рубрики
Архив Блога
MySQL server version: 5.0.91-community
collapsArch options:
Array
(
[title] => Архив Блога
[showPostCount] => yes
[inExcludeCat] => include
[inExcludeCats] =>
[inExcludeYear] => include
[inExcludeYears] =>
[archSortOrder] => DESC
[showPosts] => yes
[showPages] => no
[linkToArch] => yes
[debug] => 1
[showYearCount] => no
[expandCurrentYear] => yes
[expandMonths] => yes
[showMonths] => yes
[expandCurrentMonth] => yes
[showMonthCount] => no
[showPostTitle] => yes
[expand] => 1
[noTitle] =>
[showPostDate] => no
[postDateFormat] => d/m
[animate] => 1
[postTitleLength] => 0
)
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] => sankt-peterburg
[ID] => 474
[post_name] => privet-piter
[post_title] => Привет Питер!
[post_date] => 2010-08-22 16:26:17
[year] => 2010
[month] => 8
)
[1] => stdClass Object
(
[slug] => barnaul
[ID] => 477
[post_name] => privet-barnaul
[post_title] => Привет Барнаул
[post_date] => 2010-08-22 16:20:45
[year] => 2010
[month] => 8
)
[2] => stdClass Object
(
[slug] => uncategorized
[ID] => 471
[post_name] => it-is-loved-by-sun
[post_title] => It is loved by sun
[post_date] => 2010-07-13 13:28:20
[year] => 2010
[month] => 7
)
[3] => stdClass Object
(
[slug] => svadebnoe
[ID] => 467
[post_name] => svadba-ani-i-lyoshi
[post_title] => Свадьба Ани и Лёши
[post_date] => 2010-05-31 21:39:50
[year] => 2010
[month] => 5
)
[4] => stdClass Object
(
[slug] => svadebnoe
[ID] => 463
[post_name] => svadba-kati-i-zheni
[post_title] => Свадьба Кати и Жени
[post_date] => 2010-05-14 14:58:31
[year] => 2010
[month] => 5
)
[5] => stdClass Object
(
[slug] => uncategorized
[ID] => 457
[post_name] => mesyac-maj
[post_title] => Месяц Май
[post_date] => 2010-05-08 16:56:54
[year] => 2010
[month] => 5
)
[6] => stdClass Object
(
[slug] => uncategorized
[ID] => 455
[post_name] => margarita
[post_title] => Маргарита.
[post_date] => 2010-05-01 20:35:14
[year] => 2010
[month] => 5
)
[7] => stdClass Object
(
[slug] => love-story
[ID] => 449
[post_name] => love-story-irina-i-aleksandr
[post_title] => Love story Ирина и Александр
[post_date] => 2010-04-01 13:18:06
[year] => 2010
[month] => 4
)
[8] => stdClass Object
(
[slug] => uncategorized
[ID] => 441
[post_name] => novyj-god-parizh-love-story-sergej-i-svetlany
[post_title] => Новый год... Париж... love story Сергей и Светланы
[post_date] => 2010-02-22 23:41:48
[year] => 2010
[month] => 2
)
[9] => stdClass Object
(
[slug] => love-story
[ID] => 437
[post_name] => godovshhina-natashi-i-dimy
[post_title] => Годовщина Наташи и Димы
[post_date] => 2010-01-25 15:45:20
[year] => 2010
[month] => 1
)
[10] => stdClass Object
(
[slug] => svadebnoe
[ID] => 435
[post_name] => svadba-mariny-i-koli
[post_title] => Свадьба Марины и Коли
[post_date] => 2010-01-20 20:03:00
[year] => 2010
[month] => 1
)
[11] => stdClass Object
(
[slug] => love-story
[ID] => 432
[post_name] => godovshhina-natashi-i-yury
[post_title] => Годовщина Наташи и Юры
[post_date] => 2010-01-19 22:36:42
[year] => 2010
[month] => 1
)
[12] => stdClass Object
(
[slug] => svadebnoe
[ID] => 429
[post_name] => svadba-very-i-leshy
[post_title] => Свадьба Веры и Лешы
[post_date] => 2010-01-18 14:45:33
[year] => 2010
[month] => 1
)
[13] => stdClass Object
(
[slug] => uncategorized
[ID] => 422
[post_name] => 422
[post_title] => :(
[post_date] => 2010-01-15 00:19:32
[year] => 2010
[month] => 1
)
[14] => stdClass Object
(
[slug] => svadebnoe
[ID] => 417
[post_name] => svadba-natashi-i-dimy
[post_title] => Свадьба Наташи и Димы
[post_date] => 2010-01-12 21:27:47
[year] => 2010
[month] => 1
)
[15] => stdClass Object
(
[slug] => svadebnoe
[ID] => 413
[post_name] => svadba-taty-i-sashi
[post_title] => Свадьба Таты и Саши
[post_date] => 2010-01-11 23:33:46
[year] => 2010
[month] => 1
)
[16] => stdClass Object
(
[slug] => uncategorized
[ID] => 411
[post_name] => ya-vernulsya-podvedu-itogi-goda
[post_title] => Я вернулся... подведу итоги года :)
[post_date] => 2010-01-11 14:37:54
[year] => 2010
[month] => 1
)
[17] => stdClass Object
(
[slug] => uncategorized
[ID] => 402
[post_name] => kino
[post_title] => кино
[post_date] => 2009-12-24 23:21:33
[year] => 2009
[month] => 12
)
[18] => stdClass Object
(
[slug] => svadebnoe
[ID] => 398
[post_name] => svadba-alyony-i-vani
[post_title] => Свадьба Алёны и Вани
[post_date] => 2009-12-23 18:39:13
[year] => 2009
[month] => 12
)
[19] => stdClass Object
(
[slug] => love-story
[ID] => 395
[post_name] => love-story-alyony-i-vani
[post_title] => Love Story Алёны и Вани
[post_date] => 2009-12-16 00:12:24
[year] => 2009
[month] => 12
)
[20] => stdClass Object
(
[slug] => uncategorized
[ID] => 390
[post_name] => podruzhki
[post_title] => Подружки
[post_date] => 2009-12-06 21:15:37
[year] => 2009
[month] => 12
)
[21] => stdClass Object
(
[slug] => svadebnoe
[ID] => 374
[post_name] => svadba-nasti-i-vovy
[post_title] => Свадьба Насти и Вовы
[post_date] => 2009-11-29 19:15:26
[year] => 2009
[month] => 11
)
[22] => stdClass Object
(
[slug] => love-story
[ID] => 372
[post_name] => love-story-nasti-i-vovy
[post_title] => Love Story Насти и Вовы
[post_date] => 2009-11-26 20:08:46
[year] => 2009
[month] => 11
)
[23] => stdClass Object
(
[slug] => svadebnoe
[ID] => 369
[post_name] => svadba-ani-i-pavla
[post_title] => Свадьба Ани и Павла
[post_date] => 2009-11-25 22:46:07
[year] => 2009
[month] => 11
)
[24] => stdClass Object
(
[slug] => uncategorized
[ID] => 365
[post_name] => balet-ani
[post_title] => Балет Ани.
[post_date] => 2009-11-14 19:42:00
[year] => 2009
[month] => 11
)
[25] => stdClass Object
(
[slug] => uncategorized
[ID] => 353
[post_name] => fotoyumor
[post_title] => Фотоюмор
[post_date] => 2009-11-09 00:14:23
[year] => 2009
[month] => 11
)
[26] => stdClass Object
(
[slug] => svadebnoe
[ID] => 351
[post_name] => svadba-sergeya-i-anny
[post_title] => Свадьба Сергея и Анны
[post_date] => 2009-11-04 00:34:47
[year] => 2009
[month] => 11
)
[27] => stdClass Object
(
[slug] => uncategorized
[ID] => 346
[post_name] => master-klass-artyoma-zalomlenkova
[post_title] => Мастер Класс Артёма Заломленкова
[post_date] => 2009-10-27 15:51:30
[year] => 2009
[month] => 10
)
[28] => stdClass Object
(
[slug] => svadebnoe
[ID] => 342
[post_name] => svadba-iriny-i-danila
[post_title] => Свадьба Ирины и Данила
[post_date] => 2009-10-19 15:02:57
[year] => 2009
[month] => 10
)
[29] => stdClass Object
(
[slug] => svadebnoe
[ID] => 338
[post_name] => svadba-ani-i-antona-barnaul
[post_title] => Свадьба Ани и Антона (Барнаул)
[post_date] => 2009-10-17 17:43:56
[year] => 2009
[month] => 10
)
[30] => stdClass Object
(
[slug] => uncategorized
[ID] => 333
[post_name] => zakat-u-vody
[post_title] => Закат у воды.
[post_date] => 2009-09-20 11:59:27
[year] => 2009
[month] => 9
)
[31] => stdClass Object
(
[slug] => uncategorized
[ID] => 330
[post_name] => den-nevest-v-novosibirske-2009
[post_title] => День Невест в Новосибирске 2009
[post_date] => 2009-09-15 18:36:15
[year] => 2009
[month] => 9
)
[32] => stdClass Object
(
[slug] => love-story
[ID] => 323
[post_name] => love-story-lyuby-i-maksima
[post_title] => Love Story Любы и Максима
[post_date] => 2009-09-13 10:50:40
[year] => 2009
[month] => 9
)
[33] => stdClass Object
(
[slug] => obuchenie
[ID] => 319
[post_name] => obuchenie-fotografii-svadebnoj-fotografii
[post_title] => Обучение фотографии (свадебной фотографии)
[post_date] => 2009-09-08 22:13:59
[year] => 2009
[month] => 9
)
[34] => stdClass Object
(
[slug] => uncategorized
[ID] => 310
[post_name] => xorki
[post_title] => Хорьки :)
[post_date] => 2009-08-31 18:34:30
[year] => 2009
[month] => 8
)
[35] => stdClass Object
(
[slug] => uncategorized
[ID] => 285
[post_name] => trash-the-dress-yulya-i-lena
[post_title] => Trash The Dress Юля и Лена
[post_date] => 2009-08-18 16:32:50
[year] => 2009
[month] => 8
)
[36] => stdClass Object
(
[slug] => svadebnoe
[ID] => 282
[post_name] => svadba-iry-i-antona-chb
[post_title] => Свадьба Иры и Антона, ЧБ.
[post_date] => 2009-08-17 17:15:10
[year] => 2009
[month] => 8
)
[37] => stdClass Object
(
[slug] => love-story
[ID] => 277
[post_name] => love-story-taty-i-sashi-zimnyaya
[post_title] => Love Story Таты и Саши... зимняя.
[post_date] => 2009-08-12 22:52:21
[year] => 2009
[month] => 8
)
[38] => stdClass Object
(
[slug] => uncategorized
[ID] => 273
[post_name] => da-budet-svet
[post_title] => Да будет свет...
[post_date] => 2009-07-22 15:18:21
[year] => 2009
[month] => 7
)
[39] => stdClass Object
(
[slug] => svadebnoe
[ID] => 264
[post_name] => svadba-yany-i-vitaliya
[post_title] => Свадьба Яны и Виталия
[post_date] => 2009-06-23 13:04:13
[year] => 2009
[month] => 6
)
[40] => stdClass Object
(
[slug] => uncategorized
[ID] => 261
[post_name] => panorama
[post_title] => Панорама
[post_date] => 2009-06-15 23:24:09
[year] => 2009
[month] => 6
)
[41] => stdClass Object
(
[slug] => love-story
[ID] => 256
[post_name] => gornyjchemallove-story
[post_title] => Горный..Чемал..Love Story
[post_date] => 2009-06-14 22:40:28
[year] => 2009
[month] => 6
)
[42] => stdClass Object
(
[slug] => uncategorized
[ID] => 251
[post_name] => priexal-na-balet
[post_title] => Приехал.. на балет
[post_date] => 2009-06-08 20:49:28
[year] => 2009
[month] => 6
)
[43] => stdClass Object
(
[slug] => uncategorized
[ID] => 247
[post_name] => svadebnyj-rok-n-rolik
[post_title] => Свадебный рок-н-ролик
[post_date] => 2009-06-03 22:01:27
[year] => 2009
[month] => 6
)
[44] => stdClass Object
(
[slug] => uncategorized
[ID] => 243
[post_name] => s-dnyom-rozhdeniya-svadbinsk
[post_title] => С Днём Рождения, Свадьбинск!
[post_date] => 2009-05-31 19:30:09
[year] => 2009
[month] => 5
)
[45] => stdClass Object
(
[slug] => love-story
[ID] => 237
[post_name] => priexal-domoj
[post_title] => Приехал домой...
[post_date] => 2009-05-17 14:39:02
[year] => 2009
[month] => 5
)
[46] => stdClass Object
(
[slug] => love-story
[ID] => 232
[post_name] => love-story-dany-i-vovy-solnechnaya
[post_title] => Love Story Даны и Вовы... Солнечная..
[post_date] => 2009-05-01 14:13:33
[year] => 2009
[month] => 5
)
[47] => stdClass Object
(
[slug] => uncategorized
[ID] => 229
[post_name] => tyazhela-zhizn-studenta
[post_title] => Тяжела жизнь студента
[post_date] => 2009-04-28 22:16:03
[year] => 2009
[month] => 4
)
[48] => stdClass Object
(
[slug] => uncategorized
[ID] => 226
[post_name] => privet-asfo
[post_title] => Привет АСФО
[post_date] => 2009-04-28 21:20:50
[year] => 2009
[month] => 4
)
[49] => stdClass Object
(
[slug] => uncategorized
[ID] => 222
[post_name] => kollekciya-svadebnyj-buketov-zima-vesna-2009-galiny-pinyasovoj
[post_title] => Коллекция свадебных букетов «Зима-Весна 2009» Галины Пинясовой
[post_date] => 2009-04-13 12:58:16
[year] => 2009
[month] => 4
)
[50] => stdClass Object
(
[slug] => svadebnoe
[ID] => 217
[post_name] => svadba-iry-i-pashi-v-den-vsex-vlyublennyx
[post_title] => Свадьба Иры и Паши в День Всех Влюбленных
[post_date] => 2009-04-06 17:01:51
[year] => 2009
[month] => 4
)
[51] => stdClass Object
(
[slug] => uncategorized
[ID] => 209
[post_name] => u-moej-zheny-poyavilsya-sajt-wwwmnikolaevaru
[post_title] => У моей жены появился сайт !!! www.mnikolaeva.ru
[post_date] => 2009-03-17 22:22:24
[year] => 2009
[month] => 3
)
[52] => stdClass Object
(
[slug] => uncategorized
[ID] => 202
[post_name] => httphelp-angelinamy1ru-spasite-zhizn-rebenka
[post_title] => http://help-angelina.my1.ru/ спасите жизнь ребенка!!.
[post_date] => 2009-03-13 17:01:24
[year] => 2009
[month] => 3
)
[53] => stdClass Object
(
[slug] => uncategorized
[ID] => 197
[post_name] => love-story-sova
[post_title] => Love Story... Сова?
[post_date] => 2009-03-09 22:46:35
[year] => 2009
[month] => 3
)
[54] => stdClass Object
(
[slug] => love-story
[ID] => 193
[post_name] => love-story-iriny-i-pavla
[post_title] => Love Story Ирины и Павла
[post_date] => 2009-03-09 10:38:21
[year] => 2009
[month] => 3
)
[55] => stdClass Object
(
[slug] => uncategorized
[ID] => 186
[post_name] => s-8-marta
[post_title] => С 8 Марта!!!
[post_date] => 2009-03-08 00:00:48
[year] => 2009
[month] => 3
)
[56] => stdClass Object
(
[slug] => uncategorized
[ID] => 154
[post_name] => master-klass-alekseya-vinokurova
[post_title] => Мастер класс Алексея Винокурова
[post_date] => 2009-02-24 13:01:03
[year] => 2009
[month] => 2
)
[57] => stdClass Object
(
[slug] => uncategorized
[ID] => 147
[post_name] => vsegda-govori-da
[post_title] => Всегда говори ДА
[post_date] => 2009-02-23 17:44:09
[year] => 2009
[month] => 2
)
[58] => stdClass Object
(
[slug] => uncategorized
[ID] => 142
[post_name] => gde-my-zhivem
[post_title] => Где Мы живем?
[post_date] => 2009-02-19 22:17:06
[year] => 2009
[month] => 2
)
[59] => stdClass Object
(
[slug] => uncategorized
[ID] => 132
[post_name] => moya-zhena-doma-studiya
[post_title] => Моя Жена... Дома... Студия? :)
[post_date] => 2009-02-18 21:28:29
[year] => 2009
[month] => 2
)
[60] => stdClass Object
(
[slug] => uncategorized
[ID] => 128
[post_name] => 7-zhiznej
[post_title] => 7 жизней.
[post_date] => 2009-02-17 17:11:08
[year] => 2009
[month] => 2
)
[61] => stdClass Object
(
[slug] => love-story
[ID] => 121
[post_name] => love-story-natashi-sashi-i-lajmy
[post_title] => Love Story Таты, Саши и Лаймы... :)
[post_date] => 2009-02-06 10:19:33
[year] => 2009
[month] => 2
)
[62] => stdClass Object
(
[slug] => uncategorized
[ID] => 119
[post_name] => snchp-xorosho-ili-ploxo
[post_title] => СНЧП хорошо или плохо?
[post_date] => 2009-02-05 22:40:58
[year] => 2009
[month] => 2
)
[63] => stdClass Object
(
[slug] => love-story
[ID] => 109
[post_name] => love-story-osennee-leny-i-yury
[post_title] => Love Story Осеннее Лены и Юры
[post_date] => 2009-01-28 18:11:15
[year] => 2009
[month] => 1
)
[64] => stdClass Object
(
[slug] => love-story
[ID] => 103
[post_name] => konkurs-v-barnaule
[post_title] => Конкурс в Барнауле!
[post_date] => 2009-01-24 22:13:12
[year] => 2009
[month] => 1
)
[65] => stdClass Object
(
[slug] => love-story
[ID] => 92
[post_name] => kak-snimayut-to
[post_title] => Как снимают то!
[post_date] => 2009-01-19 19:05:19
[year] => 2009
[month] => 1
)
[66] => stdClass Object
(
[slug] => uncategorized
[ID] => 89
[post_name] => dom-rebenka-2
[post_title] => Дом Ребенка №2
[post_date] => 2009-01-13 21:08:51
[year] => 2009
[month] => 1
)
[67] => stdClass Object
(
[slug] => uncategorized
[ID] => 68
[post_name] => otkrytie-bloga
[post_title] => Открытие Блога
[post_date] => 2009-01-01 12:00:29
[year] => 2009
[month] => 1
)
)
RSS