Мужская обувь Native, Puma, Vans 42, 40, 43

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

Найдено 23 товара

Сортировать по:

по популярности

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='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 грн.

Купить

434445463738394042

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='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='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='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='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 грн.

Купить

4344

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='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='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='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 грн.

Купить

414243

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

Vans

Кроссовки Vans Rowley XLT VN000CTMBA21 Black

5 939 грн.

Купить

424344

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='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

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

Vans

Кеды Vans Knu Skool VN000D6CWTM1 Beige

4 199 грн.

Купить

42434446

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 b1.*, bl1.alttext FROM dst_banners b1 INNER JOIN dst_banners_lang bl1 ON b1.id=bl1.banner_id AND bl1.lang_id='1' WHERE b1.managetype=0 AND b1.page_url LIKE 'https://district.ua/ru/sect/men-shoes/nativeshoes,puma,vans/f-8_53_42-8_51_40-8_54_43/index.html%' AND b1.disppos='0' ORDER BY b1.sort_num
MySQL server has gone away