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 userid = 0 AND host = '' 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,2511,1899,1862,1861,1848,1849,1850,1852,1851,1895,1896,1900,1898,1897,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,1636,1880,1881,2973) SELECT userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline, customavatar.width AS avwidth, customavatar.height AS avheight, customavatar.height_thumb AS avheight_thumb, customavatar.width_thumb AS avwidth_thumb, customavatar.filedata_thumb, customprofilepic.userid AS profilepic, customprofilepic.dateline AS profilepicdateline, customprofilepic.width AS ppwidth, customprofilepic.height AS ppheight , blog_user.bloguserid, blog_user.entries, blog_user.options AS blog_options, blog_user.subscribeown AS blog_subscribeown, blog_user.subscribeothers AS blog_subscribeothers, blog_user.title AS blog_title, blog_user.description AS blog_description, blog_user.allowsmilie AS blog_allowsmilie, blog_user.draft AS blog_draft, blog_user.pending AS blog_pending, blog_user.options_everyone, blog_user.options_buddy, blog_user.options_ignore, blog_user.uncatentries, blog_user.moderation AS blog_moderation, blog_user.deleted AS blog_deleted, blog_user.akismet_key AS blog_akismet_key, isblogmoderator, blog_user.comments_moderation AS blog_comments_moderation, blog_user.lastblog, blog_user.lastblogid, blog_user.lastblogtitle FROM vb_user AS user LEFT JOIN vb_userfield AS userfield ON (user.userid = userfield.userid) LEFT JOIN vb_usertextfield AS usertextfield ON (usertextfield.userid = user.userid) 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_customprofilepic AS customprofilepic ON (user.userid = customprofilepic.userid) LEFT JOIN vb_blog_user AS blog_user ON (blog_user.bloguserid = user.userid) WHERE user.userid = 212 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_category.* FROM vb_blog_category AS blog_category WHERE userid = 212 ORDER BY displayorder 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_everyone & 1 AND state IN('visible') AND dateline >= 1590267600 AND dateline < 1591202420 AND blog.userid = 212 GROUP BY period SELECT blog.blogid, lastblogtextid AS blogtextid, blog_text.userid, blog_text.state, IF(blog_text.userid = 0, blog_text.username, user.username) AS username, blog.blogid, blog.title FROM vb_blog AS blog LEFT JOIN vb_blog_text AS blog_text ON (blog.lastblogtextid = blog_text.blogtextid) LEFT JOIN vb_user AS user ON (blog_text.userid = user.userid) WHERE blog.userid = 212 AND blog_text.blogtextid <> blog.firstblogtextid AND blog_text.state IN ('visible') AND blog.state IN ('visible') AND blog.dateline <= 1591202420 AND blog.pending = 0 ORDER BY blog.lastcomment DESC LIMIT 5 SELECT SQL_CALC_FOUND_ROWS attach, blog.blogid, dateline, blog.rating FROM vb_blog AS blog LEFT JOIN vb_blog_user AS blog_user ON (blog_user.bloguserid = blog.userid) WHERE blog.userid = 212 AND state IN('visible') AND blog.pending = 0 AND dateline <= 1591202420 ORDER BY dateline DESC LIMIT 0, 5 SELECT FOUND_ROWS() SELECT blogid, title, blog_category.blogcategoryid, blog_categoryuser.userid FROM vb_blog_categoryuser AS blog_categoryuser LEFT JOIN vb_blog_category AS blog_category ON (blog_category.blogcategoryid = blog_categoryuser.blogcategoryid) WHERE blogid IN (110) ORDER BY blogid, displayorder