SELECT `session_id`

  FROM `test_session`

  WHERE `session_id` = '02d6b1087461f7754fba56b132ebf12e' 
  LIMIT 0, 1

INSERT INTO `test_session`
(`session_id`, `client_id`, `time`) 
  VALUES 
('02d6b1087461f7754fba56b132ebf12e', 0, '1741980761')

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/5-inch-single-big-digit-segment-display-bl-se500a-detail' 
  order by `alias` desc

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

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

UPDATE `test_sh404sef_urls` 
  SET `cpt`=509 
  WHERE `id`='46448' 
  AND `rank`=0;

UPDATE `test_extensions`

  SET `params` = '{\"mediaversion\":\"91946124a8a978e58e3aacc0cf500245\"}'

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