SELECT COUNT(*) AS total
FROM EWRrio_streams
LEFT JOIN EWRrio_games ON (EWRrio_games.game_id = EWRrio_streams.game_id)

Run Time: 0.000082

Select Type

Table

Type

Possible Keys

Key

Key Len

Ref

Rows

Extra

SIMPLE

EWRrio_streams

ALL

1

SELECT node.*, COALESCE(options.nat_newwindow, 0) AS nat_newwindow,
permission.cache_value AS node_permission_cache
FROM xf_node AS node
LEFT JOIN xf_permission_cache_content AS permission
ON (permission.permission_combination_id = ?
AND permission.content_type = 'node'
AND permission.content_id = node.node_id)
LEFT JOIN nat_options AS options ON (options.node_id = node.node_id)
WHERE node.node_id IN (92, 93, 95, 89)
ORDER BY node.lft
ASC