Social Sciences Courses

WordPress database error: [Unknown column 'approved' in 'where clause']
SELECT DISTINCT user.*, user_meta.meta_value AS instructor_from_date, IFNULL(Avg(cmeta.meta_value), 0) AS rating, inst_status.meta_value AS status FROM wpio_users user INNER JOIN wpio_usermeta user_meta ON ( user.ID = user_meta.user_id ) INNER JOIN wpio_usermeta inst_status ON ( user.ID = inst_status.user_id ) LEFT JOIN wpio_usermeta AS umeta ON umeta.user_id = user.ID AND umeta.meta_key = '_tutor_instructor_course_id' LEFT JOIN wpio_comments AS c ON c.comment_post_ID = umeta.meta_value LEFT JOIN wpio_commentmeta AS cmeta ON cmeta.comment_id = c.comment_ID AND cmeta.meta_key = 'tutor_rating' WHERE user_meta.meta_key = '_is_tutor_instructor' AND ( user.display_name LIKE '%%' OR user.user_email = '' ) AND umeta.meta_value = approved GROUP BY user.ID ORDER BY user_meta.meta_value LIMIT 0, 9223372036854775807