SELECT DISTINCT m1.id, m1.url, m1.first_page, m2.make_name, m2.descr, ic.cnt as totprods FROM dst_cat_sectitem c1 INNER JOIN dst_cat_item i1 ON c1.item_id=i1.id AND i1.archive=0 INNER JOIN dst_cat_producer m1 ON i1.make_id=m1.id INNER JOIN dst_cat_producer_lang m2 ON m1.id=m2.make_id AND m2.lang_id='2' LEFT JOIN dst_cat_item_count_cache ic ON ic.sect_id = c1.sect_id AND ic.make_id = m1.id AND ic.car_id = 0 WHERE c1.sect_id='5' ORDER BY m2.make_name
Disk full (/var/tmp/#sql_112e_0); waiting for someone to free some space...
Жіноче взуття Dr. Martens, Nike, Vans, Puma – інтернет магазин District
District

Жіноче взуття Dr. Martens, Nike, Vans, Puma 42, 40, 35

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='5' 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='5' 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='5' 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='5' 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='5' 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='5' 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
Знайдено 32 товари
Сортувати:
за популярністю
SELECT count(*) as totcomments FROM dst_cat_item_comment WHERE prod_id='1216' AND visible=1
MySQL server has gone away
SELECT avg(rate) as avgrate FROM dst_cat_item_comment WHERE prod_id='1216' AND visible=1
MySQL server has gone away
SELECT count(*) as totcomments FROM dst_cat_item_comment WHERE prod_id='583' AND visible=1
MySQL server has gone away
SELECT avg(rate) as avgrate FROM dst_cat_item_comment WHERE prod_id='583' AND visible=1
MySQL server has gone away
SELECT count(*) as totcomments FROM dst_cat_item_comment WHERE prod_id='442' AND visible=1
MySQL server has gone away
SELECT avg(rate) as avgrate FROM dst_cat_item_comment WHERE prod_id='442' AND visible=1
MySQL server has gone away
SELECT count(*) as totcomments FROM dst_cat_item_comment WHERE prod_id='1352' AND visible=1
MySQL server has gone away
SELECT avg(rate) as avgrate FROM dst_cat_item_comment WHERE prod_id='1352' AND visible=1
MySQL server has gone away
SELECT count(*) as totcomments FROM dst_cat_item_comment WHERE prod_id='718' AND visible=1
MySQL server has gone away
SELECT avg(rate) as avgrate FROM dst_cat_item_comment WHERE prod_id='718' AND visible=1
MySQL server has gone away
SELECT count(*) as totcomments FROM dst_cat_item_comment WHERE prod_id='719' AND visible=1
MySQL server has gone away
SELECT avg(rate) as avgrate FROM dst_cat_item_comment WHERE prod_id='719' AND visible=1
MySQL server has gone away
SELECT count(*) as totcomments FROM dst_cat_item_comment WHERE prod_id='1219' AND visible=1
MySQL server has gone away
SELECT avg(rate) as avgrate FROM dst_cat_item_comment WHERE prod_id='1219' AND visible=1
MySQL server has gone away
SELECT count(*) as totcomments FROM dst_cat_item_comment WHERE prod_id='1574' AND visible=1
MySQL server has gone away
SELECT avg(rate) as avgrate FROM dst_cat_item_comment WHERE prod_id='1574' AND visible=1
MySQL server has gone away
SELECT count(*) as totcomments FROM dst_cat_item_comment WHERE prod_id='453' AND visible=1
MySQL server has gone away
SELECT avg(rate) as avgrate FROM dst_cat_item_comment WHERE prod_id='453' AND visible=1
MySQL server has gone away
SELECT count(*) as totcomments FROM dst_cat_item_comment WHERE prod_id='714' AND visible=1
MySQL server has gone away
SELECT avg(rate) as avgrate FROM dst_cat_item_comment WHERE prod_id='714' AND visible=1
MySQL server has gone away
Босоніжки Dr. Martens Voss Hydro Leather 23802001 Black
Dr. Martens
6 570 грн.
5 913 грн.
37383940
SELECT count(*) as totcomments FROM dst_cat_item_comment WHERE prod_id='433' AND visible=1
MySQL server has gone away
SELECT avg(rate) as avgrate FROM dst_cat_item_comment WHERE prod_id='433' AND visible=1
MySQL server has gone away
Черевики Dr. Martens Vegan 1460 Felix Lace Up 14045001 Black
Dr. Martens
6 800 грн.
6 200 грн.
3738394041
SELECT count(*) as totcomments FROM dst_cat_item_comment WHERE prod_id='460' AND visible=1
MySQL server has gone away
SELECT avg(rate) as avgrate FROM dst_cat_item_comment WHERE prod_id='460' AND visible=1
MySQL server has gone away
SELECT count(*) as totcomments FROM dst_cat_item_comment WHERE prod_id='1454' AND visible=1
MySQL server has gone away
SELECT avg(rate) as avgrate FROM dst_cat_item_comment WHERE prod_id='1454' AND visible=1
MySQL server has gone away
SELECT count(*) as totcomments FROM dst_cat_item_comment WHERE prod_id='424' AND visible=1
MySQL server has gone away
SELECT avg(rate) as avgrate FROM dst_cat_item_comment WHERE prod_id='424' AND visible=1
MySQL server has gone away
Черевики Dr. Martens 1460 Nappa 11822002 Black
Dr. Martens
6 800 грн.
6 400 грн.
3738404142
SELECT count(*) as totcomments FROM dst_cat_item_comment WHERE prod_id='451' AND visible=1
MySQL server has gone away
SELECT avg(rate) as avgrate FROM dst_cat_item_comment WHERE prod_id='451' AND visible=1
MySQL server has gone away
Черевики Dr. Martens Sinclair White Milled Nappa 26261100
Dr. Martens
7 900 грн.
5 900 грн.
3637383940
SELECT count(*) as totcomments FROM dst_cat_item_comment WHERE prod_id='1220' AND visible=1
MySQL server has gone away
SELECT avg(rate) as avgrate FROM dst_cat_item_comment WHERE prod_id='1220' AND visible=1
MySQL server has gone away
SELECT count(*) as totcomments FROM dst_cat_item_comment WHERE prod_id='1416' AND visible=1
MySQL server has gone away
SELECT avg(rate) as avgrate FROM dst_cat_item_comment WHERE prod_id='1416' AND visible=1
MySQL server has gone away
SELECT count(*) as totcomments FROM dst_cat_item_comment WHERE prod_id='887' AND visible=1
MySQL server has gone away
SELECT avg(rate) as avgrate FROM dst_cat_item_comment WHERE prod_id='887' AND visible=1
MySQL server has gone away
SELECT count(*) as totcomments FROM dst_cat_item_comment WHERE prod_id='427' AND visible=1
MySQL server has gone away
SELECT avg(rate) as avgrate FROM dst_cat_item_comment WHERE prod_id='427' AND visible=1
MySQL server has gone away
Черевики Dr. Martens 1460 Smooth 11822100 White
Dr. Martens
6 800 грн.
5 950 грн.
363738394041
SELECT count(*) as totcomments FROM dst_cat_item_comment WHERE prod_id='721' AND visible=1
MySQL server has gone away
SELECT avg(rate) as avgrate FROM dst_cat_item_comment WHERE prod_id='721' AND visible=1
MySQL server has gone away
SELECT count(*) as totcomments FROM dst_cat_item_comment WHERE prod_id='239' AND visible=1
MySQL server has gone away
SELECT avg(rate) as avgrate FROM dst_cat_item_comment WHERE prod_id='239' AND visible=1
MySQL server has gone away
SELECT count(*) as totcomments FROM dst_cat_item_comment WHERE prod_id='436' AND visible=1
MySQL server has gone away
SELECT avg(rate) as avgrate FROM dst_cat_item_comment WHERE prod_id='436' AND visible=1
MySQL server has gone away
Черевики Dr. Martens Jadon Polished Smooth 15265001 Black
Dr. Martens
9 150 грн.
8 950 грн.
37383940
SELECT count(*) as totcomments FROM dst_cat_item_comment WHERE prod_id='722' AND visible=1
MySQL server has gone away
SELECT avg(rate) as avgrate FROM dst_cat_item_comment WHERE prod_id='722' AND visible=1
MySQL server has gone away
Босоніжки Dr. Martens Pearson II Webbing 30822001 Black
Dr. Martens
6 570 грн.
5 913 грн.
37384142
SELECT count(*) as totcomments FROM dst_cat_item_comment WHERE prod_id='1391' AND visible=1
MySQL server has gone away
SELECT avg(rate) as avgrate FROM dst_cat_item_comment WHERE prod_id='1391' AND visible=1
MySQL server has gone away
12
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='5' 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='5' 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='5' 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='5' 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='5' 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/women-shoes/drmartens,nike,vans,puma/f-7_34_42-7_32_40-7_27_35/index.html%' AND b1.disppos='0' ORDER BY b1.sort_num
MySQL server has gone away
В вашому кошику
В кошику немає товарів
Зачекайте
Триває завантаження даних...