The great American Literature Prize

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

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

SELECT count(*) AS total FROM vizzed_logs.log_2019_11_18 WHERE ip_id=1604198 AND date > 1574064926 - 3 /*()*/

SELECT count(*) AS total FROM vizzed_logs.log_2019_11_18 WHERE ip_id=1604198 AND date > 1574064926 - 60 /*()*/

INSERT INTO log_2019_11_18( user_id, ip_id, page_id, browser_id, device_id, os_id, unique_id, security, date ) VALUES( '', '1604198', '733641', '23586', '2', '2', '63476780', '', 1574064926 ) /*()*/

SELECT threads.*, posts.date FROM threads INNER JOIN posts ON posts.thread = threads.id WHERE threads.id=94657 /*()*/

SELECT * FROM threads_variables WHERE thread_id=94657 /*()*/

INSERT INTO vizzed_logs.log_queries_slow (log_table,log_id,query,rendered) VALUES ('log_2019_11_18','25579','UPDATE threads SET views=views+1 WHERE id=94657 /*()*/ ','204') /*()*/

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 user, count(*) num FROM posts WHERE date>1573978526 GROUP BY user /*()*/

SELECT * FROM posts WHERE thread=94657 ORDER BY date ASC LIMIT 1 /*()*/

SELECT posts.*,posts_text.text,edited,tagval,users.id user_id,name,wordsignored,regdate,quotes , 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 ,posts,postswords,sex,powerlevel,picture,title,staffTitle,useranks,location,lastposttime,lastactivity,imood,currency,contributionpoints,minipic,initialname,previousname FROM posts INNER JOIN posts_text ON posts_text.pid = posts.id INNER JOIN users ON posts.user=users.id INNER JOIN users_last ON posts.user = users_last.user_id WHERE thread=94657 ORDER BY posts.id=1273766 DESC, posts.date ASC LIMIT 0,20 /*()*/

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

UPDATE page_statistics SET views_today=0, update_daily=18218 WHERE page_id=733641 /*()*/

SELECT * FROM `page_variable_list` WHERE (page_id=0 OR page_id=733641 OR page_id=287784 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` WHERE page_id=733641 /*()*/

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

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

UPDATE guests SET date=1574064926, last_page_id=733641,last_parent_id=287784,last_directory_id=7 WHERE ip = '35.173.234.140' /*()*/

SELECT allkeywords,id FROM thread_page_indexes WHERE thread_id=94657 /*()*/

SELECT distinct keywords, SUM(total) as counttotal, searchengine FROM thread_searchkeywords WHERE threadid = 94657 AND keywords <> '' GROUP BY keywords ORDER BY counttotal DESC, date DESC LIMIT 25 /*()*/

SELECT views FROM misc /*()*/

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

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

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

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

SELECT COUNT(*) as total FROM users_last WHERE lastactivity >= 1574064926-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=733641 OR page_id=7 OR page_id=287784 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 = 733641 ORDER BY page_content_order ASC /*()*/

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