PHP-Code:
SELECT
COUNT(DISTINCT matches.id) AS count
FROM
parent_news_de AS parent
INNER JOIN
matches_de AS matches USING(id)
LEFT JOIN
news_history AS history USING(id)
WHERE matches.key_id IN(1) AND history.kd_id = 28 AND history.id IS NULL ") ;
![dontknow](https://www.php-resource.de/forum/core/images/smilies/fragend013.gif)
Kommentar