TABLE SQL =select * from cp_breakstbl where 1=0RESULTS =PDOResult Object ( [stmt] => PDOStatement Object ( [queryString] => select * from cp_breakstbl where 1=0 ) [_errno] => 0 [_error] => Array ( [0] => 00000 [1] => [2] => ) [sql] => select * from cp_breakstbl where 1=0 [id] => [_num] => 0 ) TABLE SQL =select t.*, coalesce( m.name, 'No Name' ) as mbr_name, c.location_ID, c.memberNbr, c.problem, c.div, c.rank, c.raw_penalty, c.total_scores, c.raw_lt1, c.raw_lt2, c.raw_style, c.raw_spont, c.calc_lt1, c.calc_lt2, c.calc_style, c.calc_spont, l.lt_name as lt_location, l.st_name as st_location, if( m.assoc != 'AE', concat( t.school_city, if( length( t.school_city ), ', ', '' ), if( a.international = 'Y', a.country, UPPER( m.assoc ) ) ), concat( if( a.international = 'Y', a.country, UPPER( m.assoc ) ), if( length( t.school_city ), ', ', '' ), t.school_city ) ) as wf_location, m.city, m.county from competitionstbl as c inner join eventstbl as e on e.event_ID = c.event_ID left join cp_locationstbl as l on l.event_ID = e.event_ID and l.problem = c.problem and l.div = c.div and l.location_ID = c.location_ID left join memberstbl as m on m.memberNbr = c.memberNbr and m.school_year = e.school_year left join assoctbl as a on a.assoc = m.assoc and a.international = 'Y' left join assocteamstbl as t on t.memberNbr = c.memberNbr and t.problem = c.problem and t.div = c.div and t.school_year = e.school_year where 0 RESULTS =PDOResult Object ( [stmt] => PDOStatement Object ( [queryString] => select t.*, coalesce( m.name, 'No Name' ) as mbr_name, c.location_ID, c.memberNbr, c.problem, c.div, c.rank, c.raw_penalty, c.total_scores, c.raw_lt1, c.raw_lt2, c.raw_style, c.raw_spont, c.calc_lt1, c.calc_lt2, c.calc_style, c.calc_spont, l.lt_name as lt_location, l.st_name as st_location, if( m.assoc != 'AE', concat( t.school_city, if( length( t.school_city ), ', ', '' ), if( a.international = 'Y', a.country, UPPER( m.assoc ) ) ), concat( if( a.international = 'Y', a.country, UPPER( m.assoc ) ), if( length( t.school_city ), ', ', '' ), t.school_city ) ) as wf_location, m.city, m.county from competitionstbl as c inner join eventstbl as e on e.event_ID = c.event_ID left join cp_locationstbl as l on l.event_ID = e.event_ID and l.problem = c.problem and l.div = c.div and l.location_ID = c.location_ID left join memberstbl as m on m.memberNbr = c.memberNbr and m.school_year = e.school_year left join assoctbl as a on a.assoc = m.assoc and a.international = 'Y' left join assocteamstbl as t on t.memberNbr = c.memberNbr and t.problem = c.problem and t.div = c.div and t.school_year = e.school_year where 0 ) [_errno] => 0 [_error] => Array ( [0] => 00000 [1] => [2] => ) [sql] => select t.*, coalesce( m.name, 'No Name' ) as mbr_name, c.location_ID, c.memberNbr, c.problem, c.div, c.rank, c.raw_penalty, c.total_scores, c.raw_lt1, c.raw_lt2, c.raw_style, c.raw_spont, c.calc_lt1, c.calc_lt2, c.calc_style, c.calc_spont, l.lt_name as lt_location, l.st_name as st_location, if( m.assoc != 'AE', concat( t.school_city, if( length( t.school_city ), ', ', '' ), if( a.international = 'Y', a.country, UPPER( m.assoc ) ) ), concat( if( a.international = 'Y', a.country, UPPER( m.assoc ) ), if( length( t.school_city ), ', ', '' ), t.school_city ) ) as wf_location, m.city, m.county from competitionstbl as c inner join eventstbl as e on e.event_ID = c.event_ID left join cp_locationstbl as l on l.event_ID = e.event_ID and l.problem = c.problem and l.div = c.div and l.location_ID = c.location_ID left join memberstbl as m on m.memberNbr = c.memberNbr and m.school_year = e.school_year left join assoctbl as a on a.assoc = m.assoc and a.international = 'Y' left join assocteamstbl as t on t.memberNbr = c.memberNbr and t.problem = c.problem and t.div = c.div and t.school_year = e.school_year where 0 [id] => [_num] => 0 ) Odyssey of the Mind
World Finals 2013 May 23rd
 Problem 1 Pet Project Division II
 Rank   Member    Long
Term		  Style  Spont  Penalty  Total
 19  No Name #31230
 Calc.
Raw		 148.74
116.02		 43.38
39.34		 81.21
94.00		 0.00 273.33
 Problem 1 Pet Project Division III
 Rank   Member    Long
Term		  Style  Spont  Penalty  Total
 17  No Name #31230
 Calc.
Raw		 141.08
127.67		 43.49
40.01		 58.79
77.75		 0.00 243.36
 Problem 2 The Email Must Go Through Division III
 Rank   Member    Long
Term		  Style  Spont  Penalty  Total
 4  No Name #31230
 Calc.
Raw		 176.90
157.00		 47.65
47.34		 94.60
157.75		 1.00 318.15
 Problem 3 ARTchitecture: The Musical Division III
 Rank   Member    Long
Term		  Style  Spont  Penalty  Total
 6  No Name #31230
 Calc.
Raw		 192.05
181.25		 45.66
42.00		 71.65
91.00		 0.00 309.36
 Problem 4 Tumble-wood Division II
 Rank   Member    Long
Term		  Weight  Style  Spont  Penalty  Total
 4  No Name #31230
 Calc.
Raw		 166.24
40.33		 121.43
850.00		 45.39
42.67		 85.25
65.00		 0.00 296.88
 Problem 4 Tumble-wood Division III
 Rank   Member    Long
Term		  Weight  Style  Spont  Penalty  Total
 18  No Name #31230
 Calc.
Raw		 153.26
35.67		 107.14
650.00		 50.00
40.33		 34.45
38.50		 0.00 237.71
 Problem 5 It's How You Look at It Division II
 Rank   Member    Long
Term		  Style  Spont  Penalty  Total
 6  No Name #31230
 Calc.
Raw		 184.27
172.75		 46.27
37.33		 80.39
72.75		 0.00 310.93
 Problem 5 It's How You Look at It Division III
 Rank   Member    Long
Term		  Style  Spont  Penalty  Total
 7  No Name #31230
 Calc.
Raw		 191.88
172.68		 37.85
35.33		 75.07
92.33		 0.00 304.80