SHOW TABLES LIKE 'tbl_migration%'

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Password Recovery' LIMIT 1

SELECT name,value FROM `property` `t` WHERE `t`.`category`='settings' AND `t`.`subcategory`='user' AND (modified IS NOT NULL)

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Submit' LIMIT 1

SHOW FULL COLUMNS FROM `property`

SHOW FULL COLUMNS FROM `authitem`

SHOW TABLES

SHOW FULL COLUMNS FROM `message_categories`

SHOW FULL COLUMNS FROM `user`

SELECT name,value FROM `property` `t` WHERE `t`.`category`='settings' AND `t`.`subcategory`='calibration' AND (modified IS NOT NULL)

SHOW FULL COLUMNS FROM `tbl_migration`

SELECT `version`, `apply_time`
FROM `tbl_migration`
ORDER BY `version` DESC

SELECT name,value FROM `property` `t` WHERE `t`.`category`='settings' AND `t`.`subcategory`='migration' AND (modified IS NOT NULL)

SHOW FULL COLUMNS FROM `languages`

SHOW FULL COLUMNS FROM `messages`

SELECT name,value FROM `property` `t` WHERE `t`.`category`='settings' AND `t`.`subcategory`='file_store' AND (modified IS NOT NULL)

SHOW TABLES LIKE 'property%'

SELECT name,value FROM `property` `t` WHERE `t`.`category`='settings' AND `t`.`subcategory`='translation' AND (modified IS NOT NULL)

SELECT name,value FROM `property` `t` WHERE `t`.`category`='settings' AND `t`.`subcategory`='customer' AND (modified IS NOT NULL)

DELETE FROM `log` WHERE 0=1

SELECT * FROM `authitem` `t` WHERE `t`.`name`='QR_Code_Role' AND `t`.`type`=2 AND `t`.`portal_enable`=1 AND (portal_start_address IS NOT NULL AND portal_start_address <> '') LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '32' AND BINARY message_from = 'ID' LIMIT 1

SHOW CREATE TABLE `messages`

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Please enter the letters as they are shown in the image above.' LIMIT 1

SHOW CREATE TABLE `property`

SHOW CREATE TABLE `message_categories`

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Inactive' LIMIT 1

SELECT * FROM `authitem` `t` WHERE `t`.`name`='QR_Code_Role' AND `t`.`type`=2 AND `t`.`qrlink_enable`=1 AND (qrlink_address IS NOT NULL AND qrlink_address <> '') LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '32' AND BINARY message_from = 'First name' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Name cannot be blank.' LIMIT 1

SELECT * FROM `message_categories` `t`

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Unique Index' LIMIT 1

SHOW CREATE TABLE `authitem`

SHOW CREATE TABLE `user`

SHOW CREATE TABLE `tbl_migration`

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Primary Key' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '32' AND BINARY message_from = 'Phone' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Pending' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Choose date' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Refreshing' LIMIT 1

SELECT COUNT(*) FROM tbl_migration WHERE `version` = 'm250606_023205_add_qrlink_for_public'

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '32' AND BINARY message_from = 'Last name' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE `t`.`message_from`='Location' AND `t`.`language_code`='de' AND `t`.`category_id`='7' ORDER BY secure DESC LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '32' AND BINARY message_from = 'Reminder Change Password' LIMIT 1

SHOW CREATE TABLE `languages`

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Please choose date' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Select Page' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Next 7 Days' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Please enter a number smaller than 1000' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Approved' LIMIT 1

SELECT * FROM `user` `t` WHERE `t`.`uID` IS NULL LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '7' AND BINARY message_from = 'State' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Edit Actual Filter' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Index' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Edit Advanced Filter' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Signature Details' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '32' AND BINARY message_from = 'Current Password' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Expand' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Stop' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Columns' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Sign in' LIMIT 1

SELECT COUNT(*) FROM tbl_migration WHERE `version` = 'm240320_082359_add_new_fields_for_qrcode_role'

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'You have to accept terms of use' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '32' AND BINARY message_from = 'Firm' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '32' AND BINARY message_from = 'Password' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '7' AND BINARY message_from = 'Street' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '32' AND BINARY message_from = 'Default Page Size' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE `t`.`message_from`='Stop' AND `t`.`language_code`='de' ORDER BY secure DESC LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Please wait' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '32' AND BINARY message_from = 'API Key' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '32' AND BINARY message_from = 'Email' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Next Month' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Custom' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '32' AND BINARY message_from = 'Avatar' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '32' AND BINARY message_from = 'Role' LIMIT 1

SELECT COUNT(uID) FROM user WHERE uID = '' AND FIND_IN_SET('hidden_super_admin', `role`) > 0

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '17' AND BINARY message_from = 'Sorry, there was an error with your request.' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Clear' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE `t`.`message_from`='Standard Download Folder' AND `t`.`language_code`='de' ORDER BY secure DESC LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Use * for any number of characters, and ? for a single character<br>Example: Fluke* (starts with Fluke), *179 (ends with 179), Flu?e (one character between Flu and e).' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '7' AND BINARY message_from = 'Country' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Yesterday' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Copied' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '32' AND BINARY message_from = 'Signature' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Letters are not case-sensitive.' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '17' AND BINARY message_from = 'ACTIVE' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '17' AND BINARY message_from = 'INACTIVE' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Last 30 Days' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Deployed. Preparing Refresh ...' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Empty' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Already have an account?' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Today' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'ALL' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '7' AND BINARY message_from = 'Location' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '32' AND BINARY message_from = 'Follow Support Email' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '7' AND BINARY message_from = 'Zip' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Apply' LIMIT 1

SELECT DISTINCT(`child`), au.itemname, item.group_uID
FROM authitemchild AS ac
LEFT JOIN authassignment AS au ON ac.parent=au.itemname
LEFT JOIN authitem AS item ON item.name=ac.child AND item.type = 0
WHERE userid=NULL AND au.itemname <> 'QR_Code_Role'

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '17' AND BINARY message_from = 'DELETED' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Add Actual Filter' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Tomorrow' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Collapse' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '32' AND BINARY message_from = 'Create date' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Version {v}' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '32' AND BINARY message_from = 'Active' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '7' AND BINARY message_from = 'Name' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '32' AND BINARY message_from = 'Username (MET/TEAM)' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Yes' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Search booking' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Search customer' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Search inventory' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Don\'t have an account?' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '7' AND BINARY message_from = 'Contact' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Dashboard Name cannot be blank.' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '32' AND BINARY message_from = 'Standard Download Folder' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Next 30 Days' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '17' AND BINARY message_from = 'setting-inventory-condition' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'This Month' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '17' AND BINARY message_from = 'setting-inventory-customer' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Search calibration' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Last 7 Days' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '32' AND BINARY message_from = 'New Password' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Add Advanced Filter' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Last Month' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Self-Signed Cert' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '7' AND BINARY message_from = 'Label' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '32' AND BINARY message_from = 'Repeat Password' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '32' AND BINARY message_from = 'Certificate Info' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '7' AND BINARY message_from = 'Fax' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '7' AND BINARY message_from = 'Type' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'No' LIMIT 1

SELECT message_to, tooltip FROM `messages` `t` WHERE language_code = 'de' AND category_id = '1' AND BINARY message_from = 'Register' LIMIT 1