SET @@sql_mode = '' SELECT * FROM vb_datastore WHERE title IN ('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache','noticecache','smiliecache','bbcodecache','blogstats','blogfeatured') SELECT * FROM vb_session WHERE sessionhash = '258ebc482b2a53197b460d09b3cb0704' AND lastactivity > 1591203252 AND idhash = '4ab9e77a4bfd302ea544fb496d8a64e2' SELECT * FROM vb_session WHERE userid = 0 AND host = '18.207.254.88' AND idhash = '4ab9e77a4bfd302ea544fb496d8a64e2' LIMIT 1 SELECT languageid, phrasegroup_global AS phrasegroup_global, phrasegroup_posting AS phrasegroup_posting, phrasegroup_vbblogglobal AS phrasegroup_vbblogglobal, phrasegroup_postbit AS phrasegroup_postbit, 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 * FROM vb_style WHERE (styleid = 1 AND userselect = 1) OR styleid = 1 ORDER BY styleid ASC LIMIT 1 SELECT title, template FROM vb_template WHERE templateid IN (2543,1851,1862,1848,1849,1850,1852,2521,1893,1894,1834,1902,1835,794,1900,1898,1897,1895,1896,1829,1830,1831,1832,1913,1930,2535,3047,3046,3048,3043,3042,3320,798,3272,3273,3274,3540,3543,3552,3293,3294,3295,3296,3494,3557,2522,3558,3561,2532,3115,3112,3111,3128,3113,3114,3116,3117,3118,3119,3072,3074,3076,546,3286,3282,1347,3285,3355,3356,3287,3283,3541,1636,1880,1881,1829,1830,1831,1832,2973) SELECT bm.userid, bm.permissions, bm.type, user.username FROM vb_blog_moderator AS bm INNER JOIN vb_user AS user USING (userid) SELECT blog.*, blog.options AS blogoptions, blog_text.pagetext, blog_text.allowsmilie, blog_text.ipaddress, blog_text.reportthreadid, blog_text.ipaddress AS blogipaddress, blog_editlog.userid AS edit_userid, blog_editlog.dateline AS edit_dateline, blog_editlog.reason AS edit_reason, blog_editlog.username AS edit_username, blog_textparsed.pagetexthtml, blog_textparsed.hasimages, user.*, userfield.*, usertextfield.*, blog.userid AS userid, blog_user.title AS blog_title, blog_user.description AS blog_description, blog_user.allowsmilie AS blog_allowsmilie, blog_user.akismet_key AS akismet_key, blog_user.options_everyone, blog_user.options_buddy, blog_user.options_ignore, blog_user.entries, blog_user.isblogmoderator, blog_user.comments_moderation AS blog_comments_moderation, blog_user.draft AS blog_draft, blog_user.pending AS blog_pending, blog_user.uncatentries, blog_user.moderation AS blog_moderation, blog_user.deleted AS blog_deleted, customprofilepic.userid AS profilepic, customprofilepic.dateline AS profilepicdateline, customprofilepic.width AS ppwidth, customprofilepic.height AS ppheight, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid , avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline, customavatar.width AS avwidth, customavatar.height AS avheight FROM vb_blog AS blog INNER JOIN vb_blog_text AS blog_text ON (blog_text.blogtextid = blog.firstblogtextid) LEFT JOIN vb_user AS user ON (blog.userid = user.userid) LEFT JOIN vb_userfield AS userfield ON(userfield.userid = user.userid) LEFT JOIN vb_usertextfield AS usertextfield ON(usertextfield.userid = user.userid) LEFT JOIN vb_blog_editlog AS blog_editlog ON (blog_editlog.blogtextid = blog.firstblogtextid) LEFT JOIN vb_blog_textparsed AS blog_textparsed ON (blog_textparsed.blogtextid = blog.firstblogtextid AND blog_textparsed.styleid = 1 AND blog_textparsed.languageid = 3) LEFT JOIN vb_blog_user AS blog_user ON (blog_user.bloguserid = user.userid) LEFT JOIN vb_customprofilepic AS customprofilepic ON (user.userid = customprofilepic.userid) LEFT JOIN vb_avatar AS avatar ON (avatar.avatarid = user.avatarid) LEFT JOIN vb_customavatar AS customavatar ON (customavatar.userid = user.userid) WHERE blog.blogid = 35