Sandbox

SELECT 
  products.*, 
  product_descriptions.*, 
  MIN(
    IF(
      product_prices.percentage_discount = 0, 
      product_prices.price, 
      product_prices.price - (
        product_prices.price * product_prices.percentage_discount
      )/ 100
    )
  ) as price, 
  GROUP_CONCAT(
    CASE WHEN (
      products_categories.link_type = 'M'
    ) THEN CONCAT(
      products_categories.category_id, 
      'M'
    ) ELSE products_categories.category_id END 
    ORDER BY 
      categories.storefront_id IN (0, 1) DESC, 
      (
        products_categories.link_type = 'M'
      ) DESC, 
      products_categories.category_position ASC, 
      products_categories.category_id ASC
  ) as category_ids, 
  popularity.total as popularity, 
  company_descr.i18n_company as company_name, 
  cd.terms, 
  seo_names.name as seo_name, 
  seo_names.path as seo_path, 
  company_descriptions.company_description, 
  discussion.type as discussion_type 
FROM 
  products 
  LEFT JOIN product_prices ON product_prices.product_id = products.product_id 
  AND product_prices.lower_limit = 1 
  AND product_prices.usergroup_id IN (0, 0, 1) 
  LEFT JOIN product_descriptions ON product_descriptions.product_id = products.product_id 
  AND product_descriptions.lang_code = 'en' 
  LEFT JOIN company_descriptions as company_descr ON company_descr.company_id = products.company_id 
  AND company_descr.lang_code = 'en' 
  LEFT JOIN companies as companies ON companies.company_id = products.company_id 
  INNER JOIN products_categories ON products_categories.product_id = products.product_id 
  INNER JOIN categories ON categories.category_id = products_categories.category_id 
  AND categories.storefront_id IN (0, 1) 
  AND (
    categories.usergroup_ids = '' 
    OR FIND_IN_SET(0, categories.usergroup_ids) 
    OR FIND_IN_SET(1, categories.usergroup_ids)
  ) 
  AND (
    products.usergroup_ids = '' 
    OR FIND_IN_SET(0, products.usergroup_ids) 
    OR FIND_IN_SET(1, products.usergroup_ids)
  ) 
  AND categories.status IN ('A', 'H') 
  AND products.status IN ('A', 'H') 
  LEFT JOIN product_popularity as popularity ON popularity.product_id = products.product_id 
  LEFT JOIN company_descriptions AS cd ON cd.company_id = products.company_id 
  AND cd.lang_code = 'en' 
  LEFT JOIN seo_names ON seo_names.object_id = 259825 
  AND seo_names.type = 'p' 
  AND seo_names.dispatch = '' 
  AND seo_names.lang_code = 'en' 
  LEFT JOIN company_descriptions AS company_descriptions ON company_descriptions.company_id = products.company_id 
  AND company_descriptions.lang_code = 'en' 
  LEFT JOIN discussion ON discussion.object_id = products.product_id 
  AND discussion.object_type = 'P' 
WHERE 
  products.product_id = 259825 
  AND (
    companies.status IN ('A') 
    OR products.company_id = 0
  ) 
GROUP BY 
  products.product_id

Query time 0.00641

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "8.36"
    },
    "grouping_operation": {
      "using_filesort": false,
      "nested_loop": [
        {
          "table": {
            "table_name": "products",
            "access_type": "const",
            "possible_keys": [
              "PRIMARY",
              "status",
              "idx_company_id",
              "idx_usergroup_ids"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "product_id"
            ],
            "key_length": "3",
            "ref": [
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 1,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "0.00",
              "eval_cost": "0.10",
              "prefix_cost": "0.00",
              "data_read_per_join": "4K"
            },
            "used_columns": [
              "product_id",
              "product_code",
              "product_type",
              "status",
              "company_id",
              "list_price",
              "amount",
              "weight",
              "length",
              "width",
              "height",
              "shipping_freight",
              "low_avail_limit",
              "timestamp",
              "updated_timestamp",
              "usergroup_ids",
              "is_edp",
              "edp_shipping",
              "unlimited_download",
              "tracking",
              "free_shipping",
              "zero_price_action",
              "is_pbp",
              "is_op",
              "is_oper",
              "is_returnable",
              "return_period",
              "avail_since",
              "out_of_stock_actions",
              "localization",
              "min_qty",
              "max_qty",
              "qty_step",
              "list_qty_count",
              "tax_ids",
              "age_verification",
              "age_limit",
              "options_type",
              "exceptions_type",
              "details_layout",
              "shipping_params",
              "weight_lbs",
              "weight_oz",
              "product_tax_code",
              "deleted_at",
              "archived_at",
              "position"
            ]
          }
        },
        {
          "table": {
            "table_name": "popularity",
            "access_type": "const",
            "possible_keys": [
              "PRIMARY",
              "total"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "product_id"
            ],
            "key_length": "3",
            "ref": [
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 1,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "0.00",
              "eval_cost": "0.10",
              "prefix_cost": "0.00",
              "data_read_per_join": "32"
            },
            "used_columns": [
              "product_id",
              "total"
            ]
          }
        },
        {
          "table": {
            "table_name": "cd",
            "access_type": "const",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "company_id",
              "lang_code"
            ],
            "key_length": "10",
            "ref": [
              "const",
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 1,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "0.00",
              "eval_cost": "0.10",
              "prefix_cost": "0.00",
              "data_read_per_join": "1K"
            },
            "used_columns": [
              "company_id",
              "lang_code",
              "terms"
            ]
          }
        },
        {
          "table": {
            "table_name": "product_prices",
            "access_type": "ref",
            "possible_keys": [
              "usergroup",
              "product_id",
              "lower_limit",
              "usergroup_id"
            ],
            "key": "product_id",
            "used_key_parts": [
              "product_id"
            ],
            "key_length": "3",
            "ref": [
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 1,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "0.34",
              "eval_cost": "0.10",
              "prefix_cost": "0.44",
              "data_read_per_join": "24"
            },
            "used_columns": [
              "product_id",
              "price",
              "percentage_discount",
              "lower_limit",
              "usergroup_id"
            ],
            "attached_condition": "<if>(is_not_null_compl(product_prices), ((`goimagine`.`product_prices`.`lower_limit` = 1) and (`goimagine`.`product_prices`.`usergroup_id` in (0,0,1))), true)"
          }
        },
        {
          "table": {
            "table_name": "product_descriptions",
            "access_type": "const",
            "possible_keys": [
              "PRIMARY",
              "product_id"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "product_id",
              "lang_code"
            ],
            "key_length": "11",
            "ref": [
              "const",
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 1,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "0.64",
              "eval_cost": "0.10",
              "prefix_cost": "1.18",
              "data_read_per_join": "5K"
            },
            "used_columns": [
              "product_id",
              "lang_code",
              "product",
              "shortname",
              "short_description",
              "full_description",
              "meta_keywords",
              "meta_description",
              "search_words",
              "page_title",
              "age_warning_message",
              "promo_text",
              "cls_stop_words",
              "how_its_made",
              "custom_header"
            ]
          }
        },
        {
          "table": {
            "table_name": "company_descr",
            "access_type": "const",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "company_id",
              "lang_code"
            ],
            "key_length": "10",
            "ref": [
              "const",
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 1,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "0.89",
              "eval_cost": "0.10",
              "prefix_cost": "2.17",
              "data_read_per_join": "1K"
            },
            "used_columns": [
              "company_id",
              "lang_code",
              "i18n_company"
            ]
          }
        },
        {
          "table": {
            "table_name": "companies",
            "access_type": "const",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "company_id"
            ],
            "key_length": "4",
            "ref": [
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 1,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "0.68",
              "eval_cost": "0.10",
              "prefix_cost": "2.95",
              "data_read_per_join": "14K"
            },
            "used_columns": [
              "company_id",
              "status"
            ],
            "attached_condition": "<if>(found_match(companies), ((`goimagine`.`companies`.`status` = 'A') or false), true)"
          }
        },
        {
          "table": {
            "table_name": "products_categories",
            "access_type": "ref",
            "possible_keys": [
              "PRIMARY",
              "pt"
            ],
            "key": "pt",
            "used_key_parts": [
              "product_id"
            ],
            "key_length": "3",
            "ref": [
              "const"
            ],
            "rows_examined_per_scan": 7,
            "rows_produced_per_join": 7,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "1.79",
              "eval_cost": "0.70",
              "prefix_cost": "5.44",
              "data_read_per_join": "112"
            },
            "used_columns": [
              "product_id",
              "category_id",
              "link_type",
              "category_position"
            ]
          }
        },
        {
          "table": {
            "table_name": "categories",
            "access_type": "eq_ref",
            "possible_keys": [
              "PRIMARY",
              "c_status",
              "p_category_id"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "category_id"
            ],
            "key_length": "3",
            "ref": [
              "goimagine.products_categories.category_id"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 0,
            "filtered": "5.00",
            "cost_info": {
              "read_cost": "1.75",
              "eval_cost": "0.04",
              "prefix_cost": "7.89",
              "data_read_per_join": "938"
            },
            "used_columns": [
              "category_id",
              "usergroup_ids",
              "status",
              "storefront_id"
            ],
            "attached_condition": "((`goimagine`.`categories`.`storefront_id` in (0,1)) and ((`goimagine`.`categories`.`usergroup_ids` = '') or (0 <> find_in_set(0,`goimagine`.`categories`.`usergroup_ids`)) or (0 <> find_in_set(1,`goimagine`.`categories`.`usergroup_ids`))) and (`goimagine`.`categories`.`status` in ('A','H')))"
          }
        },
        {
          "table": {
            "table_name": "seo_names",
            "access_type": "ref",
            "possible_keys": [
              "PRIMARY",
              "dispatch"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "object_id",
              "type",
              "dispatch",
              "lang_code"
            ],
            "key_length": "206",
            "ref": [
              "const",
              "const",
              "const",
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 0,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "0.29",
              "eval_cost": "0.04",
              "prefix_cost": "8.22",
              "data_read_per_join": "607"
            },
            "used_columns": [
              "name",
              "object_id",
              "type",
              "dispatch",
              "path",
              "lang_code"
            ]
          }
        },
        {
          "table": {
            "table_name": "company_descriptions",
            "access_type": "const",
            "possible_keys": [
              "PRIMARY"
            ],
            "key": "PRIMARY",
            "used_key_parts": [
              "company_id",
              "lang_code"
            ],
            "key_length": "10",
            "ref": [
              "const",
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 0,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "0.04",
              "eval_cost": "0.04",
              "prefix_cost": "8.30",
              "data_read_per_join": "621"
            },
            "used_columns": [
              "company_id",
              "lang_code",
              "company_description"
            ]
          }
        },
        {
          "table": {
            "table_name": "discussion",
            "access_type": "const",
            "possible_keys": [
              "object_id"
            ],
            "key": "object_id",
            "used_key_parts": [
              "object_id",
              "object_type"
            ],
            "key_length": "6",
            "ref": [
              "const",
              "const"
            ],
            "rows_examined_per_scan": 1,
            "rows_produced_per_join": 0,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "0.03",
              "eval_cost": "0.04",
              "prefix_cost": "8.37",
              "data_read_per_join": "8"
            },
            "used_columns": [
              "object_id",
              "object_type",
              "type"
            ]
          }
        }
      ]
    }
  }
}

Result

product_id	product_code	product_type	status	company_id	list_price	amount	weight	length	width	height	shipping_freight	low_avail_limit	timestamp	updated_timestamp	usergroup_ids	is_edp	edp_shipping	unlimited_download	tracking	free_shipping	zero_price_action	is_pbp	is_op	is_oper	is_returnable	return_period	avail_since	out_of_stock_actions	localization	min_qty	max_qty	qty_step	list_qty_count	tax_ids	age_verification	age_limit	options_type	exceptions_type	details_layout	shipping_params	weight_lbs	weight_oz	product_tax_code	deleted_at	archived_at	position	lang_code	product	shortname	short_description	full_description	meta_keywords	meta_description	search_words	page_title	age_warning_message	promo_text	cls_stop_words	how_its_made	custom_header	price	category_ids	popularity	company_name	terms	seo_name	seo_path	company_description	discussion_type
259825	GI-259825-LVU	P	A	7548	9.95	6	0.438	0	0	0	0.50	0	1667619508	1680836697	0	N	N	N	B	N	R	N	N	N	Y	10	0	N		0	0	0	0		N	0	P	F		a:5:{s:16:"min_items_in_box";i:0;s:16:"max_items_in_box";i:0;s:10:"box_length";i:8;s:9:"box_width";i:8;s:10:"box_height";i:3;}	0.000	7.000				2147483647	en	Peace			<p><b><span style="color: rgb(118, 146, 60);"><span style="color: rgb(127, 127, 127);"><br></span></span></b></p> <p><b><span style="color: rgb(118, 146, 60);"><span style="color: rgb(127, 127, 127);">FROM OUR CARING COLLECTION:</span>   </span></b><br></p> <p><strong><span style="color: rgb(12, 12, 12);"><b>PEACE -  With this fragrance, we've perfectly recreated the iconic, signature fragrance of the Peace, Love Generation.  From the first whiff, it takes you back in time, to the music of Woodstock, when hip hugger jeans, long haired young men and women with flowers in their hair, were the signs of the time.</b>   "Peace" embodies that time, with a perfect pairing of sweet herbs, warm spices and woody, smoky notes, creating a laid back, spa-like fragrance, that's a little bit intoxicating, and a whole lot Hippie, as it should be.  </span></strong><br></p> <p><b><span style="color: rgb(118, 146, 60);">A PORTION OF THE PROCEEDS FROM ALL OF OUR "PEACE" PRODUCTS, BENEFIT </span></b><b><span style="color: rgb(118, 146, 60);">VETERAN'S  PTSD  PROGRAMS </span></b><strong></strong></p> <p><strong style="color: rgb(118, 146, 60);"><br></strong></p> <p><span style="color: rgb(127, 127, 127);"><strong><span style="color: rgb(127, 127, 127);">Listing is for Wax Melts Only.  All other products shown are</span></strong> <b>Sold Separately</b></span></p> <p><b><span style="color: rgb(127, 127, 127);">Artisan crafted, in small batches, our Wax Melt Crumbles are a blend of natural coconut wax, highly scented with unique luxury fragrances  that are stronger, longer lasting, and will fill your space with beautiful fragrance.  Use as a flameless alternative to a traditional candle, for a soot free, fume free and residue free product, providing a cleaner, easier breathing home.</span></b></p> <p><b><span style="color: rgb(127, 127, 127);">Presented in crumble form, simply pour out the desired amount into your wax to scent your space, and your own personal style. </span></b></p> <p><b><span style="color: rgb(127, 127, 127);">Phthalate and Paraben Free - Vegan - Cruelty Free   -    <b>Two Sizes:  Choose Medium 2.5+ oz, or Large 4+ oz</b></span></b></p> <p><b><span style="color: rgb(54, 96, 146);">Save your container...Refills are available.  </span></b></p> <p><br><br></p>	Aromatherapy, Wax Melts, Candles, Flameless, Fragrance, Gift, Holiday, Birthday, Mom, Daughter, Sister, friend, Co-Worker		Aromatherapy, Wax Melts, Flameless, Candle, Home, Fragrance, Gift, Holiday, Birthday, Mom, Mother, Daughter, Sister, Aunt, Teacher, Friend, Co-Worker			<p>3-7 Days Processing and delivery to shipping carrier. If you need faster shipping, please contact us prior to completing your order at; hello@withlovedavid.com. Once shipped, delivery is the responsibility of the carrier, please monitor for tracking and delivery updates.</p>		<p>Artisan crafted in small batches, with ethically sourced coconut wax, and vegan, cruelty free, phthalate and paraben free, fragrance oil.  Created to ensure a greener,  eco-friendly alternative to traditional candles, our Wax Melts are flameless, and soot free, for a cleaner, easier breathing home.  </p>		9.95000000	273M,291,19100,19102,19105,19215,19247	1323	With Love, David	<h2>Inquiries:</h2> <p>For questions, or additional information on our products, service policies or, if you're interested in  offering our products in your shops and markets, please email us at: </p> <p>hello@WithLoveDavid.com</p> <p><strong>FOR WHOLESALE INQUIRIES - </strong>please include the word  "Wholesale" in the email subject header, and include your full business name, address, contact information and type of business (retail, online only, store front, craft fairs, seasonal, year round etc.).    A copy of your Business License and/or Tax Resale Certificate, with your email is appreciated.  </p> <p>Our business hours are Monday-Friday, 9am to 4 pm CST, on Saturdays  9am to noon, and closed Sundays and Holidays.   We do our best to respond to all inquiries as quickly as possible, but please allow 24-48 hours for email response.  As always, we appreciate you!</p> <p>Sincerely,</p> <p>With Love, David</p> <p><strong><br></strong></p> <h2>Returns, Damages and Shipping:<strong style="color: rgb(51, 51, 51); font-size: 16px;">  </strong></h2> <p><b>DAMAGED PRODUCT:  DURING DELIVERY</b></p> <p>If upon arrival, any part or all of your order is damaged, please email us at:  <strong>h</strong><strong>ello@WithLoveDavid.com</strong>  <strong>within 7 days of receipt of product</strong>.  </p> <p>Please state "Damage/Replace" in your subject line of your email.  Please include your order number and multiple pictures, from all 4 sides, plus top and bottom, of both the packaging, and the damaged product.  Within 24-48 hours of receipt of your email, our customer service staff will be in contact with you for further information, and to facilitate our claims process.   </p> <p>Customer is required to retain all packaging, and product, until return instructions are provided, in writing, by <em>With Love, David</em>.  Failure to retain product and packaging, will void request for refund or reimbursement of return shipping.  No exceptions.    Customer to return at customer expense.  Please provide return tracking # so we can watch for your package to arrive.  Customer must also provide copy of receipt of return postage costs, for consideration of reimbursement, once damage claim is processed.   </p> <p><em>Please note</em>:   Products damaged due to exposure, extremes in temperature upon delivery, or packages that are lost or stolen, after delivery has been made, are not eligible for refund claims processing.  Once the product is removed from its protective packaging, we are not responsible for any further damage caused by poor product handling. </p> <p><b>FULL-PRICE ITEMS:</b><br>We hope you are 100% satisfied with your <em>With Love, David</em> purchase. If there is any reason you are not completely satisfied, <em>With Love, David</em>, is happy to offer a No Hassle Refund Policy, for full price purchase, product only, when purchased directly from <em>With Love, David,</em>  and returned unopened, unused, and in original packaging, within <em>10 days of your delivery date</em>.  Customer is responsible for return shipping/handling costs.   On receipt of returned product, <em>With Love David</em>, will inspect product and notify you within 48-72 hours of refund status.  Shipping costs are non-refundable.  </p> <p>To start return:  Please email us at:   <em>h</em><em>ello@WithLoveDavid.com</em>.  Please state "Return" in the subject line, and reference your order number, and order confirmation from your purchase, in your email.  Also include the reason for your return.  </p> <p><strong>FINAL RETURN APROVA</strong>L<em>:   </em></p> <p><em>All  returned products</em>, will be inspected on return receipt at <em>With Love, David, </em>before final approval of refund is granted.   You will be notified within 48-72 hours of refund status, (excluding weekends and holidays).  Product must be returned in new, unopened, unused condition, and in original packaging.  Please be careful to pack your return items for safe transit.  Items received damaged on return, due to improper packaging by customer, are not eligible for refund.     Please contact us at "hello@WithLoveDavid.com" with any questions or concerns.    </p> <p><span class="elementor-icon-list-text">                                                                                                           </span><br><b>RETURN PROCESSING:  Approved and Unauthorized Returns</b><br><span class="elementor-icon-list-text">Please email <em>h</em><em>ello@WithLoveDavid.com, </em>to initiate a return request<em>.  </em>  Please state "Return" and reason for return, in the subject line, and reference your order number, and your order confirmation from your purchase, in your email.    <strong>Pr</strong><strong>oduct returned to <em>With Love, David, </em>for any reason<em>,</em> without prior return authorization, are not eligible for refund.  In the very rare event an unauthorized return is approved for refund, all shipping costs, as well as a 35% restocking fee will be deducted from any refund amount.</strong>  If the reason for your return is not the result of an error by "With Love, David", all shipping costs, as well as a 15% restocking fee will be deducted from any refund amount.  The <em>cost of return shipping will be at customer expense.  </em> In this instance, we recommend using a tracked service.</span><span class="elementor-icon-list-text"><br></span><br><b>Combined Shipping and Shipping Differentials:  </b><br>It is sometimes difficult to calculate shipping costs on multiple items, and <em>With Love, David,</em> looks at this when putting together your order.  In the event you purchase multiple items in one order, and with one delivery address only, <em>With Love, David</em>, will combine your shipping as effectively as  possible for a safe, efficient delivery of your items, and in the most cost effective manner possible.  In the event there is a shipping differential in excess of $2.50, a credit will be processed. </p> <p><br></p>	peace-wax-melt-crumbles	4/99/273	<p>Hi. Thanks for stopping by to learn a bit about me, and the motivation behind "With Love, David".  </p> <p>I've always loved creating, and sold at markets and fairs for quite a number of years, until life took over, putting the creator in me aside for a while.  Then, several years ago, I developed an auto-immune disease, one that required me to put my favorite lotions, potions, cleaners and fragrances aside.  That's no fun, so the creator in me got back to work, with a goal to create  natural products that would moisturize, and sooth my skin.  Along the way, I discovered  many products I used in my home, were also impacting my health, and decided to do the same for my home, that I was doing for my skin, and work began to create natural products, that clean, freshen and scent my home, without harsh chemicals, fumes, soot or oily residue.  Through plenty of trials, setbacks, and steps forward, I've created a line of products that are doing exactly what I had hoped, and my home is becoming a cleaner, easier breathing, and better living home.  Best of all, my skin is a lot less angry, and much easier to get along with!  </p> <p>Now, it's time to introduce my products to the wider, online audience, and I'll be adding them slowly, over the next several months.   I chose Go Imagine for this venture because I love their mission of giving back.  For me, it's a blessing to be a blessing, and I'm proud to be a part of the GI story.  Our products you see here, also help raise funds for programs near, and dear to us at "With Love, David", and includes Breast Cancer Awareness, and Veterans programs, such as Camp Hope, who provide support for Veterans suffering PTSD, and for Wreaths Across America, a national event held each year to remember, and honor our Veterans who have completed their walk, and are now at rest.  </p> <p>We're happy to be here, and look forward to bringing you cleaner, healthier products for your home and family.   Please feel free to reach out with any questions, or to share your thoughts with us at:  hello@withlovedavid.com  </p> <p>With Love, David</p> <p><br></p> <p><em><span style="color: rgb(127, 127, 127);"> Wreaths Across America is a national effort to remember, and honor Veterans who lay at rest across the country, with a live wreath placed at their gravesite in remembrance of all they gave, including the wreath placed at the Tomb of the Unknown Soldier, in Arlington National Cemetery.   If you would like to join us in honoring a Veteran, I would love to count you as a sponsoring member of my "A Grateful American" group.  Sponsorships are $15.00 each, are fully tax deductible, and can be completed in just a few minutes, by clicking on the dark blue, "Sponsor a Wreath Here" button, at the bottom of my Wreaths Across American page at  </span></em> <a href="https://waahouston.salsalabs.org/2023/p/agratefulamericanrickistockwellsgroup/">https://waahouston.salsalabs.o...</a></p>	D