Recent posts
query
SELECT node.nid, node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp_last_comment_timestamp, node.type AS node_type, node.title AS node_title, node.changed AS node_changed, users.name AS users_name, users.uid AS users_uid, node_comment_statistics.comment_count AS node_comment_statistics_comment_count, node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp FROM {node} node LEFT JOIN {node_comment_statistics} node_comment_statistics ON node.nid = node_comment_statistics.nid INNER JOIN {users} users ON node.uid = users.uid WHERE (node.status = '1') ORDER BY node_comment_statistics_last_comment_timestamp_last_comment_timestamp DESC
countquery
SELECT count(node.nid) FROM {node} node LEFT JOIN {node_comment_statistics} node_comment_statistics ON node.nid = node_comment_statistics.nid INNER JOIN {users} users ON node.uid = users.uid WHERE (node.status = '1')
summary
NULL
level
NULL
args
Array
(
[0] => node
[1] => status
[2] => =
[3] => 1
)
