eDied2014's Profile -

SELECT id, url, url_format, directory_id, page_order, update_date, update_users, last_users, views_today, parent_id, directory_id, theme_id FROM page INNER JOIN page_statistics ON page_statistics.page_id = id WHERE id=139816 /*()*/

SELECT id, url, url_format, directory_id, page_order, update_date, update_users, last_users, views_today, parent_id, directory_id, theme_id FROM page INNER JOIN page_statistics ON page_statistics.page_id = id WHERE id=139816 /*()*/

/* get_browser Start /* /*()*/

/* get_browser End /* /*()*/

SELECT count(*) FROM ipbans WHERE INSTR('XXXXXXXXXXXXXXXXX',ip)=1 /*()*/

SELECT count(*) FROM ipbans WHERE INSTR('XXXXXXXXXXXXXXXXX',ip)=1 /*()*/

SELECT count(*) FROM ipbans WHERE INSTR('18.205.96.39',ip)=1 /*()*/

SELECT ip FROM logs_11_13_19 ORDER BY id DESC LIMIT 2 /*()*/

SELECT id FROM log_2019_11_13 LIMIT 1 /*()*/

SELECT * FROM log_browser WHERE browser_details='CCBot/2.0 (https://commoncrawl.org/faq/)' /*()*/

SELECT * FROM log_device WHERE device='unknown' /*()*/

SELECT * FROM log_os WHERE os='unknown' /*()*/

INSERT INTO log_2019_11_13( user_id, ip_id, page_id, browser_id, device_id, os_id, unique_id, security, date ) VALUES( '', '1562030', '327610', '23586', '2', '2', '51795203', '', 1573710265 ) /*()*/

INSERT INTO log_2019_11_13_details( log_id, url, title, referral_url, variables_post, variables_get ) VALUES( 357407, '//www.vizzed.com/user/index.php?id=511674&type=profile', '', '', '', '{\"id\":\"511674\",\"type\":\"profile\"}' ) /*()*/

SELECT * FROM boardconfig /*()*/

SELECT name,posts,sex,powerlevel,id FROM users,postradar WHERE postradar.user=0 AND users.id=postradar.comp ORDER BY posts DESC /*()*/

SELECT * FROM users_group INNER JOIN users_group_user ON users_group_user.group_id = users_group.id WHERE type=8 /*()*/

SELECT * FROM users_customization /*()*/

SELECT * FROM tourdevizzedmonthly WHERE year=2019 AND month=10 /*()*/

/* Get File Contents from information.php */ /*()*/

/* TEST */ /*()*/

SELECT useranks,currency FROM users WHERE name='eDied2014' /*()*/

SELECT text FROM ranks WHERE num<=8 AND rset=1 ORDER BY num DESC LIMIT 1 /*()*/

INSERT INTO vizzed_logs.log_queries_slow (log_table,log_id,query,rendered) VALUES ('log_2019_11_13','357407','UPDATE page_statistics SET views_today=views_today+1, views=views+1 WHERE page_id=327610 /*()*/ ','25') /*()*/

UPDATE page_statistics SET views_today=0, update_daily=18213 WHERE page_id=327610 /*()*/

SELECT * FROM `page_variables_theme_variables` WHERE page_variables_theme_id=1 /*()*/

SELECT * FROM `page_variables` WHERE page_id=139816 /*()*/

SELECT * FROM `page_variables` WHERE page_id=139816 /*()*/

SELECT id FROM guests WHERE ip = '18.205.96.39' ORDER BY date DESC LIMIT 1 /*()*/

SELECT distinct keywords, SUM(total) as counttotal, searchengine FROM searchkeywords WHERE url='/user/index.php?id=511674&type=profile' AND keywords <> '' GROUP BY keywords ORDER BY counttotal DESC, date DESC LIMIT 10 /*()*/

SELECT title FROM announcements ORDER BY date DESC LIMIT 5 /*()*/

SELECT COUNT(*) as total FROM users_last WHERE lastactivity >= 1573710265-900 AND (last_directory_id=139816 OR last_page_id=139816) /*()*/

SELECT COUNT(*) as total FROM users_last WHERE lastactivity >= 1573710265-900 /*()*/

SELECT page_admin.power, users_group.name as group_name, group_id, user_id as userid , users.birthday as userbirthday, users.name as username, users.regdate as userregdate, users.posts as userposts, users.sex as usersex, users.powerlevel as userpowerlevel, users.postsToday as userpostsToday, users.picture as userpic FROM `page_admin` LEFT JOIN users ON users.id=page_admin.user_id LEFT JOIN users_group ON users_group.id=page_admin.group_id WHERE page_id=327610 OR page_id=139816 OR page_id=139816 ORDER BY power DESC /*()*/

SELECT *, page_content_url.id as page_content_url_id FROM page_content_url LEFT JOIN page_content ON page_content.id = page_content_url.page_content_id WHERE page_id = 327610 ORDER BY page_content_order ASC /*()*/

SELECT * FROM page_content WHERE title='Miscellaneous Stats and Links' /*()*/

SELECT * FROM page_content WHERE title='Post Layout' /*()*/

SELECT * FROM page_content WHERE title='Friend List' /*()*/

SELECT * FROM page_content WHERE title='Reverse Friend List' /*()*/

SELECT * FROM page_content WHERE title='Referrals' /*()*/

SELECT id FROM log_2019_11_13 LIMIT 1 /*()*/

UPDATE log_2019_11_13 SET rendered='181', queries='73', queries_slow='1', queries_errors='' WHERE id=357407 /*()*/