Bad query: SELECT command denied to user 'suncoast_newsite'@'localhost' for table 'Listings'

 SELECT ID, user_nicename, user_email, DATE_FORMAT(user_registered, '%Y-%m-%d') AS registered, display_name, 
	um1.meta_value AS fname,
	um2.meta_value AS lname,
	um3.meta_value AS nickname,
	DATE_FORMAT(um4.meta_value,'%Y-%m-%d %h:%i %p') AS lastlogin, 
	DATE_FORMAT(um5.meta_value,'%Y-%m-%d %h:%i %p') AS lastactivity,
	um6.meta_value AS phone,
	( SELECT GROUP_CONCAT(ListingID SEPARATOR ',')
		FROM mlssavedlistings
		LEFT JOIN wp_users ON wp_users.ID = mlssavedlistings.wp_userid AND (
			mlssavedlistings.ListingId IN (SELECT ListingId FROM `flaidx_reso`.Listings)
			OR
			mlssavedlistings.ListingId IN (SELECT ListingId FROM `flaidx_reso`.ListingsSold)
			)
		WHERE users.ID = mlssavedlistings.wp_userid AND activelisting = 'y'
	) AS listings
	FROM wp_users AS users
	LEFT JOIN wp_usermeta AS um1
		ON ( um1.user_id = users.ID AND um1.meta_key = 'first_name')
	LEFT JOIN wp_usermeta AS um2
		ON ( um2.user_id = users.ID AND um2.meta_key = 'last_name' )
	LEFT JOIN wp_usermeta AS um3
		ON ( um3.user_id = users.ID AND um3.meta_key = 'nickname' )
	LEFT JOIN wp_usermeta AS um4
		ON ( um4.user_id = users.ID AND um4.meta_key = 'last_login' )
	LEFT JOIN wp_usermeta AS um5
		ON ( um5.user_id = users.ID AND um5.meta_key = 'last_action_time' )
	LEFT JOIN wp_usermeta AS um6
		ON ( um6.user_id = users.ID AND um6.meta_key = 'phone' )
	LEFT JOIN mlssavedlistings AS savedlistings
		ON ( users.ID = savedlistings.wp_userid )
	WHERE 1=1 AND
	( 	users.ID  IN ( SELECT wp_userid FROM mlssavedsearches WHERE activesearch = 'y' )
		OR 
		users.ID  IN ( SELECT wp_userid FROM mlssavedlistings WHERE activelisting = 'y' ) 
	)
	GROUP BY ID
	ORDER BY lastactivity DESC, lastlogin DESC, registered DESC, display_name ASC