Originally Posted by Old Pedant
SELECT P2.title AS page_title, pac2_notifications.*
LEFT JOIN (
SELECT DISTINCT title FROM pac2_titles
WHERE uri = '/demo.php' ) AS P2
ON pac2_notifications.what = P2.title
WHERE what = '/demo.php' AND email != 'email@example.com'
This is the results from the query :
I'm not sure it needs to be DISTINCT, I'm just in the process of testing this comment script so the database does not have a lot of entries.
I'll have to do some more tests to see if identical records appear to have a better understanding how this script is operating.