SET @@sql_mode = ''
SELECT *
FROM vb_datastore
WHERE title IN ('smiliecache','bbcodecache','blogcategorycache','blogstats','blogfeatured_settings','blogfeatured_entries','blogtagcloud','navdata','navdata','attachmentcache','cron','profilefield','loadcache','noticecache','activitystream','routes')
SELECT *
FROM vb_session
WHERE sessionhash = 'b4a04656254743e1dcdc89e56d42cbb7'
AND lastactivity > 1714249733
AND idhash = '3f22185ad132012eb06eaaea3c9668dc'
SELECT *
FROM vb_session
WHERE userid = 0
AND host = '18.119.111.9'
AND idhash = '3f22185ad132012eb06eaaea3c9668dc'
LIMIT 1
SELECT languageid,
phrasegroup_global AS phrasegroup_global,
phrasegroup_posting AS phrasegroup_posting,
phrasegroup_vbblogglobal AS phrasegroup_vbblogglobal,
phrasegroup_postbit AS phrasegroup_postbit,
phrasegroup_vbblogcat AS phrasegroup_vbblogcat,
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 = 'cms_priv_user_0'
SELECT bm.userid, bm.permissions, bm.type, user.username
FROM vb_blog_moderator AS bm
INNER JOIN vb_user AS user USING (userid)
SELECT title, template
FROM vb_template
WHERE templateid IN (33285,33320,33388,33337,33283,33282,33281,33798,33796,33287,33345,33346,33347,33348,33365,33366,33367,33371,33806,33385,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,33358)
SELECT COUNT(*) AS total,
FROM_UNIXTIME(dateline - 0, '%c-%e-%Y') AS period
FROM vb_blog AS blog
LEFT JOIN vb_blog_user AS blog_user ON (blog_user.bloguserid = blog.userid)
WHERE options_guest & 1 AND ~blog.options & 8 AND state IN('visible') AND dateline >= 1711234800 AND dateline < 1714250933
GROUP BY period
SELECT MAX(dateline) AS dateline
FROM vb_blog AS blog
LEFT JOIN vb_blog_user AS blog_user ON (blog_user.bloguserid = blog.userid)
WHERE options_guest & 1 AND ~blog.options & 8 AND state IN('visible') AND dateline <= 1711922399
SELECT SQL_CALC_FOUND_ROWS
user.*,
blog.firstblogtextid,
blog_text.pagetext,
IF (blog_user.title <> '', blog_user.title, user.username) AS blogtitle,
IF (blog_user.ratingnum >= 10, blog_user.rating, 0) AS order_rating,
blog_user.lastblog, blog_user.lastblogid AS lastblogid, blog_user.lastblogtitle,
blog_user.lastcomment, blog_user.lastblogtextid AS lastblogtextid, blog_user.lastcommenter,
blog_user.ratingnum, blog_user.ratingtotal, blog_user.title, blog_user.entries, blog_user.comments, blog_user.title, blog.categories,
blog2.categories AS categories_lastcomment,
IF(user.displaygroupid = 0, user.usergroupid, user.displaygroupid) AS displaygroupid, infractiongroupid, options_ignore, options_buddy, options_member, options_guest
,avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight
FROM vb_blog_user AS blog_user
INNER JOIN vb_user AS user ON (blog_user.bloguserid = user.userid)
LEFT JOIN vb_blog AS blog ON (blog.blogid = blog_user.lastblogid)
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_blog_text AS blog_text ON (blog_text.blogtextid = blog_user.lastblogtextid)
LEFT JOIN vb_blog AS blog2 ON (blog2.blogid = blog_text.blogid)
WHERE options_guest & 1
AND blog_user.lastblog > 0
AND blog_user.entries > 0
ORDER BY blog_user.lastblog DESC
LIMIT 0, 15
SELECT FOUND_ROWS()
UPDATE vb_session
SET lastactivity = 1714250933, location = '/blog/blog.php?do=bloglist', badlocation = 0
WHERE sessionhash = 'b165e57cdbce40cbbd9b157c64952ba9'
A4-Freunde.COMmunity - Dein Forum zum Thema Audi A4 - Blogliste - Blogs
Archiv
