10252014Sat
×

Error

Incorrect key file for table '/dev/shm/#sql_153c_28.MYI'; try to repair it SQL=SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM uoegd_content AS a LEFT JOIN uoegd_categories AS c ON c.id = a.catid LEFT JOIN uoegd_users AS ua ON ua.id = a.created_by LEFT JOIN uoegd_users AS uam ON uam.id = a.modified_by LEFT JOIN uoegd_categories as parent ON parent.id = c.parent_id LEFT JOIN uoegd_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM uoegd_categories AS cat JOIN uoegd_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id INNER JOIN uoegd_content_frontpage AS fp ON fp.content_id = a.id WHERE a.access IN (1,1) AND c.access IN (1,1) AND CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2014-10-25 22:05:40') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2014-10-25 22:05:40') ORDER BY a.created DESC , a.created DESC LIMIT 120, 30

Search

Act of Cowardice

Iran's ruling tyrants have executed yet another political prisoner in flagrant violation of international law.  READ MORE

The rush to Tehran amidst rise in executions

World leaders should halt these visits and link any deal with Iran to its human rights record.  READ MORE

Arming a dictator

What if President Obama ordered the sale of arms to Syrian dictator to massacre his opponents? READ MORE

Slaughter intensifies under Rouhani

231 executions have occurred since the presidential election in June which brought to power Hassan Rouhani. READ MORE

Exclusive Reports

Silence is not the answer

Iran: Bloody crackdown targeting dissidents aims at terrorizing the people into submission. READ MORE

Iran’s Murder Machine

The wheels of Iran's Murder Machine turn in tandem with its nuclear machine. READ MORE

What now?

The West must drop the dangerous pretence that talking to a regime not interested in listening constitutes the winning strategy. READ MORE

A facelift

This cosmetic facelift should not dupe the West into thinking that there are fresh prospects for a nuclear deal. READ MORE

An Act of Cowardice

The terrorist attack against Iranian exiles at Camp Liberty, Iraq, is another sign of Iranian regime's weakness. READ MORE

Much atalk about nothing

In Istanbul they merely agreed to talk about talking later in May in Baghdad, of all places. READ MORE

An unholy alliance

The brutal state-imposed bloodbath in Syria deserves uncompromising reproach. READ MORE

Iran cries for freedom

The clerical regime in Iran has predictably unleashed another wave of terror against the citizenry since the outburst of the latest string of mass protests beginning on 14 February. READ MORE

A new Iran policy

The latest round of nuclear talks had an all-too-familiar result: more time for Tehran and less time for the international community to prevent a nuclear-armed theocracy. READ MORE

Murder overlooked

What would the rest of us do if a mad gunman was in our midst, systematically murdering our fellow human beings in front of our eyes? The responsible amongst us would not look the other way, because that would serve as a source of encouragement for the murderers to carry on with their heinous acts unchecked. READ MORE

Standing up to Iran's executioners

The Iranian regime's malicious noose has yet again taken an innocent life. Political prisoner Ali Saremi, 63, was hanged in Tehran's infamous Evin prison after a lifetime of peacefully espousing human rights and democracy. READ MORE