Jan
06
2009
Lost Password? No account yet? Register
| Niagara Falls dance club, a magnet for fights, won't reopen | Mixed bag of wintry weather on the way | Upstate business executives say conditions are getting worse | Alma Avenue home heavily damaged in morning fire | Bookkeeper charged with stealing $50,000 from Elma firm | Bus fare hike will cost schools -- but not now | Bills' Edwards sent for 'routine' MRI on shoulder | Buffalo man gets five years for DWI death of friend | Wegmans offering free antibiotics | Sabres defensemen Lydman, Numminen battle flu | Good morning, Buffalo | Manhattan edges Canisius | Niagara men dump Loyola | Rivet to return to Sabres lineup; Connolly aims at weekend | Robber hits Key Bank on Bailey Avenue | Coulter: Drudge got NBC's Today show to rebook me | Colbert welcomes Fox token liberal as 'new sidekick': video | Obama pledges intel chiefs will break controversial tactics | Obama vows 'plenty' to say on Mideast after swearing-in | Doctor: Israel intentionally targeting civilians | Airstrike hits UN school | Tanks storm Gaza | Group: Israel targeted journos | Olbermann: 'Fatuous, lunatic' Cheney failed to prevent 9/11 | Burris avoids Senate confrontation | $240,000 awarded to blogger forced to cover Arab T-shirt | Video shows cop shooting helpless suspect in the back | Franken win official; 'I work for you now' | RNC hopefuls asked: worst GOP president? | Group: Over a dozen lies in Coulter book | Ambulances can't reach Gaza wounded | Palin figure's arrest politically timed? | Sources: Kaine to be new DNC chair | Correction: Gaza video misdated | Richardson with- draws cabinet bid | Israel army moves into Gaza, toll 500+ | Another Palin power abuse? | Bush looks forward to President Jeb | Rice cancels China trip over Gaza | Franken likely Senate winner | African high court gets out gay judge | CNN host uses expletive live on air | 'Financial 9/11' cost US trillions | Iraq assumes control of Green Zone | Bailouts averted 'financial collapse' | Gonzales: I'm a terror war casualty | Neo Nazi videos on YouTube draw fuss | Madoff meets asset deadline | UN resolution calls for Israeli ceasefire | GM to get $4 billion in gov't aid | Czechs take over EU presidency | Slovakia latest to adopt the Euro | Bangkok nightclub inferno kills 60 | A subdued New Year's worldwide | Ex-cop debuts first 'KopBusters' trailer | RNC mulls 'socialism' charge against Bush | US jobless claims dip in holiday week | Economy 'could spark military intervention' | GOP fractures over 'magic Negro'
  • Advertisement
  • Advertisement
  • Advertisement
Old Cover Stories
ol-altcovers.jpg
Filter     Order     Display # 
Date Item Title
Monday, 07 November 2005 Stock Prices, War Profiteering, and the Osprey soars (?) again
Monday, 12 September 2005 Who Wants To Be Mayor?
Wednesday, 03 August 2005 August 6th : Remembering
Wednesday, 03 August 2005 Happy Birthday Atom Bomb
Friday, 08 July 2005 CAFTA: Bush Corporate
Wednesday, 08 June 2005 Good Ol’ American Media & The Downing St. Memo
Friday, 13 May 2005 The Texas City Tragedies: Texas-Sized Denial of Workplace Safety
Monday, 25 April 2005 Bankruptcy Bill Would Thrust Predatory Counseling on the Destitute
Monday, 04 April 2005 Petroeuros and The War on Terror
Wednesday, 09 March 2005 Bush Supports Dictators While Selling Democracy
Friday, 04 February 2005 The State of The Neo-Con Nation
Monday, 17 January 2005 Make Jokes Not War!
 
<< Start < Prev 1 Next > End >>
Results 1 - 12 of 12
[ Back ]
 
33 queries executed
1
SET sql_mode = 'MYSQL40'
2
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'system'
 ORDER BY ordering
3
SELECT template
 FROM jos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 70 )
 ORDER BY menuid DESC
LIMIT 1
4
DELETE FROM jos_session
 WHERE (
 ( time < '1231285554' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1231285554' )
 AND guest = 1
 AND userid = 0
 )
5
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 0
6
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 0
7
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 1
8
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 1
9
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 2
10
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 2
11
SELECT *
 FROM jos_menu
 WHERE id = 70
12
SELECT *
 FROM jos_categories
 WHERE id = '21'
13
SELECT *
 FROM jos_sections
 WHERE id = '1'
14
SELECT c.*, COUNT( b.id ) AS numitems
 FROM jos_categories AS c
 LEFT JOIN jos_content AS b ON b.catid = c.id 
 AND b.state = 1
 AND ( b.publish_up = '0000-00-00 00:00:00' OR b.publish_up <= '2009-01-06 19:00' )
 AND ( b.publish_down = '0000-00-00 00:00:00' OR b.publish_down >= '2009-01-06 19:00' )
 AND b.access <= 0
 WHERE c.section = '1'
 AND c.published = 1
 AND c.access <= 0
 GROUP BY c.id
 HAVING COUNT( b.id ) > 0
 ORDER BY c.ordering
15
SELECT COUNT(a.id) as numitems
 FROM jos_content AS a
 LEFT JOIN jos_users AS u ON u.id = a.created_by
 LEFT JOIN jos_groups AS g ON a.access = g.id
 WHERE a.catid = 21
 AND a.state = 1
 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2009-01-06 19:00' )
 AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2009-01-06 19:00' )
 AND a.access <= 0
 AND 0 <= 0
 ORDER BY a.created DESC
16
SELECT a.id, a.title, a.hits, a.created_by, a.created_by_alias, a.created AS created, a.access, u.name AS author, a.state, g.name AS groups
 FROM jos_content AS a
 LEFT JOIN jos_users AS u ON u.id = a.created_by
 LEFT JOIN jos_groups AS g ON a.access = g.id
 WHERE a.catid = 21
 AND a.state = 1
 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2009-01-06 19:00' )
 AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2009-01-06 19:00' )
 AND a.access <= 0
 AND 0 <= 0
 ORDER BY a.created DESC
LIMIT 50
17
SELECT a.*
 FROM jos_components AS a
 WHERE ( a.admin_menu_link = 'option=com_syndicate' OR a.admin_menu_link = 'option=com_syndicate&hidemainmenu=1' )
 AND a.option = 'com_syndicate'
18
SELECT id, title, module, position, content, showtitle, params
 FROM jos_modules AS m
 INNER JOIN jos_modules_menu AS mm ON mm.moduleid = m.id
 WHERE m.published = 1
 AND m.access <= 0
 AND m.client_id != 1
 AND ( mm.menuid = 0 OR mm.menuid = 70 )
 ORDER BY ordering
19
SELECT name, link, numarticles, cache_time, id
FROM jos_newsfeeds
WHERE published='1' AND checked_out='0'
ORDER BY ordering
20
SELECT id
 FROM jos_menu
 WHERE link = 'index.php?option=com_search'
 AND published = 1
21
SELECT m.* FROM jos_menu AS m WHERE menutype='mainmenu' AND published = 1 AND access <= 0 ORDER BY ordering
22
SELECT * FROM jos_sections WHERE id = 1 ORDER BY title, id
23
SELECT cat.* FROM jos_categories AS cat, jos_sections AS sect WHERE section = 1 AND cat.section = sect.id ORDER BY title, id
24
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'leftmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
25
SELECT a.id, a.title, a.sectionid, a.catid
 FROM jos_content AS a
 LEFT JOIN jos_content_frontpage AS f ON f.content_id = a.id
 INNER JOIN jos_categories AS cc ON cc.id = a.catid
 INNER JOIN jos_sections AS s ON s.id = a.sectionid
 WHERE ( a.state = 1 AND a.sectionid > 0 )
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2009-01-06 19:00' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2009-01-06 19:00' )
 AND a.access <= 0 AND cc.access <= 0 AND s.access <= 0
 AND s.published = 1
 AND cc.published = 1
 ORDER BY a.created DESC
LIMIT 6
26
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN jos_categories AS c ON i.catid = c.id
 LEFT JOIN jos_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 545
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
27
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN jos_categories AS c ON i.catid = c.id
 LEFT JOIN jos_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 544
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
28
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN jos_categories AS c ON i.catid = c.id
 LEFT JOIN jos_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 543
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
29
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN jos_categories AS c ON i.catid = c.id
 LEFT JOIN jos_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 542
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
30
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN jos_categories AS c ON i.catid = c.id
 LEFT JOIN jos_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 541
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
31
SELECT ms.id AS sid, ms.type AS stype, mc.id AS cid, mc.type AS ctype, i.id as sectionid, i.id As catid, ms.published AS spub, mc.published AS cpub
 FROM jos_content AS i
 LEFT JOIN jos_sections AS s ON i.sectionid = s.id
 LEFT JOIN jos_menu AS ms ON ms.componentid = s.id 
 LEFT JOIN jos_categories AS c ON i.catid = c.id
 LEFT JOIN jos_menu AS mc ON mc.componentid = c.id 
 WHERE ( ms.type IN ( 'content_section', 'content_blog_section' ) OR mc.type IN ( 'content_blog_category', 'content_category' ) )
 AND i.id = 540
 ORDER BY ms.type DESC, mc.type DESC, ms.id, mc.id
32
SELECT MONTH( created ) AS created_month, created, id, sectionid, title, YEAR(created) AS created_year
 FROM jos_content
 WHERE ( state = -1 AND checked_out = 0 AND sectionid > 0 )
 GROUP BY created_year DESC, created_month DESC
LIMIT 99
33
SELECT *
 FROM jos_banner
 WHERE showBanner=1 
 AND cid IN ( 1,2,3 )
 ORDER BY RAND()