Главная страница → Каталог → Дымоходы и дымососы → Дымососы → Дымососы для газовых агрегатов в многоэтажных домах

Дымососы для газовых агрегатов в многоэтажных домах

Механическая система отвода газов (для агрегатов на газовом топливе) - многоагрегатный дымоход

•   Оптимальная тяга в дымоходе
•   Нет обратного хода газов
•   Вытяжка воздуха из внутренних помещений
•   Интегрированный предохранительный механизм

Применение

Механическая система отвода газа применяется в многоэтажных жилых домах с газовыми агрегатами, подключенными к одному дымоходу или одной вытяжной вентиляционной шахте.

gaz-kamin2

Дымосос

Дымосос RSV с вертикальным выбросом отходящих газов

Выключатель обслуживания

Выключатель обслуживания REPU-2 Polig

Автоматика выхлопного газа

EBC20

Монтажная коробка

Регулирующее устройство

EKG

Тепловой клапан выхлопного газа

GWR

Выхлопной клапан

URH

Фланец для крепления и монтажа дымососов

frsv Фланец FRSV

Функции

Отвод газа происходит через монтируемый на верхнюю часть дымохода дымосос типа RSV.

Управляется он через реле давления EBC 20, устанавливаемое между дымососом и верхним камином. Реле обеспечивает стабильную тягу в дымоходе всей системы отвода газов.

Для регулировки газового потока и предотвращения охлаждения мест установки в соединительную систему встраивается дроссельный клапан тип EKG и термический клапан тип GWR.

Если же инсталлируются приборы, которые не подвергались проверке по DVGW, G626 или не зарегистрированы (как правило, приборы без контроля токсичности ОГ), то можно дополнительно использовать контроллер безопасности. Для этого в главный газоход инсталлируется газовый магнитный клапан.

Он закрывается автоматическим устройством EBC 20 при сокращении тяги в дымовой трубе.

Также для вентиляции, например, внутри расположенных ванн и кухонь, к вытяжной вентиляционной шахте или дымоходу могут быть подсоединены вытяжные насадки-вентили.
Механическая система отвода газов соответствует техническим параметрам DVGW G 626 и DIN 18017, 3.

Гарантия завода-производителя: 2 года

Печи для дома, камины, банные печи, русские печи, барбекю, строительство печей, барбекю, каминов

Обратный звонок

Дежурный менеджер свяжется с вами в течение 15-20 минут, время работы дежурного менеджера — 9.00-18.00 в рабочие дни. Спасибо!

Информация о профиле

Application afterLoad: 0.000 seconds, 0.45 MB

Application afterInitialise: 0.046 seconds, 5.41 MB

Application afterRoute: 0.085 seconds, 9.03 MB

Application afterDispatch: 0.221 seconds, 20.53 MB

Application afterRender: 0.395 seconds, 22.99 MB

Использование памяти

24441104

Зарегистрировано запросов: 276

SELECT *
FROM glenrich_session
WHERE session_id = '26ftnl45lsc01a840pbjsa0bk3'
DELETE
FROM glenrich_session
WHERE ( TIME < '1781560182' )
SELECT *
FROM glenrich_session
WHERE session_id = '26ftnl45lsc01a840pbjsa0bk3'
INSERT INTO `glenrich_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( '26ftnl45lsc01a840pbjsa0bk3','1781563782','','0','1','0' )
SELECT *
FROM glenrich_components
WHERE parent = 0
SELECT folder AS TYPE, element AS name, params
  FROM glenrich_plugins
  WHERE published >= 1
  AND access <= 0
  ORDER BY ordering
SELECT oldurl, newurl
  FROM glenrich_redirection
  WHERE oldurl = 'dymohody-i-dymososy/dymososy/dymososy-dlya-gazovyh-agregatov-v-mnogoetazhnyh-domah.html'
  ORDER BY rank ASC
  LIMIT 1
UPDATE glenrich_redirection
  SET cpt=(cpt+1)
  WHERE `newurl` = 'index.php?option=com_virtuemart&Itemid=8&category_id=130&lang=ru&limitstart=0&page=shop.browse'
  AND `oldurl` = 'dymohody-i-dymososy/dymososy/dymososy-dlya-gazovyh-agregatov-v-mnogoetazhnyh-domah.html'
SELECT m.*, c.`option` AS component
  FROM glenrich_menu AS m
  LEFT JOIN glenrich_components AS c
  ON m.componentid = c.id
  WHERE m.published = 1
  ORDER BY m.sublevel, m.parent, m.ordering
SELECT m.*, c.`option` AS component
  FROM glenrich_menu AS m
  LEFT JOIN glenrich_components AS c
  ON m.componentid = c.id
  WHERE m.published = 1
  ORDER BY m.sublevel, m.parent, m.ordering
SELECT group_id,group_name,group_level
FROM `glenrich_vm_auth_group`
ORDER BY group_level
SELECT glenrich_vm_shopper_group.shopper_group_id, show_price_including_tax, `default`, shopper_group_discount

  FROM `glenrich_vm_shopper_group`
  WHERE glenrich_vm_shopper_group.vendor_id='1'
  AND `default`='1'
SELECT vendor_id, vendor_min_pov,vendor_name,vendor_store_name,contact_email,vendor_full_image, vendor_freeshipping,
vendor_address_1,vendor_address_2, vendor_url, vendor_city, vendor_state, vendor_country, country_2_code, country_3_code,
vendor_zip, vendor_phone, vendor_store_desc, vendor_currency, vendor_currency_display_style,
vendor_accepted_currencies, vendor_address_format, vendor_date_format, state_name

  FROM (`glenrich_vm_vendor` v, `glenrich_vm_country` c)

  LEFT JOIN glenrich_vm_state s
  ON (v.vendor_state=s.state_2_code
  AND s.country_id=c.country_id)

  WHERE `v`.`vendor_id`=1

  AND (`v`.`vendor_country`=`c`.`country_2_code` OR `v`.`vendor_country`=`c`.`country_3_code`);
SELECT module_perms
FROM glenrich_vm_module
WHERE module_name='shop'
SELECT id
  FROM glenrich_menu
  WHERE link='index.php?option=com_virtuemart'
  AND published=1
SELECT COUNT(*) AS parentcnt
FROM glenrich_vm_product
WHERE product_parent_id>0
SELECT COUNT(DISTINCT `glenrich_vm_product`.`product_sku`) AS num_rows
  FROM (`glenrich_vm_product`, `glenrich_vm_category`, `glenrich_vm_product_category_xref`,`glenrich_vm_shopper_group`)
  LEFT JOIN `glenrich_vm_product_price`
  ON `glenrich_vm_product`.`product_id` = `glenrich_vm_product_price`.`product_id`
  WHERE `glenrich_vm_product_category_xref`.`product_id`=`glenrich_vm_product`.`product_id`

  AND `glenrich_vm_product_category_xref`.`category_id`=`glenrich_vm_category`.`category_id`

  AND `glenrich_vm_product_category_xref`.`category_id`=130

  AND ((`glenrich_vm_product`.`product_id`=`glenrich_vm_product_price`.`product_id`
  AND `glenrich_vm_shopper_group`.`shopper_group_id`=`glenrich_vm_product_price`.`shopper_group_id`) OR `glenrich_vm_product_price`.`product_id` IS NULL)

  AND `glenrich_vm_shopper_group`.`default` = 1

  AND `product_parent_id`=0

  AND `product_publish`='Y'

  AND `category_publish`='Y'
SELECT category_id, category_name
FROM glenrich_vm_category
WHERE category_id='130'
SELECT category_id, category_description
FROM glenrich_vm_category
WHERE category_id='130'
SELECT category_id, category_thumb_image, category_child_id,category_name
  FROM glenrich_vm_category,glenrich_vm_category_xref
  WHERE glenrich_vm_category_xref.category_parent_id='130'
  AND glenrich_vm_category.category_id=glenrich_vm_category_xref.category_child_id
  AND glenrich_vm_category.vendor_id='1'
  AND glenrich_vm_category.category_publish='Y'
  ORDER BY glenrich_vm_category.list_order, glenrich_vm_category.category_name ASC
SELECT category_id, category_name,category_parent_id, category_child_id
  FROM glenrich_vm_category, glenrich_vm_category_xref
  WHERE glenrich_vm_category_xref.category_child_id='130'
  AND glenrich_vm_category.category_id='130'
SELECT category_id, category_name,category_parent_id, category_child_id
  FROM glenrich_vm_category, glenrich_vm_category_xref
  WHERE glenrich_vm_category_xref.category_child_id='51'
  AND glenrich_vm_category.category_id='51'
SELECT category_id, category_name,category_parent_id, category_child_id
  FROM glenrich_vm_category, glenrich_vm_category_xref
  WHERE glenrich_vm_category_xref.category_child_id='9'
  AND glenrich_vm_category.category_id='9'
SELECT id, params
  FROM glenrich_menu
  WHERE link='index.php?option=com_virtuemart'
  AND published=1
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=9&lang=ru&page=shop.browse'
SELECT name, link,id
  FROM glenrich_menu
  WHERE published='1'
  AND link LIKE 'index.php?option=com_virtuemart%'
SELECT c.category_name, c.category_id, x.category_parent_id
  FROM glenrich_vm_category AS c

  LEFT JOIN glenrich_vm_category_xref AS x
  ON c.category_id = x.category_child_id;
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=9&lang=ru&limitstart=0&page=shop.browse'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=51&lang=ru&page=shop.browse'
SELECT name, link,id
  FROM glenrich_menu
  WHERE published='1'
  AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=51&lang=ru&limitstart=0&page=shop.browse'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=130&lang=ru&page=shop.browse'
SELECT name, link,id
  FROM glenrich_menu
  WHERE published='1'
  AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=130&lang=ru&limitstart=0&page=shop.browse'
SELECT DISTINCT `glenrich_vm_product`.`product_id`, `product_name`, `products_per_row`, `category_browsepage`, `category_flypage`, `glenrich_vm_category`.`category_id`, `product_full_image`, `product_thumb_image`, `product_s_desc`, `product_parent_id`, `product_publish`, `product_in_stock`, `product_sku`, `product_url`, `product_weight`, `product_weight_uom`, `product_length`, `product_width`, `product_height`, `product_lwh_uom`, `product_available_date`, `product_availability`, `glenrich_vm_product`.`mdate`, `glenrich_vm_product`.`cdate`
  FROM (`glenrich_vm_product`, `glenrich_vm_category`, `glenrich_vm_product_category_xref`,`glenrich_vm_shopper_group`)
  LEFT JOIN `glenrich_vm_product_price`
  ON `glenrich_vm_product`.`product_id` = `glenrich_vm_product_price`.`product_id`
  WHERE `glenrich_vm_product_category_xref`.`product_id`=`glenrich_vm_product`.`product_id`

  AND `glenrich_vm_product_category_xref`.`category_id`=`glenrich_vm_category`.`category_id`

  AND `glenrich_vm_product_category_xref`.`category_id`=130

  AND ((`glenrich_vm_product`.`product_id`=`glenrich_vm_product_price`.`product_id`
  AND `glenrich_vm_shopper_group`.`shopper_group_id`=`glenrich_vm_product_price`.`shopper_group_id`) OR `glenrich_vm_product_price`.`product_id` IS NULL)

  AND `glenrich_vm_shopper_group`.`default` = 1

  AND `product_parent_id`=0

  AND `product_publish`='Y'

  AND `category_publish`='Y'

  GROUP BY `glenrich_vm_product`.`product_sku`

  ORDER BY `glenrich_vm_product_category_xref`.`product_list` ASC
  LIMIT 0, 12
SELECT DISTINCT product_sku,glenrich_vm_product.product_id,product_name,product_s_desc,product_thumb_image, product_full_image, product_in_stock, product_url
  FROM glenrich_vm_product, glenrich_vm_product_category_xref, glenrich_vm_category
  WHERE
(glenrich_vm_product.product_parent_id='' OR glenrich_vm_product.product_parent_id='0')

  AND glenrich_vm_product.product_id=glenrich_vm_product_category_xref.product_id

  AND glenrich_vm_category.category_id=glenrich_vm_product_category_xref.category_id

  AND glenrich_vm_category.category_id='130'

  AND glenrich_vm_product.product_publish='Y'

  AND glenrich_vm_product.product_special='Y'

  ORDER BY RAND()
  LIMIT 0, 10
SELECT template
  FROM glenrich_templates_menu
  WHERE client_id = 0
  AND (menuid = 0 OR menuid = 8)
  ORDER BY menuid DESC
  LIMIT 0, 1
SELECT m.*, am.params AS adv_params
  FROM glenrich_modules AS m
  LEFT JOIN glenrich_advancedmodules AS am
  ON am.moduleid = m.id
  WHERE m.published = 1
  AND m.access <= 0
  AND m.client_id = 0
  ORDER BY m.ordering, m.id
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&lang=ru&page=shop.search'
SELECT name, link,id
  FROM glenrich_menu
  WHERE published='1'
  AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&lang=ru&limitstart=0&page=shop.search'
SELECT group_id,group_name,group_level
FROM `glenrich_vm_auth_group`
ORDER BY group_level
SELECT published
FROM glenrich_modules
WHERE module='mod_virtuemart_cart'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=0
  AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=0
  AND a.category_publish='Y'
  ORDER BY a.list_order, a.category_name
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=1&lang=ru&page=shop.browse'
SELECT name, link,id
  FROM glenrich_menu
  WHERE published='1'
  AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=1&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=1
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
  WHERE a.category_id = f.category_id
  AND f.category_id=1
  AND a.category_publish='Y'
  AND p.product_id = f.product_id
  AND p.product_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=1
  AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=1
  AND a.category_publish='Y'
  ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=133
  AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=133
  AND a.category_publish='Y'
  ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=139
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=164
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=11
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=12
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=13
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=162
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=125
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=14
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=15
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=24
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=25
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=56
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=60
  AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=60
  AND a.category_publish='Y'
  ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=88
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=89
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=90
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=91
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=93
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=166
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=61
  AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=61
  AND a.category_publish='Y'
  ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=110
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=112
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=113
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=62
  AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=62
  AND a.category_publish='Y'
  ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=120
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=117
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=119
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=118
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=167
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=161
  AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=2&lang=ru&page=shop.browse'
SELECT name, link,id
  FROM glenrich_menu
  WHERE published='1'
  AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=2&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=2
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
  WHERE a.category_id = f.category_id
  AND f.category_id=2
  AND a.category_publish='Y'
  AND p.product_id = f.product_id
  AND p.product_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=2
  AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=2
  AND a.category_publish='Y'
  ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=132
  AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=132
  AND a.category_publish='Y'
  ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=135
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=136
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=137
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=145
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=16
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=17
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=140
  AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=140
  AND a.category_publish='Y'
  ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=141
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=142
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=143
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=18
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=19
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=20
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=22
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=157
  AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=157
  AND a.category_publish='Y'
  ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=158
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=159
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=23
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=21
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=144
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=54
  AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=6&lang=ru&page=shop.browse'
SELECT name, link,id
  FROM glenrich_menu
  WHERE published='1'
  AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=6&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=6
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
  WHERE a.category_id = f.category_id
  AND f.category_id=6
  AND a.category_publish='Y'
  AND p.product_id = f.product_id
  AND p.product_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=6
  AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=6
  AND a.category_publish='Y'
  ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=40
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=74
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=42
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=75
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=43
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=44
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=41
  AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=3&lang=ru&page=shop.browse'
SELECT name, link,id
  FROM glenrich_menu
  WHERE published='1'
  AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=3&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=3
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
  WHERE a.category_id = f.category_id
  AND f.category_id=3
  AND a.category_publish='Y'
  AND p.product_id = f.product_id
  AND p.product_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=3
  AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=3
  AND a.category_publish='Y'
  ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=26
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=27
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=28
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=29
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=124
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=30
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=31
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=163
  AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=4&lang=ru&page=shop.browse'
SELECT name, link,id
  FROM glenrich_menu
  WHERE published='1'
  AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=4&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=4
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
  WHERE a.category_id = f.category_id
  AND f.category_id=4
  AND a.category_publish='Y'
  AND p.product_id = f.product_id
  AND p.product_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=4
  AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=4
  AND a.category_publish='Y'
  ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=32
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=33
  AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=8&lang=ru&page=shop.browse'
SELECT name, link,id
  FROM glenrich_menu
  WHERE published='1'
  AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=8&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=8
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
  WHERE a.category_id = f.category_id
  AND f.category_id=8
  AND a.category_publish='Y'
  AND p.product_id = f.product_id
  AND p.product_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=8
  AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=8
  AND a.category_publish='Y'
  ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=48
  AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=48
  AND a.category_publish='Y'
  ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=94
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=95
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=96
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=97
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=103
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=104
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=168
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=49
  AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=9&lang=ru&page=shop.browse'
SELECT name, link,id
  FROM glenrich_menu
  WHERE published='1'
  AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=9&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=9
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
  WHERE a.category_id = f.category_id
  AND f.category_id=9
  AND a.category_publish='Y'
  AND p.product_id = f.product_id
  AND p.product_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=9
  AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=9
  AND a.category_publish='Y'
  ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=50
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=51
  AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=51
  AND a.category_publish='Y'
  ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=126
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=127
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=128
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=129
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=130
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=9
  AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=9
  AND a.category_publish='Y'
  ORDER BY a.list_order, a.category_name
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=50&lang=ru&page=shop.browse'
SELECT name, link,id
  FROM glenrich_menu
  WHERE published='1'
  AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=50&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=50
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
  WHERE a.category_id = f.category_id
  AND f.category_id=50
  AND a.category_publish='Y'
  AND p.product_id = f.product_id
  AND p.product_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=50
  AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=51&lang=ru&page=shop.browse'
SELECT name, link,id
  FROM glenrich_menu
  WHERE published='1'
  AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=51&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=51
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
  WHERE a.category_id = f.category_id
  AND f.category_id=51
  AND a.category_publish='Y'
  AND p.product_id = f.product_id
  AND p.product_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=51
  AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=51
  AND a.category_publish='Y'
  ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=126
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=127
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=128
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=129
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=130
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=51
  AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=51
  AND a.category_publish='Y'
  ORDER BY a.list_order, a.category_name
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=126&lang=ru&page=shop.browse'
SELECT name, link,id
  FROM glenrich_menu
  WHERE published='1'
  AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=126&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=126
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
  WHERE a.category_id = f.category_id
  AND f.category_id=126
  AND a.category_publish='Y'
  AND p.product_id = f.product_id
  AND p.product_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=126
  AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=127&lang=ru&page=shop.browse'
SELECT name, link,id
  FROM glenrich_menu
  WHERE published='1'
  AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=127&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=127
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
  WHERE a.category_id = f.category_id
  AND f.category_id=127
  AND a.category_publish='Y'
  AND p.product_id = f.product_id
  AND p.product_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=127
  AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=128&lang=ru&page=shop.browse'
SELECT name, link,id
  FROM glenrich_menu
  WHERE published='1'
  AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=128&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=128
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
  WHERE a.category_id = f.category_id
  AND f.category_id=128
  AND a.category_publish='Y'
  AND p.product_id = f.product_id
  AND p.product_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=128
  AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=129&lang=ru&page=shop.browse'
SELECT name, link,id
  FROM glenrich_menu
  WHERE published='1'
  AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=129&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=129
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
  WHERE a.category_id = f.category_id
  AND f.category_id=129
  AND a.category_publish='Y'
  AND p.product_id = f.product_id
  AND p.product_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=129
  AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=130&lang=ru&page=shop.browse'
SELECT name, link,id
  FROM glenrich_menu
  WHERE published='1'
  AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=130&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=130
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
  WHERE a.category_id = f.category_id
  AND f.category_id=130
  AND a.category_publish='Y'
  AND p.product_id = f.product_id
  AND p.product_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=130
  AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=7&lang=ru&page=shop.browse'
SELECT name, link,id
  FROM glenrich_menu
  WHERE published='1'
  AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=7&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=7
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
  WHERE a.category_id = f.category_id
  AND f.category_id=7
  AND a.category_publish='Y'
  AND p.product_id = f.product_id
  AND p.product_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=7
  AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=7
  AND a.category_publish='Y'
  ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=45
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=46
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=47
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=57
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=58
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=59
  AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=169&lang=ru&page=shop.browse'
SELECT name, link,id
  FROM glenrich_menu
  WHERE published='1'
  AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=169&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=169
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
  WHERE a.category_id = f.category_id
  AND f.category_id=169
  AND a.category_publish='Y'
  AND p.product_id = f.product_id
  AND p.product_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=169
  AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=170&lang=ru&page=shop.browse'
SELECT name, link,id
  FROM glenrich_menu
  WHERE published='1'
  AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=170&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=170
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
  WHERE a.category_id = f.category_id
  AND f.category_id=170
  AND a.category_publish='Y'
  AND p.product_id = f.product_id
  AND p.product_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=170
  AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=170
  AND a.category_publish='Y'
  ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=171
  AND a.category_publish='Y'
SELECT params
FROM glenrich_advancedmodules
WHERE moduleid = 41
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&lang=ru'
SELECT name, link,id
  FROM glenrich_menu
  WHERE published='1'
  AND link LIKE 'index.php?option=com_virtuemart%'
SELECT name, link,id
  FROM glenrich_menu
  WHERE id = '8'
  AND published='1'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&lang=ru&limitstart=0'
SELECT vendor_id, vendor_name, vendor_store_name, vendor_store_desc
FROM glenrich_vm_vendor
SELECT c.category_name, c.category_id, c.category_description, x.category_parent_id
  FROM glenrich_vm_category AS c

  LEFT JOIN glenrich_vm_category_xref AS x
  ON c.category_id = x.category_child_id;
SELECT id, metadesc, metakey, metatitle, metalang, metarobots
FROM glenrich_sh404SEF_meta
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=130&lang=ru&limitstart=0&page=shop.browse'

Зарегистрировано запросов старых компонентов: 276

SELECT *
FROM glenrich_session
WHERE session_id = '26ftnl45lsc01a840pbjsa0bk3'
DELETE
FROM glenrich_session
WHERE ( TIME < '1781560182' )
SELECT *
FROM glenrich_session
WHERE session_id = '26ftnl45lsc01a840pbjsa0bk3'
INSERT INTO `glenrich_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( '26ftnl45lsc01a840pbjsa0bk3','1781563782','','0','1','0' )
SELECT *
FROM glenrich_components
WHERE parent = 0
SELECT folder AS TYPE, element AS name, params
  FROM glenrich_plugins
  WHERE published >= 1
  AND access <= 0
  ORDER BY ordering
SELECT oldurl, newurl
  FROM glenrich_redirection
  WHERE oldurl = 'dymohody-i-dymososy/dymososy/dymososy-dlya-gazovyh-agregatov-v-mnogoetazhnyh-domah.html'
  ORDER BY rank ASC
  LIMIT 1
UPDATE glenrich_redirection
  SET cpt=(cpt+1)
  WHERE `newurl` = 'index.php?option=com_virtuemart&Itemid=8&category_id=130&lang=ru&limitstart=0&page=shop.browse'
  AND `oldurl` = 'dymohody-i-dymososy/dymososy/dymososy-dlya-gazovyh-agregatov-v-mnogoetazhnyh-domah.html'
SELECT m.*, c.`option` AS component
  FROM glenrich_menu AS m
  LEFT JOIN glenrich_components AS c
  ON m.componentid = c.id
  WHERE m.published = 1
  ORDER BY m.sublevel, m.parent, m.ordering
SELECT m.*, c.`option` AS component
  FROM glenrich_menu AS m
  LEFT JOIN glenrich_components AS c
  ON m.componentid = c.id
  WHERE m.published = 1
  ORDER BY m.sublevel, m.parent, m.ordering
SELECT group_id,group_name,group_level
FROM `glenrich_vm_auth_group`
ORDER BY group_level
SELECT glenrich_vm_shopper_group.shopper_group_id, show_price_including_tax, `default`, shopper_group_discount

  FROM `glenrich_vm_shopper_group`
  WHERE glenrich_vm_shopper_group.vendor_id='1'
  AND `default`='1'
SELECT vendor_id, vendor_min_pov,vendor_name,vendor_store_name,contact_email,vendor_full_image, vendor_freeshipping,
vendor_address_1,vendor_address_2, vendor_url, vendor_city, vendor_state, vendor_country, country_2_code, country_3_code,
vendor_zip, vendor_phone, vendor_store_desc, vendor_currency, vendor_currency_display_style,
vendor_accepted_currencies, vendor_address_format, vendor_date_format, state_name

  FROM (`glenrich_vm_vendor` v, `glenrich_vm_country` c)

  LEFT JOIN glenrich_vm_state s
  ON (v.vendor_state=s.state_2_code
  AND s.country_id=c.country_id)

  WHERE `v`.`vendor_id`=1

  AND (`v`.`vendor_country`=`c`.`country_2_code` OR `v`.`vendor_country`=`c`.`country_3_code`);
SELECT module_perms
FROM glenrich_vm_module
WHERE module_name='shop'
SELECT id
  FROM glenrich_menu
  WHERE link='index.php?option=com_virtuemart'
  AND published=1
SELECT COUNT(*) AS parentcnt
FROM glenrich_vm_product
WHERE product_parent_id>0
SELECT COUNT(DISTINCT `glenrich_vm_product`.`product_sku`) AS num_rows
  FROM (`glenrich_vm_product`, `glenrich_vm_category`, `glenrich_vm_product_category_xref`,`glenrich_vm_shopper_group`)
  LEFT JOIN `glenrich_vm_product_price`
  ON `glenrich_vm_product`.`product_id` = `glenrich_vm_product_price`.`product_id`
  WHERE `glenrich_vm_product_category_xref`.`product_id`=`glenrich_vm_product`.`product_id`

  AND `glenrich_vm_product_category_xref`.`category_id`=`glenrich_vm_category`.`category_id`

  AND `glenrich_vm_product_category_xref`.`category_id`=130

  AND ((`glenrich_vm_product`.`product_id`=`glenrich_vm_product_price`.`product_id`
  AND `glenrich_vm_shopper_group`.`shopper_group_id`=`glenrich_vm_product_price`.`shopper_group_id`) OR `glenrich_vm_product_price`.`product_id` IS NULL)

  AND `glenrich_vm_shopper_group`.`default` = 1

  AND `product_parent_id`=0

  AND `product_publish`='Y'

  AND `category_publish`='Y'
SELECT category_id, category_name
FROM glenrich_vm_category
WHERE category_id='130'
SELECT category_id, category_description
FROM glenrich_vm_category
WHERE category_id='130'
SELECT category_id, category_thumb_image, category_child_id,category_name
  FROM glenrich_vm_category,glenrich_vm_category_xref
  WHERE glenrich_vm_category_xref.category_parent_id='130'
  AND glenrich_vm_category.category_id=glenrich_vm_category_xref.category_child_id
  AND glenrich_vm_category.vendor_id='1'
  AND glenrich_vm_category.category_publish='Y'
  ORDER BY glenrich_vm_category.list_order, glenrich_vm_category.category_name ASC
SELECT category_id, category_name,category_parent_id, category_child_id
  FROM glenrich_vm_category, glenrich_vm_category_xref
  WHERE glenrich_vm_category_xref.category_child_id='130'
  AND glenrich_vm_category.category_id='130'
SELECT category_id, category_name,category_parent_id, category_child_id
  FROM glenrich_vm_category, glenrich_vm_category_xref
  WHERE glenrich_vm_category_xref.category_child_id='51'
  AND glenrich_vm_category.category_id='51'
SELECT category_id, category_name,category_parent_id, category_child_id
  FROM glenrich_vm_category, glenrich_vm_category_xref
  WHERE glenrich_vm_category_xref.category_child_id='9'
  AND glenrich_vm_category.category_id='9'
SELECT id, params
  FROM glenrich_menu
  WHERE link='index.php?option=com_virtuemart'
  AND published=1
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=9&lang=ru&page=shop.browse'
SELECT name, link,id
  FROM glenrich_menu
  WHERE published='1'
  AND link LIKE 'index.php?option=com_virtuemart%'
SELECT c.category_name, c.category_id, x.category_parent_id
  FROM glenrich_vm_category AS c

  LEFT JOIN glenrich_vm_category_xref AS x
  ON c.category_id = x.category_child_id;
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=9&lang=ru&limitstart=0&page=shop.browse'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=51&lang=ru&page=shop.browse'
SELECT name, link,id
  FROM glenrich_menu
  WHERE published='1'
  AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=51&lang=ru&limitstart=0&page=shop.browse'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=130&lang=ru&page=shop.browse'
SELECT name, link,id
  FROM glenrich_menu
  WHERE published='1'
  AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=130&lang=ru&limitstart=0&page=shop.browse'
SELECT DISTINCT `glenrich_vm_product`.`product_id`, `product_name`, `products_per_row`, `category_browsepage`, `category_flypage`, `glenrich_vm_category`.`category_id`, `product_full_image`, `product_thumb_image`, `product_s_desc`, `product_parent_id`, `product_publish`, `product_in_stock`, `product_sku`, `product_url`, `product_weight`, `product_weight_uom`, `product_length`, `product_width`, `product_height`, `product_lwh_uom`, `product_available_date`, `product_availability`, `glenrich_vm_product`.`mdate`, `glenrich_vm_product`.`cdate`
  FROM (`glenrich_vm_product`, `glenrich_vm_category`, `glenrich_vm_product_category_xref`,`glenrich_vm_shopper_group`)
  LEFT JOIN `glenrich_vm_product_price`
  ON `glenrich_vm_product`.`product_id` = `glenrich_vm_product_price`.`product_id`
  WHERE `glenrich_vm_product_category_xref`.`product_id`=`glenrich_vm_product`.`product_id`

  AND `glenrich_vm_product_category_xref`.`category_id`=`glenrich_vm_category`.`category_id`

  AND `glenrich_vm_product_category_xref`.`category_id`=130

  AND ((`glenrich_vm_product`.`product_id`=`glenrich_vm_product_price`.`product_id`
  AND `glenrich_vm_shopper_group`.`shopper_group_id`=`glenrich_vm_product_price`.`shopper_group_id`) OR `glenrich_vm_product_price`.`product_id` IS NULL)

  AND `glenrich_vm_shopper_group`.`default` = 1

  AND `product_parent_id`=0

  AND `product_publish`='Y'

  AND `category_publish`='Y'

  GROUP BY `glenrich_vm_product`.`product_sku`

  ORDER BY `glenrich_vm_product_category_xref`.`product_list` ASC
  LIMIT 0, 12
SELECT DISTINCT product_sku,glenrich_vm_product.product_id,product_name,product_s_desc,product_thumb_image, product_full_image, product_in_stock, product_url
  FROM glenrich_vm_product, glenrich_vm_product_category_xref, glenrich_vm_category
  WHERE
(glenrich_vm_product.product_parent_id='' OR glenrich_vm_product.product_parent_id='0')

  AND glenrich_vm_product.product_id=glenrich_vm_product_category_xref.product_id

  AND glenrich_vm_category.category_id=glenrich_vm_product_category_xref.category_id

  AND glenrich_vm_category.category_id='130'

  AND glenrich_vm_product.product_publish='Y'

  AND glenrich_vm_product.product_special='Y'

  ORDER BY RAND()
  LIMIT 0, 10
SELECT template
  FROM glenrich_templates_menu
  WHERE client_id = 0
  AND (menuid = 0 OR menuid = 8)
  ORDER BY menuid DESC
  LIMIT 0, 1
SELECT m.*, am.params AS adv_params
  FROM glenrich_modules AS m
  LEFT JOIN glenrich_advancedmodules AS am
  ON am.moduleid = m.id
  WHERE m.published = 1
  AND m.access <= 0
  AND m.client_id = 0
  ORDER BY m.ordering, m.id
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&lang=ru&page=shop.search'
SELECT name, link,id
  FROM glenrich_menu
  WHERE published='1'
  AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&lang=ru&limitstart=0&page=shop.search'
SELECT group_id,group_name,group_level
FROM `glenrich_vm_auth_group`
ORDER BY group_level
SELECT published
FROM glenrich_modules
WHERE module='mod_virtuemart_cart'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=0
  AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=0
  AND a.category_publish='Y'
  ORDER BY a.list_order, a.category_name
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=1&lang=ru&page=shop.browse'
SELECT name, link,id
  FROM glenrich_menu
  WHERE published='1'
  AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=1&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=1
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
  WHERE a.category_id = f.category_id
  AND f.category_id=1
  AND a.category_publish='Y'
  AND p.product_id = f.product_id
  AND p.product_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=1
  AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=1
  AND a.category_publish='Y'
  ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=133
  AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=133
  AND a.category_publish='Y'
  ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=139
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=164
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=11
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=12
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=13
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=162
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=125
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=14
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=15
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=24
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=25
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=56
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=60
  AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=60
  AND a.category_publish='Y'
  ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=88
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=89
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=90
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=91
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=93
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=166
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=61
  AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=61
  AND a.category_publish='Y'
  ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=110
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=112
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=113
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=62
  AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=62
  AND a.category_publish='Y'
  ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=120
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=117
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=119
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=118
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=167
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=161
  AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=2&lang=ru&page=shop.browse'
SELECT name, link,id
  FROM glenrich_menu
  WHERE published='1'
  AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=2&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=2
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
  WHERE a.category_id = f.category_id
  AND f.category_id=2
  AND a.category_publish='Y'
  AND p.product_id = f.product_id
  AND p.product_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=2
  AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=2
  AND a.category_publish='Y'
  ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=132
  AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=132
  AND a.category_publish='Y'
  ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=135
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=136
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=137
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=145
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=16
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=17
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=140
  AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=140
  AND a.category_publish='Y'
  ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=141
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=142
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=143
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=18
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=19
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=20
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=22
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=157
  AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=157
  AND a.category_publish='Y'
  ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=158
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=159
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=23
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=21
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=144
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=54
  AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=6&lang=ru&page=shop.browse'
SELECT name, link,id
  FROM glenrich_menu
  WHERE published='1'
  AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=6&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=6
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
  WHERE a.category_id = f.category_id
  AND f.category_id=6
  AND a.category_publish='Y'
  AND p.product_id = f.product_id
  AND p.product_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=6
  AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=6
  AND a.category_publish='Y'
  ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=40
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=74
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=42
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=75
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=43
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=44
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=41
  AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=3&lang=ru&page=shop.browse'
SELECT name, link,id
  FROM glenrich_menu
  WHERE published='1'
  AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=3&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=3
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
  WHERE a.category_id = f.category_id
  AND f.category_id=3
  AND a.category_publish='Y'
  AND p.product_id = f.product_id
  AND p.product_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=3
  AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=3
  AND a.category_publish='Y'
  ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=26
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=27
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=28
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=29
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=124
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=30
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=31
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=163
  AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=4&lang=ru&page=shop.browse'
SELECT name, link,id
  FROM glenrich_menu
  WHERE published='1'
  AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=4&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=4
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
  WHERE a.category_id = f.category_id
  AND f.category_id=4
  AND a.category_publish='Y'
  AND p.product_id = f.product_id
  AND p.product_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=4
  AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=4
  AND a.category_publish='Y'
  ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=32
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=33
  AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=8&lang=ru&page=shop.browse'
SELECT name, link,id
  FROM glenrich_menu
  WHERE published='1'
  AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=8&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=8
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
  WHERE a.category_id = f.category_id
  AND f.category_id=8
  AND a.category_publish='Y'
  AND p.product_id = f.product_id
  AND p.product_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=8
  AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=8
  AND a.category_publish='Y'
  ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=48
  AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=48
  AND a.category_publish='Y'
  ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=94
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=95
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=96
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=97
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=103
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=104
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=168
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=49
  AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=9&lang=ru&page=shop.browse'
SELECT name, link,id
  FROM glenrich_menu
  WHERE published='1'
  AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=9&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=9
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
  WHERE a.category_id = f.category_id
  AND f.category_id=9
  AND a.category_publish='Y'
  AND p.product_id = f.product_id
  AND p.product_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=9
  AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=9
  AND a.category_publish='Y'
  ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=50
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=51
  AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=51
  AND a.category_publish='Y'
  ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=126
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=127
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=128
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=129
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=130
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=9
  AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=9
  AND a.category_publish='Y'
  ORDER BY a.list_order, a.category_name
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=50&lang=ru&page=shop.browse'
SELECT name, link,id
  FROM glenrich_menu
  WHERE published='1'
  AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=50&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=50
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
  WHERE a.category_id = f.category_id
  AND f.category_id=50
  AND a.category_publish='Y'
  AND p.product_id = f.product_id
  AND p.product_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=50
  AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=51&lang=ru&page=shop.browse'
SELECT name, link,id
  FROM glenrich_menu
  WHERE published='1'
  AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=51&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=51
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
  WHERE a.category_id = f.category_id
  AND f.category_id=51
  AND a.category_publish='Y'
  AND p.product_id = f.product_id
  AND p.product_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=51
  AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=51
  AND a.category_publish='Y'
  ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=126
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=127
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=128
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=129
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=130
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=51
  AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=51
  AND a.category_publish='Y'
  ORDER BY a.list_order, a.category_name
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=126&lang=ru&page=shop.browse'
SELECT name, link,id
  FROM glenrich_menu
  WHERE published='1'
  AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=126&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=126
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
  WHERE a.category_id = f.category_id
  AND f.category_id=126
  AND a.category_publish='Y'
  AND p.product_id = f.product_id
  AND p.product_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=126
  AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=127&lang=ru&page=shop.browse'
SELECT name, link,id
  FROM glenrich_menu
  WHERE published='1'
  AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=127&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=127
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
  WHERE a.category_id = f.category_id
  AND f.category_id=127
  AND a.category_publish='Y'
  AND p.product_id = f.product_id
  AND p.product_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=127
  AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=128&lang=ru&page=shop.browse'
SELECT name, link,id
  FROM glenrich_menu
  WHERE published='1'
  AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=128&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=128
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
  WHERE a.category_id = f.category_id
  AND f.category_id=128
  AND a.category_publish='Y'
  AND p.product_id = f.product_id
  AND p.product_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=128
  AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=129&lang=ru&page=shop.browse'
SELECT name, link,id
  FROM glenrich_menu
  WHERE published='1'
  AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=129&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=129
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
  WHERE a.category_id = f.category_id
  AND f.category_id=129
  AND a.category_publish='Y'
  AND p.product_id = f.product_id
  AND p.product_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=129
  AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=130&lang=ru&page=shop.browse'
SELECT name, link,id
  FROM glenrich_menu
  WHERE published='1'
  AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=130&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=130
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
  WHERE a.category_id = f.category_id
  AND f.category_id=130
  AND a.category_publish='Y'
  AND p.product_id = f.product_id
  AND p.product_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=130
  AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=7&lang=ru&page=shop.browse'
SELECT name, link,id
  FROM glenrich_menu
  WHERE published='1'
  AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=7&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=7
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
  WHERE a.category_id = f.category_id
  AND f.category_id=7
  AND a.category_publish='Y'
  AND p.product_id = f.product_id
  AND p.product_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=7
  AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=7
  AND a.category_publish='Y'
  ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=45
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=46
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=47
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=57
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=58
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=59
  AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=169&lang=ru&page=shop.browse'
SELECT name, link,id
  FROM glenrich_menu
  WHERE published='1'
  AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=169&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=169
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
  WHERE a.category_id = f.category_id
  AND f.category_id=169
  AND a.category_publish='Y'
  AND p.product_id = f.product_id
  AND p.product_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=169
  AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=170&lang=ru&page=shop.browse'
SELECT name, link,id
  FROM glenrich_menu
  WHERE published='1'
  AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=170&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=170
  AND a.category_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
  WHERE a.category_id = f.category_id
  AND f.category_id=170
  AND a.category_publish='Y'
  AND p.product_id = f.product_id
  AND p.product_publish='Y'
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=170
  AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=170
  AND a.category_publish='Y'
  ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
  FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
  WHERE a.category_id = f.category_child_id
  AND f.category_parent_id=171
  AND a.category_publish='Y'
SELECT params
FROM glenrich_advancedmodules
WHERE moduleid = 41
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&lang=ru'
SELECT name, link,id
  FROM glenrich_menu
  WHERE published='1'
  AND link LIKE 'index.php?option=com_virtuemart%'
SELECT name, link,id
  FROM glenrich_menu
  WHERE id = '8'
  AND published='1'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&lang=ru&limitstart=0'
SELECT vendor_id, vendor_name, vendor_store_name, vendor_store_desc
FROM glenrich_vm_vendor
SELECT c.category_name, c.category_id, c.category_description, x.category_parent_id
  FROM glenrich_vm_category AS c

  LEFT JOIN glenrich_vm_category_xref AS x
  ON c.category_id = x.category_child_id;
SELECT id, metadesc, metakey, metatitle, metalang, metarobots
FROM glenrich_sh404SEF_meta
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=130&lang=ru&limitstart=0&page=shop.browse'

Языковые файлы загружены

/home/u70253/glenrich.ru/www/language/ru-RU/ru-RU.ini 1
/home/u70253/glenrich.ru/www/language/ru-RU/ru-RU.plg_system_debug.ini 1
/home/u70253/glenrich.ru/www/language/ru-RU/ru-RU.com_virtuemart.ini
/home/u70253/glenrich.ru/www/language/en-GB/en-GB.com_virtuemart.ini
/home/u70253/glenrich.ru/www/language/ru-RU/ru-RU.tpl_glenrich.ini
/home/u70253/glenrich.ru/www/language/en-GB/en-GB.tpl_glenrich.ini
/home/u70253/glenrich.ru/www/language/ru-RU/ru-RU.mod_amcallmeback.ini 1
/home/u70253/glenrich.ru/www/language/ru-RU/ru-RU.mod_mainmenu.ini 1
/home/u70253/glenrich.ru/www/language/ru-RU/ru-RU.mod_search.ini 1
/home/u70253/glenrich.ru/www/language/ru-RU/ru-RU.mod_virtuemart.ini
/home/u70253/glenrich.ru/www/language/en-GB/en-GB.mod_virtuemart.ini
/home/u70253/glenrich.ru/www/language/ru-RU/ru-RU.mod_vm_cat_menu_specific.ini
/home/u70253/glenrich.ru/www/language/en-GB/en-GB.mod_vm_cat_menu_specific.ini
/home/u70253/glenrich.ru/www/language/ru-RU/ru-RU.mod_vm_next_prev.ini
/home/u70253/glenrich.ru/www/language/en-GB/en-GB.mod_vm_next_prev.ini
/home/u70253/glenrich.ru/www/language/ru-RU/ru-RU.mod_breadcrumbs.ini 1

Диагностика непереведённых строк

Нет

Дизайнер непереведённых строк

Нет