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_3); waiting for someone to free some space...
SELECT DISTINCT p1.url as make_url, i1.*, i2.model2, i2.descr, i2.descr0, m1.make_name as producer, cc1.name as section, max(pr1.price) as maxcost, min(pr1.price) as mincost, max(pr1.availiable_now) as sortexist, case when max(pr1.price)=0 then 1 else 0 end as sortcost, cc1.sect_id as sectid FROM dst_cat_item i1 INNER JOIN dst_cat_item_lang i2 ON i1.id=i2.item_id AND i2.lang_id='2' INNER JOIN dst_cat_sectitem c1 ON i1.id=c1.item_id AND c1.sect_id='5' INNER JOIN dst_cat_producer_lang m1 ON ( (i1.make_id=4) OR (i1.make_id=8) OR (i1.make_id=15) OR (i1.make_id=5) ) AND i1.make_id=m1.make_id AND m1.lang_id='2' INNER JOIN dst_cat_producer p1 ON p1.id=m1.make_id INNER JOIN dst_cat_section_lang cc1 ON c1.sect_id=cc1.sect_id AND cc1.lang_id='2' LEFT JOIN dst_cat_price pr1 ON i1.id=pr1.item_id INNER JOIN dst_cat_filters_value v0 ON i1.id=v0.item_id AND v0.param_id=7 AND v0.value=0 INNER JOIN dst_cat_filters_valueopts owi0 ON v0.id=owi0.param_value_id AND owi0.option_id IN (34,31,27) WHERE i1.archive=0 GROUP BY i1.id ORDER BY sortexist DESC, sortcost, item_rate DESC LIMIT 0,24
Disk full (/var/tmp/#sql_112e_0); waiting for someone to free some space...
Жіноче взуття Converse, Vans, Buffalo London, Dr. Martens – інтернет магазин District
District
0
0
Головна
Жіноче взуття

Жіноче взуття Converse, Vans, Buffalo London, Dr. Martens 42, 39, 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
Знайдено 83 товари
Сортувати:
за популярністю
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 c1.parent_id, c1.id, c1.url, c1.filename, c1.is_link, c2.name, c2.descr, c1.menu_group_id, cp1.id as pid, cp1.url as purl, g2.title as grouptitle, g1.id as groupid, case when g1.sort_num IS NOT NULL then g1.sort_num else 1000 end as groupsort FROM dst_cat_section c1 INNER JOIN dst_cat_section_lang c2 ON c1.id=c2.sect_id AND c2.lang_id='2' LEFT JOIN dst_cat_section cp1 ON c1.parent_id=cp1.id LEFT JOIN dst_cat_section_groups g1 ON c1.menu_group_id=g1.id LEFT JOIN dst_cat_section_groups_lang g2 ON c1.menu_group_id=g2.sect_group_id AND g2.lang_id='2' WHERE c1.parent_id='5' AND c1.visible=1 ORDER BY groupsort,c1.sort_num
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/converse,vans,buffalolondon,drmartens/f-7_34_42-7_31_39-7_27_35/index.html%' AND b1.disppos='0' ORDER BY b1.sort_num
MySQL server has gone away
В вашому кошику
В кошику немає товарів
Зачекайте
Триває завантаження даних...