Cart
Checkout
Sign in
Register
My cart
()
Total:
€0.00
(0)
0
Total:
€0.00
Cart
Checkout
Submit
Home
Shop
Bags
Tote and Shoulder bags
Cross body bags
Backpacks and Bucket bags
Clutches
Accessories
Home
Wallets / card holder
Key chains
Bridal
Bags
Lookbook
Editorial
Blog
Contact
Product
List
Home
Leather accessories
Wallets / card holder
select * from (select Row_Number() over ( ORDER BY [order] ASC) as RowIndex, * FROM [prods] WHERE ([diathesi]<>N'Μη διαθέσιμο') AND [is_visible]=1 AND ( CHARINDEX('~24~',[prodKatID]) > 0 )) as Sub Where Sub.RowIndex >= 1 and Sub.RowIndex <= 12;
/
DECLARE @klist NVARCHAR(MAX) SELECT @klist = COALESCE(@klist+'|' ,'') + CAST(katigoriaID as varchar(20)) + '~' + katigoriaName FROM (SELECT TOP 500 prods.prodKatID,katigories.katigoriaName,katigories.katigoriaID FROM prods INNER JOIN Katigories ON CHARINDEX('~'+ CAST(katigories.katigoriaID as varchar(20)) +'~',prods.prodKatID) > 0 WHERE [is_visible]=1 AND ( CHARINDEX('~24~',[prodKatID]) > 0 ) ORDER BY katigories.katigoriaName) t SELECT IsNull(@klist, '') |||| False / ~~~~
Sort:
-
Higher Price
Lower Price
Popular
Recent
Alphabetically
Show:
2
4
8
16
32
1
2
Add to cart
ALBIANO WALLET - CAMEL
28,00 €
Add to cart
ALBIANO WALLET - DARK BROWN
28,00 €
Add to cart
ALBIANO WALLET - BLACK
28,00 €
Add to cart
MILA WALLET - TABAC LEATHER
35,00 €
Add to cart
MILA WALLET - OLIVE MOSS LEATHER
35,00 €
Add to cart
MILA WALLET - OLIVE GREEN LEATHER
35,00 €
Add to cart
CLES FOLDOVER WALLET - BLACK
42,00 €
Add to cart
CLES FOLDOVER WALLET - LIGHT BROWN
42,00 €
Add to cart
CLES FOLDOVER WALLET - RED
42,00 €
Add to cart
MILA WALLET - UNLINED TABAC
28,00 €
Add to cart
MILA WALLET - UNLINED OLIVE GREEN
28,00 €
Add to cart
MILA WALLET - UNLINED BORDEAUX
28,00 €
Sort:
-
Higher Price
Lower Price
Popular
Recent
Alphabetically
Show:
2
4
8
16
32
1
2