•Joomla! accessible Template•

•Profile Information•

•Memory Usage•

•69 queries logged•

1. SELECT *
     FROM jos_session
     WHERE session_id = 'f3fcd0d17fb1eef8172e6478ffff16a7'
2. DELETE
     FROM jos_session
     WHERE ( time < '1268225217' )
3. SELECT *
     FROM jos_session
     WHERE session_id = 'f3fcd0d17fb1eef8172e6478ffff16a7'
4. INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
     VALUES ( 'f3fcd0d17fb1eef8172e6478ffff16a7','1268226117','','0','1','0' )
5. SELECT *
     FROM jos_components
     WHERE parent = 0
6. SELECT folder AS type, element AS name, params
     FROM jos_plugins
     WHERE published >= 1
     AND access <= 0
     ORDER BY ordering
7. SELECT m.*, c.`option` AS component
     FROM jos_menu AS m
     LEFT JOIN jos_components AS c
     ON m.componentid = c.id
     WHERE m.published = 1
     ORDER BY m.sublevel, m.parent, m.ordering
8. SELECT template
     FROM jos_templates_menu
     WHERE client_id = 0
     AND (menuid = 0 OR menuid = 68)
     ORDER BY menuid DESC
     LIMIT 0, 1
9. SELECT a.id, a.title, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.attribs, a.urls, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups, cc.title AS category, s.title AS section, s.ordering AS s_ordering, cc.ordering AS cc_ordering, a.ordering AS a_ordering, f.ordering AS f_ordering
     FROM jos_content AS a
     INNER JOIN jos_content_frontpage AS f
     ON f.content_id = a.id
     LEFT JOIN jos_categories AS cc
     ON cc.id = a.catid
     LEFT JOIN jos_sections AS s
     ON s.id = a.sectionid
     LEFT JOIN jos_users AS u
     ON u.id = a.created_by
     LEFT JOIN jos_groups AS g
     ON a.access = g.id
     WHERE 1
     AND a.access <= 0
     AND a.state = 1
     AND (( cc.published = 1
     AND s.published = 1 ) OR ( a.catid = 0
     AND a.sectionid = 0 ) )
     AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-03-10 13:01:58' )
     AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-03-10 13:01:58' )
     ORDER BY  f.ordering
     LIMIT 0, 9
10. SELECT a.id, a.title, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.attribs, a.urls, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups, cc.title AS category, s.title AS section, s.ordering AS s_ordering, cc.ordering AS cc_ordering, a.ordering AS a_ordering, f.ordering AS f_ordering
      FROM jos_content AS a
      INNER JOIN jos_content_frontpage AS f
      ON f.content_id = a.id
      LEFT JOIN jos_categories AS cc
      ON cc.id = a.catid
      LEFT JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON u.id = a.created_by
      LEFT JOIN jos_groups AS g
      ON a.access = g.id
      WHERE 1
      AND a.access <= 0
      AND a.state = 1
      AND (( cc.published = 1
      AND s.published = 1 ) OR ( a.catid = 0
      AND a.sectionid = 0 ) )
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-03-10 13:01:58' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-03-10 13:01:58' )
      ORDER BY  f.ordering
11. SELECT id, title, module, position, content, showtitle, control, params
      FROM jos_modules AS m
      LEFT JOIN jos_modules_menu AS mm
      ON mm.moduleid = m.id
      WHERE m.published = 1
      AND m.access <= 0
      AND m.client_id = 0
      AND ( mm.menuid = 68 OR mm.menuid = 0 )
      ORDER BY position, ordering
12. SELECT group_id,group_name,group_level
      FROM `jos_vm_auth_group`
      ORDER BY group_level
13. SELECT jos_vm_shopper_group.shopper_group_id, show_price_including_tax, `default`, shopper_group_discount
               
      FROM `jos_vm_shopper_group`
      WHERE jos_vm_shopper_group.vendor_id='1'
      AND `default`='1'
14. SELECT `name`
      FROM `jos_core_acl_aro_groups`
      WHERE `id` =29
15. SELECT `lft`, `rgt`
      FROM `jos_core_acl_aro_groups`
      WHERE `name`='Public Frontend'
16. SELECT g1.id, g1.name, COUNT(g2.name) AS level
    
      FROM jos_core_acl_aro_groups AS g1
    
      INNER JOIN jos_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt
    
    
      GROUP BY g1.name
    
      ORDER BY g1.lft
17. SELECT `lft`, `rgt`
      FROM `jos_core_acl_aro_groups`
      WHERE `name`='Public Backend'
18. SELECT g1.id, g1.name, COUNT(g2.name) AS level
    
      FROM jos_core_acl_aro_groups AS g1
    
      INNER JOIN jos_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt
    
    
      GROUP BY g1.name
    
      ORDER BY g1.lft
19. SELECT vendor_id, vendor_min_pov,vendor_name,vendor_store_name,contact_email,vendor_full_image, vendor_freeshipping,
                                            vendor_address_1, 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
                                   
      FROM (`jos_vm_vendor`, `jos_vm_country`)
                                   
      WHERE `vendor_id`=1
                                   
      AND (vendor_country=country_2_code OR vendor_country=country_3_code);
20. SELECT category_id, category_description, category_name,category_child_id AS cid, category_parent_id AS pid,list_order, category_publish
                                                   
      FROM jos_vm_category, jos_vm_category_xref
      WHERE jos_vm_category.category_publish='Y'
      AND jos_vm_category.category_id=jos_vm_category_xref.category_child_id
      ORDER BY jos_vm_category.list_order ASC, jos_vm_category.category_name ASC
21. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
22. SELECT group_id,group_name,group_level
      FROM `jos_vm_auth_group`
      ORDER BY group_level
23. SELECT COUNT(user_id) AS num_rows
      FROM `jos_vm_user_info`
                                           
      WHERE jos_vm_user_info.user_id='0' 
                                           
      AND jos_vm_user_info.address_type='BT'
24. SELECT published
      FROM jos_modules
      WHERE module='mod_virtuemart_cart'
25. SELECT id
      FROM jos_menu
      WHERE link LIKE '%index.php?option=com_virtuemart%'
26. SELECT *
      FROM jos_vm_category_xref
      WHERE category_parent_id = 0
27. SELECT *
      FROM jos_vm_category
      WHERE category_id = 18
28. SELECT count(*)
      FROM jos_vm_product_category_xref
      WHERE category_id = 18
29. SELECT count(*)
      FROM jos_vm_category_xref
      WHERE category_parent_id = 18
30. SELECT category_child_id
      FROM jos_vm_category_xref
      WHERE category_parent_id = 18
31. SELECT *
      FROM jos_vm_product_category_xref
      WHERE category_id = 18
32. SELECT *
      FROM jos_vm_product
      WHERE product_id=27
33. SELECT *
      FROM jos_vm_category
      WHERE category_id = 19
34. SELECT count(*)
      FROM jos_vm_product_category_xref
      WHERE category_id = 19
35. SELECT count(*)
      FROM jos_vm_category_xref
      WHERE category_parent_id = 19
36. SELECT category_child_id
      FROM jos_vm_category_xref
      WHERE category_parent_id = 19
37. SELECT *
      FROM jos_vm_product_category_xref
      WHERE category_id = 19
38. SELECT *
      FROM jos_vm_product
      WHERE product_id=28
39. SELECT guest, usertype, client_id
      FROM jos_session
      WHERE client_id = 0
40. SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.name) THEN CONCAT_WS(":", cc.id, cc.name) ELSE cc.id END AS catslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      WHERE a.state = 1 
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = "0000-00-00 00:00:00" OR a.publish_up <= "2010-03-10 13:02:00" ) 
      AND (a.publish_down = "0000-00-00 00:00:00" OR a.publish_down >= "2010-03-10 13:02:00" )
      AND cc.id = 34
      AND cc.section = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
41. SELECT DISTINCT product_sku
      FROM jos_vm_product, jos_vm_product_category_xref, jos_vm_category
      WHERE (jos_vm_product.product_parent_id='' OR jos_vm_product.product_parent_id='0')
      AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id
      AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id
      AND jos_vm_product.product_publish='Y'
      AND jos_vm_product.product_special='Y'
      ORDER BY product_name DESC
      LIMIT 1
42. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='HACKED'
43. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='27'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
44. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`
    
                           
      LEFT JOIN `jos_vm_product_category_xref`
      ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                           
      LEFT JOIN `jos_vm_category`
      ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`
    
                           
      WHERE `jos_vm_product`.`product_id`='27'
45. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=27
46. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='27'
      AND (start_date<='1268226120' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
47. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='27'
48. SELECT shopper_group_id,shopper_group_discount
      FROM jos_vm_shopper_group
      WHERE vendor_id='1'
      AND `default`='1'
49. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=27
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
50. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='27'
51. SELECT `tax_rate`
      FROM jos_vm_vendor, jos_vm_tax_rate
      WHERE tax_country=vendor_country
      AND jos_vm_vendor.vendor_id=1
      ORDER BY `tax_rate` DESC
52. SELECT DISTINCT product_sku
      FROM jos_vm_product, jos_vm_product_category_xref, jos_vm_category
      WHERE product_parent_id=''
      AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id
      AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id
      AND jos_vm_product.product_publish='Y'
      ORDER BY product_name DESC
53. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='HACKED'
54. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='27'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
55. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='27'
56. SELECT `tax_rate`
      FROM jos_vm_vendor, jos_vm_tax_rate
      WHERE tax_country=vendor_country
      AND jos_vm_vendor.vendor_id=1
      ORDER BY `tax_rate` DESC
57. SELECT jos_vm_product.product_id, product_parent_id,product_name, jos_vm_category.category_id, category_flypage
      FROM jos_vm_product, jos_vm_product_category_xref, jos_vm_category
      WHERE jos_vm_product.product_publish='Y'
      AND jos_vm_product_category_xref.product_id = jos_vm_product.product_id
      AND jos_vm_product_category_xref.category_id = jos_vm_category.category_id
      AND jos_vm_product.product_sales>0
      ORDER BY jos_vm_product.product_sales DESC
      LIMIT 0, 10
58. SELECT *
      FROM jos_vm_product, jos_vm_product_category_xref, jos_vm_category
      WHERE product_parent_id=''
      AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id
      AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id
      AND jos_vm_product.product_publish='Y'
      ORDER BY jos_vm_product.product_id DESC
      LIMIT 1
59. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='vamp'
60. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='28'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
61. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`
    
                           
      LEFT JOIN `jos_vm_product_category_xref`
      ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                           
      LEFT JOIN `jos_vm_category`
      ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`
    
                           
      WHERE `jos_vm_product`.`product_id`='28'
62. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=28
63. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='28'
      AND (start_date<='1268226121' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
64. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=28
65. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1268226121' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
66. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='28'
67. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=28
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
68. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='28'
69. SELECT `tax_rate`
      FROM jos_vm_vendor, jos_vm_tax_rate
      WHERE tax_country=vendor_country
      AND jos_vm_vendor.vendor_id=1
      ORDER BY `tax_rate` DESC

•69 legacy queries logged•

1. SELECT *
     FROM jos_session
     WHERE session_id = 'f3fcd0d17fb1eef8172e6478ffff16a7'
2. DELETE
     FROM jos_session
     WHERE ( time < '1268225217' )
3. SELECT *
     FROM jos_session
     WHERE session_id = 'f3fcd0d17fb1eef8172e6478ffff16a7'
4. INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
     VALUES ( 'f3fcd0d17fb1eef8172e6478ffff16a7','1268226117','','0','1','0' )
5. SELECT *
     FROM jos_components
     WHERE parent = 0
6. SELECT folder AS type, element AS name, params
     FROM jos_plugins
     WHERE published >= 1
     AND access <= 0
     ORDER BY ordering
7. SELECT m.*, c.`option` AS component
     FROM jos_menu AS m
     LEFT JOIN jos_components AS c
     ON m.componentid = c.id
     WHERE m.published = 1
     ORDER BY m.sublevel, m.parent, m.ordering
8. SELECT template
     FROM jos_templates_menu
     WHERE client_id = 0
     AND (menuid = 0 OR menuid = 68)
     ORDER BY menuid DESC
     LIMIT 0, 1
9. SELECT a.id, a.title, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.attribs, a.urls, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups, cc.title AS category, s.title AS section, s.ordering AS s_ordering, cc.ordering AS cc_ordering, a.ordering AS a_ordering, f.ordering AS f_ordering
     FROM jos_content AS a
     INNER JOIN jos_content_frontpage AS f
     ON f.content_id = a.id
     LEFT JOIN jos_categories AS cc
     ON cc.id = a.catid
     LEFT JOIN jos_sections AS s
     ON s.id = a.sectionid
     LEFT JOIN jos_users AS u
     ON u.id = a.created_by
     LEFT JOIN jos_groups AS g
     ON a.access = g.id
     WHERE 1
     AND a.access <= 0
     AND a.state = 1
     AND (( cc.published = 1
     AND s.published = 1 ) OR ( a.catid = 0
     AND a.sectionid = 0 ) )
     AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-03-10 13:01:58' )
     AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-03-10 13:01:58' )
     ORDER BY  f.ordering
     LIMIT 0, 9
10. SELECT a.id, a.title, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.attribs, a.urls, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups, cc.title AS category, s.title AS section, s.ordering AS s_ordering, cc.ordering AS cc_ordering, a.ordering AS a_ordering, f.ordering AS f_ordering
      FROM jos_content AS a
      INNER JOIN jos_content_frontpage AS f
      ON f.content_id = a.id
      LEFT JOIN jos_categories AS cc
      ON cc.id = a.catid
      LEFT JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON u.id = a.created_by
      LEFT JOIN jos_groups AS g
      ON a.access = g.id
      WHERE 1
      AND a.access <= 0
      AND a.state = 1
      AND (( cc.published = 1
      AND s.published = 1 ) OR ( a.catid = 0
      AND a.sectionid = 0 ) )
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-03-10 13:01:58' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-03-10 13:01:58' )
      ORDER BY  f.ordering
11. SELECT id, title, module, position, content, showtitle, control, params
      FROM jos_modules AS m
      LEFT JOIN jos_modules_menu AS mm
      ON mm.moduleid = m.id
      WHERE m.published = 1
      AND m.access <= 0
      AND m.client_id = 0
      AND ( mm.menuid = 68 OR mm.menuid = 0 )
      ORDER BY position, ordering
12. SELECT group_id,group_name,group_level
      FROM `jos_vm_auth_group`
      ORDER BY group_level
13. SELECT jos_vm_shopper_group.shopper_group_id, show_price_including_tax, `default`, shopper_group_discount
               
      FROM `jos_vm_shopper_group`
      WHERE jos_vm_shopper_group.vendor_id='1'
      AND `default`='1'
14. SELECT `name`
      FROM `jos_core_acl_aro_groups`
      WHERE `id` =29
15. SELECT `lft`, `rgt`
      FROM `jos_core_acl_aro_groups`
      WHERE `name`='Public Frontend'
16. SELECT g1.id, g1.name, COUNT(g2.name) AS level
    
      FROM jos_core_acl_aro_groups AS g1
    
      INNER JOIN jos_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt
    
    
      GROUP BY g1.name
    
      ORDER BY g1.lft
17. SELECT `lft`, `rgt`
      FROM `jos_core_acl_aro_groups`
      WHERE `name`='Public Backend'
18. SELECT g1.id, g1.name, COUNT(g2.name) AS level
    
      FROM jos_core_acl_aro_groups AS g1
    
      INNER JOIN jos_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt
    
    
      GROUP BY g1.name
    
      ORDER BY g1.lft
19. SELECT vendor_id, vendor_min_pov,vendor_name,vendor_store_name,contact_email,vendor_full_image, vendor_freeshipping,
                                            vendor_address_1, 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
                                   
      FROM (`jos_vm_vendor`, `jos_vm_country`)
                                   
      WHERE `vendor_id`=1
                                   
      AND (vendor_country=country_2_code OR vendor_country=country_3_code);
20. SELECT category_id, category_description, category_name,category_child_id AS cid, category_parent_id AS pid,list_order, category_publish
                                                   
      FROM jos_vm_category, jos_vm_category_xref
      WHERE jos_vm_category.category_publish='Y'
      AND jos_vm_category.category_id=jos_vm_category_xref.category_child_id
      ORDER BY jos_vm_category.list_order ASC, jos_vm_category.category_name ASC
21. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_virtuemart'
      AND published=1
22. SELECT group_id,group_name,group_level
      FROM `jos_vm_auth_group`
      ORDER BY group_level
23. SELECT COUNT(user_id) AS num_rows
      FROM `jos_vm_user_info`
                                           
      WHERE jos_vm_user_info.user_id='0' 
                                           
      AND jos_vm_user_info.address_type='BT'
24. SELECT published
      FROM jos_modules
      WHERE module='mod_virtuemart_cart'
25. SELECT id
      FROM jos_menu
      WHERE link LIKE '%index.php?option=com_virtuemart%'
26. SELECT *
      FROM jos_vm_category_xref
      WHERE category_parent_id = 0
27. SELECT *
      FROM jos_vm_category
      WHERE category_id = 18
28. SELECT count(*)
      FROM jos_vm_product_category_xref
      WHERE category_id = 18
29. SELECT count(*)
      FROM jos_vm_category_xref
      WHERE category_parent_id = 18
30. SELECT category_child_id
      FROM jos_vm_category_xref
      WHERE category_parent_id = 18
31. SELECT *
      FROM jos_vm_product_category_xref
      WHERE category_id = 18
32. SELECT *
      FROM jos_vm_product
      WHERE product_id=27
33. SELECT *
      FROM jos_vm_category
      WHERE category_id = 19
34. SELECT count(*)
      FROM jos_vm_product_category_xref
      WHERE category_id = 19
35. SELECT count(*)
      FROM jos_vm_category_xref
      WHERE category_parent_id = 19
36. SELECT category_child_id
      FROM jos_vm_category_xref
      WHERE category_parent_id = 19
37. SELECT *
      FROM jos_vm_product_category_xref
      WHERE category_id = 19
38. SELECT *
      FROM jos_vm_product
      WHERE product_id=28
39. SELECT guest, usertype, client_id
      FROM jos_session
      WHERE client_id = 0
40. SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.name) THEN CONCAT_WS(":", cc.id, cc.name) ELSE cc.id END AS catslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      WHERE a.state = 1 
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (a.publish_up = "0000-00-00 00:00:00" OR a.publish_up <= "2010-03-10 13:02:00" ) 
      AND (a.publish_down = "0000-00-00 00:00:00" OR a.publish_down >= "2010-03-10 13:02:00" )
      AND cc.id = 34
      AND cc.section = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.ordering
41. SELECT DISTINCT product_sku
      FROM jos_vm_product, jos_vm_product_category_xref, jos_vm_category
      WHERE (jos_vm_product.product_parent_id='' OR jos_vm_product.product_parent_id='0')
      AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id
      AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id
      AND jos_vm_product.product_publish='Y'
      AND jos_vm_product.product_special='Y'
      ORDER BY product_name DESC
      LIMIT 1
42. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='HACKED'
43. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='27'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
44. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`
    
                           
      LEFT JOIN `jos_vm_product_category_xref`
      ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                           
      LEFT JOIN `jos_vm_category`
      ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`
    
                           
      WHERE `jos_vm_product`.`product_id`='27'
45. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=27
46. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='27'
      AND (start_date<='1268226120' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
47. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='27'
48. SELECT shopper_group_id,shopper_group_discount
      FROM jos_vm_shopper_group
      WHERE vendor_id='1'
      AND `default`='1'
49. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=27
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
50. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='27'
51. SELECT `tax_rate`
      FROM jos_vm_vendor, jos_vm_tax_rate
      WHERE tax_country=vendor_country
      AND jos_vm_vendor.vendor_id=1
      ORDER BY `tax_rate` DESC
52. SELECT DISTINCT product_sku
      FROM jos_vm_product, jos_vm_product_category_xref, jos_vm_category
      WHERE product_parent_id=''
      AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id
      AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id
      AND jos_vm_product.product_publish='Y'
      ORDER BY product_name DESC
53. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='HACKED'
54. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='27'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
55. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='27'
56. SELECT `tax_rate`
      FROM jos_vm_vendor, jos_vm_tax_rate
      WHERE tax_country=vendor_country
      AND jos_vm_vendor.vendor_id=1
      ORDER BY `tax_rate` DESC
57. SELECT jos_vm_product.product_id, product_parent_id,product_name, jos_vm_category.category_id, category_flypage
      FROM jos_vm_product, jos_vm_product_category_xref, jos_vm_category
      WHERE jos_vm_product.product_publish='Y'
      AND jos_vm_product_category_xref.product_id = jos_vm_product.product_id
      AND jos_vm_product_category_xref.category_id = jos_vm_category.category_id
      AND jos_vm_product.product_sales>0
      ORDER BY jos_vm_product.product_sales DESC
      LIMIT 0, 10
58. SELECT *
      FROM jos_vm_product, jos_vm_product_category_xref, jos_vm_category
      WHERE product_parent_id=''
      AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id
      AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id
      AND jos_vm_product.product_publish='Y'
      ORDER BY jos_vm_product.product_id DESC
      LIMIT 1
59. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='vamp'
60. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='28'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
61. SELECT
                                    `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                    `jos_vm_category`.`category_flypage`
                           
      FROM
                                    `jos_vm_product`
    
                           
      LEFT JOIN `jos_vm_product_category_xref`
      ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                           
      LEFT JOIN `jos_vm_category`
      ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`
    
                           
      WHERE `jos_vm_product`.`product_id`='28'
62. SELECT product_id, `jos_vm_product`.*
      FROM `jos_vm_product`
      WHERE `product_id`=28
63. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='28'
      AND (start_date<='1268226121' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
64. SELECT product_parent_id
      FROM jos_vm_product
      WHERE product_id=28
65. SELECT amount,is_percent
      FROM jos_vm_product,jos_vm_product_discount
      WHERE product_id='0'
      AND (start_date<='1268226121' OR start_date=0)
      AND (end_date>='1268195760' OR end_date=0)
      AND product_discount_id=discount_id
66. SELECT vendor_id
      FROM jos_vm_product
      WHERE product_id='28'
67. SELECT `product_price`, `product_price_id`, `product_currency`
      FROM `jos_vm_product_price`
      WHERE product_id=28
      AND shopper_group_id=5   
      ORDER BY price_quantity_start
68. SELECT product_weight, tax_rate
      FROM jos_vm_product, jos_vm_tax_rate
      WHERE product_tax_id=tax_rate_id
      AND product_id='28'
69. SELECT `tax_rate`
      FROM jos_vm_vendor, jos_vm_tax_rate
      WHERE tax_country=vendor_country
      AND jos_vm_vendor.vendor_id=1
      ORDER BY `tax_rate` DESC

•Language Files Loaded•

• /home/a5139363/public_html/online-shop/language/en-GB/en-GB.ini 1
• /home/a5139363/public_html/online-shop/language/en-GB/en-GB.plg_system_debug.ini 1
• /home/a5139363/public_html/online-shop/language/en-GB/en-GB.com_content.ini 1
• /home/a5139363/public_html/online-shop/language/en-GB/en-GB.tpl_beez.ini 1
• /home/a5139363/public_html/online-shop/language/en-GB/en-GB.mod_syndicate.ini 1
• /home/a5139363/public_html/online-shop/language/en-GB/en-GB.mod_virtuemart.ini
• /home/a5139363/public_html/online-shop/language/en-GB/en-GB.mod_virtuemart_cart.ini
• /home/a5139363/public_html/online-shop/language/en-GB/en-GB.mod_ice_vmcategories.ini
• /home/a5139363/public_html/online-shop/language/en-GB/en-GB.mod_whosonline.ini 1
• /home/a5139363/public_html/online-shop/language/en-GB/en-GB.mod_login.ini 1
• /home/a5139363/public_html/online-shop/language/en-GB/en-GB.mod_ice_accordion.ini

•Untranslated strings•

•None•