|
|
 
         |
|
IRAQ ON THE RECORD
Prepared at the direction of Rep. Henry A. Waxman, Iraq on the Recordis a searchable collection of 237 specific misleading statements made by Bush Administration officials about the threat posed by Iraq.
more »
Patriot Act Primer
Key Documents & Links Relating to the USA Patriot Act. Compiled by Washingtonpost.com November 3, 2005
more »
Book of the Month
IMAGINE NO SUPERSTITION
The Power to Enjoy Life With No Guilt, No Shame, No Blame
by Stephen F. Uhl
more »
|
|
 |
 |
|
?
8 queries, seconds
SELECT * FROM _journals WHERE journal_id=1 = 1 (fetching journal info)
SELECT * FROM _sections WHERE journal_rid=1 AND is_cover=1 AND language='en' = 0 (fetching cover section for language "en")
SELECT * FROM _sections WHERE journal_rid=1 AND is_cover=1 AND language='' = 1 (fetching cover section for language "")
SELECT name,section_id FROM _sections WHERE journal_rid=1 AND hidden!=1 AND parent_section_rid=0 AND ( language="" OR language="en" ) ORDER BY ordering = 18 (fetching visible top sections)
SELECT * FROM _sections WHERE section_id=1 = 1 (fetching section)
SELECT art.article_id, art.title, art.photo, art.intro, CHAR_LENGTH(art.text) AS textcount, art.date, art.commentable, art.date, artsec.expiry_date, auth.name AS author_name, COUNT(comm.comment_id) AS commentnum , sec.section_id FROM _articles AS art LEFT JOIN _authors AS auth ON auth.author_id=art.author_rid LEFT JOIN _comments AS comm ON comm.article_rid=art.article_id , _articlesections AS artsec, _sections AS sec WHERE artsec.article_rid = art.article_id AND sec.section_id = artsec.section_rid AND artsec.section_rid = 1 AND (art.language = 'en' OR art.language = '') AND art.date>="2010-09-01" AND art.date<"2010-10-01" GROUP BY art.article_id ORDER BY art.date DESC LIMIT 0,9999 = 0 (fetching article list)
SELECT art.article_id,art.title,art.intro,LENGTH(art.text) AS text,DATE_FORMAT(art.date,"d-M-y, h:i a") AS date FROM _articles AS art, _articlesections AS artsec, _sections AS sec WHERE artsec.article_rid=art.article_id AND artsec.section_rid=sec.section_id AND sec.journal_rid=1 AND sec.name LIKE "%_NEWS_%" AND (sec.language='en' OR sec.language='') = 4 (fetching news boxes)
SELECT section_id,name FROM _sections WHERE journal_rid=1 AND parent_section_rid = 1 AND hidden=0 ORDER BY ordering = 0 (fetching subsection list)
