The Colombian government has finally reached a peace deal with the country's main guerrilla group, but a number of questions remain when it comes to the provisions of the agreement on the treatment of crimes committed by actors in the armed conflict.
The Colombian government claims it has forced the country's main criminal organization out of the remote Eastern Plains region, but the area's strategic value as a cocaine production and trafficking hub means other criminal actors are likely to try to fill the vacuum.
A new guidebook published by the United Nations highlights the links between organized crime and match fixing in sports, and it offers suggestions for the relevant authorities about how to tackle the issue.
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.
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-31 23:28:03') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2016-08-31 23:28:03')