Joseph click for home. Joseph click for home. Joseph click for home. Joseph click for home.
sqlsize=select distinct level3+level4 as size,level3,level4 from vend,ipinvhdr,ipinvdtl,IPLUSBCL,IPLUCOLR,josephactivecolors where ipinvhdr.SBCLASS > ' ' and ipinvhdr.hdrguid=ipinvdtl.hdrguid and ipinvhdr.sbclass=IPLUSBCL.mainkey and ipinvhdr.vendor1=vend.id and IPINVDTL.LEVEL2=IPLUCOLR.mainkey and vend.VENDGUID=iplucolr.VENDGUID and replace(josephactivecolors.color,'-',' ') = IPLUCOLR.DESCRIP and josephactivecolors.sku=ipinvdtl.level1 and ipinvdtl.curonh > 0 and not level3 like '1%' and color='cheetah' and sku='MBL017' order by level3,level4
sqlcolor=select distinct color as suffix from josephactivecolors,ipinvdtl,ipinvhdr where ipinvdtl.hdrguid=ipinvhdr.hdrguid and sku='MBL017' and ipinvdtl.level1=sku and curonh > 0 and sbclass > ' ' order by color
MANOLO BLAHNIK - Taylerbibo 90 D'Orsay Pump

MANOLO BLAHNIK

Taylerbibo 90 D'Orsay Pump

$795

• 3 1/4" heel

Joseph Item # MBL017
Color: cheetah

© 2017, Joseph   Memphis   New Orleans  800.890.5470
Security & Privacy
Top