שם רוטר
אין תקציר עריכה |
מ (החלפת טקסט – "{{פרופיל" ב־"{{פרופיל כדורגל ") |
||
| שורה 1: | שורה 1: | ||
{{פרופיל|שם מלא=רוטר|עמדה=קישור|שחקן מכבי=כן|פרש ממשחק=כן}} | {{פרופיל כדורגל |שם מלא=רוטר|עמדה=קישור|שחקן מכבי=כן|פרש ממשחק=כן}} | ||
שגיאה בביטוי: אופרטור < בלתי־צפוי.
שם רוטר
עונות 1
תארים 6
עמדה
מס' חולצה
[[קטגוריה: שחקנים שלבשו מספרהופעות 1 0 כמחליף
ספיגות 1 1.00 למשחק, 0 בפנדל
שער נקי 0 0.00%
הדיפות פנדלים 0 0.00%
שערים 0 0.00 למשחק, 0 בפנדל
בישולים 0 0.00 למשחק, 0 סחיטות פנדל
צהובים 0 0.00 למשחק
אדומים 0 0.00 למשחק
ניצחונות 0 0.00%
תיקו 1 100.00%
הפסדים 0 0.00%
הופעות 1 0 כמחליף
ספיגות 1 1.00 למשחק, 0 בפנדל
שער נקי 0 0.00%
הדיפות פנדלים 0 0.00%
שערים 0 0.00 למשחק, 0 בפנדל
בישולים 0 0.00 למשחק, 0 סחיטות פנדל
צהובים 0 0.00 למשחק
אדומים 0 0.00 למשחק
ניצחונות 0 0.00%
תיקו 1 100.00%
הפסדים 0 0.00%
הופעות 0 0 כמחליף
ספיגות 0
שער נקי 0
הדיפות פנדלים 0
שערים 0
בישולים 0
צהובים 0
אדומים 0
ניצחונות 0
תיקו 0
הפסדים 0
הופעות 0 0 כמחליף
ספיגות 0
שער נקי 0
הדיפות פנדלים 0
שערים 0
בישולים 0
צהובים 0
אדומים 0
ניצחונות 0
תיקו 0
הפסדים 0
הופעות 0 0 כמחליף
ספיגות 0
שער נקי 0
הדיפות פנדלים 0
שערים 0
בישולים 0
צהובים 0
אדומים 0
ניצחונות 0
תיקו 0
הפסדים 0
Function: CargoSQLQuery::run Query: SELECT `fg`.`Season` AS `Season`,COUNT(CASE WHEN `fg`.`ResultOpt`=1 THEN 1 ELSE NULL END) AS `WinCount`,COUNT(CASE WHEN `fg`.`ResultOpt`=2 THEN 2 ELSE NULL END) AS `TieCount`,COUNT(CASE WHEN `fg`.`ResultOpt`=3 THEN 3 ELSE NULL END) AS `LooseCount` FROM `MPMW_cargo__Football_Games` `fg` LEFT OUTER JOIN `MPMW_cargo__Games_Events` `ge` ON ((`fg`.`_pageName`=`ge`.`_pageName`)) LEFT OUTER JOIN `MPMW_cargo__Competitions` `c` ON ((`fg`.`Competition`=`c`.`OriginalName`)) WHERE `ge`.`PlayerName`="רוטר" AND `ge`.`EventType` IN (1, 5) AND `ge`.`Team`=1 AND `fg`.`Season` IN ("<div class="error">Cannot access the database: :real_connect(): (42000/1226): User 'maccabit_MaccabiPedia' has exceeded the 'max_user_connections' resource (current value: 30)</div>")
AND `c`.`Official` = 1 GROUP BY `Season` ORDER BY `Season` DESC LIMIT 100
Function: CargoSQLQuery::run Query: SELECT `fg`.`Season` AS `Season`,COUNT(CASE WHEN `fg`.`ResultOpt`=1 THEN 1 ELSE NULL END) AS `WinCount`,COUNT(CASE WHEN `fg`.`ResultOpt`=2 THEN 2 ELSE NULL END) AS `TieCount`,COUNT(CASE WHEN `fg`.`ResultOpt`=3 THEN 3 ELSE NULL END) AS `LooseCount` FROM `MPMW_cargo__Football_Games` `fg` LEFT OUTER JOIN `MPMW_cargo__Games_Events` `ge` ON ((`fg`.`_pageName`=`ge`.`_pageName`)) LEFT OUTER JOIN `MPMW_cargo__Competitions` `c` ON ((`fg`.`Competition`=`c`.`OriginalName`)) WHERE `ge`.`PlayerName`="רוטר" AND `ge`.`EventType` IN (1, 5) AND `ge`.`Team`=1 AND `fg`.`Season` IN ("<div class="error">Cannot access the database: :real_connect(): (42000/1226): User 'maccabit_MaccabiPedia' has exceeded the 'max_user_connections' resource (current value: 30)</div>") AND `c`.`League` = 1 GROUP BY `Season` ORDER BY `Season` DESC LIMIT 100
Function: CargoSQLQuery::run Query: SELECT `fg`.`Season` AS `Season`,COUNT(CASE WHEN `fg`.`ResultOpt`=1 THEN 1 ELSE NULL END) AS `WinCount`,COUNT(CASE WHEN `fg`.`ResultOpt`=2 THEN 2 ELSE NULL END) AS `TieCount`,COUNT(CASE WHEN `fg`.`ResultOpt`=3 THEN 3 ELSE NULL END) AS `LooseCount` FROM `MPMW_cargo__Football_Games` `fg` LEFT OUTER JOIN `MPMW_cargo__Games_Events` `ge` ON ((`fg`.`_pageName`=`ge`.`_pageName`)) LEFT OUTER JOIN `MPMW_cargo__Competitions` `c` ON ((`fg`.`Competition`=`c`.`OriginalName`)) WHERE `ge`.`PlayerName`="רוטר" AND `ge`.`EventType` IN (1, 5) AND `ge`.`Team`=1 AND `fg`.`Season` IN ("<div class="error">Cannot access the database: :real_connect(): (42000/1226): User 'maccabit_MaccabiPedia' has exceeded the 'max_user_connections' resource (current value: 30)</div>")
AND `c`.`Trophy` = 1 GROUP BY `Season` ORDER BY `Season` DESC LIMIT 100
Function: CargoSQLQuery::run Query: SELECT `fg`.`Season` AS `Season`,COUNT(CASE WHEN `fg`.`ResultOpt`=1 THEN 1 ELSE NULL END) AS `WinCount`,COUNT(CASE WHEN `fg`.`ResultOpt`=2 THEN 2 ELSE NULL END) AS `TieCount`,COUNT(CASE WHEN `fg`.`ResultOpt`=3 THEN 3 ELSE NULL END) AS `LooseCount` FROM `MPMW_cargo__Football_Games` `fg` LEFT OUTER JOIN `MPMW_cargo__Games_Events` `ge` ON ((`fg`.`_pageName`=`ge`.`_pageName`)) LEFT OUTER JOIN `MPMW_cargo__Competitions` `c` ON ((`fg`.`Competition`=`c`.`OriginalName`)) WHERE `ge`.`PlayerName`="רוטר" AND `ge`.`EventType` IN (1, 5) AND `ge`.`Team`=1 AND `fg`.`Season` IN ("<div class="error">Cannot access the database: :real_connect(): (42000/1226): User 'maccabit_MaccabiPedia' has exceeded the 'max_user_connections' resource (current value: 30)</div>")
AND `c`.`International` = 1 GROUP BY `Season` ORDER BY `Season` DESC LIMIT 100
Function: CargoSQLQuery::run Query: SELECT `fg`.`Season` AS `Season`,COUNT(CASE WHEN `fg`.`ResultOpt`=1 THEN 1 ELSE NULL END) AS `WinCount`,COUNT(CASE WHEN `fg`.`ResultOpt`=2 THEN 2 ELSE NULL END) AS `TieCount`,COUNT(CASE WHEN `fg`.`ResultOpt`=3 THEN 3 ELSE NULL END) AS `LooseCount` FROM `MPMW_cargo__Football_Games` `fg` LEFT OUTER JOIN `MPMW_cargo__Games_Events` `ge` ON ((`fg`.`_pageName`=`ge`.`_pageName`)) LEFT OUTER JOIN `MPMW_cargo__Competitions` `c` ON ((`fg`.`Competition`=`c`.`OriginalName`)) WHERE `ge`.`PlayerName`="רוטר" AND `ge`.`EventType` IN (1, 5) AND `ge`.`Team`=1 AND `fg`.`Season` IN ("<div class="error">Cannot access the database: :real_connect(): (42000/1226): User 'maccabit_MaccabiPedia' has exceeded the 'max_user_connections' resource (current value: 30)</div>")
AND (`c`.`Official` = 1 AND `c`.`League` = 0 AND `c`.`Trophy` = 0 AND `c`.`International` = 0) GROUP BY `Season` ORDER BY `Season` DESC LIMIT 100
Function: CargoSQLQuery::run Query: SELECT `fg`.`Season` AS `Season`,COUNT(CASE WHEN `ge`.`EventType`=1 OR `ge`.`EventType`=5 THEN 1 ELSE NULL END) AS `Total App`,COUNT(CASE WHEN `ge`.`EventType`=5 THEN 1 ELSE NULL END) AS `Subtitue App`,COUNT(CASE WHEN `ge`.`EventType`=3 AND `ge`.`SubType`!=33 THEN 1 ELSE NULL END) AS `Total Goals`,COUNT(CASE WHEN `ge`.`SubType`=35 THEN 1 ELSE NULL END) AS `Penalty Goals`,COUNT(CASE WHEN `ge`.`EventType`=4 THEN 1 ELSE NULL END) AS `Assists`,COUNT(CASE WHEN `ge`.`SubType`=71 THEN 1 ELSE NULL END) AS `First Yellow Card`,COUNT(CASE WHEN `ge`.`SubType`=72 THEN 1 ELSE NULL END) AS `Second Yellow Card`,COUNT(CASE WHEN `ge`.`SubType`=73 THEN 1 ELSE NULL END) AS `Direct Red Card`,COUNT(CASE WHEN `ge`.`SubType`=83 THEN 1 ELSE NULL END) AS `PenaltyLurch` FROM `MPMW_cargo__Football_Games` `fg` LEFT OUTER JOIN `MPMW_cargo__Games_Events` `ge` ON ((`fg`.`_pageName`=`ge`.`_pageName`)) LEFT OUTER JOIN `MPMW_cargo__Competitions` `c` ON ((`fg`.`Competition`=`c`.`OriginalName`)) WHERE `ge`.`PlayerName`="רוטר" AND `ge`.`Team`=1 AND `fg`.`Season` IN ("<div class="error">Cannot access the database: :real_connect(): (42000/1226): User 'maccabit_MaccabiPedia' has exceeded the 'max_user_connections' resource (current value: 30)</div>")
AND `c`.`Official` = 1 GROUP BY `Season` ORDER BY `Season` DESC LIMIT 100
Function: CargoSQLQuery::run Query: SELECT `fg`.`Season` AS `Season`,COUNT(CASE WHEN `ge`.`EventType`=1 OR `ge`.`EventType`=5 THEN 1 ELSE NULL END) AS `Total App`,COUNT(CASE WHEN `ge`.`EventType`=5 THEN 1 ELSE NULL END) AS `Subtitue App`,COUNT(CASE WHEN `ge`.`EventType`=3 AND `ge`.`SubType`!=33 THEN 1 ELSE NULL END) AS `Total Goals`,COUNT(CASE WHEN `ge`.`SubType`=35 THEN 1 ELSE NULL END) AS `Penalty Goals`,COUNT(CASE WHEN `ge`.`EventType`=4 THEN 1 ELSE NULL END) AS `Assists`,COUNT(CASE WHEN `ge`.`SubType`=71 THEN 1 ELSE NULL END) AS `First Yellow Card`,COUNT(CASE WHEN `ge`.`SubType`=72 THEN 1 ELSE NULL END) AS `Second Yellow Card`,COUNT(CASE WHEN `ge`.`SubType`=73 THEN 1 ELSE NULL END) AS `Direct Red Card`,COUNT(CASE WHEN `ge`.`SubType`=83 THEN 1 ELSE NULL END) AS `PenaltyLurch` FROM `MPMW_cargo__Football_Games` `fg` LEFT OUTER JOIN `MPMW_cargo__Games_Events` `ge` ON ((`fg`.`_pageName`=`ge`.`_pageName`)) LEFT OUTER JOIN `MPMW_cargo__Competitions` `c` ON ((`fg`.`Competition`=`c`.`OriginalName`)) WHERE `ge`.`PlayerName`="רוטר" AND `ge`.`Team`=1 AND `fg`.`Season` IN ("<div class="error">Cannot access the database: :real_connect(): (42000/1226): User 'maccabit_MaccabiPedia' has exceeded the 'max_user_connections' resource (current value: 30)</div>") AND `c`.`League` = 1 GROUP BY `Season` ORDER BY `Season` DESC LIMIT 100
Function: CargoSQLQuery::run Query: SELECT `fg`.`Season` AS `Season`,COUNT(CASE WHEN `ge`.`EventType`=1 OR `ge`.`EventType`=5 THEN 1 ELSE NULL END) AS `Total App`,COUNT(CASE WHEN `ge`.`EventType`=5 THEN 1 ELSE NULL END) AS `Subtitue App`,COUNT(CASE WHEN `ge`.`EventType`=3 AND `ge`.`SubType`!=33 THEN 1 ELSE NULL END) AS `Total Goals`,COUNT(CASE WHEN `ge`.`SubType`=35 THEN 1 ELSE NULL END) AS `Penalty Goals`,COUNT(CASE WHEN `ge`.`EventType`=4 THEN 1 ELSE NULL END) AS `Assists`,COUNT(CASE WHEN `ge`.`SubType`=71 THEN 1 ELSE NULL END) AS `First Yellow Card`,COUNT(CASE WHEN `ge`.`SubType`=72 THEN 1 ELSE NULL END) AS `Second Yellow Card`,COUNT(CASE WHEN `ge`.`SubType`=73 THEN 1 ELSE NULL END) AS `Direct Red Card`,COUNT(CASE WHEN `ge`.`SubType`=83 THEN 1 ELSE NULL END) AS `PenaltyLurch` FROM `MPMW_cargo__Football_Games` `fg` LEFT OUTER JOIN `MPMW_cargo__Games_Events` `ge` ON ((`fg`.`_pageName`=`ge`.`_pageName`)) LEFT OUTER JOIN `MPMW_cargo__Competitions` `c` ON ((`fg`.`Competition`=`c`.`OriginalName`)) WHERE `ge`.`PlayerName`="רוטר" AND `ge`.`Team`=1 AND `fg`.`Season` IN ("<div class="error">Cannot access the database: :real_connect(): (42000/1226): User 'maccabit_MaccabiPedia' has exceeded the 'max_user_connections' resource (current value: 30)</div>")
AND `c`.`Trophy` = 1 GROUP BY `Season` ORDER BY `Season` DESC LIMIT 100
Function: CargoSQLQuery::run Query: SELECT `fg`.`Season` AS `Season`,COUNT(CASE WHEN `ge`.`EventType`=1 OR `ge`.`EventType`=5 THEN 1 ELSE NULL END) AS `Total App`,COUNT(CASE WHEN `ge`.`EventType`=5 THEN 1 ELSE NULL END) AS `Subtitue App`,COUNT(CASE WHEN `ge`.`EventType`=3 AND `ge`.`SubType`!=33 THEN 1 ELSE NULL END) AS `Total Goals`,COUNT(CASE WHEN `ge`.`SubType`=35 THEN 1 ELSE NULL END) AS `Penalty Goals`,COUNT(CASE WHEN `ge`.`EventType`=4 THEN 1 ELSE NULL END) AS `Assists`,COUNT(CASE WHEN `ge`.`SubType`=71 THEN 1 ELSE NULL END) AS `First Yellow Card`,COUNT(CASE WHEN `ge`.`SubType`=72 THEN 1 ELSE NULL END) AS `Second Yellow Card`,COUNT(CASE WHEN `ge`.`SubType`=73 THEN 1 ELSE NULL END) AS `Direct Red Card`,COUNT(CASE WHEN `ge`.`SubType`=83 THEN 1 ELSE NULL END) AS `PenaltyLurch` FROM `MPMW_cargo__Football_Games` `fg` LEFT OUTER JOIN `MPMW_cargo__Games_Events` `ge` ON ((`fg`.`_pageName`=`ge`.`_pageName`)) LEFT OUTER JOIN `MPMW_cargo__Competitions` `c` ON ((`fg`.`Competition`=`c`.`OriginalName`)) WHERE `ge`.`PlayerName`="רוטר" AND `ge`.`Team`=1 AND `fg`.`Season` IN ("<div class="error">Cannot access the database: :real_connect(): (42000/1226): User 'maccabit_MaccabiPedia' has exceeded the 'max_user_connections' resource (current value: 30)</div>")
AND `c`.`International` = 1 GROUP BY `Season` ORDER BY `Season` DESC LIMIT 100
Function: CargoSQLQuery::run Query: SELECT `fg`.`Season` AS `Season`,COUNT(CASE WHEN `ge`.`EventType`=1 OR `ge`.`EventType`=5 THEN 1 ELSE NULL END) AS `Total App`,COUNT(CASE WHEN `ge`.`EventType`=5 THEN 1 ELSE NULL END) AS `Subtitue App`,COUNT(CASE WHEN `ge`.`EventType`=3 AND `ge`.`SubType`!=33 THEN 1 ELSE NULL END) AS `Total Goals`,COUNT(CASE WHEN `ge`.`SubType`=35 THEN 1 ELSE NULL END) AS `Penalty Goals`,COUNT(CASE WHEN `ge`.`EventType`=4 THEN 1 ELSE NULL END) AS `Assists`,COUNT(CASE WHEN `ge`.`SubType`=71 THEN 1 ELSE NULL END) AS `First Yellow Card`,COUNT(CASE WHEN `ge`.`SubType`=72 THEN 1 ELSE NULL END) AS `Second Yellow Card`,COUNT(CASE WHEN `ge`.`SubType`=73 THEN 1 ELSE NULL END) AS `Direct Red Card`,COUNT(CASE WHEN `ge`.`SubType`=83 THEN 1 ELSE NULL END) AS `PenaltyLurch` FROM `MPMW_cargo__Football_Games` `fg` LEFT OUTER JOIN `MPMW_cargo__Games_Events` `ge` ON ((`fg`.`_pageName`=`ge`.`_pageName`)) LEFT OUTER JOIN `MPMW_cargo__Competitions` `c` ON ((`fg`.`Competition`=`c`.`OriginalName`)) WHERE `ge`.`PlayerName`="רוטר" AND `ge`.`Team`=1 AND `fg`.`Season` IN ("<div class="error">Cannot access the database: :real_connect(): (42000/1226): User 'maccabit_MaccabiPedia' has exceeded the 'max_user_connections' resource (current value: 30)</div>")
AND (`c`.`Official` = 1 AND `c`.`League` = 0 AND `c`.`Trophy` = 0 AND `c`.`International` = 0) GROUP BY `Season` ORDER BY `Season` DESC LIMIT 100