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

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

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

Сортувати:

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

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='1203' AND visible=1
MySQL server has gone away
SELECT avg(rate) as avgrate FROM dst_cat_item_comment WHERE prod_id='1203' AND visible=1
MySQL server has gone away

Converse

Кеди Converse Chuck 70 Archive Flame 165024C Black

4 299 грн.

3 279 грн.

Купити

383941424345

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

New Balance

Кросівки New Balance 530 MR530EMA White

5 999 грн.

3 999 грн.

Купити

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='1230' AND visible=1
MySQL server has gone away
SELECT avg(rate) as avgrate FROM dst_cat_item_comment WHERE prod_id='1230' AND visible=1
MySQL server has gone away

New Balance

Кросівки New Balance 2002R M2002RFB Grey

6 999 грн.

4 399 грн.

Купити

41,5424344

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

New Balance

Кросiвки New Balance 410 MT410LB8 Black

3 599 грн.

2 499 грн.

Купити

41,54245

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

Converse

Кеди Converse Chuck Taylor All Star Ox Leather 132174C Black

3 999 грн.

2 299 грн.

Купити

384244

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

Converse

Кеди Converse Chuck Taylor All Star Hi M9622C Navy

3 299 грн.

2 289 грн.

Купити

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

Converse

Кеди Converse Chuck Taylor All Star Hi Monochrome M3310C Black

3 299 грн.

2 289 грн.

Купити

3637383941

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='99' AND visible=1
MySQL server has gone away
SELECT avg(rate) as avgrate FROM dst_cat_item_comment WHERE prod_id='99' AND visible=1
MySQL server has gone away

New Balance

Кросівки New Balance 2002R M2002RBK Black

6 999 грн.

4 399 грн.

Купити

41,54244

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='81' AND visible=1
MySQL server has gone away
SELECT avg(rate) as avgrate FROM dst_cat_item_comment WHERE prod_id='81' AND visible=1
MySQL server has gone away

Converse

Кеди Converse Chuck Taylor All Star Ox M7652C Optic White

3 199 грн.

2 359 грн.

Купити

36384142434446

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='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='1608' AND visible=1
MySQL server has gone away
SELECT avg(rate) as avgrate FROM dst_cat_item_comment WHERE prod_id='1608' AND visible=1
MySQL server has gone away

New Balance

Кросівки New Balance DynaSoft Nitrel v6 MTNTRLF6 Black

4 899 грн.

3 599 грн.

Купити

41,542434445

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

Converse

Кеди Converse Chuck Taylor All Star Ox M9696C Red

3 199 грн.

2 359 грн.

Купити

3738394344

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='737' AND visible=1
MySQL server has gone away
SELECT avg(rate) as avgrate FROM dst_cat_item_comment WHERE prod_id='737' AND visible=1
MySQL server has gone away

New Balance

Кросівки New Balance 1906R M1906RRC Metallic Teal

7 599 грн.

5 099 грн.

Купити

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

New Balance

Кросівки New Balance BB480 V1 BB480L3W White

3 959 грн.

2 299 грн.

Купити

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

12 3 4

від		до		грн.

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