Convicts were able to force the Venezuelan government to transfer more than 2,500 detainees to their prison for the express purpose of collecting extortion payments from them in a case that illustrates the dangerous lack of official control over the country’s penitentiary system.
A peace agreement between Colombia's government and the country’s largest rebel army has been reached, and while the end of the five-decade old civil war has immense political and social implications, it's not clear what is going to happen to the criminal economies that have sustained thousands of rebels.
Repeated blockades by coca farmers in Colombia are stopping state agents from eradicating their crops, in a reminder of the challenges the authorities face in implementing the eradication and substitution plan developed during peace talks with the FARC guerrillas.
El Salvador Attorney General Douglas Meléndez has ordered the arrest of several prominent suspects accused of judicial corruption, including his own predecessor, an unprecedented move that suggests Meléndez's office is prepared to pursue high-profile corruption cases.
Not unique table/alias: 'fp' SQL=SELECT COUNT(*) FROM #__content AS a INNER JOIN #__content_frontpage AS fp ON fp.content_id = a.id LEFT JOIN #__categories AS c ON c.id = a.catid LEFT JOIN #__users AS ua ON ua.id = a.created_by LEFT JOIN #__users AS uam ON uam.id = a.modified_by LEFT JOIN #__categories as parent ON parent.id = c.parent_id LEFT JOIN #__content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM #__categories AS cat JOIN #__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 #__content_frontpage AS fp ON fp.content_id = a.id WHERE a.access IN (1,1,5) AND c.access IN (1,1,5) 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 <= '2016-08-28 05:08:38') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2016-08-28 05:08:38')