All Forums - All Forums

/* 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.206.194.210',ip)=1 /*()*/

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

SELECT count(*) AS total FROM vizzed_logs.log_2019_11_13 WHERE ip_id=1574711 AND date > 1573682337 - 3 /*()*/

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( '', '1574711', '287729', '23586', '2', '2', '98003923', '', 1573682337 ) /*()*/

INSERT INTO log_2019_11_13_details( log_id, url, title, referral_url, variables_post, variables_get ) VALUES( 226352, '//www.vizzed.com/boards/forum.php?sub=Game', 'All Threads', '', '', '{\"sub\":\"Game\"}' ) /*()*/

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 /*()*/

SELECT SUM(numthreads) FROM forums /*()*/

SELECT COUNT(pid) FROM posts_text /*()*/

INSERT INTO vizzed_logs.log_queries_slow (log_table,log_id,query,rendered) VALUES ('log_2019_11_13','226352',' SELECT SUM(views) as view_total, SUM(likes) as likes_total, SUM(dislikes) as dislikes_total FROM threads WHERE forum<>0 /*()*/ ','78') /*()*/

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

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

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

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

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

SELECT COUNT(id) as total FROM page_content WHERE cantremovefrompage=287729 /*()*/

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

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

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

SELECT * FROM page WHERE (directory_id=287729 OR (directory_id=7 AND directory_id!=2) ) AND page_order=3 AND (page_title <> '' OR page_title_short <> '') ORDER BY page_title ASC /*()*/

SELECT id, url, page_order, page_title, page_title_short FROM page WHERE (parent_id=287729 OR directory_id=287729 OR id=287729 OR id=7 OR parent_id=287729 OR (directory_id=7 AND directory_id <> 2) ) AND page_order <= 3 ORDER BY id = 7 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 = 287729 ORDER BY page_content_order ASC /*()*/

INSERT INTO vizzed_logs.log_queries_slow (log_table,log_id,query,rendered) VALUES ('log_2019_11_13','226352',' SELECT threads.* FROM ( SELECT threads.*, page.img_thumbnail AS img_thumbnail, minpower, forums.title as forumtitle, forums.id as forumid, users2.id as user2, users2.birthday as birthday2, users2.name as name2, users2.regdate as regdate2, users2.posts as posts2, users2.sex as sex2, users2.powerlevel as powerlevel2, users2.postsToday as postsToday2 , 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 threads FORCE INDEX(lastpostdate) INNER JOIN users ON users.id = threads.user INNER JOIN users users2 ON users2.id = threads.lastposter LEFT JOIN threads_keywords ON threads_keywords.thread_id = threads.id LEFT JOIN keywords ON keywords.id = threads_keywords.keyword_id LEFT JOIN forums ON forums.id=threads.forum LEFT JOIN page ON page.special_id = threads.id AND page.parent_id=795701 WHERE forum<>0 AND (forums.minpower <= 0 )AND keywords.keyword = \'Game\' ORDER BY lastpostdate DESC LIMIT 0,50 ) threads ORDER BY lastpostdate DESC /*()*/ ','56') /*()*/

SELECT id,birthday,name,regdate,posts,postsToday,sex,powerlevel,picture,last_invizection FROM `users` LEFT JOIN users_last ON users_last.user_id = users.id WHERE `id`='472649' /*()*/

SELECT id,birthday,name,regdate,posts,postsToday,sex,powerlevel,picture,last_invizection FROM `users` LEFT JOIN users_last ON users_last.user_id = users.id WHERE `id`='35979' /*()*/

SELECT id,birthday,name,regdate,posts,postsToday,sex,powerlevel,picture,last_invizection FROM `users` LEFT JOIN users_last ON users_last.user_id = users.id WHERE `id`='385188' /*()*/

SELECT id,birthday,name,regdate,posts,postsToday,sex,powerlevel,picture,last_invizection FROM `users` LEFT JOIN users_last ON users_last.user_id = users.id WHERE `id`='259134' /*()*/

SELECT id,birthday,name,regdate,posts,postsToday,sex,powerlevel,picture,last_invizection FROM `users` LEFT JOIN users_last ON users_last.user_id = users.id WHERE `id`='259134' /*()*/

SELECT id,birthday,name,regdate,posts,postsToday,sex,powerlevel,picture,last_invizection FROM `users` LEFT JOIN users_last ON users_last.user_id = users.id WHERE `id`='578665' /*()*/

SELECT id,birthday,name,regdate,posts,postsToday,sex,powerlevel,picture,last_invizection FROM `users` LEFT JOIN users_last ON users_last.user_id = users.id WHERE `id`='117123' /*()*/

SELECT id,birthday,name,regdate,posts,postsToday,sex,powerlevel,picture,last_invizection FROM `users` LEFT JOIN users_last ON users_last.user_id = users.id WHERE `id`='117123' /*()*/

SELECT id,birthday,name,regdate,posts,postsToday,sex,powerlevel,picture,last_invizection FROM `users` LEFT JOIN users_last ON users_last.user_id = users.id WHERE `id`='117123' /*()*/

SELECT id,birthday,name,regdate,posts,postsToday,sex,powerlevel,picture,last_invizection FROM `users` LEFT JOIN users_last ON users_last.user_id = users.id WHERE `id`='578665' /*()*/

SELECT id,birthday,name,regdate,posts,postsToday,sex,powerlevel,picture,last_invizection FROM `users` LEFT JOIN users_last ON users_last.user_id = users.id WHERE `id`='579004' /*()*/

SELECT id,birthday,name,regdate,posts,postsToday,sex,powerlevel,picture,last_invizection FROM `users` LEFT JOIN users_last ON users_last.user_id = users.id WHERE `id`='311445' /*()*/

SELECT id,birthday,name,regdate,posts,postsToday,sex,powerlevel,picture,last_invizection FROM `users` LEFT JOIN users_last ON users_last.user_id = users.id WHERE `id`='311445' /*()*/

SELECT id,birthday,name,regdate,posts,postsToday,sex,powerlevel,picture,last_invizection FROM `users` LEFT JOIN users_last ON users_last.user_id = users.id WHERE `id`='311445' /*()*/

SELECT id,birthday,name,regdate,posts,postsToday,sex,powerlevel,picture,last_invizection FROM `users` LEFT JOIN users_last ON users_last.user_id = users.id WHERE `id`='311445' /*()*/

SELECT id,birthday,name,regdate,posts,postsToday,sex,powerlevel,picture,last_invizection FROM `users` LEFT JOIN users_last ON users_last.user_id = users.id WHERE `id`='311445' /*()*/

SELECT id,birthday,name,regdate,posts,postsToday,sex,powerlevel,picture,last_invizection FROM `users` LEFT JOIN users_last ON users_last.user_id = users.id WHERE `id`='584875' /*()*/

SELECT id,birthday,name,regdate,posts,postsToday,sex,powerlevel,picture,last_invizection FROM `users` LEFT JOIN users_last ON users_last.user_id = users.id WHERE `id`='584875' /*()*/

SELECT id,birthday,name,regdate,posts,postsToday,sex,powerlevel,picture,last_invizection FROM `users` LEFT JOIN users_last ON users_last.user_id = users.id WHERE `id`='311445' /*()*/

SELECT id,birthday,name,regdate,posts,postsToday,sex,powerlevel,picture,last_invizection FROM `users` LEFT JOIN users_last ON users_last.user_id = users.id WHERE `id`='582485' /*()*/

SELECT id,birthday,name,regdate,posts,postsToday,sex,powerlevel,picture,last_invizection FROM `users` LEFT JOIN users_last ON users_last.user_id = users.id WHERE `id`='579004' /*()*/

SELECT id,birthday,name,regdate,posts,postsToday,sex,powerlevel,picture,last_invizection FROM `users` LEFT JOIN users_last ON users_last.user_id = users.id WHERE `id`='578665' /*()*/

SELECT id,birthday,name,regdate,posts,postsToday,sex,powerlevel,picture,last_invizection FROM `users` LEFT JOIN users_last ON users_last.user_id = users.id WHERE `id`='578665' /*()*/

SELECT id,birthday,name,regdate,posts,postsToday,sex,powerlevel,picture,last_invizection FROM `users` LEFT JOIN users_last ON users_last.user_id = users.id WHERE `id`='311445' /*()*/

SELECT id,birthday,name,regdate,posts,postsToday,sex,powerlevel,picture,last_invizection FROM `users` LEFT JOIN users_last ON users_last.user_id = users.id WHERE `id`='578665' /*()*/

SELECT id,birthday,name,regdate,posts,postsToday,sex,powerlevel,picture,last_invizection FROM `users` LEFT JOIN users_last ON users_last.user_id = users.id WHERE `id`='348107' /*()*/

SELECT id,birthday,name,regdate,posts,postsToday,sex,powerlevel,picture,last_invizection FROM `users` LEFT JOIN users_last ON users_last.user_id = users.id WHERE `id`='185739' /*()*/

SELECT id,birthday,name,regdate,posts,postsToday,sex,powerlevel,picture,last_invizection FROM `users` LEFT JOIN users_last ON users_last.user_id = users.id WHERE `id`='65348' /*()*/

SELECT id,birthday,name,regdate,posts,postsToday,sex,powerlevel,picture,last_invizection FROM `users` LEFT JOIN users_last ON users_last.user_id = users.id WHERE `id`='311445' /*()*/

SELECT id,birthday,name,regdate,posts,postsToday,sex,powerlevel,picture,last_invizection FROM `users` LEFT JOIN users_last ON users_last.user_id = users.id WHERE `id`='568640' /*()*/

SELECT id,birthday,name,regdate,posts,postsToday,sex,powerlevel,picture,last_invizection FROM `users` LEFT JOIN users_last ON users_last.user_id = users.id WHERE `id`='311445' /*()*/

SELECT id,birthday,name,regdate,posts,postsToday,sex,powerlevel,picture,last_invizection FROM `users` LEFT JOIN users_last ON users_last.user_id = users.id WHERE `id`='568640' /*()*/

SELECT id,birthday,name,regdate,posts,postsToday,sex,powerlevel,picture,last_invizection FROM `users` LEFT JOIN users_last ON users_last.user_id = users.id WHERE `id`='568640' /*()*/

SELECT id,birthday,name,regdate,posts,postsToday,sex,powerlevel,picture,last_invizection FROM `users` LEFT JOIN users_last ON users_last.user_id = users.id WHERE `id`='65348' /*()*/

SELECT id,birthday,name,regdate,posts,postsToday,sex,powerlevel,picture,last_invizection FROM `users` LEFT JOIN users_last ON users_last.user_id = users.id WHERE `id`='228466' /*()*/

SELECT id,birthday,name,regdate,posts,postsToday,sex,powerlevel,picture,last_invizection FROM `users` LEFT JOIN users_last ON users_last.user_id = users.id WHERE `id`='528799' /*()*/

SELECT id,birthday,name,regdate,posts,postsToday,sex,powerlevel,picture,last_invizection FROM `users` LEFT JOIN users_last ON users_last.user_id = users.id WHERE `id`='528799' /*()*/

INSERT INTO vizzed_logs.log_queries_slow (log_table,log_id,query,rendered) VALUES ('log_2019_11_13','226352',' SELECT COUNT(keyword) as total, keyword, keywords.id as keyword_id FROM keywords LEFT JOIN threads_keywords ON threads_keywords.keyword_id = keywords.id LEFT JOIN threads ON threads.id = threads_keywords.thread_id WHERE forum<>0 GROUP BY keyword ORDER BY keyword ASC /*()*/ ','129') /*()*/

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

UPDATE log_2019_11_13 SET rendered='384', queries='112', queries_slow='3', queries_errors='' WHERE id=226352 /*()*/