techstar

mysql> explain SELECT SQL_CALC_FOUND_ROWS  wp_posts.* FROM wp_posts  JOIN wp_postmeta ON (wp_posts.ID = wp_postmeta.post_id)  WHERE 1=1  AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') AND wp_postmeta.meta_key = 'Thumbnail-150x75'  GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 5\G
*************************** 1. row ***************************
           id: 1
  select_type: SIMPLE
        table: wp_posts
         type: ref
possible_keys: PRIMARY,type_status_date
          key: type_status_date
      key_len: 124
          ref: const,const
         rows: 21058
        Extra: Using where; Using temporary; Using filesort
*************************** 2. row ***************************
           id: 1
  select_type: SIMPLE
        table: wp_postmeta
         type: ref
possible_keys: post_id,meta_key,meta_post_id
          key: post_id
      key_len: 8
          ref: mm.wp_posts.ID
         rows: 1
        Extra: Using where
2 rows in set (0.00 sec)

Using temporary; Using filesort is the bad part

I want to use this:

mysql> explain SELECT wp_posts.* FROM wp_posts  JOIN wp_postmeta ON (wp_posts.ID = wp_postmeta.post_id)  WHERE 1=1  AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') AND wp_postmeta.meta_key = 'Thumbnail-150x75' ORDER BY wp_posts.post_date DESC LIMIT 0, 5\G
*************************** 1. row ***************************
           id: 1
  select_type: SIMPLE
        table: wp_posts
         type: ref
possible_keys: PRIMARY,type_status_date
          key: type_status_date
      key_len: 124
          ref: const,const
         rows: 21058
        Extra: Using where
*************************** 2. row ***************************
           id: 1
  select_type: SIMPLE
        table: wp_postmeta
         type: ref
possible_keys: post_id,meta_key,meta_post_id
          key: post_id
      key_len: 8
          ref: mm.wp_posts.ID
         rows: 1
        Extra: Using where
2 rows in set (0.00 sec)

Latest version.

Turning anything off should not be a solution, but thanks for the tip. This software shouldn’t need to access the database so frequently, seems like a bad use of db table access to me, or we are just screwed in the beginning without innodb support on full text tables?

Uhoh.. where is the dev team at these hours of the day? :>

Darn, the avatar doesnt pull the users custom photo, it just selects a random avatar…

This is the weirdest thing ever.

<?php
global $post;
$userid = $post->post_author;
$user_total_post = get_usernumposts($userid);
$user_array = get_userdata($userid);

$userinfo = $user_array->user_login . "<br />Total Articles: $user_total_post<br />Bio: ";

$user_email = get_usermeta( $userid, 'user_email');
$description = get_usermeta( $userid, 'description');

$userinfo  .= "$description";
$userinfo  .= get_avatar($user_email, $size, $default, $alt );

echo $userinfo;
?>

That’s my code, but user_login is not the same as Display Name so it’s not really the same.

How can I move the avatar to the top with a right alignment so the_author name, bio and post count appear on the side of the avatar?

This really confusing, there are no docs on how this works in the code?

hmm i see. It works but it shows the author ID # not the name.

<?php
global $post;
echo $post->post_author;
?>

This is not the case when trying to identify the Media ID of images within the gallery. The only way is to insert the image into your post, then find the ID within the CSS tag…