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

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

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

Сортувати:

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

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

Vans

Кеди Vans Old Skool VN000CR50ZB1 Black

3 999 грн.

Купити

4344

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

Vans

Кеди Vans Old Skool Vr3 VN0005UFBMA1 Black

3 680 грн.

Купити

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

Caterpillar

Кросівки Caterpillar Intruder Max P111450 Black/Yellow

6 999 грн.

5 949 грн.

Купити

4145

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

Caterpillar

Кросівки Caterpillar Intruder P110463 Black

4 999 грн.

Купити

4142434445

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

Caterpillar

Черевики Caterpillar Colorado 2.0 P110428 Honey Reset

6 111 грн.

4 889 грн.

Купити

394041424345

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

Vans

Кеди Vans Knu Skool Jumbo VN0009QCBA21 Black

4 099 грн.

Купити

4244

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

Puma

Черевики Puma Trinity Mid Hybrid L 39398510 Grey

4 099 грн.

Купити

424344

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

Puma

Кросівки Puma Club II Era Suede 40071701 Black

3 199 грн.

Купити

4144

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

Caterpillar

Черевики Caterpillar Intruder Galosh 2.0 Mid WP P111559 Black

7 150 грн.

5 999 грн.

Купити

404244

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

Puma

Кросівки Puma Morphic Athletic 39591905 Black

3 600 грн.

3 240 грн.

Купити

414244

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

Puma

Кросівки Puma Morphic Base 39298202 White

3 590 грн.

3 231 грн.

Купити

394041

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

Puma

Кросівки Puma Morphic Retro 39592003 Black

3 899 грн.

Купити

41424345

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

Vans

Кеди Vans Old Skool VN000D3HY281 Black

3 449 грн.

Купити

4344454637383940

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

Vans

Кеди Vans Knu Skool VN0009QCNWH1 Brown

4 599 грн.

Купити

4243

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

Puma

Кросівки Puma Morphic Athletic 39591901 Black

3 600 грн.

3 240 грн.

Купити

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

Puma

Кросівки Puma ST Runner v4 L 39906809 Black

2 871 грн.

Купити

4142434445

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

Caterpillar

Кросівки Caterpillar Intruder Galosh 2.0 Low WP P111554 Black

6 930 грн.

5 499 грн.

Купити

41424344

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

Puma

Черевики Puma Obstruct Pro Mid Trail 37868912 Black

3 860 грн.

Купити

4142434445

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

Caterpillar

Кросівки Caterpillar Intruder P723901 Black

5 890 грн.

Купити

41434445

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

Caterpillar

Черевики Caterpillar Colorado Hardwear P111518 Black

6 930 грн.

5 799 грн.

Купити

424344

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

Caterpillar

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

6 299 грн.

5 039 грн.

Купити

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

Vans

Кеди Vans Old Skool VN000D3HNVY1 Navy

3 689 грн.

2 949 грн.

Купити

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

Caterpillar

Черевики Caterpillar Colorado 2.0 P110425 Black

6 111 грн.

4 889 грн.

Купити

3940414243444546

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

Vans

Кеди Vans Old Skool VN0A3WKT5WU1 Black

3 449 грн.

Купити

424344

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

12 3

від		до		грн.

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/drmartens,puma,caterpillar,thenorthface,nativeshoes,vans/index.html%' AND b1.disppos='0' ORDER BY b1.sort_num
MySQL server has gone away