kimcoleman

SELECT
  p.ID as 'Subscription ID',
  pm1.meta_value as 'User ID',
  oitems.order_item_name as 'Product',
  pm2.meta_value as 'Next Payment Date'
FROM wp_posts p
INNER JOIN wp_postmeta pm1 ON pm1.post_id = p.ID
INNER JOIN wp_postmeta pm2 ON pm2.post_id = p.ID
INNER JOIN wp_woocommerce_order_items oitems ON oitems.order_id = p.ID
WHERE

kimcoleman

<!-- wp:paragraph -->
<p>The Common category includes the following blocks:<em> Paragraph, image, headings, list, gallery, quote, audio, cover, video.</em></p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>The paragraph block is the default block type.&nbsp; It should not have any alignment of any kind. It should just flow like you would normally expect. Nothing fancy. Just straight up text, free flowing, with love.</p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>This paragraph is left aligned.</p>

kimcoleman

<?php
/**
 * Hide the active sale from users with level ID 1, 2, or 3.
 */
function my_swsales_hide_from_premium_members( ) {
	
	// Return early if this is the admin.
	if ( is_admin() ) {
		return;
	}

kimcoleman

<!-- wp:group {"gradient":"vivid-cyan-blue-to-vivid-purple"} -->
<div class="wp-block-group has-vivid-cyan-blue-to-vivid-purple-gradient-background has-background"><!-- wp:columns {"verticalAlignment":"center"} -->
<div class="wp-block-columns are-vertically-aligned-center"><!-- wp:column {"verticalAlignment":"center","width":"66.66%"} -->
<div class="wp-block-column is-vertically-aligned-center" style="flex-basis:66.66%"><!-- wp:group {"layout":{"type":"flex","flexWrap":"nowrap"}} -->
<div class="wp-block-group"><!-- wp:heading {"level":3,"textColor":"white","className":"is-style-highlight"} -->
<h3 class="is-style-highlight has-white-color has-text-color">Black Friday Sale</h3>
<!-- /wp:heading -->

<!-- wp:heading {"level":3,"textColor":"palette-color-8"} -->
<h3 class="has-palette-color-8-color has-text-color">50% Off Our Best-Selling Serum</h3>

kimcoleman

<!-- wp:group {"gradient":"luminous-vivid-orange-to-vivid-red"} -->
<div class="wp-block-group has-luminous-vivid-orange-to-vivid-red-gradient-background has-background"><!-- wp:group {"align":"wide","textColor":"palette-color-8","layout":{"type":"flex","flexWrap":"wrap","justifyContent":"center"},"fontSize":"medium"} -->
<div class="wp-block-group alignwide has-palette-color-8-color has-text-color has-medium-font-size"><!-- wp:paragraph {"className":"is-style-default"} -->
<p class="is-style-default"><strong><mark style="background-color:#fc7ed8" class="has-inline-color">BLACK FRIDAY 2022</mark></strong></p>
<!-- /wp:paragraph -->

<!-- wp:paragraph -->
<p>Save 40% on everything in the store!</p>
<!-- /wp:paragraph -->

kimcoleman

<!-- wp:swsales/sale-content {"period":"pre-sale"} -->
<div class="wp-block-swsales-sale-content"><!-- wp:columns -->
<div class="wp-block-columns"><!-- wp:column {"width":"65%","gradient":"vivid-cyan-blue-to-vivid-purple"} -->
<div class="wp-block-column has-vivid-cyan-blue-to-vivid-purple-gradient-background has-background" style="flex-basis:65%"><!-- wp:group {"layout":{"type":"flex","flexWrap":"nowrap","justifyContent":"center"}} -->
<div class="wp-block-group"><!-- wp:paragraph {"textColor":"palette-color-4"} -->
<p class="has-palette-color-4-color has-text-color"><strong><mark style="background-color:var(--paletteColor6, #F4F4F5)" class="has-inline-color">SUPER SECRET SAVINGS</mark></strong></p>
<!-- /wp:paragraph --></div>
<!-- /wp:group -->

<!-- wp:heading {"textAlign":"center","level":1,"textColor":"palette-color-8","className":"no-margin"} -->

kimcoleman

<!-- wp:swsales/sale-content {"period":"pre-sale"} -->
<div class="wp-block-swsales-sale-content"><!-- wp:group {"align":"full","gradient":"pale-ocean"} -->
<div class="wp-block-group alignfull has-pale-ocean-gradient-background has-background"><!-- wp:separator {"className":"is-style-dots"} -->
<hr class="wp-block-separator has-alpha-channel-opacity is-style-dots"/>
<!-- /wp:separator -->

<!-- wp:group {"layout":{"type":"flex","flexWrap":"nowrap","justifyContent":"center"}} -->
<div class="wp-block-group"><!-- wp:paragraph -->
<p><strong><mark style="background-color:var(--paletteColor2, #F74D67)" class="has-inline-color has-palette-color-8-color">SUPER SECRET SAVINGS</mark></strong></p>
<!-- /wp:paragraph --></div>

kimcoleman

<!-- wp:swsales/sale-content {"period":"pre-sale"} -->
<div class="wp-block-swsales-sale-content"><!-- wp:group {"align":"full","gradient":"luminous-vivid-orange-to-vivid-red"} -->
<div class="wp-block-group alignfull has-luminous-vivid-orange-to-vivid-red-gradient-background has-background"><!-- wp:group {"layout":{"type":"flex","flexWrap":"nowrap","justifyContent":"center"}} -->
<div class="wp-block-group"><!-- wp:paragraph {"textColor":"palette-color-2"} -->
<p class="has-palette-color-2-color has-text-color"><strong><mark style="background-color:var(--paletteColor6, #F4F4F5)" class="has-inline-color">SUPER SECRET SAVINGS</mark></strong></p>
<!-- /wp:paragraph --></div>
<!-- /wp:group -->

<!-- wp:heading {"textAlign":"center","level":1,"textColor":"palette-color-8","className":"no-margin"} -->
<h1 class="has-text-align-center no-margin has-palette-color-8-color has-text-color">Black Friday Skincare Deal</h1>

kimcoleman

<!-- wp:group {"align":"full","backgroundColor":"color-primary"} -->
<div class="wp-block-group alignfull has-color-primary-background-color has-background"><!-- wp:group {"layout":{"type":"flex","flexWrap":"nowrap","justifyContent":"center"}} -->
<div class="wp-block-group"><!-- wp:shortcode -->
[pmpro_member field="avatar"]
<!-- /wp:shortcode -->

<!-- wp:heading {"textColor":"site-navigation-background"} -->
<h2 class="has-site-navigation-background-color has-text-color" id="h-welcome-pmpro-member-field-display-name">Welcome, [pmpro_member field="display_name"]</h2>
<!-- /wp:heading --></div>
<!-- /wp:group --></div>

kimcoleman

<!-- wp:paragraph -->
<p>Here are some resources you are free to use when you write about Sitewide Sales.</p>
<!-- /wp:paragraph -->

<!-- wp:group {"backgroundColor":"palette-color-6"} -->
<div class="wp-block-group has-palette-color-6-background-color has-background"><!-- wp:yoast-seo/table-of-contents -->
<div class="wp-block-yoast-seo-table-of-contents yoast-table-of-contents"><h2>Table of contents</h2><ul><li><a href="#logo" data-level="3">Official Logo</a></li><li><a href="#h-brand-colors" data-level="2">Brand Colors</a></li><li><a href="#h-screenshots" data-level="2">Screenshots</a><ul><li><a href="#h-product-screenshots" data-level="3">Product Screenshots</a></li><li><a href="#h-for-woocommerce" data-level="3">For WooCommerce</a></li><li><a href="#h-for-paid-memberships-pro" data-level="3">For Paid Memberships Pro</a></li><li><a href="#h-for-easy-digital-downloads" data-level="3">For Easy Digital Downloads</a></li></ul></li><li><a href="#h-founder-headshots" data-level="2">Founder Headshots</a></li></