MySQL - Group by und Count

[omata]

Hier noch ein Versuch...

SQL-Code:

SELECT SUM(anzahl) AS anzahl
FROM (SELECT COUNT(*) AS anzahl
      FROM articles a
      INNER JOIN articles_data ad
        ON a.article_id = ad.article_id
      WHERE ad.show_flag = 0
        AND ad.active = 1
        AND (   a.text LIKE '%blubb%'
             OR a.title LIKE '%blubb%')
      GROUP BY a.article_id, a.title) x

Gruss
Thorsten