The following sample SQL query displays the SP Capital IQ entity Id, name, country, and region, along with the corresponding identifier name and Id in BECRS. It also indicates whether the identifier is flagged as the primary identifier. Note: Top 100000 companies are selected to reduce execution time.