(02) 9522-9095
Login
|
Sign Up
|
Wishlist
|
Cart
Menu
Toggle navigation
Home
About
About Us
Testimonials
Trade
Catalogues
Jewellery Insurance
Finance Options
Events
Contact Us
Shop
Rings
Pendants
Necklets
Charm
Bangles
Bracelets
Anklets
Earrings
Chains
Body Jewellery
Strands
Watches
Keyrings
Cufflinks
Shop All
Shop
Rings
Pendants
Necklets
Charm
Bangles
Bracelets
Anklets
Earrings
Chains
Body Jewellery
Strands
Watches
Keyrings
Cufflinks
Shop All
Argyle
Brands
Engagement Rings
Jewellery Facts
Services
Lay-by
Gift Cards
Custom Design
Jewellery Remodelling
Pearl Re-threading
Jewellery Repairs
Finance Options
Watch Batteries
7 Year Diamond Guarantee
Valuations
FREE Gift Wrapping
Insurance Replacement
FREE Inspection
Watch Repairs
Q Report
ZipPay
Body Jewellery
SELECT EdgeMaster.EdgeID,EdgeMaster.StockNum,EdgeMaster.SKU,EdgeMaster.CurrentPrice,EdgeMaster.RetailPrice,EdgeMaster.Images,EdgeMaster.categoryType,EdgeMaster.CategoryID,EdgeMaster.ShortMktngDesc,EdgeMaster.BrandName,EdgeMaster.MCategory,EdgeMaster.SCategory,EdgeDetailsMaster.SCategory,EdgeDetailsMaster.MCategory,EdgeDetailsMaster.MetalColor,EdgeDetailsMaster.MetalType FROM EdgeMaster JOIN EdgeDetailsMaster ON (EdgeMaster.categoryType = EdgeDetailsMaster.EdgeCategoryType and EdgeMaster.StockNum = EdgeDetailsMaster.EdgeStockNum and EdgeMaster.SKU = EdgeDetailsMaster.EdgeSKU) where EdgeMaster.MCategory='1013 Body Jewellery' and EdgeMaster.TotalAvailQOH>0 and EdgeMaster.ProdDel not in ('y')
Filter By
Metal Color
Price
to
No products were found under this category!
×
Copyright ©2021 Pontifex Jewellers |
Terms & Conditions
6603915