Главная страницаКаталогКамины → Чугунные камины

Чугунные камины

Чугунный камин АК5
Артикул АК5
Цена 2120 €
Ширина 1110 мм.
Высота 1190 мм.
Глубина 130 мм.

Стиль: Модерн
Отделка: Черный

Подробнее
Английский камин АК18
Артикул АК18
Цена 2100 €
Ширина 1040 мм.
Высота 1040 мм.
Глубина 200 мм.

Стиль: Викторианский
Отделка: Полированный

Подробнее
Английский камин АК79
Артикул АК79
Цена 2465 €
Ширина 1400 мм.
Высота 1230 мм.
Глубина 200 мм.

Чугунный камин

Подробнее
Чугунный камин АК91
Артикул АК91
Цена 3450 €
Ширина 1510 мм.
Высота 1220 мм.
Глубина 280 мм.

Стиль: Рококо
Отделка: Черный

Подробнее
Английский камин АК27
Артикул АК27
Цена 2070 €
Ширина 990 мм.
Высота 1050 мм.
Глубина 200 мм.

Стиль: Георгианский
Отделка: Черный

Подробнее
Английский камин АК12
Артикул АК12
Цена 1998 €
Ширина 1010 мм.
Высота 1020 мм.
Глубина 240 мм.

Стиль: Поздний викторианский
Отделка: Полированный

Подробнее
Английский камин АК16
Артикул АК16
Цена 2180 €
Ширина 1140 мм.
Высота 1030 мм.
Глубина 220 мм.

Стиль: Викторианский
Отделка: Полированный

Подробнее
Английский камин АК70
Артикул АК70
Цена 2598 €
Ширина 1510 мм.
Высота 1220 мм.
Глубина 300 мм.

Стиль: Георгианский
Отделка: Частично полированный

Подробнее
Английский камин АК54
Артикул АК54
Цена 2295 €
Ширина 1370 мм.
Высота 1210 мм.
Глубина 250 мм.

Стиль: Ранний викторианский
Отделка: Черный

Подробнее
Английский камин АК88
Артикул АК88
Цена 2680 €
Ширина 1370 мм.
Высота 1210 мм.
Глубина 200 мм.

Стиль: Традиционный
Отделка: Черный

Подробнее
Английский камин АК4
Артикул АК4
Цена 2190 €
Ширина 1110 мм.
Высота 1190 мм.
Глубина 130 мм.

Стиль: Модерн
Отделка: Полированный

Подробнее
Английский камин АК60
Артикул АК60
Цена 2350 €
Ширина 1360 мм.
Высота 1140 мм.
Глубина 180 мм.

Стиль: Викторианский
Отделка: Черный

Подробнее

Страница 1 из 2


Представляем вашему вниманию чугунные камины, изготовленные в традиционно английском,

викторианском стиле.

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

На нашем сайте Вы можете видеть чугунные камины, которые представляют полностью литую конструкцию, точнее - портал вместе с топкой – это одно изделие. Есть модели каминов, которые состоят из двух частей, деталей – это чугунный или деревянный портал (обрамление) и чугунная топка.

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

Замечательно выглядят чугунные камины с деревянным порталом.

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

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

Чугунный английский камин не потерял привлекательность и в наши дни.

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

Схему установки чугунных каминов Вы можете видеть справа от изображения каждой модели.

Габаритные размеры каждой модели в прикрепленных файлах.

Поступившие товары

Английский камин АК64
Артикул АК64

Подробнее
Английский камин АК70
Артикул АК70

Подробнее
Английский камин АК12
Артикул АК12

Подробнее

Печи для дома, камины, банные печи, русские печи, барбекю, строительство печей, барбекю, каминов Наша группа вконтакте Наша группа в facebook Яндекс.Метрика

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

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



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

Application afterLoad: 0.000 seconds, 0.45 MB
Application afterInitialise: 0.036 seconds, 5.44 MB
Application afterRoute: 0.070 seconds, 9.07 MB
Application afterDispatch: 0.658 seconds, 22.10 MB
Application afterRender: 0.875 seconds, 24.42 MB

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

25935432

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

  1. SELECT *
      FROM glenrich_session
      WHERE session_id = 'poo97kecchu6nl4gfggastq0p6'
  2. DELETE
      FROM glenrich_session
      WHERE ( TIME < '1784971039' )
  3. SELECT *
      FROM glenrich_session
      WHERE session_id = 'poo97kecchu6nl4gfggastq0p6'
  4. UPDATE `glenrich_session`
      SET `time`='1784974639',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:8:{s:15:\"session.counter\";i:6;s:19:\"session.timer.start\";i:1784974608;s:18:\"session.timer.last\";i:1784974635;s:17:\"session.timer.now\";i:1784974637;s:22:\"session.client.browser\";s:103:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)\";s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:1:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:3:\"gid\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:3:\"aid\";i:0;s:5:\"guest\";i:1;s:7:\"_params\";O:10:\"JParameter\":7:{s:4:\"_raw\";s:0:\"\";s:4:\"_xml\";N;s:9:\"_elements\";a:0:{}s:12:\"_elementPath\";a:1:{i:0;s:68:\"/home/u70253/glenrich.ru/www/libraries/joomla/html/parameter/element\";}s:17:\"_defaultNameSpace\";s:8:\"_default\";s:9:\"_registry\";a:1:{s:8:\"_default\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{}}s:13:\"session.token\";s:32:\"c64be9051c4438039c8b7f3831418e7b\";}auth|a:11:{s:11:\"show_prices\";i:1;s:7:\"user_id\";i:0;s:8:\"username\";s:4:\"demo\";s:5:\"perms\";s:0:\"\";s:10:\"first_name\";s:5:\"guest\";s:9:\"last_name\";s:0:\"\";s:16:\"shopper_group_id\";s:1:\"5\";s:22:\"shopper_group_discount\";s:4:\"0.00\";s:24:\"show_price_including_tax\";s:1:\"1\";s:21:\"default_shopper_group\";i:1;s:22:\"is_registered_customer\";b:0;}cart|a:1:{s:3:\"idx\";i:0;}recent|a:6:{s:3:\"idx\";i:5;i:0;a:2:{s:10:\"product_id\";i:10;s:11:\"category_id\";s:2:\"16\";}i:1;a:2:{s:10:\"product_id\";i:1164;s:11:\"category_id\";s:2:\"20\";}i:2;a:2:{s:10:\"product_id\";i:9;s:11:\"category_id\";s:2:\"16\";}i:3;a:2:{s:10:\"product_id\";i:1407;s:11:\"category_id\";s:3:\"166\";}i:4;a:2:{s:10:\"product_id\";i:1376;s:11:\"category_id\";s:3:\"118\";}}ps_vendor_id|i:1;minimum_pov|s:4:\"0.00\";vendor_currency|s:3:\"EUR\";userstate|a:5:{s:10:\"product_id\";s:4:\"1376\";s:31:\"view16product_detailslimitstart\";i:0;s:31:\"view20product_detailslimitstart\";i:0;s:32:\"view166product_detailslimitstart\";i:0;s:32:\"view118product_detailslimitstart\";i:0;}last_page|s:20:\"shop.product_details\";last_browse_parameters|a:7:{s:11:\"category_id\";N;s:15:\"manufacturer_id\";N;s:7:\"keyword\";b:0;s:8:\"keyword1\";N;s:8:\"keyword2\";N;s:8:\"featured\";s:1:\"N\";s:10:\"discounted\";s:1:\"N\";}product_sess|a:12:{i:11;a:1:{s:7:\"flypage\";s:17:\"flypage_black.tpl\";}i:9;a:4:{s:7:\"flypage\";s:17:\"flypage_black.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1784974632;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:10;a:4:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1784974608;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;s:7:\"flypage\";s:17:\"flypage_black.tpl\";}i:1169;a:1:{s:7:\"flypage\";s:17:\"flypage_black.tpl\";}i:1142;a:1:{s:7:\"flypage\";s:17:\"flypage_black.tpl\";}i:1164;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1784974631;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:8;a:1:{s:7:\"flypage\";s:17:\"flypage_black.tpl\";}i:1406;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:1407;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1784974635;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:1133;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:1084;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:1376;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1784974637;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}}taxrate|a:1:{i:1;i:0;}vmMiniCart|b:0;'
      WHERE session_id='poo97kecchu6nl4gfggastq0p6'
  5. SELECT *
      FROM glenrich_components
      WHERE parent = 0
  6. SELECT folder AS TYPE, element AS name, params
      FROM glenrich_plugins
      WHERE published >= 1
      AND access <= 0
      ORDER BY ordering
  7. SELECT oldurl, newurl
      FROM glenrich_redirection
      WHERE oldurl = 'kaminy/chugunnye-kaminy.html'
      ORDER BY rank ASC
      LIMIT 1
  8. UPDATE glenrich_redirection
      SET cpt=(cpt+1)
      WHERE `newurl` = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&lang=ru&limitstart=0&page=shop.browse'
      AND `oldurl` = 'kaminy/chugunnye-kaminy.html'
  9. 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
  10. 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
  11. SELECT group_id,group_name,group_level
      FROM `glenrich_vm_auth_group`
      ORDER BY group_level
  12. 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'
  13. 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`);
  14. SELECT module_perms
      FROM glenrich_vm_module
      WHERE module_name='shop'
  15. SELECT id
      FROM glenrich_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  16. SELECT COUNT(*) AS parentcnt
      FROM glenrich_vm_product
      WHERE product_parent_id>0
  17. 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`=162
     
      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'
  18. SELECT category_id, category_name
      FROM glenrich_vm_category
      WHERE category_id='162'
  19. SELECT category_id, category_description
      FROM glenrich_vm_category
      WHERE category_id='162'
  20. 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='162'
      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
  21. 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='162'
      AND glenrich_vm_category.category_id='162'
  22. 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'
  23. SELECT id, params
      FROM glenrich_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  24. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=1&lang=ru&page=shop.browse'
  25. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  26. 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;
  27. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=1&lang=ru&limitstart=0&page=shop.browse'
  28. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&lang=ru&page=shop.browse'
  29. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  30. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&lang=ru&limitstart=0&page=shop.browse'
  31. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&lang=ru&page=shop.browse'
  32. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  33. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&lang=ru&limitstart=0&page=shop.browse'
  34. 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`=162
     
      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
  35. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=117'
  36. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  37. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 117
  38. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '117'
  39. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=117'
  40. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=117
  41. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='117'
      AND (start_date<='1784974639' OR start_date=0)
      AND (end_date>='1784936160' OR end_date=0)
      AND product_discount_id=discount_id
  42. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=117
  43. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1784974639' OR start_date=0)
      AND (end_date>='1784936160' OR end_date=0)
      AND product_discount_id=discount_id
  44. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='117'
  45. SELECT shopper_group_id,shopper_group_discount
      FROM glenrich_vm_shopper_group
      WHERE vendor_id='1'
      AND `default`='1'
  46. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=117
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  47. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=117
  48. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='117'
  49. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=117
  50. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=117
      AND `file_is_image`=1
      AND `file_published`=1
  51. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=117
      AND `file_is_image`=0
  52. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='117'
  53. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=130'
  54. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  55. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 130
  56. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '130'
  57. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=130'
  58. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=130
  59. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='130'
      AND (start_date<='1784974639' OR start_date=0)
      AND (end_date>='1784936160' OR end_date=0)
      AND product_discount_id=discount_id
  60. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=130
  61. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1784974639' OR start_date=0)
      AND (end_date>='1784936160' OR end_date=0)
      AND product_discount_id=discount_id
  62. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='130'
  63. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=130
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  64. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=130
  65. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='130'
  66. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=130
  67. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=130
      AND `file_is_image`=1
      AND `file_published`=1
  68. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=130
      AND `file_is_image`=0
  69. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='130'
  70. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=191'
  71. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  72. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 191
  73. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '191'
  74. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=191'
  75. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=191
  76. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='191'
      AND (start_date<='1784974640' OR start_date=0)
      AND (end_date>='1784936160' OR end_date=0)
      AND product_discount_id=discount_id
  77. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=191
  78. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1784974640' OR start_date=0)
      AND (end_date>='1784936160' OR end_date=0)
      AND product_discount_id=discount_id
  79. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='191'
  80. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=191
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  81. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=191
  82. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='191'
  83. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=191
  84. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=191
      AND `file_is_image`=1
      AND `file_published`=1
  85. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=191
      AND `file_is_image`=0
  86. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='191'
  87. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  88. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='191'
  89. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=1345'
  90. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  91. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 1345
  92. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1345'
  93. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=1345'
  94. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1345
  95. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1345'
      AND (start_date<='1784974640' OR start_date=0)
      AND (end_date>='1784936160' OR end_date=0)
      AND product_discount_id=discount_id
  96. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1345
  97. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1784974640' OR start_date=0)
      AND (end_date>='1784936160' OR end_date=0)
      AND product_discount_id=discount_id
  98. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1345'
  99. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1345
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  100. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1345
  101. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1345'
  102. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1345
  103. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1345
      AND `file_is_image`=1
      AND `file_published`=1
  104. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1345
      AND `file_is_image`=0
  105. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1345'
  106. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=139'
  107. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  108. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 139
  109. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '139'
  110. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=139'
  111. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=139
  112. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='139'
      AND (start_date<='1784974640' OR start_date=0)
      AND (end_date>='1784936160' OR end_date=0)
      AND product_discount_id=discount_id
  113. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=139
  114. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1784974640' OR start_date=0)
      AND (end_date>='1784936160' OR end_date=0)
      AND product_discount_id=discount_id
  115. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='139'
  116. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=139
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  117. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=139
  118. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='139'
  119. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=139
  120. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=139
      AND `file_is_image`=1
      AND `file_published`=1
  121. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=139
      AND `file_is_image`=0
  122. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='139'
  123. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=124'
  124. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  125. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 124
  126. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '124'
  127. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=124'
  128. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=124
  129. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='124'
      AND (start_date<='1784974640' OR start_date=0)
      AND (end_date>='1784936160' OR end_date=0)
      AND product_discount_id=discount_id
  130. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=124
  131. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1784974640' OR start_date=0)
      AND (end_date>='1784936160' OR end_date=0)
      AND product_discount_id=discount_id
  132. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='124'
  133. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=124
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  134. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=124
  135. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='124'
  136. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=124
  137. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=124
      AND `file_is_image`=1
      AND `file_published`=1
  138. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=124
      AND `file_is_image`=0
  139. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='124'
  140. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=128'
  141. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  142. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 128
  143. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '128'
  144. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=128'
  145. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=128
  146. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='128'
      AND (start_date<='1784974640' OR start_date=0)
      AND (end_date>='1784936160' OR end_date=0)
      AND product_discount_id=discount_id
  147. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=128
  148. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1784974640' OR start_date=0)
      AND (end_date>='1784936160' OR end_date=0)
      AND product_discount_id=discount_id
  149. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='128'
  150. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=128
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  151. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=128
  152. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='128'
  153. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=128
  154. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=128
      AND `file_is_image`=1
      AND `file_published`=1
  155. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=128
      AND `file_is_image`=0
  156. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='128'
  157. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=182'
  158. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  159. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 182
  160. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '182'
  161. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=182'
  162. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=182
  163. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='182'
      AND (start_date<='1784974640' OR start_date=0)
      AND (end_date>='1784936160' OR end_date=0)
      AND product_discount_id=discount_id
  164. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=182
  165. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1784974640' OR start_date=0)
      AND (end_date>='1784936160' OR end_date=0)
      AND product_discount_id=discount_id
  166. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='182'
  167. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=182
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  168. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=182
  169. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='182'
  170. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=182
  171. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=182
      AND `file_is_image`=1
      AND `file_published`=1
  172. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=182
      AND `file_is_image`=0
  173. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='182'
  174. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=166'
  175. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  176. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 166
  177. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '166'
  178. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=166'
  179. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=166
  180. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='166'
      AND (start_date<='1784974640' OR start_date=0)
      AND (end_date>='1784936160' OR end_date=0)
      AND product_discount_id=discount_id
  181. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=166
  182. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1784974640' OR start_date=0)
      AND (end_date>='1784936160' OR end_date=0)
      AND product_discount_id=discount_id
  183. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='166'
  184. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=166
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  185. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=166
  186. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='166'
  187. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=166
  188. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=166
      AND `file_is_image`=1
      AND `file_published`=1
  189. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=166
      AND `file_is_image`=0
  190. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='166'
  191. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=196'
  192. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  193. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 196
  194. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '196'
  195. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=196'
  196. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=196
  197. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='196'
      AND (start_date<='1784974640' OR start_date=0)
      AND (end_date>='1784936160' OR end_date=0)
      AND product_discount_id=discount_id
  198. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=196
  199. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1784974640' OR start_date=0)
      AND (end_date>='1784936160' OR end_date=0)
      AND product_discount_id=discount_id
  200. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='196'
  201. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=196
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  202. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=196
  203. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='196'
  204. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=196
  205. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=196
      AND `file_is_image`=1
      AND `file_published`=1
  206. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=196
      AND `file_is_image`=0
  207. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='196'
  208. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  209. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='196'
  210. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=116'
  211. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  212. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 116
  213. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '116'
  214. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=116'
  215. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=116
  216. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='116'
      AND (start_date<='1784974640' OR start_date=0)
      AND (end_date>='1784936160' OR end_date=0)
      AND product_discount_id=discount_id
  217. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=116
  218. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1784974640' OR start_date=0)
      AND (end_date>='1784936160' OR end_date=0)
      AND product_discount_id=discount_id
  219. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='116'
  220. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=116
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  221. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=116
  222. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='116'
  223. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=116
  224. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=116
      AND `file_is_image`=1
      AND `file_published`=1
  225. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=116
      AND `file_is_image`=0
  226. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='116'
  227. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=172'
  228. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  229. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 172
  230. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '172'
  231. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=172'
  232. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=172
  233. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='172'
      AND (start_date<='1784974640' OR start_date=0)
      AND (end_date>='1784936160' OR end_date=0)
      AND product_discount_id=discount_id
  234. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=172
  235. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1784974640' OR start_date=0)
      AND (end_date>='1784936160' OR end_date=0)
      AND product_discount_id=discount_id
  236. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='172'
  237. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=172
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  238. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=172
  239. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='172'
  240. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=172
  241. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=172
      AND `file_is_image`=1
      AND `file_published`=1
  242. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=172
      AND `file_is_image`=0
  243. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='172'
  244. SELECT product_name, category_name, c.category_flypage,product_s_desc,product_thumb_image
      FROM glenrich_vm_product AS p,glenrich_vm_category AS c,glenrich_vm_product_category_xref AS cx
      WHERE p.product_id = '1376'
      AND c.category_id = '118'
      AND p.product_id = cx.product_id
      AND c.category_id=cx.category_id
      AND p.product_publish='Y'
      AND c.category_publish='Y'
      LIMIT 0,1
  245. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1376
  246. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=118&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=1376'
  247. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  248. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 1376
  249. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1376'
  250. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=118&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=1376'
  251. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=118&lang=ru&page=shop.browse'
  252. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  253. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=118&lang=ru&limitstart=0&page=shop.browse'
  254. SELECT product_name, category_name, c.category_flypage,product_s_desc,product_thumb_image
      FROM glenrich_vm_product AS p,glenrich_vm_category AS c,glenrich_vm_product_category_xref AS cx
      WHERE p.product_id = '1407'
      AND c.category_id = '166'
      AND p.product_id = cx.product_id
      AND c.category_id=cx.category_id
      AND p.product_publish='Y'
      AND c.category_publish='Y'
      LIMIT 0,1
  255. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1407
  256. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=166&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=1407'
  257. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  258. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 1407
  259. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1407'
  260. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=166&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=1407'
  261. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=166&lang=ru&page=shop.browse'
  262. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  263. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=166&lang=ru&limitstart=0&page=shop.browse'
  264. SELECT product_name, category_name, c.category_flypage,product_s_desc,product_thumb_image
      FROM glenrich_vm_product AS p,glenrich_vm_category AS c,glenrich_vm_product_category_xref AS cx
      WHERE p.product_id = '9'
      AND c.category_id = '16'
      AND p.product_id = cx.product_id
      AND c.category_id=cx.category_id
      AND p.product_publish='Y'
      AND c.category_publish='Y'
      LIMIT 0,1
  265. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=9
  266. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=16&flypage=flypage_black.tpl&lang=ru&page=shop.product_details&product_id=9'
  267. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  268. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 9
  269. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '9'
  270. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=16&flypage=flypage_black.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=9'
  271. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=16&lang=ru&page=shop.browse'
  272. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  273. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=16&lang=ru&limitstart=0&page=shop.browse'
  274. SELECT product_name, category_name, c.category_flypage,product_s_desc,product_thumb_image
      FROM glenrich_vm_product AS p,glenrich_vm_category AS c,glenrich_vm_product_category_xref AS cx
      WHERE p.product_id = '1164'
      AND c.category_id = '20'
      AND p.product_id = cx.product_id
      AND c.category_id=cx.category_id
      AND p.product_publish='Y'
      AND c.category_publish='Y'
      LIMIT 0,1
  275. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1164
  276. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=20&flypage=flypage_black.tpl&lang=ru&page=shop.product_details&product_id=1164'
  277. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  278. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 1164
  279. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1164'
  280. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=20&flypage=flypage_black.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=1164'
  281. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=20&lang=ru&page=shop.browse'
  282. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  283. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=20&lang=ru&limitstart=0&page=shop.browse'
  284. SELECT product_name, category_name, c.category_flypage,product_s_desc,product_thumb_image
      FROM glenrich_vm_product AS p,glenrich_vm_category AS c,glenrich_vm_product_category_xref AS cx
      WHERE p.product_id = '10'
      AND c.category_id = '16'
      AND p.product_id = cx.product_id
      AND c.category_id=cx.category_id
      AND p.product_publish='Y'
      AND c.category_publish='Y'
      LIMIT 0,1
  285. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=10
  286. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=16&flypage=flypage_black.tpl&lang=ru&page=shop.product_details&product_id=10'
  287. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  288. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 10
  289. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '10'
  290. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=16&flypage=flypage_black.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=10'
  291. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=16&lang=ru&page=shop.browse'
  292. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  293. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=16&lang=ru&limitstart=0&page=shop.browse'
  294. SELECT template
      FROM glenrich_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 8)
      ORDER BY menuid DESC
      LIMIT 0, 1
  295. 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='162'

      AND glenrich_vm_product.product_publish='Y'

      AND glenrich_vm_product.product_special='Y'

      ORDER BY RAND()
      LIMIT 0, 10
  296. SELECT
                                    `glenrich_vm_product`.`product_parent_id` AS product_parent_id,
                                    `glenrich_vm_category`.`category_flypage`
                           
      FROM
                                    `glenrich_vm_product`

                           
      LEFT JOIN `glenrich_vm_product_category_xref`
      ON `glenrich_vm_product_category_xref`.`product_id` = `glenrich_vm_product`.`product_id`
                           
      LEFT JOIN `glenrich_vm_category`
      ON `glenrich_vm_product_category_xref`.`category_id` = `glenrich_vm_category`.`category_id`

                           
      WHERE `glenrich_vm_product`.`product_id`='176'
  297. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=176
  298. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='176'
      AND (start_date<='1784974640' OR start_date=0)
      AND (end_date>='1784936160' OR end_date=0)
      AND product_discount_id=discount_id
  299. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=176
  300. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1784974640' OR start_date=0)
      AND (end_date>='1784936160' OR end_date=0)
      AND product_discount_id=discount_id
  301. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='176'
  302. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=176
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  303. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=176
  304. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='176'
  305. SELECT
                                    `glenrich_vm_product`.`product_parent_id` AS product_parent_id,
                                    `glenrich_vm_category`.`category_flypage`
                           
      FROM
                                    `glenrich_vm_product`

                           
      LEFT JOIN `glenrich_vm_product_category_xref`
      ON `glenrich_vm_product_category_xref`.`product_id` = `glenrich_vm_product`.`product_id`
                           
      LEFT JOIN `glenrich_vm_category`
      ON `glenrich_vm_product_category_xref`.`category_id` = `glenrich_vm_category`.`category_id`

                           
      WHERE `glenrich_vm_product`.`product_id`='182'
  306. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=182
  307. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='182'
  308. SELECT
                                    `glenrich_vm_product`.`product_parent_id` AS product_parent_id,
                                    `glenrich_vm_category`.`category_flypage`
                           
      FROM
                                    `glenrich_vm_product`

                           
      LEFT JOIN `glenrich_vm_product_category_xref`
      ON `glenrich_vm_product_category_xref`.`product_id` = `glenrich_vm_product`.`product_id`
                           
      LEFT JOIN `glenrich_vm_category`
      ON `glenrich_vm_product_category_xref`.`category_id` = `glenrich_vm_category`.`category_id`

                           
      WHERE `glenrich_vm_product`.`product_id`='124'
  309. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=124
  310. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='124'
  311. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage_black.tpl&lang=ru&page=shop.product_details&product_id=176'
  312. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  313. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 176
  314. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '176'
  315. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage_black.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=176'
  316. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage_black.tpl&lang=ru&page=shop.product_details&product_id=176'
  317. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  318. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 176
  319. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '176'
  320. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage_black.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=176'
  321. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage_black.tpl&lang=ru&page=shop.product_details&product_id=182'
  322. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  323. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 182
  324. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '182'
  325. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage_black.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=182'
  326. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage_black.tpl&lang=ru&page=shop.product_details&product_id=182'
  327. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  328. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 182
  329. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '182'
  330. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage_black.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=182'
  331. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage_black.tpl&lang=ru&page=shop.product_details&product_id=124'
  332. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  333. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 124
  334. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '124'
  335. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage_black.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=124'
  336. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage_black.tpl&lang=ru&page=shop.product_details&product_id=124'
  337. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  338. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 124
  339. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '124'
  340. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage_black.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=124'
  341. 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
  342. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&lang=ru&page=shop.search'
  343. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  344. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&lang=ru&limitstart=0&page=shop.search'
  345. SELECT group_id,group_name,group_level
      FROM `glenrich_vm_auth_group`
      ORDER BY group_level
  346. SELECT published
      FROM glenrich_modules
      WHERE module='mod_virtuemart_cart'
  347. SELECT COUNT(*)
      FROM 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'
  348. 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
  349. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=1&lang=ru&page=shop.browse'
  350. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  351. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=1&lang=ru&limitstart=0&page=shop.browse'
  352. SELECT COUNT(*)
      FROM 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'
  353. 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'
  354. SELECT COUNT(*)
      FROM 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'
  355. 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
  356. SELECT COUNT(*)
      FROM 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'
  357. 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
  358. SELECT COUNT(*)
      FROM 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'
  359. SELECT COUNT(*)
      FROM 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'
  360. SELECT COUNT(*)
      FROM 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'
  361. SELECT COUNT(*)
      FROM 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'
  362. SELECT COUNT(*)
      FROM 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'
  363. SELECT COUNT(*)
      FROM 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'
  364. SELECT COUNT(*)
      FROM 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'
  365. SELECT COUNT(*)
      FROM 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'
  366. SELECT COUNT(*)
      FROM 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'
  367. SELECT COUNT(*)
      FROM 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'
  368. SELECT COUNT(*)
      FROM 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'
  369. SELECT COUNT(*)
      FROM 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'
  370. SELECT COUNT(*)
      FROM 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'
  371. 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
  372. SELECT COUNT(*)
      FROM 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'
  373. SELECT COUNT(*)
      FROM 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'
  374. SELECT COUNT(*)
      FROM 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'
  375. SELECT COUNT(*)
      FROM 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'
  376. SELECT COUNT(*)
      FROM 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'
  377. SELECT COUNT(*)
      FROM 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'
  378. SELECT COUNT(*)
      FROM 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'
  379. 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
  380. SELECT COUNT(*)
      FROM 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'
  381. SELECT COUNT(*)
      FROM 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'
  382. SELECT COUNT(*)
      FROM 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'
  383. SELECT COUNT(*)
      FROM 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'
  384. 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
  385. SELECT COUNT(*)
      FROM 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'
  386. SELECT COUNT(*)
      FROM 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'
  387. SELECT COUNT(*)
      FROM 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'
  388. SELECT COUNT(*)
      FROM 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'
  389. SELECT COUNT(*)
      FROM 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'
  390. SELECT COUNT(*)
      FROM 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'
  391. SELECT COUNT(*)
      FROM 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'
  392. 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
  393. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=133&lang=ru&page=shop.browse'
  394. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  395. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=133&lang=ru&limitstart=0&page=shop.browse'
  396. SELECT COUNT(*)
      FROM 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'
  397. 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'
  398. SELECT COUNT(*)
      FROM 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'
  399. 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
  400. SELECT COUNT(*)
      FROM 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'
  401. SELECT COUNT(*)
      FROM 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'
  402. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=11&lang=ru&page=shop.browse'
  403. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  404. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=11&lang=ru&limitstart=0&page=shop.browse'
  405. SELECT COUNT(*)
      FROM 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'
  406. 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'
  407. SELECT COUNT(*)
      FROM 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'
  408. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=12&lang=ru&page=shop.browse'
  409. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  410. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=12&lang=ru&limitstart=0&page=shop.browse'
  411. SELECT COUNT(*)
      FROM 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'
  412. 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'
  413. SELECT COUNT(*)
      FROM 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'
  414. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=13&lang=ru&page=shop.browse'
  415. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  416. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=13&lang=ru&limitstart=0&page=shop.browse'
  417. SELECT COUNT(*)
      FROM 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'
  418. 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'
  419. SELECT COUNT(*)
      FROM 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'
  420. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&lang=ru&page=shop.browse'
  421. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  422. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&lang=ru&limitstart=0&page=shop.browse'
  423. SELECT COUNT(*)
      FROM 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'
  424. 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'
  425. SELECT COUNT(*)
      FROM 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'
  426. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=125&lang=ru&page=shop.browse'
  427. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  428. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=125&lang=ru&limitstart=0&page=shop.browse'
  429. SELECT COUNT(*)
      FROM 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'
  430. 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'
  431. SELECT COUNT(*)
      FROM 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'
  432. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=14&lang=ru&page=shop.browse'
  433. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  434. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=14&lang=ru&limitstart=0&page=shop.browse'
  435. SELECT COUNT(*)
      FROM 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'
  436. 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'
  437. SELECT COUNT(*)
      FROM 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'
  438. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=15&lang=ru&page=shop.browse'
  439. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  440. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=15&lang=ru&limitstart=0&page=shop.browse'
  441. SELECT COUNT(*)
      FROM 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'
  442. 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'
  443. SELECT COUNT(*)
      FROM 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'
  444. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=24&lang=ru&page=shop.browse'
  445. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  446. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=24&lang=ru&limitstart=0&page=shop.browse'
  447. SELECT COUNT(*)
      FROM 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'
  448. 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'
  449. SELECT COUNT(*)
      FROM 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'
  450. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=25&lang=ru&page=shop.browse'
  451. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  452. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=25&lang=ru&limitstart=0&page=shop.browse'
  453. SELECT COUNT(*)
      FROM 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'
  454. 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'
  455. SELECT COUNT(*)
      FROM 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'
  456. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=56&lang=ru&page=shop.browse'
  457. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  458. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=56&lang=ru&limitstart=0&page=shop.browse'
  459. SELECT COUNT(*)
      FROM 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'
  460. 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'
  461. SELECT COUNT(*)
      FROM 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'
  462. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=60&lang=ru&page=shop.browse'
  463. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  464. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=60&lang=ru&limitstart=0&page=shop.browse'
  465. SELECT COUNT(*)
      FROM 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'
  466. 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'
  467. SELECT COUNT(*)
      FROM 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'
  468. 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
  469. SELECT COUNT(*)
      FROM 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'
  470. SELECT COUNT(*)
      FROM 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'
  471. SELECT COUNT(*)
      FROM 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'
  472. SELECT COUNT(*)
      FROM 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'
  473. SELECT COUNT(*)
      FROM 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'
  474. SELECT COUNT(*)
      FROM 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'
  475. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&lang=ru&page=shop.browse'
  476. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  477. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&lang=ru&limitstart=0&page=shop.browse'
  478. SELECT COUNT(*)
      FROM 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'
  479. 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'
  480. SELECT COUNT(*)
      FROM 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'
  481. 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
  482. SELECT COUNT(*)
      FROM 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'
  483. SELECT COUNT(*)
      FROM 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'
  484. SELECT COUNT(*)
      FROM 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'
  485. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&lang=ru&page=shop.browse'
  486. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  487. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&lang=ru&limitstart=0&page=shop.browse'
  488. SELECT COUNT(*)
      FROM 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'
  489. 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'
  490. SELECT COUNT(*)
      FROM 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'
  491. 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
  492. SELECT COUNT(*)
      FROM 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'
  493. SELECT COUNT(*)
      FROM 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'
  494. SELECT COUNT(*)
      FROM 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'
  495. SELECT COUNT(*)
      FROM 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'
  496. SELECT COUNT(*)
      FROM 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'
  497. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=161&lang=ru&page=shop.browse'
  498. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  499. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=161&lang=ru&limitstart=0&page=shop.browse'
  500. SELECT COUNT(*)
      FROM 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'
  501. 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'
  502. SELECT COUNT(*)
      FROM 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'
  503. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=2&lang=ru&page=shop.browse'
  504. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  505. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=2&lang=ru&limitstart=0&page=shop.browse'
  506. SELECT COUNT(*)
      FROM 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'
  507. 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'
  508. SELECT COUNT(*)
      FROM 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'
  509. 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
  510. SELECT COUNT(*)
      FROM 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'
  511. 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
  512. SELECT COUNT(*)
      FROM 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'
  513. SELECT COUNT(*)
      FROM 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'
  514. SELECT COUNT(*)
      FROM 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'
  515. SELECT COUNT(*)
      FROM 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'
  516. SELECT COUNT(*)
      FROM 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'
  517. SELECT COUNT(*)
      FROM 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'
  518. SELECT COUNT(*)
      FROM 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'
  519. 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
  520. SELECT COUNT(*)
      FROM 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'
  521. SELECT COUNT(*)
      FROM 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'
  522. SELECT COUNT(*)
      FROM 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'
  523. SELECT COUNT(*)
      FROM 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'
  524. SELECT COUNT(*)
      FROM 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'
  525. SELECT COUNT(*)
      FROM 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'
  526. SELECT COUNT(*)
      FROM 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'
  527. SELECT COUNT(*)
      FROM 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'
  528. 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
  529. SELECT COUNT(*)
      FROM 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'
  530. SELECT COUNT(*)
      FROM 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'
  531. SELECT COUNT(*)
      FROM 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'
  532. SELECT COUNT(*)
      FROM 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'
  533. SELECT COUNT(*)
      FROM 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'
  534. SELECT COUNT(*)
      FROM 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'
  535. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=6&lang=ru&page=shop.browse'
  536. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  537. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=6&lang=ru&limitstart=0&page=shop.browse'
  538. SELECT COUNT(*)
      FROM 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'
  539. 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'
  540. SELECT COUNT(*)
      FROM 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'
  541. 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
  542. SELECT COUNT(*)
      FROM 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'
  543. SELECT COUNT(*)
      FROM 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'
  544. SELECT COUNT(*)
      FROM 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'
  545. SELECT COUNT(*)
      FROM 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'
  546. SELECT COUNT(*)
      FROM 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'
  547. SELECT COUNT(*)
      FROM 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'
  548. SELECT COUNT(*)
      FROM 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'
  549. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=3&lang=ru&page=shop.browse'
  550. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  551. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=3&lang=ru&limitstart=0&page=shop.browse'
  552. SELECT COUNT(*)
      FROM 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'
  553. 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'
  554. SELECT COUNT(*)
      FROM 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'
  555. 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
  556. SELECT COUNT(*)
      FROM 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'
  557. SELECT COUNT(*)
      FROM 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'
  558. SELECT COUNT(*)
      FROM 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'
  559. SELECT COUNT(*)
      FROM 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'
  560. SELECT COUNT(*)
      FROM 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'
  561. SELECT COUNT(*)
      FROM 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'
  562. SELECT COUNT(*)
      FROM 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'
  563. SELECT COUNT(*)
      FROM 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'
  564. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=4&lang=ru&page=shop.browse'
  565. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  566. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=4&lang=ru&limitstart=0&page=shop.browse'
  567. SELECT COUNT(*)
      FROM 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'
  568. 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'
  569. SELECT COUNT(*)
      FROM 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'
  570. 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
  571. SELECT COUNT(*)
      FROM 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'
  572. SELECT COUNT(*)
      FROM 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'
  573. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=8&lang=ru&page=shop.browse'
  574. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  575. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=8&lang=ru&limitstart=0&page=shop.browse'
  576. SELECT COUNT(*)
      FROM 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'
  577. 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'
  578. SELECT COUNT(*)
      FROM 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'
  579. 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
  580. SELECT COUNT(*)
      FROM 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'
  581. 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
  582. SELECT COUNT(*)
      FROM 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'
  583. SELECT COUNT(*)
      FROM 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'
  584. SELECT COUNT(*)
      FROM 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'
  585. SELECT COUNT(*)
      FROM 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'
  586. SELECT COUNT(*)
      FROM 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'
  587. SELECT COUNT(*)
      FROM 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'
  588. SELECT COUNT(*)
      FROM 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'
  589. SELECT COUNT(*)
      FROM 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'
  590. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=9&lang=ru&page=shop.browse'
  591. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  592. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=9&lang=ru&limitstart=0&page=shop.browse'
  593. SELECT COUNT(*)
      FROM 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'
  594. 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'
  595. SELECT COUNT(*)
      FROM 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'
  596. 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
  597. SELECT COUNT(*)
      FROM 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'
  598. SELECT COUNT(*)
      FROM 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'
  599. 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
  600. SELECT COUNT(*)
      FROM 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'
  601. SELECT COUNT(*)
      FROM 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'
  602. SELECT COUNT(*)
      FROM 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'
  603. SELECT COUNT(*)
      FROM 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'
  604. SELECT COUNT(*)
      FROM 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'
  605. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=7&lang=ru&page=shop.browse'
  606. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  607. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=7&lang=ru&limitstart=0&page=shop.browse'
  608. SELECT COUNT(*)
      FROM 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'
  609. 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'
  610. SELECT COUNT(*)
      FROM 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'
  611. 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
  612. SELECT COUNT(*)
      FROM 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'
  613. SELECT COUNT(*)
      FROM 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'
  614. SELECT COUNT(*)
      FROM 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'
  615. SELECT COUNT(*)
      FROM 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'
  616. SELECT COUNT(*)
      FROM 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'
  617. SELECT COUNT(*)
      FROM 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'
  618. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=169&lang=ru&page=shop.browse'
  619. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  620. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=169&lang=ru&limitstart=0&page=shop.browse'
  621. SELECT COUNT(*)
      FROM 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'
  622. 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'
  623. SELECT COUNT(*)
      FROM 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'
  624. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=170&lang=ru&page=shop.browse'
  625. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  626. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=170&lang=ru&limitstart=0&page=shop.browse'
  627. SELECT COUNT(*)
      FROM 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'
  628. 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'
  629. SELECT COUNT(*)
      FROM 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'
  630. 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
  631. SELECT COUNT(*)
      FROM 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'
  632. SELECT params
      FROM glenrich_advancedmodules
      WHERE moduleid = 41
  633. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&lang=ru'
  634. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  635. SELECT name, link,id
      FROM glenrich_menu
      WHERE id = '8'
      AND published='1'
  636. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&lang=ru&limitstart=0'
  637. SELECT vendor_id, vendor_name, vendor_store_name, vendor_store_desc
      FROM glenrich_vm_vendor
  638. 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;
  639. SELECT id, metadesc, metakey, metatitle, metalang, metarobots
      FROM glenrich_sh404SEF_meta
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&lang=ru&limitstart=0&page=shop.browse'

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

  1. SELECT *
      FROM glenrich_session
      WHERE session_id = 'poo97kecchu6nl4gfggastq0p6'
  2. DELETE
      FROM glenrich_session
      WHERE ( TIME < '1784971039' )
  3. SELECT *
      FROM glenrich_session
      WHERE session_id = 'poo97kecchu6nl4gfggastq0p6'
  4. UPDATE `glenrich_session`
      SET `time`='1784974639',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:8:{s:15:\"session.counter\";i:6;s:19:\"session.timer.start\";i:1784974608;s:18:\"session.timer.last\";i:1784974635;s:17:\"session.timer.now\";i:1784974637;s:22:\"session.client.browser\";s:103:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)\";s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:1:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:3:\"gid\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:3:\"aid\";i:0;s:5:\"guest\";i:1;s:7:\"_params\";O:10:\"JParameter\":7:{s:4:\"_raw\";s:0:\"\";s:4:\"_xml\";N;s:9:\"_elements\";a:0:{}s:12:\"_elementPath\";a:1:{i:0;s:68:\"/home/u70253/glenrich.ru/www/libraries/joomla/html/parameter/element\";}s:17:\"_defaultNameSpace\";s:8:\"_default\";s:9:\"_registry\";a:1:{s:8:\"_default\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{}}s:13:\"session.token\";s:32:\"c64be9051c4438039c8b7f3831418e7b\";}auth|a:11:{s:11:\"show_prices\";i:1;s:7:\"user_id\";i:0;s:8:\"username\";s:4:\"demo\";s:5:\"perms\";s:0:\"\";s:10:\"first_name\";s:5:\"guest\";s:9:\"last_name\";s:0:\"\";s:16:\"shopper_group_id\";s:1:\"5\";s:22:\"shopper_group_discount\";s:4:\"0.00\";s:24:\"show_price_including_tax\";s:1:\"1\";s:21:\"default_shopper_group\";i:1;s:22:\"is_registered_customer\";b:0;}cart|a:1:{s:3:\"idx\";i:0;}recent|a:6:{s:3:\"idx\";i:5;i:0;a:2:{s:10:\"product_id\";i:10;s:11:\"category_id\";s:2:\"16\";}i:1;a:2:{s:10:\"product_id\";i:1164;s:11:\"category_id\";s:2:\"20\";}i:2;a:2:{s:10:\"product_id\";i:9;s:11:\"category_id\";s:2:\"16\";}i:3;a:2:{s:10:\"product_id\";i:1407;s:11:\"category_id\";s:3:\"166\";}i:4;a:2:{s:10:\"product_id\";i:1376;s:11:\"category_id\";s:3:\"118\";}}ps_vendor_id|i:1;minimum_pov|s:4:\"0.00\";vendor_currency|s:3:\"EUR\";userstate|a:5:{s:10:\"product_id\";s:4:\"1376\";s:31:\"view16product_detailslimitstart\";i:0;s:31:\"view20product_detailslimitstart\";i:0;s:32:\"view166product_detailslimitstart\";i:0;s:32:\"view118product_detailslimitstart\";i:0;}last_page|s:20:\"shop.product_details\";last_browse_parameters|a:7:{s:11:\"category_id\";N;s:15:\"manufacturer_id\";N;s:7:\"keyword\";b:0;s:8:\"keyword1\";N;s:8:\"keyword2\";N;s:8:\"featured\";s:1:\"N\";s:10:\"discounted\";s:1:\"N\";}product_sess|a:12:{i:11;a:1:{s:7:\"flypage\";s:17:\"flypage_black.tpl\";}i:9;a:4:{s:7:\"flypage\";s:17:\"flypage_black.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1784974632;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:10;a:4:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1784974608;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;s:7:\"flypage\";s:17:\"flypage_black.tpl\";}i:1169;a:1:{s:7:\"flypage\";s:17:\"flypage_black.tpl\";}i:1142;a:1:{s:7:\"flypage\";s:17:\"flypage_black.tpl\";}i:1164;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1784974631;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:8;a:1:{s:7:\"flypage\";s:17:\"flypage_black.tpl\";}i:1406;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:1407;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1784974635;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}i:1133;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:1084;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:1376;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1784974637;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";i:0;}}taxrate|a:1:{i:1;i:0;}vmMiniCart|b:0;'
      WHERE session_id='poo97kecchu6nl4gfggastq0p6'
  5. SELECT *
      FROM glenrich_components
      WHERE parent = 0
  6. SELECT folder AS TYPE, element AS name, params
      FROM glenrich_plugins
      WHERE published >= 1
      AND access <= 0
      ORDER BY ordering
  7. SELECT oldurl, newurl
      FROM glenrich_redirection
      WHERE oldurl = 'kaminy/chugunnye-kaminy.html'
      ORDER BY rank ASC
      LIMIT 1
  8. UPDATE glenrich_redirection
      SET cpt=(cpt+1)
      WHERE `newurl` = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&lang=ru&limitstart=0&page=shop.browse'
      AND `oldurl` = 'kaminy/chugunnye-kaminy.html'
  9. 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
  10. 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
  11. SELECT group_id,group_name,group_level
      FROM `glenrich_vm_auth_group`
      ORDER BY group_level
  12. 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'
  13. 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`);
  14. SELECT module_perms
      FROM glenrich_vm_module
      WHERE module_name='shop'
  15. SELECT id
      FROM glenrich_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  16. SELECT COUNT(*) AS parentcnt
      FROM glenrich_vm_product
      WHERE product_parent_id>0
  17. 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`=162
     
      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'
  18. SELECT category_id, category_name
      FROM glenrich_vm_category
      WHERE category_id='162'
  19. SELECT category_id, category_description
      FROM glenrich_vm_category
      WHERE category_id='162'
  20. 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='162'
      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
  21. 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='162'
      AND glenrich_vm_category.category_id='162'
  22. 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'
  23. SELECT id, params
      FROM glenrich_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
  24. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=1&lang=ru&page=shop.browse'
  25. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  26. 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;
  27. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=1&lang=ru&limitstart=0&page=shop.browse'
  28. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&lang=ru&page=shop.browse'
  29. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  30. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&lang=ru&limitstart=0&page=shop.browse'
  31. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&lang=ru&page=shop.browse'
  32. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  33. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&lang=ru&limitstart=0&page=shop.browse'
  34. 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`=162
     
      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
  35. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=117'
  36. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  37. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 117
  38. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '117'
  39. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=117'
  40. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=117
  41. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='117'
      AND (start_date<='1784974639' OR start_date=0)
      AND (end_date>='1784936160' OR end_date=0)
      AND product_discount_id=discount_id
  42. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=117
  43. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1784974639' OR start_date=0)
      AND (end_date>='1784936160' OR end_date=0)
      AND product_discount_id=discount_id
  44. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='117'
  45. SELECT shopper_group_id,shopper_group_discount
      FROM glenrich_vm_shopper_group
      WHERE vendor_id='1'
      AND `default`='1'
  46. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=117
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  47. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=117
  48. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='117'
  49. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=117
  50. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=117
      AND `file_is_image`=1
      AND `file_published`=1
  51. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=117
      AND `file_is_image`=0
  52. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='117'
  53. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=130'
  54. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  55. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 130
  56. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '130'
  57. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=130'
  58. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=130
  59. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='130'
      AND (start_date<='1784974639' OR start_date=0)
      AND (end_date>='1784936160' OR end_date=0)
      AND product_discount_id=discount_id
  60. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=130
  61. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1784974639' OR start_date=0)
      AND (end_date>='1784936160' OR end_date=0)
      AND product_discount_id=discount_id
  62. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='130'
  63. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=130
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  64. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=130
  65. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='130'
  66. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=130
  67. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=130
      AND `file_is_image`=1
      AND `file_published`=1
  68. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=130
      AND `file_is_image`=0
  69. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='130'
  70. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=191'
  71. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  72. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 191
  73. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '191'
  74. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=191'
  75. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=191
  76. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='191'
      AND (start_date<='1784974640' OR start_date=0)
      AND (end_date>='1784936160' OR end_date=0)
      AND product_discount_id=discount_id
  77. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=191
  78. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1784974640' OR start_date=0)
      AND (end_date>='1784936160' OR end_date=0)
      AND product_discount_id=discount_id
  79. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='191'
  80. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=191
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  81. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=191
  82. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='191'
  83. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=191
  84. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=191
      AND `file_is_image`=1
      AND `file_published`=1
  85. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=191
      AND `file_is_image`=0
  86. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='191'
  87. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  88. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='191'
  89. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=1345'
  90. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  91. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 1345
  92. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1345'
  93. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=1345'
  94. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1345
  95. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='1345'
      AND (start_date<='1784974640' OR start_date=0)
      AND (end_date>='1784936160' OR end_date=0)
      AND product_discount_id=discount_id
  96. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=1345
  97. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1784974640' OR start_date=0)
      AND (end_date>='1784936160' OR end_date=0)
      AND product_discount_id=discount_id
  98. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='1345'
  99. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=1345
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  100. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1345
  101. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='1345'
  102. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=1345
  103. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1345
      AND `file_is_image`=1
      AND `file_published`=1
  104. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=1345
      AND `file_is_image`=0
  105. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='1345'
  106. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=139'
  107. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  108. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 139
  109. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '139'
  110. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=139'
  111. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=139
  112. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='139'
      AND (start_date<='1784974640' OR start_date=0)
      AND (end_date>='1784936160' OR end_date=0)
      AND product_discount_id=discount_id
  113. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=139
  114. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1784974640' OR start_date=0)
      AND (end_date>='1784936160' OR end_date=0)
      AND product_discount_id=discount_id
  115. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='139'
  116. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=139
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  117. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=139
  118. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='139'
  119. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=139
  120. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=139
      AND `file_is_image`=1
      AND `file_published`=1
  121. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=139
      AND `file_is_image`=0
  122. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='139'
  123. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=124'
  124. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  125. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 124
  126. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '124'
  127. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=124'
  128. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=124
  129. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='124'
      AND (start_date<='1784974640' OR start_date=0)
      AND (end_date>='1784936160' OR end_date=0)
      AND product_discount_id=discount_id
  130. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=124
  131. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1784974640' OR start_date=0)
      AND (end_date>='1784936160' OR end_date=0)
      AND product_discount_id=discount_id
  132. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='124'
  133. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=124
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  134. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=124
  135. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='124'
  136. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=124
  137. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=124
      AND `file_is_image`=1
      AND `file_published`=1
  138. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=124
      AND `file_is_image`=0
  139. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='124'
  140. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=128'
  141. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  142. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 128
  143. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '128'
  144. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=128'
  145. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=128
  146. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='128'
      AND (start_date<='1784974640' OR start_date=0)
      AND (end_date>='1784936160' OR end_date=0)
      AND product_discount_id=discount_id
  147. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=128
  148. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1784974640' OR start_date=0)
      AND (end_date>='1784936160' OR end_date=0)
      AND product_discount_id=discount_id
  149. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='128'
  150. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=128
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  151. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=128
  152. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='128'
  153. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=128
  154. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=128
      AND `file_is_image`=1
      AND `file_published`=1
  155. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=128
      AND `file_is_image`=0
  156. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='128'
  157. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=182'
  158. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  159. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 182
  160. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '182'
  161. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=182'
  162. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=182
  163. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='182'
      AND (start_date<='1784974640' OR start_date=0)
      AND (end_date>='1784936160' OR end_date=0)
      AND product_discount_id=discount_id
  164. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=182
  165. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1784974640' OR start_date=0)
      AND (end_date>='1784936160' OR end_date=0)
      AND product_discount_id=discount_id
  166. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='182'
  167. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=182
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  168. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=182
  169. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='182'
  170. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=182
  171. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=182
      AND `file_is_image`=1
      AND `file_published`=1
  172. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=182
      AND `file_is_image`=0
  173. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='182'
  174. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=166'
  175. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  176. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 166
  177. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '166'
  178. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=166'
  179. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=166
  180. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='166'
      AND (start_date<='1784974640' OR start_date=0)
      AND (end_date>='1784936160' OR end_date=0)
      AND product_discount_id=discount_id
  181. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=166
  182. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1784974640' OR start_date=0)
      AND (end_date>='1784936160' OR end_date=0)
      AND product_discount_id=discount_id
  183. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='166'
  184. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=166
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  185. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=166
  186. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='166'
  187. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=166
  188. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=166
      AND `file_is_image`=1
      AND `file_published`=1
  189. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=166
      AND `file_is_image`=0
  190. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='166'
  191. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=196'
  192. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  193. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 196
  194. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '196'
  195. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=196'
  196. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=196
  197. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='196'
      AND (start_date<='1784974640' OR start_date=0)
      AND (end_date>='1784936160' OR end_date=0)
      AND product_discount_id=discount_id
  198. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=196
  199. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1784974640' OR start_date=0)
      AND (end_date>='1784936160' OR end_date=0)
      AND product_discount_id=discount_id
  200. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='196'
  201. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=196
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  202. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=196
  203. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='196'
  204. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=196
  205. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=196
      AND `file_is_image`=1
      AND `file_published`=1
  206. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=196
      AND `file_is_image`=0
  207. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id='196'
  208. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=0
      AND `file_is_image`=0
  209. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='196'
  210. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=116'
  211. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  212. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 116
  213. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '116'
  214. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=116'
  215. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=116
  216. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='116'
      AND (start_date<='1784974640' OR start_date=0)
      AND (end_date>='1784936160' OR end_date=0)
      AND product_discount_id=discount_id
  217. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=116
  218. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1784974640' OR start_date=0)
      AND (end_date>='1784936160' OR end_date=0)
      AND product_discount_id=discount_id
  219. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='116'
  220. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=116
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  221. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=116
  222. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='116'
  223. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=116
  224. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=116
      AND `file_is_image`=1
      AND `file_published`=1
  225. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=116
      AND `file_is_image`=0
  226. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='116'
  227. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=172'
  228. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  229. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 172
  230. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '172'
  231. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=172'
  232. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=172
  233. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='172'
      AND (start_date<='1784974640' OR start_date=0)
      AND (end_date>='1784936160' OR end_date=0)
      AND product_discount_id=discount_id
  234. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=172
  235. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1784974640' OR start_date=0)
      AND (end_date>='1784936160' OR end_date=0)
      AND product_discount_id=discount_id
  236. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='172'
  237. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=172
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  238. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=172
  239. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='172'
  240. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=172
  241. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=172
      AND `file_is_image`=1
      AND `file_published`=1
  242. SELECT *
      FROM `glenrich_vm_product_files`
      WHERE `file_product_id`=172
      AND `file_is_image`=0
  243. SELECT *
      FROM glenrich_vm_product_product_type_xref
      WHERE product_id='172'
  244. SELECT product_name, category_name, c.category_flypage,product_s_desc,product_thumb_image
      FROM glenrich_vm_product AS p,glenrich_vm_category AS c,glenrich_vm_product_category_xref AS cx
      WHERE p.product_id = '1376'
      AND c.category_id = '118'
      AND p.product_id = cx.product_id
      AND c.category_id=cx.category_id
      AND p.product_publish='Y'
      AND c.category_publish='Y'
      LIMIT 0,1
  245. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1376
  246. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=118&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=1376'
  247. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  248. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 1376
  249. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1376'
  250. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=118&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=1376'
  251. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=118&lang=ru&page=shop.browse'
  252. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  253. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=118&lang=ru&limitstart=0&page=shop.browse'
  254. SELECT product_name, category_name, c.category_flypage,product_s_desc,product_thumb_image
      FROM glenrich_vm_product AS p,glenrich_vm_category AS c,glenrich_vm_product_category_xref AS cx
      WHERE p.product_id = '1407'
      AND c.category_id = '166'
      AND p.product_id = cx.product_id
      AND c.category_id=cx.category_id
      AND p.product_publish='Y'
      AND c.category_publish='Y'
      LIMIT 0,1
  255. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1407
  256. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=166&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=1407'
  257. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  258. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 1407
  259. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1407'
  260. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=166&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=1407'
  261. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=166&lang=ru&page=shop.browse'
  262. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  263. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=166&lang=ru&limitstart=0&page=shop.browse'
  264. SELECT product_name, category_name, c.category_flypage,product_s_desc,product_thumb_image
      FROM glenrich_vm_product AS p,glenrich_vm_category AS c,glenrich_vm_product_category_xref AS cx
      WHERE p.product_id = '9'
      AND c.category_id = '16'
      AND p.product_id = cx.product_id
      AND c.category_id=cx.category_id
      AND p.product_publish='Y'
      AND c.category_publish='Y'
      LIMIT 0,1
  265. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=9
  266. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=16&flypage=flypage_black.tpl&lang=ru&page=shop.product_details&product_id=9'
  267. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  268. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 9
  269. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '9'
  270. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=16&flypage=flypage_black.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=9'
  271. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=16&lang=ru&page=shop.browse'
  272. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  273. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=16&lang=ru&limitstart=0&page=shop.browse'
  274. SELECT product_name, category_name, c.category_flypage,product_s_desc,product_thumb_image
      FROM glenrich_vm_product AS p,glenrich_vm_category AS c,glenrich_vm_product_category_xref AS cx
      WHERE p.product_id = '1164'
      AND c.category_id = '20'
      AND p.product_id = cx.product_id
      AND c.category_id=cx.category_id
      AND p.product_publish='Y'
      AND c.category_publish='Y'
      LIMIT 0,1
  275. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=1164
  276. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=20&flypage=flypage_black.tpl&lang=ru&page=shop.product_details&product_id=1164'
  277. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  278. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 1164
  279. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '1164'
  280. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=20&flypage=flypage_black.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=1164'
  281. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=20&lang=ru&page=shop.browse'
  282. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  283. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=20&lang=ru&limitstart=0&page=shop.browse'
  284. SELECT product_name, category_name, c.category_flypage,product_s_desc,product_thumb_image
      FROM glenrich_vm_product AS p,glenrich_vm_category AS c,glenrich_vm_product_category_xref AS cx
      WHERE p.product_id = '10'
      AND c.category_id = '16'
      AND p.product_id = cx.product_id
      AND c.category_id=cx.category_id
      AND p.product_publish='Y'
      AND c.category_publish='Y'
      LIMIT 0,1
  285. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=10
  286. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=16&flypage=flypage_black.tpl&lang=ru&page=shop.product_details&product_id=10'
  287. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  288. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 10
  289. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '10'
  290. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=16&flypage=flypage_black.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=10'
  291. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=16&lang=ru&page=shop.browse'
  292. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  293. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=16&lang=ru&limitstart=0&page=shop.browse'
  294. SELECT template
      FROM glenrich_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 8)
      ORDER BY menuid DESC
      LIMIT 0, 1
  295. 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='162'

      AND glenrich_vm_product.product_publish='Y'

      AND glenrich_vm_product.product_special='Y'

      ORDER BY RAND()
      LIMIT 0, 10
  296. SELECT
                                    `glenrich_vm_product`.`product_parent_id` AS product_parent_id,
                                    `glenrich_vm_category`.`category_flypage`
                           
      FROM
                                    `glenrich_vm_product`

                           
      LEFT JOIN `glenrich_vm_product_category_xref`
      ON `glenrich_vm_product_category_xref`.`product_id` = `glenrich_vm_product`.`product_id`
                           
      LEFT JOIN `glenrich_vm_category`
      ON `glenrich_vm_product_category_xref`.`category_id` = `glenrich_vm_category`.`category_id`

                           
      WHERE `glenrich_vm_product`.`product_id`='176'
  297. SELECT product_id, `glenrich_vm_product`.*
      FROM `glenrich_vm_product`
      WHERE `product_id`=176
  298. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='176'
      AND (start_date<='1784974640' OR start_date=0)
      AND (end_date>='1784936160' OR end_date=0)
      AND product_discount_id=discount_id
  299. SELECT product_parent_id
      FROM glenrich_vm_product
      WHERE product_id=176
  300. SELECT amount,is_percent
      FROM glenrich_vm_product,glenrich_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1784974640' OR start_date=0)
      AND (end_date>='1784936160' OR end_date=0)
      AND product_discount_id=discount_id
  301. SELECT vendor_id
      FROM glenrich_vm_product
      WHERE product_id='176'
  302. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `glenrich_vm_product_price`
      WHERE product_id=176
      AND shopper_group_id=5  
      ORDER BY price_quantity_start
  303. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=176
  304. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='176'
  305. SELECT
                                    `glenrich_vm_product`.`product_parent_id` AS product_parent_id,
                                    `glenrich_vm_category`.`category_flypage`
                           
      FROM
                                    `glenrich_vm_product`

                           
      LEFT JOIN `glenrich_vm_product_category_xref`
      ON `glenrich_vm_product_category_xref`.`product_id` = `glenrich_vm_product`.`product_id`
                           
      LEFT JOIN `glenrich_vm_category`
      ON `glenrich_vm_product_category_xref`.`category_id` = `glenrich_vm_category`.`category_id`

                           
      WHERE `glenrich_vm_product`.`product_id`='182'
  306. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=182
  307. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='182'
  308. SELECT
                                    `glenrich_vm_product`.`product_parent_id` AS product_parent_id,
                                    `glenrich_vm_category`.`category_flypage`
                           
      FROM
                                    `glenrich_vm_product`

                           
      LEFT JOIN `glenrich_vm_product_category_xref`
      ON `glenrich_vm_product_category_xref`.`product_id` = `glenrich_vm_product`.`product_id`
                           
      LEFT JOIN `glenrich_vm_category`
      ON `glenrich_vm_product_category_xref`.`category_id` = `glenrich_vm_category`.`category_id`

                           
      WHERE `glenrich_vm_product`.`product_id`='124'
  309. SELECT tax_rate
      FROM glenrich_vm_product, glenrich_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id=124
  310. SELECT COUNT(product_id) AS num_rows
      FROM glenrich_vm_product
      WHERE product_parent_id='124'
  311. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage_black.tpl&lang=ru&page=shop.product_details&product_id=176'
  312. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  313. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 176
  314. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '176'
  315. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage_black.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=176'
  316. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage_black.tpl&lang=ru&page=shop.product_details&product_id=176'
  317. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  318. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 176
  319. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '176'
  320. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage_black.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=176'
  321. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage_black.tpl&lang=ru&page=shop.product_details&product_id=182'
  322. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  323. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 182
  324. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '182'
  325. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage_black.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=182'
  326. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage_black.tpl&lang=ru&page=shop.product_details&product_id=182'
  327. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  328. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 182
  329. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '182'
  330. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage_black.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=182'
  331. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage_black.tpl&lang=ru&page=shop.product_details&product_id=124'
  332. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  333. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 124
  334. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '124'
  335. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage_black.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=124'
  336. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage_black.tpl&lang=ru&page=shop.product_details&product_id=124'
  337. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  338. SELECT p.product_id, x.category_id
      FROM glenrich_vm_product AS p
      LEFT JOIN glenrich_vm_product_category_xref AS x
      ON (p.product_id = x.product_id OR (p.product_parent_id <> 0
      AND p.product_parent_id=x.product_id))
     
      WHERE p.product_id = 124
  339. SELECT product_id, product_sku, product_name
      FROM glenrich_vm_product
     
      WHERE product_id = '124'
  340. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage_black.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=124'
  341. 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
  342. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&lang=ru&page=shop.search'
  343. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  344. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&lang=ru&limitstart=0&page=shop.search'
  345. SELECT group_id,group_name,group_level
      FROM `glenrich_vm_auth_group`
      ORDER BY group_level
  346. SELECT published
      FROM glenrich_modules
      WHERE module='mod_virtuemart_cart'
  347. SELECT COUNT(*)
      FROM 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'
  348. 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
  349. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=1&lang=ru&page=shop.browse'
  350. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  351. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=1&lang=ru&limitstart=0&page=shop.browse'
  352. SELECT COUNT(*)
      FROM 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'
  353. 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'
  354. SELECT COUNT(*)
      FROM 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'
  355. 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
  356. SELECT COUNT(*)
      FROM 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'
  357. 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
  358. SELECT COUNT(*)
      FROM 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'
  359. SELECT COUNT(*)
      FROM 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'
  360. SELECT COUNT(*)
      FROM 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'
  361. SELECT COUNT(*)
      FROM 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'
  362. SELECT COUNT(*)
      FROM 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'
  363. SELECT COUNT(*)
      FROM 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'
  364. SELECT COUNT(*)
      FROM 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'
  365. SELECT COUNT(*)
      FROM 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'
  366. SELECT COUNT(*)
      FROM 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'
  367. SELECT COUNT(*)
      FROM 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'
  368. SELECT COUNT(*)
      FROM 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'
  369. SELECT COUNT(*)
      FROM 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'
  370. SELECT COUNT(*)
      FROM 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'
  371. 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
  372. SELECT COUNT(*)
      FROM 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'
  373. SELECT COUNT(*)
      FROM 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'
  374. SELECT COUNT(*)
      FROM 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'
  375. SELECT COUNT(*)
      FROM 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'
  376. SELECT COUNT(*)
      FROM 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'
  377. SELECT COUNT(*)
      FROM 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'
  378. SELECT COUNT(*)
      FROM 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'
  379. 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
  380. SELECT COUNT(*)
      FROM 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'
  381. SELECT COUNT(*)
      FROM 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'
  382. SELECT COUNT(*)
      FROM 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'
  383. SELECT COUNT(*)
      FROM 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'
  384. 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
  385. SELECT COUNT(*)
      FROM 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'
  386. SELECT COUNT(*)
      FROM 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'
  387. SELECT COUNT(*)
      FROM 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'
  388. SELECT COUNT(*)
      FROM 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'
  389. SELECT COUNT(*)
      FROM 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'
  390. SELECT COUNT(*)
      FROM 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'
  391. SELECT COUNT(*)
      FROM 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'
  392. 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
  393. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=133&lang=ru&page=shop.browse'
  394. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  395. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=133&lang=ru&limitstart=0&page=shop.browse'
  396. SELECT COUNT(*)
      FROM 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'
  397. 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'
  398. SELECT COUNT(*)
      FROM 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'
  399. 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
  400. SELECT COUNT(*)
      FROM 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'
  401. SELECT COUNT(*)
      FROM 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'
  402. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=11&lang=ru&page=shop.browse'
  403. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  404. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=11&lang=ru&limitstart=0&page=shop.browse'
  405. SELECT COUNT(*)
      FROM 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'
  406. 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'
  407. SELECT COUNT(*)
      FROM 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'
  408. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=12&lang=ru&page=shop.browse'
  409. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  410. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=12&lang=ru&limitstart=0&page=shop.browse'
  411. SELECT COUNT(*)
      FROM 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'
  412. 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'
  413. SELECT COUNT(*)
      FROM 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'
  414. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=13&lang=ru&page=shop.browse'
  415. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  416. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=13&lang=ru&limitstart=0&page=shop.browse'
  417. SELECT COUNT(*)
      FROM 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'
  418. 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'
  419. SELECT COUNT(*)
      FROM 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'
  420. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&lang=ru&page=shop.browse'
  421. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  422. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&lang=ru&limitstart=0&page=shop.browse'
  423. SELECT COUNT(*)
      FROM 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'
  424. 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'
  425. SELECT COUNT(*)
      FROM 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'
  426. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=125&lang=ru&page=shop.browse'
  427. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  428. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=125&lang=ru&limitstart=0&page=shop.browse'
  429. SELECT COUNT(*)
      FROM 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'
  430. 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'
  431. SELECT COUNT(*)
      FROM 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'
  432. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=14&lang=ru&page=shop.browse'
  433. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  434. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=14&lang=ru&limitstart=0&page=shop.browse'
  435. SELECT COUNT(*)
      FROM 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'
  436. 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'
  437. SELECT COUNT(*)
      FROM 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'
  438. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=15&lang=ru&page=shop.browse'
  439. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  440. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=15&lang=ru&limitstart=0&page=shop.browse'
  441. SELECT COUNT(*)
      FROM 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'
  442. 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'
  443. SELECT COUNT(*)
      FROM 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'
  444. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=24&lang=ru&page=shop.browse'
  445. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  446. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=24&lang=ru&limitstart=0&page=shop.browse'
  447. SELECT COUNT(*)
      FROM 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'
  448. 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'
  449. SELECT COUNT(*)
      FROM 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'
  450. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=25&lang=ru&page=shop.browse'
  451. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  452. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=25&lang=ru&limitstart=0&page=shop.browse'
  453. SELECT COUNT(*)
      FROM 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'
  454. 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'
  455. SELECT COUNT(*)
      FROM 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'
  456. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=56&lang=ru&page=shop.browse'
  457. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  458. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=56&lang=ru&limitstart=0&page=shop.browse'
  459. SELECT COUNT(*)
      FROM 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'
  460. 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'
  461. SELECT COUNT(*)
      FROM 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'
  462. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=60&lang=ru&page=shop.browse'
  463. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  464. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=60&lang=ru&limitstart=0&page=shop.browse'
  465. SELECT COUNT(*)
      FROM 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'
  466. 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'
  467. SELECT COUNT(*)
      FROM 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'
  468. 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
  469. SELECT COUNT(*)
      FROM 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'
  470. SELECT COUNT(*)
      FROM 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'
  471. SELECT COUNT(*)
      FROM 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'
  472. SELECT COUNT(*)
      FROM 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'
  473. SELECT COUNT(*)
      FROM 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'
  474. SELECT COUNT(*)
      FROM 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'
  475. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&lang=ru&page=shop.browse'
  476. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  477. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&lang=ru&limitstart=0&page=shop.browse'
  478. SELECT COUNT(*)
      FROM 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'
  479. 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'
  480. SELECT COUNT(*)
      FROM 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'
  481. 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
  482. SELECT COUNT(*)
      FROM 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'
  483. SELECT COUNT(*)
      FROM 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'
  484. SELECT COUNT(*)
      FROM 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'
  485. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&lang=ru&page=shop.browse'
  486. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  487. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&lang=ru&limitstart=0&page=shop.browse'
  488. SELECT COUNT(*)
      FROM 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'
  489. 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'
  490. SELECT COUNT(*)
      FROM 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'
  491. 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
  492. SELECT COUNT(*)
      FROM 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'
  493. SELECT COUNT(*)
      FROM 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'
  494. SELECT COUNT(*)
      FROM 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'
  495. SELECT COUNT(*)
      FROM 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'
  496. SELECT COUNT(*)
      FROM 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'
  497. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=161&lang=ru&page=shop.browse'
  498. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  499. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=161&lang=ru&limitstart=0&page=shop.browse'
  500. SELECT COUNT(*)
      FROM 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'
  501. 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'
  502. SELECT COUNT(*)
      FROM 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'
  503. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=2&lang=ru&page=shop.browse'
  504. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  505. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=2&lang=ru&limitstart=0&page=shop.browse'
  506. SELECT COUNT(*)
      FROM 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'
  507. 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'
  508. SELECT COUNT(*)
      FROM 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'
  509. 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
  510. SELECT COUNT(*)
      FROM 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'
  511. 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
  512. SELECT COUNT(*)
      FROM 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'
  513. SELECT COUNT(*)
      FROM 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'
  514. SELECT COUNT(*)
      FROM 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'
  515. SELECT COUNT(*)
      FROM 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'
  516. SELECT COUNT(*)
      FROM 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'
  517. SELECT COUNT(*)
      FROM 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'
  518. SELECT COUNT(*)
      FROM 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'
  519. 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
  520. SELECT COUNT(*)
      FROM 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'
  521. SELECT COUNT(*)
      FROM 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'
  522. SELECT COUNT(*)
      FROM 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'
  523. SELECT COUNT(*)
      FROM 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'
  524. SELECT COUNT(*)
      FROM 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'
  525. SELECT COUNT(*)
      FROM 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'
  526. SELECT COUNT(*)
      FROM 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'
  527. SELECT COUNT(*)
      FROM 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'
  528. 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
  529. SELECT COUNT(*)
      FROM 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'
  530. SELECT COUNT(*)
      FROM 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'
  531. SELECT COUNT(*)
      FROM 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'
  532. SELECT COUNT(*)
      FROM 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'
  533. SELECT COUNT(*)
      FROM 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'
  534. SELECT COUNT(*)
      FROM 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'
  535. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=6&lang=ru&page=shop.browse'
  536. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  537. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=6&lang=ru&limitstart=0&page=shop.browse'
  538. SELECT COUNT(*)
      FROM 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'
  539. 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'
  540. SELECT COUNT(*)
      FROM 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'
  541. 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
  542. SELECT COUNT(*)
      FROM 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'
  543. SELECT COUNT(*)
      FROM 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'
  544. SELECT COUNT(*)
      FROM 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'
  545. SELECT COUNT(*)
      FROM 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'
  546. SELECT COUNT(*)
      FROM 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'
  547. SELECT COUNT(*)
      FROM 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'
  548. SELECT COUNT(*)
      FROM 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'
  549. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=3&lang=ru&page=shop.browse'
  550. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  551. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=3&lang=ru&limitstart=0&page=shop.browse'
  552. SELECT COUNT(*)
      FROM 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'
  553. 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'
  554. SELECT COUNT(*)
      FROM 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'
  555. 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
  556. SELECT COUNT(*)
      FROM 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'
  557. SELECT COUNT(*)
      FROM 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'
  558. SELECT COUNT(*)
      FROM 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'
  559. SELECT COUNT(*)
      FROM 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'
  560. SELECT COUNT(*)
      FROM 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'
  561. SELECT COUNT(*)
      FROM 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'
  562. SELECT COUNT(*)
      FROM 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'
  563. SELECT COUNT(*)
      FROM 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'
  564. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=4&lang=ru&page=shop.browse'
  565. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  566. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=4&lang=ru&limitstart=0&page=shop.browse'
  567. SELECT COUNT(*)
      FROM 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'
  568. 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'
  569. SELECT COUNT(*)
      FROM 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'
  570. 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
  571. SELECT COUNT(*)
      FROM 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'
  572. SELECT COUNT(*)
      FROM 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'
  573. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=8&lang=ru&page=shop.browse'
  574. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  575. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=8&lang=ru&limitstart=0&page=shop.browse'
  576. SELECT COUNT(*)
      FROM 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'
  577. 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'
  578. SELECT COUNT(*)
      FROM 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'
  579. 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
  580. SELECT COUNT(*)
      FROM 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'
  581. 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
  582. SELECT COUNT(*)
      FROM 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'
  583. SELECT COUNT(*)
      FROM 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'
  584. SELECT COUNT(*)
      FROM 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'
  585. SELECT COUNT(*)
      FROM 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'
  586. SELECT COUNT(*)
      FROM 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'
  587. SELECT COUNT(*)
      FROM 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'
  588. SELECT COUNT(*)
      FROM 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'
  589. SELECT COUNT(*)
      FROM 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'
  590. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=9&lang=ru&page=shop.browse'
  591. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  592. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=9&lang=ru&limitstart=0&page=shop.browse'
  593. SELECT COUNT(*)
      FROM 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'
  594. 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'
  595. SELECT COUNT(*)
      FROM 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'
  596. 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
  597. SELECT COUNT(*)
      FROM 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'
  598. SELECT COUNT(*)
      FROM 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'
  599. 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
  600. SELECT COUNT(*)
      FROM 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'
  601. SELECT COUNT(*)
      FROM 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'
  602. SELECT COUNT(*)
      FROM 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'
  603. SELECT COUNT(*)
      FROM 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'
  604. SELECT COUNT(*)
      FROM 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'
  605. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=7&lang=ru&page=shop.browse'
  606. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  607. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=7&lang=ru&limitstart=0&page=shop.browse'
  608. SELECT COUNT(*)
      FROM 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'
  609. 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'
  610. SELECT COUNT(*)
      FROM 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'
  611. 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
  612. SELECT COUNT(*)
      FROM 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'
  613. SELECT COUNT(*)
      FROM 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'
  614. SELECT COUNT(*)
      FROM 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'
  615. SELECT COUNT(*)
      FROM 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'
  616. SELECT COUNT(*)
      FROM 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'
  617. SELECT COUNT(*)
      FROM 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'
  618. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=169&lang=ru&page=shop.browse'
  619. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  620. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=169&lang=ru&limitstart=0&page=shop.browse'
  621. SELECT COUNT(*)
      FROM 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'
  622. 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'
  623. SELECT COUNT(*)
      FROM 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'
  624. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=170&lang=ru&page=shop.browse'
  625. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  626. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=170&lang=ru&limitstart=0&page=shop.browse'
  627. SELECT COUNT(*)
      FROM 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'
  628. 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'
  629. SELECT COUNT(*)
      FROM 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'
  630. 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
  631. SELECT COUNT(*)
      FROM 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'
  632. SELECT params
      FROM glenrich_advancedmodules
      WHERE moduleid = 41
  633. SELECT oldurl, dateadd
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&lang=ru'
  634. SELECT name, link,id
      FROM glenrich_menu
      WHERE published='1'
      AND link LIKE 'index.php?option=com_virtuemart%'
  635. SELECT name, link,id
      FROM glenrich_menu
      WHERE id = '8'
      AND published='1'
  636. SELECT oldurl
      FROM glenrich_redirection
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&lang=ru&limitstart=0'
  637. SELECT vendor_id, vendor_name, vendor_store_name, vendor_store_desc
      FROM glenrich_vm_vendor
  638. 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;
  639. SELECT id, metadesc, metakey, metatitle, metalang, metarobots
      FROM glenrich_sh404SEF_meta
      WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&lang=ru&limitstart=0&page=shop.browse'

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

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

Нет

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

Нет