Crime | Page 6 | The Tombstone Tourist

            array(1) {
  [0]=>
  string(156) "Grave of Mark Sandman. Mark Sandman was born on September 24, 1952 and died in Giardini del Principe, Palestrina, Italy due to Heart attack on July 3, 1999."
}

            array(1) {
  [0]=>
  string(174) "Grave of Bunk Johnson. Bunk Johnson was born on December 27, 1885 and died in 638 Franklin Street, New Iberia, Louisiana due to Lingering effects of a stroke on July 7, 1949."
}

Default Args

array(5) {
  ["paged"]=>
  int(6)
  ["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(6)
  ["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 100, 20"

Additional Query Info

# of posts found	102
paged	6

Von Bulow, Sunny

Crime and their Victims

Age 76

September 1, 1932 - December 6, 2008

Saint Mary's Episcopal Churchyard and Cemetery / Portsmouth / Rhode Island / USA / North America

Martha "Sunny" Von Bulow was an American heiress, socialite, and philanthropist. Upon her utilities magnate father's death, she was the heiress to his ~ $100 million fortune. After divorcing her first husband, Prince Alfred von Au...

Weiss, Hymie

Crime and their Victims

Age 28

December 25, 1898 - October 11, 1926

Mount Carmel Catholic Cemetery / Hillside / Illinois / 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...

<< page 1 page 2 … page 4 page 5 page 6