SELECT *
FROM glenrich_session
WHERE session_id = '568i8vnlnub6l7r0vsds3n9j73'
DELETE
FROM glenrich_session
WHERE ( TIME < '1781483308' )
SELECT *
FROM glenrich_session
WHERE session_id = '568i8vnlnub6l7r0vsds3n9j73'
UPDATE `glenrich_session`
SET `time`='1781486908',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1781486906;s:18:\"session.timer.last\";i:1781486906;s:17:\"session.timer.now\";i:1781486906;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:\"65da6a0080a016a1723af4c58895cba6\";}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:2:{s:3:\"idx\";i:1;i:0;a:2:{s:10:\"product_id\";i:430;s:11:\"category_id\";s:2:\"89\";}}ps_vendor_id|i:1;minimum_pov|s:4:\"0.00\";vendor_currency|s:3:\"EUR\";userstate|a:2:{s:10:\"product_id\";s:3:\"430\";s:31:\"view89product_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:3:{i:431;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:429;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:430;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1781486906;}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='568i8vnlnub6l7r0vsds3n9j73'
SELECT *
FROM glenrich_components
WHERE parent = 0
SELECT folder AS TYPE, element AS name, params
FROM glenrich_plugins
WHERE published >= 1
AND access <= 0
ORDER BY ordering
SELECT oldurl, newurl
FROM glenrich_redirection
WHERE oldurl = 'izrazcovyi-kamin-ik6.html'
ORDER BY rank ASC
LIMIT 1
UPDATE glenrich_redirection
SET cpt=(cpt+1)
WHERE `newurl` = 'index.php?option=com_virtuemart&Itemid=8&category_id=11&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=86'
AND `oldurl` = 'izrazcovyi-kamin-ik6.html'
SELECT m.*, c.`option` AS component
FROM glenrich_menu AS m
LEFT JOIN glenrich_components AS c
ON m.componentid = c.id
WHERE m.published = 1
ORDER BY m.sublevel, m.parent, m.ordering
SELECT m.*, c.`option` AS component
FROM glenrich_menu AS m
LEFT JOIN glenrich_components AS c
ON m.componentid = c.id
WHERE m.published = 1
ORDER BY m.sublevel, m.parent, m.ordering
SELECT group_id,group_name,group_level
FROM `glenrich_vm_auth_group`
ORDER BY group_level
SELECT glenrich_vm_shopper_group.shopper_group_id, show_price_including_tax, `default`, shopper_group_discount
FROM `glenrich_vm_shopper_group`
WHERE glenrich_vm_shopper_group.vendor_id='1'
AND `default`='1'
SELECT vendor_id, vendor_min_pov,vendor_name,vendor_store_name,contact_email,vendor_full_image, vendor_freeshipping,
vendor_address_1,vendor_address_2, vendor_url, vendor_city, vendor_state, vendor_country, country_2_code, country_3_code,
vendor_zip, vendor_phone, vendor_store_desc, vendor_currency, vendor_currency_display_style,
vendor_accepted_currencies, vendor_address_format, vendor_date_format, state_name
FROM (`glenrich_vm_vendor` v, `glenrich_vm_country` c)
LEFT JOIN glenrich_vm_state s
ON (v.vendor_state=s.state_2_code
AND s.country_id=c.country_id)
WHERE `v`.`vendor_id`=1
AND (`v`.`vendor_country`=`c`.`country_2_code` OR `v`.`vendor_country`=`c`.`country_3_code`);
SELECT module_perms
FROM glenrich_vm_module
WHERE module_name='shop'
SELECT id
FROM glenrich_menu
WHERE link='index.php?option=com_virtuemart'
AND published=1
SELECT *
FROM `glenrich_vm_product`
WHERE `product_id`=86
AND `product_publish`='Y'
SELECT product_sku, related_products
FROM glenrich_vm_product,glenrich_vm_product_relations
WHERE glenrich_vm_product_relations.product_id='86'
AND product_publish='Y'
AND FIND_IN_SET(glenrich_vm_product.product_id, REPLACE(related_products, '|', ',' ))
LIMIT 0, 8
SELECT product_id, product_name, product_parent_id, product_thumb_image
FROM glenrich_vm_product
WHERE product_sku='ИК3'
SELECT category_id
FROM `glenrich_vm_product_category_xref`
WHERE product_id=83
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`='83'
SELECT id, params
FROM glenrich_menu
WHERE link='index.php?option=com_virtuemart'
AND published=1
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=11&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=83'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
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 = 83
SELECT product_id, product_sku, product_name
FROM glenrich_vm_product
WHERE product_id = '83'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=11&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=83'
SELECT product_id, `glenrich_vm_product`.*
FROM `glenrich_vm_product`
WHERE `product_id`=83
SELECT amount,is_percent
FROM glenrich_vm_product,glenrich_vm_product_discount
WHERE product_id='83'
AND (start_date<='1781486908' OR start_date=0)
AND (end_date>='1781480160' OR end_date=0)
AND product_discount_id=discount_id
SELECT product_parent_id
FROM glenrich_vm_product
WHERE product_id=83
SELECT amount,is_percent
FROM glenrich_vm_product,glenrich_vm_product_discount
WHERE product_id='0'
AND (start_date<='1781486908' OR start_date=0)
AND (end_date>='1781480160' OR end_date=0)
AND product_discount_id=discount_id
SELECT vendor_id
FROM glenrich_vm_product
WHERE product_id='83'
SELECT shopper_group_id,shopper_group_discount
FROM glenrich_vm_shopper_group
WHERE vendor_id='1'
AND `default`='1'
SELECT `product_price`, `product_price_id`, `product_currency`
FROM `glenrich_vm_product_price`
WHERE product_id=83
AND shopper_group_id=5
ORDER BY price_quantity_start
SELECT `product_price`, `product_price_id`, `product_currency`
FROM `glenrich_vm_product_price`
WHERE product_id=83
AND shopper_group_id=5
ORDER BY price_quantity_start
SELECT `product_price`, `product_price_id`, `product_currency`
FROM `glenrich_vm_product_price`
WHERE product_id=83
AND shopper_group_id=5
ORDER BY price_quantity_start
SELECT `product_price`, `product_price_id`, `product_currency`
FROM `glenrich_vm_product_price`
WHERE product_id=83
AND shopper_group_id=5
ORDER BY price_quantity_start
SELECT COUNT(product_id) AS num_rows
FROM glenrich_vm_product
WHERE product_parent_id='83'
SELECT product_id, product_name, product_parent_id, product_thumb_image
FROM glenrich_vm_product
WHERE product_sku='ИК 27'
SELECT category_id
FROM `glenrich_vm_product_category_xref`
WHERE product_id=1191
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`='1191'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=1&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=1191'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
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 = 1191
SELECT product_id, product_sku, product_name
FROM glenrich_vm_product
WHERE product_id = '1191'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=1&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=1191'
SELECT product_id, `glenrich_vm_product`.*
FROM `glenrich_vm_product`
WHERE `product_id`=1191
SELECT amount,is_percent
FROM glenrich_vm_product,glenrich_vm_product_discount
WHERE product_id='1191'
AND (start_date<='1781486908' OR start_date=0)
AND (end_date>='1781480160' OR end_date=0)
AND product_discount_id=discount_id
SELECT product_parent_id
FROM glenrich_vm_product
WHERE product_id=1191
SELECT amount,is_percent
FROM glenrich_vm_product,glenrich_vm_product_discount
WHERE product_id='0'
AND (start_date<='1781486908' OR start_date=0)
AND (end_date>='1781480160' OR end_date=0)
AND product_discount_id=discount_id
SELECT vendor_id
FROM glenrich_vm_product
WHERE product_id='1191'
SELECT `product_price`, `product_price_id`, `product_currency`
FROM `glenrich_vm_product_price`
WHERE product_id=1191
AND shopper_group_id=5
ORDER BY price_quantity_start
SELECT tax_rate
FROM glenrich_vm_product, glenrich_vm_tax_rate
WHERE product_tax_id=tax_rate_id
AND product_id=1191
SELECT COUNT(product_id) AS num_rows
FROM glenrich_vm_product
WHERE product_parent_id='1191'
SELECT product_id, product_name, product_parent_id, product_thumb_image
FROM glenrich_vm_product
WHERE product_sku='ИК45'
SELECT category_id
FROM `glenrich_vm_product_category_xref`
WHERE product_id=1355
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`='1355'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=11&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=1355'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
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 = 1355
SELECT product_id, product_sku, product_name
FROM glenrich_vm_product
WHERE product_id = '1355'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=11&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=1355'
SELECT product_id, `glenrich_vm_product`.*
FROM `glenrich_vm_product`
WHERE `product_id`=1355
SELECT amount,is_percent
FROM glenrich_vm_product,glenrich_vm_product_discount
WHERE product_id='1355'
AND (start_date<='1781486908' OR start_date=0)
AND (end_date>='1781480160' OR end_date=0)
AND product_discount_id=discount_id
SELECT product_parent_id
FROM glenrich_vm_product
WHERE product_id=1355
SELECT amount,is_percent
FROM glenrich_vm_product,glenrich_vm_product_discount
WHERE product_id='0'
AND (start_date<='1781486908' OR start_date=0)
AND (end_date>='1781480160' OR end_date=0)
AND product_discount_id=discount_id
SELECT vendor_id
FROM glenrich_vm_product
WHERE product_id='1355'
SELECT `product_price`, `product_price_id`, `product_currency`
FROM `glenrich_vm_product_price`
WHERE product_id=1355
AND shopper_group_id=5
ORDER BY price_quantity_start
SELECT `product_price`, `product_price_id`, `product_currency`
FROM `glenrich_vm_product_price`
WHERE product_id=1355
AND shopper_group_id=5
ORDER BY price_quantity_start
SELECT `product_price`, `product_price_id`, `product_currency`
FROM `glenrich_vm_product_price`
WHERE product_id=1355
AND shopper_group_id=5
ORDER BY price_quantity_start
SELECT `product_price`, `product_price_id`, `product_currency`
FROM `glenrich_vm_product_price`
WHERE product_id=1355
AND shopper_group_id=5
ORDER BY price_quantity_start
SELECT COUNT(product_id) AS num_rows
FROM glenrich_vm_product
WHERE product_parent_id='1355'
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='11'
AND glenrich_vm_category.category_id='11'
SELECT category_id, category_name,category_parent_id, category_child_id
FROM glenrich_vm_category, glenrich_vm_category_xref
WHERE glenrich_vm_category_xref.category_child_id='1'
AND glenrich_vm_category.category_id='1'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=1&lang=ru&page=shop.browse'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
SELECT c.category_name, c.category_id, x.category_parent_id
FROM glenrich_vm_category AS c
LEFT JOIN glenrich_vm_category_xref AS x
ON c.category_id = x.category_child_id;
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=1&lang=ru&limitstart=0&page=shop.browse'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=11&lang=ru&page=shop.browse'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=11&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*) AS parentcnt
FROM glenrich_vm_product
WHERE product_parent_id>0
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`=11
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, 2000
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`='88'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=88'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
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 = 88
SELECT product_id, product_sku, product_name
FROM glenrich_vm_product
WHERE product_id = '88'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=88'
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`='85'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=85'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
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 = 85
SELECT product_id, product_sku, product_name
FROM glenrich_vm_product
WHERE product_id = '85'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=85'
SELECT template
FROM glenrich_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 8)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT category_child_id
FROM glenrich_vm_category_xref
WHERE category_parent_id='11'
SELECT manufacturer_id
FROM glenrich_vm_product_mf_xref
WHERE product_id='86'
SELECT mf_name,glenrich_vm_manufacturer.manufacturer_id
FROM glenrich_vm_product_mf_xref,glenrich_vm_manufacturer
WHERE product_id='86'
AND glenrich_vm_manufacturer.manufacturer_id=glenrich_vm_product_mf_xref.manufacturer_id
SELECT product_id, `glenrich_vm_product`.*
FROM `glenrich_vm_product`
WHERE `product_id`=86
SELECT amount,is_percent
FROM glenrich_vm_product,glenrich_vm_product_discount
WHERE product_id='86'
AND (start_date<='1781486908' OR start_date=0)
AND (end_date>='1781480160' OR end_date=0)
AND product_discount_id=discount_id
SELECT product_parent_id
FROM glenrich_vm_product
WHERE product_id=86
SELECT amount,is_percent
FROM glenrich_vm_product,glenrich_vm_product_discount
WHERE product_id='0'
AND (start_date<='1781486908' OR start_date=0)
AND (end_date>='1781480160' OR end_date=0)
AND product_discount_id=discount_id
SELECT vendor_id
FROM glenrich_vm_product
WHERE product_id='86'
SELECT `product_price`, `product_price_id`, `product_currency`
FROM `glenrich_vm_product_price`
WHERE product_id=86
AND shopper_group_id=5
ORDER BY price_quantity_start
SELECT `product_price`, `product_price_id`, `product_currency`
FROM `glenrich_vm_product_price`
WHERE product_id=86
AND shopper_group_id=5
ORDER BY price_quantity_start
SELECT `product_price`, `product_price_id`, `product_currency`
FROM `glenrich_vm_product_price`
WHERE product_id=86
AND shopper_group_id=5
ORDER BY price_quantity_start
SELECT `product_price`, `product_price_id`, `product_currency`
FROM `glenrich_vm_product_price`
WHERE product_id=86
AND shopper_group_id=5
ORDER BY price_quantity_start
SELECT COUNT(product_id) AS num_rows
FROM glenrich_vm_product
WHERE product_parent_id='86'
SELECT `product_price`, `product_price_id`, `product_currency`
FROM `glenrich_vm_product_price`
WHERE product_id=86
AND shopper_group_id=5
ORDER BY price_quantity_start
SELECT `product_price`, `product_price_id`, `product_currency`
FROM `glenrich_vm_product_price`
WHERE product_id=86
AND shopper_group_id=5
ORDER BY price_quantity_start
SELECT tax_rate
FROM glenrich_vm_product, glenrich_vm_tax_rate
WHERE product_tax_id=tax_rate_id
AND product_id=86
SELECT *
FROM `glenrich_vm_product_files`
WHERE `file_product_id`=86
AND `file_is_image`=1
AND `file_published`=1
SELECT *
FROM `glenrich_vm_product_files`
WHERE `file_product_id`=86
AND `file_is_image`=0
SELECT product_parent_id
FROM glenrich_vm_product
WHERE product_id='86'
SELECT *
FROM `glenrich_vm_product_files`
WHERE `file_product_id`=0
AND `file_is_image`=0
SELECT attribute_value
FROM glenrich_vm_product_attribute
WHERE `product_id` = '0'
AND attribute_name='download'
SELECT DISTINCT file_id, file_mimetype, file_title, file_name
FROM `glenrich_vm_product_files`
WHERE file_product_id = '0'
AND file_published = '1'
AND file_is_image = '0'
SELECT COUNT(product_id) AS num_rows
FROM glenrich_vm_product
WHERE product_parent_id='86'
SELECT COUNT(product_id) AS num_rows
FROM glenrich_vm_product
WHERE product_parent_id='86'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=11&flypage=flypage.tpl&lang=ru&page=shop.ask&product_id=86'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
SELECT glenrich_vm_vendor.vendor_name
FROM glenrich_vm_product, glenrich_vm_vendor
WHERE glenrich_vm_product.product_id='86'
AND glenrich_vm_vendor.vendor_id=glenrich_vm_product.vendor_id
SELECT *
FROM glenrich_vm_product_product_type_xref
WHERE product_id='86'
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 = '430'
AND c.category_id = '89'
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
SELECT product_id, `glenrich_vm_product`.*
FROM `glenrich_vm_product`
WHERE `product_id`=430
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=89&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=430'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
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 = 430
SELECT product_id, product_sku, product_name
FROM glenrich_vm_product
WHERE product_id = '430'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=89&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=430'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=89&lang=ru&page=shop.browse'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=89&lang=ru&limitstart=0&page=shop.browse'
SELECT product_id, `glenrich_vm_product`.*
FROM `glenrich_vm_product`
WHERE `product_id`=86
SELECT product_id, attribute, product_parent_id
FROM glenrich_vm_product
WHERE product_id='86'
SELECT product_id, attribute
FROM glenrich_vm_product
WHERE product_id='86'
SELECT `product_price`, `product_price_id`, `product_currency`
FROM `glenrich_vm_product_price`
WHERE product_id=86
AND shopper_group_id=5
ORDER BY price_quantity_start
SELECT `product_price`, `product_price_id`, `product_currency`
FROM `glenrich_vm_product_price`
WHERE product_id=86
AND shopper_group_id=5
ORDER BY price_quantity_start
SELECT product_id, custom_attribute, product_parent_id
FROM glenrich_vm_product
WHERE product_id='86'
SELECT product_id, custom_attribute
FROM glenrich_vm_product
WHERE product_id='86'
SELECT product_id,product_name
FROM glenrich_vm_product
WHERE product_parent_id='86'
AND product_publish='Y'
SELECT `payment_method_id`
FROM `glenrich_vm_payment_method`
WHERE `payment_class`='ps_paypal_api'
AND `payment_enabled`='Y'
SELECT m.*, am.params AS adv_params
FROM glenrich_modules AS m
LEFT JOIN glenrich_advancedmodules AS am
ON am.moduleid = m.id
WHERE m.published = 1
AND m.access <= 0
AND m.client_id = 0
ORDER BY m.ordering, m.id
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&lang=ru&page=shop.search'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&lang=ru&limitstart=0&page=shop.search'
SELECT group_id,group_name,group_level
FROM `glenrich_vm_auth_group`
ORDER BY group_level
SELECT published
FROM glenrich_modules
WHERE module='mod_virtuemart_cart'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=0
AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=0
AND a.category_publish='Y'
ORDER BY a.list_order, a.category_name
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=1&lang=ru&page=shop.browse'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=1&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=1
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
WHERE a.category_id = f.category_id
AND f.category_id=1
AND a.category_publish='Y'
AND p.product_id = f.product_id
AND p.product_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=1
AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=1
AND a.category_publish='Y'
ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=133
AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=133
AND a.category_publish='Y'
ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=139
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=164
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=11
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=12
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=13
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=162
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=125
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=14
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=15
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=24
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=25
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=56
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=60
AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=60
AND a.category_publish='Y'
ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=88
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=89
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=90
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=91
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=93
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=166
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=61
AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=61
AND a.category_publish='Y'
ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=110
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=112
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=113
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=62
AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=62
AND a.category_publish='Y'
ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=120
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=117
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=119
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=118
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=167
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=161
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=1
AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=1
AND a.category_publish='Y'
ORDER BY a.list_order, a.category_name
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=133&lang=ru&page=shop.browse'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=133&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=133
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
WHERE a.category_id = f.category_id
AND f.category_id=133
AND a.category_publish='Y'
AND p.product_id = f.product_id
AND p.product_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=133
AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=133
AND a.category_publish='Y'
ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=139
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=164
AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=11&lang=ru&page=shop.browse'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=11&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=11
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
WHERE a.category_id = f.category_id
AND f.category_id=11
AND a.category_publish='Y'
AND p.product_id = f.product_id
AND p.product_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=11
AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=12&lang=ru&page=shop.browse'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=12&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=12
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
WHERE a.category_id = f.category_id
AND f.category_id=12
AND a.category_publish='Y'
AND p.product_id = f.product_id
AND p.product_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=12
AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=13&lang=ru&page=shop.browse'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=13&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=13
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
WHERE a.category_id = f.category_id
AND f.category_id=13
AND a.category_publish='Y'
AND p.product_id = f.product_id
AND p.product_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=13
AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&lang=ru&page=shop.browse'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=162
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
WHERE a.category_id = f.category_id
AND f.category_id=162
AND a.category_publish='Y'
AND p.product_id = f.product_id
AND p.product_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=162
AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=125&lang=ru&page=shop.browse'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=125&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=125
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
WHERE a.category_id = f.category_id
AND f.category_id=125
AND a.category_publish='Y'
AND p.product_id = f.product_id
AND p.product_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=125
AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=14&lang=ru&page=shop.browse'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=14&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=14
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
WHERE a.category_id = f.category_id
AND f.category_id=14
AND a.category_publish='Y'
AND p.product_id = f.product_id
AND p.product_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=14
AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=15&lang=ru&page=shop.browse'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=15&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=15
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
WHERE a.category_id = f.category_id
AND f.category_id=15
AND a.category_publish='Y'
AND p.product_id = f.product_id
AND p.product_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=15
AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=24&lang=ru&page=shop.browse'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=24&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=24
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
WHERE a.category_id = f.category_id
AND f.category_id=24
AND a.category_publish='Y'
AND p.product_id = f.product_id
AND p.product_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=24
AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=25&lang=ru&page=shop.browse'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=25&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=25
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
WHERE a.category_id = f.category_id
AND f.category_id=25
AND a.category_publish='Y'
AND p.product_id = f.product_id
AND p.product_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=25
AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=56&lang=ru&page=shop.browse'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=56&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=56
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
WHERE a.category_id = f.category_id
AND f.category_id=56
AND a.category_publish='Y'
AND p.product_id = f.product_id
AND p.product_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=56
AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=60&lang=ru&page=shop.browse'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=60&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=60
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
WHERE a.category_id = f.category_id
AND f.category_id=60
AND a.category_publish='Y'
AND p.product_id = f.product_id
AND p.product_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=60
AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=60
AND a.category_publish='Y'
ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=88
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=89
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=90
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=91
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=93
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=166
AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&lang=ru&page=shop.browse'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=61
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
WHERE a.category_id = f.category_id
AND f.category_id=61
AND a.category_publish='Y'
AND p.product_id = f.product_id
AND p.product_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=61
AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=61
AND a.category_publish='Y'
ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=110
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=112
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=113
AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&lang=ru&page=shop.browse'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=62
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
WHERE a.category_id = f.category_id
AND f.category_id=62
AND a.category_publish='Y'
AND p.product_id = f.product_id
AND p.product_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=62
AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=62
AND a.category_publish='Y'
ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=120
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=117
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=119
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=118
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=167
AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=161&lang=ru&page=shop.browse'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=161&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=161
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
WHERE a.category_id = f.category_id
AND f.category_id=161
AND a.category_publish='Y'
AND p.product_id = f.product_id
AND p.product_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=161
AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=2&lang=ru&page=shop.browse'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=2&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=2
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
WHERE a.category_id = f.category_id
AND f.category_id=2
AND a.category_publish='Y'
AND p.product_id = f.product_id
AND p.product_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=2
AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=2
AND a.category_publish='Y'
ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=132
AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=132
AND a.category_publish='Y'
ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=135
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=136
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=137
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=145
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=16
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=17
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=140
AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=140
AND a.category_publish='Y'
ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=141
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=142
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=143
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=18
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=19
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=20
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=22
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=157
AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=157
AND a.category_publish='Y'
ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=158
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=159
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=23
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=21
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=144
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=54
AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=6&lang=ru&page=shop.browse'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=6&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=6
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
WHERE a.category_id = f.category_id
AND f.category_id=6
AND a.category_publish='Y'
AND p.product_id = f.product_id
AND p.product_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=6
AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=6
AND a.category_publish='Y'
ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=40
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=74
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=42
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=75
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=43
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=44
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=41
AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=3&lang=ru&page=shop.browse'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=3&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=3
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
WHERE a.category_id = f.category_id
AND f.category_id=3
AND a.category_publish='Y'
AND p.product_id = f.product_id
AND p.product_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=3
AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=3
AND a.category_publish='Y'
ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=26
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=27
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=28
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=29
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=124
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=30
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=31
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=163
AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=4&lang=ru&page=shop.browse'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=4&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=4
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
WHERE a.category_id = f.category_id
AND f.category_id=4
AND a.category_publish='Y'
AND p.product_id = f.product_id
AND p.product_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=4
AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=4
AND a.category_publish='Y'
ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=32
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=33
AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=8&lang=ru&page=shop.browse'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=8&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=8
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
WHERE a.category_id = f.category_id
AND f.category_id=8
AND a.category_publish='Y'
AND p.product_id = f.product_id
AND p.product_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=8
AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=8
AND a.category_publish='Y'
ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=48
AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=48
AND a.category_publish='Y'
ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=94
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=95
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=96
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=97
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=103
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=104
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=168
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=49
AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=9&lang=ru&page=shop.browse'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=9&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=9
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
WHERE a.category_id = f.category_id
AND f.category_id=9
AND a.category_publish='Y'
AND p.product_id = f.product_id
AND p.product_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=9
AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=9
AND a.category_publish='Y'
ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=50
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=51
AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=51
AND a.category_publish='Y'
ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=126
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=127
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=128
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=129
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=130
AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=7&lang=ru&page=shop.browse'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=7&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=7
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
WHERE a.category_id = f.category_id
AND f.category_id=7
AND a.category_publish='Y'
AND p.product_id = f.product_id
AND p.product_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=7
AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=7
AND a.category_publish='Y'
ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=45
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=46
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=47
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=57
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=58
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=59
AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=169&lang=ru&page=shop.browse'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=169&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=169
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
WHERE a.category_id = f.category_id
AND f.category_id=169
AND a.category_publish='Y'
AND p.product_id = f.product_id
AND p.product_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=169
AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=170&lang=ru&page=shop.browse'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=170&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=170
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
WHERE a.category_id = f.category_id
AND f.category_id=170
AND a.category_publish='Y'
AND p.product_id = f.product_id
AND p.product_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=170
AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=170
AND a.category_publish='Y'
ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=171
AND a.category_publish='Y'
SELECT COUNT(*) AS parentcnt
FROM glenrich_vm_product
WHERE product_parent_id>0
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`=11
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, 2000
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=88'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
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 = 88
SELECT product_id, product_sku, product_name
FROM glenrich_vm_product
WHERE product_id = '88'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=88'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=85'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
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 = 85
SELECT product_id, product_sku, product_name
FROM glenrich_vm_product
WHERE product_id = '85'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=85'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&lang=ru'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
SELECT name, link,id
FROM glenrich_menu
WHERE id = '8'
AND published='1'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&lang=ru&limitstart=0'
SELECT vendor_id, vendor_name, vendor_store_name, vendor_store_desc
FROM glenrich_vm_vendor
SELECT product_id, product_name, product_s_desc
FROM glenrich_vm_product
WHERE product_id = 86
SELECT c.category_name, c.category_id, c.category_description, x.category_parent_id
FROM glenrich_vm_category AS c
LEFT JOIN glenrich_vm_category_xref AS x
ON c.category_id = x.category_child_id;
SELECT id, metadesc, metakey, metatitle, metalang, metarobots
FROM glenrich_sh404SEF_meta
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=11&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=86'
SELECT *
FROM glenrich_session
WHERE session_id = '568i8vnlnub6l7r0vsds3n9j73'
DELETE
FROM glenrich_session
WHERE ( TIME < '1781483308' )
SELECT *
FROM glenrich_session
WHERE session_id = '568i8vnlnub6l7r0vsds3n9j73'
UPDATE `glenrich_session`
SET `time`='1781486908',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1781486906;s:18:\"session.timer.last\";i:1781486906;s:17:\"session.timer.now\";i:1781486906;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:\"65da6a0080a016a1723af4c58895cba6\";}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:2:{s:3:\"idx\";i:1;i:0;a:2:{s:10:\"product_id\";i:430;s:11:\"category_id\";s:2:\"89\";}}ps_vendor_id|i:1;minimum_pov|s:4:\"0.00\";vendor_currency|s:3:\"EUR\";userstate|a:2:{s:10:\"product_id\";s:3:\"430\";s:31:\"view89product_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:3:{i:431;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:429;a:1:{s:7:\"flypage\";s:11:\"flypage.tpl\";}i:430;a:3:{s:13:\"discount_info\";a:3:{s:6:\"amount\";i:0;s:10:\"is_percent\";i:0;s:11:\"create_time\";i:1781486906;}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='568i8vnlnub6l7r0vsds3n9j73'
SELECT *
FROM glenrich_components
WHERE parent = 0
SELECT folder AS TYPE, element AS name, params
FROM glenrich_plugins
WHERE published >= 1
AND access <= 0
ORDER BY ordering
SELECT oldurl, newurl
FROM glenrich_redirection
WHERE oldurl = 'izrazcovyi-kamin-ik6.html'
ORDER BY rank ASC
LIMIT 1
UPDATE glenrich_redirection
SET cpt=(cpt+1)
WHERE `newurl` = 'index.php?option=com_virtuemart&Itemid=8&category_id=11&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=86'
AND `oldurl` = 'izrazcovyi-kamin-ik6.html'
SELECT m.*, c.`option` AS component
FROM glenrich_menu AS m
LEFT JOIN glenrich_components AS c
ON m.componentid = c.id
WHERE m.published = 1
ORDER BY m.sublevel, m.parent, m.ordering
SELECT m.*, c.`option` AS component
FROM glenrich_menu AS m
LEFT JOIN glenrich_components AS c
ON m.componentid = c.id
WHERE m.published = 1
ORDER BY m.sublevel, m.parent, m.ordering
SELECT group_id,group_name,group_level
FROM `glenrich_vm_auth_group`
ORDER BY group_level
SELECT glenrich_vm_shopper_group.shopper_group_id, show_price_including_tax, `default`, shopper_group_discount
FROM `glenrich_vm_shopper_group`
WHERE glenrich_vm_shopper_group.vendor_id='1'
AND `default`='1'
SELECT vendor_id, vendor_min_pov,vendor_name,vendor_store_name,contact_email,vendor_full_image, vendor_freeshipping,
vendor_address_1,vendor_address_2, vendor_url, vendor_city, vendor_state, vendor_country, country_2_code, country_3_code,
vendor_zip, vendor_phone, vendor_store_desc, vendor_currency, vendor_currency_display_style,
vendor_accepted_currencies, vendor_address_format, vendor_date_format, state_name
FROM (`glenrich_vm_vendor` v, `glenrich_vm_country` c)
LEFT JOIN glenrich_vm_state s
ON (v.vendor_state=s.state_2_code
AND s.country_id=c.country_id)
WHERE `v`.`vendor_id`=1
AND (`v`.`vendor_country`=`c`.`country_2_code` OR `v`.`vendor_country`=`c`.`country_3_code`);
SELECT module_perms
FROM glenrich_vm_module
WHERE module_name='shop'
SELECT id
FROM glenrich_menu
WHERE link='index.php?option=com_virtuemart'
AND published=1
SELECT *
FROM `glenrich_vm_product`
WHERE `product_id`=86
AND `product_publish`='Y'
SELECT product_sku, related_products
FROM glenrich_vm_product,glenrich_vm_product_relations
WHERE glenrich_vm_product_relations.product_id='86'
AND product_publish='Y'
AND FIND_IN_SET(glenrich_vm_product.product_id, REPLACE(related_products, '|', ',' ))
LIMIT 0, 8
SELECT product_id, product_name, product_parent_id, product_thumb_image
FROM glenrich_vm_product
WHERE product_sku='ИК3'
SELECT category_id
FROM `glenrich_vm_product_category_xref`
WHERE product_id=83
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`='83'
SELECT id, params
FROM glenrich_menu
WHERE link='index.php?option=com_virtuemart'
AND published=1
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=11&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=83'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
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 = 83
SELECT product_id, product_sku, product_name
FROM glenrich_vm_product
WHERE product_id = '83'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=11&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=83'
SELECT product_id, `glenrich_vm_product`.*
FROM `glenrich_vm_product`
WHERE `product_id`=83
SELECT amount,is_percent
FROM glenrich_vm_product,glenrich_vm_product_discount
WHERE product_id='83'
AND (start_date<='1781486908' OR start_date=0)
AND (end_date>='1781480160' OR end_date=0)
AND product_discount_id=discount_id
SELECT product_parent_id
FROM glenrich_vm_product
WHERE product_id=83
SELECT amount,is_percent
FROM glenrich_vm_product,glenrich_vm_product_discount
WHERE product_id='0'
AND (start_date<='1781486908' OR start_date=0)
AND (end_date>='1781480160' OR end_date=0)
AND product_discount_id=discount_id
SELECT vendor_id
FROM glenrich_vm_product
WHERE product_id='83'
SELECT shopper_group_id,shopper_group_discount
FROM glenrich_vm_shopper_group
WHERE vendor_id='1'
AND `default`='1'
SELECT `product_price`, `product_price_id`, `product_currency`
FROM `glenrich_vm_product_price`
WHERE product_id=83
AND shopper_group_id=5
ORDER BY price_quantity_start
SELECT `product_price`, `product_price_id`, `product_currency`
FROM `glenrich_vm_product_price`
WHERE product_id=83
AND shopper_group_id=5
ORDER BY price_quantity_start
SELECT `product_price`, `product_price_id`, `product_currency`
FROM `glenrich_vm_product_price`
WHERE product_id=83
AND shopper_group_id=5
ORDER BY price_quantity_start
SELECT `product_price`, `product_price_id`, `product_currency`
FROM `glenrich_vm_product_price`
WHERE product_id=83
AND shopper_group_id=5
ORDER BY price_quantity_start
SELECT COUNT(product_id) AS num_rows
FROM glenrich_vm_product
WHERE product_parent_id='83'
SELECT product_id, product_name, product_parent_id, product_thumb_image
FROM glenrich_vm_product
WHERE product_sku='ИК 27'
SELECT category_id
FROM `glenrich_vm_product_category_xref`
WHERE product_id=1191
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`='1191'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=1&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=1191'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
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 = 1191
SELECT product_id, product_sku, product_name
FROM glenrich_vm_product
WHERE product_id = '1191'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=1&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=1191'
SELECT product_id, `glenrich_vm_product`.*
FROM `glenrich_vm_product`
WHERE `product_id`=1191
SELECT amount,is_percent
FROM glenrich_vm_product,glenrich_vm_product_discount
WHERE product_id='1191'
AND (start_date<='1781486908' OR start_date=0)
AND (end_date>='1781480160' OR end_date=0)
AND product_discount_id=discount_id
SELECT product_parent_id
FROM glenrich_vm_product
WHERE product_id=1191
SELECT amount,is_percent
FROM glenrich_vm_product,glenrich_vm_product_discount
WHERE product_id='0'
AND (start_date<='1781486908' OR start_date=0)
AND (end_date>='1781480160' OR end_date=0)
AND product_discount_id=discount_id
SELECT vendor_id
FROM glenrich_vm_product
WHERE product_id='1191'
SELECT `product_price`, `product_price_id`, `product_currency`
FROM `glenrich_vm_product_price`
WHERE product_id=1191
AND shopper_group_id=5
ORDER BY price_quantity_start
SELECT tax_rate
FROM glenrich_vm_product, glenrich_vm_tax_rate
WHERE product_tax_id=tax_rate_id
AND product_id=1191
SELECT COUNT(product_id) AS num_rows
FROM glenrich_vm_product
WHERE product_parent_id='1191'
SELECT product_id, product_name, product_parent_id, product_thumb_image
FROM glenrich_vm_product
WHERE product_sku='ИК45'
SELECT category_id
FROM `glenrich_vm_product_category_xref`
WHERE product_id=1355
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`='1355'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=11&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=1355'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
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 = 1355
SELECT product_id, product_sku, product_name
FROM glenrich_vm_product
WHERE product_id = '1355'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=11&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=1355'
SELECT product_id, `glenrich_vm_product`.*
FROM `glenrich_vm_product`
WHERE `product_id`=1355
SELECT amount,is_percent
FROM glenrich_vm_product,glenrich_vm_product_discount
WHERE product_id='1355'
AND (start_date<='1781486908' OR start_date=0)
AND (end_date>='1781480160' OR end_date=0)
AND product_discount_id=discount_id
SELECT product_parent_id
FROM glenrich_vm_product
WHERE product_id=1355
SELECT amount,is_percent
FROM glenrich_vm_product,glenrich_vm_product_discount
WHERE product_id='0'
AND (start_date<='1781486908' OR start_date=0)
AND (end_date>='1781480160' OR end_date=0)
AND product_discount_id=discount_id
SELECT vendor_id
FROM glenrich_vm_product
WHERE product_id='1355'
SELECT `product_price`, `product_price_id`, `product_currency`
FROM `glenrich_vm_product_price`
WHERE product_id=1355
AND shopper_group_id=5
ORDER BY price_quantity_start
SELECT `product_price`, `product_price_id`, `product_currency`
FROM `glenrich_vm_product_price`
WHERE product_id=1355
AND shopper_group_id=5
ORDER BY price_quantity_start
SELECT `product_price`, `product_price_id`, `product_currency`
FROM `glenrich_vm_product_price`
WHERE product_id=1355
AND shopper_group_id=5
ORDER BY price_quantity_start
SELECT `product_price`, `product_price_id`, `product_currency`
FROM `glenrich_vm_product_price`
WHERE product_id=1355
AND shopper_group_id=5
ORDER BY price_quantity_start
SELECT COUNT(product_id) AS num_rows
FROM glenrich_vm_product
WHERE product_parent_id='1355'
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='11'
AND glenrich_vm_category.category_id='11'
SELECT category_id, category_name,category_parent_id, category_child_id
FROM glenrich_vm_category, glenrich_vm_category_xref
WHERE glenrich_vm_category_xref.category_child_id='1'
AND glenrich_vm_category.category_id='1'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=1&lang=ru&page=shop.browse'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
SELECT c.category_name, c.category_id, x.category_parent_id
FROM glenrich_vm_category AS c
LEFT JOIN glenrich_vm_category_xref AS x
ON c.category_id = x.category_child_id;
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=1&lang=ru&limitstart=0&page=shop.browse'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=11&lang=ru&page=shop.browse'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=11&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*) AS parentcnt
FROM glenrich_vm_product
WHERE product_parent_id>0
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`=11
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, 2000
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`='88'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=88'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
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 = 88
SELECT product_id, product_sku, product_name
FROM glenrich_vm_product
WHERE product_id = '88'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=88'
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`='85'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=85'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
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 = 85
SELECT product_id, product_sku, product_name
FROM glenrich_vm_product
WHERE product_id = '85'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=85'
SELECT template
FROM glenrich_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 8)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT category_child_id
FROM glenrich_vm_category_xref
WHERE category_parent_id='11'
SELECT manufacturer_id
FROM glenrich_vm_product_mf_xref
WHERE product_id='86'
SELECT mf_name,glenrich_vm_manufacturer.manufacturer_id
FROM glenrich_vm_product_mf_xref,glenrich_vm_manufacturer
WHERE product_id='86'
AND glenrich_vm_manufacturer.manufacturer_id=glenrich_vm_product_mf_xref.manufacturer_id
SELECT product_id, `glenrich_vm_product`.*
FROM `glenrich_vm_product`
WHERE `product_id`=86
SELECT amount,is_percent
FROM glenrich_vm_product,glenrich_vm_product_discount
WHERE product_id='86'
AND (start_date<='1781486908' OR start_date=0)
AND (end_date>='1781480160' OR end_date=0)
AND product_discount_id=discount_id
SELECT product_parent_id
FROM glenrich_vm_product
WHERE product_id=86
SELECT amount,is_percent
FROM glenrich_vm_product,glenrich_vm_product_discount
WHERE product_id='0'
AND (start_date<='1781486908' OR start_date=0)
AND (end_date>='1781480160' OR end_date=0)
AND product_discount_id=discount_id
SELECT vendor_id
FROM glenrich_vm_product
WHERE product_id='86'
SELECT `product_price`, `product_price_id`, `product_currency`
FROM `glenrich_vm_product_price`
WHERE product_id=86
AND shopper_group_id=5
ORDER BY price_quantity_start
SELECT `product_price`, `product_price_id`, `product_currency`
FROM `glenrich_vm_product_price`
WHERE product_id=86
AND shopper_group_id=5
ORDER BY price_quantity_start
SELECT `product_price`, `product_price_id`, `product_currency`
FROM `glenrich_vm_product_price`
WHERE product_id=86
AND shopper_group_id=5
ORDER BY price_quantity_start
SELECT `product_price`, `product_price_id`, `product_currency`
FROM `glenrich_vm_product_price`
WHERE product_id=86
AND shopper_group_id=5
ORDER BY price_quantity_start
SELECT COUNT(product_id) AS num_rows
FROM glenrich_vm_product
WHERE product_parent_id='86'
SELECT `product_price`, `product_price_id`, `product_currency`
FROM `glenrich_vm_product_price`
WHERE product_id=86
AND shopper_group_id=5
ORDER BY price_quantity_start
SELECT `product_price`, `product_price_id`, `product_currency`
FROM `glenrich_vm_product_price`
WHERE product_id=86
AND shopper_group_id=5
ORDER BY price_quantity_start
SELECT tax_rate
FROM glenrich_vm_product, glenrich_vm_tax_rate
WHERE product_tax_id=tax_rate_id
AND product_id=86
SELECT *
FROM `glenrich_vm_product_files`
WHERE `file_product_id`=86
AND `file_is_image`=1
AND `file_published`=1
SELECT *
FROM `glenrich_vm_product_files`
WHERE `file_product_id`=86
AND `file_is_image`=0
SELECT product_parent_id
FROM glenrich_vm_product
WHERE product_id='86'
SELECT *
FROM `glenrich_vm_product_files`
WHERE `file_product_id`=0
AND `file_is_image`=0
SELECT attribute_value
FROM glenrich_vm_product_attribute
WHERE `product_id` = '0'
AND attribute_name='download'
SELECT DISTINCT file_id, file_mimetype, file_title, file_name
FROM `glenrich_vm_product_files`
WHERE file_product_id = '0'
AND file_published = '1'
AND file_is_image = '0'
SELECT COUNT(product_id) AS num_rows
FROM glenrich_vm_product
WHERE product_parent_id='86'
SELECT COUNT(product_id) AS num_rows
FROM glenrich_vm_product
WHERE product_parent_id='86'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=11&flypage=flypage.tpl&lang=ru&page=shop.ask&product_id=86'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
SELECT glenrich_vm_vendor.vendor_name
FROM glenrich_vm_product, glenrich_vm_vendor
WHERE glenrich_vm_product.product_id='86'
AND glenrich_vm_vendor.vendor_id=glenrich_vm_product.vendor_id
SELECT *
FROM glenrich_vm_product_product_type_xref
WHERE product_id='86'
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 = '430'
AND c.category_id = '89'
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
SELECT product_id, `glenrich_vm_product`.*
FROM `glenrich_vm_product`
WHERE `product_id`=430
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=89&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=430'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
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 = 430
SELECT product_id, product_sku, product_name
FROM glenrich_vm_product
WHERE product_id = '430'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=89&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=430'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=89&lang=ru&page=shop.browse'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=89&lang=ru&limitstart=0&page=shop.browse'
SELECT product_id, `glenrich_vm_product`.*
FROM `glenrich_vm_product`
WHERE `product_id`=86
SELECT product_id, attribute, product_parent_id
FROM glenrich_vm_product
WHERE product_id='86'
SELECT product_id, attribute
FROM glenrich_vm_product
WHERE product_id='86'
SELECT `product_price`, `product_price_id`, `product_currency`
FROM `glenrich_vm_product_price`
WHERE product_id=86
AND shopper_group_id=5
ORDER BY price_quantity_start
SELECT `product_price`, `product_price_id`, `product_currency`
FROM `glenrich_vm_product_price`
WHERE product_id=86
AND shopper_group_id=5
ORDER BY price_quantity_start
SELECT product_id, custom_attribute, product_parent_id
FROM glenrich_vm_product
WHERE product_id='86'
SELECT product_id, custom_attribute
FROM glenrich_vm_product
WHERE product_id='86'
SELECT product_id,product_name
FROM glenrich_vm_product
WHERE product_parent_id='86'
AND product_publish='Y'
SELECT `payment_method_id`
FROM `glenrich_vm_payment_method`
WHERE `payment_class`='ps_paypal_api'
AND `payment_enabled`='Y'
SELECT m.*, am.params AS adv_params
FROM glenrich_modules AS m
LEFT JOIN glenrich_advancedmodules AS am
ON am.moduleid = m.id
WHERE m.published = 1
AND m.access <= 0
AND m.client_id = 0
ORDER BY m.ordering, m.id
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&lang=ru&page=shop.search'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&lang=ru&limitstart=0&page=shop.search'
SELECT group_id,group_name,group_level
FROM `glenrich_vm_auth_group`
ORDER BY group_level
SELECT published
FROM glenrich_modules
WHERE module='mod_virtuemart_cart'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=0
AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=0
AND a.category_publish='Y'
ORDER BY a.list_order, a.category_name
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=1&lang=ru&page=shop.browse'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=1&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=1
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
WHERE a.category_id = f.category_id
AND f.category_id=1
AND a.category_publish='Y'
AND p.product_id = f.product_id
AND p.product_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=1
AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=1
AND a.category_publish='Y'
ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=133
AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=133
AND a.category_publish='Y'
ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=139
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=164
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=11
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=12
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=13
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=162
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=125
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=14
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=15
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=24
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=25
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=56
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=60
AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=60
AND a.category_publish='Y'
ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=88
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=89
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=90
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=91
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=93
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=166
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=61
AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=61
AND a.category_publish='Y'
ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=110
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=112
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=113
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=62
AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=62
AND a.category_publish='Y'
ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=120
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=117
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=119
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=118
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=167
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=161
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=1
AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=1
AND a.category_publish='Y'
ORDER BY a.list_order, a.category_name
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=133&lang=ru&page=shop.browse'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=133&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=133
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
WHERE a.category_id = f.category_id
AND f.category_id=133
AND a.category_publish='Y'
AND p.product_id = f.product_id
AND p.product_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=133
AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=133
AND a.category_publish='Y'
ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=139
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=164
AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=11&lang=ru&page=shop.browse'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=11&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=11
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
WHERE a.category_id = f.category_id
AND f.category_id=11
AND a.category_publish='Y'
AND p.product_id = f.product_id
AND p.product_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=11
AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=12&lang=ru&page=shop.browse'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=12&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=12
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
WHERE a.category_id = f.category_id
AND f.category_id=12
AND a.category_publish='Y'
AND p.product_id = f.product_id
AND p.product_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=12
AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=13&lang=ru&page=shop.browse'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=13&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=13
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
WHERE a.category_id = f.category_id
AND f.category_id=13
AND a.category_publish='Y'
AND p.product_id = f.product_id
AND p.product_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=13
AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&lang=ru&page=shop.browse'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=162&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=162
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
WHERE a.category_id = f.category_id
AND f.category_id=162
AND a.category_publish='Y'
AND p.product_id = f.product_id
AND p.product_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=162
AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=125&lang=ru&page=shop.browse'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=125&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=125
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
WHERE a.category_id = f.category_id
AND f.category_id=125
AND a.category_publish='Y'
AND p.product_id = f.product_id
AND p.product_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=125
AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=14&lang=ru&page=shop.browse'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=14&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=14
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
WHERE a.category_id = f.category_id
AND f.category_id=14
AND a.category_publish='Y'
AND p.product_id = f.product_id
AND p.product_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=14
AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=15&lang=ru&page=shop.browse'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=15&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=15
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
WHERE a.category_id = f.category_id
AND f.category_id=15
AND a.category_publish='Y'
AND p.product_id = f.product_id
AND p.product_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=15
AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=24&lang=ru&page=shop.browse'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=24&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=24
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
WHERE a.category_id = f.category_id
AND f.category_id=24
AND a.category_publish='Y'
AND p.product_id = f.product_id
AND p.product_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=24
AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=25&lang=ru&page=shop.browse'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=25&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=25
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
WHERE a.category_id = f.category_id
AND f.category_id=25
AND a.category_publish='Y'
AND p.product_id = f.product_id
AND p.product_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=25
AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=56&lang=ru&page=shop.browse'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=56&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=56
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
WHERE a.category_id = f.category_id
AND f.category_id=56
AND a.category_publish='Y'
AND p.product_id = f.product_id
AND p.product_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=56
AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=60&lang=ru&page=shop.browse'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=60&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=60
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
WHERE a.category_id = f.category_id
AND f.category_id=60
AND a.category_publish='Y'
AND p.product_id = f.product_id
AND p.product_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=60
AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=60
AND a.category_publish='Y'
ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=88
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=89
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=90
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=91
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=93
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=166
AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&lang=ru&page=shop.browse'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=61&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=61
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
WHERE a.category_id = f.category_id
AND f.category_id=61
AND a.category_publish='Y'
AND p.product_id = f.product_id
AND p.product_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=61
AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=61
AND a.category_publish='Y'
ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=110
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=112
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=113
AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&lang=ru&page=shop.browse'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=62&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=62
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
WHERE a.category_id = f.category_id
AND f.category_id=62
AND a.category_publish='Y'
AND p.product_id = f.product_id
AND p.product_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=62
AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=62
AND a.category_publish='Y'
ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=120
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=117
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=119
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=118
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=167
AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=161&lang=ru&page=shop.browse'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=161&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=161
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
WHERE a.category_id = f.category_id
AND f.category_id=161
AND a.category_publish='Y'
AND p.product_id = f.product_id
AND p.product_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=161
AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=2&lang=ru&page=shop.browse'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=2&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=2
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
WHERE a.category_id = f.category_id
AND f.category_id=2
AND a.category_publish='Y'
AND p.product_id = f.product_id
AND p.product_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=2
AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=2
AND a.category_publish='Y'
ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=132
AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=132
AND a.category_publish='Y'
ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=135
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=136
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=137
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=145
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=16
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=17
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=140
AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=140
AND a.category_publish='Y'
ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=141
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=142
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=143
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=18
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=19
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=20
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=22
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=157
AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=157
AND a.category_publish='Y'
ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=158
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=159
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=23
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=21
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=144
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=54
AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=6&lang=ru&page=shop.browse'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=6&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=6
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
WHERE a.category_id = f.category_id
AND f.category_id=6
AND a.category_publish='Y'
AND p.product_id = f.product_id
AND p.product_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=6
AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=6
AND a.category_publish='Y'
ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=40
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=74
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=42
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=75
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=43
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=44
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=41
AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=3&lang=ru&page=shop.browse'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=3&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=3
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
WHERE a.category_id = f.category_id
AND f.category_id=3
AND a.category_publish='Y'
AND p.product_id = f.product_id
AND p.product_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=3
AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=3
AND a.category_publish='Y'
ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=26
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=27
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=28
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=29
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=124
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=30
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=31
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=163
AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=4&lang=ru&page=shop.browse'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=4&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=4
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
WHERE a.category_id = f.category_id
AND f.category_id=4
AND a.category_publish='Y'
AND p.product_id = f.product_id
AND p.product_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=4
AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=4
AND a.category_publish='Y'
ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=32
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=33
AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=8&lang=ru&page=shop.browse'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=8&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=8
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
WHERE a.category_id = f.category_id
AND f.category_id=8
AND a.category_publish='Y'
AND p.product_id = f.product_id
AND p.product_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=8
AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=8
AND a.category_publish='Y'
ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=48
AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=48
AND a.category_publish='Y'
ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=94
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=95
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=96
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=97
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=103
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=104
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=168
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=49
AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=9&lang=ru&page=shop.browse'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=9&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=9
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
WHERE a.category_id = f.category_id
AND f.category_id=9
AND a.category_publish='Y'
AND p.product_id = f.product_id
AND p.product_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=9
AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=9
AND a.category_publish='Y'
ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=50
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=51
AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=51
AND a.category_publish='Y'
ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=126
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=127
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=128
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=129
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=130
AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=7&lang=ru&page=shop.browse'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=7&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=7
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
WHERE a.category_id = f.category_id
AND f.category_id=7
AND a.category_publish='Y'
AND p.product_id = f.product_id
AND p.product_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=7
AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=7
AND a.category_publish='Y'
ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=45
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=46
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=47
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=57
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=58
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=59
AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=169&lang=ru&page=shop.browse'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=169&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=169
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
WHERE a.category_id = f.category_id
AND f.category_id=169
AND a.category_publish='Y'
AND p.product_id = f.product_id
AND p.product_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=169
AND a.category_publish='Y'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=170&lang=ru&page=shop.browse'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=170&lang=ru&limitstart=0&page=shop.browse'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=170
AND a.category_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_product_category_xref AS f, glenrich_vm_category AS a, glenrich_vm_product AS p
WHERE a.category_id = f.category_id
AND f.category_id=170
AND a.category_publish='Y'
AND p.product_id = f.product_id
AND p.product_publish='Y'
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=170
AND a.category_publish='Y'
SELECT a.category_id, a.category_name, a.category_publish, a.list_order, f.category_parent_id, f.category_child_id
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=170
AND a.category_publish='Y'
ORDER BY a.list_order, a.category_name
SELECT COUNT(*)
FROM glenrich_vm_category AS a, glenrich_vm_category_xref AS f
WHERE a.category_id = f.category_child_id
AND f.category_parent_id=171
AND a.category_publish='Y'
SELECT COUNT(*) AS parentcnt
FROM glenrich_vm_product
WHERE product_parent_id>0
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`=11
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, 2000
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=88'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
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 = 88
SELECT product_id, product_sku, product_name
FROM glenrich_vm_product
WHERE product_id = '88'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=88'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&page=shop.product_details&product_id=85'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
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 = 85
SELECT product_id, product_sku, product_name
FROM glenrich_vm_product
WHERE product_id = '85'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=85'
SELECT oldurl, dateadd
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&lang=ru'
SELECT name, link,id
FROM glenrich_menu
WHERE published='1'
AND link LIKE 'index.php?option=com_virtuemart%'
SELECT name, link,id
FROM glenrich_menu
WHERE id = '8'
AND published='1'
SELECT oldurl
FROM glenrich_redirection
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&lang=ru&limitstart=0'
SELECT vendor_id, vendor_name, vendor_store_name, vendor_store_desc
FROM glenrich_vm_vendor
SELECT product_id, product_name, product_s_desc
FROM glenrich_vm_product
WHERE product_id = 86
SELECT c.category_name, c.category_id, c.category_description, x.category_parent_id
FROM glenrich_vm_category AS c
LEFT JOIN glenrich_vm_category_xref AS x
ON c.category_id = x.category_child_id;
SELECT id, metadesc, metakey, metatitle, metalang, metarobots
FROM glenrich_sh404SEF_meta
WHERE newurl = 'index.php?option=com_virtuemart&Itemid=8&category_id=11&flypage=flypage.tpl&lang=ru&limitstart=0&page=shop.product_details&product_id=86'
Глазурь 90
Глазурь 1780
Глазурь 1095
Глазурь 1490
Глазурь 0580
Глазурь 995
Глазурь 3280
Глазурь 5210
Глазурь 1450
Глазурь 1140
Глазурь 0770
Глазурь 0230
Глазурь 1130
Глазурь 1190
Глазурь 1500
Глазурь 1410
Глазурь 2270
Глазурь 3470
Глазурь 5294
Глазурь 0800
Глазурь 1260
Глазурь 0740
Глазурь 461
Глазурь 1270
