Delete Cards:
DELETE FROM wp_6_posts WHERE post_type = 'muscovy_discountcard'

Post Schema Cards:
DELETE FROM wp_6_postmeta WHERE meta_key = 'ft_page_schema' AND meta_value = ''

Delete Cards:
DELETE FROM wp_6_postmeta WHERE meta_key IN ('_discount-content', 'discount-content', '_discount-image', 'discount-image', '_discount-website', 'discount-website', '_discount-address', 'discount-address', '_discount-phone-number', 'discount-phone-number')

Clean DB:
DELETE pm FROM wp_6_postmeta pm LEFT JOIN wp_6_posts wp ON wp.ID = pm.post_id WHERE wp.ID IS NULL

Clean Terms:
DELETE wp_6_term_relationships FROM wp_6_term_relationships LEFT JOIN wp_6_posts ON wp_6_term_relationships.object_id = wp_6_posts.ID WHERE wp_6_posts.ID is NULL;

Clean ACF Terms:
DELETE wp_6_yoast_seo_meta FROM wp_6_yoast_seo_meta LEFT JOIN wp_6_posts ON wp_6_yoast_seo_meta.object_id = wp_6_posts.ID WHERE wp_6_posts.ID is NULL;

-- Optimize Tables --
Completed

Myrtle Beach SkyWheel Created Successfully!
WonderWorks Created Successfully!
Myrtle Beach Pelicans Created Successfully!
Dave & Buster’s Created Successfully!
Level 6 Entertainment Center Created Successfully!
Duplin Winery Created Successfully!
Rockin’ Jump Myrtle Beach Created Successfully!
Myrtle Beach Watersports Created Successfully!
Ripley’s Aquarium Created Successfully!
Hollywood Wax Museum Entertainment Center Created Successfully!
Board & Brush North Myrtle Beach Created Successfully!
Brookgreen Gardens Created Successfully!
Big “M” Casino Created Successfully!
Downwind Sails Created Successfully!
Broadway Grand Prix Created Successfully!
T.I.G.E.R.S. Created Successfully!
Fossils Forever Created Successfully!
Pavilion Park Created Successfully!
Waccamaw River Tours Created Successfully!
Calabash Fishing Fleet Created Successfully!
Kokopelli Surf Camp Paddleboard & Kayak Tours Created Successfully!
Slingshot Thrill Ride Created Successfully!
2nd Avenue Pier Created Successfully!
Go Ape North Myrtle Beach Created Successfully!
J&L Kayaking Created Successfully!
Glass Bottom Kayak Tours Created Successfully!
Myrtle Beach Segway Created Successfully!
Trailblaze Adventure Created Successfully!
Fun Warehouse Created Successfully!
Little River Fishing Fleet Created Successfully!
Extreme Laser Tag Created Successfully!
Reel Action Fishing Charters Created Successfully!
Inlet Point Plantation Created Successfully!
Carolina Safari Jeep Tours Created Successfully!
Plantation Island Tours Created Successfully!
Are You A Business Interested In Joining Our Guest Value Program? Created Successfully!
Jungle Lagoon Miniature Golf Created Successfully!
Captain Hook’s Adventure Golf Created Successfully!
Jungle Safari Mini Golf Created Successfully!
Jurassic Golf Created Successfully!
Shipwreck Island Adventure Golf Created Successfully!
Alabama Theatre Created Successfully!
Carolina Improv Company at Uptown Theater Created Successfully!
Comedy Cabana Created Successfully!
GTS Theatre Created Successfully!
Legends in Concert Created Successfully!
Are You A Business Interested In Joining Our Guest Value Program? Created Successfully!
Angus Steakhouse and Seafood Created Successfully!
Aspen Grille Created Successfully!
Ben and Jerry’s Ice Cream Created Successfully!
Bimini’s Created Successfully!
Buckets Bar & Grill Created Successfully!
Bully’s Pub & Grill Created Successfully!
Bumstead’s Pub Created Successfully!
California Dreaming Surfside Created Successfully!
California Dreaming Created Successfully!
Captain Jack’s Seafood Buffet Created Successfully!
Carolina Roadhouse Created Successfully!
Carolina Seafood & Steakhouse Created Successfully!
Chestnut Hill Created Successfully!
City Pizza Created Successfully!
Crabby George’s Seafood Buffet Created Successfully!
Crab Daddy’s Seafood Buffet and Restaurant Created Successfully!
Creek Ratz Created Successfully!
Croissants Bistro & Bakery Created Successfully!
Croissants Bistro & Bakery Created Successfully!
Dagwood’s Deli Created Successfully!
Dagwood’s Deli & Sports Bar Created Successfully!
Damon’s Grill Created Successfully!
Dick’s Last Resort Created Successfully!
Duck Donuts Myrtle Beach Created Successfully!
Fuddruckers Created Successfully!
Fuddruckers Created Successfully!
Giant Crab Created Successfully!
Gordon Biersch Brewery Created Successfully!
Gulfstream Cafe Created Successfully!
Hook & Barrel Created Successfully!
Are You A Business Interested In Joining Our Guest Value Program? Created Successfully!
Hot Fish Club Created Successfully!
House of Blues Created Successfully!
Ledo Pizza Created Successfully!
Liberty Tap Room & Grill Created Successfully!
Lil’ Tokyo Hibachi and Sushi Bar Created Successfully!
Lobster House Seafood Restaurant Created Successfully!
Loco Gecko - Captain’s Quarters Location Created Successfully!
Loco Gecko - Crown Reef Location Created Successfully!
Lombardo’s Restaurant Created Successfully!
Masala Myrtle Beach Created Successfully!
Moe Moons Created Successfully!
National House of Pancakes Created Successfully!
New York Prime Created Successfully!
Original Benjamin’s Calabash Seafood Restaurant Created Successfully!
The Original Spring House Family Restaurant Created Successfully!
Pier House Restaurant Created Successfully!
Pier View Open Air Bar Created Successfully!
Preston’s Seafood and Country Buffet Created Successfully!
Rioz Brazilian Steakhouse Created Successfully!
Rioz Brazilian Steakhouse - NMB Created Successfully!
Sara J’s Created Successfully!
Pirate’s Table Calabash Seafood Buffet Created Successfully!
Senor Frog’s Created Successfully!
Shucker’s Raw Bar Created Successfully!
Smokin’ Hot Grill & BBQ Created Successfully!
Soho 544 Created Successfully!
Soho Steaks Seafood and Sushi Created Successfully!
Sugami Sushi Bar and Hibachi Created Successfully!
Sweet Molly’s Creamery Created Successfully!
TBonz Gill & Grill Created Successfully!
Texas Roadhouse Grill Created Successfully!
TGI Friday’s - 76th Avenue North Created Successfully!
Thoroughbred’s Chophouse Created Successfully!
Tin Roof Created Successfully!
Whiskey Beach Bar & Grill Created Successfully!
Wild Wing Cafe Created Successfully!
Black Dog Running Company Created Successfully!
Cariloha Created Successfully!
Cariloha - Golf Offer Created Successfully!
Coastal Wine Boutique and Tasting Room - Barefoot Landing Created Successfully!
Coastal Wine Boutique and Tasting Room Created Successfully!
Hope Taylor & Company Created Successfully!
Nick’s Cigar World Created Successfully!
Platos Closet Myrtle Beach Created Successfully!
Ron Jon Surf Shop Created Successfully!
Ron Jon Surf Shop - Barefoot Landing Created Successfully!
Tsunami Surf Shop Created Successfully!
The Harley Shop At The Beach Created Successfully!
The Olive Shoppe Created Successfully!
The Wacky Rabbit Created Successfully!
Are You A Business Interested In Joining Our Guest Value Program? Created Successfully!
Hero Tattoos Created Successfully!
Michael & Co. Salon Created Successfully!
Myrtle Beach Storage and Business Centre Created Successfully!
Professional Beach Portraits Created Successfully!
Strand College of Hair Design Created Successfully!
Timeless Memories, Inc. Created Successfully!
Tire Town Conway Created Successfully!
Tire Town Myrtle Beach Created Successfully!
Tire Town on Waccamaw Created Successfully!
Tire Town South Created Successfully!
Are You A Business Interested In Joining Our Guest Value Program? Created Successfully!
Senor Frog’s Created Successfully!
Are You A Business Interested In Joining Our Guest Value Program? Created Successfully!
Moped Rentals of Myrtle Beach Created Successfully!
Limo-Scene of Myrtle Beach Created Successfully!
Are You A Business Interested In Joining Our Guest Value Program? Created Successfully!
Cane Patch Driving Range Created Successfully!
Legends Golf Resort Created Successfully!
Are You A Business Interested In Joining Our Guest Value Program? Created Successfully!