0.0005 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0108 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-03-29' AND `url` = 'https://www.maineventtravel.com/destination/articles/las-vegas-guide/Summer-in-Vegas-2023-Line-Up-of-Women-Only-Tournamen-t' ORDER BY `views` DESC

0.0011 SECONDS:
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/destination/articles/las-vegas-guide/Summer-in-Vegas-2023-Line-Up-of-Women-Only-Tournamen-t', 1, '2024-03-29')

0.0006 SECONDS:
SELECT * FROM `settings` JOIN `white_label_versions` ON `white_label_versions`.`id` = `settings`.`white_label_version_id` WHERE `white_label_versions`.`url` = 'maineventtravel.com'

0.0003 SECONDS:
SELECT * FROM `settings` WHERE `white_label_version_id` = 0

0.0008 SECONDS:
SELECT `tours`.* FROM `tours` WHERE `active` = 1 AND `venue` = '0' AND `festival` = '0' ORDER BY `order` ASC

0.0005 SECONDS:
SELECT `white_label_inclusions`.`entity_id` FROM `white_label_inclusions` JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id` WHERE `white_label_versions`.`url` = 'maineventtravel.com' AND `white_label_inclusions`.`entity_type` = 'tour'

0.0003 SECONDS:
SELECT * FROM `tours` WHERE `active` = '1' AND `festival` = '1' ORDER BY `order` ASC

0.0004 SECONDS:
SELECT `white_label_inclusions`.`entity_id` FROM `white_label_inclusions` JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id` WHERE `white_label_versions`.`url` = 'maineventtravel.com' AND `white_label_inclusions`.`entity_type` = 'tour'

0.0002 SECONDS:
SELECT `id`, `name`, `url` FROM `destinations` WHERE `active` = 1 ORDER BY `display_order`

0.0116 SECONDS:
SELECT `venues`.*, (select COUNT(*) from tour_stops where tour_stops.venue_id=venues.id AND tour_stops.end_date > curdate() AND tour_stops.active = 1) tour_stop_count FROM `venues` WHERE `display_in_navigation` = '1' LIMIT 30

0.0015 SECONDS:
SELECT `pages`.*, `parents`.`url_name` as `parent_url_name` FROM `pages` LEFT JOIN `pages` as `parents` ON `parents`.`id` = `pages`.`parent_page_id` WHERE `pages`.`active` = '1'

0.0005 SECONDS:
SELECT `white_label_inclusions`.`entity_id` FROM `white_label_inclusions` JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id` WHERE `white_label_versions`.`url` = 'maineventtravel.com' AND `white_label_inclusions`.`entity_type` = 'page'

0.0003 SECONDS:
SELECT destinations.*, uapi_airports.name as airport_name FROM `destinations` LEFT JOIN `uapi_airports` ON `destinations`.`uapi_code` = `uapi_airports`.`airport_code` WHERE `url` = 'las-vegas-guide'

0.0027 SECONDS:
SELECT `news_articles`.*, `users`.`full_name` as `author`, `users`.`twitter_name` as `twitter_name` FROM `news_articles` LEFT JOIN `users` ON `users`.`id` = `news_articles`.`user_id` WHERE `url_name` = 'Summer-in-Vegas-2023-Line-Up-of-Women-Only-Tournamen-t'

0.0002 SECONDS:
SELECT `news_categories`.* FROM `news_article_categories` LEFT JOIN `news_categories` ON `news_article_categories`.`news_category_id` = `news_categories`.`id` WHERE `news_article_categories`.`news_article_id` = '829'

0.0070 SECONDS:
SELECT DISTINCT tour_stops.*, tours.name as tour_name, ((ACOS(SIN(36.11532281210326 * PI() / 180) * SIN(venues.map_latitude * PI() / 180) + COS(36.11532281210326 * PI() / 180) * COS(venues.map_latitude * PI() / 180) * COS((-115.17587848916014 - venues.map_longitude) * PI() / 180)) * 180 / PI()) * 60 * 1.1515) AS distance, venues.name as venue_name, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, tours.logo as tour_logo, CASE WHEN tour_stops.logo IS NULL or tour_stops.logo = '' THEN tours.logo ELSE tour_stops.logo END AS logo FROM `venues` LEFT JOIN `tour_stops` ON `tour_stops`.`venue_id` = `venues`.`id` JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id` WHERE `tour_stops`.`active` = '1' AND tour_stops.end_date > CURDATE() HAVING `distance` <= 10 ORDER BY `tour_stops`.`start_date` ASC

0.0004 SECONDS:
SELECT `news_articles`.`url_name`, `news_articles`.`main_image`, `news_articles`.`meta_description`, `news_articles`.`title` FROM `news_article_destinations` JOIN `news_articles` ON `news_article_destinations`.`news_article_id` = `news_articles`.`id` WHERE `news_articles`.`active` = 1 AND `destination_id` = 2 ORDER BY `news_article_destinations`.`display_order`

English
Friday 26th May, 2023

Summer in Vegas 2023 Line-Up of Women-Only Tournaments

By Mad Harper

An absolute feast of women's poker action is lined up in Vegas this summer culminating in a dedicated Ladies’ Poker Week Bonanza being organised by the Women’s Poker Association, the Ladies International Poker Series (LIPS), the Poker League of Nations and several Las Vegas Casinos. The events offer a combined guaranteed prize pool amounting to $225,000. 

The WPA Summer Camp Ladies Poker Week celebrates a stretch from June 25 to July 4 which will include a bunch of tournaments along with social events, meet-ups, and raffles. It’s being billed as the deepest stretch of Women’s Poker events in history with at least 10 separate events taking place at eight different Las Vegas Casinos. Four of the tournaments are official offerings from LIPS - the Ladies International Poker Series Tour, two are WSOP tournaments while another is a Poker League of Nations event. All 10 tournaments will be eligible for points on the WPA Leaderboard.

The Ladies Poker Week seems more than a good enough reason for female players to plan a fabulous trip to Sin City. Wherever and whatever you’re playing, MainEventTravel can help you with all your Vegas travel needs – from our comprehensive flight booking service to bagging the best hotels .

Here are the 10 women’s poker tourneys already scheduled between June 25 and July 4:

  • June 25, 6:00 pm, MGM Resort Grand Summer Festival: LIPS $250 Kick Off Ladies Event NLH ($20,000 Gtd.)
  • June 26, 1:00 pm, Resorts World LV: PLON $360 Ladies Event NLH ($35,000 Gtd.)
  • June 27, 2:00 pm, South Point: LIPS $180 Mega-Satellite (1 in 10 wins a $360 seat to the July 1 LIPS main event, plus $1,050 in cash)
  • June 28, 12:10 pm, Venetian Deepstack Championship: LIPS $500 Ladies Event NLH ($30,000 Gtd.)
  • June 28, 6:00 pm, Horseshoe LV: WSOP $150 Ladies Warmup NLH
  • June 29, 11:00 am, Horseshoe LV: WSOP $1,000 2023 Ladies Championship (4-day event)
  • June 30, 1:00 pm, Golden Nugget LV The Grand: $200 Ladies Event NLH ($10,000 Gtd.)
  • July 1, 11:00 am, South Point: LIPS $360 National Championship NLH (2-day event, $30,000 Gtd.)
  • July 2, 2:00 pm, South Point: LIPS $200 Ladies Deepstack NLH
  • July 3, 11:00 am, Wynn Summer Classic: $550 Ladies Event NLH ($50,000 Gtd.)
  • July 4, 11:00 am, Aria Poker Classic, $500 Ladies Event NLH ($50,000)



What's Hot in Las Vegas


Events

Your search results are valid for . More Info
Travel search results are valid for a period of 20 minutes. If you do not book by this time, items in your cart may change in price or become unavailable.