SELECT *
	FROM hostings
	LEFT JOIN domains ON domains.id = hostings.domain_id 
	LEFT JOIN credit ON credit.id = hostings.credit_id 
	WHERE
			name = 'dreamhost' 
		OR
			name like '%foobar%'