Headwear

object(WP_Query)#5715 (52) {
  ["query"]=>
  array(1) {
    ["product_cat"]=>
    string(17) "clothing/headwear"
  }
  ["query_vars"]=>
  array(70) {
    ["product_cat"]=>
    string(8) "headwear"
    ["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) ""
    ["fields"]=>
    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) {
    }
    ["orderby"]=>
    string(16) "menu_order title"
    ["order"]=>
    string(3) "ASC"
    ["meta_query"]=>
    array(1) {
      [0]=>
      array(3) {
        ["key"]=>
        string(13) "_stock_status"
        ["value"]=>
        string(10) "outofstock"
        ["compare"]=>
        string(6) "NOT IN"
      }
    }
    ["tax_query"]=>
    array(2) {
      ["relation"]=>
      string(3) "AND"
      [0]=>
      array(4) {
        ["taxonomy"]=>
        string(18) "product_visibility"
        ["field"]=>
        string(16) "term_taxonomy_id"
        ["terms"]=>
        array(2) {
          [0]=>
          int(1025)
          [1]=>
          int(1027)
        }
        ["operator"]=>
        string(6) "NOT IN"
      }
    }
    ["posts_per_page"]=>
    int(9999)
    ["wc_query"]=>
    string(13) "product_query"
    ["ignore_sticky_posts"]=>
    bool(false)
    ["suppress_filters"]=>
    bool(false)
    ["cache_results"]=>
    bool(true)
    ["update_post_term_cache"]=>
    bool(true)
    ["lazy_load_term_meta"]=>
    bool(true)
    ["update_post_meta_cache"]=>
    bool(true)
    ["post_type"]=>
    string(0) ""
    ["nopaging"]=>
    bool(false)
    ["comments_per_page"]=>
    string(2) "50"
    ["no_found_rows"]=>
    bool(false)
    ["taxonomy"]=>
    string(11) "product_cat"
    ["term"]=>
    string(8) "headwear"
  }
  ["tax_query"]=>
  object(WP_Tax_Query)#11207 (6) {
    ["queries"]=>
    array(3) {
      ["relation"]=>
      string(3) "AND"
      [0]=>
      array(5) {
        ["taxonomy"]=>
        string(18) "product_visibility"
        ["terms"]=>
        array(2) {
          [0]=>
          int(1025)
          [1]=>
          int(1027)
        }
        ["field"]=>
        string(16) "term_taxonomy_id"
        ["operator"]=>
        string(6) "NOT IN"
        ["include_children"]=>
        bool(true)
      }
      [1]=>
      array(5) {
        ["taxonomy"]=>
        string(11) "product_cat"
        ["terms"]=>
        array(1) {
          [0]=>
          string(8) "headwear"
        }
        ["field"]=>
        string(4) "slug"
        ["operator"]=>
        string(2) "IN"
        ["include_children"]=>
        bool(true)
      }
    }
    ["relation"]=>
    string(3) "AND"
    ["table_aliases":protected]=>
    array(1) {
      [0]=>
      string(21) "wp_term_relationships"
    }
    ["queried_terms"]=>
    array(1) {
      ["product_cat"]=>
      array(2) {
        ["terms"]=>
        array(1) {
          [0]=>
          string(8) "headwear"
        }
        ["field"]=>
        string(4) "slug"
      }
    }
    ["primary_table"]=>
    string(8) "wp_posts"
    ["primary_id_column"]=>
    string(2) "ID"
  }
  ["meta_query"]=>
  object(WP_Meta_Query)#11181 (9) {
    ["queries"]=>
    array(2) {
      [0]=>
      array(3) {
        ["key"]=>
        string(13) "_stock_status"
        ["value"]=>
        string(10) "outofstock"
        ["compare"]=>
        string(6) "NOT IN"
      }
      ["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(13) "_stock_status"
        ["value"]=>
        string(10) "outofstock"
        ["compare"]=>
        string(6) "NOT IN"
        ["compare_key"]=>
        string(1) "="
        ["alias"]=>
        string(11) "wp_postmeta"
        ["cast"]=>
        string(4) "CHAR"
      }
    }
    ["has_or_relation":protected]=>
    bool(false)
  }
  ["date_query"]=>
  bool(false)
  ["queried_object"]=>
  object(WP_Term)#11179 (10) {
    ["term_id"]=>
    int(1161)
    ["name"]=>
    string(8) "Headwear"
    ["slug"]=>
    string(8) "headwear"
    ["term_group"]=>
    int(0)
    ["term_taxonomy_id"]=>
    int(1161)
    ["taxonomy"]=>
    string(11) "product_cat"
    ["description"]=>
    string(0) ""
    ["parent"]=>
    int(1158)
    ["count"]=>
    int(7)
    ["filter"]=>
    string(3) "raw"
  }
  ["queried_object_id"]=>
  int(1161)
  ["request"]=>
  string(712) "SELECT SQL_CALC_FOUND_ROWS  wp_posts.* FROM wp_posts  LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) WHERE 1=1  AND ( 
  wp_posts.ID NOT IN (
				SELECT object_id
				FROM wp_term_relationships
				WHERE term_taxonomy_id IN (1025,1027)
			) 
  AND 
  wp_term_relationships.term_taxonomy_id IN (1161)
) AND ( 
  ( wp_postmeta.meta_key = '_stock_status' AND wp_postmeta.meta_value NOT IN ('outofstock') )
) AND wp_posts.post_type = 'product' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled') GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order ASC, wp_posts.post_title ASC LIMIT 0, 9999"
  ["posts"]=>
  &array(6) {
    [0]=>
    object(WP_Post)#11178 (24) {
      ["ID"]=>
      int(179288)
      ["post_author"]=>
      string(1) "1"
      ["post_date"]=>
      string(19) "2017-03-15 09:57:56"
      ["post_date_gmt"]=>
      string(19) "2017-03-15 09:57:56"
      ["post_content"]=>
      string(127) "Similar to the Birmingham Bears Navy Bobble Hat, this hat feature the text "You Bears" as well  as a yellow and navy bobble."
      ["post_title"]=>
      string(39) "Birmingham Bears 'you Bears' Bobble Hat"
      ["post_excerpt"]=>
      string(0) ""
      ["post_status"]=>
      string(7) "publish"
      ["comment_status"]=>
      string(4) "open"
      ["ping_status"]=>
      string(6) "closed"
      ["post_password"]=>
      string(0) ""
      ["post_name"]=>
      string(37) "birmingham-bears-you-bears-bobble-hat"
      ["to_ping"]=>
      string(0) ""
      ["pinged"]=>
      string(0) ""
      ["post_modified"]=>
      string(19) "2021-10-20 00:05:44"
      ["post_modified_gmt"]=>
      string(19) "2021-10-19 23:05:44"
      ["post_content_filtered"]=>
      string(0) ""
      ["post_parent"]=>
      int(0)
      ["guid"]=>
      string(71) "http://edgbastonshop.com/product/birmingham-bears-you-bears-bobble-hat/"
      ["menu_order"]=>
      int(0)
      ["post_type"]=>
      string(7) "product"
      ["post_mime_type"]=>
      string(0) ""
      ["comment_count"]=>
      string(1) "0"
      ["filter"]=>
      string(3) "raw"
    }
    [1]=>
    object(WP_Post)#11208 (24) {
      ["ID"]=>
      int(155443)
      ["post_author"]=>
      string(1) "1"
      ["post_date"]=>
      string(19) "2016-11-11 16:30:14"
      ["post_date_gmt"]=>
      string(19) "2016-11-11 16:30:14"
      ["post_content"]=>
      string(199) "With the Birmingham Bears Junior Navy Bobble Hat you can be assured of its warmth and quality. Finished with a yellow and navy bobble, this hat is versatile, insulating and a little bit legendary!"
      ["post_title"]=>
      string(39) "Birmingham Bears Junior Navy Bobble Hat"
      ["post_excerpt"]=>
      string(0) ""
      ["post_status"]=>
      string(7) "publish"
      ["comment_status"]=>
      string(4) "open"
      ["ping_status"]=>
      string(6) "closed"
      ["post_password"]=>
      string(0) ""
      ["post_name"]=>
      string(39) "birmingham-bears-junior-navy-bobble-hat"
      ["to_ping"]=>
      string(0) ""
      ["pinged"]=>
      string(0) ""
      ["post_modified"]=>
      string(19) "2021-10-20 00:06:19"
      ["post_modified_gmt"]=>
      string(19) "2021-10-19 23:06:19"
      ["post_content_filtered"]=>
      string(0) ""
      ["post_parent"]=>
      int(0)
      ["guid"]=>
      string(73) "http://edgbastonshop.com/product/birmingham-bears-junior-navy-bobble-hat/"
      ["menu_order"]=>
      int(0)
      ["post_type"]=>
      string(7) "product"
      ["post_mime_type"]=>
      string(0) ""
      ["comment_count"]=>
      string(1) "0"
      ["filter"]=>
      string(3) "raw"
    }
    [2]=>
    object(WP_Post)#11209 (24) {
      ["ID"]=>
      int(155446)
      ["post_author"]=>
      string(1) "1"
      ["post_date"]=>
      string(19) "2016-11-11 16:30:14"
      ["post_date_gmt"]=>
      string(19) "2016-11-11 16:30:14"
      ["post_content"]=>
      string(199) "With the Birmingham Bears Junior Navy Bobble Hat you can be assured of its warmth and quality. Finished with a yellow and navy bobble, this hat is versatile, insulating and a little bit legendary!"
      ["post_title"]=>
      string(32) "Birmingham Bears Navy Bobble Hat"
      ["post_excerpt"]=>
      string(0) ""
      ["post_status"]=>
      string(7) "publish"
      ["comment_status"]=>
      string(4) "open"
      ["ping_status"]=>
      string(6) "closed"
      ["post_password"]=>
      string(0) ""
      ["post_name"]=>
      string(32) "birmingham-bears-navy-bobble-hat"
      ["to_ping"]=>
      string(0) ""
      ["pinged"]=>
      string(0) ""
      ["post_modified"]=>
      string(19) "2021-10-20 00:06:32"
      ["post_modified_gmt"]=>
      string(19) "2021-10-19 23:06:32"
      ["post_content_filtered"]=>
      string(0) ""
      ["post_parent"]=>
      int(0)
      ["guid"]=>
      string(66) "http://edgbastonshop.com/product/birmingham-bears-navy-bobble-hat/"
      ["menu_order"]=>
      int(0)
      ["post_type"]=>
      string(7) "product"
      ["post_mime_type"]=>
      string(0) ""
      ["comment_count"]=>
      string(1) "0"
      ["filter"]=>
      string(3) "raw"
    }
    [3]=>
    object(WP_Post)#11210 (24) {
      ["ID"]=>
      int(155410)
      ["post_author"]=>
      string(1) "1"
      ["post_date"]=>
      string(19) "2016-11-11 16:30:10"
      ["post_date_gmt"]=>
      string(19) "2016-11-11 16:30:10"
      ["post_content"]=>
      string(157) "The Warwickshire CCC Black Basic Cap is a classic, made from navy cotton-twill and has an adjustable velcro back tab that allows you to find the perfect fit."
      ["post_title"]=>
      string(31) "Warwickshire CCC Basic Cap Navy"
      ["post_excerpt"]=>
      string(0) ""
      ["post_status"]=>
      string(7) "publish"
      ["comment_status"]=>
      string(4) "open"
      ["ping_status"]=>
      string(6) "closed"
      ["post_password"]=>
      string(0) ""
      ["post_name"]=>
      string(31) "warwickshire-ccc-navy-basic-cap"
      ["to_ping"]=>
      string(0) ""
      ["pinged"]=>
      string(0) ""
      ["post_modified"]=>
      string(19) "2021-10-20 00:15:17"
      ["post_modified_gmt"]=>
      string(19) "2021-10-19 23:15:17"
      ["post_content_filtered"]=>
      string(0) ""
      ["post_parent"]=>
      int(0)
      ["guid"]=>
      string(65) "http://edgbastonshop.com/product/warwickshire-ccc-navy-basic-cap/"
      ["menu_order"]=>
      int(0)
      ["post_type"]=>
      string(7) "product"
      ["post_mime_type"]=>
      string(0) ""
      ["comment_count"]=>
      string(1) "0"
      ["filter"]=>
      string(3) "raw"
    }
    [4]=>
    object(WP_Post)#11211 (24) {
      ["ID"]=>
      int(182097)
      ["post_author"]=>
      string(1) "1"
      ["post_date"]=>
      string(19) "2017-03-22 11:21:36"
      ["post_date_gmt"]=>
      string(19) "2017-03-22 11:21:36"
      ["post_content"]=>
      string(267) "The Warwickshire CCC Contrast Cap is made from a navy cotton-twill and has an adjustable snapback tab that allows you to find the perfect fit. The contrast understated black peak is perfect for keeping the sun off your face whether your in the stands or on the field."
      ["post_title"]=>
      string(29) "Warwickshire CCC Contrast Cap"
      ["post_excerpt"]=>
      string(0) ""
      ["post_status"]=>
      string(7) "publish"
      ["comment_status"]=>
      string(4) "open"
      ["ping_status"]=>
      string(6) "closed"
      ["post_password"]=>
      string(0) ""
      ["post_name"]=>
      string(29) "warwickshire-ccc-contrast-cap"
      ["to_ping"]=>
      string(0) ""
      ["pinged"]=>
      string(0) ""
      ["post_modified"]=>
      string(19) "2021-10-20 00:15:28"
      ["post_modified_gmt"]=>
      string(19) "2021-10-19 23:15:28"
      ["post_content_filtered"]=>
      string(0) ""
      ["post_parent"]=>
      int(0)
      ["guid"]=>
      string(63) "http://edgbastonshop.com/product/warwickshire-ccc-contrast-cap/"
      ["menu_order"]=>
      int(0)
      ["post_type"]=>
      string(7) "product"
      ["post_mime_type"]=>
      string(0) ""
      ["comment_count"]=>
      string(1) "0"
      ["filter"]=>
      string(3) "raw"
    }
    [5]=>
    object(WP_Post)#11212 (24) {
      ["ID"]=>
      int(182121)
      ["post_author"]=>
      string(1) "1"
      ["post_date"]=>
      string(19) "2017-03-22 11:21:55"
      ["post_date_gmt"]=>
      string(19) "2017-03-22 11:21:55"
      ["post_content"]=>
      string(327) "Just like the adult Bobble Hat, but for kids. Ward off the winter winds in style with the Warwickshire CCC Bobble Hat. Sporting the trademark Warwickshire County Cricket Club crest on the front, the hat is a product of superb craftsmanship and will looks just as good in the stands as it would if you were standing at point."
      ["post_title"]=>
      string(34) "Warwickshire CCC Junior Bobble Hat"
      ["post_excerpt"]=>
      string(0) ""
      ["post_status"]=>
      string(7) "publish"
      ["comment_status"]=>
      string(4) "open"
      ["ping_status"]=>
      string(6) "closed"
      ["post_password"]=>
      string(0) ""
      ["post_name"]=>
      string(34) "warwickshire-ccc-junior-bobble-hat"
      ["to_ping"]=>
      string(0) ""
      ["pinged"]=>
      string(0) ""
      ["post_modified"]=>
      string(19) "2021-10-20 00:15:48"
      ["post_modified_gmt"]=>
      string(19) "2021-10-19 23:15:48"
      ["post_content_filtered"]=>
      string(0) ""
      ["post_parent"]=>
      int(0)
      ["guid"]=>
      string(68) "http://edgbastonshop.com/product/warwickshire-ccc-junior-bobble-hat/"
      ["menu_order"]=>
      int(0)
      ["post_type"]=>
      string(7) "product"
      ["post_mime_type"]=>
      string(0) ""
      ["comment_count"]=>
      string(1) "0"
      ["filter"]=>
      string(3) "raw"
    }
  }
  ["post_count"]=>
  int(6)
  ["current_post"]=>
  int(-1)
  ["in_the_loop"]=>
  bool(false)
  ["post"]=>
  object(WP_Post)#11178 (24) {
    ["ID"]=>
    int(179288)
    ["post_author"]=>
    string(1) "1"
    ["post_date"]=>
    string(19) "2017-03-15 09:57:56"
    ["post_date_gmt"]=>
    string(19) "2017-03-15 09:57:56"
    ["post_content"]=>
    string(127) "Similar to the Birmingham Bears Navy Bobble Hat, this hat feature the text "You Bears" as well  as a yellow and navy bobble."
    ["post_title"]=>
    string(39) "Birmingham Bears 'you Bears' Bobble Hat"
    ["post_excerpt"]=>
    string(0) ""
    ["post_status"]=>
    string(7) "publish"
    ["comment_status"]=>
    string(4) "open"
    ["ping_status"]=>
    string(6) "closed"
    ["post_password"]=>
    string(0) ""
    ["post_name"]=>
    string(37) "birmingham-bears-you-bears-bobble-hat"
    ["to_ping"]=>
    string(0) ""
    ["pinged"]=>
    string(0) ""
    ["post_modified"]=>
    string(19) "2021-10-20 00:05:44"
    ["post_modified_gmt"]=>
    string(19) "2021-10-19 23:05:44"
    ["post_content_filtered"]=>
    string(0) ""
    ["post_parent"]=>
    int(0)
    ["guid"]=>
    string(71) "http://edgbastonshop.com/product/birmingham-bears-you-bears-bobble-hat/"
    ["menu_order"]=>
    int(0)
    ["post_type"]=>
    string(7) "product"
    ["post_mime_type"]=>
    string(0) ""
    ["comment_count"]=>
    string(1) "0"
    ["filter"]=>
    string(3) "raw"
  }
  ["comment_count"]=>
  int(0)
  ["current_comment"]=>
  int(-1)
  ["found_posts"]=>
  string(1) "6"
  ["max_num_pages"]=>
  float(1)
  ["max_num_comment_pages"]=>
  int(0)
  ["is_single"]=>
  bool(false)
  ["is_preview"]=>
  bool(false)
  ["is_page"]=>
  bool(false)
  ["is_archive"]=>
  bool(true)
  ["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(true)
  ["is_search"]=>
  bool(false)
  ["is_feed"]=>
  bool(false)
  ["is_comment_feed"]=>
  bool(false)
  ["is_trackback"]=>
  bool(false)
  ["is_home"]=>
  bool(false)
  ["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_posts_page"]=>
  bool(false)
  ["is_post_type_archive"]=>
  bool(false)
  ["query_vars_hash":"WP_Query":private]=>
  string(32) "c3900964ff2de71e3a5fa83ac86d9bd2"
  ["query_vars_changed":"WP_Query":private]=>
  bool(true)
  ["thumbnails_cached"]=>
  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"
  }
}

Showing all 6 results

Showing all 6 results