(02) 9522-9095
Login
|
Sign Up
|
Wishlist
|
Cart
Menu
Toggle navigation
Home
About
About Us
Testimonials
Trade
Jewellery Insurance
Events
Contact Us
Services
FREE Inspection
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
Watch Repairs
Shop
Rings
Pendants
Necklets
Charm
Bangles
Bracelets
Anklets
Earrings
Chains
Body Jewellery
Strands
Watches
Cufflinks
Keyrings
Shop All
Shop
Rings
Pendants
Necklets
Charm
Bangles
Bracelets
Anklets
Earrings
Chains
Body Jewellery
Strands
Watches
Cufflinks
Keyrings
Shop All
Brands
Catalogues
Jewellery Facts
Finance Options
Q Report
ZipPay
Body Jewellery
SELECT EdgeMaster.StockNum,EdgeMaster.SKU,EdgeMaster.CurrentPrice,EdgeMaster.RetailPrice,EdgeMaster.Images,EdgeMaster.categoryType,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 ©2020 Pontifex Jewellers |
Terms & Conditions
2563421