- 01
- 02
- 03
- 04
- 05
- 06
- 07
- 08
- 09
- 10
# Query_time: 1 Lock_time: 0 Rows_sent: 50807 Rows_examined: 160282
SELECT `node`.id, (
TO_DAYS( NOW( ) ) - TO_DAYS( `node`.datecreate )
) AS countDay, (
`rating_node`.up - `rating_node`.down
) AS countRating, COUNT( `comments`.cid ) AS countComments, `node`.view AS countViews
FROM node
LEFT JOIN `rating_node` ON `rating_node`.node_id = `node`.id
LEFT JOIN `comments` ON `comments`.nid = `node`.id
GROUP BY `node`.id;