SELECT TABLE_NAME, UPDATE_TIME FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'dddd' AND TABLE_NAME IN ('jos_vm_product', 'jos_menu', 'jos_content', 'jos_opensef_sef', 'jos_vm_category', 'jos_vm_category_xref', 'jos_vm_product_param_name', 'jos_vm_product_param_group', 'jos_vm_product_param_sub_group', 'jos_vm_product_category_xref', 'jos_vm_product_mf_xref', 'jos_vm_product_special_group', 'jos_vm_shipping_rate', 'jos_vm_coupons', 'jos_vm_manufacturer', 'jos_modules', 'jos_vm_custom_delivery_points', 'jos_vm_tax_rate', 'jos_vm_product_availability');
SELECT name, value FROM jos_opensef_config WHERE scope = 'com_sef' ORDER BY name ASC
SELECT * FROM jos_languages WHERE active = 1 AND iso <> '' ORDER BY ordering
SELECT *,'alias_sk' FROM jos_opensef_sef_component
SELECT alias FROM jos_opensef_sef_component WHERE published = 1 AND CONCAT('|',alias,'|') LIKE '%|components|%' LIMIT 1
SELECT alias FROM jos_opensef_sef_component WHERE published = 1 AND CONCAT('|',alias,'|') LIKE '%|components|%' LIMIT 1
SELECT template  FROM jos_templates_menu  WHERE client_id = 0  AND ( menuid = 0  )  ORDER BY menuid DESC  LIMIT 1
DELETE FROM jos_session  WHERE time < '1616537095'  AND guest = 1  AND gid = 0  AND userid <> 0
UPDATE jos_session  SET time = '1616580295'  WHERE session_id = '123'
SELECT COUNT( session_id )  FROM jos_session  WHERE session_id = '123'  AND username = 'user'  AND userid = 40
SELECT params FROM jos_users_quick_help WHERE user_id = 40 LIMIT 1
SELECT params FROM jos_users_quick_help WHERE user_id = 40 LIMIT 1
SELECT jos_users.gid FROM jos_users WHERE jos_users.id = 40 LIMIT 1
SELECT jos_users.gid FROM jos_users WHERE jos_users.id = 40 LIMIT 1
SELECT jos_components.id FROM jos_components WHERE jos_components.id = 140 LIMIT 1
SELECT *  FROM jos_users  WHERE id = '40'
SELECT DISTINCT special_group_id, product_tag, lang_list FROM jos_vm_product_special_group WHERE product_tag <> '';
SELECT shopper_group_id, shopper_group_name, shopper_group_discount FROM jos_vm_shopper_group ORDER BY shopper_group_id
SELECT vendor_id, vendor_min_pov,vendor_name,vendor_store_name,contact_email,vendor_full_image, vendor_freeshipping, 			vendor_address_1, vendor_address_2, vendor_city, vendor_state, vendor_country, country_2_code, country_3_code, 			vendor_zip, vendor_phone, vendor_store_desc, vendor_currency 		FROM (`jos_vm_vendor`, `jos_vm_country`) 		WHERE `vendor_id`=1 		AND (vendor_country=country_2_code OR vendor_country=country_3_code);
SELECT * FROM jos_users WHERE id = '40' LIMIT 1;
SELECT ui.*, sg.shopper_group_id, sg.shopper_group_name, sg.show_price_including_tax,  sg.shopper_group_discount, sg.default AS default_shopper_group, c.country_name, c.country_id, c.country_2_code, c.country_3_code, c.country_freeshipping FROM jos_vm_user_info AS ui 			LEFT JOIN jos_vm_shopper_vendor_xref AS svx ON svx.user_id = ui.user_id 			LEFT JOIN jos_vm_shopper_group AS sg ON sg.shopper_group_id = svx.shopper_group_id 			LEFT JOIN jos_vm_country AS c ON c.country_3_code = ui.country 			WHERE ui.user_id = '240' AND ui.address_type = 'BT'  LIMIT 1;
SELECT currency_display_style	FROM `jos_vm_currency`	WHERE `currency_id`='EUR' OR `currency_code`='EUR';
SELECT a.*, b.currency_rate_choice FROM jos_vm_currency AS a LEFT JOIN jos_vm_vendor AS b ON a.currency_code = b.vendor_currency WHERE b.vendor_id > 0 LIMIT 1
SELECT currency_code, currency_display_style FROM jos_vm_currency WHERE currency_code="EUR" OR currency_code="EUR"
SELECT jos_vm_shopper_group.shopper_group_id, shopper_group_name, show_price_including_tax, `default`, shopper_group_discount FROM `jos_vm_shopper_group`,`jos_vm_shopper_vendor_xref` WHERE jos_vm_shopper_vendor_xref.user_id='240' AND jos_vm_shopper_group.shopper_group_id=jos_vm_shopper_vendor_xref.shopper_group_id
SELECT g1.group_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.group_id, g1.name ORDER BY g1.lft
SELECT `lft`, `rgt` FROM jos_core_acl_aro_groups WHERE `name`='Public Backend'
SELECT g1.group_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 WHERE g1.lft BETWEEN 13 AND 20 GROUP BY g1.group_id, g1.name ORDER BY g1.lft
SELECT jos_users.id, jos_vm_user_info.user_id from jos_users, jos_vm_user_info  					WHERE jos_users.id='240' AND jos_users.id=jos_vm_user_info.user_id  					AND jos_vm_user_info.address_type='BT' AND jos_vm_user_info.first_name != ''  					AND jos_vm_user_info.last_name != ''
SELECT perms, first_name, last_name, country, zip FROM jos_vm_user_info WHERE user_id = 240 AND address_type = 'BT'
SELECT module_perms FROM jos_vm_module where module_name='store'
SELECT id,iso,image FROM jos_languages WHERE code LIKE 'slovak-utf'
SELECT jos_components.id FROM jos_components WHERE jos_components.id = 1030 LIMIT 1
SHOW COLUMNS FROM jos_vm_product
SHOW COLUMNS FROM jos_vm_product
CREATE TABLE IF NOT EXISTS `jos_temp` ( `id` int(11) NOT NULL auto_increment,`f01` text character set utf8,`f02` text character set utf8,`f03` text character set utf8,`f04` text character set utf8,`f05` text character set utf8,`f06` text character set utf8,`f07` text character set utf8,`f08` text character set utf8,`f09` text character set utf8,`f10` text character set utf8,`f11` text character set utf8,`f12` text character set utf8,`f13` text character set utf8,`f14` text character set utf8,`f15` text character set utf8,`f16` text character set utf8,`f17` text character set utf8,`f18` text character set utf8,`f19` text character set utf8,`f20` text character set utf8,`f21` text character set utf8,`f22` text character set utf8,`f23` text character set utf8,`f24` text character set utf8,`f25` text character set utf8,`f26` text character set utf8,`f27` text character set utf8,`f28` text character set utf8,`f29` text character set utf8,`f30` text character set utf8,`f31` text character set utf8,`f32` text character set utf8,`f33` text character set utf8,`f34` text character set utf8,`f35` text character set utf8,`f36` text character set utf8,`f37` text character set utf8,`f38` text character set utf8,`f39` text character set utf8,`f40` text character set utf8,`f41` text character set utf8,`f42` text character set utf8,`f43` text character set utf8,`f44` text character set utf8,`f45` text character set utf8,`f46` text character set utf8,`f47` text character set utf8,`f48` text character set utf8,`f49` text character set utf8,`f50` text character set utf8, PRIMARY KEY (`id`) ) DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
LOAD DATA LOCAL INFILE '/some_path/CSV rigum vane 1111.csv' INTO TABLE jos_temp 		      CHARACTER SET cp1250 		      FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"' 		      LINES TERMINATED BY ' ' 		      (f01,f02,f03,f04,f05,f06,f07,f08,f09,f10,f11,f12,f13,f14,f15,f16,f17,f18,f19,f20,f21,f22,f23,f24,f25,f26,f27,f28,f29,f30,f31,f32,f33,f34,f35,f36,f37,f38,f39,f40,f41,f42,f43,f44,f45,f46,f47,f48,f49,f50);
