SQL Query #2

SELECT * FROM datastore
WHERE `title` IN ('options','bitfields','attachmentcache','usergroupcache','stylecache','languagecache','products','cron','profilefield','loadcache','miscoptions','noticecache','hooks','publicoptions','vBUgChannelAccess','vBUgChannelPermissionsFrom','vBChannelTypes')

SQL Query #6

SELECT * FROM routenew
WHERE `prefix` IN ('forum/draft-countdown-forums/team-boards/san-francisco-49ers-team-forum/38403-poll-alex-smith-or-mike-singletary','forum/draft-countdown-forums/team-boards/san-francisco-49ers-team-forum','forum/draft-countdown-forums/team-boards','forum/draft-countdown-forums','forum')

SQL Query #11

SELECT * FROM channel
WHERE `guid` IN ('vbulletin-4ecbdf567f2773.55528984','vbulletin-4ecbdf567f3341.44450667','vbulletin-4ecbdf567f3341.44451100','vbulletin-4ecbdf567f2c35.70389590','vbulletin-4ecbdf567f3a38.99555305','vbulletin-4ecbdf567f3a38.99555306','vbulletin-4ecbdf567f3a38.99555307','vbulletin-c-cmshome5229fa38b251e2.92227401','vbulletin-4ecbdf567f3da8.31769341','vbulletin-4ecbdf567f36c3.90966558','vbulletin-4ecbdf567f3a38.99555303','vbulletin-4ecbdf567f3a38.99555304','vbulletin-4ecbdf567f3a38.99555308')

SQL Query #35

SELECT * FROM phrase
WHERE `varname` IN ('widget_conversationdisplay_widgettitle','system_widgetcat','widget_announcement_widgettitle','display_widgetcat','widget_pagetitle_widgettitle','generic_widgetcat') AND `languageid` IN (1,0,-1)

SQL Query #39

SELECT * FROM phrase
WHERE `varname` IN ('infraction_for_x_y','infraction_for_x_y_in_topic_z','warning_for_x_y','warning_for_x_y_in_topic_z','infraction_topic_post','infraction_topic_profile','infraction_received_ginfraction','warning_received_ginfraction','infraction_received_post','infraction_received_profile','warning_received_post','warning_received_profile','x_days','x_weeks','x_months','x_years','permanent') AND `languageid` IN (1,0,-1)

SQL Query #57

SELECT * FROM searchlog
WHERE `searchhash` IN ('29fc4846c2d25ebfba93f58252e26c79') AND `userid` = 0 AND `dateline` >= 1518938157 AND `sortby` = 'created' AND `sortorder` = 'asc'
ORDER BY `dateline` ASC

SQL Query #66

SELECT * FROM cache
WHERE `cacheid` IN ('node_2754182_lvl1data','node_2754580_lvl1data','node_2754581_lvl1data','node_2754617_lvl1data','node_2754877_lvl1data','node_2755013_lvl1data','node_2755018_lvl1data','node_2755022_lvl1data','node_2760351_lvl1data','node_2760385_lvl1data','node_2760469_lvl1data','node_2760532_lvl1data','node_2760589_lvl1data','node_2760621_lvl1data')

SQL Query #67

SELECT * FROM cache
WHERE `cacheid` IN ('vb_UserWPerms_12452_1','vb_UserWPerms_14824_1','vb_UserWPerms_468_1','vb_UserWPerms_14416_1','vb_UserWPerms_528_1','vb_UserWPerms_15393_1','vb_UserWPerms_15408_1','vb_UserWPerms_9846_1','vb_UserWPerms_471_1')

SQL Query #70

SELECT * FROM cache
WHERE `cacheid` IN ('vBAtchmnts_2754182','vBAtchmnts_2754580','vBAtchmnts_2754581','vBAtchmnts_2754617','vBAtchmnts_2754877','vBAtchmnts_2755013','vBAtchmnts_2755018','vBAtchmnts_2755022','vBAtchmnts_2760351','vBAtchmnts_2760385','vBAtchmnts_2760469','vBAtchmnts_2760532','vBAtchmnts_2760589','vBAtchmnts_2760621')

SQL Query #71

SELECT cl.parent AS nodeid, count(a.nodeid) AS count
FROM closure AS cl
INNER JOIN attach AS a ON (a.nodeid = cl.child)
WHERE cl.parent in (38403,2754182,2754580,2754581,2754617,2754877,2755013,2755018,2755022,2760351,2760385,2760469,2760532,2760589,2760621)
GROUP BY cl.parent
/**getDescendantAttachCount**/

SQL Query #72

SELECT cl.parent AS nodeid, count(child.nodeid) AS count
FROM closure AS cl
INNER JOIN node AS child USE INDEX (nodeid, node_ctypid_userid_dispo_idx) ON (child.nodeid = cl.child)
WHERE cl.parent in (38403,2754182,2754580,2754581,2754617,2754877,2755013,2755018,2755022,2760351,2760385,2760469,2760532,2760589,2760621) AND child.contenttypeid = 33
GROUP BY cl.parent
/**getDescendantPhotoCount**/

SQL Query #75

SELECT * FROM cache
WHERE `cacheid` IN ('node_2754182_lvl3data','node_2754580_lvl3data','node_2754581_lvl3data','node_2754617_lvl3data','node_2754877_lvl3data','node_2755013_lvl3data','node_2755018_lvl3data','node_2755022_lvl3data','node_2760351_lvl3data','node_2760385_lvl3data','node_2760469_lvl3data','node_2760532_lvl3data','node_2760589_lvl3data','node_2760621_lvl3data')

SQL Query #99

SELECT * FROM phrase
WHERE `varname` IN ('login_or_sign_up','you_can_also_login_as','logo','powered_by_vbulletin_title','sections','navbar_home','navbar_draft_countdown','navbar_mock_draft','navbar_player_rankings','navbar_dc_podcast','navbar_todays_posts','navbar_mark_channels_read','home','notice_1_html','announcement','no_announcement','collapse','expand','page_title','posts','latest_activity','search','filter','time','all_time','today','last_week','last_month','show','all','discussions_only','photos_only','videos_only','links_only','polls_only','filtered_by','clear_all','conversation_new_posts','page','of_pagination','previous_page','next_page','votes','votes_lower','click_to_see_who_voted_for_this_option','reputation12','join_date','x_is_offline','last_edited_by_x_on_y_at_z','tags','none','comment','type_your_comment_here','cancel','post','see_previous_comments','see_next_comments','previous','next','navbar_help','navbar_contact_us','go_to_top','powered_by_vbulletin','footer_current_time','working_ellipsis','yes','no','ok') AND `languageid` IN (1,0,-1)

SQL Query #103

SELECT * FROM cache
WHERE `cacheid` IN ('vbnodetext38403_8_0:09f14d73cd828b8c283774e754116338','vbnodetext2754182_8_0:09f14d73cd828b8c283774e754116338','vbnodetext2754580_8_0:09f14d73cd828b8c283774e754116338','vbnodetext2754581_8_0:09f14d73cd828b8c283774e754116338','vbnodetext2754617_8_0:09f14d73cd828b8c283774e754116338','vbnodetext2754877_8_0:09f14d73cd828b8c283774e754116338','vbnodetext2755013_8_0:09f14d73cd828b8c283774e754116338','vbnodetext2755018_8_0:09f14d73cd828b8c283774e754116338','vbnodetext2755022_8_0:09f14d73cd828b8c283774e754116338','vbnodetext2760351_8_0:09f14d73cd828b8c283774e754116338','vbnodetext2760385_8_0:09f14d73cd828b8c283774e754116338','vbnodetext2760469_8_0:09f14d73cd828b8c283774e754116338','vbnodetext2760532_8_0:09f14d73cd828b8c283774e754116338','vbnodetext2760589_8_0:09f14d73cd828b8c283774e754116338','vbnodetext2760621_8_0:09f14d73cd828b8c283774e754116338')

SQL Query #105

SELECT * FROM phrase
WHERE `varname` IN ('debug_information','page_id','page_parent_id','page_template_id','route_id','page_type','screen_layout_id','screen_layout_template','channel_id','node_id','database_asserts','ajax_requests','facebook_active','not_enabled_or_no_appid_secret_set','style_id','templates_renders','parent','css_templates','rollup','js_files','included_files','autoloaded_classes','not_loaded','current_time','page_time') AND `languageid` IN (1,0,-1)