Mesures-Eliosys

15/02/2018
By andreas
Archives

collapsArch options:
Array
(
    [title] => Archives
    [noTitle] => 
    [inExcludeCat] => exclude
    [inExcludeCats] => news,news-nl,news-de,news-it,news-en,news-ru
    [inExcludeYear] => exclude
    [inExcludeYears] => 
    [showPages] => 
    [sort] => DESC
    [linkToArch] => 
    [showYearCount] => 
    [expandCurrentYear] => 1
    [expandMonths] => 
    [expandYears] => 1
    [expandCurrentMonth] => 1
    [showMonthCount] => 
    [showPostTitle] => 
    [expand] => 4
    [showPostDate] => 
    [debug] => 1
    [postDateFormat] => m/d
    [postDateAppend] => after
    [accordion] => 0
    [useCookies] => 1
    [post_type] => post
    [taxoncmy] => category
    [postTitleLength] => 
    [showPostCount] => 
    [style] => custom
    [archSortOrder] => DESC
    [showPosts] => 
    [customExpand] => 
    [customCollapse] => 
    [taxonomy] => both
    [number] => 2
)
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' ,
    wp_posts.post_type
    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_status='publish' AND wp_posts.post_type='post'  AND wp_terms.slug NOT IN ('news', 'news-nl' , 'news-de' , 'news-it' , 'news-en' , 'news-ru' ) 
  GROUP BY wp_posts.ID 
  ORDER BY wp_posts.post_date DESC

POST QUERY RESULTS
Array
(
    [0] => stdClass Object
        (
            [slug] => blog
            [ID] => 5825
            [post_name] => lisolation-dune-toiture-par-linterieur-sans-membrane-sous-toiture-est-possible-avec-aluthermo-optima
            [post_title] => L‘isolation d’une toiture par l’intérieur sans membrane sous toiture est possible avec Aluthermo Optima :
            [post_author] => 4
            [post_date] => 2017-06-29 09:26:07
            [year] => 2017
            [month] => 6
            [post_type] => post
        )

    [1] => stdClass Object
        (
            [slug] => blog-nl
            [ID] => 5830
            [post_name] => de-dakisolatie-van-binnen-zonder-een-onderdak-is-mogelijk-met-aluthermo-optima
            [post_title] => De dakisolatie van binnen zonder een onderdak is mogelijk met Aluthermo Optima
            [post_author] => 4
            [post_date] => 2017-06-29 09:26:07
            [year] => 2017
            [month] => 6
            [post_type] => post
        )

    [2] => stdClass Object
        (
            [slug] => blog-en
            [ID] => 5831
            [post_name] => roof-insulation-from-the-inside-without-breather-membrane-is-possible-with-aluthermo-optima
            [post_title] => Roof insulation from the inside without breather membrane is possible with Aluthermo Optima
            [post_author] => 4
            [post_date] => 2017-06-29 09:26:07
            [year] => 2017
            [month] => 6
            [post_type] => post
        )

    [3] => stdClass Object
        (
            [slug] => blog-de
            [ID] => 5832
            [post_name] => die-daemmung-des-daches-von-innen-ohne-unterspannbahn-ist-moeglich-mit-aluthermo-optima
            [post_title] => Die Dämmung des Daches von innen ohne Unterspannbahn ist möglich mit Aluthermo Optima
            [post_author] => 4
            [post_date] => 2017-06-29 09:26:07
            [year] => 2017
            [month] => 6
            [post_type] => post
        )

)
2017
- June