INSERT INTO `test_session`
(`session_id`, `client_id`, `time`) 
  VALUES 
('68978adce23ab5d72bb32bfccca2f0ab', 0, '1732805596')

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/dot-matrix-led/5x9-dot-matrix/1.2-inch-5x9-dot-matrix/1.2-inch-height-5x9-led-dot-matrix-bl-m12a591bl-m12b591-detail' 
  order by `alias` desc

SELECT * 
  FROM test_sh404sef_pageids 
  WHERE `pageid`='led-en/dot-matrix-led/5x9-dot-matrix/1.2-inch-5x9-dot-matrix/1.2-inch-height-5x9-led-dot-matrix-bl-m12a591bl-m12b591-detail';

SELECT `oldurl`, `newurl`, `dateadd`, `id`, `cpt`, `rank` 
  FROM test_sh404sef_urls 
  WHERE `oldurl`='led-en/dot-matrix-led/5x9-dot-matrix/1.2-inch-5x9-dot-matrix/1.2-inch-height-5x9-led-dot-matrix-bl-m12a591bl-m12b591-detail' 
  ORDER BY `rank`;

UPDATE `test_sh404sef_urls` 
  SET `cpt`=736 
  WHERE `id`='18170' 
  AND `rank`=0;

UPDATE `test_extensions`

  SET `params` = '{\"mediaversion\":\"53641c590ed23071e8881ef7816e1e7d\"}'

  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