mathezwerg's Rätselstatus

Erzeugt in 0.01486 Sekunden mit 16 Abfragen
Nettolaufzeit: 0.01486 Cps: 67
SELECT typ,item,value FROM system_sys_vars
INSERT INTO system_sessions (sid,uid,gid,session_ip,session_time,session_bot) VALUES ('3089294ddd64bb34d47509a49dc55afe',0,99,'d849d8d1',1788645594,1)
SELECT * FROM system_sessions WHERE sid='3089294ddd64bb34d47509a49dc55afe'
SELECT * FROM system_users WHERE uid=0
SELECT * FROM system_users WHERE uid=20499
SELECT m.*,r.riddle_name,r.riddle_max_questions,r.riddle_has_hs,r.riddle_typ,r.riddle_categorie,r.riddle_sort,count(q.level) AS levelcount FROM riddle_user_riddle m,riddle_riddles r,riddle_questions q WHERE m.ur_uid=20499 AND r.rid=m.ur_rid AND q.riddle=m.ur_rid AND r.riddle_launched=1 AND q.ok=1 AND q.released<="2026-09-05 23:59:54" GROUP BY q.riddle ORDER BY r.riddle_categorie,r.riddle_sort
SELECT count(*) FROM riddle_user_solved WHERE us_uid=20499 AND us_rid=56 AND us_solves>0
SELECT count(*) FROM riddle_user_solved WHERE us_uid=20499 AND us_rid=62 AND us_solves>0
SELECT count(*) FROM riddle_user_solved WHERE us_uid=20499 AND us_rid=69 AND us_solves>0
SELECT r.rid,r.riddle_name,q.level,q.released FROM riddle_riddles r,riddle_questions q WHERE r.riddle_launched=1 AND q.riddle=r.rid AND q.ok=1 AND q.released>="2026-09-05 23:59:54" ORDER BY released LIMIT 0,1
SELECT r.rid,r.riddle_name,q.level,q.released FROM riddle_riddles r,riddle_questions q WHERE r.riddle_launched=1 AND q.riddle=r.rid AND q.ok=1 AND q.released>="2026-09-05 23:59:54" ORDER BY released LIMIT 0,1
SELECT count(*) FROM riddle_riddles r, riddle_questions q WHERE r.riddle_launched=1 AND q.riddle=r.rid AND q.ok=1 AND q.released < "2026-09-05 23:59:54"
UPDATE system_sessions SET session_page = 'userrstate',session_time = 1788645594 ,session_data='b:0;' WHERE sid='3089294ddd64bb34d47509a49dc55afe'
INSERT INTO stats_bot_ip SET date='2026-09-05',ip='d849d8d1',agent='Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)',page='userrstate',count=1 ON DUPLICATE KEY UPDATE count=count+1
UPDATE system_sys_vars SET value='1788645654|0|0|-' WHERE typ='V' AND item='countdown'
INSERT INTO stats_counter_pi (id,count_bot,date,hour) VALUES ('userrstate','1','2026-09-05','23') ON DUPLICATE KEY UPDATE count_bot=count_bot+1