select tat_recordid, tat_full_address from ffew_database.business_table where tat_full_address like '%._211A_The_Parade%' and tat_full_address like '%_Norwood%' and tat_full_address like '%_SA%' and tat_full_address like '%_5067%'