SELECT ignore_thread.*, thread.*
,
NULL AS thread_read_date
FROM xf_ignore_thread AS ignore_thread
LEFT JOIN xf_thread AS thread ON (thread.thread_id = ignore_thread.thread_id)
WHERE ignore_thread.user_id = ?
ORDER BY ignore_thread.ignore_time DESC

Params: 0

Run Time: 0.000308

Select Type

Table

Type

Possible Keys

Key

Key Len

Ref

Rows

Extra

SIMPLE

ignore_thread

ref

user_thread

user_thread

4

const

1

Using where; Using filesort

SIMPLE

thread

eq_ref

PRIMARY

PRIMARY

4

jfuqua_gotitans.ignore_thread.thread_id

1

SELECT COUNT(*)
FROM xf_thread AS thread
WHERE ((thread.node_id = 35) AND (thread.sticky = 0) AND (thread.discussion_state IN ('visible')))