Чоловіче взуття Puma, Vans, The North Face, Native, Caterpillar, New Balance, Converse, Dr. Martens

SELECT count(*) as totalitems FROM dst_cat_item i1 INNER JOIN dst_cat_sectitem cc1 ON i1.id=cc1.item_id AND cc1.sect_id='1' INNER JOIN dst_cat_producer m1 ON i1.make_id=m1.id INNER JOIN dst_cat_section c1 ON cc1.sect_id=c1.id WHERE i1.id<>0 AND i1.status='0' AND i1.archive=0
MySQL server has gone away
SELECT count(*) as totalitems FROM dst_cat_item i1 INNER JOIN dst_cat_sectitem cc1 ON i1.id=cc1.item_id AND cc1.sect_id='1' INNER JOIN dst_cat_producer m1 ON i1.make_id=m1.id INNER JOIN dst_cat_section c1 ON cc1.sect_id=c1.id WHERE i1.id<>0 AND i1.status='1' AND i1.archive=0
MySQL server has gone away
SELECT count(*) as totalitems FROM dst_cat_item i1 INNER JOIN dst_cat_sectitem cc1 ON i1.id=cc1.item_id AND cc1.sect_id='1' INNER JOIN dst_cat_producer m1 ON i1.make_id=m1.id INNER JOIN dst_cat_section c1 ON cc1.sect_id=c1.id WHERE i1.id<>0 AND i1.status='2' AND i1.archive=0
MySQL server has gone away
SELECT count(*) as totalitems FROM dst_cat_item i1 INNER JOIN dst_cat_sectitem cc1 ON i1.id=cc1.item_id AND cc1.sect_id='1' INNER JOIN dst_cat_producer m1 ON i1.make_id=m1.id INNER JOIN dst_cat_section c1 ON cc1.sect_id=c1.id WHERE i1.id<>0 AND i1.status='3' AND i1.archive=0
MySQL server has gone away
SELECT count(*) as totalitems FROM dst_cat_item i1 INNER JOIN dst_cat_sectitem cc1 ON i1.id=cc1.item_id AND cc1.sect_id='1' INNER JOIN dst_cat_producer m1 ON i1.make_id=m1.id INNER JOIN dst_cat_section c1 ON cc1.sect_id=c1.id WHERE i1.id<>0 AND i1.status='4' AND i1.archive=0
MySQL server has gone away
SELECT count(*) as totalitems FROM dst_cat_item i1 INNER JOIN dst_cat_sectitem cc1 ON i1.id=cc1.item_id AND cc1.sect_id='1' INNER JOIN dst_cat_producer m1 ON i1.make_id=m1.id INNER JOIN dst_cat_section c1 ON cc1.sect_id=c1.id INNER JOIN dst_cat_action_items ai1 ON i1.id=ai1.prod_id INNER JOIN dst_cat_actions a1 ON ai1.act_id=a1.id AND a1.active=1 WHERE i1.id<>0 AND i1.status='0' AND i1.archive=0
MySQL server has gone away

Знайдено 96 товарів

Сортувати:

за популярністю

SELECT count(*) as totcomments FROM dst_cat_item_comment WHERE prod_id='1472' AND visible=1
MySQL server has gone away
SELECT avg(rate) as avgrate FROM dst_cat_item_comment WHERE prod_id='1472' AND visible=1
MySQL server has gone away

Caterpillar

Черевики Caterpillar Colorado Galosh WP P726082 Green

7 480 грн.

5 980 грн.

Купити

41424344

SELECT count(*) as totcomments FROM dst_cat_item_comment WHERE prod_id='1384' AND visible=1
MySQL server has gone away
SELECT avg(rate) as avgrate FROM dst_cat_item_comment WHERE prod_id='1384' AND visible=1
MySQL server has gone away

Puma

Кросівки Puma Park Lifestyle 39508403 Black

3 230 грн.

Купити

4245

SELECT count(*) as totcomments FROM dst_cat_item_comment WHERE prod_id='749' AND visible=1
MySQL server has gone away
SELECT avg(rate) as avgrate FROM dst_cat_item_comment WHERE prod_id='749' AND visible=1
MySQL server has gone away

New Balance

Кросівки New Balance 9060 U9060BLK Black

7 899 грн.

5 499 грн.

Купити

SELECT count(*) as totcomments FROM dst_cat_item_comment WHERE prod_id='677' AND visible=1
MySQL server has gone away
SELECT avg(rate) as avgrate FROM dst_cat_item_comment WHERE prod_id='677' AND visible=1
MySQL server has gone away

Caterpillar

Кросівки Caterpillar Vapor Web P110609 Black

6 699 грн.

5 359 грн.

Купити

414243

SELECT count(*) as totcomments FROM dst_cat_item_comment WHERE prod_id='1557' AND visible=1
MySQL server has gone away
SELECT avg(rate) as avgrate FROM dst_cat_item_comment WHERE prod_id='1557' AND visible=1
MySQL server has gone away

Converse

Кеди Converse Chuck 70 Sketch Puffed Ox A10562C Black

4 199 грн.

2 499 грн.

Купити

4142434445

SELECT count(*) as totcomments FROM dst_cat_item_comment WHERE prod_id='1580' AND visible=1
MySQL server has gone away
SELECT avg(rate) as avgrate FROM dst_cat_item_comment WHERE prod_id='1580' AND visible=1
MySQL server has gone away

Vans

Кеди Vans Knu Skool VN000D6CBXC1 Grey

4 199 грн.

Купити

42434445

SELECT count(*) as totcomments FROM dst_cat_item_comment WHERE prod_id='676' AND visible=1
MySQL server has gone away
SELECT avg(rate) as avgrate FROM dst_cat_item_comment WHERE prod_id='676' AND visible=1
MySQL server has gone away

Caterpillar

Кросівки Caterpillar Raider Lace P110599 Black

6 111 грн.

4 889 грн.

Купити

414243

SELECT count(*) as totcomments FROM dst_cat_item_comment WHERE prod_id='85' AND visible=1
MySQL server has gone away
SELECT avg(rate) as avgrate FROM dst_cat_item_comment WHERE prod_id='85' AND visible=1
MySQL server has gone away

Converse

Кеди Converse Chuck Taylor All Star Ox M9166C Black

3 199 грн.

2 359 грн.

Купити

3738394041424445

SELECT count(*) as totcomments FROM dst_cat_item_comment WHERE prod_id='89' AND visible=1
MySQL server has gone away
SELECT avg(rate) as avgrate FROM dst_cat_item_comment WHERE prod_id='89' AND visible=1
MySQL server has gone away

Converse

Кеди Converse Chuck Taylor All Star Ox M9697C Navy

3 199 грн.

2 359 грн.

Купити

3538

SELECT count(*) as totcomments FROM dst_cat_item_comment WHERE prod_id='724' AND visible=1
MySQL server has gone away
SELECT avg(rate) as avgrate FROM dst_cat_item_comment WHERE prod_id='724' AND visible=1
MySQL server has gone away

New Balance

Кросівки New Balance BB480 BB480COB Black

4 319 грн.

1 999 грн.

Купити

41,542

SELECT count(*) as totcomments FROM dst_cat_item_comment WHERE prod_id='682' AND visible=1
MySQL server has gone away
SELECT avg(rate) as avgrate FROM dst_cat_item_comment WHERE prod_id='682' AND visible=1
MySQL server has gone away

Caterpillar

Кросівки Caterpillar Intruder P723902 White

6 299 грн.

5 039 грн.

Купити

4244

SELECT count(*) as totcomments FROM dst_cat_item_comment WHERE prod_id='1421' AND visible=1
MySQL server has gone away
SELECT avg(rate) as avgrate FROM dst_cat_item_comment WHERE prod_id='1421' AND visible=1
MySQL server has gone away

Puma

Черевики Puma Trinity Mid Hybrid Leather 39398509 Beige

4 099 грн.

Купити

424344

SELECT count(*) as totcomments FROM dst_cat_item_comment WHERE prod_id='692' AND visible=1
MySQL server has gone away
SELECT avg(rate) as avgrate FROM dst_cat_item_comment WHERE prod_id='692' AND visible=1
MySQL server has gone away

Converse

Кеди Converse Chuck 70 HI A06520C Begie

4 199 грн.

2 799 грн.

Купити

4344

SELECT count(*) as totcomments FROM dst_cat_item_comment WHERE prod_id='1579' AND visible=1
MySQL server has gone away
SELECT avg(rate) as avgrate FROM dst_cat_item_comment WHERE prod_id='1579' AND visible=1
MySQL server has gone away

Vans

Кеди Vans LX Old Skool VN000D56MCG1 Black/Yellow

4 199 грн.

Купити

4042434445

SELECT count(*) as totcomments FROM dst_cat_item_comment WHERE prod_id='1401' AND visible=1
MySQL server has gone away
SELECT avg(rate) as avgrate FROM dst_cat_item_comment WHERE prod_id='1401' AND visible=1
MySQL server has gone away

Vans

Кросівки Vans Rowley Xlt VN000CTM1O71 Grey

5 999 грн.

Купити

424344

SELECT count(*) as totcomments FROM dst_cat_item_comment WHERE prod_id='1455' AND visible=1
MySQL server has gone away
SELECT avg(rate) as avgrate FROM dst_cat_item_comment WHERE prod_id='1455' AND visible=1
MySQL server has gone away

Puma

Черевики Puma Trinity Mid Hybrid 39232701 Black

3 999 грн.

Купити

414344

SELECT count(*) as totcomments FROM dst_cat_item_comment WHERE prod_id='259' AND visible=1
MySQL server has gone away
SELECT avg(rate) as avgrate FROM dst_cat_item_comment WHERE prod_id='259' AND visible=1
MySQL server has gone away

Vans

Кеди Vans Sk8-Hi Flame VN0005UJBZW1 Black

4 454 грн.

Купити

SELECT count(*) as totcomments FROM dst_cat_item_comment WHERE prod_id='675' AND visible=1
MySQL server has gone away
SELECT avg(rate) as avgrate FROM dst_cat_item_comment WHERE prod_id='675' AND visible=1
MySQL server has gone away

Caterpillar

Кросівки Caterpillar Raider Sport P110597 Black

6 111 грн.

4 889 грн.

Купити

41424344

SELECT count(*) as totcomments FROM dst_cat_item_comment WHERE prod_id='687' AND visible=1
MySQL server has gone away
SELECT avg(rate) as avgrate FROM dst_cat_item_comment WHERE prod_id='687' AND visible=1
MySQL server has gone away

Converse

Кросівки Converse As-1 Pro Ox A04957C White

4 499 грн.

2 789 грн.

Купити

424344

SELECT count(*) as totcomments FROM dst_cat_item_comment WHERE prod_id='1576' AND visible=1
MySQL server has gone away
SELECT avg(rate) as avgrate FROM dst_cat_item_comment WHERE prod_id='1576' AND visible=1
MySQL server has gone away

Vans

Кеди Vans Knu Skool VN0009QCB9M1 Black/Gum

4 299 грн.

Купити

424344

SELECT count(*) as totcomments FROM dst_cat_item_comment WHERE prod_id='685' AND visible=1
MySQL server has gone away
SELECT avg(rate) as avgrate FROM dst_cat_item_comment WHERE prod_id='685' AND visible=1
MySQL server has gone away

Caterpillar

Черевики Caterpillar Crail Sport Mid P725600 Black

6 999 грн.

5 599 грн.

Купити

SELECT count(*) as totcomments FROM dst_cat_item_comment WHERE prod_id='1578' AND visible=1
MySQL server has gone away
SELECT avg(rate) as avgrate FROM dst_cat_item_comment WHERE prod_id='1578' AND visible=1
MySQL server has gone away

Vans

Кеди Vans LX Old Skool VN000D564581 Black/Red

4 399 грн.

Купити

404142434445

SELECT count(*) as totcomments FROM dst_cat_item_comment WHERE prod_id='1221' AND visible=1
MySQL server has gone away
SELECT avg(rate) as avgrate FROM dst_cat_item_comment WHERE prod_id='1221' AND visible=1
MySQL server has gone away

Dr. Martens

Черевики Dr. Martens Tarik Extra Tough Nylon 27017001 Black

6 799 грн.

Купити

414344

SELECT count(*) as totcomments FROM dst_cat_item_comment WHERE prod_id='1199' AND visible=1
MySQL server has gone away
SELECT avg(rate) as avgrate FROM dst_cat_item_comment WHERE prod_id='1199' AND visible=1
MySQL server has gone away

Caterpillar

Кросівки Caterpillar Intruder Mecha P111427 Black

5 399 грн.

Купити

Показати ще 24 товара

1 234

від		до		грн.

SELECT b1.*, bl1.alttext FROM dst_banners b1 INNER JOIN dst_banners_lang bl1 ON b1.id=bl1.banner_id AND bl1.lang_id='2' WHERE b1.managetype=0 AND b1.page_url LIKE 'https://district.ua/sect/men-shoes/puma,vans,thenorthface,nativeshoes,caterpillar,newbalance,converse,drmartens/p_3.html%' AND b1.disppos='0' ORDER BY b1.sort_num
MySQL server has gone away