Crime | Page 7 | The Tombstone Tourist

            array(1) {
  [0]=>
  string(137) "Visit the grave of Morphine frontman Mark Sandman at Sharon Memorial Park. Learn of his life and musical legacy at The Tombstone Tourist."
}

            array(1) {
  [0]=>
  string(134) "Visit the Grave of Bunk Johnson at St Edward Cemetery in New Iberia, Louisiana. Learn of his life and legacy at The Tombstone Tourist."
}

Default Args

array(5) {
  ["paged"]=>
  int(7)
  ["posts_per_page"]=>
  string(2) "20"
  ["numberposts"]=>
  int(-1)
  ["default_sort"]=>
  string(9) "sort_name"
  ["default_sort_order"]=>
  string(3) "asc"
}

Args

array(9) {
  ["paged"]=>
  int(7)
  ["post_type"]=>
  string(6) "graves"
  ["posts_per_page"]=>
  string(2) "20"
  ["numberposts"]=>
  string(2) "20"
  ["post_status"]=>
  array(3) {
    [0]=>
    string(7) "publish"
    [1]=>
    string(7) "pending"
    [2]=>
    string(5) "draft"
  }
  ["meta_query"]=>
  array(5) {
    ["relation"]=>
    string(3) "AND"
    ["query_acfs"]=>
    array(1) {
      ["relation"]=>
      string(2) "OR"
    }
    ["query_post_status"]=>
    array(3) {
      ["key"]=>
      string(11) "post_status"
      ["compare"]=>
      string(1) "="
      ["value"]=>
      string(9) "Published"
    }
    ["query_sort_name"]=>
    array(2) {
      ["key"]=>
      string(9) "sort_name"
      ["compare"]=>
      string(6) "EXISTS"
    }
    ["query_claim_to_fame"]=>
    array(4) {
      ["key"]=>
      string(13) "claim_to_fame"
      ["value"]=>
      string(23) "Crime and their Victims"
      ["compare"]=>
      string(1) "="
      ["type"]=>
      string(4) "CHAR"
    }
  }
  ["orderby"]=>
  string(10) "meta_value"
  ["meta_key"]=>
  string(9) "sort_name"
  ["order"]=>
  string(3) "ASC"
}

Sort By

array(0) {
}

Query

string(837) "SELECT SQL_CALC_FOUND_ROWS  wp_posts.ID
					 FROM wp_posts  INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id )  INNER JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id )  INNER JOIN wp_postmeta AS mt2 ON ( wp_posts.ID = mt2.post_id )  INNER JOIN wp_postmeta AS mt3 ON ( wp_posts.ID = mt3.post_id )
					 WHERE 1=1  AND ( 
  wp_postmeta.meta_key = 'sort_name' 
  AND 
  ( 
    ( mt1.meta_key = 'post_status' AND mt1.meta_value = 'Published' ) 
    AND 
    mt2.meta_key = 'sort_name' 
    AND 
    ( mt3.meta_key = 'claim_to_fame' AND mt3.meta_value = 'Crime and their Victims' )
  )
) AND wp_posts.post_type = 'graves' AND ((wp_posts.post_status = 'publish' OR wp_posts.post_status = 'draft' OR wp_posts.post_status = 'pending'))
					 GROUP BY wp_posts.ID
					 ORDER BY wp_postmeta.meta_value ASC
					 LIMIT 120, 20"

Additional Query Info

# of posts found	122
paged	7

Weiss, Hymie

Crime and their Victims

Age 28

December 25, 1898 - October 11, 1926

Mt. Carmel Catholic Cemetery / Hillside / Illinois / USA / North America

Chicago mobster and a tough rival of legendary mobster Al Capone. Hymie Weiss was thought to be the first to use the infamous words 'Lets take him for a ride' when planning a hit on someone. Folklore has it that Weiss was the only...

White, Stanford

Crime and their Victims

Age 52

November 9, 1853 - June 25, 1906

Saint James Episcopal Church Graveyard / Saint James / New York / USA / North America

Stanford White was a celebrated American architect and a partner in the architectural firm McKim, Mead & White, one of the most significant Beaux-Arts firms at the turn of the 20th century. White designed many houses for the wealt...

<< page 1 page 2 … page 5 page 6 page 7