Links and History

SELECT * FROM page LEFT JOIN page_statistics ON page_statistics.page_id = id WHERE url = "/w/links-and-history.php" /*()*/

SELECT count(*) FROM ipbans WHERE INSTR('35.173.234.140',ip)=1 /*()*/

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

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

INSERT INTO log_2019_11_21_details( log_id, url, title, referral_url, variables_post, variables_get ) VALUES( 56485, '//www.vizzed.com/w/links-and-history.php', 'Links and History', '', '', '' ) /*()*/

SELECT * FROM users_group INNER JOIN users_group_user ON users_group_user.group_id = users_group.id WHERE type=8 /*()*/

SELECT id FROM page_content WHERE widget LIKE '%links-and-history.php' /*()*/

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

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

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

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

UPDATE guests SET date=1574332665, last_page_id=139931,last_parent_id=139931,last_directory_id=139840 WHERE ip = '35.173.234.140' /*()*/

SELECT allkeywords,id FROM page_indexes WHERE url='/w/links-and-history.php' /*()*/

SELECT distinct keywords, SUM(total) as counttotal, searchengine FROM searchkeywords WHERE url='/w/links-and-history.php' AND keywords <> '' GROUP BY keywords ORDER BY counttotal DESC, date DESC LIMIT 10 /*()*/

SELECT views FROM misc /*()*/

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

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

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

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

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

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