Support

Account

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

  • Here’s var_dump( $attachment_query );

    
    object(WP_Query)#3978 (52) {
      ["query"]=>
      array(4) {
        ["fields"]=>
        string(3) "ids"
        ["posts_per_page"]=>
        int(1)
        ["post_type"]=>
        string(10) "attachment"
        ["meta_query"]=>
        array(1) {
          [0]=>
          array(2) {
            ["key"]=>
            string(19) "image_meta_image_id"
            ["value"]=>
            string(5) "17574"
          }
        }
      }
      ["query_vars"]=>
      array(66) {
        ["fields"]=>
        string(3) "ids"
        ["posts_per_page"]=>
        int(1)
        ["post_type"]=>
        string(10) "attachment"
        ["meta_query"]=>
        array(1) {
          [0]=>
          array(2) {
            ["key"]=>
            string(19) "image_meta_image_id"
            ["value"]=>
            string(5) "17574"
          }
        }
        ["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)#3417 (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)#3983 (9) {
        ["queries"]=>
        array(2) {
          [0]=>
          array(2) {
            ["key"]=>
            string(19) "image_meta_image_id"
            ["value"]=>
            string(5) "17574"
          }
          ["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) "17574"
            ["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(472) "
    			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 = '17574' )
    ) AND ((wp_posts.post_type = 'attachment' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled' 
    OR wp_posts.post_status = 'private')))
    			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) "79faba4333b88670ed32918a2aeeae58"
      ["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"
      }
    }