District

Чоловіче взуття Vans, Converse, New Balance, Puma Кеди, 42

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
Знайдено 15 товарів
Сортувати:
за популярністю
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 Old Skool VN000D3HY281 Black
Vans
3 449 грн.
42,5434444,5454636373839404142
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 Chuck Taylor All Star Hi M9622C Navy
Converse
3 299 грн.
2 289 грн.
363739424344
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 Chuck 70 Archive Flame 165024C Black
Converse
4 299 грн.
3 279 грн.
3839404142434445
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
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
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
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 Chuck Taylor All Star Ox M7652C Optic White
Converse
3 199 грн.
2 359 грн.
3536384142434446
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
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
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
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
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 Chuck Taylor All Star Ox M9166C Black
Converse
3 199 грн.
2 359 грн.
373839404142434445
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 Old Skool VN000D3HNVY1 Navy
Vans
3 689 грн.
2 949 грн.
4142
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 Chuck Taylor All Star Ox Leather 132174C Black
Converse
3 999 грн.
2 299 грн.
3842434445
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
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
Фільтри
Ціна, (грн.)
від до грн.
Бренди
Розмір
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/vans,converse,newbalance,puma/f-6_22_kedy-8_53_42/index.html%' AND b1.disppos='0' ORDER BY b1.sort_num
MySQL server has gone away
В вашому кошику
В кошику немає товарів
Зачекайте
Триває завантаження даних...