Welcome, visitor! Log in
 

Source View: getarchives_join

To save our bandwidth, we show only a snippet of code around each occurence of the hook. View complete file in SVN (without highlighting).

Understanding Source Code

The best way to understand what a hook does is to look at where it occurs in the source code.

  • Action hooks look like this: do_action( "hook_name" )
  • Filter hooks look like this: apply_filters( "hook_name", "what_to_filter" ).

Remember, this hook may occur in more than one file. Moreover, the hook's context may change from version to version.

Source View

Line Code
896
897      if ( !$archive_date_format_over_ride ) {
898           $archive_day_date_format = get_option('date_format');
899           $archive_week_start_date_format = get_option('date_format');
900           $archive_week_end_date_format = get_option('date_format');
901      }
902
903      //filters
904      $where = apply_filters('getarchives_where', "WHERE post_type = 'post' AND post_status = 'publish'", $r );
905      $join = apply_filters('getarchives_join', "", $r);
906
907      $output = '';
908
909      if ( 'monthly' == $type ) {
910           $query = "SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM $wpdb->posts $join $where GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC $limit";
911           $key = md5($query);
912           $cache = wp_cache_get( 'wp_get_archives' , 'general');
913           if ( !isset( $cache[ $key ] ) ) {
914                $arcresults = $wpdb->get_results($query);