-- to get articles from MediaWiki CMS: Let's call it STATEMENT1
SELECT
		wikimedia_page.page_id AS PageID,
		CONVERT(wikimedia_page.page_title USING latin1) AS PageTitle,
		CONVERT(wikimedia_text.old_text USING latin1) AS PageContent
	FROM
		wikimedia_page
	LEFT JOIN (
		wikimedia_revision, wikimedia_text)
	ON
		wikimedia_page.page_latest=wikimedia_revision.rev_id
	WHERE 
		wikimedia_page.page_namespace=0
		AND wikimedia_revision.rev_text_id=wikimedia_text.old_id
		AND wikimedia_text.old_text''
		AND wikimedia_page.page_is_redirect=0

-- yields: let's call it MyTable1: Query time: 0.187s.  880 rows returned.
PageID           PageTitle          PageContent
---------------- ------------------ ---------------------
1144             7911_and_7912_t... ==Description==...

1.  -- to get articles from MediaWiki CMS: Let's call it STATEMENT1 
2.  SELECT 
3.          wikimedia_page.page_id AS PageID, 
4.          CONVERT(wikimedia_page.page_title USING latin1) AS PageTitle, 
5.          CONVERT(wikimedia_text.old_text USING latin1) AS PageContent 
6.      FROM 
7.          wikimedia_page 
8.      LEFT JOIN ( 
9.          wikimedia_revision, wikimedia_text) 
10.      ON 
11.          wikimedia_page.page_latest=wikimedia_revision.rev_id 
12.      WHERE 
13.          wikimedia_page.page_namespace=0 
14.          AND wikimedia_revision.rev_text_id=wikimedia_text.old_id 
15.          AND wikimedia_text.old_text'' 
16.          AND wikimedia_page.page_is_redirect=0 
17.   
18.  -- yields: let's call it MyTable1: Query time: 0.187s.  880 rows returned. 
19.  PageID           PageTitle          PageContent 
20.  ---------------- ------------------ --------------------- 
21.  1144             7911_and_7912_t... ==Description==... 

-- to get a row from my custom audit table
SELECT
   ApprovalID, ArticleID, DateSigned
FROM
   Audit_Publishing
WHERE 
   ArticleID IS NOT NULL


-- yields: let's call it MyTable2: Query time: 0.016s.  4367 rows returned.
ApprovalID       ArticleID          DateSigned
---------------- ------------------ ---------------------
17               1144               2010-06-18 12:25:22

1.  -- to get a row from my custom audit table 
2.  SELECT 
3.     ApprovalID, ArticleID, DateSigned 
4.  FROM 
5.     Audit_Publishing 
6.  WHERE 
7.     ArticleID IS NOT NULL 
8.   
9.   
10.  -- yields: let's call it MyTable2: Query time: 0.016s.  4367 rows returned. 
11.  ApprovalID       ArticleID          DateSigned 
12.  ---------------- ------------------ --------------------- 
13.  17               1144               2010-06-18 12:25:22 

-- STATEMENT2
SELECT  PageID, PageTitle, PageContent
FROM    MyTable1
WHERE   PageID NOT IN (SELECT ArticleID FROM MyTable2)

1.  -- STATEMENT2 
2.  SELECT  PageID, PageTitle, PageContent 
3.  FROM    MyTable1 
4.  WHERE   PageID NOT IN (SELECT ArticleID FROM MyTable2) 

-- STATEMENT3
SELECT PageID, PageTitle, PageContent
FROM   MyTable1
WHERE  NOT EXISTS
  (SELECT ArticleID
   FROM   MyTable2
   WHERE  MyTable2.ArticleID = MyTable1.PageID)

1.  -- STATEMENT3 
2.  SELECT PageID, PageTitle, PageContent 
3.  FROM   MyTable1 
4.  WHERE  NOT EXISTS 
5.    (SELECT ArticleID 
6.     FROM   MyTable2 
7.     WHERE  MyTable2.ArticleID = MyTable1.PageID) 

-- STATEMENT4
SELECT PageID, PageTitle, PageContent 
FROM   MyTable1
LEFT OUTER JOIN MyTable2
  ON (MyTable1.PageID= MyTable2.ArticleID)
  WHERE MyTable2.ArticleID IS NULL

1.  -- STATEMENT4 
2.  SELECT PageID, PageTitle, PageContent 
3.  FROM   MyTable1 
4.  LEFT OUTER JOIN MyTable2 
5.    ON (MyTable1.PageID= MyTable2.ArticleID) 
6.    WHERE MyTable2.ArticleID IS NULL