Notifcations

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

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

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

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

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

SELECT count(*) AS total FROM vizzed_logs.log_2019_11_21 WHERE ip_id=1629405 AND date > 1574323429 - 60 /*()*/

INSERT INTO vizzed_logs.log_queries_bad (log_table,log_id,query) VALUES ('log_2019_11_21','22496',' SELECT MAX(total) AS max_total, MIN(total) AS min_total, AVG(total) AS avg_total FROM ( SELECT distinct type, COUNT(type) as total FROM notifications WHERE userid= GROUP BY type ) AS counts /*()*/ ') /*()*/

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

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

UPDATE guests SET date=1574323429, last_page_id=965438,last_parent_id=965438,last_directory_id=139816 WHERE ip = '18.210.28.227' /*()*/

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

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

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

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

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

SELECT COUNT(*) as total FROM users_last WHERE lastactivity >= 1574323429-900 /*()*/

SELECT COUNT(*) as total FROM guests WHERE date >= 1574323429-900 /*()*/

SELECT users.id as userid, users.picture as userpic, users_last.last_invizection , 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 users LEFT JOIN users_last ON users_last.user_id = users.id WHERE lastactivity >= 1574323429-900 AND last_page_id=965438 ORDER BY lastactivity DESC /*()*/

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=965438 OR page_id=139816 OR page_id=965438 ORDER BY power DESC /*()*/

SELECT * FROM page WHERE page_order <= 2 ORDER BY page_order ASC, page_title ASC /*()*/

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

UPDATE log_2019_11_21 SET rendered='66', queries='62', queries_slow='', queries_errors='5' WHERE id=22496 /*()*/