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('46035', '45001', '46037', '46036', '45003', '45002')) AND (at_status.value = '1')
  • White Murano Glass Bead 925 Sterling Silver Charm
    $25.00
    $25.00
  • Equinox Flower Murano Glass Bead 925 Sterling Silver Charm
    $25.00
    $25.00
  • Red Murano Glass Bead 925 Sterling Silver Charm
    $25.00
    $25.00
  • Pink Murano Glass Bead 925 Sterling Silver Charm
    $25.00
    $25.00
  • Ocean Blue Magic Murano Glass Bead 925 Sterling Silver Charm
    $25.00
    $25.00
  • Dark Blue Magic Murano Glass Bead 925 Sterling Silver Charm
    $25.00
    $25.00
Page:
  1. FIRST
  2. PREV
  3. 1
  4. 2
  • Ocean Blue Magic Murano Glass Bead 925 Sterling Silver Charm
    $25.00
  • Dark Blue Magic Murano Glass Bead 925 Sterling Silver Charm
    $25.00
  • Equinox Flower Murano Glass Bead 925 Sterling Silver Charm
    $25.00
  • Pink Murano Glass Bead 925 Sterling Silver Charm
    $25.00
  • White Murano Glass Bead 925 Sterling Silver Charm
    $25.00
  • Red Murano Glass Bead 925 Sterling Silver Charm
    $25.00
  • 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

  • Pink Five Petals Flower Murano Glass Bead 925 Sterling Silver

    $40.00

    $15.95

  • Light Pink Flower Petals Murano Glass Charm 925 Sterling Silver

    $40.00

    $15.95

  • Pink Peach Flower Glass Bead 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

  • Pink Bubbles Murano Glass Charm 925 Sterling Silver

    $40.00

    $15.95

  • Frozen Sea Blue Murano Glass Charm 925 Sterling Silver

    $40.00

    $15.95

  • Blue Water Drop Murano Glass Charm 925 Sterling Silver

    $40.00

    $15.95

  • Gold Desert Murano Glass Charm 925 Sterling Silver

    $40.00

    $15.95

  • Folklore 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

  • Glimmer In The Sea Murano Glass Charm 925 Sterling Silver

    $40.00

    $15.95

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

    $40.00

    $15.95

  • Pink Plum Flower Murano Glass Charm 925 Sterling Silver

    $40.00

    $15.95

  • Gold Bubbles Murano Glass Charm 925 Sterling Silver

    $40.00

    $15.95

  • Bright Yellow Murano Glass Bead Charm 925 Sterling Silver

    $40.00

    $15.95

    Out of stock

  • Rainbow Bridge Murano Glass Bead Charm 925 Sterling Silver

    $40.00

    $15.95

  • Blue Built-in Bubble Glass Bead Charm 925 Sterling Silver

    $30.00

    $15.95

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

    $30.00

    $15.95

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