Archivio

MySQL server version: 5.0.51a-24+lenny2+spu1
collapsArch options:
Array
(
    [title] => Archivio
    [noTitle] =>
    [inExcludeCat] =>
    [inExcludeCats] =>
    [inExcludeYear] =>
    [inExcludeYears] =>
    [showPages] =>
    [sort] => DESC
    [linkToArch] => 1
    [showYearCount] => 1
    [expandCurrentYear] =>
    [expandMonths] =>
    [expandYears] => 1
    [expandCurrentMonth] =>
    [showMonthCount] => 1
    [showPostTitle] => 1
    [expand] => 2
    [showPostDate] =>
    [debug] => 1
    [postDateFormat] => m/d
    [postDateAppend] => after
    [animate] => 1
    [postTitleLength] =>
    [showPostCount] => 1
    [archSortOrder] => DESC
    [showPosts] =>
    [customExpand] =>
    [customCollapse] =>
    [number] => 3
)
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'
    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] => rete-together
            [ID] => 657
            [post_name] => mondiali-antirazzisti-2010-casalecchio-di-reno-bologna
            [post_title] => Mondiali Antirazzisti 2010 - Casalecchio di Reno (Bologna)
            [post_author] => 1
            [post_date] => 2010-07-08 18:56:48
            [year] => 2010
            [month] => 7
        )
    [1] => stdClass Object
        (
            [slug] => rete-together
            [ID] => 648
            [post_name] => nuovi-italiani-dalla-zuanna-farina-strozza
            [post_title] => Nuovi Italiani - Dalla Zuanna, Farina, Strozza
            [post_author] => 3
            [post_date] => 2010-07-01 20:07:01
            [year] => 2010
            [month] => 7
        )
    [2] => stdClass Object
        (
            [slug] => rete-together
            [ID] => 631
            [post_name] => molteplicitta-incontri-dibatti-e-spettacoli-sulla-citta-che-cambia
            [post_title] => Molteplicitta' - Incontri, dibatti e spettacoli sulla citta' che cambia
            [post_author] => 1
            [post_date] => 2010-06-29 10:35:54
            [year] => 2010
            [month] => 6
        )
    [3] => stdClass Object
        (
            [slug] => rete-together
            [ID] => 624
            [post_name] => sms-45503-1-goal-per%ef%bb%bf-lafrica
            [post_title] => SMS 45503 - 1 Goal per l'Africa
            [post_author] => 1
            [post_date] => 2010-06-21 10:54:00
            [year] => 2010
            [month] => 6
        )
    [4] => stdClass Object
        (
            [slug] => rete-together
            [ID] => 608
            [post_name] => anche-la-svizzera-e-multietnica
            [post_title] => Anche la Svizzera e' multietnica!
            [post_author] => 3
            [post_date] => 2010-06-16 18:03:56
            [year] => 2010
            [month] => 6
        )
    [5] => stdClass Object
        (
            [slug] => rete-together
            [ID] => 585
            [post_name] => lippi-loda-corea-del-sud-e-giappone-e-la-cina
            [post_title] => Lippi loda Corea del Sud e Giappone. E la Cina?
            [post_author] => 3
            [post_date] => 2010-06-15 17:10:02
            [year] => 2010
            [month] => 6
        )
    [6] => stdClass Object
        (
            [slug] => rete-together
            [ID] => 576
            [post_name] => festa-pachanka-2010-monzuno-bo-19-giugno-2010
            [post_title] => Festa Pachanka 2010 - Monzuno (BO) 19 Giugno 2010
            [post_author] => 1
            [post_date] => 2010-06-15 15:10:57
            [year] => 2010
            [month] => 6
        )
    [7] => stdClass Object
        (
            [slug] => rete-together
            [ID] => 557
            [post_name] => 167-contatto-reggio-emilia-dall8-al-13-giugno-2010
            [post_title] => 1,6,7 Contatto! - Reggio Emilia - dall'8 al 13 Giugno 2010
            [post_author] => 1
            [post_date] => 2010-06-09 11:30:13
            [year] => 2010
            [month] => 6
        )
    [8] => stdClass Object
        (
            [slug] => rete-together
            [ID] => 548
            [post_name] => noi-figli-dellimmigrazione-cittadini-italiani-di-serie-b
            [post_title] => Noi Figli dell'Immigrazione: Cittadini Italiani di Serie B?
            [post_author] => 1
            [post_date] => 2010-06-07 10:20:12
            [year] => 2010
            [month] => 6
        )
    [9] => stdClass Object
        (
            [slug] => blog
            [ID] => 527
            [post_name] => non-ci-sono-seconde-generazioni-in-tv-balle
            [post_title] => Non ci sono seconde generazioni in tv? Balle!
            [post_author] => 3
            [post_date] => 2010-06-04 07:14:56
            [year] => 2010
            [month] => 6
        )
    [10] => stdClass Object
        (
            [slug] => rete-together
            [ID] => 507
            [post_name] => i-love-islam-di-patrizia-finucci-gallo
            [post_title] => "I Love Islam" di Patrizia Finucci Gallo
            [post_author] => 2
            [post_date] => 2010-06-02 16:16:05
            [year] => 2010
            [month] => 6
        )
    [11] => stdClass Object
        (
            [slug] => blog
            [ID] => 480
            [post_name] => ad-interazioni-together-non-parla-di-gaza-perche
            [post_title] => Ad Interazioni TogethER non parla di Gaza. Perche'?
            [post_author] => 3
            [post_date] => 2010-06-01 18:35:28
            [year] => 2010
            [month] => 6
        )
    [12] => stdClass Object
        (
            [slug] => rete-together
            [ID] => 472
            [post_name] => together-al-iv-festival-delle-culture-ravenna
            [post_title] => TogethER al IV Festival delle Culture - Ravenna
            [post_author] => 1
            [post_date] => 2010-06-01 13:01:07
            [year] => 2010
            [month] => 6
        )
    [13] => stdClass Object
        (
            [slug] => rete-together
            [ID] => 460
            [post_name] => pericolo-banlieue
            [post_title] => Pericolo banlieue
            [post_author] => 4
            [post_date] => 2010-05-26 17:05:08
            [year] => 2010
            [month] => 5
        )
    [14] => stdClass Object
        (
            [slug] => rete-together
            [ID] => 450
            [post_name] => interazioni-2010-rimini-gemmano
            [post_title] => Interazioni 2010, Rimini - Gemmano
            [post_author] => 1
            [post_date] => 2010-05-25 11:37:28
            [year] => 2010
            [month] => 5
        )
    [15] => stdClass Object
        (
            [slug] => video
            [ID] => 444
            [post_name] => mixa-diventa-free-press
            [post_title] => Mixa diventa Free Press
            [post_author] => 1
            [post_date] => 2010-05-24 19:56:16
            [year] => 2010
            [month] => 5
        )
    [16] => stdClass Object
        (
            [slug] => attualita
            [ID] => 429
            [post_name] => bozza-proposta-di-legge-sul-permesso-di-soggiorno-a-punti
            [post_title] => Bozza Proposta di Legge sul Permesso di Soggiorno a Punti
            [post_author] => 3
            [post_date] => 2010-05-19 17:23:14
            [year] => 2010
            [month] => 5
        )
    [17] => stdClass Object
        (
            [slug] => rete-together
            [ID] => 417
            [post_name] => iomla-festival-interculture-imola-28-29-30-maggio
            [post_title] => Iòmla festival Interculture (Imola) 28-29-30 maggio
            [post_author] => 8
            [post_date] => 2010-05-17 13:11:10
            [year] => 2010
            [month] => 5
        )
    [18] => stdClass Object
        (
            [slug] => rete-together
            [ID] => 412
            [post_name] => immigrazione-citizen-report
            [post_title] => Immigrazione – Citizen Report
            [post_author] => 1
            [post_date] => 2010-05-17 13:01:14
            [year] => 2010
            [month] => 5
        )
    [19] => stdClass Object
        (
            [slug] => rete-together
            [ID] => 396
            [post_name] => religione-2-0-citizen-report
            [post_title] => Religione 2.0 - Citizen Report
            [post_author] => 3
            [post_date] => 2010-05-13 14:39:51
            [year] => 2010
            [month] => 5
        )
    [20] => stdClass Object
        (
            [slug] => rete-together
            [ID] => 385
            [post_name] => in-risposta-al-sindaco-di-milano-clandestino-delinquente
            [post_title] => In risposta al Sindaco di Milano - Clandestino = Delinquente
            [post_author] => 3
            [post_date] => 2010-05-12 12:15:19
            [year] => 2010
            [month] => 5
        )
    [21] => stdClass Object
        (
            [slug] => rete-together
            [ID] => 365
            [post_name] => ustation-a-napoli-internet-for-peace
            [post_title] => Ustation a Napoli - Internet for Peace!
            [post_author] => 3
            [post_date] => 2010-05-11 00:10:51
            [year] => 2010
            [month] => 5
        )
    [22] => stdClass Object
        (
            [slug] => rete-together
            [ID] => 345
            [post_name] => ma-lo-sai-di-essere-diverso
            [post_title] => Ma lo sai di essere "diverso"???
            [post_author] => 5
            [post_date] => 2010-05-06 16:46:41
            [year] => 2010
            [month] => 5
        )
    [23] => stdClass Object
        (
            [slug] => rete-together
            [ID] => 337
            [post_name] => solo-andata
            [post_title] => Sola andata
            [post_author] => 4
            [post_date] => 2010-05-04 12:13:24
            [year] => 2010
            [month] => 5
        )
    [24] => stdClass Object
        (
            [slug] => rete-together
            [ID] => 314
            [post_name] => l-essere-giovane-in-una-societa-non-giovane
            [post_title] => L'essere giovane in una societa' non giovane
            [post_author] => 1
            [post_date] => 2010-04-29 19:36:13
            [year] => 2010
            [month] => 4
        )
    [25] => stdClass Object
        (
            [slug] => rete-together
            [ID] => 304
            [post_name] => together-su-icaro-tv-rimini
            [post_title] => TogethER su Icaro Tv - Rimini
            [post_author] => 1
            [post_date] => 2010-04-27 18:58:30
            [year] => 2010
            [month] => 4
        )
    [26] => stdClass Object
        (
            [slug] => rete-together
            [ID] => 287
            [post_name] => together-working-at-urban-center-of-bologna
            [post_title] => TogethER working at Urban Center of Bologna!
            [post_author] => 1
            [post_date] => 2010-04-24 10:20:22
            [year] => 2010
            [month] => 4
        )
    [27] => stdClass Object
        (
            [slug] => rete-together
            [ID] => 241
            [post_name] => yassine-lafram-ad-annozero
            [post_title] => Yassine Lafram ad Annozero
            [post_author] => 1
            [post_date] => 2010-04-23 11:52:34
            [year] => 2010
            [month] => 4
        )
    [28] => stdClass Object
        (
            [slug] => rete-together
            [ID] => 209
            [post_name] => sabato-24-aprile-2010-siamo-in-sala-borsa-a-bologna
            [post_title] => Sabato 24 Aprile 2010 siamo in Sala Borsa a Bologna!
            [post_author] => 1
            [post_date] => 2010-04-21 10:47:12
            [year] => 2010
            [month] => 4
        )
    [29] => stdClass Object
        (
            [slug] => rete-together
            [ID] => 187
            [post_name] => sono-un-italiano-nero
            [post_title] => Sono un italiano nero
            [post_author] => 1
            [post_date] => 2010-04-19 14:31:48
            [year] => 2010
            [month] => 4
        )
    [30] => stdClass Object
        (
            [slug] => rete-together
            [ID] => 174
            [post_name] => convegno-occhio-ai-media-ferrara-16-17-aprile-2010
            [post_title] => Convegno Occhio ai Media - Ferrara 16-17 Aprile 2010
            [post_author] => 1
            [post_date] => 2010-04-14 10:43:12
            [year] => 2010
            [month] => 4
        )
    [31] => stdClass Object
        (
            [slug] => video
            [ID] => 157
            [post_name] => senza-cure
            [post_title] => Senza cure
            [post_author] => 3
            [post_date] => 2010-04-12 20:06:11
            [year] => 2010
            [month] => 4
        )
    [32] => stdClass Object
        (
            [slug] => rete-together
            [ID] => 136
            [post_name] => together-giovani-cervelli-in-rete-citta-meticcia
            [post_title] => TogethER: giovani cervelli in rete - Citta' Meticcia
            [post_author] => 3
            [post_date] => 2010-04-12 14:31:02
            [year] => 2010
            [month] => 4
        )
    [33] => stdClass Object
        (
            [slug] => rete-together
            [ID] => 111
            [post_name] => gli-asili-di-bologna-sono-un-bene-prezioso
            [post_title] => Gli asili di Bologna sono un bene prezioso...
            [post_author] => 3
            [post_date] => 2010-04-08 17:19:43
            [year] => 2010
            [month] => 4
        )
    [34] => stdClass Object
        (
            [slug] => rete-together
            [ID] => 81
            [post_name] => vorrei-poter-esprimere-un-voto
            [post_title] => Vorrei poter esprimere un voto
            [post_author] => 4
            [post_date] => 2010-03-27 20:52:40
            [year] => 2010
            [month] => 3
        )
    [35] => stdClass Object
        (
            [slug] => rete-together
            [ID] => 52
            [post_name] => concorso-video-nuovi-italiani-storie-di-ordinaria-integrazione
            [post_title] => Concorso Video "NUOVI ITALIANI: Storie di ordinaria integrazione"
            [post_author] => 2
            [post_date] => 2010-03-24 12:46:48
            [year] => 2010
            [month] => 3
        )
    [36] => stdClass Object
        (
            [slug] => rete-together
            [ID] => 3
            [post_name] => il-nostro-sito-web-e-nato
            [post_title] => Il nostro sito web è nato!
            [post_author] => 1
            [post_date] => 2010-03-20 18:36:01
            [year] => 2010
            [month] => 3
        )
)

• [+]2010 (37)
  • luglio (2)
  • giugno (11)
  • maggio (11)
  • aprile (10)
  • marzo (3)