Witam.
Mam dwa zapytania do bazy:

[SQL] pobierz, plaintext 
SELECT *, (MATCH(tresc) AGAINST('$q2'IN BOOLEAN MODE)) AS `score` FROM m_news 
WHERE MATCH(tresc) AGAINST('$q2' IN BOOLEAN MODE) ORDER BY score DESC LIMIT $start, $perPage
[SQL] pobierz, plaintext 

i

[SQL] pobierz, plaintext 
SELECT COUNT(*) FROM k_news c WHERE (c.m_id = n.id)
[SQL] pobierz, plaintext 

i jak je łączę tak:

[SQL] pobierz, plaintext 
SELECT n.*, (MATCH(tresc) AGAINST('$q2'IN BOOLEAN MODE)) AS `score`,
(SELECT COUNT(*) FROM k_news c WHERE (c.m_id = n.id)) AS `kom` 
FROM m_news 
WHERE MATCH(tresc) AGAINST('$q2' IN BOOLEAN MODE) ORDER BY score DESC LIMIT $start, $perPage
[SQL] pobierz, plaintext 

to nie działa. Co robię źle

a jaka jest tresc bledu?

SELECT n.*, (MATCH(n.tresc) AGAINST('$q2'IN BOOLEAN MODE)) AS `score`,
(SELECT COUNT(*) FROM k_news c WHERE (c.m_id = n.id)) AS `kom`
FROM m_news n
WHERE MATCH(n.tresc) AGAINST('$q2' IN BOOLEAN MODE) ORDER BY score DESC LIMIT $start, $perPage

ps. nie łatwiej to przez LEFT JOIN zrobić ?