Kod
SELECT n.*, COUNT(c.id) AS commentscount FROM news AS n LEFT JOIN
comments AS c ON (c.what = 'N' AND c.wid = n.id) WHERE n.nday != 1 GROUP
BY n.id ORDER BY n.time DESC LIMIT 0, 10;
# Query_time: 193 Lock_time: 0 Rows_sent: 10 Rows_examined: 43757843
comments AS c ON (c.what = 'N' AND c.wid = n.id) WHERE n.nday != 1 GROUP
BY n.id ORDER BY n.time DESC LIMIT 0, 10;
# Query_time: 193 Lock_time: 0 Rows_sent: 10 Rows_examined: 43757843
co jest z tym nie tak, że tyle wierszy mi sprawdza?