use BBLEARN
SELECT u.user_id,
    cm.course_name,
    cm.course_id
FROM users as u
join course_users cu on u.pk1 = cu.users_pk1
join course_main cm on cu.crsmain_pk1=cm.pk1
join course_application ca on cm.pk1 = ca.crsmain_pk1

WHERE cu.role='P'
AND
((cm.course_id) LIKE '%FA2013' AND (ca.application) = 'alrn-AtomicLearning_tool')
AND (((ca.enable_ind) = 'Y' OR (ca.visible_ind) = 'N')
OR ((ca.enable_ind) = 'N' OR (ca.visible_ind) = 'Y'))