Support

Account

Home Forums Add-ons Gallery Field “Reverse Lookup” via Attachment Custom Field Reply To: “Reverse Lookup” via Attachment Custom Field

  • Man, still a no-go. Here’s what I have now:

      $args = array(
          'fields' => 'ids',
          'posts_per_page'    => 1, 
          'post_type'      => 'post',
          'post_status' => 'any',
          'meta_query'    => array(
        		array(
        			'key'	 	=> 'image_meta_image_id',
        			'value'	  	=> $image_meta_image_id
        		)
        	)
      );
      $attachment_query = new WP_Query( $args );
      $attachments = $attachment_query->posts();
    

    var_dump( $attachments ); gets me bool(false), but I see it in PMA (attached).

    PMA Screen Shot

    var_dump( $attachment_query ) is below.

    Appreciate any other ideas you might have. Thanks so much!

    
    object(WP_Query)#3567 (52) {
      ["query"]=>
      array(5) {
        ["fields"]=>
        string(3) "ids"
        ["posts_per_page"]=>
        int(1)
        ["post_type"]=>
        string(4) "post"
        ["post_status"]=>
        string(3) "any"
        ["meta_query"]=>
        array(1) {
          [0]=>
          array(2) {
            ["key"]=>
            string(19) "image_meta_image_id"
            ["value"]=>
            string(5) "16233"
          }
        }
      }
      ["query_vars"]=>
      array(67) {
        ["fields"]=>
        string(3) "ids"
        ["posts_per_page"]=>
        int(1)
        ["post_type"]=>
        string(4) "post"
        ["post_status"]=>
        string(3) "any"
        ["meta_query"]=>
        array(1) {
          [0]=>
          array(2) {
            ["key"]=>
            string(19) "image_meta_image_id"
            ["value"]=>
            string(5) "16233"
          }
        }
        ["error"]=>
        string(0) ""
        ["m"]=>
        string(0) ""
        ["p"]=>
        int(0)
        ["post_parent"]=>
        string(0) ""
        ["subpost"]=>
        string(0) ""
        ["subpost_id"]=>
        string(0) ""
        ["attachment"]=>
        string(0) ""
        ["attachment_id"]=>
        int(0)
        ["name"]=>
        string(0) ""
        ["pagename"]=>
        string(0) ""
        ["page_id"]=>
        int(0)
        ["second"]=>
        string(0) ""
        ["minute"]=>
        string(0) ""
        ["hour"]=>
        string(0) ""
        ["day"]=>
        int(0)
        ["monthnum"]=>
        int(0)
        ["year"]=>
        int(0)
        ["w"]=>
        int(0)
        ["category_name"]=>
        string(0) ""
        ["tag"]=>
        string(0) ""
        ["cat"]=>
        string(0) ""
        ["tag_id"]=>
        string(0) ""
        ["author"]=>
        string(0) ""
        ["author_name"]=>
        string(0) ""
        ["feed"]=>
        string(0) ""
        ["tb"]=>
        string(0) ""
        ["paged"]=>
        int(0)
        ["meta_key"]=>
        string(0) ""
        ["meta_value"]=>
        string(0) ""
        ["preview"]=>
        string(0) ""
        ["s"]=>
        string(0) ""
        ["sentence"]=>
        string(0) ""
        ["title"]=>
        string(0) ""
        ["menu_order"]=>
        string(0) ""
        ["embed"]=>
        string(0) ""
        ["category__in"]=>
        array(0) {
        }
        ["category__not_in"]=>
        array(0) {
        }
        ["category__and"]=>
        array(0) {
        }
        ["post__in"]=>
        array(0) {
        }
        ["post__not_in"]=>
        array(0) {
        }
        ["post_name__in"]=>
        array(0) {
        }
        ["tag__in"]=>
        array(0) {
        }
        ["tag__not_in"]=>
        array(0) {
        }
        ["tag__and"]=>
        array(0) {
        }
        ["tag_slug__in"]=>
        array(0) {
        }
        ["tag_slug__and"]=>
        array(0) {
        }
        ["post_parent__in"]=>
        array(0) {
        }
        ["post_parent__not_in"]=>
        array(0) {
        }
        ["author__in"]=>
        array(0) {
        }
        ["author__not_in"]=>
        array(0) {
        }
        ["search_columns"]=>
        array(0) {
        }
        ["ignore_sticky_posts"]=>
        bool(false)
        ["suppress_filters"]=>
        bool(false)
        ["cache_results"]=>
        bool(true)
        ["update_post_term_cache"]=>
        bool(true)
        ["update_menu_item_cache"]=>
        bool(false)
        ["lazy_load_term_meta"]=>
        bool(true)
        ["update_post_meta_cache"]=>
        bool(true)
        ["nopaging"]=>
        bool(false)
        ["comments_per_page"]=>
        string(2) "50"
        ["no_found_rows"]=>
        bool(false)
        ["order"]=>
        string(4) "DESC"
      }
      ["tax_query"]=>
      object(WP_Tax_Query)#3974 (6) {
        ["queries"]=>
        array(0) {
        }
        ["relation"]=>
        string(3) "AND"
        ["table_aliases":protected]=>
        array(0) {
        }
        ["queried_terms"]=>
        array(0) {
        }
        ["primary_table"]=>
        string(8) "wp_posts"
        ["primary_id_column"]=>
        string(2) "ID"
      }
      ["meta_query"]=>
      object(WP_Meta_Query)#3962 (9) {
        ["queries"]=>
        array(2) {
          [0]=>
          array(2) {
            ["key"]=>
            string(19) "image_meta_image_id"
            ["value"]=>
            string(5) "16233"
          }
          ["relation"]=>
          string(2) "OR"
        }
        ["relation"]=>
        string(3) "AND"
        ["meta_table"]=>
        string(11) "wp_postmeta"
        ["meta_id_column"]=>
        string(7) "post_id"
        ["primary_table"]=>
        string(8) "wp_posts"
        ["primary_id_column"]=>
        string(2) "ID"
        ["table_aliases":protected]=>
        array(1) {
          [0]=>
          string(11) "wp_postmeta"
        }
        ["clauses":protected]=>
        array(1) {
          ["wp_postmeta"]=>
          array(6) {
            ["key"]=>
            string(19) "image_meta_image_id"
            ["value"]=>
            string(5) "16233"
            ["compare"]=>
            string(1) "="
            ["compare_key"]=>
            string(1) "="
            ["alias"]=>
            string(11) "wp_postmeta"
            ["cast"]=>
            string(4) "CHAR"
          }
        }
        ["has_or_relation":protected]=>
        bool(false)
      }
      ["date_query"]=>
      bool(false)
      ["request"]=>
      string(426) "
    			SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID
    			FROM wp_posts  INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id )
    			WHERE 1=1  AND ( 
      ( wp_postmeta.meta_key = 'image_meta_image_id' AND wp_postmeta.meta_value = '16233' )
    ) AND wp_posts.post_type = 'post' AND ((wp_posts.post_status <> 'trash' AND wp_posts.post_status <> 'auto-draft'))
    			GROUP BY wp_posts.ID
    			ORDER BY wp_posts.post_date DESC
    			LIMIT 0, 1
    		"
      ["posts"]=>
      array(0) {
      }
      ["post_count"]=>
      int(0)
      ["current_post"]=>
      int(-1)
      ["before_loop"]=>
      bool(true)
      ["in_the_loop"]=>
      bool(false)
      ["comment_count"]=>
      int(0)
      ["current_comment"]=>
      int(-1)
      ["found_posts"]=>
      int(0)
      ["max_num_pages"]=>
      int(0)
      ["max_num_comment_pages"]=>
      int(0)
      ["is_single"]=>
      bool(false)
      ["is_preview"]=>
      bool(false)
      ["is_page"]=>
      bool(false)
      ["is_archive"]=>
      bool(false)
      ["is_date"]=>
      bool(false)
      ["is_year"]=>
      bool(false)
      ["is_month"]=>
      bool(false)
      ["is_day"]=>
      bool(false)
      ["is_time"]=>
      bool(false)
      ["is_author"]=>
      bool(false)
      ["is_category"]=>
      bool(false)
      ["is_tag"]=>
      bool(false)
      ["is_tax"]=>
      bool(false)
      ["is_search"]=>
      bool(false)
      ["is_feed"]=>
      bool(false)
      ["is_comment_feed"]=>
      bool(false)
      ["is_trackback"]=>
      bool(false)
      ["is_home"]=>
      bool(true)
      ["is_privacy_policy"]=>
      bool(false)
      ["is_404"]=>
      bool(false)
      ["is_embed"]=>
      bool(false)
      ["is_paged"]=>
      bool(false)
      ["is_admin"]=>
      bool(false)
      ["is_attachment"]=>
      bool(false)
      ["is_singular"]=>
      bool(false)
      ["is_robots"]=>
      bool(false)
      ["is_favicon"]=>
      bool(false)
      ["is_posts_page"]=>
      bool(false)
      ["is_post_type_archive"]=>
      bool(false)
      ["query_vars_hash":"WP_Query":private]=>
      string(32) "2ab9be15f5f96057950ea53522e2d60a"
      ["query_vars_changed":"WP_Query":private]=>
      bool(false)
      ["thumbnails_cached"]=>
      bool(false)
      ["allow_query_attachment_by_filename":protected]=>
      bool(false)
      ["stopwords":"WP_Query":private]=>
      NULL
      ["compat_fields":"WP_Query":private]=>
      array(2) {
        [0]=>
        string(15) "query_vars_hash"
        [1]=>
        string(18) "query_vars_changed"
      }
      ["compat_methods":"WP_Query":private]=>
      array(2) {
        [0]=>
        string(16) "init_query_flags"
        [1]=>
        string(15) "parse_tax_query"
      }
    }