MySQL support is not available in this PHP configuration<br>SELECT DISTINCT resources.resource_id FROM resources  INNER JOIN resources_subjects as r_s1 ON resources.resource_id = r_s1.resource_id  WHERE ( r_s1.subject_id = '249' )