SELECT `session_id`

  FROM `test_session`

  WHERE `session_id` = 'f3673b7f57c9783a474323252f55c1ea' 
  LIMIT 0, 1

INSERT INTO `test_session`
(`session_id`, `client_id`, `time`) 
  VALUES 
('f3673b7f57c9783a474323252f55c1ea', 0, '1741958717')

SELECT b.id

  FROM test_usergroups AS a

  LEFT JOIN test_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 9

SELECT id, rules

  FROM `test_viewlevels`

SELECT element

  FROM test_extensions

  WHERE type = 'language' 
  AND client_id = 0 
  AND enabled = 1

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM test_menu AS m

  LEFT JOIN test_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft

SELECT `params` 
  FROM test_extensions 
  WHERE `element`='com_sh404sef' 
  AND `type`='component';

SELECT `id`,`alias`,`newurl`,`hits` 
  FROM `test_sh404sef_aliases` 
  WHERE `alias` = 'led-en/8-inch-single-big-digit-segment-display-bl-se800a-detail?print=1&tmpl=component' or `alias` = 'led-en/8-inch-single-big-digit-segment-display-bl-se800a-detail' or `alias` = 'led-en/8-inch-single-big-digit-segment-display-bl-se800a-detail/' 
  order by `alias` desc

SELECT * 
  FROM test_sh404sef_pageids 
  WHERE `pageid`='led-en/8-inch-single-big-digit-segment-display-bl-se800a-detail';

SELECT `oldurl`, `newurl`, `dateadd`, `id`, `cpt`, `rank` 
  FROM test_sh404sef_urls 
  WHERE `oldurl`='led-en/8-inch-single-big-digit-segment-display-bl-se800a-detail' 
  ORDER BY `rank`;

UPDATE `test_sh404sef_urls` 
  SET `cpt`=644 
  WHERE `id`='5173' 
  AND `rank`=0;

UPDATE `test_extensions`

  SET `params` = '{\"mediaversion\":\"f33c104c09369b31bd3bbf0ece890173\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

SELECT a.rules

  FROM test_assets AS a

  WHERE (a.id = 1)

  GROUP BY a.id, a.rules, a.lft

SELECT b.rules

  FROM test_assets AS a

  LEFT JOIN test_assets AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE (a.name = 'com_virtuemart')

  GROUP BY b.id, b.rules, b.lft

  ORDER BY b.lft

SHOW TABLES LIKE "test_virtuemart_configs"

SELECT `config` 
  FROM `test_virtuemart_configs` 
  WHERE `virtuemart_config_id` = "1";

SELECT * 
  FROM `test_virtuemart_shoppergroups` 
  WHERE `default` = "2" 
  AND (`virtuemart_vendor_id` = "1" OR `shared` = "1")  
  AND `published`="1"

SELECT `test_virtuemart_shoppergroups`.*  
  FROM `test_virtuemart_shoppergroups`  
  WHERE `test_virtuemart_shoppergroups`.`virtuemart_shoppergroup_id` = "1"

SELECT `test_virtuemart_products`.* ,`test_virtuemart_products_en_gb`.*  
  FROM `test_virtuemart_products` 
  INNER JOIN `test_virtuemart_products_en_gb` using (`virtuemart_product_id`) 
  WHERE `test_virtuemart_products`.`virtuemart_product_id` = "2537"

SELECT `virtuemart_media_id` 
  FROM `test_virtuemart_product_medias` 
  WHERE `virtuemart_product_id` = "2537" 
  ORDER BY `ordering`