SELECT `session_id`

  FROM `test_session`

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

INSERT INTO `test_session`
(`session_id`, `client_id`, `time`) 
  VALUES 
('d91d131f3d9a1b1c9ffdc61f36c9cc4e', 0, '1742366795')

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/arrow-display-30x56mm-bl-at5z3056-detail?print=1&tmpl=component' or `alias` = 'led-en/arrow-display-30x56mm-bl-at5z3056-detail' or `alias` = 'led-en/arrow-display-30x56mm-bl-at5z3056-detail/' 
  order by `alias` desc

SELECT * 
  FROM test_sh404sef_pageids 
  WHERE `pageid`='led-en/arrow-display-30x56mm-bl-at5z3056-detail';

SELECT `oldurl`, `newurl`, `dateadd`, `id`, `cpt`, `rank` 
  FROM test_sh404sef_urls 
  WHERE `oldurl`='led-en/arrow-display-30x56mm-bl-at5z3056-detail' 
  ORDER BY `rank`;

UPDATE `test_sh404sef_urls` 
  SET `cpt`=484 
  WHERE `id`='74403' 
  AND `rank`=0;

UPDATE `test_extensions`

  SET `params` = '{\"mediaversion\":\"6b5b474fe24e73540777869914e348fb\"}'

  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` = "2030"

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

SELECT `virtuemart_shoppergroup_id` 
  FROM `test_virtuemart_product_shoppergroups` 
  WHERE `virtuemart_product_id` = "2030"

SELECT * 
  FROM `test_virtuemart_product_prices` 
  WHERE `virtuemart_product_id` = "2030"  
  AND ( `virtuemart_shoppergroup_id` ="1" OR  `virtuemart_shoppergroup_id` IS NULL OR `virtuemart_shoppergroup_id`="0")  
  AND ( (`product_price_publish_up` IS NULL OR `product_price_publish_up` = "0000-00-00 00:00:00" OR `product_price_publish_up` <= "2025-03-19 06:46:35" )
		        
  AND (`product_price_publish_down` IS NULL OR `product_price_publish_down` = "0000-00-00 00:00:00" OR product_price_publish_down >= "2025-03-19 06:46:35" ) ) 
  ORDER BY `product_price` DESC

SELECT `virtuemart_manufacturer_id` 
  FROM `test_virtuemart_product_manufacturers` 
  WHERE `virtuemart_product_id` = "2030"