Re: Slow Subquery - Optimization in this simple query needed

[Björn Steinbrink]

SELECT
    *
FROM
    `newsme_groups_users` AS a
INNER JOIN
    `newsme_users` AS b ON b.userID = a.gUID
LEFT JOIN
    `newsme_letters_logs` AS c ON c.logEMAIL = b.userEMAIL and c.logLID = '25'
WHERE
    a.gGID IN (25, 26, 27) AND
    b.userACTIVE = '1' AND
    c.logEMAIL IS NULL
LIMIT
    100

Edited 1 time(s). Last edit at 04/04/2007 08:30AM by Björn Steinbrink.