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 = 238948 
  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 = 238948 
  AND (
    companies.status IN ('A') 
    OR products.company_id = 0
  ) 
GROUP BY 
  products.product_id

Query time 0.00395

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "5.38"
    },
    "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.40",
              "eval_cost": "0.10",
              "prefix_cost": "0.50",
              "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.24",
              "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.90",
              "eval_cost": "0.10",
              "prefix_cost": "2.24",
              "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": "3.02",
              "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": 3,
            "rows_produced_per_join": 3,
            "filtered": "100.00",
            "cost_info": {
              "read_cost": "0.75",
              "eval_cost": "0.30",
              "prefix_cost": "4.07",
              "data_read_per_join": "48"
            },
            "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": "0.75",
              "eval_cost": "0.02",
              "prefix_cost": "5.12",
              "data_read_per_join": "402"
            },
            "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.13",
              "eval_cost": "0.02",
              "prefix_cost": "5.27",
              "data_read_per_join": "260"
            },
            "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.05",
              "eval_cost": "0.02",
              "prefix_cost": "5.33",
              "data_read_per_join": "266"
            },
            "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.04",
              "eval_cost": "0.02",
              "prefix_cost": "5.38",
              "data_read_per_join": "3"
            },
            "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
238948 GI-238948-OMD P A 6667 6.50 25 0.008 0 0 0 0.00 0 1658045242 1667791106 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:0;s:9:"box_width";i:0;s:10:"box_height";i:0;} 0.000 0.120 2147483647 en Feminist-Protest Buttons/Badges-Crochet-Made to Order <p>Crocheted feminist protest button or badge. </p> <ol><li>Pro Roe</li><li>Hanger</li><li>Female Symbol</li><li>Vote</li><li>Beto</li></ol> <p>MORE GRAPHICS/DESIGNS COMING SOON!</p> <p>These pieces are made with acrylic yarn and can be worn as buttons or badges. I add crafters plastic inside for added rigidity and a safety catch back pin on the back.</p> <p>MADE TO ORDER.</p> <p>Materials: Materials: Acrylic yarn, medium worsted, 4 ply, sewing thread, safety catch back pin, crafters plastic, and glue.</p> <p>IMPORTANT: Please allow 1-2 weeks for me to complete custom handmade orders. In some cases however, completion may take over two weeks depending on my work load or difficulty level of pattern, particularly during peak season/the holidays.</p> <p>Please contact me if you need a custom order completed by a specific date, so we can work it out before you place an order.</p> <p>Once payment clears, I will purchase the materials needed to start on your custom order. In most cases, I have the materials in stock.</p> <p>Please keep in mind that it can take up to 2-5 business days for banks to process and post a credit/debit card payment, therefore delaying the process and completion time of your order.</p> <p>&nbsp;</p> <p>Please review the <a href="https://mamasophs.square.site/shop-policies" target="_blank" rel="noreferrer noopener">shop policies/FAQ</a>s for more info.</p> <p>&nbsp;</p> <p>If you have any questions or concerns, please do not hesitate to contact me.</p> <p>Thank you for taking the time to visit my shop! I appreciate your support.</p> <p>&nbsp;</p> <p>Love,</p> <p>Mama Sophs</p> <p></p> protest buttons, badges, crochet, handmade, feminist crafts Feminist-Protest Buttons/Badges-Crochet-Made to Order feminist, protest, buttons, badges, women's rights, human rights, reproductive rights, pro roe, roe v wade Feminist-Protest Buttons/Badges-Crochet-Made to Order <p>Please allow 1-2 weeks for me to complete custom handmade orders. In some cases however, completion may take over two weeks depending on my work load or difficulty level of pattern, particularly during peak season/the holidays.</p> <p> Please keep in mind that shipping delays can occur due to COVID-19, holiday rushes or closures, the graduation season rush, inclement weather conditions, or unforeseeable events that are out of my control.</p> <p> For more info, please read the shop policies and FAQ's.</p> <p>Thank you for your patience and understanding in this matter!</p> <p></p> <p>MADE TO ORDER.</p> <p>Materials: Materials: Acrylic yarn, medium worsted, 4 ply, sewing thread, safety catch back pin, crafters plastic, and glue.</p> 6.50000000 75M,15347,15348 1294 mamasophs Vintage, Art, & Crafts <p><strong>Shop Policies </strong></p> <p>I am honored to be part of the GoImagine community and dedicated to making your experience a fun and refreshing one. Whether it's through GoImagine, Square, Ko-Fi, or Facebook, I am really looking forward to getting to know you and serve you.</p> <p><br></p> <p><strong>Refunds and Exchanges <br></strong><strong></strong></p> <p>Generally, returns are not accepted for artwork, custom handmade items, personalized items, or digital downloads. However, if you are not satisfied with your order, please do not hesitate to contact me. We may be able to come to a friendly agreement depending on the nature of your issue. <br><br></p> <ul><li>In the event an agreement is made for a return, the customer is responsible for shipping cost. </li></ul> <ul><li>You must contact me within 14 days after delivery to qualify for a return. </li></ul> <ul><li>An item must be shipped back within 30 days of delivery (in the condition it was received). </li></ul> <ul><li>Exchanges not accepted at this time. </li></ul> <ul><li>Cancellations will be considered and handled accordingly. Customers may be subject to a cancellation fee if a custom handmade order, personalized item, or art piece is cancelled mid project. </li></ul> <ul><li>I do not offer store credit. </li></ul> <p></p> <p><strong>Payment </strong></p> <p> I am currently accepting electronic payments via the GoImagine shop. Payment methods include: Stripe.<br></p> <p><br></p> <ul><li>I offer a variety of avenues for customers to place an order and make a payment, other than Stripe.</li></ul> <ul><li>Accepted payment methods outside of the GoImagine platform include: PayPal, Square, Venmo, Cash App, and Facebook Pay. </li></ul> <ul><li>Gift cards are specific to a site and cannot be used outside of that platform. In other words, you cannot use a Square gift card to shop on GoImagine or vice versa. </li></ul> <ul><li>&nbsp;I do not accept phone orders.</li></ul> <ul><li>Due to Covid-19 I will not accept cash payments.</li></ul> <ul><li>I do not accept money orders or check payments.</li></ul> <ul><li>Depending on the platform you use, their website may offer different payment options at checkout that I have not listed.</li></ul> <ul><li>I do not add a handling fee or tax amount to final sale prices on handmade items, artwork, or digital downloads listed in the shop. However, taxes may be automatically included with your order according to your home State laws. It may also depend on the platform or payment app you choose to use at checkout. </li></ul> <p><br></p> <p> <strong>Shipping</strong></p> <p>In order to keep shipping prices to a minimum, I do not include packaging cost with the shipping price. In some cases, I reuse packaging materials in order to keep cost down on my end and to promote recycling. <br></p> <p><br></p> <ul><li>Most items are currently shipped via USPS, and include tracking/confirmation unless otherwise stated. I offer domestic shipping options and ship internationally. </li></ul> <ul><li>Shipping rates are based on the size and weight of an item/package and reflect the USPS, UPS, FedEx, or DHL calculations, according to location/destination. </li></ul> <p><br></p> <p> If you would like to add insurance to your package, please contact me before submitting a payment. This will allow me to update or reserve a listing to reflect the proper shipping price. &nbsp; <br></p> <p><br></p> <ul><li>For insurance, it will cost an additional $2.75. Rates may vary between shipping services and is subject to change.</li></ul> <ul><li>High-cost sales items will be insured automatically for my protection and yours. The cost of insurance is included in the final shipping price and noted in the listing.&nbsp; </li></ul> <ul><li>For international buyers, a Certificate of Mailing will automatically be included in the shipping price for an additional fee. </li></ul> <ul><li>Insurance is available for most international packages. Insurance is not provided for First-Class Package International Service (FCPIS).</li></ul> <ul><li>Tracking is available for most international packages. Tracking is available to select destinations for First-Class Package International Service (FCPIS). </li></ul> <ul><li>Expected delivery varies by destination. </li></ul> <ul><li>Customs form is required for shipping.</li></ul> <p><br></p> <ul><li>If you have a preference for a particular shipping service, please contact me and I will do my best to meet your needs. Please keep in mind that shipping delays can occur due to COVID-19, holiday rushes or closures, the graduation season rush, inclement weather conditions, or unforeseeable events that are out of my control. &nbsp; Once an item has left my shop/has shipped: I will not be responsible for delayed, lost, or stolen packages and/or damaged goods. However, if you should have any questions or concerns during transit time or after delivery, please do not hesitate to contact me. We may be able to work towards a friendly agreement, depending on the nature of the situation.</li></ul> <p><br></p> <p><strong>Additional Policies and FAQs</strong></p> <p>Aside from GoImagine, I run storefronts on other sites like Square, Ko-Fi, and Facebook. At this time the Facebook shop is linked to the Square site. I no longer offer direct checkout from their site. I am currently the only person running my business and do not have help from outside sources.</p> <p><br></p> <p><strong>Placing Orders Outside of GoImagine<br></strong></p> <p>If you'd like to place a custom/handmade order outside of GoImagine, <a href="https://mamasophs.square.site/" target="_blank">Square</a>, <a href="https://ko-fi.com/mamasophs" target="_blank">Ko-Fi</a>, or <a href="https://www.facebook.com/MamaSophsVintageArtCrafts" target="_blank" rel="noopener noreferrer">Facebook</a>, please do not hesitate to contact me.</p> <p><br></p> <p> <strong>Pick-up and Delivery</strong></p> <p> I do not hand deliver items to customers at this time or offer local delivery services. However, if you are local to Richardson, TX. or located in the DFW area, I am now offering customers porch pick-up (similar to marketplace pick-ups) in accordance with social distancing safety guidelines. Please keep in mind pick-up dates may vary, depending on the item you are purchasing. Non handmade items can be scheduled for same day pick-up or a later date depending on the time of day your order was placed. Handmade orders are subject to longer wait times. For added safety measures, you must provide information that will help me to identify you (Eg. make/model of vehicle) with your order note and text the number provided when you have arrived. If you have any questions or concerns, please don't hesitate to contact me before placing your order. <br><br></p> <ul><li>Payment must be received before pick-up.</li></ul> <ul><li>Due to Covid19, I cannot meet in person. </li></ul> <p> <strong><br></strong></p> <p><strong>Please Note: Handmade Items and Order Processing</strong></p> <p> All of the handmade items listed in the shop are crocheted by me and made to order. &nbsp; <strong><em><br></em></strong></p> <p><strong><em><br></em></strong></p> <p><strong><em>Please allow 1-2 weeks for me to complete a custom handmade order.</em></strong> In some cases, however, completion may take over two weeks depending on my work load or difficulty level of pattern, particularly during peak season/the holidays.&nbsp; <br></p> <p><br></p> <ul><li>Please contact me if you need a custom order completed by a specific date, so we can work it out before you place an order. </li></ul> <ul><li>Once payment clears, I will purchase the materials needed to start on your custom order. In most cases, I have the materials in stock.</li></ul> <ul><li>Please keep in mind that it can take up to 2-5 business days for banks to process and post credit/debit card payments, therefore delaying the process and completion time of your order.</li></ul> <ul><li>For faster processing time, I suggest making an instant payment via PayPal, Venmo, or CashApp (if those options are made available to you). </li></ul> <p><br></p> <p> For more information and to request a custom handmade order, please fill out a <a href="https://mamasophs.square.site/request-custom-order" target="_blank" rel="noopener noreferrer">request form</a> on my personal website or contact me here on GoImagine, and I will get back to your at my earliest convenience. Thank you for your patience and understanding in this matter!</p> <p> <strong><br></strong></p> <p><strong>Feedback</strong></p> <p> If you are happy with your experience, I encourage you to leave positive feedback for me. This will help other buyers know I am a responsible and reliable seller. <br></p> <p><br></p> <ul><li>For transparency purposes, you can access customer reviews via GoImagine, <a href="https://www.etsy.com/shop/mamasophs?ref=profile_header#reviews" target="_blank">Etsy</a>, <a href="https://www.facebook.com/MamaSophsVintageArtCrafts/reviews/?ref=page_internal" target="_blank" rel="noopener noreferrer">Facebook</a>, or <a href="https://www.trustpilot.com/review/mamasophs.square.site" target="_blank" rel="noopener noreferrer">TrustPilot</a>. At this time, I do not have the tools to display reviews on the Square site.&nbsp;</li></ul> <ul><li>If for any reason you are not satisfied with service and/or your order, please contact me with any questions or concerns before leaving negative or neutral feedback. I will be more than happy to work something out with you. </li></ul> <ul><li>Constructive criticism welcomed! In fact, I encourage it. This allows me to understand and correct an error, so I can work towards providing customers a pleasurable buying experience. </li></ul> <p><br></p> <p><strong>Privacy Settings&nbsp;</strong></p> <p><a href="https://www.freeprivacypolicy.com/live/e3c39c16-a975-424b-91de-b72a16ff9a5b" data-v-0b81e024="" target="_blank" rel="noopener noreferrer" class="w-button w-button--large w-button--text w-button--dark" data-v-ab1ca44a="">Click Here to Read Privacy Policy</a></p> <p><a href="https://www.freeprivacypolicy.com/live/e3c39c16-a975-424b-91de-b72a16ff9a5b" data-v-0b81e024="" target="_blank" rel="noopener noreferrer" class="w-button w-button--large w-button--text w-button--dark" data-v-ab1ca44a=""><br></a><br></p> <p><a href="https://www.freeprivacypolicy.com/live/e3c39c16-a975-424b-91de-b72a16ff9a5b" data-v-0b81e024="" target="_blank" rel="noopener noreferrer" class="w-button w-button--large w-button--text w-button--dark" data-v-ab1ca44a=""></a></p> <p><br></p> <h3> </h3> feminist-protest-buttons-badges-crochet-made-to-order 71/75 <p><em><strong>My Story</strong></em><br></p> <p><br>Hi! My name is Sophia. Nickname Sophs, or Mama Sophs to my closest friends and family. I was born and raised in El Paso, TX. My heart belongs to the mountains and the desert is my home, but I gravitated towards Dallas, Texas in 2001, and I now reside in Richardson, Texas. I absolutely miss those West Texas sunsets, the cool summer nights and clear skies-so clear you can see the stars shining bright at night! The rich culture of the border town, especially it's authentic Mexican food, is undoubtedly something to yearn for. More so, family and friends I left behind when I ventured out on my own. I do appreciate the diversity and sense of community living in a city like Richardson, Texas, however. I feel at home and have grown to love it here. It's like a part of my soul is drawn to the land from a distant past or memory.&nbsp;</p> <p><br></p> <p>I am a proud mother of three beautiful girls. One is headed to Jr. High School (Arts and Technology Magnet School) in the Fall, and the oldest just graduated from UCF with a BFA in Experimental Animation (Arts and Humanities). I have one fur baby- a cool cat named Trixie! She's a bit of a Trickster, but I still love her like a child. I just recently started homeschooling my two youngest, due to the pandemic. It can take a great deal of work to inspire their minds and creativity, but it's also fun and constructive. It's totally worth the effort to watch them learn and grow! However, after two years of attending virtual school and then homeschooling, they're ready and excited to return to public school in the Fall. I've been in a committed relationship with my partner Joey since 2001. That's half my lifetime! Yikes. We both worked for Starbucks when we first met and moved in together a month later. The rest is history!</p> <p></p> <p>I am a self taught artist and handcrafter. I first learned how to crochet when I was a little girl. I was taught by the best-my grandma! However, I didn't take my handcrafting skills to the next level until about 2010. I relied on YouTube videos to brush up on my knowledge and learn new techniques. Yea, for technology! I consider arts and crafts lifelong learning skills, and there is always room for growth and improvement. I took an interest in art at a young age that lead me on a path to creating abstract art. I didn't attend art classes growing up. Instead, I turned to art as a creative outlet. Art is not just a hobby to me, it's a healing process! My perception of art comes from deep within the center of my being-my heart, soul, and subconscious mind. I find art to be extremely therapeutic. It heals the soul! Crochet does wonders for me, just the same. As someone who struggles with mental illness, more specifically OCD, SA, and Depression, creating things with my hands keeps me grounded. I haven't caught on to knitting yet, but I've tried and hope to 'perfect' it one day. I'd like to learn how to make soap, incense, candles, and essential oils. I'm also considering writing a book someday. So much to learn and do, so little time in our lifetimes!</p> <p><br></p> <p>I love chocolate, wine, poetry, reading, board games, working on jigsaw puzzles, and geneology. My favorite pastime is gardening. I enjoy sitting out on the balcony (my happy place) during the Springtime and Fall (my two favorite seasons), while I indulge in the sights and sounds, and enjoy my balcony garden. I also love Netflixing. My favorite genres to watch are all things paranormal and horror, Sci-Fi, psychological thrillers, and comedy. I enjoy listening to a wide array of musical genres, including punk, ska, reggae, rockabilly, industrial, electronic, techno, classic country, indie, and so much more.</p> <p><strong><br></strong></p> <p><em><strong>Additional Information</strong></em><br></p> <p><br>All of the handmade items you see in the shop are crocheted by me. Handmade with love and care! After taking a much needed break and a one year hiatus, I decided it was time to start taking custom orders again. The pandemic and personal health issues really took a toll on me the past few years. So unfortunately, I didn't get around to creating new projects like I had planned on doing during the shutdown. My goal is to bring a few project ideas to life within the next few months or so. I'm also considering writing and possibly sharing patterns with followers/subscribers, and perhaps even sell some of them. Believe it or not, I've never taken the time to write my patterns down. Yowzers! It's time. <br></p> <p><br></p> <p>As of yet, I am currently the only person running my small business and do not have help from outside sources. I'm my own boss! How cool is that? Truth is, it can be overwhelming at times. Learning to balance it all is a must, especially at a time when hobbyist or small businesses are expected to mass produce items, and everyone wants instant gratification. <br></p> <p><br></p> <p>Aside from GoImagine, I run storefronts on other sites like <a href="https://mamasophs.square.site/" target="_blank">Square</a>, <a href="https://ko-fi.com/mamasophs" target="_blank">Ko-Fi</a>, <a href="https://handmadeartists.com/shop/mamasophs" target="_blank">Handmade Artists</a>, and <a href="https://www.facebook.com/MamaSophsVintageArtCrafts">Facebook</a>. I was a seller on Etsy for about 10 years, but recently decided it was time for a change and closed shop. In my spare time, I am a paranormal investigator with a local non-profit organization (<a href="https://www.asupinc.org/" target="_blank" rel="noopener noreferrer">ASUP, Inc.</a>, TAPS Family Member) that I have been involved with since 2008. On occasion I will join my team members out in the field to investigate an active case. I mostly work remotely from home. I previously held the title: Team Lead, Audio Evidence, and volunteered briefly on the research team. I am currently the Website and Social Media Manager.&nbsp;I'm also a wedding officiant, and #OCDvocate.</p> <p><br></p> <p> </p> <p>I love what GoImagine stands for and I am honored to be part of the community. I'm dedicated to making your experience a fun and refreshing one! Whether it's through GoImagine, Square, Ko-Fi, Handmade Artists, or Facebook, I am really looking forward to getting to know you and serve you.</p> <p><br></p> <p>Thanks for taking the time to visit my shop! I truly appreciate your support.</p> <p>Love, Mama Sophs</p> <p><br><a href="https://mamasophs.square.site/s/stories" target="_blank">Read More Stories</a><br></p> <p></p> <p></p> <p></p> D