Crime | Page 7 | The Tombstone Tourist

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" }

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"

Vario, Paul

Crime and their Victims

Age 73

July 10, 1914 - May 3, 1988

St. John Cemetery / Middle Village / New York / USA / North America

Paul Vario was a prominent New York mobster and high-ranking member of the Lucchese crime family. Born on July 10, 1914, in Brooklyn, he became involved in organized crime at a young age, eventually rising to become a caporegime (...

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

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

Default Args

Args

Sort By

Query

Additional Query Info

# of posts found	124
paged	7