Ladies 36 Hole Stableford Championship
Monday 2nd July 2018
The Bedford, Tees - Red, Red, Red
Stableford
H'cap Allowance: Full Handicap
Array
(
[0] => Array
(
[file] => /data/includes/multiroundresults.php
[line] => 49
[function] => TeamMembersById
[args] => Array
(
[0] => 649
[1] =>
)
)
[1] => Array
(
[file] => /data/compinclude.php
[line] => 163
[function] => multiroundresults
[args] => Array
(
[0] => 684
[1] =>
)
)
[2] => Array
(
[file] => /data/compinclude.php
[line] => 6301
[function] => Results
[args] => Array
(
[0] => 684
[1] =>
[2] =>
[3] =>
[4] =>
[5] =>
)
)
[3] => Array
(
[file] => /data/templates/competition2_details.php
[line] => 25
[function] => DisplayInfo
[args] => Array
(
[0] => 684
)
)
[4] => Array
(
[file] => /data/includes/PhpTemplate.php
[line] => 90
[args] => Array
(
[0] => /data/templates/competition2_details.php
)
[function] => include
)
[5] => Array
(
[file] => /data/includes/competition2_details.php
[line] => 59
[function] => fetch
[class] => PhpTemplate
[object] => PhpTemplate Object
(
[vars] => Array
(
[_gen] => PhpTemplate_Generator Object
(
[parent:PhpTemplate_Generator:private] => PhpTemplate Object
*RECURSION*
)
[_attr] => PhpTemplate_Generator Object
(
[parent:PhpTemplate_Generator:private] => PhpTemplate Object
*RECURSION*
)
[competition] => Array
(
[id] => 684
[name] => Ladies 36 Hole Stableford Championship
[start] => 2018-07-02
[end] => 0000-00-00
[rules] =>
[type] => 2
[groupid] => 0
[courseid] => 66
[tee] => 3
[image] =>
[numrounds] => 2
[visibility] => 0
[blurb] =>
[imported] => 0
[hcapallowance] => 1
[forumid] => 0
[admins] =>
[status] => 3
[betterball] => 0
[ident] => NSH
[winner] => 13695
[sss] => 0
[css] => -1
[twos] => 0
[signup] => 0
[signupstart] => 0000-00-00
[signupend] => 0000-00-00
[numperteam] => 1
[multiday] => 0
[divisions] => 1
[div1lim] => 0
[div2lim] => 0
[div3lim] => 0
[div4lim] => 0
[parentcomp] => 684
[abandoned] =>
[reductiononly] => 0
[signupopt] =>
[extrateams] => 0
[qual] => 0
[signuptimestart] =>
[signuptimestartv2] => 00:00:00
[signuptimeend] =>
[signuptimeendv2] => 00:00:00
[reqcontact] =>
[entrants] => 2
[nicestart] => 00-00-0000
[niceend] => 00-00-0000
[limitsignup] =>
[limitsignupnum] =>
[enablereservelist] =>
[reqqual] =>
[compadmin] => 0
[teamselect] => 0
[reqpayment] => 0
[overbookingzone] => 0
[wintype] => 0
[showtees] => 0
[prizesperdivision] => 0
[round] => 2
[formdate] => 02-07-2018
[nicetsdate] => Mon 2nd Jul
[open] => 1
[rollup] => 0
[freeformresults] =>
[tieres] => 0
[mixedchild] => 0
[categories] => 0
[longdate] => Mon 2nd Jul
[fiveday] => 0
[strokeadjust] => 0.0
[par] => 0
[showentrants] => 0
[vcss] => -1
[vro] => 0
[use_gc] => 0
[paymentamount] =>
[payment_deadline] => 0000-00-00
[nicedeadline] => 00-00-0000
[shotgun] => 0
[live] => 0
[maxtee] => 00:00:00
[mintee] => 00:00:00
[teeslots] => 0
[hole_group_1] => 0
[next_1] => 0
[time_1] => 00:00:00
[hole_group_2] => 0
[next_2] => 0
[time_2] => 00:00:00
[advanced_teetimes] => 0
[touchleaderboard] => 1
[extbookingref] => 0
[signdelayhours] => 0
[signdelayminutes] => 0
[usepi] => 0
[useci] => 0
[reserveonfull] => 0
[reservelistalwaysactive] => 0
[requireactive] => 0
[includecomp] => 0
[startsheet_results_comp] =>
[emails_sent] => 0
[maxhcap] => 0
[maxhcap_mixed_ladies] => 0
[event_id] => 0
[teetimes_comp_only] => 0
[teetimes_exclusive] => 0
[teetimes_custom_interval] => 0.0
[visitor_signup] => 0
[inprogress] => 0
[ballot] =>
[ballotnum] =>
[reserve] =>
[reservenum] =>
[ballotsort] =>
[ballotmethod] =>
[showreserve] =>
[linkcss] =>
[holemask] =>
[noprizeinactive] => 0
[prize_structure] => 0
[practiceroundforcomp] => 0
[roundlabel] =>
[showpics] => 0
[min_age_entry] =>
[max_age_entry] =>
[min_hcap_entry] =>
[max_hcap_entry] =>
[age_entry_type] =>
[cutplayers] => 0
[cutafter] => 0
[cutline_ties] => 0
[playerdisplaytype] => 0
[usepse] => 0
[usepse_leaderboard] => 0
[entrygroup] => 1
[bb_custom] =>
[colour] =>
[somescoretype] => 0
[teeupfront] =>
[entryform] =>
[customdivisions] => 0
[wagr] => 0
[recursivemultiround] => 1
[directpay] =>
[display_handicaps] => 1
[keep_hcap_between_rounds] => 1
[esrstatus] => 0
[nicedate] => Monday 2nd July 2018
)
[competitionModel] => Competition Object
(
[klasses] => Array
(
[competition] => Competition
[team] => Team
[teams] => Teams
[entrant] => Entrant
[entrants] => Entrants
[namesorter] => NameSorter
[user] => User
[result] => Result
[results] => Results
[resultssorter] => CardSorter
[card] => Card
)
[resultsSorter] =>
[_signedUpPlayers:Competition:private] =>
[_previousRoundCompId:Competition:private] =>
[_allFees:Competition:private] =>
[_allPaidFees:Competition:private] =>
[data:protected] => Array
(
[id] => 684
[name] => Ladies 36 Hole Stableford Championship
[start] => 2018-07-02
[end] => 0000-00-00
[winpts] => 0
[losepts] => 0
[drawpts] => 0
[rules] =>
[type] => 2
[groupid] => 0
[courseid] => 66
[image] =>
[numrounds] => 2
[multiday] => 0
[round] => 2
[visibility] => 0
[imported] => 0
[twos] => 0
[tee] => 3
[blurb] =>
[hcapallowance] => 1
[forumid] => 0
[admins] =>
[status] => 3
[betterball] => 0
[link] => 0
[css] => -1
[ident] => NSH
[sss] => 0
[par] => 0
[winner] => 13695
[wintype] => 0
[divisions] => 1
[prizesperdivision] => 0
[div1lim] => 0
[div2lim] => 0
[div3lim] => 0
[div4lim] => 0
[tie1] => 0
[tie2] => 0
[entrants] => 2
[categories] => 0
[strokeadjust] => 0.0
[mixedchild] => 0
[reductiononly] => 0
[qual] => 0
[signup] => 0
[rollup] => 0
[signupopt] =>
[signupstart] => 0000-00-00
[signupend] => 0000-00-00
[signuptimestart] =>
[signuptimeend] =>
[parentcomp] => 684
[numperteam] => 1
[abandoned] =>
[usepi] => 0
[usepse] => 0
[lgu] => 0
[reqcontact] =>
[limitsignup] =>
[limitsignupnum] =>
[enablereservelist] =>
[reqqual] =>
[compadmin] => 0
[teamselect] => 0
[reqpayment] => 0
[showtees] => 0
[open] => 1
[freeformresults] =>
[paymentamount] =>
[use_gc] => 0
[reqcheckin] => 0
[tieres] => 0
[maxhcap] => 0
[maxscore] =>
[maxhcap_mixed_ladies] => 0
[fiveday] => 0
[showentrants] => 0
[vcss] => -1
[vro] => 0
[payment_deadline] => 0000-00-00
[shotgun] => 0
[live] => 0
[mintee] => 00:00:00
[maxtee] => 00:00:00
[teeslots] => 0
[advanced_teetimes] => 0
[touchleaderboard] => 1
[extbookingref] => 0
[time_1] => 00:00:00
[hole_group_2] => 0
[next_2] => 0
[time_2] => 00:00:00
[hole_group_1] => 0
[next_1] => 0
[signdelayhours] => 0
[signdelayminutes] => 0
[reserveonfull] => 0
[reservelistalwaysactive] => 0
[requireactive] => 0
[includecomp] => 0
[emails_sent] => 0
[event_id] => 0
[teetimes_comp_only] => 0
[teetimes_exclusive] => 0
[visitor_signup] => 0
[inprogress] => 0
[ballot] =>
[ballotnum] =>
[ballotsort] =>
[ballotmethod] =>
[reserve] =>
[reservenum] =>
[showreserve] =>
[linkcss] =>
[somescoretype] => 0
[entryform] =>
[div1name] =>
[div2name] =>
[div3name] =>
[div4name] =>
[inactivehide] => 0
[extra] =>
[customdivisions] => 0
[wagr] => 0
[recursivemultiround] => 1
[extrateams] => 0
[directpay] =>
[teeupfront] =>
[esrstatus] => 0
[tsignup] => 0
[useci] => 0
[teetimes_custom_interval] => 0.0
[holemask] =>
[noprizeinactive] => 0
[prize_structure] => 0
[display_handicaps] => 1
[legacy] =>
[legacylegacy_associated] =>
[legacy_associated] =>
[age_entry_type] =>
[min_hcap_entry] =>
[max_hcap_entry] =>
[min_age_entry] =>
[max_age_entry] =>
[practiceroundforcomp] => 0
[roundlabel] =>
[signuptimestartv2] => 00:00:00
[signuptimeendv2] => 00:00:00
[showpics] => 0
[cutplayers] => 0
[cutafter] => 0
[keep_hcap_between_rounds] => 1
[usepse_leaderboard] => 0
[playerdisplaytype] => 0
[pace_subtitle] =>
[entrygroup] => 1
[cutline] => 0
[cutline_ties] => 0
[startsheet_results_comp] =>
[overbookingzone] => 0
[bb_custom] =>
[usepse_marking] => 1
[colour] =>
)
[alreadySerialized] =>
)
[signupStatusInfo] => Array
(
[text] =>
[longText] =>
[signupText] =>
[signupLink] =>
[openText] =>
[closeText] =>
[entered] => 0
)
[feesRequired] =>
[fees] => Array
(
)
[paymentDeadline] => On Entry
[courseInfo] => The Bedford
, Tees - Red, Red, Red
[entrantsInfo] => Ladies
[hcapAllowanceText] => Full Handicap
[compTypeName] => Stableford
[entrantsCount] => 0
[interestedPlayers] =>
[isInterested] =>
[canShowInterest] =>
[onlineSignup] => OnlineSignup Object
(
[compId] => 684
[userId] =>
[isTouchscreen] =>
[_data:protected] => Array
(
[comparray] => Array
(
[id] => 684
[name] => Ladies 36 Hole Stableford Championship
[start] => 2018-07-02
[end] => 0000-00-00
[rules] =>
[type] => 2
[groupid] => 0
[courseid] => 66
[tee] => 3
[image] =>
[numrounds] => 2
[visibility] => 0
[blurb] =>
[imported] => 0
[hcapallowance] => 1
[forumid] => 0
[admins] =>
[status] => 3
[betterball] => 0
[ident] => NSH
[winner] => 13695
[sss] => 0
[css] => -1
[twos] => 0
[signup] => 0
[signupstart] => 0000-00-00
[signupend] => 0000-00-00
[numperteam] => 1
[multiday] => 0
[divisions] => 1
[div1lim] => 0
[div2lim] => 0
[div3lim] => 0
[div4lim] => 0
[parentcomp] => 684
[abandoned] =>
[reductiononly] => 0
[signupopt] =>
[extrateams] => 0
[qual] => 0
[signuptimestart] =>
[signuptimestartv2] => 00:00:00
[signuptimeend] =>
[signuptimeendv2] => 00:00:00
[reqcontact] =>
[entrants] => 2
[nicestart] => 00-00-0000
[niceend] => 00-00-0000
[limitsignup] =>
[limitsignupnum] =>
[enablereservelist] =>
[reqqual] =>
[compadmin] => 0
[teamselect] => 0
[reqpayment] => 0
[overbookingzone] => 0
[wintype] => 0
[showtees] => 0
[prizesperdivision] => 0
[round] => 2
[formdate] => 02-07-2018
[nicetsdate] => Mon 2nd Jul
[open] => 1
[rollup] => 0
[freeformresults] =>
[tieres] => 0
[mixedchild] => 0
[categories] => 0
[longdate] => Mon 2nd Jul
[fiveday] => 0
[strokeadjust] => 0.0
[par] => 0
[showentrants] => 0
[vcss] => -1
[vro] => 0
[use_gc] => 0
[paymentamount] =>
[payment_deadline] => 0000-00-00
[nicedeadline] => 00-00-0000
[shotgun] => 0
[live] => 0
[maxtee] => 00:00:00
[mintee] => 00:00:00
[teeslots] => 0
[hole_group_1] => 0
[next_1] => 0
[time_1] => 00:00:00
[hole_group_2] => 0
[next_2] => 0
[time_2] => 00:00:00
[advanced_teetimes] => 0
[touchleaderboard] => 1
[extbookingref] => 0
[signdelayhours] => 0
[signdelayminutes] => 0
[usepi] => 0
[useci] => 0
[reserveonfull] => 0
[reservelistalwaysactive] => 0
[requireactive] => 0
[includecomp] => 0
[startsheet_results_comp] =>
[emails_sent] => 0
[maxhcap] => 0
[maxhcap_mixed_ladies] => 0
[event_id] => 0
[teetimes_comp_only] => 0
[teetimes_exclusive] => 0
[teetimes_custom_interval] => 0.0
[visitor_signup] => 0
[inprogress] => 0
[ballot] =>
[ballotnum] =>
[reserve] =>
[reservenum] =>
[ballotsort] =>
[ballotmethod] =>
[showreserve] =>
[linkcss] =>
[holemask] =>
[noprizeinactive] => 0
[prize_structure] => 0
[practiceroundforcomp] => 0
[roundlabel] =>
[showpics] => 0
[min_age_entry] =>
[max_age_entry] =>
[min_hcap_entry] =>
[max_hcap_entry] =>
[age_entry_type] =>
[cutplayers] => 0
[cutafter] => 0
[cutline_ties] => 0
[playerdisplaytype] => 0
[usepse] => 0
[usepse_leaderboard] => 0
[entrygroup] => 1
[bb_custom] =>
[colour] =>
[somescoretype] => 0
[teeupfront] =>
[entryform] =>
[customdivisions] => 0
[wagr] => 0
[recursivemultiround] => 1
[directpay] =>
[display_handicaps] => 1
[keep_hcap_between_rounds] => 1
[esrstatus] => 0
[nicedate] => Monday 2nd July 2018
)
[competition] => Competition Object
(
[klasses] => Array
(
[competition] => Competition
[team] => Team
[teams] => Teams
[entrant] => Entrant
[entrants] => Entrants
[namesorter] => NameSorter
[user] => User
[result] => Result
[results] => Results
[resultssorter] => CardSorter
[card] => Card
)
[resultsSorter] =>
[_signedUpPlayers:Competition:private] =>
[_previousRoundCompId:Competition:private] =>
[_allFees:Competition:private] =>
[_allPaidFees:Competition:private] =>
[data:protected] => Array
(
[id] => 684
[name] => Ladies 36 Hole Stableford Championship
[start] => 2018-07-02
[end] => 0000-00-00
[winpts] => 0
[losepts] => 0
[drawpts] => 0
[rules] =>
[type] => 2
[groupid] => 0
[courseid] => 66
[image] =>
[numrounds] => 2
[multiday] => 0
[round] => 2
[visibility] => 0
[imported] => 0
[twos] => 0
[tee] => 3
[blurb] =>
[hcapallowance] => 1
[forumid] => 0
[admins] =>
[status] => 3
[betterball] => 0
[link] => 0
[css] => -1
[ident] => NSH
[sss] => 0
[par] => 0
[winner] => 13695
[wintype] => 0
[divisions] => 1
[prizesperdivision] => 0
[div1lim] => 0
[div2lim] => 0
[div3lim] => 0
[div4lim] => 0
[tie1] => 0
[tie2] => 0
[entrants] => 2
[categories] => 0
[strokeadjust] => 0.0
[mixedchild] => 0
[reductiononly] => 0
[qual] => 0
[signup] => 0
[rollup] => 0
[signupopt] =>
[signupstart] => 0000-00-00
[signupend] => 0000-00-00
[signuptimestart] =>
[signuptimeend] =>
[parentcomp] => 684
[numperteam] => 1
[abandoned] =>
[usepi] => 0
[usepse] => 0
[lgu] => 0
[reqcontact] =>
[limitsignup] =>
[limitsignupnum] =>
[enablereservelist] =>
[reqqual] =>
[compadmin] => 0
[teamselect] => 0
[reqpayment] => 0
[showtees] => 0
[open] => 1
[freeformresults] =>
[paymentamount] =>
[use_gc] => 0
[reqcheckin] => 0
[tieres] => 0
[maxhcap] => 0
[maxscore] =>
[maxhcap_mixed_ladies] => 0
[fiveday] => 0
[showentrants] => 0
[vcss] => -1
[vro] => 0
[payment_deadline] => 0000-00-00
[shotgun] => 0
[live] => 0
[mintee] => 00:00:00
[maxtee] => 00:00:00
[teeslots] => 0
[advanced_teetimes] => 0
[touchleaderboard] => 1
[extbookingref] => 0
[time_1] => 00:00:00
[hole_group_2] => 0
[next_2] => 0
[time_2] => 00:00:00
[hole_group_1] => 0
[next_1] => 0
[signdelayhours] => 0
[signdelayminutes] => 0
[reserveonfull] => 0
[reservelistalwaysactive] => 0
[requireactive] => 0
[includecomp] => 0
[emails_sent] => 0
[event_id] => 0
[teetimes_comp_only] => 0
[teetimes_exclusive] => 0
[visitor_signup] => 0
[inprogress] => 0
[ballot] =>
[ballotnum] =>
[ballotsort] =>
[ballotmethod] =>
[reserve] =>
[reservenum] =>
[showreserve] =>
[linkcss] =>
[somescoretype] => 0
[entryform] =>
[div1name] =>
[div2name] =>
[div3name] =>
[div4name] =>
[inactivehide] => 0
[extra] =>
[customdivisions] => 0
[wagr] => 0
[recursivemultiround] => 1
[extrateams] => 0
[directpay] =>
[teeupfront] =>
[esrstatus] => 0
[tsignup] => 0
[useci] => 0
[teetimes_custom_interval] => 0.0
[holemask] =>
[noprizeinactive] => 0
[prize_structure] => 0
[display_handicaps] => 1
[legacy] =>
[legacylegacy_associated] =>
[legacy_associated] =>
[age_entry_type] =>
[min_hcap_entry] =>
[max_hcap_entry] =>
[min_age_entry] =>
[max_age_entry] =>
[practiceroundforcomp] => 0
[roundlabel] =>
[signuptimestartv2] => 00:00:00
[signuptimeendv2] => 00:00:00
[showpics] => 0
[cutplayers] => 0
[cutafter] => 0
[keep_hcap_between_rounds] => 1
[usepse_leaderboard] => 0
[playerdisplaytype] => 0
[pace_subtitle] =>
[entrygroup] => 1
[cutline] => 0
[cutline_ties] => 0
[startsheet_results_comp] =>
[overbookingzone] => 0
[bb_custom] =>
[usepse_marking] => 1
[colour] =>
)
[alreadySerialized] =>
)
[signupStatus] => 0
[competition2] => Competition2 Object
(
[data:protected] => Array
(
[id] => 684
[name] => Ladies 36 Hole Stableford Championship
[start] => 2018-07-02
[end] => 0000-00-00
[winpts] => 0
[losepts] => 0
[drawpts] => 0
[rules] =>
[type] => 2
[groupid] => 0
[courseid] => 66
[image] =>
[numrounds] => 2
[multiday] => 0
[round] => 2
[visibility] => 0
[imported] => 0
[twos] => 0
[tee] => 3
[blurb] =>
[hcapallowance] => 1
[forumid] => 0
[admins] =>
[status] => 3
[betterball] => 0
[link] => 0
[css] => -1
[ident] => NSH
[sss] => 0
[par] => 0
[winner] => 13695
[wintype] => 0
[divisions] => 1
[prizesperdivision] => 0
[div1lim] => 0
[div2lim] => 0
[div3lim] => 0
[div4lim] => 0
[tie1] => 0
[tie2] => 0
[entrants] => 2
[categories] => 0
[strokeadjust] => 0.0
[mixedchild] => 0
[reductiononly] => 0
[qual] => 0
[signup] => 0
[rollup] => 0
[signupopt] =>
[signupstart] => 0000-00-00
[signupend] => 0000-00-00
[signuptimestart] =>
[signuptimeend] =>
[parentcomp] => 684
[numperteam] => 1
[abandoned] =>
[usepi] => 0
[usepse] => 0
[lgu] => 0
[reqcontact] =>
[limitsignup] =>
[limitsignupnum] =>
[enablereservelist] =>
[reqqual] =>
[compadmin] => 0
[teamselect] => 0
[reqpayment] => 0
[showtees] => 0
[open] => 1
[freeformresults] =>
[paymentamount] =>
[use_gc] => 0
[reqcheckin] => 0
[tieres] => 0
[maxhcap] => 0
[maxscore] =>
[maxhcap_mixed_ladies] => 0
[fiveday] => 0
[showentrants] => 0
[vcss] => -1
[vro] => 0
[payment_deadline] => 0000-00-00
[shotgun] => 0
[live] => 0
[mintee] => 00:00:00
[maxtee] => 00:00:00
[teeslots] => 0
[advanced_teetimes] => 0
[touchleaderboard] => 1
[extbookingref] => 0
[time_1] => 00:00:00
[hole_group_2] => 0
[next_2] => 0
[time_2] => 00:00:00
[hole_group_1] => 0
[next_1] => 0
[signdelayhours] => 0
[signdelayminutes] => 0
[reserveonfull] => 0
[reservelistalwaysactive] => 0
[requireactive] => 0
[includecomp] => 0
[emails_sent] => 0
[event_id] => 0
[teetimes_comp_only] => 0
[teetimes_exclusive] => 0
[visitor_signup] => 0
[inprogress] => 0
[ballot] =>
[ballotnum] =>
[ballotsort] =>
[ballotmethod] =>
[reserve] =>
[reservenum] =>
[showreserve] =>
[linkcss] =>
[somescoretype] => 0
[entryform] =>
[div1name] =>
[div2name] =>
[div3name] =>
[div4name] =>
[inactivehide] => 0
[extra] =>
[customdivisions] => 0
[wagr] => 0
[recursivemultiround] => 1
[extrateams] => 0
[directpay] =>
[teeupfront] =>
[esrstatus] => 0
[tsignup] => 0
[useci] => 0
[teetimes_custom_interval] => 0.0
[holemask] =>
[noprizeinactive] => 0
[prize_structure] => 0
[display_handicaps] => 1
[legacy] =>
[legacylegacy_associated] =>
[legacy_associated] =>
[age_entry_type] =>
[min_hcap_entry] =>
[max_hcap_entry] =>
[min_age_entry] =>
[max_age_entry] =>
[practiceroundforcomp] => 0
[roundlabel] =>
[signuptimestartv2] => 00:00:00
[signuptimeendv2] => 00:00:00
[showpics] => 0
[cutplayers] => 0
[cutafter] => 0
[keep_hcap_between_rounds] => 1
[usepse_leaderboard] => 0
[playerdisplaytype] => 0
[pace_subtitle] =>
[entrygroup] => 1
[cutline] => 0
[cutline_ties] => 0
[startsheet_results_comp] =>
[overbookingzone] => 0
[bb_custom] =>
[usepse_marking] => 1
[colour] =>
)
[alreadySerialized] =>
)
[entrants] => Array
(
)
)
[userdata] =>
)
[compEntryImage] => 1
[boardComp] =>
)
[file] => templates/competition2_details.php
[scriptFile] =>
[noroot] =>
)
[type] => ->
[args] => Array
(
)
)
[6] => Array
(
[file] => /data/competition2.php
[line] => 51
[function] => fetchPageContent
[args] => Array
(
)
)
)
error in SELECT p.forename, p.surname, p.user_id
FROM sm_signup s, sm_users p
WHERE s.teamid=
AND compid=649
AND s.playerid=p.user_id: (teammembersbyid)You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND compid=649
AND s.playerid=p.user_id' at line 41