select tat_recordid, tat_full_address from ffew_database.business_table where tat_full_address like '%0%' and tat_full_address like '%_Aerovaal%' and tat_full_address like '%_Vereeniging%' and tat_full_address like '%_1936%' and tat_full_address like '%_South_Africa%'