Pulling attachments from specific post categories

Do you need pagination with this or do just want to show 18 random image attachments from posts from a specific category? I don’t think this can be done with a (one) query.

I changed the solution from this topic to show a random attachment from 18 posts (with an attachement) from a specific category: http://wordpress.org/support/topic/exclude-posts-without-attachments-from-query

Try it with this:

<?php
	$category_ID = 25;

	global $wpdb;

	// get the first 18 posts with an attachment from the database
	$posts = $wpdb->get_results("
	  SELECT *
	  FROM $wpdb->posts
	  LEFT JOIN $wpdb->term_relationships ON ($wpdb->posts.ID = $wpdb->term_relationships.object_id)
	  LEFT JOIN $wpdb->term_taxonomy ON ($wpdb->term_relationships.term_taxonomy_id = $wpdb->term_taxonomy.term_taxonomy_id)
	  WHERE post_status = 'publish'
	  AND ID IN (
	    SELECT DISTINCT post_parent
	    FROM $wpdb->posts
	    WHERE post_parent > 0
	    AND post_type = 'attachment'
	    AND post_mime_type IN ('image/jpeg', 'image/png')
	  )
	  AND $wpdb->term_taxonomy.taxonomy = 'category'
	  AND $wpdb->term_taxonomy.term_id = '" . $category_ID . "'
	  ORDER BY RAND() LIMIT 0,18
	");

	if($posts){
		foreach($posts as $post) {
			setup_postdata($post);
			$images = get_children(array(
			  'post_parent' => $post->ID,
			  'post_type' => 'attachment',
			  'post_mime_type' => 'image',
			  'orderby' => 'rand'
			));

			if(!empty($images)){
				$ids = array_keys($images);
				// link attachement to post
				echo '<a href="' . get_permalink($post->ID) . '" >' . wp_get_attachment_image($ids[0], 'thumbnail') . '</a>';
			}
		}
	}
?>

Change $category_ID = 25; to the correct category ID;

I’m not sure why that is happening. Try it with this: http://pastebin.com/CqHVXLic

If that doesn’t help can you paste and submit the full code of the template file you’re using into a pastebin.com and post the link to it here? see the Forum Rules for posting code and using the pastebin.

No problem. I’m glad you got it resolved 🙂