Autore: deeterd

SELECT option_value 
FROM itr_options 
WHERE option_name = 'uninstall_plugins' 
LIMIT 1

SHOW TABLES LIKE 'sib_model_users'

SHOW TABLES LIKE 'sib_model_forms'

SHOW TABLES LIKE 'sib_model_forms'

CREATE TABLE IF NOT EXISTS itr_sib_model_forms ( `id` int(20) NOT NULL AUTO_INCREMENT, `title` varchar(120) CHARACTER 
SET utf8 COLLATE utf8_unicode_ci, `html` longtext CHARACTER 
SET utf8 COLLATE utf8_unicode_ci, `css` longtext, `dependTheme` int(1) NOT NULL DEFAULT 1, `listID` longtext, `templateID` int(20) NOT NULL DEFAULT -1, `confirmID` int(20) NOT NULL DEFAULT -1, `isDopt` int(1) NOT NULL DEFAULT 0, `isOpt` int(1) NOT NULL DEFAULT 0, `redirectInEmail` varchar(255), `redirectInForm` varchar(255), `successMsg` varchar(255) CHARACTER 
SET utf8 COLLATE utf8_unicode_ci, `errorMsg` varchar(255) CHARACTER 
SET utf8 COLLATE utf8_unicode_ci, `existMsg` varchar(255) CHARACTER 
SET utf8 COLLATE utf8_unicode_ci, `invalidMsg` varchar(255) CHARACTER 
SET utf8 COLLATE utf8_unicode_ci, `requiredMsg` varchar(255) CHARACTER 
SET utf8 COLLATE utf8_unicode_ci, `attributes` TEXT CHARACTER 
SET utf8 COLLATE utf8_unicode_ci, `date` DATE NOT NULL, `isDefault` int(1) NOT NULL DEFAULT 0, `gCaptcha` int(1) NOT NULL DEFAULT 0, `gCaptcha_secret` varchar(255) CHARACTER 
SET utf8 COLLATE utf8_unicode_ci, `gCaptcha_site` varchar(255) CHARACTER 
SET utf8 COLLATE utf8_unicode_ci, `termAccept` int(1) NOT NULL DEFAULT 0, `termsURL` varchar(255) CHARACTER 
SET utf8 COLLATE utf8_unicode_ci, PRIMARY KEY (`id`) );

SELECT * 
FROM itr_sib_model_forms

CREATE TABLE IF NOT EXISTS itr_sib_model_users ( `id` int(20) NOT NULL AUTO_INCREMENT, `email` varchar(255), `code` varchar(100), `listIDs` longtext, `redirectUrl` varchar(255), `info` TEXT CHARACTER 
SET utf8 COLLATE utf8_unicode_ci, `frmid` int(2), PRIMARY KEY (`id`) );

SHOW COLUMNS 
FROM `itr_sib_model_forms` LIKE 'gCaptcha'

SHOW COLUMNS 
FROM `itr_sib_model_forms` LIKE 'termAccept';

SHOW COLUMNS 
FROM `itr_sib_model_forms` LIKE 'confirmID';

SHOW COLUMNS 
FROM `itr_sib_model_forms` LIKE 'requiredMsg';

SELECT option_value 
FROM itr_options 
WHERE option_name = 'updraft_restore_in_progress' 
LIMIT 1

SHOW TABLES LIKE "itr_wpml_mails"

SELECT * 
FROM itr_posts LEFT JOIN itr_postmeta ON ( itr_posts.ID = itr_postmeta.post_id ) 
WHERE (post_type = 'page' 
AND post_status = 'publish') 
AND itr_postmeta.meta_key = 'calendarista_page_type' 
ORDER BY itr_posts.post_title ASC

SELECT option_value 
FROM itr_options 
WHERE option_name = 'can_compress_scripts' 
LIMIT 1

SELECT option_value 
FROM itr_options 
WHERE option_name = '_site_transient_timeout_theme_roots' 
LIMIT 1

SELECT option_value 
FROM itr_options 
WHERE option_name = '_site_transient_theme_roots' 
LIMIT 1

SELECT * 
FROM itr_users 
WHERE user_nicename = 'deeterd' 
LIMIT 1

SELECT user_id, meta_key, meta_value 
FROM itr_usermeta 
WHERE user_id IN (1) 
ORDER BY umeta_id ASC

SELECT SQL_CALC_FOUND_ROWS itr_posts.ID 
FROM itr_posts 
WHERE 1=1 
AND (itr_posts.post_author = 1) 
AND itr_posts.post_type = 'post' 
AND (itr_posts.post_status = 'publish' OR itr_posts.post_status = 'expired') 
ORDER BY itr_posts.post_date DESC 
LIMIT 0, 12

SELECT FOUND_ROWS()

SELECT itr_posts.* 
FROM itr_posts 
WHERE ID IN (1)

SELECT t.*, tt.*, tr.object_id 
FROM itr_terms AS t 
INNER JOIN itr_term_taxonomy AS tt ON t.term_id = tt.term_id 
INNER JOIN itr_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id 
WHERE tt.taxonomy IN ('category', 'post_tag', 'post_format') 
AND tr.object_id IN (1) 
ORDER BY t.name ASC

SELECT post_id, meta_key, meta_value 
FROM itr_postmeta 
WHERE post_id IN (1) 
ORDER BY meta_id ASC

SELECT id, name, data 
FROM itr_calendarista_settings 
WHERE name = 'General settings'

SELECT * 
FROM itr_posts 
WHERE ID = 13880 
LIMIT 1

SELECT post_id, meta_key, meta_value 
FROM itr_postmeta 
WHERE post_id IN (14673) 
ORDER BY meta_id ASC

SELECT post_id, meta_key, meta_value 
FROM itr_postmeta 
WHERE post_id IN (25454) 
ORDER BY meta_id ASC

SELECT * 
FROM itr_posts 
WHERE ID = 25454 
LIMIT 1

SELECT t.*, tt.* 
FROM itr_terms AS t 
INNER JOIN itr_term_taxonomy AS tt ON t.term_id = tt.term_id 
WHERE t.term_id = 2

SELECT tr.object_id 
FROM itr_term_relationships AS tr 
INNER JOIN itr_term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id 
WHERE tt.taxonomy IN ('nav_menu') 
AND tt.term_id IN ('2') 
ORDER BY tr.object_id ASC

SELECT itr_posts.* 
FROM itr_posts 
WHERE 1=1 
AND itr_posts.ID IN (7,8,13365,13495,13626,26154) 
AND itr_posts.post_type = 'nav_menu_item' 
AND ((itr_posts.post_status = 'publish')) 
ORDER BY itr_posts.menu_order ASC

SELECT post_id, meta_key, meta_value 
FROM itr_postmeta 
WHERE post_id IN (13495,7,8,26154,13626) 
ORDER BY meta_id ASC

SELECT itr_posts.* 
FROM itr_posts 
WHERE 1=1 
AND itr_posts.ID IN (13479,4,2,26151,13623) 
AND itr_posts.post_type = 'page' 
AND ((itr_posts.post_status = 'publish')) 
ORDER BY itr_posts.post_date DESC

SELECT post_id, meta_key, meta_value 
FROM itr_postmeta 
WHERE post_id IN (26151,13623,13479,4,2) 
ORDER BY meta_id ASC

SELECT itr_posts.ID 
FROM itr_posts 
WHERE 1=1 
AND itr_posts.post_type = 'post' 
AND ((itr_posts.post_status = 'publish')) 
ORDER BY itr_posts.post_date DESC 
LIMIT 0, 5

SELECT itr_posts.* 
FROM itr_posts 
WHERE ID IN (10375,9454)

SELECT t.*, tt.*, tr.object_id 
FROM itr_terms AS t 
INNER JOIN itr_term_taxonomy AS tt ON t.term_id = tt.term_id 
INNER JOIN itr_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id 
WHERE tt.taxonomy IN ('category', 'post_tag', 'post_format') 
AND tr.object_id IN (9454, 10375) 
ORDER BY t.name ASC

SELECT post_id, meta_key, meta_value 
FROM itr_postmeta 
WHERE post_id IN (9454,10375) 
ORDER BY meta_id ASC

SELECT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts 
FROM itr_posts 
WHERE post_type = 'post' 
AND post_status = 'publish' 
GROUP BY YEAR(post_date), MONTH(post_date) 
ORDER BY post_date DESC

SELECT t.*, tt.* 
FROM itr_terms AS t 
INNER JOIN itr_term_taxonomy AS tt ON t.term_id = tt.term_id 
WHERE tt.taxonomy IN ('category') 
AND tt.count > 0 
ORDER BY t.name ASC

SELECT term_id, meta_key, meta_value 
FROM itr_termmeta 
WHERE term_id IN (1) 
ORDER BY meta_id ASC

SELECT * 
FROM itr_posts 
WHERE ID = 21819 
LIMIT 1

SELECT post_id, meta_key, meta_value 
FROM itr_postmeta 
WHERE post_id IN (21819) 
ORDER BY meta_id ASC

SELECT t.*, tt.* 
FROM itr_terms AS t 
INNER JOIN itr_term_taxonomy AS tt ON t.term_id = tt.term_id 
WHERE t.term_id = 25

SELECT tr.object_id 
FROM itr_term_relationships AS tr 
INNER JOIN itr_term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id 
WHERE tt.taxonomy IN ('nav_menu') 
AND tt.term_id IN ('25') 
ORDER BY tr.object_id ASC

SELECT itr_posts.* 
FROM itr_posts 
WHERE 1=1 
AND itr_posts.ID IN (11,12) 
AND itr_posts.post_type = 'nav_menu_item' 
AND ((itr_posts.post_status = 'publish')) 
ORDER BY itr_posts.menu_order ASC

SELECT post_id, meta_key, meta_value 
FROM itr_postmeta 
WHERE post_id IN (11,12) 
ORDER BY meta_id ASC