SET @@sql_mode = '' SELECT * FROM vb_datastore WHERE title IN ('tagcloud','iconcache','navdata','navdata','attachmentcache','cron','profilefield','loadcache','noticecache','activitystream','routes') SELECT * FROM vb_session WHERE sessionhash = '2775135a01cbdb142fac917e8c0c4e41' AND lastactivity > 1714249737 AND idhash = '84d19bcec0ead68f17e442c6ce01b1e7' SELECT * FROM vb_session WHERE userid = 0 AND host = '18.220.154.41' AND idhash = '84d19bcec0ead68f17e442c6ce01b1e7' LIMIT 1 SELECT languageid, phrasegroup_global AS phrasegroup_global, phrasegroup_inlinemod AS phrasegroup_inlinemod, phrasegroup_search AS phrasegroup_search, phrasegroup_prefix AS phrasegroup_prefix, phrasegroupinfo AS lang_phrasegroupinfo, options AS lang_options, languagecode AS lang_code, charset AS lang_charset, locale AS lang_locale, imagesoverride AS lang_imagesoverride, dateoverride AS lang_dateoverride, timeoverride AS lang_timeoverride, registereddateoverride AS lang_registereddateoverride, calformat1override AS lang_calformat1override, calformat2override AS lang_calformat2override, logdateoverride AS lang_logdateoverride, decimalsep AS lang_decimalsep, thousandsep AS lang_thousandsep FROM vb_language WHERE languageid = 3 SELECT MAX(permissions & 1) AS perm FROM vb_cms_permissions WHERE nodeid = 1 AND usergroupid IN (1) SELECT * FROM vb_style WHERE (styleid = 7 AND userselect = 1) OR styleid = 7 ORDER BY styleid ASC LIMIT 1 SELECT data, expires, locktime, serialized FROM vb_cache WHERE cacheid = 'vb_types.types'SELECT tagid, tagtext, canonicaltagid, dateline FROM vb_tag WHERE tagtext = 'beleuchtung' SELECT searchlog.* FROM vb_searchlog AS searchlog WHERE searchhash = '6b8dc29706a035041ec32775a26730d0' AND sortby = '' AND sortorder = 'asc' AND dateline > 1714247337 AND userid = 0 AND completed = 1 ORDER BY dateline DESC LIMIT 1 SELECT title, template FROM vb_template WHERE templateid IN (0,34318,34058,0,34071,34072,34191,34193,34192,33964,34181,34180,34160,34166,34068,34077,33823,7408,7407,8564,34282,0,0,6450,6444,13350,13024,13022,31734,31629,6451,6452,2680,33997,34271,19731,33947,33944,33945,33946,34301,0,0,34281,34242,33967,33968,33970,33971,34194,34313,34295,34245,34246,33794,33793,33797,33362,33358) SELECT moderator.*, user.username, IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid, infractiongroupid FROM vb_moderator AS moderator INNER JOIN vb_user AS user USING(userid) SELECT thread.*,'' as preview,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, user.avatarrevision, customavatar.dateline AS avatardateline, customavatar.width AS width, customavatar.height AS height, customavatar.height_thumb AS height_thumb, customavatar.width_thumb AS width_thumb, customavatar.filedata_thumb, first_user.avatarrevision AS first_avatarrevision, first_avatar.avatarpath AS first_avatarpath, NOT ISNULL(first_customavatar.userid) AS first_hascustomavatar, first_customavatar.dateline AS first_avatardateline, first_customavatar.width AS first_width, first_customavatar.height AS first_height, first_customavatar.height_thumb AS first_height_thumb, first_customavatar.width_thumb AS first_width_thumb, first_customavatar.filedata_thumb AS first_filedata_thumb,lastpost.lastposttime FROM vb_thread AS thread LEFT JOIN vb_user AS user ON (user.userid = thread.lastposterid) LEFT JOIN vb_avatar AS avatar ON (avatar.avatarid = user.avatarid) LEFT JOIN vb_customavatar AS customavatar ON (customavatar.userid = user.userid) LEFT JOIN vb_user AS first_user ON (first_user.userid = thread.postuserid) LEFT JOIN vb_avatar AS first_avatar ON (first_avatar.avatarid = first_user.avatarid) LEFT JOIN vb_customavatar AS first_customavatar ON (first_customavatar.userid = first_user.userid) LEFT JOIN ( SELECT threadid, MAX(dateline) AS lastposttime FROM vb_post WHERE threadid IN (207701,200968,210367,210112,209265,209213,208865,207018,206448,205676,201659,201794,178134,199379,199860,195009,194477,192268,191089,188963) AND userid = 0 GROUP BY threadid ) AS lastpost ON (lastpost.threadid = thread.threadid) WHERE thread.threadid IN (207701,200968,210367,210112,209265,209213,208865,207018,206448,205676,201659,201794,178134,199379,199860,195009,194477,192268,191089,188963) SELECT moderator.*, user.username, IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid, infractiongroupid FROM vb_moderator AS moderator INNER JOIN vb_user AS user USING(userid) SELECT thread.*,'' as preview,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, user.avatarrevision, customavatar.dateline AS avatardateline, customavatar.width AS width, customavatar.height AS height, customavatar.height_thumb AS height_thumb, customavatar.width_thumb AS width_thumb, customavatar.filedata_thumb, first_user.avatarrevision AS first_avatarrevision, first_avatar.avatarpath AS first_avatarpath, NOT ISNULL(first_customavatar.userid) AS first_hascustomavatar, first_customavatar.dateline AS first_avatardateline, first_customavatar.width AS first_width, first_customavatar.height AS first_height, first_customavatar.height_thumb AS first_height_thumb, first_customavatar.width_thumb AS first_width_thumb, first_customavatar.filedata_thumb AS first_filedata_thumb,lastpost.lastposttime FROM vb_thread AS thread LEFT JOIN vb_user AS user ON (user.userid = thread.lastposterid) LEFT JOIN vb_avatar AS avatar ON (avatar.avatarid = user.avatarid) LEFT JOIN vb_customavatar AS customavatar ON (customavatar.userid = user.userid) LEFT JOIN vb_user AS first_user ON (first_user.userid = thread.postuserid) LEFT JOIN vb_avatar AS first_avatar ON (first_avatar.avatarid = first_user.avatarid) LEFT JOIN vb_customavatar AS first_customavatar ON (first_customavatar.userid = first_user.userid) LEFT JOIN ( SELECT threadid, MAX(dateline) AS lastposttime FROM vb_post WHERE threadid IN (187321,181863,181733,178118,91737,166573,163369,157369,154917,147139,125089,124737,125075,123411,112996,91789,92333,94013,93862,92946) AND userid = 0 GROUP BY threadid ) AS lastpost ON (lastpost.threadid = thread.threadid) WHERE thread.threadid IN (187321,181863,181733,178118,91737,166573,163369,157369,154917,147139,125089,124737,125075,123411,112996,91789,92333,94013,93862,92946) SELECT moderator.*, user.username, IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid, infractiongroupid FROM vb_moderator AS moderator INNER JOIN vb_user AS user USING(userid) SELECT thread.*,'' as preview,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, user.avatarrevision, customavatar.dateline AS avatardateline, customavatar.width AS width, customavatar.height AS height, customavatar.height_thumb AS height_thumb, customavatar.width_thumb AS width_thumb, customavatar.filedata_thumb, first_user.avatarrevision AS first_avatarrevision, first_avatar.avatarpath AS first_avatarpath, NOT ISNULL(first_customavatar.userid) AS first_hascustomavatar, first_customavatar.dateline AS first_avatardateline, first_customavatar.width AS first_width, first_customavatar.height AS first_height, first_customavatar.height_thumb AS first_height_thumb, first_customavatar.width_thumb AS first_width_thumb, first_customavatar.filedata_thumb AS first_filedata_thumb,lastpost.lastposttime FROM vb_thread AS thread LEFT JOIN vb_user AS user ON (user.userid = thread.lastposterid) LEFT JOIN vb_avatar AS avatar ON (avatar.avatarid = user.avatarid) LEFT JOIN vb_customavatar AS customavatar ON (customavatar.userid = user.userid) LEFT JOIN vb_user AS first_user ON (first_user.userid = thread.postuserid) LEFT JOIN vb_avatar AS first_avatar ON (first_avatar.avatarid = first_user.avatarid) LEFT JOIN vb_customavatar AS first_customavatar ON (first_customavatar.userid = first_user.userid) LEFT JOIN ( SELECT threadid, MAX(dateline) AS lastposttime FROM vb_post WHERE threadid IN (93004,92744,90502,89612,85856,84023,84082,82145) AND userid = 0 GROUP BY threadid ) AS lastpost ON (lastpost.threadid = thread.threadid) WHERE thread.threadid IN (93004,92744,90502,89612,85856,84023,84082,82145) UPDATE vb_searchlog SET results = 'a:4:{i:0;a:48:{i:0;a:4:{i:0;s:1:\"2\";i:1;s:6:\"207701\";i:2;s:6:\"207701\";i:3;s:10:\"1706901801\";}i:1;a:4:{i:0;s:1:\"2\";i:1;s:6:\"200968\";i:2;s:6:\"200968\";i:3;s:10:\"1692130165\";}i:2;a:4:{i:0;s:1:\"2\";i:1;s:6:\"210367\";i:2;s:6:\"210367\";i:3;s:10:\"1675374420\";}i:3;a:4:{i:0;s:1:\"2\";i:1;s:6:\"210112\";i:2;s:6:\"210112\";i:3;s:10:\"1670518270\";}i:4;a:4:{i:0;s:1:\"2\";i:1;s:6:\"209265\";i:2;s:6:\"209265\";i:3;s:10:\"1643468494\";}i:5;a:4:{i:0;s:1:\"2\";i:1;s:6:\"209213\";i:2;s:6:\"209213\";i:3;s:10:\"1642318150\";}i:6;a:4:{i:0;s:1:\"2\";i:1;s:6:\"208865\";i:2;s:6:\"208865\";i:3;s:10:\"1634664602\";}i:7;a:4:{i:0;s:1:\"2\";i:1;s:6:\"207018\";i:2;s:6:\"207018\";i:3;s:10:\"1591986342\";}i:8;a:4:{i:0;s:1:\"2\";i:1;s:6:\"206448\";i:2;s:6:\"206448\";i:3;s:10:\"1581971807\";}i:9;a:4:{i:0;s:1:\"2\";i:1;s:6:\"205676\";i:2;s:6:\"205676\";i:3;s:10:\"1569647472\";}i:10;a:4:{i:0;s:1:\"2\";i:1;s:6:\"201659\";i:2;s:6:\"201659\";i:3;s:10:\"1522019819\";}i:11;a:4:{i:0;s:1:\"2\";i:1;s:6:\"201794\";i:2;s:6:\"201794\";i:3;s:10:\"1519293707\";}i:12;a:4:{i:0;s:1:\"2\";i:1;s:6:\"178134\";i:2;s:6:\"178134\";i:3;s:10:\"1514393884\";}i:13;a:4:{i:0;s:1:\"2\";i:1;s:6:\"199379\";i:2;s:6:\"199379\";i:3;s:10:\"1501931301\";}i:14;a:4:{i:0;s:1:\"2\";i:1;s:6:\"199860\";i:2;s:6:\"199860\";i:3;s:10:\"1501622134\";}i:15;a:4:{i:0;s:1:\"2\";i:1;s:6:\"195009\";i:2;s:6:\"195009\";i:3;s:10:\"1469300596\";}i:16;a:4:{i:0;s:1:\"2\";i:1;s:6:\"194477\";i:2;s:6:\"194477\";i:3;s:10:\"1466337695\";}i:17;a:4:{i:0;s:1:\"2\";i:1;s:6:\"192268\";i:2;s:6:\"192268\";i:3;s:10:\"1456572287\";}i:18;a:4:{i:0;s:1:\"2\";i:1;s:6:\"191089\";i:2;s:6:\"191089\";i:3;s:10:\"1453710864\";}i:19;a:4:{i:0;s:1:\"2\";i:1;s:6:\"188963\";i:2;s:6:\"188963\";i:3;s:10:\"1442147736\";}i:20;a:4:{i:0;s:1:\"2\";i:1;s:6:\"187321\";i:2;s:6:\"187321\";i:3;s:10:\"1435230517\";}i:21;a:4:{i:0;s:1:\"2\";i:1;s:6:\"181863\";i:2;s:6:\"181863\";i:3;s:10:\"1417171721\";}i:22;a:4:{i:0;s:1:\"2\";i:1;s:6:\"181733\";i:2;s:6:\"181733\";i:3;s:10:\"1417076072\";}i:23;a:4:{i:0;s:1:\"2\";i:1;s:6:\"178118\";i:2;s:6:\"178118\";i:3;s:10:\"1405579401\";}i:24;a:4:{i:0;s:1:\"2\";i:1;s:5:\"91737\";i:2;s:5:\"91737\";i:3;s:10:\"1404593070\";}i:25;a:4:{i:0;s:1:\"2\";i:1;s:6:\"166573\";i:2;s:6:\"166573\";i:3;s:10:\"1390992648\";}i:26;a:4:{i:0;s:1:\"2\";i:1;s:6:\"163369\";i:2;s:6:\"163369\";i:3;s:10:\"1387664531\";}i:27;a:4:{i:0;s:1:\"2\";i:1;s:6:\"157369\";i:2;s:6:\"157369\";i:3;s:10:\"1381255029\";}i:28;a:4:{i:0;s:1:\"2\";i:1;s:6:\"154917\";i:2;s:6:\"154917\";i:3;s:10:\"1378479415\";}i:29;a:4:{i:0;s:1:\"2\";i:1;s:6:\"147139\";i:2;s:6:\"147139\";i:3;s:10:\"1370794980\";}i:30;a:4:{i:0;s:1:\"2\";i:1;s:6:\"125089\";i:2;s:6:\"125089\";i:3;s:10:\"1355577067\";}i:31;a:4:{i:0;s:1:\"2\";i:1;s:6:\"124737\";i:2;s:6:\"124737\";i:3;s:10:\"1354261903\";}i:32;a:4:{i:0;s:1:\"2\";i:1;s:6:\"125075\";i:2;s:6:\"125075\";i:3;s:10:\"1350504089\";}i:33;a:4:{i:0;s:1:\"2\";i:1;s:6:\"123411\";i:2;s:6:\"123411\";i:3;s:10:\"1347740599\";}i:34;a:4:{i:0;s:1:\"2\";i:1;s:6:\"112996\";i:2;s:6:\"112996\";i:3;s:10:\"1330581919\";}i:35;a:4:{i:0;s:1:\"2\";i:1;s:5:\"91789\";i:2;s:5:\"91789\";i:3;s:10:\"1302083733\";}i:36;a:4:{i:0;s:1:\"2\";i:1;s:5:\"92333\";i:2;s:5:\"92333\";i:3;s:10:\"1301416730\";}i:37;a:4:{i:0;s:1:\"2\";i:1;s:5:\"94013\";i:2;s:5:\"94013\";i:3;s:10:\"1298937513\";}i:38;a:4:{i:0;s:1:\"2\";i:1;s:5:\"93862\";i:2;s:5:\"93862\";i:3;s:10:\"1298926598\";}i:39;a:4:{i:0;s:1:\"2\";i:1;s:5:\"92946\";i:2;s:5:\"92946\";i:3;s:10:\"1298563445\";}i:40;a:4:{i:0;s:1:\"2\";i:1;s:5:\"93004\";i:2;s:5:\"93004\";i:3;s:10:\"1297514036\";}i:41;a:4:{i:0;s:1:\"2\";i:1;s:5:\"92744\";i:2;s:5:\"92744\";i:3;s:10:\"1297155372\";}i:42;a:4:{i:0;s:1:\"2\";i:1;s:5:\"90502\";i:2;s:5:\"90502\";i:3;s:10:\"1295524790\";}i:43;a:4:{i:0;s:1:\"2\";i:1;s:5:\"89612\";i:2;s:5:\"89612\";i:3;s:10:\"1292278362\";}i:44;a:4:{i:0;s:1:\"2\";i:1;s:5:\"85856\";i:2;s:5:\"85856\";i:3;s:10:\"1286042421\";}i:45;a:4:{i:0;s:1:\"2\";i:1;s:5:\"84023\";i:2;s:5:\"84023\";i:3;s:10:\"1283105946\";}i:46;a:4:{i:0;s:1:\"2\";i:1;s:5:\"84082\";i:2;s:5:\"84082\";i:3;s:10:\"1283102408\";}i:47;a:4:{i:0;s:1:\"2\";i:1;s:5:\"82145\";i:2;s:5:\"82145\";i:3;s:10:\"1280208945\";}}i:1;i:56;i:2;a:1:{i:2;a:96:{i:0;s:6:\"207701\";i:1;s:6:\"200968\";i:2;s:6:\"210367\";i:3;s:6:\"210112\";i:4;s:6:\"209265\";i:5;s:6:\"209213\";i:6;s:6:\"208865\";i:7;s:6:\"207018\";i:8;s:6:\"206448\";i:9;s:6:\"205676\";i:10;s:6:\"201659\";i:11;s:6:\"201794\";i:12;s:6:\"178134\";i:13;s:6:\"199379\";i:14;s:6:\"199860\";i:15;s:6:\"195009\";i:16;s:6:\"194477\";i:17;s:6:\"192268\";i:18;s:6:\"191089\";i:19;s:6:\"188963\";i:20;s:6:\"187321\";i:21;s:6:\"181863\";i:22;s:6:\"181733\";i:23;s:6:\"178118\";i:24;s:5:\"91737\";i:25;s:6:\"166573\";i:26;s:6:\"163369\";i:27;s:6:\"157369\";i:28;s:6:\"154917\";i:29;s:6:\"147139\";i:30;s:6:\"125089\";i:31;s:6:\"124737\";i:32;s:6:\"125075\";i:33;s:6:\"123411\";i:34;s:6:\"112996\";i:35;s:5:\"91789\";i:36;s:5:\"92333\";i:37;s:5:\"94013\";i:38;s:5:\"93862\";i:39;s:5:\"92946\";i:40;s:5:\"93004\";i:41;s:5:\"92744\";i:42;s:5:\"90502\";i:43;s:5:\"89612\";i:44;s:5:\"85856\";i:45;s:5:\"84023\";i:46;s:5:\"84082\";i:47;s:5:\"82145\";i:48;s:6:\"207701\";i:49;s:6:\"200968\";i:50;s:6:\"210367\";i:51;s:6:\"210112\";i:52;s:6:\"209265\";i:53;s:6:\"209213\";i:54;s:6:\"208865\";i:55;s:6:\"207018\";i:56;s:6:\"206448\";i:57;s:6:\"205676\";i:58;s:6:\"201659\";i:59;s:6:\"201794\";i:60;s:6:\"178134\";i:61;s:6:\"199379\";i:62;s:6:\"199860\";i:63;s:6:\"195009\";i:64;s:6:\"194477\";i:65;s:6:\"192268\";i:66;s:6:\"191089\";i:67;s:6:\"188963\";i:68;s:6:\"187321\";i:69;s:6:\"181863\";i:70;s:6:\"181733\";i:71;s:6:\"178118\";i:72;s:5:\"91737\";i:73;s:6:\"166573\";i:74;s:6:\"163369\";i:75;s:6:\"157369\";i:76;s:6:\"154917\";i:77;s:6:\"147139\";i:78;s:6:\"125089\";i:79;s:6:\"124737\";i:80;s:6:\"125075\";i:81;s:6:\"123411\";i:82;s:6:\"112996\";i:83;s:5:\"91789\";i:84;s:5:\"92333\";i:85;s:5:\"94013\";i:86;s:5:\"93862\";i:87;s:5:\"92946\";i:88;s:5:\"93004\";i:89;s:5:\"92744\";i:90;s:5:\"90502\";i:91;s:5:\"89612\";i:92;s:5:\"85856\";i:93;s:5:\"84023\";i:94;s:5:\"84082\";i:95;s:5:\"82145\";}}i:3;a:1:{i:2;a:0:{}}}' WHERE searchlogid = 369803 SELECT template FROM vb_template WHERE templateid = 33969 SELECT template FROM vb_template WHERE templateid = 33972 SELECT template FROM vb_template WHERE templateid = 33973 UPDATE vb_session SET lastactivity = 1714250937, location = '/tags.php?tag=beleuchtung', inforum = 0, inthread = 0, badlocation = 0, bypass = 0 WHERE sessionhash = '59d5a92a52e683114a835b0f43e2f271'