This is the SQL Statement
SELECT b.`recid` , CONCAT( b.`fname` , ' ', b.`lname` ) AS name, a.`position`, a.`ordinal`, a.`sponsor`, a.`studentid`, a.`amount`, b.`school`, a.`type`, a.`startyear`, a.`endyear`, b.`thumb` FROM `daropaew_bpstoy`.`awards` a LEFT JOIN `daropaew_bpstoy`.`students` b ON ( a.`studentid` = b.`recid` ) where a.`endyear` = 2019 and a.`type` = 'Ranked-Finalist'

The Ranked Finalist For 2019

 

 

 

 

 

 

 

 

 

 

 

© Copyright 2016 Bahamas Primary School Student of The Year Foundation