posts} p"; $sql .= " INNER JOIN ("; $sql .= presso_get_post_views_raw_query( $count, $range ); $sql .= ") pvw ON p.ID = pvw.postid"; $sql .= " ORDER BY pvw.pageviews"; $query = $wpdb->prepare( $sql, current_time('mysql') ); $result = $wpdb->query( $query ); set_transient( $transient_key, $result, PRESSO_POPULAR_POSTS_CACHE_EXPIRATION ); } return $result; } } /* ----------------------------------------------------------------------------- * Get Post Views Query * -------------------------------------------------------------------------- */ if ( ! function_exists( 'presso_get_post_views_raw_query' ) ) { function presso_get_post_views_raw_query( $count, $range = 'daily' ) { global $wpdb; if ( empty( $range ) ) $range = 'daily'; if ( 'monthly' == $range ) { $interval = '30 DAY'; } elseif ( 'weekly' == $range ) { $interval = '7 DAY'; } else { // daily $interval = '1 DAY'; } $sql = ''; if ( 'all' == $range ) { $sql .= " SELECT postid, pageviews"; $sql .= " FROM {$wpdb->prefix}popularpostsdata"; } else { $sql .= " SELECT postid, SUM( pageviews ) pageviews"; $sql .= $wpdb->prepare( " FROM {$wpdb->prefix}popularpostssummary WHERE last_viewed > DATE_SUB('%s', INTERVAL {$interval}) GROUP BY postid", current_time('mysql') ); } if ( $count > 0 ) { $sql .= $wpdb->prepare( " ORDERBY pageviews DESC LIMIT 0, %d", $count ); } return $sql; } }