Главная страница → Каталог → Камины → Как мы строим камины - мастер класс → Кафельный камин в деревянном доме

Кафельный камин в деревянном доме

Строительство камина из кафеля.

На этой страничке мы покажем Вам на фотографиях, как мы устанавливаем спроектированный нами

кафельный камин в деревянном доме. Поставка всех комплектующих для камина - компании Гленрич.

1. В первую очередь, для защиты деревянных стен приложения, строим брандмауэр (защитная огнеупорная стена, согласно проекту). Затем проводим базировку топки (согласно проекту) с привязкой к уровню чистого пола и выравниванием по горизонтали и вертикали. Устанавливаем дымоходную керамическую систему и подключаем каминную топку к дымоходной системе.

kafk1

kafk2

2. После того, как установлена каминная топка со всеми привязками (согласно проекту),

мы приступаем к очень ответственному моменту, это базировка кафельной облицовки

с привязкой к установленной топке и дымоходу.

kafk3

kafk4

3. Поднимаем 2-й ряд кафеля после базировки облицовки.

kafk5

kafk6

4. Поднимаем 3-й ряд изразцового камина. Для работы с кафелем мы применяем

специальный термостойкий раствор - хафтмертель.

Этот раствор специально разрабатывался для работы с кафелем.

Линейное и объёмное расширение его с кафелем одинаковое, поэтому кафель и хафтмертель работают,

как одно целое монолитное соединение.

kafk7

kafk8

5. Поднимаем 4-й ряд кафеля. Кстати, ещё о Хафтмертеле.

Раньше при строительстве кафельных печей и каминов применяли глину или глиняные смеси.

Схватываемость таких растворов составляла примерно 48 часов. К чему это приводило?

Это приводило к тому, что печник должен был закрепить кафельную деталь неподвижно и

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

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

Хафтмертель схватывается за 15 - 20 минут, дальше надо объяснять???

Хафтмертель - великолепный материал.

kafk9

kafk10

6. Поднимем 5-й ряд кафельной облицовки.

kafk11

kafk12

7. Поднимаем 6-й ряд кафеля. Работа с кафелем, как правило,

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

Обратите внимание, насколько точно и аккуратно кафель подрезан и заведён

за блендраму каминной топки.

kafk13

kafk14

8. Поднимаем 7-й и 8-й ряды кафельной облицовки кафельного камина.

В кафеле 8-го ряда вы увидите отверстия, это места установки отводящих решёток.

Через решётки в комнату будет поступать конвекционный тёплый воздух.

kafk15

kafk16

9. Далее мы перекрываем кафельными декплатами горизонтальную часть кафельного камина

и подходим к монтажному столику керамического дымохода.

kafk17

kafk18

10. Теперь мы должны поднять несколько рядов кафеля и закрыть монтажный столик дымохода

и часть дымохода (согласно проекту).

kafk19

kafk20

11. Далее мы закрываем кафелем верхнюю горизонтальную часть кафельной облицовки

и наконец затираем швы.

kafk21

kafk22

12. Теперь кафельный камин готов. Это просто прелесть!!!

Кафель - теплый, солнечный, экологически чистый материал, согретый теплом человеческих рук

всегда будет радовать глаз, согревать душу и ваш дом. Наслаждайтесь на здоровье!

kafk23

kafk24

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

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

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

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

Application afterLoad: 0.000 seconds, 0.45 MB

Application afterInitialise: 0.044 seconds, 5.41 MB

Application afterRoute: 0.085 seconds, 9.03 MB

Application afterDispatch: 0.208 seconds, 20.53 MB

Application afterRender: 0.399 seconds, 23.05 MB

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

24509280

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

SELECT *
FROM glenrich_session
WHERE session_id = '1t1vl3u0agbn3j1n995m7hs693'
DELETE
FROM glenrich_session
WHERE ( TIME < '1781478785' )
SELECT *
FROM glenrich_session
WHERE session_id = '1t1vl3u0agbn3j1n995m7hs693'
INSERT INTO `glenrich_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( '1t1vl3u0agbn3j1n995m7hs693','1781482385','','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 = 'kaminy/kak-my-stroim-kaminy-master-klass/kafelnyi-kamin-v-derevyannom-dome.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=139&lang=ru&limitstart=0&page=shop.browse'
  AND `oldurl` = 'kaminy/kak-my-stroim-kaminy-master-klass/kafelnyi-kamin-v-derevyannom-dome.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`=139

  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='139'
SELECT category_id, category_description
FROM glenrich_vm_category
WHERE category_id='139'
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='139'
  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='139'
  AND glenrich_vm_category.category_id='139'
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='133'
  AND glenrich_vm_category.category_id='133'
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='1'
  AND glenrich_vm_category.category_id='1'
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=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 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=1&lang=ru&limitstart=0&page=shop.browse'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=133&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=133&lang=ru&limitstart=0&page=shop.browse'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=139&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=139&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`=139

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

  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 COUNT(*)
  FROM 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 oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=133&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=133&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=133
  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=133
  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=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=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 oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=139&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=139&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=139
  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=139
  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=139
  AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=164&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=164&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=164
  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=164
  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=164
  AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=11&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=11&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=11
  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=11
  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=11
  AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=12&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=12&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=12
  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=12
  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=12
  AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=13&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=13&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=13
  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=13
  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=13
  AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&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=162&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=162
  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=162
  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=162
  AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=125&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=125&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=125
  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=125
  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=125
  AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=14&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=14&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=14
  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=14
  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=14
  AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=15&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=15&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=15
  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=15
  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=15
  AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=24&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=24&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=24
  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=24
  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=24
  AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=25&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=25&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=25
  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=25
  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=25
  AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=56&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=56&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=56
  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=56
  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=56
  AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=60&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=60&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=60
  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=60
  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=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 oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&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=61&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=61
  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=61
  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=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 oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&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=62&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=62
  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=62
  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=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 oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=161&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=161&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=161
  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=161
  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=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 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=139&lang=ru&limitstart=0&page=shop.browse'

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

SELECT *
FROM glenrich_session
WHERE session_id = '1t1vl3u0agbn3j1n995m7hs693'
DELETE
FROM glenrich_session
WHERE ( TIME < '1781478785' )
SELECT *
FROM glenrich_session
WHERE session_id = '1t1vl3u0agbn3j1n995m7hs693'
INSERT INTO `glenrich_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( '1t1vl3u0agbn3j1n995m7hs693','1781482385','','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 = 'kaminy/kak-my-stroim-kaminy-master-klass/kafelnyi-kamin-v-derevyannom-dome.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=139&lang=ru&limitstart=0&page=shop.browse'
  AND `oldurl` = 'kaminy/kak-my-stroim-kaminy-master-klass/kafelnyi-kamin-v-derevyannom-dome.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`=139

  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='139'
SELECT category_id, category_description
FROM glenrich_vm_category
WHERE category_id='139'
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='139'
  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='139'
  AND glenrich_vm_category.category_id='139'
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='133'
  AND glenrich_vm_category.category_id='133'
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='1'
  AND glenrich_vm_category.category_id='1'
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=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 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=1&lang=ru&limitstart=0&page=shop.browse'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=133&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=133&lang=ru&limitstart=0&page=shop.browse'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=139&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=139&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`=139

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

  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 COUNT(*)
  FROM 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 oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=133&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=133&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=133
  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=133
  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=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=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 oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=139&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=139&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=139
  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=139
  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=139
  AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=164&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=164&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=164
  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=164
  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=164
  AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=11&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=11&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=11
  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=11
  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=11
  AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=12&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=12&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=12
  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=12
  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=12
  AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=13&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=13&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=13
  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=13
  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=13
  AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&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=162&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=162
  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=162
  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=162
  AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=125&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=125&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=125
  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=125
  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=125
  AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=14&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=14&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=14
  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=14
  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=14
  AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=15&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=15&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=15
  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=15
  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=15
  AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=24&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=24&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=24
  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=24
  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=24
  AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=25&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=25&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=25
  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=25
  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=25
  AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=56&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=56&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=56
  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=56
  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=56
  AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=60&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=60&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=60
  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=60
  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=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 oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&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=61&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=61
  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=61
  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=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 oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&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=62&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=62
  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=62
  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=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 oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=161&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=161&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=161
  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=161
  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=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 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=139&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

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

Нет

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

Нет