• cs@soufeel.com

Murano Glass Beads

SELECT `e`.*, IF(at_special_price.value_id > 0, at_special_price.value, at_special_price_default.value) AS `special_price`, `at_status`.`value` AS `status` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_entity_decimal` AS `at_special_price_default` ON (`at_special_price_default`.`entity_id` = `e`.`entity_id`) AND (`at_special_price_default`.`attribute_id` = '567') AND `at_special_price_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_decimal` AS `at_special_price` ON (`at_special_price`.`entity_id` = `e`.`entity_id`) AND (`at_special_price`.`attribute_id` = '567') AND (`at_special_price`.`store_id` = 1) INNER JOIN `catalog_product_entity_int` AS `at_status` ON (`at_status`.`entity_id` = `e`.`entity_id`) AND (`at_status`.`attribute_id` = '273') AND (`at_status`.`store_id` = 0) INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id = '1' WHERE (IF(at_special_price.value_id > 0, at_special_price.value, at_special_price_default.value) > 1) AND (`e`.`sku` IN('46012', '46010', '46004', '46003', '46001', '46005')) AND (at_status.value = '1')
  • 60% 0FF
    The Daffodils Murano Glass Bead 925 Sterling Silver
    $40.00
    $15.95
  • 60% 0FF
    Gardenia In Blossom Murano Glass Bead 925 Sterling Silver
    $40.00
    $15.95
  • 60% 0FF
    Blooming Flowers Murano Glass Bead 925 Sterling Silver
    $40.00
    $15.95
  • 65% 0FF
    Mandevilla Sanderi Murano Glass Bead 925 Sterling Silver
    $45.00
    $15.95
  • 60% 0FF
    Green Pear Blossom Murano Glass Bead 925 Sterling Silver
    $40.00
    $15.95
  • 60% 0FF
    Drifting Petals Murano Glass Bead 925 Sterling Silver
    $40.00
    $15.95
Page:
  1. FIRST
  2. PREV
  3. 1
  4. 2
  • Pink Five Petals Flower Murano Glass Bead 925 Sterling Silver

    $40.00

    $15.95

  • Green Pear Blossom Murano Glass Bead 925 Sterling Silver

    $40.00

    $15.95

  • The Daffodils Murano Glass Bead 925 Sterling Silver

    $40.00

    $15.95

  • Shying Flower Murano Glass Bead 925 Sterling Silver

    $40.00

    $15.95

  • Gardenia In Blossom Murano Glass Bead 925 Sterling Silver

    $40.00

    $15.95

  • Drifting Petals Murano Glass Bead 925 Sterling Silver

    $40.00

    $15.95

  • Summer's Desire Murano Glass Bead 925 Sterling Silver

    $40.00

    $15.95

  • Blooming Flowers Murano Glass Bead 925 Sterling Silver

    $40.00

    $15.95

  • Little Duck Murano Glass Bead 925 Sterling Silver

    $40.00

    $15.95

  • Flower Blooming In the Spring Murano Glass Bead 925 Sterling Silver

    $40.00

    $15.95

  • Mandevilla Sanderi Murano Glass Bead 925 Sterling Silver

    $45.00

    $15.95

  • Pink Three Petals Flower Murano Glass Bead 925 Sterling Silver

    $40.00

    $15.95

  • Gold Waves and Brown Dots Murano Glass Charm 925 Sterling Silver

    $40.00

    $15.95

  • Pink and Blue Rose Petals Murano Glass Charm 925 Sterling Silver

    $40.00

    $15.95

  • Light Pink Flower Petals Murano Glass Charm 925 Sterling Silver

    $40.00

    $15.95

  • Datura Flower Murano Glass Charm 925 Sterling Silver

    $40.00

    $15.95

  • Gold In Memory Murano Glass Charm 925 Sterling Silver

    $40.00

    $15.95

  • Red Hibiscus Murano Glass Charm 925 Sterling Silver

    $40.00

    $15.95

    Out of stock

  • Pink Plum Flower Murano Glass Charm 925 Sterling Silver

    $40.00

    $15.95

  • Snowy Winter Blue Murano Glass Charm 925 Sterling Silver

    $40.00

    $15.95

  • Light Yellow Bubble Murano Glass Charm 925 Sterling Silver

    $40.00

    $15.95

  • Colourful Flower Glass Bead Charm 925 Sterling Silver

    $40.00

    $15.95

  • Folklore Murano Glass Charm 925 Sterling Silver

    $40.00

    $15.95

  • Blue Water Drop Murano Glass Charm 925 Sterling Silver

    $40.00

    $15.95

  • Rainbow Bridge Murano Glass Bead Charm 925 Sterling Silver

    $40.00

    $15.95

  • Bright Yellow Murano Glass Bead Charm 925 Sterling Silver

    $40.00

    $15.95

  • Pale Blue With Red Flower Murano Glass Bead Charm 925 Sterling Silver

    $30.00

    $12.95

    Out of stock

  • Red Built-in Flower Glass Bead Charm 925 Sterling Silver

    $30.00

    $12.95

  • Rainbow Color Murano Glass Bead Charm 925 Sterling Silver

    $30.00

    $12.95

  • Green Four Flowers Glass Bead Charm 925 Sterling Silver

    $30.00

    $12.95

  • Black Golden Powder Murano Glass Bead Charm 925 Sterling Silver

    $30.00

    $12.95

  • Green Built-in Gold Thread Glass Bead Charm 925 Sterling Silver

    $35.00

    $15.95

  • Multicolor Wave Stripe Murano Glass Bead Charm 925 Sterling Silver

    $30.00

    $12.95

  • Red Built-in Gold Thread Glass Bead Charm 925 Sterling Silver

    $30.00

    $15.95

  • Mixed Colors Rainbow Glass Bead Charm 925 Sterling Silver

    $35.00

    $15.95

  • Green Flower Murano Glass Bead Charm 925 Sterling Silver

    $30.00

    $12.95

Page:
  1. FIRST
  2. PREV
  3. 1
  4. 2