Trending on Site

SELECT * FROM page LEFT JOIN page_statistics ON page_statistics.page_id = id WHERE url = "/w/trending.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=139840 /*()*/

SELECT count(*) AS total FROM vizzed_logs.log_2019_11_14 WHERE ip_id=1562030 AND date > 1573712735 - 3 /*()*/

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

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

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

INSERT INTO log_2019_11_14( user_id, ip_id, page_id, browser_id, device_id, os_id, unique_id, security, date ) VALUES( '', '1562030', '139846', '23586', '2', '2', '69105537', '', 1573712735 ) /*()*/

INSERT INTO vizzed_logs.log_queries_slow (log_table,log_id,query,rendered) VALUES ('log_2019_11_14','5857',' SELECT id, name, system, TYPE , systemType FROM game_games_stats FORCE INDEX ( viewsToday ) INNER JOIN game ON game.id = game_games_stats.game_id WHERE defaultRGROrder <> 0 AND infoUpdateDate = 18214 ORDER BY viewsToday DESC LIMIT 32 /*()*/ ','30') /*()*/

SELECT threads.id as threadid, threads.title as title, count(distinct posts.user) as total, threads.user as userid, forums.title as forumtitle, forums.id as forumid , 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 posts INNER JOIN threads ON threads.id = posts.thread INNER JOIN users ON users.id = threads.user INNER JOIN forums ON forums.id = threads.forum WHERE posts.date > 1573712735-86400 AND 0 >= minpower GROUP BY threads.id ORDER BY total DESC LIMIT 32 /*()*/

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

SELECT * FROM `page_variable_list` WHERE (page_id=0 OR page_id=139846 OR page_id=139846 OR page_id=139840) 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 id FROM guests WHERE ip = '18.205.96.39' ORDER BY date DESC LIMIT 1 /*()*/

UPDATE guests SET date=1573712735, last_page_id=139846,last_parent_id=139846,last_directory_id=139840 WHERE ip = '18.205.96.39' /*()*/

SELECT allkeywords,id FROM page_indexes WHERE url='/w/trending.php' /*()*/

SELECT views FROM misc /*()*/

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

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 >= 1573712735-900 AND last_page_id=139846 /*()*/

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

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

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

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

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