easylessons.co.uk

Profile Information

Memory Usage

82 queries logged

1. SELECT *
     FROM jos_session
     WHERE session_id = '2bquttaa40fdhoeckjeskjqfm1'
2. DELETE
     FROM jos_session
     WHERE ( TIME < '1786446214' )
3. SELECT *
     FROM jos_session
     WHERE session_id = '2bquttaa40fdhoeckjeskjqfm1'
4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
     VALUES ( '2bquttaa40fdhoeckjeskjqfm1','1786447114','','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 = 1)
     ORDER BY menuid DESC
     LIMIT 0, 1
9. SELECT a.id, a.title, a.alias, 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, u.email AS author_email, 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 <= '2026-08-11 11:18:34' )
     AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-08-11 11:18:34' )
     ORDER BY  f.ordering
10. SELECT a.id, a.title, a.alias, 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, u.email AS author_email, 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 <= '2026-08-11 11:18:34' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-08-11 11:18:34' )
      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 = 1 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 COUNT(jos_vm_product.product_id) AS num_rows
      FROM jos_vm_product,jos_vm_product_category_xref, jos_vm_category
      WHERE jos_vm_product_category_xref.category_id='11'
      AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id
      AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id  
      AND product_publish='Y'
23. SELECT COUNT(jos_vm_product.product_id) AS num_rows
      FROM jos_vm_product,jos_vm_product_category_xref, jos_vm_category
      WHERE jos_vm_product_category_xref.category_id='12'
      AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id
      AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id  
      AND product_publish='Y'
24. SELECT COUNT(jos_vm_product.product_id) AS num_rows
      FROM jos_vm_product,jos_vm_product_category_xref, jos_vm_category
      WHERE jos_vm_product_category_xref.category_id='42'
      AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id
      AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id  
      AND product_publish='Y'
25. SELECT category_child_id
      FROM jos_vm_category_xref
      WHERE category_parent_id='42'
26. SELECT COUNT(jos_vm_product.product_id) AS num_rows
      FROM jos_vm_product,jos_vm_product_category_xref, jos_vm_category
      WHERE jos_vm_product_category_xref.category_id='39'
      AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id
      AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id  
      AND product_publish='Y'
27. SELECT COUNT(jos_vm_product.product_id) AS num_rows
      FROM jos_vm_product,jos_vm_product_category_xref, jos_vm_category
      WHERE jos_vm_product_category_xref.category_id='38'
      AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id
      AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id  
      AND product_publish='Y'
28. SELECT COUNT(jos_vm_product.product_id) AS num_rows
      FROM jos_vm_product,jos_vm_product_category_xref, jos_vm_category
      WHERE jos_vm_product_category_xref.category_id='37'
      AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id
      AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id  
      AND product_publish='Y'
29. SELECT COUNT(jos_vm_product.product_id) AS num_rows
      FROM jos_vm_product,jos_vm_product_category_xref, jos_vm_category
      WHERE jos_vm_product_category_xref.category_id='36'
      AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id
      AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id  
      AND product_publish='Y'
30. SELECT COUNT(jos_vm_product.product_id) AS num_rows
      FROM jos_vm_product,jos_vm_product_category_xref, jos_vm_category
      WHERE jos_vm_product_category_xref.category_id='35'
      AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id
      AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id  
      AND product_publish='Y'
31. SELECT a.*,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, 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, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
      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 <= '2026-08-11 11:18:34' )  
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-08-11 11:18:34' )
     
      AND cc.id=36
      AND cc.SECTION = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.created DESC
      LIMIT 0, 2
32. SELECT a.*,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, 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, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
      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 <= '2026-08-11 11:18:34' )  
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-08-11 11:18:34' )
     
      AND cc.id=38
      AND cc.SECTION = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.created DESC
      LIMIT 0, 2
33. SELECT a.*,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, 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, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
      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 <= '2026-08-11 11:18:34' )  
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-08-11 11:18:34' )
     
      AND cc.id=39
      AND cc.SECTION = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.created DESC
      LIMIT 0, 2
34. SELECT a.*,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, 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, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
      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 <= '2026-08-11 11:18:34' )  
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-08-11 11:18:34' )
     
      AND cc.id=40
      AND cc.SECTION = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.created DESC
      LIMIT 0, 2
35. SELECT category_thumb_image
      FROM jos_vm_category
      WHERE category_id=11
36. SELECT category_thumb_image
      FROM jos_vm_category
      WHERE category_id=11
37. SELECT category_thumb_image
      FROM jos_vm_category
      WHERE category_id=12
38. SELECT category_thumb_image
      FROM jos_vm_category
      WHERE category_id=12
39. SELECT category_thumb_image
      FROM jos_vm_category
      WHERE category_id=42
40. SELECT category_thumb_image
      FROM jos_vm_category
      WHERE category_id=42
41. SELECT category_child_id
      FROM jos_vm_category_xref
      WHERE category_parent_id='42'
42. SELECT category_thumb_image
      FROM jos_vm_category
      WHERE category_id=39
43. SELECT category_thumb_image
      FROM jos_vm_category
      WHERE category_id=39
44. SELECT category_thumb_image
      FROM jos_vm_category
      WHERE category_id=38
45. SELECT category_thumb_image
      FROM jos_vm_category
      WHERE category_id=38
46. SELECT category_thumb_image
      FROM jos_vm_category
      WHERE category_id=37
47. SELECT category_thumb_image
      FROM jos_vm_category
      WHERE category_id=37
48. SELECT category_thumb_image
      FROM jos_vm_category
      WHERE category_id=36
49. SELECT category_thumb_image
      FROM jos_vm_category
      WHERE category_id=36
50. SELECT category_thumb_image
      FROM jos_vm_category
      WHERE category_id=35
51. SELECT category_thumb_image
      FROM jos_vm_category
      WHERE category_id=35
52. SELECT DISTINCT product_sku
      FROM jos_vm_product
      WHERE (jos_vm_product.product_parent_id='' OR jos_vm_product.product_parent_id='0')
      AND vendor_id='1'
      AND jos_vm_product.product_publish='Y'
      AND jos_vm_product.product_special='Y'
      ORDER BY RAND()
      LIMIT 0, 8
53. SELECT COUNT(DISTINCT(p.product_sku))
      FROM `jos_vm_product` p
      INNER JOIN `jos_vm_product_category_xref` cf  
      ON  cf.product_id = p.product_id  
      INNER JOIN `jos_vm_category` c  
      ON  cf.category_id = c.category_id  
      WHERE p.product_parent_id=""
      AND p.product_publish="Y"  
      AND c.category_publish="Y"
54. SELECT DISTINCT(p.product_sku)
      FROM `jos_vm_product` p
      INNER JOIN `jos_vm_product_category_xref` cf  
      ON  cf.product_id = p.product_id  
      INNER JOIN `jos_vm_category` c  
      ON  cf.category_id = c.category_id  
      WHERE p.product_parent_id=""
      AND p.product_publish="Y"  
      AND c.category_publish="Y"
      ORDER BY p.cdate DESC
55. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='003875649'
56. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='123'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
57. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='12345892'
58. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='122'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
59. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='008976543'
60. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='121'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
61. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='002456381'
62. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='114'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
63. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='0023461'
64. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='112'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
65. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='001238973'
66. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='109'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
67. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='0026578'
68. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='107'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
69. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='00031'
70. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='98'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
71. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='00022'
72. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='97'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
73. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='0000111'
74. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='93'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
75. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='0006'
76. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='87'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
77. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='0005'
78. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='86'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
79. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='0004'
80. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='83'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
81. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='0002'
82. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='75'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id

82 legacy queries logged

1. SELECT *
     FROM jos_session
     WHERE session_id = '2bquttaa40fdhoeckjeskjqfm1'
2. DELETE
     FROM jos_session
     WHERE ( TIME < '1786446214' )
3. SELECT *
     FROM jos_session
     WHERE session_id = '2bquttaa40fdhoeckjeskjqfm1'
4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
     VALUES ( '2bquttaa40fdhoeckjeskjqfm1','1786447114','','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 = 1)
     ORDER BY menuid DESC
     LIMIT 0, 1
9. SELECT a.id, a.title, a.alias, 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, u.email AS author_email, 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 <= '2026-08-11 11:18:34' )
     AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-08-11 11:18:34' )
     ORDER BY  f.ordering
10. SELECT a.id, a.title, a.alias, 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, u.email AS author_email, 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 <= '2026-08-11 11:18:34' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-08-11 11:18:34' )
      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 = 1 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 COUNT(jos_vm_product.product_id) AS num_rows
      FROM jos_vm_product,jos_vm_product_category_xref, jos_vm_category
      WHERE jos_vm_product_category_xref.category_id='11'
      AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id
      AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id  
      AND product_publish='Y'
23. SELECT COUNT(jos_vm_product.product_id) AS num_rows
      FROM jos_vm_product,jos_vm_product_category_xref, jos_vm_category
      WHERE jos_vm_product_category_xref.category_id='12'
      AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id
      AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id  
      AND product_publish='Y'
24. SELECT COUNT(jos_vm_product.product_id) AS num_rows
      FROM jos_vm_product,jos_vm_product_category_xref, jos_vm_category
      WHERE jos_vm_product_category_xref.category_id='42'
      AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id
      AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id  
      AND product_publish='Y'
25. SELECT category_child_id
      FROM jos_vm_category_xref
      WHERE category_parent_id='42'
26. SELECT COUNT(jos_vm_product.product_id) AS num_rows
      FROM jos_vm_product,jos_vm_product_category_xref, jos_vm_category
      WHERE jos_vm_product_category_xref.category_id='39'
      AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id
      AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id  
      AND product_publish='Y'
27. SELECT COUNT(jos_vm_product.product_id) AS num_rows
      FROM jos_vm_product,jos_vm_product_category_xref, jos_vm_category
      WHERE jos_vm_product_category_xref.category_id='38'
      AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id
      AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id  
      AND product_publish='Y'
28. SELECT COUNT(jos_vm_product.product_id) AS num_rows
      FROM jos_vm_product,jos_vm_product_category_xref, jos_vm_category
      WHERE jos_vm_product_category_xref.category_id='37'
      AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id
      AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id  
      AND product_publish='Y'
29. SELECT COUNT(jos_vm_product.product_id) AS num_rows
      FROM jos_vm_product,jos_vm_product_category_xref, jos_vm_category
      WHERE jos_vm_product_category_xref.category_id='36'
      AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id
      AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id  
      AND product_publish='Y'
30. SELECT COUNT(jos_vm_product.product_id) AS num_rows
      FROM jos_vm_product,jos_vm_product_category_xref, jos_vm_category
      WHERE jos_vm_product_category_xref.category_id='35'
      AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id
      AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id  
      AND product_publish='Y'
31. SELECT a.*,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, 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, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
      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 <= '2026-08-11 11:18:34' )  
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-08-11 11:18:34' )
     
      AND cc.id=36
      AND cc.SECTION = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.created DESC
      LIMIT 0, 2
32. SELECT a.*,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, 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, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
      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 <= '2026-08-11 11:18:34' )  
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-08-11 11:18:34' )
     
      AND cc.id=38
      AND cc.SECTION = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.created DESC
      LIMIT 0, 2
33. SELECT a.*,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, 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, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
      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 <= '2026-08-11 11:18:34' )  
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-08-11 11:18:34' )
     
      AND cc.id=39
      AND cc.SECTION = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.created DESC
      LIMIT 0, 2
34. SELECT a.*,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, 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, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
      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 <= '2026-08-11 11:18:34' )  
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-08-11 11:18:34' )
     
      AND cc.id=40
      AND cc.SECTION = s.id
      AND cc.published = 1
      AND s.published = 1
      ORDER BY a.created DESC
      LIMIT 0, 2
35. SELECT category_thumb_image
      FROM jos_vm_category
      WHERE category_id=11
36. SELECT category_thumb_image
      FROM jos_vm_category
      WHERE category_id=11
37. SELECT category_thumb_image
      FROM jos_vm_category
      WHERE category_id=12
38. SELECT category_thumb_image
      FROM jos_vm_category
      WHERE category_id=12
39. SELECT category_thumb_image
      FROM jos_vm_category
      WHERE category_id=42
40. SELECT category_thumb_image
      FROM jos_vm_category
      WHERE category_id=42
41. SELECT category_child_id
      FROM jos_vm_category_xref
      WHERE category_parent_id='42'
42. SELECT category_thumb_image
      FROM jos_vm_category
      WHERE category_id=39
43. SELECT category_thumb_image
      FROM jos_vm_category
      WHERE category_id=39
44. SELECT category_thumb_image
      FROM jos_vm_category
      WHERE category_id=38
45. SELECT category_thumb_image
      FROM jos_vm_category
      WHERE category_id=38
46. SELECT category_thumb_image
      FROM jos_vm_category
      WHERE category_id=37
47. SELECT category_thumb_image
      FROM jos_vm_category
      WHERE category_id=37
48. SELECT category_thumb_image
      FROM jos_vm_category
      WHERE category_id=36
49. SELECT category_thumb_image
      FROM jos_vm_category
      WHERE category_id=36
50. SELECT category_thumb_image
      FROM jos_vm_category
      WHERE category_id=35
51. SELECT category_thumb_image
      FROM jos_vm_category
      WHERE category_id=35
52. SELECT DISTINCT product_sku
      FROM jos_vm_product
      WHERE (jos_vm_product.product_parent_id='' OR jos_vm_product.product_parent_id='0')
      AND vendor_id='1'
      AND jos_vm_product.product_publish='Y'
      AND jos_vm_product.product_special='Y'
      ORDER BY RAND()
      LIMIT 0, 8
53. SELECT COUNT(DISTINCT(p.product_sku))
      FROM `jos_vm_product` p
      INNER JOIN `jos_vm_product_category_xref` cf  
      ON  cf.product_id = p.product_id  
      INNER JOIN `jos_vm_category` c  
      ON  cf.category_id = c.category_id  
      WHERE p.product_parent_id=""
      AND p.product_publish="Y"  
      AND c.category_publish="Y"
54. SELECT DISTINCT(p.product_sku)
      FROM `jos_vm_product` p
      INNER JOIN `jos_vm_product_category_xref` cf  
      ON  cf.product_id = p.product_id  
      INNER JOIN `jos_vm_category` c  
      ON  cf.category_id = c.category_id  
      WHERE p.product_parent_id=""
      AND p.product_publish="Y"  
      AND c.category_publish="Y"
      ORDER BY p.cdate DESC
55. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='003875649'
56. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='123'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
57. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='12345892'
58. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='122'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
59. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='008976543'
60. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='121'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
61. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='002456381'
62. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='114'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
63. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='0023461'
64. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='112'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
65. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='001238973'
66. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='109'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
67. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='0026578'
68. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='107'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
69. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='00031'
70. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='98'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
71. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='00022'
72. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='97'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
73. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='0000111'
74. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='93'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
75. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='0006'
76. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='87'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
77. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='0005'
78. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='86'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
79. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='0004'
80. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='83'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
81. SELECT product_id, product_name, product_parent_id, product_thumb_image
      FROM jos_vm_product
      WHERE product_sku='0002'
82. SELECT jos_vm_category.category_id
      FROM jos_vm_category,jos_vm_product_category_xref
      WHERE product_id='75'
      AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id

Language Files Loaded

• /home/davidg/public_html/language/en-GB/en-GB.ini 1
• /home/davidg/public_html/language/en-GB/en-GB.plg_system_debug.ini 1
• /home/davidg/public_html/language/en-GB/en-GB.com_content.ini 1
• /home/davidg/public_html/language/en-GB/en-GB.tpl_ja_mesolite.ini 1
• /home/davidg/public_html/language/en-GB/en-GB.mod_footer.ini 1
• /home/davidg/public_html/language/en-GB/en-GB.mod_mainmenu.ini 1
• /home/davidg/public_html/language/en-GB/en-GB.mod_product_categories.ini
• /home/davidg/public_html/language/en-GB/en-GB.mod_janews.ini
• /home/davidg/public_html/language/en-GB/en-GB.mod_frontpage_categories.ini
• /home/davidg/public_html/language/en-GB/en-GB.mod_virtuemart_featureprod.ini
• /home/davidg/public_html/language/en-GB/en-GB.mod_ja_vmproductslide.ini
• /home/davidg/public_html/language/en-GB/en-GB.mod_virtuemart_search.ini
• /home/davidg/public_html/language/en-GB/en-GB.mod_S5tellafriend.ini

Untranslated Strings Diagnostic

None

Untranslated Strings Designer

None