}\r
\r
// get all relations between primary resources and their alternatives\r
- $sql = "SELECT DISTINCT c.content_path, pr.resource, , prt.type_id primary_type,\r
+ $sql = "SELECT DISTINCT c.content_path, pr.resource, prt.type_id primary_type,\r
sr.secondary_resource, srt.type_id secondary_type\r
FROM ".TABLE_PREFIX."primary_resources pr, ".\r
TABLE_PREFIX."primary_resources_types prt,".\r