Badehosen
SELECT DISTINCT `e`.*, `cat_index`.`position` AS `cat_index_position`, `stock_status_index`.`stock_status` AS `is_salable`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price` FROM `catalog_product_entity` AS `e`
INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=2 AND cat_index.visibility IN(2, 4) AND cat_index.category_id='83'
LEFT JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 WHERE (`stock_status_index`.`stock_status`=1) AND (`stock_status_index`.`stock_status` <> 0 ) ORDER BY `cat_index`.`position` ASC
LIMIT 32
Shop By
Filter
Geschlecht
Hersteller
Material
Size
28-30
32-34
35 1/2
48,5
52 mm
53 mm
54 mm
Large
Medium
Narrow
Small
US 10
US 13
W'10 / EU 42
W'8 / EU 40
W'8.5 / EU 40.5
W'9 / EU 41
W'9.5 / EU 41.5
Wide
X-Large
10
10,5
11
11,5
12
138
139
142
143
146
144
147
148
150
151
152
153
154
154-Wide
155
155W
156
156-Wide
157
157-Wide
157W
158
158-Wide
158W
159
159-Wide
159W
16
160
160-Wide
161
161-Wide
161W
162
162-Wide
163
163-Wide
164-Wide
165
166-Wide
167-Wide
17
18
19
20
21
22
23
23,5
24
25
25,5
25/26
26
27
28/29
29
30-30
30-32
31
31-32
31/32
32-30
32-32
32.5
33
33-32
33-34
33/34
34-30
34-32
34-34
35
35/36
35/38
36 2/3
36-32
36-34
37 1/3
37,5
37/38
38 2/3
38,5
38-34
39 1/3
39/42
40 2/3
402/3
41 1/3
42 1/3
42 2/3
42,5
43 1/3
43/46
44 2/3
44,5
45 1/3
45,5
46 2/3
46,5
47 1/3
48 2/3
49 1/3
8,5
9
9,5
L long
L normal
L-154
L/XL
M long
M normal
M-151
M/L
M\L
One Size
S normal
S-148
S/M
S\M
TALL
US 10 / EU 41.5
US 10 / EU 43
US 10 / EU 43
US 10 / EU 44
US 10.5 / EU 43.5
US 10.5 / EU 44
US 10.5 / EU 44.5
US 11
US 11 / EU 42.5
US 11 / EU 44
US 11 / EU 44.5
US 11 / EU 45
US 11.5 / EU 45.5
US 11.5 / EU 44.5
US 11.5 / EU 45
US 11.5 / EU 45.5
US 12
US 12 / EU 45
US 12 / EU 46
US 13 / EU 46
US 13 / EU 47.5
US 13 / EU 48
US 14 / EU 47
US 14 / EU 49
US 5
US 6
US 7
US 7 / EU 37
US 7.5 / EU 38
US 8
US 8 / EU 39
US 8 / EU 41
US 8,5 / EU 42
US 8.5 / 41.5
US 8.5 / EU 39.5
US 8.5 / EU 41.5
US 8.5 / EU 42
US 9
US 9 / EU 40
US 9 / EU 42
US 9 / EU 42.5
US 9,5 / EU 43
US 9.5 / EU 42.5
US 9.5 / EU 43
US10
W`10 / EU 42
W`8 / EU 40
W`8.5 / EU 40.5
W`9 / EU 41
W`9.5 / EU 41.5
W29/L30
W29/L32
W30/L30
W30/L32
W31/L32
W31/L34
W32/L32
W32/L34
W33/L32
W33/L34
W34/L30
W34/L32
W34/L34
W36/L32
W36/L34
W38/L32
W38/L34
W40/L32
W40/L34
XL normal
XL-158
XS-142
XS/S
XXL
XXXL
Einheitsgröße
3XS
2XS
XS
S
M
L
XL
2XL
3XL
4XL
6
6.5
12.5
28
30
32
34
35.5
36
36.5
37
37.5
38
38.5
39
39.5
40
40.5
41
41.5
42
42.5
43
43.5
44
44.5
45
45.5
46
46.5
47
47.5
48
48.5
49
49.5
50
50.5
51.5
52
153 cm
158 cm
162 cm
167 cm
35,5
Preis