Recent Additions | 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(1)
  ["posts_per_page"]=>
  string(2) "15"
  ["numberposts"]=>
  int(-1)
  ["default_sort"]=>
  string(19) "post_published_date"
  ["default_sort_order"]=>
  string(4) "desc"
}

Args

array(9) {
  ["paged"]=>
  int(1)
  ["post_type"]=>
  string(6) "graves"
  ["posts_per_page"]=>
  string(2) "15"
  ["numberposts"]=>
  string(2) "15"
  ["post_status"]=>
  array(3) {
    [0]=>
    string(7) "publish"
    [1]=>
    string(7) "pending"
    [2]=>
    string(5) "draft"
  }
  ["meta_query"]=>
  array(6) {
    ["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"
    }
    ["time_fame_start"]=>
    array(3) {
      ["key"]=>
      string(19) "post_published_date"
      ["compare"]=>
      string(2) ">="
      ["value"]=>
      string(8) "20230305"
    }
    ["time_fame_end"]=>
    array(3) {
      ["key"]=>
      string(19) "post_published_date"
      ["compare"]=>
      string(2) "<="
      ["value"]=>
      string(8) "20230605"
    }
  }
  ["orderby"]=>
  string(10) "meta_value"
  ["meta_key"]=>
  string(19) "post_published_date"
  ["order"]=>
  string(4) "DESC"
}

Sort By

array(0) {
}

Query

string(996) "
					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 )  INNER JOIN wp_postmeta AS mt4 ON ( wp_posts.ID = mt4.post_id )
					WHERE 1=1  AND ( 
  wp_postmeta.meta_key = 'post_published_date' 
  AND 
  ( 
    ( mt1.meta_key = 'post_status' AND mt1.meta_value = 'Published' ) 
    AND 
    mt2.meta_key = 'sort_name' 
    AND 
    ( mt3.meta_key = 'post_published_date' AND mt3.meta_value >= '20230305' ) 
    AND 
    ( mt4.meta_key = 'post_published_date' AND mt4.meta_value <= '20230605' )
  )
) 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 DESC
					LIMIT 0, 15
				"

Additional Query Info

# of posts found	32
paged	1

Cochran, Eddie

Music

Age 21

October 3, 1938 - April 17, 1960

Forest Lawn Memorial Park / Cypress / California / USA / North America

Eddie Cochran was an American rock and roll musician and songwriter with such hits as "Twenty Flight Rock", "Summertime Blues", "C'mon Everybody" and ...

Stewart, Dennis Cleveland

Show Business

Age 46

July 29, 1947 - April 20, 1994

Rose Hills Memorial Park / Whittier / California / USA / North America

Actor and dancer Dennis Stewart's career looked to be on the up when, after playing a dancer in the 1978 Beatles-inspired film Sgt Pepper’s Lonely H...

Hazzard, Walt

Sports

Age 69

April 15, 1942 - November 18, 2011

Rose Hills Memorial Park / Whittier / California / USA / North America

Walter Hazzard was an American professional basketball player and college basketball coach. Hazzard attended Overbrook High School in Philadelphia, wh...

St. John, John Patrick

Crime and their Victims

Age 77

February 18, 1918 - May 3, 1995

Rose Hills Memorial Park / Whittier / California / USA / North America

John Patrick St. John, better known as "Jigsaw John", was a Los Angeles Police Department homicide detective, renowned for his investigations of many ...

Rodgers, Jimmie

Music

Age 35

September 8, 1897 - May 26, 1933

Oak Grove Baptist Church Cemetery / Meridian / Mississippi / USA / North America

Jimmie Rodgers was an American singer, songwriter and musician who rose to popularity in the late 1920s. Widely regarded as "the Father of Country Mus...

Boltzmann, Ludwig

Science

Age 62

February 20, 1844 - September 5, 1906

Der Wiener Zentralfriedhof / Simmeringer Hauptstraße 234 / Vienna / Austria / Europe

Ludwig Boltzmann was one of the greatest theoretical physicists of all time. His fame is due to his pioneering research work on thermodynamics and sta...

Schoenberg, Arnold

Music

Age 76

September 13, 1874 - July 13, 1951

Der Wiener Zentralfriedhof / Simmeringer Hauptstraße 234 / Vienna / Austria / Europe

Arnold Schoenberg was an Austrian-American composer, music theorist, teacher, writer, and painter. He is widely considered one of the most influential...

Zawinul, Joe

Music

Age 75

July 7, 1932 - September 11, 2007

Der Wiener Zentralfriedhof / Simmeringer Hauptstraße 234 / Vienna / Austria / Europe

Joe Zawinul was an Austrian jazz and jazz fusion keyboardist and composer who first come to prominence with saxophonist Cannonball Adderley. Zawinul w...

Salieri, Antonio

Music

Age 74

August 18, 1750 - May 7, 1825

Der Wiener Zentralfriedhof / Simmeringer Hauptstraße 234 / Vienna / Austria / Europe

Antonio Salieri was an Italian classical composer, conductor, and teacher. Salieri was a pivotal figure in the development of late 18th-century opera....

Jürgens, Udo

Music

Age 80

September 30, 1934 - December 21, 2014

Der Wiener Zentralfriedhof / Simmeringer Hauptstraße 234 / Vienna / Austria / Europe

Udo Jürgens, was an Austrian composer and singer of German origin of popular music whose career spanned over 50 years. He won the Eurovision Song Con...

Strauss ll, Johann

Music

Age 73

October 25, 1825 - June 3, 1899

Der Wiener Zentralfriedhof / Simmeringer Hauptstraße 234 / Vienna / Austria / Europe

Johann Strauss II (also referred to as Johann Strauss Jr., the Younger) was an Austrian composer of light music, particularly dance music and operetta...

Brahms, Johannes

Music

Age 63

May 7, 1833 - April 3, 1897

Der Wiener Zentralfriedhof / Simmeringer Hauptstraße 234 / Vienna / Austria / Europe

Johannes Brahms was a German composer, pianist, and conductor of the mid-Romantic period. Born in Hamburg into a Lutheran family, he spent much of his...

Falco

Music

Age 40

February 19, 1957 - February 6, 1998

Der Wiener Zentralfriedhof / Simmeringer Hauptstraße 234 / Vienna / Austria / Europe

His name was Falco, and the image of sharp suit and slick-back hair already set him apart from the glam rockers and post-punks of the late 80s. He was...

Schubert, Franz

Music

Age 31

January 31, 1797 - November 19, 1828

Der Wiener Zentralfriedhof / Simmeringer Hauptstraße 234 / Vienna / Austria / Europe

Franz Schubert was an Austrian composer of the late Classical and early Romantic eras. Despite his short life, Schubert left behind a vast oeuvre, inc...

Beethoven, Ludwig van

Music

Age 56

December 17, 1770 - March 26, 1827

Der Wiener Zentralfriedhof / Simmeringer Hauptstraße 234 / Vienna / Austria / Europe

Ludwig van Beethoven was a German composer and pianist who remains one of the most admired composers in the history of Western music. His works rank a...

page 1 page 2 page 3 >>