switch($Type) {

case 'OR':

$Sql="Select count(*) Quanti, count(distinct EnCountry) Countries, EvCode, EvEventName, EvTeamEvent, EvProgr,

concat(DvMajVersion, '.', DvMinVersion) as DocVersion,

date_format(DvPrintDateTime, '%e %b %Y %H:%i UTC') as DocVersionDate,

DvNotes as DocNotes

from Entries

inner join EventCategories on EnDivision=EcDivision and EnClass=EcClass and EcTournament={$_SESSION['TourId']} and EcTeamEvent=0

LEFT JOIN DocumentVersions on EnTournament=DvTournament AND DvFile = 'EN'

where EnIndFEvent=1 and EnTournament={$_SESSION['TourId']}

group by EvCode

ORDER BY EvProgr";

break;

case 'IF':

$Sql = "SELECT EvCode as Code, EvEventName as EventName, EvFinalFirstPhase as FirstPhase, COUNT(EnId) as Quanti, count(distinct EnCountry) Countries,

concat(DvMajVersion, '.', DvMinVersion) as DocVersion,

date_format(DvPrintDateTime, '%e %b %Y %H:%i UTC') as DocVersionDate,

DvNotes as DocNotes

FROM Events

INNER JOIN EventClass ON EvCode=EcCode AND EvTeamEvent=EcTeamEvent AND EvTournament=EcTournament

INNER JOIN Individuals ON EvCode=IndEvent AND EvTournament=IndTournament

INNER JOIN Entries ON EnId=IndId AND EnTournament=IndTournament AND EcClass=EnClass AND EcDivision=EnDivision

LEFT JOIN DocumentVersions on EnTournament=DvTournament AND DvFile = 'EN'

WHERE EvTournament=" . StrSafe_DB($_SESSION['TourId']) . " AND EvTeamEvent=0 AND ((EnIndFEvent=1 AND EnStatus<=1) OR EnId IS NULL)

GROUP BY EvCode, EvFinalFirstPhase

ORDER BY EvProgr";

break;

case 'TF':

$Sql = "SELECT EvCode, EvEventName as EventName, EvFinalFirstPhase as FirstPhase, EvMixedTeam, EvMultiTeam, EvMaxTeamPerson,EvTeamCreationMode,

concat(DvMajVersion, '.', DvMinVersion) as DocVersion,

date_format(DvPrintDateTime, '%e %b %Y %H:%i UTC') as DocVersionDate,

DvNotes as DocNotes

FROM Events

LEFT JOIN DocumentVersions on EvTournament=DvTournament AND DvFile = 'EN'

WHERE EvTournament=" . StrSafe_DB($_SESSION['TourId']) . " AND EvTeamEvent=1

ORDER BY EvProgr";

break;

default:

$Sql = "SELECT EnDivision as Divisione, EnClass as Classe, SUM(EnIndClEvent) as QuantiInd, IFNULL(numTeam,0) AS QuantiSq,

concat(DvMajVersion, '.', DvMinVersion) as DocVersion,

date_format(DvPrintDateTime, '%e %b %Y %H:%i UTC') as DocVersionDate,

DvNotes as DocNotes

FROM Entries

inner join Divisions on EnDivision=DivId and DivAthlete=1 and DivTournament=" . StrSafe_DB($_SESSION['TourId']) . "

inner join Classes on EnClass=ClId and ClAthlete=1 and ClTournament=" . StrSafe_DB($_SESSION['TourId']) . "

LEFT JOIN DocumentVersions on EnTournament=DvTournament AND DvFile = 'EN'

LEFT JOIN (

SELECT sqDiv, sqCl, COUNT(sqQuanti) as numTeam

FROM

(SELECT EnDivision as sqDiv, EnClass as sqCl, COUNT(EnId) as sqQuanti

FROM Entries

WHERE EnTournament=" . StrSafe_DB($_SESSION['TourId']) . " AND EnTeamClEvent=1

GROUP BY EnDivision, EnClass, IF(EnCountry2=0,EnCountry,EnCountry2), EnSubTeam

HAVING sqQuanti>=3) as sq

GROUP BY sqDiv, sqCl

) AS sqy ON EnDivision=sqDiv AND EnClass=sqCl

WHERE EnTournament=" . StrSafe_DB($_SESSION['TourId']) . "

GROUP BY EnDivision, EnClass, numTeam

order by ClViewOrder, DivViewOrder, numTeam";

break;

}

return $Sql;

$Sql = "SELECT EvCode as Code, EvEventName as EventName, EvFinalFirstPhase as FirstPhase, COUNT(EnId) as Quanti,

concat(DvMajVersion, '.', DvMinVersion) as DocVersion,

date_format(DvPrintDateTime, '%e %b %Y %H:%i UTC') as DocVersionDate,

DvNotes as DocNotes

FROM Events

INNER JOIN EventClass ON EvCode=EcCode AND EvTeamEvent=EcTeamEvent AND EvTournament=EcTournament

INNER JOIN Individuals ON EvCode=IndEvent AND EvTournament=IndTournament

INNER JOIN Entries ON EnId=IndId AND EnTournament=IndTournament AND EcClass=EnClass AND EcDivision=EnDivision

LEFT JOIN DocumentVersions on EnTournament=DvTournament AND DvFile = 'EN'

WHERE EvTournament=" . StrSafe_DB($_SESSION['TourId']) . " AND EvTeamEvent=0 AND ((EnIndFEvent=1 AND EnStatus<=1) OR EnId IS NULL)

GROUP BY EvCode, EvFinalFirstPhase

ORDER BY EvProgr";

return $Sql;

$Sql="";

if($ORIS) {

$Sql = "SELECT SUM(IF((DivAthlete AND ClAthlete AND EnSex=0), 1,0)) as M, SUM(IF((DivAthlete AND ClAthlete AND EnSex=1), 1,0)) as W, SUM(IF((DivAthlete AND ClAthlete), 0,1)) as Of,

CoCode as NationCode, CoName as NationName,

concat(DvMajVersion, '.', DvMinVersion) as DocVersion,

date_format(DvPrintDateTime, '%e %b %Y %H:%i UTC') as DocVersionDate,

DvNotes as DocNotes

FROM Entries

INNER JOIN Countries ON EnCountry = CoId

LEFT JOIN DocumentVersions on EnTournament=DvTournament AND DvFile = 'EN'

LEFT JOIN Divisions ON EnDivision=DivId AND DivTournament=" . StrSafe_DB($_SESSION['TourId']) . "

LEFT JOIN Classes ON EnClass=ClId AND ClTournament=" . StrSafe_DB($_SESSION['TourId']) . "

WHERE EnTournament = " . StrSafe_DB($_SESSION['TourId']) . "

GROUP BY CoCode

ORDER BY CoCode ";

} else {

$Sql = "SELECT DISTINCT CONCAT(TRIM(EnDivision),'|',TRIM(EnClass)) as Id, (DivAthlete AND ClAthlete) as isAthlete

FROM Entries

LEFT JOIN Divisions ON EnDivision=DivId AND DivTournament=" . StrSafe_DB($_SESSION['TourId']) . "

LEFT JOIN Classes ON EnClass=ClId AND ClTournament=" . StrSafe_DB($_SESSION['TourId']) . "

WHERE EnTournament = " . StrSafe_DB($_SESSION['TourId']) . " "

. ($Athletes ? 'AND DivAthlete=1 AND ClAthlete=1 ' : '')

. "ORDER BY LENGTH(EnDivision) DESC, DivViewOrder, EnDivision, LENGTH(EnClass) DESC, ClViewOrder, EnClass";

$Rs = safe_r_sql($Sql);

$Sql = "SELECT ";

if(safe_num_rows($Rs)>0) {

while($MyRow=safe_fetch($Rs))

$Sql .= "SUM(IF(CONCAT(TRIM(EnDivision),'|',TRIM(EnClass))='" . $MyRow->Id . "',1,0)) as `" . $MyRow->Id . "`, ";

safe_free_result($Rs);

}

$Sql .= "CoCode as NationCode, CoName as NationName,

concat(DvMajVersion, '.', DvMinVersion) as DocVersion,

date_format(DvPrintDateTime, '%e %b %Y %H:%i UTC') as DocVersionDate,

DvNotes as DocNotes

FROM Entries

INNER JOIN Countries ON EnCountry = CoId

LEFT JOIN DocumentVersions on EnTournament=DvTournament AND DvFile = 'EN'

WHERE EnTournament = " . StrSafe_DB($_SESSION['TourId']) . "

GROUP BY CoCode

ORDER BY CoCode ";

}

return $Sql;

global $CFG;

if(file_exists($f=$CFG->DOCUMENT_PATH.'Modules/Sets/'.$_SESSION['TourLocRule'].'/func/getStartListQuery.php')) {

include_once($f);

$func='getStartListQuery_'.$_SESSION['TourLocRule'];

return $func($ORIS, $Event, $Elim);

}

if($Elim) {

$MyQuery = "SELECT distinct

SesName,

EvCode as EventCode,

EnCode as Bib,

EnName AS Name,

upper(EnFirstName) AS FirstName,

EnClass AS ClassCode,

EnDivision AS DivCode,

EnAgeClass as AgeClass,

EnSubClass as SubClass,

ElElimPhase as Session,

ElTargetNo AS TargetNo,

upper(right(ElTargetNo,1)) AS TargetLetter,

CoCode AS NationCode,

CoName AS Nation,

EvElim1,

EvElim2,

EvEventName as EventName,

upper(DATE_FORMAT(EnDob,'%d %b %Y')) as DOB,

ElSession,

concat(DvMajVersion, '.', DvMinVersion) as DocVersion,

date_format(DvPrintDateTime, '%e %b %Y %H:%i UTC') as DocVersionDate,

DvNotes as DocNotes,

ifnull(RankRanking, '') as Ranking

FROM Eliminations

INNER JOIN Entries ON ElId=EnId

inner join Tournament on ToId=EnTournament

INNER JOIN Countries ON EnCountry=CoId AND EnTournament=CoTournament

INNER JOIN Events ON ElEventCode=EvCode AND EvTeamEvent=0 AND EvTournament=" . StrSafe_DB($_SESSION['TourId']) . " AND (EvElim1>0 OR EvElim2>0)

LEFT JOIN Rankings on EnTournament=RankTournament and RankEvent=ElEventCode and RankTeam=0 and EnCode=RankCode and ToIocCode='FITA' and EnIocCode in ('', 'FITA') and RankIocCode='FITA'

LEFT JOIN Session ON ElSession=SesOrder AND ElTournament=SesTournament AND SesType='E'

LEFT JOIN DocumentVersions on EnTournament=DvTournament AND DvFile = 'ELIM'

WHERE

EnTournament=" . StrSafe_DB($_SESSION['TourId']) . " ";

if (isset($_REQUEST['Elim']) && is_numeric($_REQUEST['Elim'])) {

$MyQuery.="AND ElElimPhase=" . StrSafe_DB($_REQUEST['Elim']) . " ";

} elseif ($Event) {

$MyQuery.="AND ElElimPhase=" . ($Event-1) . " ";

}

if(!empty($_REQUEST['EnCodes'])) {

sort($_REQUEST['EnCodes']);

$MyQuery.= " and EnCode in (".implode(',', $_REQUEST['EnCodes']).") ";

}

$MyQuery .= "ORDER BY ElSession ASC, ElElimPhase ASC, ElTargetNo, EvProgr, EventName, Name, FirstName ";

// $MyQuery = "SELECT EvEventName ";

} else {

if($ORIS) {

$Fields="";

$Join="";

} else {

$Fields="";

$Join="";

}

if(!empty($_REQUEST["Session"])) {

if(is_array($_REQUEST["Session"])) {

$Sessions=$_REQUEST["Session"];

} else {

$Sessions=array($_REQUEST["Session"]);

}

}

$MyQuery = "SELECT distinct "

. " SesName, "

. " EvCode, "

. " DivDescription, "

. " ClDescription, "

. " Bib, "

. " Athlete,"

. " SUBSTRING(AtTargetNo,1,1) AS Session,"

. " SUBSTRING(AtTargetNo,2) AS TargetNo,"

. " NationCode,"

. " Nation,"

. " EventCode, "

. " EventName,"

. " DOB, "

. " SesAth4Target,"

. " ClassCode,"

. " DivCode,"

. " AgeClass,"

. " SubClass,"

. " Status,"

. " `IC`,"

. " `TC`,"

. " `IF`,"

. " `TF`,"

. " `TM`,"

. " NationCode2,"

. " Nation2,"

. " NationCode3,"

. " Nation3,"

. " EnSubTeam, "

. " TfName, "

. " concat(DvMajVersion, '.', DvMinVersion) as DocVersion,"

. " date_format(DvPrintDateTime, '%e %b %Y %H:%i UTC') as DocVersionDate,

DvNotes as DocNotes,

ifnull(RankRanking, '') as Ranking ";

$MyQuery.= "FROM AvailableTarget at ";

$MyQuery.= "INNER JOIN Session ON SUBSTRING(AtTargetNo,1,1)=SesOrder AND AtTournament=SesTournament AND SesType='Q' ";

$MyQuery.= "LEFT JOIN DocumentVersions on AtTournament=DvTournament AND DvFile = 'TGT' ";

$MyQuery.= "LEFT JOIN ";

$MyQuery.= "(";

$MyQuery.= "SELECT distinct ".($ORIS ? "EvCode," : "'' EvCode,")

. ($ORIS ? " EvProgr," : " '' EvProgr,")

. " DivDescription,"

. " ClDescription,"

. ($ORIS ? " IFNULL(EvCode,CONCAT(TRIM(EnDivision),TRIM(EnClass))) as EventCode," : " '' as EventCode,")

. " concat(upper(EnFirstName), ' ', EnName) Athlete,"

. " EnCode as Bib,"

. " QuTargetNo,"

. " upper(c.CoCode) AS NationCode,"

. " upper(c.CoName) AS Nation,"

. " upper(c2.CoCode) NationCode2,"

. " upper(c2.CoName) Nation2,"

. " upper(c3.CoCode) NationCode3,"

. " upper(c3.CoName) Nation3,"

. ($ORIS ? " IFNULL(EvEventName,CONCAT('|',DivDescription, '| |', ClDescription)) as EventName," : " '' as EventName,")

. " EnSubTeam,"

. " EnClass AS ClassCode,"

. " EnDivision AS DivCode,"

. " EnAgeClass as AgeClass,"

. " EnSubClass as SubClass,"

. " EnStatus as Status,"

. " EnIndClEvent AS `IC`,"

. " EnTeamClEvent AS `TC`,"

. " EnIndFEvent AS `IF`,"

. " EnTeamFEvent as `TF`,"

. " EnTeamMixEvent as `TM`,"

. " DATE_FORMAT(EnDob,'%d %b %Y') as DOB, "

. " TfName, "

. ($ORIS ? " RankRanking " : "'' RankRanking ");

$MyQuery.= " FROM Qualifications AS q ";

$MyQuery.= "INNER JOIN Entries AS e ON q.QuId=e.EnId AND e.EnTournament= " . StrSafe_DB($_SESSION['TourId']) . " AND EnAthlete=1 ";

$MyQuery.= "INNER JOIN Countries AS c ON e.EnCountry=c.CoId AND e.EnTournament=c.CoTournament

INNER JOIN Tournament on ToId=EnTournament ";

$MyQuery.= "LEFT JOIN Countries AS c2 ON e.EnCountry2=c2.CoId AND e.EnTournament=c2.CoTournament ";

$MyQuery.= "LEFT JOIN Countries AS c3 ON e.EnCountry3=c3.CoId AND e.EnTournament=c3.CoTournament ";

$MyQuery.= "LEFT JOIN Divisions ON TRIM(EnDivision)=TRIM(DivId) AND EnTournament=DivTournament ";

$MyQuery.= "LEFT JOIN Classes ON TRIM(EnClass)=TRIM(ClId) AND EnTournament=ClTournament ";

$MyQuery.= "LEFT JOIN EventCategories AS ec ON ec.EcTeamEvent=0 AND e.EnTournament=ec.EcTournament AND e.EnClass=ec.EcClass AND e.EnDivision=ec.EcDivision and EvMedals=1 ";

$MyQuery.= "LEFT JOIN Rankings on EnTournament=RankTournament and RankEvent=IF(EvWaCategory!='',EvWaCategory,EvCode) and RankTeam=0 and EnCode=RankCode and ToIocCode='FITA' and EnIocCode in ('', 'FITA') and RankIocCode='FITA' ";

$MyQuery.= "LEFT JOIN TargetFaces ON EnTournament=TfTournament AND EnTargetFace=TfId ";

$MyQuery.= ") as Sq ON at.AtTargetNo=Sq.QuTargetNo ";

$MyQuery.= "WHERE AtTournament = " . StrSafe_DB($_SESSION['TourId']) ;

if(isset($_REQUEST["Session"]) && $_REQUEST["Session"]!='All') {

$MyQuery .= "AND SUBSTRING(AtTargetNo,1,1) in (" . implode(',', $Sessions) . ") ";

}

if(isset($_REQUEST["x_Session"]) )

$MyQuery .= "AND SUBSTRING(AtTargetNo,1,1) = " . StrSafe_DB($_REQUEST["x_Session"]) . " ";

if(isset($_REQUEST["x_From"]) and isset($_REQUEST["x_To"]) ) {

$MyQuery .= "AND SUBSTRING(AtTargetNo,2,3) >= " . StrSafe_DB(sprintf('%03d', intval($_REQUEST["x_From"]))) . " ";

$MyQuery .= "AND SUBSTRING(AtTargetNo,2,3) <= " . StrSafe_DB(sprintf('%03d', intval($_REQUEST["x_To"]))) . " ";

}

if(isset($_REQUEST['Empty'])) {

$MyQuery.=" and QuTargetNo is null

and AtTargetNo not in (select case right(QuTargetNo,1) when 'A' then concat(left(QuTargetNo, 4),'C') when 'B' then concat(left(QuTargetNo, 4),'D') when 'C' then concat(left(QuTargetNo, 4),'A') when 'D' then concat(left(QuTargetNo, 4),'B') else '' end from (select QuTargetNo from Qualifications inner join Entries on EnId=QuId and EnTournament={$_SESSION['TourId']} and EnWchair=1) tmp )

and AtTargetNo not in (select case right(QuTargetNo,1) when 'A' then concat(left(QuTargetNo, 4),'b') when 'B' then concat(left(QuTargetNo, 4),'A') when 'C' then concat(left(QuTargetNo, 4),'D') when 'D' then concat(left(QuTargetNo, 4),'C') else '' end from (select QuTargetNo from Qualifications inner join Entries on EnId=QuId and EnTournament={$_SESSION['TourId']} and EnDoubleSpace=1) tmp ) ";

}

if(!empty($_REQUEST['EnCodes'])) {

sort($_REQUEST['EnCodes']);

$MyQuery.= " and Bib in (".implode(',', $_REQUEST['EnCodes']).") ";

}

if($ORIS) {

$MyQuery.= " AND EventName!='' ";

$MyQuery.= "ORDER BY EvProgr, EventName, AtTargetNo, Athlete ";

} else {

$MyQuery.= " ORDER BY AtTargetNo, NationCode, Athlete, Nation ";

}

}

return $MyQuery;

$TmpWhere="";

if(isset($_REQUEST["CountryName"]) && preg_match("/^[-,0-9A-Z]*$/i",str_replace(" ","",$_REQUEST["CountryName"])))

{

foreach(explode(",",$_REQUEST["CountryName"]) as $Value)

{

$Tmp=NULL;

if(preg_match("/^([A-Z0-9]*)-([A-Z0-9]*)$/i",str_replace(" ","",$Value),$Tmp))

$TmpWhere .= "(CoCode >= " . StrSafe_DB(stripslashes($Tmp[1]) ) . " AND CoCode <= " . StrSafe_DB(stripslashes($Tmp[2].chr(255))) . ") OR ";

else

$TmpWhere .= "CoCode LIKE " . StrSafe_DB(stripslashes(trim($Value)) . "%") . " OR ";

}

$TmpWhere = substr($TmpWhere,0,-3);

}

$MyQuery = "SELECT DISTINCT

upper(CoCode) AS NationCode, upper(CoName) AS Nation,

concat(DvMajVersion, '.', DvMinVersion) as DocVersion,

date_format(DvPrintDateTime, '%e %b %Y %H:%i UTC') as DocVersionDate,

DvNotes as DocNotes

FROM Entries AS e

INNER JOIN Countries AS c ON e.EnCountry=c.CoId AND e.EnTournament=c.CoTournament

INNER JOIN Qualifications AS q ON e.EnId=q.QuId

LEFT JOIN DocumentVersions on EnTournament=DvTournament AND DvFile = 'EN'

WHERE EnTournament = " . StrSafe_DB($_SESSION['TourId']) . " "; // 2010-03-16 totlo EnAthlete=1 AND

if(isset($_REQUEST["Session"]) && is_numeric($_REQUEST["Session"])) {

$MyQuery .= "AND QuSession = " . StrSafe_DB($_REQUEST["Session"]) . " ";

}

if($TmpWhere != "") {

$MyQuery .= "AND (" . $TmpWhere . ")";

}

$MyQuery.= "ORDER BY CoCode";

return $MyQuery;

$SinglePage = isset($_REQUEST['SinglePage']);

$TargetFace=(isset($_REQUEST['tf']) && $_REQUEST['tf']==1);

$NoPhoto=isset($_REQUEST['NoPhoto']);

$Emails=isset($_REQUEST['Emails']);

$TmpWhere="";

if(isset($_REQUEST["CountryName"]) && preg_match("/^[-,0-9A-Z]*$/i",str_replace(" ","",$_REQUEST["CountryName"])))

{

foreach(explode(",",$_REQUEST["CountryName"]) as $Value)

{

$Tmp=NULL;

if(preg_match("/^([A-Z0-9]*)-([A-Z0-9]*)$/i",str_replace(" ","",$Value),$Tmp))

$TmpWhere .= "(CoCode >= " . StrSafe_DB(stripslashes($Tmp[1]) ) . " AND CoCode <= " . StrSafe_DB(stripslashes($Tmp[2].chr(255))) . ") OR ";

else

$TmpWhere .= "CoCode LIKE " . StrSafe_DB(stripslashes(trim($Value)) . "%") . " OR ";

}

$TmpWhere = substr($TmpWhere,0,-3);

}

if($ORIS) {

$MyQuery = "SELECT distinct

SesName, EvCode, DivDescription, ClDescription, DivAthlete and ClAthlete as IsAthlete,

IFNULL(EvCode,CONCAT(TRIM(EnDivision),TRIM(EnClass))) as EventCode, EnCode as Bib,

concat(upper(EnFirstName), ' ', EnName) AS Athlete, DATE_FORMAT(EnDob,'%d %b %Y') as DOB, QuSession AS Session, SUBSTRING(QuTargetNo,2) AS TargetNo,

upper(CoCode) AS NationCode, upper(CoName) AS Nation,

IFNULL(GROUP_CONCAT(EvEventName SEPARATOR ', '), if(DivAthlete and ClAthlete, CONCAT('|',DivDescription, '| |', ClDescription), ClDescription)) as EventName,

IFNULL(GROUP_CONCAT(RankRanking order by EvProgr SEPARATOR ', '), '') as Ranking,

cNumber, PhPhoto is not null as HasPhoto,

concat(DvMajVersion, '.', DvMinVersion) as DocVersion,

date_format(DvPrintDateTime, '%e %b %Y %H:%i UTC') as DocVersionDate,

DvNotes as DocNotes, EdEmail, EdExtra, EnDob

FROM Entries AS e

INNER JOIN Countries AS c ON e.EnCountry=c.CoId AND e.EnTournament=c.CoTournament

INNER JOIN Qualifications AS q ON e.EnId=q.QuId

INNER JOIN (

SELECT EnCountry AS cCode, COUNT(EnId) AS cNumber FROM `Entries`

WHERE EnTournament=" . StrSafe_DB($_SESSION['TourId']) . " GROUP BY EnCountry

) as sqy ON e.EnCountry=sqy.cCode

inner join Tournament on EnTournament=ToId

LEFT JOIN Individuals on IndId=EnId AND EnTournament=IndTournament

left JOIN Divisions ON TRIM(EnDivision)=TRIM(DivId) AND EnTournament=DivTournament

left JOIN Classes ON TRIM(EnClass)=TRIM(ClId) AND EnTournament=ClTournament

LEFT JOIN Session on EnTournament=SesTournament and SesType='Q' and SesOrder=QuSession

LEFT JOIN EventCategories AS ec ON ec.EcTeamEvent=0 AND IndTournament=ec.EcTournament AND IndEvent=EcCode and EcClass=EnClass and EcDivision=EnDivision

LEFT JOIN Photos ON PhEnId=EnId

LEFT JOIN ExtraData ON EdId=EnId and EdType='E'

LEFT JOIN DocumentVersions on EnTournament=DvTournament AND DvFile = 'EN'

LEFT JOIN Rankings on EnTournament=RankTournament and RankEvent=IF(EvWaCategory!='',EvWaCategory,EvCode) and RankTeam=0 and EnCode=RankCode and ToIocCode='FITA' and EnIocCode in ('', 'FITA') and RankIocCode='FITA'

WHERE EnTournament = " . StrSafe_DB($_SESSION['TourId']) . " "; // 2010-03-16 totlo EnAthlete=1 AND

if($Athletes) {

$MyQuery.= " AND EnAthlete=1 ";

}

if(isset($_REQUEST["Event"]))

$MyQuery .= "AND IndEvent LIKE " . StrSafe_DB($_REQUEST["Event"]) . " ";

if(isset($_REQUEST["Session"]) && is_numeric($_REQUEST["Session"]))

$MyQuery .= "AND QuSession = " . StrSafe_DB($_REQUEST["Session"]) . " ";

if($TmpWhere != "")

$MyQuery .= "AND (" . $TmpWhere . ")";

if(!empty($_REQUEST['Exclude'])) {

$MyQuery .= "AND (EnDivision not in ('" . implode("','", $_REQUEST['Exclude']) . "')) ";

}

$MyQuery.= "GROUP BY SesName, DivDescription, ClDescription, IsAthlete, Bib, Athlete, DOB, Session, TargetNo, NationCode, Nation ";

$MyQuery.= "ORDER BY CoCode, EnAthlete desc, ".($Athletes ? 'DivViewOrder, ClViewOrder, ' : '' )."Athlete, TargetNo ";

return $MyQuery;

}

$MyQuery = "(SELECT"

. " EnCode as Bib"

. ", concat(upper(EnFirstName), ' ', EnName) AS Athlete"

. ", QuSession AS Session"

. ", SesName"

. ", SUBSTRING(QuTargetNo,2) AS TargetNo"

. ", upper(CoCode) AS NationCode"

. ", upper(CoName) AS Nation"

. ", EnSubTeam"

. ", EnClass AS ClassCode"

. ", ClDescription"

. ", EnDivision AS DivCode"

. ", DivDescription"

. ", DivAthlete and ClAthlete as IsAthlete"

. ", EnAgeClass as AgeClass"

. ", EnSubClass as SubClass"

. ", EnStatus as Status"

. ", EnIndClEvent AS `IC`"

. ", EnTeamClEvent AS `TC`"

. ", EnIndFEvent AS `IF`"

. ", EnTeamFEvent as `TF`"

. ", EnTeamMixEvent as `TM`"

. ", IF(EnCountry2=0,0,1) as secTeam "

. ", TfName, PhPhoto is not null as HasPhoto, EdEmail, EdExtra, EnDob ";

$MyQuery.= "FROM Entries AS e ";

$MyQuery.= "LEFT JOIN Photos ON e.EnId=PhEnId ";

$MyQuery.= "LEFT JOIN ExtraData ON EdId=EnId and EdType='E' ";

$MyQuery.= "LEFT JOIN Countries AS c ON e.EnCountry=c.CoId AND e.EnTournament=c.CoTournament ";

$MyQuery.= "LEFT JOIN Qualifications AS q ON e.EnId=q.QuId ";

$MyQuery.= "LEFT JOIN Divisions ON TRIM(EnDivision)=TRIM(DivId) AND EnTournament=DivTournament ";

$MyQuery.= "LEFT JOIN Classes ON TRIM(EnClass)=TRIM(ClId) AND EnTournament=ClTournament ";

$MyQuery.= "LEFT JOIN Session on EnTournament=SesTournament and SesType='Q' and SesOrder=QuSession ";

$MyQuery.= "LEFT JOIN TargetFaces ON EnTournament=TfTournament AND EnTargetFace=TfId ";

$MyQuery.= "WHERE EnTournament = " . StrSafe_DB($_SESSION['TourId']) . " ";

if($Athletes) $MyQuery.= " AND EnAthlete=1 ";

if(isset($_REQUEST["Session"]) && is_numeric($_REQUEST["Session"]))

$MyQuery .= "AND QuSession = " . StrSafe_DB($_REQUEST["Session"]) . " ";

if($TmpWhere != "")

$MyQuery .= "AND (" . $TmpWhere . ")";

if($NoPhoto) $MyQuery .= "AND (length(PhPhoto)='' or PhPhoto is null) ";

$MyQuery .= ") UNION ALL ";

$MyQuery .= "(SELECT"

. " EnCode as Bib"

. ", concat(upper(EnFirstName), ' ', EnName) AS Athlete"

. ", QuSession AS Session"

. ", SesName"

. ", SUBSTRING(QuTargetNo,2) AS TargetNo"

. ", upper(CoCode) AS NationCode"

. ", upper(CoName) AS Nation"

. ", EnSubTeam"

. ", EnClass AS ClassCode"

. ", ClDescription"

. ", EnDivision AS DivCode"

. ", DivDescription"

. ", DivAthlete and ClAthlete as IsAthlete"

. ", EnAgeClass as AgeClass"

. ", EnSubClass as SubClass"

. ", EnStatus as Status"

. ", EnIndClEvent AS `IC`"

. ", EnTeamClEvent AS `TC`"

. ", EnIndFEvent AS `IF`"

. ", EnTeamFEvent as `TF`"

. ", EnTeamMixEvent as `TM`"

. ", 2 as secTeam "

. ", TfName, PhPhoto is not null as HasPhoto, EdEmail, EdExtra, EnDob ";

$MyQuery.= "FROM Entries AS e ";

$MyQuery.= "LEFT JOIN Photos ON e.EnId=PhEnId ";

$MyQuery.= "LEFT JOIN ExtraData ON EdId=EnId and EdType='E' ";

$MyQuery.= "LEFT JOIN Countries AS c ON e.EnCountry2=c.CoId AND e.EnTournament=c.CoTournament ";

$MyQuery.= "LEFT JOIN Qualifications AS q ON e.EnId=q.QuId ";

$MyQuery.= "LEFT JOIN Divisions ON TRIM(EnDivision)=TRIM(DivId) AND EnTournament=DivTournament ";

$MyQuery.= "LEFT JOIN Classes ON TRIM(EnClass)=TRIM(ClId) AND EnTournament=ClTournament ";

$MyQuery.= "LEFT JOIN Session on EnTournament=SesTournament and SesType='Q' and SesOrder=QuSession ";

$MyQuery.= "LEFT JOIN TargetFaces ON EnTournament=TfTournament AND EnTargetFace=TfId ";

$MyQuery.= "WHERE EnTournament = " . StrSafe_DB($_SESSION['TourId']) . " AND EnCountry2!=0 AND (EnTeamClEvent!=0 OR EnTeamFEvent!=0 OR EnTeamMixEvent!=0) ";

if($Athletes) $MyQuery.= " AND EnAthlete=1 ";

if(isset($_REQUEST["Session"]) && is_numeric($_REQUEST["Session"]))

$MyQuery .= "AND QuSession = " . StrSafe_DB($_REQUEST["Session"]) . " ";

if($TmpWhere != "")

$MyQuery .= "AND (" . $TmpWhere . ")";

if($NoPhoto) $MyQuery .= "AND (length(PhPhoto)='' or PhPhoto is null) ";

$MyQuery.= ") UNION ALL ";

$MyQuery .= "(SELECT"

. " EnCode as Bib"

. ", concat(upper(EnFirstName), ' ', EnName) AS Athlete"

. ", QuSession AS Session"

. ", SesName"

. ", SUBSTRING(QuTargetNo,2) AS TargetNo"

. ", upper(CoCode) AS NationCode"

. ", upper(CoName) AS Nation"

. ", EnSubTeam"

. ", EnClass AS ClassCode"

. ", ClDescription"

. ", EnDivision AS DivCode"

. ", DivDescription"

. ", DivAthlete and ClAthlete as IsAthlete"

. ", EnAgeClass as AgeClass"

. ", EnSubClass as SubClass"

. ", EnStatus as Status"

. ", EnIndClEvent AS `IC`"

. ", EnTeamClEvent AS `TC`"

. ", EnIndFEvent AS `IF`"

. ", EnTeamFEvent as `TF`"

. ", EnTeamMixEvent as `TM`"

. ", 3 as secTeam "

. ", TfName, PhPhoto is not null as HasPhoto, EdEmail, EdExtra, EnDob ";

$MyQuery.= "FROM Entries AS e ";

$MyQuery.= "LEFT JOIN Photos ON e.EnId=PhEnId ";

$MyQuery.= "LEFT JOIN ExtraData ON EdId=EnId and EdType='E' ";

$MyQuery.= "LEFT JOIN Countries AS c ON e.EnCountry3=c.CoId AND e.EnTournament=c.CoTournament ";

$MyQuery.= "LEFT JOIN Qualifications AS q ON e.EnId=q.QuId ";

$MyQuery.= "LEFT JOIN Divisions ON TRIM(EnDivision)=TRIM(DivId) AND EnTournament=DivTournament ";

$MyQuery.= "LEFT JOIN Classes ON TRIM(EnClass)=TRIM(ClId) AND EnTournament=ClTournament ";

$MyQuery.= "LEFT JOIN Session on EnTournament=SesTournament and SesType='Q' and SesOrder=QuSession ";

$MyQuery.= "LEFT JOIN TargetFaces ON EnTournament=TfTournament AND EnTargetFace=TfId ";

$MyQuery.= "WHERE EnTournament = " . StrSafe_DB($_SESSION['TourId']) . " AND EnCountry3!=0 ";

if($Athletes) $MyQuery.= " AND EnAthlete=1 ";

if(isset($_REQUEST["Session"]) && is_numeric($_REQUEST["Session"]))

$MyQuery .= "AND QuSession = " . StrSafe_DB($_REQUEST["Session"]) . " ";

if($TmpWhere != "")

$MyQuery .= "AND (" . $TmpWhere . ")";

if($NoPhoto) $MyQuery .= "AND (length(PhPhoto)='' or PhPhoto is null) ";

$MyQuery.= ") ORDER BY " . ($orderByName ? "Nation" : "NationCode") . ", ".($SinglePage?'Session, ':'')." Athlete, TargetNo ";

return $MyQuery;

$MyQuery="select distinct EvEventName EventName, EvTeamEvent, EvRecCategory, RecTournament.*

from Events

inner join RecTournament on EvTournament=RtTournament and EvTeamEvent=RtRecTeam and EvRecCategory=RtRecCategory

inner join TourRecords on TrTournament=EvTournament and TrRecType=RtRecType and TrRecCode=RtRecCode and TrRecTeam=EvTeamEvent and TrRecPara=RtRecPara

where EvTournament={$_SESSION['TourId']} and EvMedals=1

order by EvTeamEvent, EvProgr, RtRecCode desc, RtRecType desc, RtRecPhase=0, RtRecPhase=2, RtRecDistance desc";

return $MyQuery;

// needs to check 1=qualification, 2=team qualification, 3=ind matches and 4=team matches

// at the moment no partial (distance for 1440 round) are shown

// MISSING FinXNine !!!

// MISSING TeFinXNine

$MyQuery="(select distinct '1' as Phase, EvProgr, EvEventName EventName, EvTeamEvent, EvRecCategory, QuScore NewRecord, QuXNine NewXNine, if(RecDate is null, '{$_SESSION['TourRealWhenTo']}', date_format(RecDate, '%e %M %Y')) as RecordDate, concat(upper(EnFirstName), ' ', EnName) as Athlete, CoCode, RecTournament.*

from Events

inner join RecTournament on EvTournament=RtTournament and EvTeamEvent=RtRecTeam and EvRecCategory=RtRecCategory and RtRecPhase=1

inner join TourRecords on TrTournament=EvTournament and TrRecType=RtRecType and TrRecCode=RtRecCode and TrRecTeam=EvTeamEvent and TrRecPara=RtRecPara

inner join Individuals on IndEvent=EvCode and EvTeamEvent=0 and IndTournament=EvTournament

inner join Entries on IndId=EnId

inner join Countries on CoId=if(EnCountry2>0, EnCountry2, EnCountry)

inner join Qualifications on IndId=QuId and (QuScore>RtRecTotal or if(RtRecXNine>0, QuXNine>RtRecXNine, false))

left join (select DiSession, max(DiDay) RecDate

from DistanceInformation

where DiDay>0 and DiType='Q' and DiTournament={$_SESSION['TourId']} group by DiSession) Ses on QuSession=DiSession

where EvTournament={$_SESSION['TourId']})

union

(select distinct '2' as Phase, EvProgr, EvEventName EventName, EvTeamEvent, EvRecCategory, TeScore NewRecord, TeXNine NewXNine, if(RecDate is null, '{$_SESSION['TourRealWhenTo']}', date_format(RecDate, '%e %M %Y')) as RecordDate, concat(CoCode, ' ', CoName, \"\n\", Components) as Athlete, CoCode, RecTournament.*

from Events

inner join RecTournament on EvTournament=RtTournament and EvTeamEvent=RtRecTeam and EvRecCategory=RtRecCategory and RtRecPhase=1

inner join TourRecords on TrTournament=EvTournament and TrRecType=RtRecType and TrRecCode=RtRecCode and TrRecTeam=EvTeamEvent and TrRecPara=RtRecPara

inner join Teams on TeEvent=EvCode and EvTeamEvent=1 and TeTournament=EvTournament and TeFinEvent=1 and (TeScore>RtRecTotal or if(RtRecXNine>0, TeXNine>RtRecXNine, false))

inner join (select RecDate, group_concat(concat(' ', upper(EnFirstName), ' ', EnName) separator \"\n\") as Components, TfcCoId, TfcSubTeam, TfcTournament, TfcEvent

from TeamFinComponent

inner join Entries on TfcId=EnId

inner join Qualifications on EnId=QuId

left join (select DiSession, max(DiDay) RecDate

from DistanceInformation

where DiDay>0 and DiType='Q' and DiTournament={$_SESSION['TourId']} group by DiSession) Ses on QuSession=DiSession

where TfcTournament={$_SESSION['TourId']}

group by TfcCoId, TfcSubTeam, TfcTournament, TfcEvent) Components on TfcCoId=TeCoId and TfcSubTeam=TeSubTeam and TfcTournament=TeTournament and TfcEvent=TeEvent

inner join Countries on CoId=TeCoId

where EvTournament={$_SESSION['TourId']})

union

(select distinct '3' as Phase, EvProgr, EvEventName EventName, EvTeamEvent, EvRecCategory, FinScore NewRecord, 0 NewXNine, if(FsScheduledDate is null, '{$_SESSION['TourRealWhenTo']}', date_format(FsScheduledDate, '%e %M %Y')) as RecordDate, concat(upper(EnFirstName), ' ', EnName) as Athlete, CoCode, RecTournament.*

from Events

inner join RecTournament on EvTournament=RtTournament and EvTeamEvent=RtRecTeam and EvRecCategory=RtRecCategory and RtRecPhase=0

inner join TourRecords on TrTournament=EvTournament and TrRecType=RtRecType and TrRecCode=RtRecCode and TrRecTeam=EvTeamEvent and TrRecPara=RtRecPara

inner join Finals on FinEvent=EvCode and EvTeamEvent=0 and FinTournament=EvTournament and (FinScore>RtRecTotal or if(RtRecXNine>0, FinScore=RtRecTotal, false))

inner join Entries on FinAthlete=EnId

inner join Countries on CoId=if(EnCountry2>0, EnCountry2, EnCountry)

left join FinSchedule on FSEvent=EvCode and FSTeamEvent=EvTeamEvent and FSMatchNo=FinMatchNo and FsTournament=EvTournament

where EvTournament={$_SESSION['TourId']})

union

(select distinct '4' as Phase, EvProgr, EvEventName EventName, EvTeamEvent, EvRecCategory, TfScore NewRecord, 0 NewXNine, if(FsScheduledDate is null, '{$_SESSION['TourRealWhenTo']}', date_format(FsScheduledDate, '%e %M %Y')) as RecordDate, concat(CoCode, ' ', CoName, \"\n\", Components) as Athlete, CoCode, RecTournament.*

from Events

inner join RecTournament on EvTournament=RtTournament and EvTeamEvent=RtRecTeam and EvRecCategory=RtRecCategory and RtRecPhase=0

inner join TourRecords on TrTournament=EvTournament and TrRecType=RtRecType and TrRecCode=RtRecCode and TrRecTeam=EvTeamEvent and TrRecPara=RtRecPara

inner join TeamFinals on TfEvent=EvCode and EvTeamEvent=1 and TfTournament=EvTournament and (TfScore>RtRecTotal or if(RtRecXNine>0, TfScore=RtRecTotal, false))

inner join (select group_concat(concat(' ', upper(EnFirstName), ' ', EnName) separator \"\n\") as Components, TfcCoId, TfcSubTeam, TfcTournament, TfcEvent

from TeamFinComponent

inner join Entries on TfcId=EnId

where TfcTournament={$_SESSION['TourId']}

group by TfcCoId, TfcSubTeam, TfcTournament, TfcEvent) Components on TfcCoId=TfTeam and TfcSubTeam=TfSubTeam and TfcTournament=TfTournament and TfcEvent=TfEvent

inner join Countries on CoId=TfTeam

left join FinSchedule on FSEvent=EvCode and FSTeamEvent=EvTeamEvent and FSMatchNo=TfMatchNo and FsTournament=EvTournament

where EvTournament={$_SESSION['TourId']})

order by EvTeamEvent, EvProgr, RtRecCode desc, RtRecType desc, RtRecPhase=0, RtRecPhase=2, RtRecDistance desc";

// debug_svela($MyQuery);

return $MyQuery;

$TmpWhere="";

if(isset($_REQUEST["ArcherName"]) && preg_match("/^[-,0-9A-Z]*$/i",str_replace(" ","",$_REQUEST["ArcherName"]))) {

foreach(explode(",",$_REQUEST["ArcherName"]) as $Value) {

$Tmp=NULL;

if(preg_match("/^([0-9A-Z]*)\-([0-9A-Z]*)$/i",str_replace(" ","",$Value),$Tmp)) {

$TmpWhere .= "(EnFirstName >= " . StrSafe_DB(stripslashes($Tmp[1]) ) . " AND EnFirstName <= " . StrSafe_DB(stripslashes($Tmp[2].chr(255))) . ") OR ";

} else {

$TmpWhere .= "EnFirstName LIKE " . StrSafe_DB(stripslashes(trim($Value)) . "%") . " OR ";

}

}

$TmpWhere = substr($TmpWhere,0,-3);

}

$Collation = ($_SESSION['TourCollation'] ? "COLLATE utf8_{$_SESSION['TourCollation']}_ci" : '');

$MyQuery = "SELECT distinct"

. " upper(substr(EnFirstname $Collation,1,1)) as FirstLetter"

. ", SesName"

. ", EnCode as Bib"

. ", concat(upper(EnFirstName $Collation), ' ', EnName $Collation) AS Athlete"

. ", QuSession AS Session"

. ", SUBSTRING(QuTargetNo,2) AS TargetNo"

. ", upper(c.CoCode) AS NationCode"

. ", upper(c.CoName) AS Nation"

. ", upper(c2.CoCode) AS NationCode2"

. ", upper(c2.CoName) AS Nation2"

. ", upper(c3.CoCode) AS NationCode3"

. ", upper(c3.CoName) AS Nation3"

. ", DivDescription"

. ", ClDescription"

. ", EnSubTeam"

. ", EnClass AS ClassCode"

. ", EnDivision AS DivCode"

. ", DivAthlete and ClAthlete as IsAthlete"

. ", EnAgeClass as AgeClass"

. ", EnSubClass as SubClass"

. ", EnStatus as Status"

. ", EnIndClEvent AS `IC`, EnTeamClEvent AS `TC`, EnIndFEvent AS `IF`, EnTeamFEvent as `TF`, EnTeamMixEvent as `TM` "

. ", EvCode"

. ", IFNULL(EvCode,CONCAT(TRIM(EnDivision),TRIM(EnClass))) as EventCode"

. ", DATE_FORMAT(EnDob,'%d %b %Y') as DOB"

. ", IFNULL(GROUP_CONCAT(EvEventName order by EvProgr SEPARATOR ', '), if(DivAthlete and ClAthlete, CONCAT('|',DivDescription, '| |', ClDescription), ClDescription)) as EventName "

. ", IFNULL(GROUP_CONCAT(RankRanking order by EvProgr SEPARATOR ', '), '') as Ranking "

. ", TfName,

concat(DvMajVersion, '.', DvMinVersion) as DocVersion,

date_format(DvPrintDateTime, '%e %b %Y %H:%i UTC') as DocVersionDate,

DvNotes as DocNotes ";

$MyQuery.= "FROM Entries AS e

inner join Tournament on ToId=EnTournament

LEFT JOIN DocumentVersions on EnTournament=DvTournament AND DvFile = 'EN' ";

$MyQuery.= "LEFT JOIN Qualifications AS q ON e.EnId=q.QuId ";

$MyQuery.= "LEFT JOIN Individuals on IndId=EnId AND EnTournament=IndTournament ";

$MyQuery.= "LEFT JOIN Divisions ON TRIM(EnDivision)=TRIM(DivId) AND EnTournament=DivTournament ";

$MyQuery.= "LEFT JOIN Classes ON TRIM(EnClass)=TRIM(ClId) AND EnTournament=ClTournament ";

$MyQuery.= "LEFT JOIN Countries AS c ON e.EnCountry=c.CoId AND e.EnTournament=c.CoTournament ";

$MyQuery.= "LEFT JOIN Countries AS c2 ON e.EnCountry2=c2.CoId AND e.EnTournament=c2.CoTournament ";

$MyQuery.= "LEFT JOIN Countries AS c3 ON e.EnCountry3=c3.CoId AND e.EnTournament=c3.CoTournament ";

$MyQuery.= "LEFT JOIN Session on EnTournament=SesTournament and SesType='Q' and SesOrder=QuSession ";

$MyQuery.= "LEFT JOIN EventCategories AS ec ON ec.EcTeamEvent=0 AND EnTournament=ec.EcTournament AND IndEvent=EcCode and EcClass=EnClass and EcDivision=EnDivision ";

$MyQuery.= "LEFT JOIN TargetFaces ON EnTournament=TfTournament AND EnTargetFace=TfId

LEFT JOIN Rankings on EnTournament=RankTournament and RankEvent=IF(EvWaCategory!='',EvWaCategory,EvCode) and RankTeam=0 and EnCode=RankCode and ToIocCode='FITA' and EnIocCode in ('', 'FITA') and RankIocCode='FITA' ";

$MyQuery.= "WHERE EnTournament = " . StrSafe_DB($_SESSION['TourId']) ;

if(isset($_REQUEST["Session"]) and is_numeric($_REQUEST["Session"])) $MyQuery .= " AND QuSession = " . StrSafe_DB($_REQUEST["Session"]) ;

if(!empty($_REQUEST["Divisions"])) $MyQuery .= " AND concat(EnDivision, EnClass) like '{$_REQUEST["Divisions"]}'";

if($TmpWhere) $MyQuery .= " AND (" . $TmpWhere . ")";

$MyQuery.= " GROUP BY FirstLetter, SesName, Bib, Athlete, Session, TargetNo, NationCode, Nation, NationCode2, Nation2, NationCode3, Nation3,

DivDescription, ClDescription, EnSubTeam, ClassCode, DivCode, IsAthlete, AgeClass, SubClass, Status, `IC`, `TC`, `IF`, `TF`, `TM`,

DOB, TfName ";

$MyQuery.= " ORDER BY Athlete, TargetNo ";

return $MyQuery;

$TmpWhere="";

if(isset($_REQUEST["ArcherCategories"]) && preg_match("/^[,0-9A-Z]*$/i",str_replace(" ","",$_REQUEST["ArcherCategories"]))) {

foreach(explode(",",$_REQUEST["ArcherCategories"]) as $Value) {

$TmpWhere .= "CONCAT(EnDivision,EnClass) LIKE " . StrSafe_DB(stripslashes(trim($Value)) . "%") . " OR ";

}

$TmpWhere = substr($TmpWhere,0,-3);

}

if(!empty($_REQUEST['TeamEvents'])) {

$tmp=array();

foreach($_REQUEST['TeamEvents'] as $ev) $tmp[]=StrSafe_DB($ev);

$TmpWhere=" EvCode in (".implode(',', $tmp).") ";

}

$Collation = ($_SESSION['TourCollation'] ? "COLLATE utf8_{$_SESSION['TourCollation']}_ci" : '');

$MyQuery = "SELECT distinct"

. ($ORIS ? ' EvCode as EventCode ' :" IFNULL(EvCode,CONCAT(TRIM(EnDivision),TRIM(EnClass))) as EventCode")

. ", SesName"

. ", EnCode as Bib"

. ", concat(upper(EnFirstName $Collation), ' ', EnName $Collation) AS Athlete"

. ", QuSession AS Session"

. ", SUBSTRING(QuTargetNo,2) AS TargetNo"

. ", upper(c.CoCode) AS NationCode"

. ", upper(c.CoName) AS Nation"

. ", upper(c2.CoCode) AS NationCode2"

. ", upper(c2.CoName) AS Nation2"

. ", upper(c3.CoCode) AS NationCode3"

. ", upper(c3.CoName) AS Nation3"

. ", DivDescription"

. ", ClDescription"

. ", EnSubTeam"

. ", EnClass AS ClassCode"

. ", EnDivision AS DivCode"

. ", DivAthlete and ClAthlete as IsAthlete"

. ", EnAgeClass as AgeClass"

. ", EnSubClass as SubClass"

. ", EnStatus as Status"

. ", EnIndClEvent AS `IC`, EnTeamClEvent AS `TC`, EnIndFEvent AS `IF`, EnTeamFEvent as `TF`, EnTeamMixEvent as `TM` "

. ", EvCode"

. ", DATE_FORMAT(EnDob,'%d %b %Y') as DOB"

. ", IFNULL(GROUP_CONCAT(EvEventName order by EvProgr SEPARATOR ', '),CONCAT('|',DivDescription, '| |', ClDescription)) as EventName "

. ", TfName, cNumber,

ifnull(GROUP_CONCAT(RankRanking order by EvProgr SEPARATOR ', '), '') as Ranking

FROM Entries AS e

INNER JOIN Tournament on EnTournament=ToId

INNER JOIN Qualifications AS q ON e.EnId=q.QuId ";

$MyQuery.= "LEFT JOIN Individuals on IndId=EnId AND EnTournament=IndTournament ";

$MyQuery.= "LEFT JOIN Divisions ON TRIM(EnDivision)=TRIM(DivId) AND EnTournament=DivTournament ";

$MyQuery.= "LEFT JOIN Classes ON TRIM(EnClass)=TRIM(ClId) AND EnTournament=ClTournament ";

$MyQuery.= "LEFT JOIN Countries AS c ON e.EnCountry=c.CoId AND e.EnTournament=c.CoTournament ";

$MyQuery.= "LEFT JOIN Countries AS c2 ON e.EnCountry2=c2.CoId AND e.EnTournament=c2.CoTournament ";

$MyQuery.= "LEFT JOIN Countries AS c3 ON e.EnCountry3=c3.CoId AND e.EnTournament=c3.CoTournament

LEFT JOIN ( ";

$MyQuery.= "SELECT EnCountry AS cCode, COUNT(EnId) AS cNumber, IndEvent as cEvent FROM `Entries` inner join Individuals on EnId=IndId and IndTournament={$_SESSION['TourId']} ";

$MyQuery.= "WHERE EnTournament={$_SESSION['TourId']} GROUP BY EnCountry, IndEvent ";

$MyQuery.= ") as sqy ON e.EnCountry=sqy.cCode and IndEvent=cEvent ";

$MyQuery.= "LEFT JOIN Session on EnTournament=SesTournament and SesType='Q' and SesOrder=QuSession ";

$MyQuery.= "LEFT JOIN EventCategories AS ec ON ec.EcTeamEvent=0 AND EnTournament=ec.EcTournament AND IndEvent=EcCode and EcClass=EnClass and EcDivision=EnDivision ";

$MyQuery.= "LEFT JOIN TargetFaces ON EnTournament=TfTournament AND EnTargetFace=TfId

LEFT JOIN Rankings on EnTournament=RankTournament and RankEvent=IF(EvWaCategory!='',EvWaCategory,EvCode) and RankTeam=0 and EnCode=RankCode and ToIocCode='FITA' and EnIocCode in ('', 'FITA') and RankIocCode='FITA' ";

$MyQuery.= "WHERE ".($ORIS ? 'EvCode is not null and ' : '')." EnAthlete=1 and EnTournament = " . StrSafe_DB($_SESSION['TourId']) ;

if(isset($_REQUEST["Session"]) and is_numeric($_REQUEST["Session"])) $MyQuery .= " AND QuSession = " . StrSafe_DB($_REQUEST["Session"]) ;

if($TmpWhere) $MyQuery .= " AND (" . $TmpWhere . ")";

$MyQuery.= " GROUP BY EventCode, SesName, Bib, Athlete, Session, TargetNo, NationCode, Nation, NationCode2, Nation2, NationCode3, Nation3,

DivDescription, ClDescription, EnSubTeam, ClassCode, DivCode, IsAthlete, AgeClass, SubClass, Status, `IC`, `TC`, `IF`, `TF`, `TM`,

DOB, TfName ";

$MyQuery.= " ORDER BY ".($ORIS ? 'EvProgr, NationCode' : 'EventCode').", " . ($orderByTeam ? ($orderByTeam==1 ? " NationCode, ":"Nation, "):"") . " Athlete, TargetNo ";

return $MyQuery;