Pacman+Mariofan's Profile - Creator of an unoriginal username

SELECT * FROM page LEFT JOIN page_statistics ON page_statistics.page_id = id WHERE url = "/user?id=289675" /*()*/

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 FROM vizzed_logs.log_ip WHERE ip=INET_ATON('3.92.92.168') /*()*/

SELECT count(*) AS total FROM vizzed_logs.log_2019_11_17 WHERE ip_id=1609723 AND date > 1574051669 - 3 /*()*/

SELECT count(*) AS total FROM vizzed_logs.log_2019_11_17 WHERE ip_id=1609723 AND date > 1574051669 - 60 /*()*/

SELECT * FROM log_ip WHERE ip=INET_ATON('3.92.92.168') /*()*/

INSERT INTO log_2019_11_17( user_id, ip_id, page_id, browser_id, device_id, os_id, unique_id, security, date ) VALUES( '', '1609723', '304775', '23586', '2', '2', '73611916', '', 1574051669 ) /*()*/

SELECT users.*, users_last.*, users_games.*, page.url, page.url_format, page.page_title, page.page_title_short, forums.minpower FROM users LEFT JOIN users_last ON users.id = users_last.user_id LEFT JOIN users_games ON users.id = users_games.user_id LEFT JOIN page ON page.id = users_last.last_page_id LEFT JOIN forums ON forums.id = page.special_id AND parent_id=287729 WHERE users.id=289675 /*()*/

SELECT COUNT(id) as total FROM game_user_wishlist WHERE user_id=289675 /*()*/

SELECT COUNT(id) as total FROM game_user_collection WHERE user_id=289675 /*()*/

SELECT SUM(quantity) as total FROM market_user_items WHERE user_id=289675 /*()*/

SELECT SUM(quantity) as total FROM market_vizzed WHERE userid=289675 AND active=1 /*()*/

SELECT useranks,currency FROM users WHERE name='Pacman+Mariofan' /*()*/

SELECT count(id) AS cnt FROM threads WHERE user=289675 /*()*/

INSERT INTO vizzed_logs.log_queries_slow (log_table,log_id,query,rendered) VALUES ('log_2019_11_17','369229',' SELECT threads.id, threads.title, forums.minpower, posts.date FROM posts INNER JOIN threads ON threads.id = posts.thread INNER JOIN forums ON forums.id = threads.forum WHERE posts.user=289675 ORDER BY posts.date DESC LIMIT 1 /*()*/ ','54') /*()*/

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

SELECT * FROM banlog WHERE banUserID=289675 and banStatus='Active' ORDER BY banStartDate ASC LIMIT 1 /*()*/

UPDATE page_statistics SET views_today=views_today+1, views=views+1 WHERE page_id=304775 /*()*/

SELECT * FROM `page_variable_list` WHERE (page_id=0 OR page_id=304775 OR page_id=139816 OR page_id=139816) ORDER BY page_id <> '' DESC, category = 'Page Meta' DESC, category = 'Page Look' DESC, category = 'Page Detailed' DESC, category = 'Content Disabling' ASC, category ASC, variableOrder ASC, name ASC /*()*/

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

SELECT COUNT(page_content.id) as total FROM page_content LEFT JOIN page_content_url ON page_content_url.page_content_id=page_content.id WHERE page_content_url.page_id=304775 AND cantremovefrompage=139816 /*()*/

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

UPDATE guests SET date=1574051669, last_page_id=304775,last_parent_id=139816,last_directory_id=139816 WHERE ip = '3.92.92.168' /*()*/

SELECT allkeywords,id FROM page_indexes WHERE url='/user/index.php?id=289675&type=profile' /*()*/

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

SELECT views FROM misc /*()*/

UPDATE misc SET views=2535904491 /*()*/

SELECT page.* FROM `page` INNER JOIN page_statistics ON page_statistics.page_id = page.id WHERE page_order = 3 ORDER BY views_today DESC /*()*/

SELECT page.* FROM `page` INNER JOIN page_statistics ON page_statistics.page_id = page.id WHERE page_order <= 3 ORDER BY page.id=2 DESC, page.id=3 DESC, page.id=7 DESC, page.id=8 DESC, page.id=141056 DESC, page.id=290325 DESC, page.id=817112 DESC, page.id=139840 DESC, page.id=980494 DESC, page.id=270457 DESC, page_order DESC, views DESC LIMIT 10 /*()*/

SELECT COUNT(*) as total FROM users_last WHERE lastactivity >= 1574051669-900 AND last_page_id=304775 /*()*/

SELECT id FROM guests WHERE date >= 1574051669-900 AND last_page_id=304775 /*()*/

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

SELECT id FROM guests WHERE date >= 1574051669-900 AND (last_directory_id=139816 OR last_page_id=139816) /*()*/

SELECT COUNT(*) as total FROM guests WHERE date >= 1574051669-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=304775 OR page_id=139816 OR page_id=139816 ORDER BY power DESC /*()*/

SELECT id, url, page_order, page_title, page_title_short FROM page WHERE (parent_id=304775 OR directory_id=304775 OR id=139816 OR id=139816 OR parent_id=139816 OR (directory_id=139816 AND directory_id <> 2) ) AND page_order <= 3 ORDER BY id = 139816 DESC, page_order ASC, page_title ASC /*()*/

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 = 304775 ORDER BY page_content_order ASC /*()*/

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

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