All Forums - All Forums

SELECT * FROM page LEFT JOIN page_statistics ON page_statistics.page_id = id WHERE url = "/boards/forum.php" /*()*/

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

SELECT id FROM vizzed_logs.log_ip WHERE ip=INET_ATON('35.175.180.108') /*()*/

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

SELECT count(*) AS total FROM vizzed_logs.log_2019_11_13 WHERE ip_id=1559507 AND date > 1573691825 - 60 /*()*/

INSERT INTO log_2019_11_13( user_id, ip_id, page_id, browser_id, device_id, os_id, unique_id, security, date ) VALUES( '', '1559507', '287729', '23586', '2', '2', '90887126', '', 1573691825 ) /*()*/

SELECT * FROM `page_variable_list` WHERE (page_id=0 OR page_id=287729 OR page_id=287729 OR page_id=7) 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_theme_variables` WHERE page_variables_theme_id=1 /*()*/

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

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

UPDATE guests SET date=1573691825, last_page_id=287729,last_parent_id=287729,last_directory_id=7 WHERE ip = '35.175.180.108' /*()*/

SELECT allkeywords,id FROM page_indexes WHERE url='/boards/forum.php?sub=Megaman%20Forum%20Games&order=title%E2%8A%82=Bible' /*()*/

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

SELECT COUNT(*) as total FROM users LEFT JOIN users_last ON users_last.user_id = users.id WHERE lastactivity >= 1573691825-900 AND (last_parent_id=287729 OR last_page_id=287729 OR lastforum=0) /*()*/

SELECT COUNT(*) as total FROM guests WHERE date >= 1573691825-900 AND (last_parent_id=287729 OR last_page_id=287729 OR lastforum=0) /*()*/

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 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 = 'Megaman Forum Games' LIMIT 0,50 ) threads /*()*/

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