GetCAtalogFilterAjax Error at Line 77 - 1001: GetCatalogByID Error at Line 26 - 1: SELECT C.BRCODE, B.brname, cast(C.PRDCATALOG_ID as decimal(10)) as ID, C.CATDESC, C.CATSTATUS, C.RLSDATE, C.RMVDATE , count(distinct Style) as StyleCnt
FROM soaprod.prdcatalog c
Left outer join Soaprod.catalog_style cs on c.PRDCATALOG_ID = cs.PRDCATALOG_ID
join Soaprod.Brand B on c.brcode = b.brcode
Where c.brcode='VA' and c.CATSTATUS ='Published'
GROUP BY C.BRCODE, C.PRDCATALOG_ID, C.CATDESC, C.CATSTATUS, C.RLSDATE, C.RMVDATE, B.BRNAMe
SELECT C.BRCODE, B.brname, cast(C.PRDCATALOG_ID as decimal(10)) as ID, C.CATDESC, C.CATSTATUS, C.RLSDATE, C.RMVDATE , count(distinct Style) as StyleCnt
FROM soaprod.prdcatalog c
Left outer join Soaprod.catalog_style cs on c.PRDCATALOG_ID = cs.PRDCATALOG_ID
join Soaprod.Brand B on c.brcode = b.brcode
Where c.brcode='VA' and c.CATSTATUS ='Published'
GROUP BY C.BRCODE, C.PRDCATALOG_ID, C.CATDESC, C.CATSTATUS, C.RLSDATE, C.RMVDATE, B.BRNAMe
 
Gender
All
Male
Female
Age
All
Child
Tween
Adult
Shape
All
Aviator
Cat Eye
Cornered Rectangle
Goggle
Oval
Round
Rectangle
Square
Tapered Oval
Butterfly
Navigator
P-3
Cylindrical Goggle
Spherical Goggle
Tea Cup
Modified Rectangle
Shield
Material
All
Color
All
Black
Blue
Brown
Clear
Gold
Green
Grey
Multicolor
Orange
Pink
Purple
Red
Silver
White
Yellow
Eye Size
All
New Styles
Please select a brand
Please click on a style image to view color options and details
Deselect All
   
Print
Welcome to the Marchon Digital catalog. Please take a moment to tell us about yourself.
User Type
Please select a user type
Annonymous
Consumer
ECP
Employee
Licensor
Company
Name
Email
Play
Pause