No announcement yet.

SQL query--where is it coming from?

  • Filter
  • Time
  • Show
Clear All
new posts

  • SQL query--where is it coming from?

    I've asked before, but I would like to know which part of vB this query is from:

    SELECT COUNT(*) AS threads, SUM(IF(lastpost>=1112638723 AND open<>10,1,0)) AS newthread FROM thread AS thread LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread') WHERE forumid = 2 AND sticky = 0 AND visible = 1 AND deletionlog.primaryid IS NULL
    Whenever this one shows up while I'm monitoring the database using mytop, there can sometimes be several of these stacked up with long delays in the queue (stale queries over a minute old, sometimes). I'm just trying to see if this is tied to some unneeded feature I could disable.
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.