[SOLVED] JOIN the party - MySQL having some trouble

$sql= "SELECT tv.*, IF(tvc.value!='',tvc.value,tv.default_text) as value ";
$sql .= "FROM " . $this->getFullTableName("site_tmplvars") . " tv ";
$sql .= "INNER JOIN " . $this->getFullTableName("site_tmplvar_templates")." tvtpl ON tvtpl.tmplvarid = tv.id ";
$sql .= "LEFT JOIN " . $this->getFullTableName("site_tmplvar_contentvalues")." tvc ON tvc.tmplvarid=tv.id AND tvc.contentid = '" . $this->documentIdentifier . "' ";
$sql .= "WHERE tvtpl.templateid = '" . $documentObject['template'] . "'";

SELECT 
  master_ev.ev_date,
  animals.aname,
  species.species,
  species.subspecies,
  IF(events_ref.ev_name = 'feeding', foodinv.food_type, IF(events_ref.ev_name = 'notes', notes.note, events_ref.ev_name)) AS event_fixed
FROM
 master_ev
 INNER JOIN animals ON (master_ev.animal_id=animals.animal_id)
 INNER JOIN species ON (animals.species=species.species_idx)
 INNER JOIN events_ref ON (master_ev.events_idx=events_ref.event_id)
 LEFT OUTER JOIN notes ON (master_ev.ev_id=notes.ev_id)
 LEFT OUTER JOIN feedings ON (master_ev.ev_id=feedings.ev_id)
 LEFT OUTER JOIN foodinv ON (feedings.perm_id=foodinv.perm_id)

<?php

include "dbcore.php";

$query = "SELECT 
  master_ev.ev_date,
  animals.aname,
  species.species,
  species.subspecies,
  events_ref.ev_name,
  master_ev.events_idx,
  notes.note,
  weight.weight,
  foodinv.food_type
FROM
 master_ev
 INNER JOIN animals ON (master_ev.animal_id=animals.animal_id)
 INNER JOIN species ON (animals.species=species.species_idx)
 INNER JOIN events_ref ON (master_ev.events_idx=events_ref.event_id)
 LEFT OUTER JOIN notes ON (master_ev.ev_id=notes.ev_id)
 LEFT OUTER JOIN weight ON (master_ev.ev_id=weight.ev_id)
 LEFT OUTER JOIN length ON (master_ev.ev_id=length.ev_id)
 LEFT OUTER JOIN feedings ON (master_ev.ev_id=feedings.ev_id)
 LEFT OUTER JOIN foodinv ON (feedings.perm_id=foodinv.perm_id)";
	 
$result = mysql_query($query) or die(mysql_error());

echo "<table border='1'>";
echo "<tr> <th>date</th> <th>animal</th> <th>species</th> <th>event</th> </tr>";

while($row = mysql_fetch_array( $result )) {
	echo "<tr><td>"; 
	echo $row['ev_date'];
	echo "</td><td>"; 
	echo $row['aname'];
	echo "</td><td>";
	echo $row['species'];
	echo "</td><td>";
		switch ( $row['events_idx'] ) {
			case 8:
				echo $row['note'];
				break;
			case 5:
				echo "weight ",$row['weight'],"oz";
				break;
			case 6:
				echo "length ",$row['length'],"in";
				break;
			case 1:
				echo $row['food_type'];		
				break;
			default:
				echo $row['ev_name'];		
		}	
	echo "</td></tr>"; 
} 

echo "</table>";
?>