HawkEye | Bukkit data logging plugin with web-based data browser

I have 3 tables in my database, looking something like this:

Main table

Team ID Name ID Set ID 1 Name ID 1 Set ID 1 Name ID 2 Set ID 1 Name ID 3 Set ID 2 Name ID 1 Set ID 2 Name ID 2

Name Table

Name ID Name Name ID 1 (insert random name) Name ID 2 (insert more gibberish)

Team Table

Team ID Name Team ID 1 (insert random set name) Team ID 2 (insert some more gibberish)

Basically I'm trying to replace the main table with the names instead of the Ids, something like this:

Team Name Avengers Captain America Avengers Spiderman Avengers Hawkeye Sinister 6 Electro Sinister 6 Mysterio

I'm using the following code but doesn't seem to want to work

...

There are two doctors (DOC_A and DOC_B) assigned to every patient. There are 3 tables. The PATIENT table has the Patient_ID and DOC_A's DOC_ID. The CONSULT table has Patient_ID and DOC_B's DOC_ID. Finally, the DOCTOR table has both DOC_A and DOC_B's DOC_ID with their FirstName and LastName.

I'd like to show a distinct Patient_ID on each row with both DOC_A and DOC_B with FirstName and LastName (concatenated) instead of DOC_ID's.

Example Output (manually created):

Patient_ID DOC_A FirstLast DOC_B FirstLast 123 John Smith Jane Smith 456 Nathaniel Hawkeye Cora Munroe ...

I have some Python code to iterate over a large XML file to parse out certain results within a comma-separated element.

While the code pulls out the results, I need it to count the results as well. How do I write this loop within my current code, and where should it be placed? Within the loop after my .split() function? After?

My code:

...

I have angular application which contains Employ model class as follow:

...