+371 27440035

+371 26285543

HELP
LV   RU   EN
Home » Guess
SORT BY

Guess

Refine by:
select a.* from prod_table4 a LEFT JOIN prod_table5 b on (b.tab4_id=a.id) LEFT JOIN prod_table3 c on (c.id=b.tab3_id) WHERE (a.brand like '%Guess%') and c.tab2_id<>34 GROUP BY a.id DESC LIMIT 0, 48
Guess
Handbag
84 EUR149 EUR
-44%
33x18x10
Guess
Sweater
59 EUR99 EUR
-40%
XL
Guess
Sweater
44 EUR89 EUR
-51%
XS
Guess
Down jacket
99 EUR199 EUR
-50%
XL
Guess by Marciano
Dress
64 EUR114 EUR
-44%
It46(40)
It44(38)
Refine by: