SELECT cm.id, cm.content_id, cm.course_id, cm.url, cm.title, cm.permalink, cm.type, cm.access, c.permalink content_permalink, cc.permalink course_permalink, cm.description, (SELECT path FROM document_files WHERE doc_id = cm.id AND doc_type='CME') path FROM content_menus cm LEFT JOIN content c ON (c.id = cm.content_id) LEFT JOIN content_menus cc ON (cc.id = cm.course_id) WHERE cm.id_parent = (SELECT cm1.id FROM content_menus cm1 WHERE cm1.permalink = 'moc-1-1') AND cm.active = 'Y' AND cm.type = 'A' ORDER BY cm.sort ASC