SELECT 
  cscart_product_descriptions.product_id, 
  cscart_product_descriptions.short_description, 
  IF(
    cscart_product_descriptions.short_description = '' 
    OR cscart_product_descriptions.short_description IS NULL, 
    cscart_product_descriptions.full_description, 
    ''
  ) AS full_description 
FROM 
  cscart_product_descriptions 
WHERE 
  cscart_product_descriptions.product_id IN (
    29862, 29877, 29876, 29875, 29863, 29867, 
    29865, 29860, 29859, 29872, 29890, 
    29861, 29879, 29905, 29892, 29871, 
    29891, 29881
  ) 
  AND cscart_product_descriptions.lang_code = 'en'

Query time 0.00117

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "31.39"
    },
    "table": {
      "table_name": "cscart_product_descriptions",
      "access_type": "range",
      "possible_keys": [
        "PRIMARY",
        "product_id"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "product_id",
        "lang_code"
      ],
      "key_length": "9",
      "rows_examined_per_scan": 18,
      "rows_produced_per_join": 18,
      "filtered": "100.00",
      "index_condition": "((`cscartdb`.`cscart_product_descriptions`.`product_id` in (29862,29877,29876,29875,29863,29867,29865,29860,29859,29872,29890,29861,29879,29905,29892,29871,29891,29881)) and (`cscartdb`.`cscart_product_descriptions`.`lang_code` = 'en'))",
      "cost_info": {
        "read_cost": "29.59",
        "eval_cost": "1.80",
        "prefix_cost": "31.39",
        "data_read_per_join": "68K"
      },
      "used_columns": [
        "product_id",
        "lang_code",
        "short_description",
        "full_description"
      ]
    }
  }
}

Result

product_id short_description full_description
29859 FREE USPS REGULAR SHIPPING WITHIN THE USA! Get any of our two lip products in a special Gift Set! Just provide names of ANY of our two lip products! The set includes: - Two ANY of our full size lip products (you acn add more upon request), - Card with your personalized message, - Reusable gift box (no logos) We will wrap the gift using supplies like crinkled paper, ribbon, clear wrap, etc to make your gift look special. *Please note that gift wrapping supplies may vary upon availability. Processing time is 5 to 8 business days. Please choose Priority shipping if you need to get it asap. All our products are handmade per order and we don't keep any products in stock. Everything is custom made and we don't offer refunds or replacements. Please reach out if you have any questions.
29860 Sinful is a rich, all natural mineral eye shadow, and is shimmery burgundy with brownish tone. VEGAN! Ingredients: -Mica -Copper Powder -Titanium Dioxide -Silicon Dioxide -Tin Oxide All our eye shadows are free of parabens and other harsh chemicals, and are great for sensitive skin. Our eye shadows can be used dry for softer look, or wet for foiling or more dramatic look. Try using a primer prior to application of eye shadows. It is hard to convey an exact color of this eye shadow, since it is shimmery and camera doesn't capture it very well. Please note that colors may vary depending on your monitor and its settings. Sold in a 5 gr jar with a black lid, and contains approximately 1 gr of powder eye shadow. Please check our "Special Offers" section for bundles and sets of multiple products. Feel free to contact us if you have any further questions.
29861 Get samples of our lipsticks and/or lip glosses of your choice and mention the names of the products you'd like in the "note to FierceMagenta" box at checkout. This offer does NOT include eye shadows and FLATTE MATTEs. All samples (glosses and lipsticks) come in jars (aprox 1-2 gr of product in each) and are sold by weight, not volume. Jars may vary. This is a great way to try out multiple products and see which ones you like before committing to full size. Or, get them as party favors for a Birthday, bachelorette party, wedding, or any other event! Please mention the names of products in "notes" at check-out. We're always happy to assist! Please contact us if you have any questions. KINDLY NOTE: There will be NO REFUNDS or exchanges on lip products.
29862 US ORDERS $35 AND UP SHIP FREE WITH USPS STANDARD SHIPPING! Look fierce with this pearlescent white sheer to semi-sheer lipstick! "WinterFrost" can be used by itself or over your favorite lipstick to add shimmer, as well as a highlighter. It is lightweight, non greasy, and will give your lips a healthy, moisturized and soft look. Color may vary depending on your monitor and its settings. FRESH, HANDMADE PER ORDER! (we do not keep any of our products in stock). For multiple quantities and samples please check our "Special Offers" Section. GLUTEN FREE! NO HARSH CHEMICALS, NO PARABENS! NO FLAVORINGS, NO DEODORIZERS! (please note that the smell is of oils and butters that are the ingredients of our products). FRESH, HANDMADE PER ORDER FROM OUR OWN SIGNATURE LIPSTICK BASE! (we do not keep any of our products in stock) NOT VEGAN! (contains beeswax!) Our makeup is handcrafted with only high quality ingredients. The ingredients are: -coconut butter, -cocoa butter -jojoba oil -olive oil -beeswax -micro-crystalline wax -mica -titanium dioxide -tin oxide -calcium sodium borosilicate (in glitters) NOTE: There will be NO REFUNDS OR REPLACEMENTS on lip products. Please check Policies section of the shop for more details. The expiration date for all of our lipsticks is 3 months from purchase date, since they are made from natural ingredients. Please keep in mind that these are made of handmade natural base, and are more sensitive than regular lip products. Keeping it in a dry, cool, and dark place (even the fridge) may prolong the shelf life. ***************************************************************************************************** Color may vary depending on your monitor settings. MELT WARNING This product will melt in the heat. It doesn't damage the product, but may cause the lipstick to leak or get stuck in the cap. So try not to leave it in your car during the summer, or any other hot spots. We cannot guarantee this product will arrive unharmed from heat, especially during the summer months. Please do not hesitate to contact us if you have any questions.
29863 US ORDERS $35 AND UP SHIP FREE WITH USPS STANDARD SHIPPING! Lilith is an opaque, creamy with satin finish purple lipstick that has a pink undertone and stains your lips. It may appear more blue on some monitors, so please check via few (your PC, laptop, phone, tablet, etc). Keep in mind that color may vary depending on your monitor and its settings. FRESH, HANDMADE PER ORDER! (we do not keep any of our products in stock). For multiple quantities and samples, please check our "Special Offers" Section. GLUTEN FREE! NO HARSH CHEMICALS, NO PARABENS! NO FLAVORINGS, NO DEODORIZERS! (please note that the smell is of oils and butters that are the ingredients of our products). FRESH, HANDMADE PER ORDER FROM OUR OWN SIGNATURE LIPSTICK BASE! (we do not keep any of our products in stock). NOT VEGAN! (contains beeswax!) Our makeup is handcrafted with only high quality ingredients. The ingredients are: -coconut butter, -cocoa butter -jojoba oil -olive oil -beeswax -micro-crystalline wax -mica -titanium dioxide -iron oxide -blue 1 -red 27 -red 7 NOTE: There will be NO REFUNDS OR REPLACEMENTS on lip products. Please check Policies section of the shop for more details. The expiration date for all of our lipsticks is 3 months from purchase date, since they are made from natural ingredients. Please keep in mind that these are made of handmade natural base, and are more sensitive than regular lip products. Keeping it in a dry, cool, and dark place (even the fridge) may prolong the shelf life. ***************************************************************************************************** MELT WARNING This product will melt in the heat. We cannot guarantee this product will arrive unharmed from heat, especially during the summer months. Please do not hesitate to contact us if you have any questions.
29865 US ORDERS $35 AND UP SHIP FREE WITH USPS STANDARD SHIPPING! Look fierce with this highly pigmented, black with blue tone lipstick! It is lightweight, non greasy, and will give your lips a healthy, moisturized and soft look. Color may vary depending on your monitor settings. FRESH, HANDMADE PER ORDER! (we do not keep any of our products in stock). For multiple quantities and samples, please check our "Special Offers" Section. GLUTEN FREE! NO HARSH CHEMICALS, NO PARABENS! NO FLAVORINGS, NO DEODORIZERS! (please note that the smell is of oils and butters that are the ingredients of our products). FRESH, HANDMADE PER ORDER FROM OUR OWN SIGNATURE LIPSTICK BASE! (we do not keep any of our products in stock). NOT VEGAN! (contains beeswax!) Our makeup is handcrafted with only high quality ingredients. The ingredients are: -coconut butter, -cocoa butter -jojoba oil -olive oil -beeswax -micro-crystalline wax -mica -titanium dioxide -iron oxide -hydrogenated polyisobutene -palmitic acid -blue 1 Photos 3,4 and 5 are courtesy of MoonShineApparel. There will be NO REFUNDS OR REPLACEMENTS on lip products. Please check Policies section of the shop for more details_ The expiration date for all of our lipsticks is 3 months from purchase date, since they are made from natural ingredients. Please keep in mind that these are made of handmade natural base, and are more sensitive than regular lip products. Keeping it in a dry, cool, and dark place (even the fridge) may prolong the shelf life. ***************************************************************************************************** Color may vary depending on your monitor settings. MELT WARNING This product will melt in the heat. It doesn't damage the product, but may cause the lipstick to leak or get stuck in the cap. So try not to leave it in your car during the summer, or any other hot spots. We cannot guarantee this product will arrive unharmed from heat, especially during the summer months. Please do not hesitate to contact us if you have any questions.
29867 US ORDERS $35 AND UP SHIP FREE WITH USPS STANDARD SHIPPING! Pink Mirage is a semi-sheer and rich in shimmer frosted pale pink lipstick, which will be a great addition to your collection. It is almost pearlescent white with a touch of pink, and is reflective of light. Add a touch to your bottom lip for a lighter, soft color, or apply a few layers to both lips for a deeper hue. It is lightweight, non greasy, and will give your lips a healthy, moisturized and soft look. Color may vary depending on your monitor settings. FRESH, HANDMADE PER ORDER! (we do not keep any of our products in stock). For multiple quantities and samples, please check our "Special Offers" Section. GLUTEN FREE! NO HARSH CHEMICALS, NO PARABENS! NO FLAVORINGS, NO DEODORIZERS! (please note that the smell is of oils and butters that are the ingredients of our products). FRESH, HANDMADE PER ORDER FROM OUR OWN SIGNATURE LIPSTICK BASE! (we do not keep any of our products in stock). NOT VEGAN! (Contains beeswax!) Our makeup is handcrafted with only high quality ingredients. The ingredients are: -coconut butter, -cocoa butter -jojoba oil -olive oil -beeswax -micro-crystalline wax -mica -titanium dioxide -iron oxide -tin oxide -red 27 NOTE: There will be NO REFUNDS OR REPLACEMENTS on lip products. Please check Policies section of the shop for more details. The expiration date for all of our lipsticks is 3 months from purchase date, since they are made from natural ingredients. Please keep in mind that these are made of handmade natural base, and are more sensitive than regular lip products. Keeping it in a dry, cool, and dark place (even the fridge) may prolong the shelf life. ***************************************************************************************************** Color may vary depending on your monitor settings. MELT WARNING This product will melt in the heat. We cannot guarantee this product will arrive unharmed from heat, especially during the summer months. Please do not hesitate to contact us if you have any questions.
29871 US ORDERS $35 AND UP SHIP FREE WITH USPS STANDARD SHIPPING! This shimmery copper lipstick with brownish undertone will be a perfect addition to your collection! Gold and pink shine may be seen depending on light that hits the lipstick on your lips. Add a touch to your bottom lip for a natural, soft shimmer or apply a few layers to both lips for a deeper hue. It is lightweight, non greasy, and will give your lips a healthy, moisturized and soft look. Color may vary depending on your monitor and its settings. FRESH, HANDMADE PER ORDER! (we do not keep any of our products in stock) For multiple quantities and samples please check our "Special Offers" Section. GLUTEN FREE! NO HARSH CHEMICALS, NO PARABENS! NO FLAVORINGS, NO DEODORIZERS! (please note that the smell is of oils and butters that are the ingredients of our products). FRESH, HANDMADE PER ORDER FROM OUR OWN SIGNATURE LIPSTICK BASE! (we do not keep any of our products in stock) NOT VEGAN! (contains beeswax!) Our makeup is handcrafted with only high quality ingredients. The ingredients are: -coconut butter, -cocoa butter -jojoba oil -olive oil -beeswax -micro-crystalline wax -mica -titanium dioxide -iron oxide NOTE: There will be NO REFUNDS OR REPLACEMENTS on lip products. Please check Policies section of the shop for more details. The expiration date for all of our lipsticks is 3 months from purchase date, since they are made from natural ingredients. Please keep in mind that these are made of handmade natural base, and are more sensitive than regular lip products. Keeping it in a dry, cool, and dark place (even the fridge) may prolong the shelf life. ***************************************************************************************************** MELT WARNING This product will melt in the heat. We cannot guarantee this product will arrive unharmed from heat, especially during the summer months. Please do not hesitate to contact us if you have any questions.
29872 US ORDERS $35 AND UP SHIP FREE WITH USPS STANDARD SHIPPING! "Golden Sandstone" is extremely shimmery bronzed gold creamy lipstick and is a perfect addition to your collection! This is a mica-based, sheer lipstick and not a dye or a stain. Add a touch to your bottom lip for a natural, soft shimmer or apply a few layers to both lips for a more intense shine. This lipstick is safe for both lips and eyes, so have fun experimenting! It is lightweight, non greasy, and will give your lips a healthy, moisturized and soft look. Color may vary depending on your monitor settings. FRESH, HANDMADE PER ORDER! (we do not keep any of our products in stock). For multiple quantities and samples, please check our "Special Offers" Section. GLUTEN FREE! NO HARSH CHEMICALS, NO PARABENS! NO FLAVORINGS, NO DEODORIZERS! (please note that the smell is of oils and butters that are the ingredients of our products). FRESH, HANDMADE PER ORDER FROM OUR OWN SIGNATURE LIPSTICK BASE! (we do not keep any of our products in a stock) NOT VEGAN! (contains beeswax!) Our makeup is handcrafted with only high quality ingredients. The ingredients are: -coconut butter, -cocoa butter -jojoba oil -olive oil -beeswax -micro-crystalline wax -mica -titanium dioxide -tin oxide -iron oxide Color may vary slightly depending on your monitor settings. NOTE: There will be NO REFUNDS OR REPLACEMENTS on lip products. Please check Policies section of the shop for more details. The expiration date for all of our lipsticks is 3 months from purchase date, since they are made from natural ingredients. Please keep in mind that these are made of handmade natural base, and are more sensitive than regular lip products. Keeping it in a dry, cool, and dark place (even the fridge) may prolong the shelf life. ***************************************************************************************************** Color may vary depending on your monitor settings. MELT WARNING This product will melt in the heat. We cannot guarantee this product will arrive unharmed from heat, especially during the summer months. Please do not hesitate to contact us if you have any questions.
29875 US ORDERS $35 AND UP SHIP FREE WITH USPS STANDARD SHIPPING! Orange Mirage is a semi-sheer and rich in shimmer pale lipstick, which will be a great addition to your collection. It gives off orange and tan tones with just a hint of copper. It is almost pearlescent white with a touch of color that "plays" under light, and is reflective of light. Add a touch to your bottom lip for a lighter, soft color, or apply a few layers to both lips for a deeper hue. It is lightweight, non greasy, and will give your lips a healthy, moisturized and soft look. Color may vary depending on your monitor settings. FRESH, HANDMADE PER ORDER! (we do not keep any of our products in stock). For multiple quantities and samples, please check our "Special Offers" Section. GLUTEN FREE! NO HARSH CHEMICALS, NO PARABENS! NO FLAVORINGS, NO DEODORIZERS! (please note that the smell is of oils and butters that are the ingredients of our products). FRESH, HANDMADE PER ORDER FROM OUR OWN SIGNATURE LIPSTICK BASE! (we do not keep any of our products in stock). NOT VEGAN! (Contains beeswax!) Our makeup is handcrafted with only high quality ingredients. The ingredients are: -coconut butter, -cocoa butter -jojoba oil -olive oil -beeswax -micro-crystalline wax -mica -titanium dioxide -iron oxide -tin oxide -yellow 6 NOTE: There will be NO REFUNDS OR REPLACEMENTS on lip products. Please check Policies section of the shop for more details. The expiration date for all of our lipsticks is 3 months from purchase date, since they are made from natural ingredients. Please keep in mind that these are made of handmade natural base, and are more sensitive than regular lip products. Keeping it in a dry, cool, and dark place (even the fridge) may prolong the shelf life. ***************************************************************************************************** MELT WARNING This product will melt in the heat. We cannot guarantee this product will arrive unharmed from heat, especially during the summer months. Please do not hesitate to contact us if you have any questions.
29876 US ORDERS $35 AND UP SHIP FREE WITH USPS STANDARD SHIPPING! This shimmery golden lipstick will be a perfect addition to your collection! Gold Rush is a sheer, mica-based, shimmery lipstick and not a dye or stain. It is lightweight, non greasy, and will give your lips a healthy, moisturized and soft look. Color may vary depending on your monitor settings. FRESH, HANDMADE PER ORDER! (we do not keep any of our products in stock). For multiple quantities and samples, please check our "Special Offers" Section. GLUTEN FREE! NO HARSH CHEMICALS, NO PARABENS! NO FLAVORINGS, NO DEODORIZERS! (please note that the smell is of oils and butters that are the ingredients of our products). FRESH, HANDMADE PER ORDER FROM OUR OWN SIGNATURE LIPSTICK BASE! (we do not keep any of our products in stock). NOT VEGAN! (contains beeswax!) Our makeup is handcrafted with only high quality ingredients. The ingredients are: -coconut butter, -cocoa butter -jojoba oil -olive oil -beeswax -micro-crystalline wax -mica -titanium dioxide -tin oxide -iron oxide NOTE: There will be NO REFUNDS OR REPLACEMENTS on lip products. Please check Policies section of the shop for more details. The expiration date for all of our lip products is 3 months from purchase date, since they are all natural, and there are no chemical preservatives. Lumps may occur on lipsticks due to crystallization of butters, since there are no chemical blenders/emulsifiers. Please keep in mind that these are made of handmade natural base, and are more sensitive than regular lip products. ***************************************************************************************************** MELT WARNING This product will melt in the heat. We cannot guarantee this product will arrive unharmed from heat, especially during the summer months. Please do not hesitate to contact us if you have any questions.
29877 US ORDERS $35 AND UP SHIP FREE WITH USPS STANDARD SHIPPING! Look fierce with this extremely shimmery, semi-sheer lipstick! Depending on light it may offer a light beige, grey and'or silver white shine. Add a touch to your bottom lip for a natural, soft shimmer or apply a few layers to both lips for a deeper hue. This is a mica based lipstick, and is safe for lips, eyes, and skin, so have fun experimenting! It is lightweight, non greasy, and will give your lips a healthy, moisturized and soft look. PLEASE NOTE THAT DUE TO INTENSITY OF SHIMMER, THIS LIPSTICK REFLECTS LIGHT, WHICH MAKES IT HARD TO CAPTURE 100% TRUE COLOR. IT MAY LOOK A BIT MORE BEIGE IN REAL LIFE WHEN APPLIED. DEPENDING ON SURROUNDING LIGHT THIS LIPSTICK MAY GIVE OFF A GRAY TONE. Color may also vary depending on your monitor settings. FRESH, HANDMADE PER ORDER! (we do not keep any of our products in stock) For multiple quantities and samples, please check our "Special Offers" Section. GLUTEN FREE! NO HARSH CHEMICALS, NO PARABENS! NO FLAVORINGS, NO DEODORIZERS! (please note that the smell is of oils and butters that are the ingredients of our products). FRESH, HANDMADE PER ORDER FROM OUR OWN SIGNATURE LIPSTICK BASE! (we do not keep any of our products in a stock) NOT VEGAN! (contains beeswax! Our makeup is handcrafted with only high quality ingredients. The ingredients are: -coconut butter, -cocoa butter -jojoba oil -olive oil -beeswax -micro-crystalline wax -mica -titanium dioxide -tin oxide -iron oxide NOTE: There will be NO REFUNDS OR REPLACEMENTS on lip products. Please check Policies section of the shop for more details. The expiration date for all of our lipsticks is 3 months from purchase date, since they are made from natural ingredients. Please keep in mind that these are made of handmade natural base, and are more sensitive than regular lip products. Keeping it in a dry, cool, and dark place (even the fridge) may prolong the shelf life. ***************************************************************************************************** MELT WARNING This product will melt in the heat. We cannot guarantee this product will arrive unharmed from heat, especially during the summer months. Please do not hesitate to contact us if you have any questions.
29879 US ORDERS $35 AND UP SHIP FREE WITH USPS STANDARD SHIPPING! "Surya" is a semi-sheer duochrome lipstick with pastel pink and golden tones. The shine depends on the way the light hits your lips when the lipstick is applied. Add a touch to your bottom lip for a natural, soft shimmer or apply a few layers to both lips for a deeper hue. This is a mica based lipstick, and is safe for lips, eyes, and skin, so have fun experimenting! PLEASE NOTE THAT DUE TO THE INTENSITY OF SHIMMER AND THE DUOCHROME EFFECT IT IS HARD TO CAPTURE 100% TRUE COLOR. It may appear more pink or more gold depending on light. Color may also vary depending on your monitor and its settings. FRESH, HANDMADE PER ORDER! (we do not keep any of our products in stock). For multiple quantities, please check our "Special Offers" Section. It is lightweight, non greasy, and will give your lips a healthy, moisturized and soft look. GLUTEN FREE! NO HARSH CHEMICALS, NO PARABENS! NO FLAVORINGS, NO DEODORIZERS! (please note that the smell is of oils and butters that are the ingredients of our products). FRESH, HANDMADE PER ORDER FROM OUR OWN SIGNATURE LIPSTICK BASE! (we do not keep any of our products in a stock) NOT VEGAN! (contains beeswax!) The ingredients are: -coconut butter, -cocoa butter -jojoba oil -olive oil -beeswax -micro-crystalline wax -mica -titanium dioxide -tin oxide -tea tree oil Our makeup is handcrafted with only high quality ingredients. NOTE: There will be NO REFUNDS OR REPLACEMENTS on lip products. Please check Policies section of the shop for more details. The expiration date for all of our lipsticks is 3 months from purchase date, since they are made from natural ingredients. Please keep in mind that these are made of handmade natural base, and are more sensitive than regular lip products. Keeping it in a dry, cool, and dark place (even the fridge) may prolong the shelf life. ***************************************************************************************************** Color may vary depending on your monitor settings. MELT WARNING This product will melt in the heat. We cannot guarantee this product will arrive unharmed from heat, especially during the summer months. Please do not hesitate to contact us if you have any questions.
29881 US ORDERS $35 AND UP SHIP FREE WITH USPS STANDARD SHIPPING! Violet Mirage is a semi-sheer and rich in shimmer frosted pale violet lipstick, which will be a great addition to your collection. It is almost pearlescent white with a touch of violet, and is reflective of light. Wear it as a sheer lipstick, or build it up for a more opaque look, as shown on photos. The color may appear more white, pink, violet and/or with a hint of blue depending on light. It is lightweight, non greasy, and will give your lips a healthy, moisturized and soft look. Color may vary depending on your monitor settings. FRESH, HANDMADE PER ORDER! (we do not keep any of our products in stock). For multiple quantities and samples, please check our "Special Offers" Section. GLUTEN FREE! NO HARSH CHEMICALS, NO PARABENS! NO FLAVORINGS, NO DEODORIZERS! (please note that the smell is of oils and butters that are the ingredients of our products). FRESH, HANDMADE PER ORDER FROM OUR OWN SIGNATURE LIPSTICK BASE! (we do not keep any of our products in stock). NOT VEGAN! (Contains beeswax!) Our makeup is handcrafted with only high quality ingredients. The ingredients are: -coconut butter, -cocoa butter -jojoba oil -olive oil -beeswax -micro-crystalline wax -mica -titanium dioxide -iron oxide -tin oxide -blue 1 -red 27 NOTE: There will be NO REFUNDS OR REPLACEMENTS on lip products. Please check Policies section of the shop for more details. The expiration date for all of our lipsticks is 3 months from purchase date, since they are made from natural ingredients. Please keep in mind that these are made of handmade natural base, and are more sensitive than regular lip products. Keeping it in a dry, cool, and dark place (even the fridge) may prolong the shelf life. ***************************************************************************************************** Color may vary depending on your monitor settings. MELT WARNING This product will melt in the heat. We cannot guarantee this product will arrive unharmed from heat, especially during the summer months. Please do not hesitate to contact us if you have any questions.
29890 US ORDERS $35 AND UP SHIP FREE WITH USPS STANDARD SHIPPING! "FROSTALINE"s are created from our signature all natural handmade base (see ingredients below). With just a touch of shimmer that gives your lips opalescent frosty shine, Frostalines will be a great addition to your collection of lips products. Sheer to semi-sheer, they are available in green, blue, orange, pink, and violet shine. "FROSTALINE"s are lightweight, non greasy, and will give your lips a healthy, moisturized and soft look. NOTE: EACH "FROSTALINE" HAS A DIFFERENT COLOR/SHINE. THIS IS NOT JUST ONE LIPSTICK WITH ALL 5 SHADES. THIS LISTING IS FOR "FROSTALINE" OF YOUR CHOICE OF COLOR AND SIZE. PLEASE MAKE YOUR SELECTION OF SIZE AND QUANTITY BEFORE ADDING TO CART. CHOOSE 1 OR ALL 5 IN YOUR DESIRED SIZE. PLEASE SPECIFY THE COLOR OF YOUR CHOICE IN NOTES AT CHECK-OUT OR SEND US A CONVO. For multiple quantities and samples please check our "Special Offers" Section: https://www.etsy.com/shop/FierceMagenta?ref=seller-platform-mcnav§ion_id=12564734 KINDLY NOTE THAT THE SHINE AND SHADE OF EACH VARY DEPENDING ON SURROUNDING LIGHT. Thus, violet may appear as more pink at times; pink may appear with blueish shine at times, etc... Depending on lighting the shine may be seen more or less. Colors also may vary depending on your monitor and its settings. FRESH, HANDMADE PER ORDER! (we do not keep any of our products in stock) GLUTEN FREE! NO HARSH CHEMICALS, NO PARABENS! NO FLAVORINGS, NO DEODORIZERS! (please note that the smell is of oils and butters that are the ingredients of our products). FRESH, HANDMADE PER ORDER FROM OUR OWN SIGNATURE LIPSTICK BASE! (we do not keep any of our products in a stock) NOT VEGAN! (contains beeswax!) Our makeup is handcrafted with only high quality ingredients. The ingredients are: -coconut butter, -cocoa butter -jojoba oil -olive oil -beeswax -micro-crystalline wax -mica -titanium dioxide -iron oxide (May contain just a touch of either one: Blue 1, Red 27, orange 5, yellow 5). NOTE: There will be NO REFUNDS OR REPLACEMENTS on lip products. Please check Policies section of the shop for more details. The expiration date for all of our lipsticks is 3 months from purchase date, since they are made from natural ingredients. Please keep in mind that these are made of handmade natural base, and are more sensitive than regular lip products. Keeping it in a dry, cool, and dark place (even the fridge) may prolong the shelf life. ***************************************************************************************************** Color may vary depending on your monitor settings. MELT WARNING This product will melt in the heat. It doesn't damage the product, but may cause the lipstick to leak or get stuck in the cap. So try not to leave it in your car during the summer, or any other hot spots. We cannot guarantee this product will arrive unharmed from heat, especially during the summer months. Please do not hesitate to contact us if you have any questions.
29891 US ORDERS $35 AND UP SHIP FREE WITH USPS STANDARD SHIPPING! Naive is a semi-sheer and rich in shimmer pink lipstick, which will be a great addition to your collection. Add a touch to your bottom lip for a lighter, soft color, or apply a few layers to both lips for a deeper hue. It is lightweight, non greasy, and will give your lips a healthy, moisturized and soft look. Color may vary depending on your monitor settings. FRESH, HANDMADE PER ORDER! (we do not keep any of our products in stock). For multiple quantities and samples, please check our "Special Offers" Section. GLUTEN FREE! NO HARSH CHEMICALS, NO PARABENS! NO FLAVORINGS, NO DEODORIZERS! (please note that the smell is of oils and butters that are the ingredients of our products). FRESH, HANDMADE PER ORDER FROM OUR OWN SIGNATURE LIPSTICK BASE! (we do not keep any of our products in stock). NOT VEGAN! (contains beeswax and carmine!) Our makeup is handcrafted with only high quality ingredients. The ingredients are: -coconut butter, -cocoa butter -jojoba oil -olive oil -beeswax -micro-crystalline wax -mica -titanium dioxide -iron oxide -tin oxide -carmine -boron nitrate NOTE: There will be NO REFUNDS OR REPLACEMENTS on lip products. Please check Policies section of the shop for more details. The expiration date for all of our lipsticks is 3 months from purchase date, since they are made from natural ingredients. Please keep in mind that these are made of handmade natural base, and are more sensitive than regular lip products. Keeping it in a dry, cool, and dark place (even the fridge) may prolong the shelf life. ***************************************************************************************************** Color may vary depending on your monitor settings. MELT WARNING This product will melt in the heat. We cannot guarantee this product will arrive unharmed from heat, especially during the summer months. Please do not hesitate to contact us if you have any questions.
29892 US ORDERS $35 AND UP SHIP FREE WITH USPS STANDARD SHIPPING! Temptation is a mica-based, shimmery rich in color lipstick, and not a dye or stain. This semi-sheer bright pink with coral accent colored lipstick will be a great addition to your collection. Add a touch to your bottom lip for a lighter, soft color, or apply a few layers to both lips for a deeper hue. Color may vary depending on your monitor settings. This lipstick is lightweight, non greasy, and will give your lips a healthy, moisturized and soft look. FRESH, HANDMADE PER ORDER! (we do not keep any of our products in stock). For multiple quantities and samples, please check our "Special Offers" Section. GLUTEN FREE! NO HARSH CHEMICALS, NO PARABENS! NO FLAVORINGS, NO DEODORIZERS! (please note that the smell is of oils and butters that are the ingredients of our products). FRESH, HANDMADE PER ORDER FROM OUR OWN SIGNATURE LIPSTICK BASE! (we do not keep any of our products in stock) NOT VEGAN! (contains beeswax!) Our makeup is handcrafted with only high quality ingredients. The ingredients are: -coconut butter, -cocoa butter -jojoba oil -olive oil -beeswax -micro-crystalline wax -mica -titanium dioxide -hydrogenated polyisobutene -palmitic acid -red 40 Color may vary slightly depending on your monitor settings. NOTE: There will be NO REFUNDS OR REPLACEMENTS on lip products. Please check Policies section of the shop for more details. The expiration date for all of our lipsticks is 3 months from purchase date, since they are made from natural ingredients. Please keep in mind that these are made of handmade natural base, and are more sensitive than regular lip products. Keeping it in a dry, cool, and dark place (even the fridge) may prolong the shelf life. ***************************************************************************************************** Color may vary depending on your monitor settings. MELT WARNING This product will melt in the heat. We cannot guarantee this product will arrive unharmed from heat, especially during the summer months. Please do not hesitate to contact us if you have any questions.
29905 "FLATTE MATTE" is our collection of matte liquid lipsticks. They go on as a creamy and smooth gloss, but dry within seconds as a matte lipstick, and last for hours.* "FLATTE MATTE"s are specially formulated to give your lips a natural look, will not dry out your lips while you wear them, and do not transfer. They are available in: Nude (beige/light brown), Faded Peach (nude with peachy tone), Hot Rouge Orange (bright red with orange tone), Crazy Coral (bright pink with coral tone). All are sold in a standard gloss tube with a wand as on the last photo. PLEASE MAKE YOUR SELECTION FROM AVAILABLE OPTIONS BEFORE ADDING TO CART. KINDLY NOTE THAT THE SHADES OF EACH MAY VARY DEPENDING ON YOUR MONITOR SETTINGS, AS WELL AS SURROUNDING LIGHT WHEN YOU WEAR THEM. (Nude may appear with more taupe or more pink tone; Crazy Coral may appear with more of coral or more pink tone; peachy nude may appear more beige or more peachy, etc...) INGREDIENTS: Isoparaffin Dimethicone Trimethylsiloxysilicate Talc Quaternium-18 Bentonite Cera Microcristallina Methyl Methacrylate Crosspolymer Zea Mays (Corn) Starch CYCLOPENTASILOXANE Silica PROPYLENE CARBONATE CYCLOHEXASILOXANE Parfum Phenoxyethanol Quartz Ethylhexylglycerin -mica -titanium dioxide -iron oxide *Please note that the wear time of products on lips differs from person to person. Products may flake after consuming food. NOTE: There will be NO REFUNDS on lip products. The expiration date for this product is up to 1 year (depending on storage and use). Please make sure to close the tube tightly after each use. ******************************************************************************** Colors may vary depending on your monitor settings. Please do not hesitate to contact us if you have any questions.