Search for Instructors

xCRUDYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '))' at line 12
SELECT COUNT(*) AS `count`  
 FROM `wp_taichi_instructor`
 INNER JOIN `wp_taichi_country` AS `wp_taichi_country` 
                ON `wp_taichi_instructor`.`address_country_id` = `wp_taichi_country`.`id` INNER JOIN `wp_taichi_view_instructor_displayed_certs` AS `wp_taichi_view_instructor_displayed_certs` 
                ON `wp_taichi_instructor`.`id` = `wp_taichi_view_instructor_displayed_certs`.`instructor_id`
 WHERE ((wp_taichi_view_instructor_displayed_certs.num_displayed_certs > 0) AND (wp_taichi_instructor.hidden = FALSE) AND (
	wp_taichi_instructor.id IN (
		SELECT instructor_id
		FROM wp_taichi_members
		WHERE member_paid_to > DATE_SUB( NOW( ) , INTERVAL 30 DAY ) AND member_active > 0
	)
) AND (wp_taichi_instructor.address_country_id = 233®ion=))