Crime | Page 6 | The Tombstone Tourist

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

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"

Tucker, Karla Faye

Crime and their Victims

Age 38

November 18, 1959 - February 3, 1998

Forest Park Lawndale Cemetery / Houston / Texas / USA / North America

Convicted for killing two people with a pickaxe during a burglary, she was the first woman to be executed in Texas since Chipita Rodriguez in 1863. Her execution received worldwide attention at the time.

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

Default Args

Args

Sort By

Query

Additional Query Info

# of posts found	103
paged	6