https://www.maccabipedia.co.il/index.php?action=history&feed=atom&title=%D7%A9%D7%97%D7%A7%D7%A0%D7%99%D7%9D_%D7%A9%D7%94%D7%99%D7%95_%D7%9E%D7%A2%D7%95%D7%A8%D7%91%D7%99%D7%9D_%D7%91%D7%A9%D7%A0%D7%99_%D7%A9%D7%A2%D7%A8%D7%99%D7%9D_%D7%91%D7%90%D7%95%D7%AA%D7%94_%D7%94%D7%93%D7%A7%D7%94 2026-04-24T05:44:58Z היסטוריית הגרסאות של הדף הזה בוויקי MediaWiki 1.39.11 https://www.maccabipedia.co.il/index.php?title=%D7%A9%D7%97%D7%A7%D7%A0%D7%99%D7%9D_%D7%A9%D7%94%D7%99%D7%95_%D7%9E%D7%A2%D7%95%D7%A8%D7%91%D7%99%D7%9D_%D7%91%D7%A9%D7%A0%D7%99_%D7%A9%D7%A2%D7%A8%D7%99%D7%9D_%D7%91%D7%90%D7%95%D7%AA%D7%94_%D7%94%D7%93%D7%A7%D7%94&diff=114392&oldid=prev 2023-04-20T22:45:13Z

<p>Kosh העביר את הדף <a href="/index.php?title=%D7%A9%D7%97%D7%A7%D7%A0%D7%99%D7%9D_%D7%A9%D7%9B%D7%91%D7%A9%D7%95_%D7%95%D7%91%D7%99%D7%A9%D7%9C%D7%95_%D7%90%D7%AA_%D7%90%D7%95%D7%AA%D7%95_%D7%94%D7%A9%D7%A2%D7%A8&amp;action=edit&amp;redlink=1" class="new" title="שחקנים שכבשו ובישלו את אותו השער (הדף אינו קיים)">שחקנים שכבשו ובישלו את אותו השער</a> לשם <a href="/%D7%A9%D7%97%D7%A7%D7%A0%D7%99%D7%9D_%D7%A9%D7%94%D7%99%D7%95_%D7%9E%D7%A2%D7%95%D7%A8%D7%91%D7%99%D7%9D_%D7%91%D7%A9%D7%A0%D7%99_%D7%A9%D7%A2%D7%A8%D7%99%D7%9D_%D7%91%D7%90%D7%95%D7%AA%D7%94_%D7%94%D7%93%D7%A7%D7%94" title="שחקנים שהיו מעורבים בשני שערים באותה הדקה">שחקנים שהיו מעורבים בשני שערים באותה הדקה</a> בלי להשאיר הפניה</p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="he"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">→ הגרסה הקודמת</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">גרסה מ־01:45, 21 באפריל 2023</td> </tr> <!-- diff cache key maccabit_MaccabiPedia-MPMW_:diff::1.12:old-114391:rev-114392 --> </table>

Kosh https://www.maccabipedia.co.il/index.php?title=%D7%A9%D7%97%D7%A7%D7%A0%D7%99%D7%9D_%D7%A9%D7%94%D7%99%D7%95_%D7%9E%D7%A2%D7%95%D7%A8%D7%91%D7%99%D7%9D_%D7%91%D7%A9%D7%A0%D7%99_%D7%A9%D7%A2%D7%A8%D7%99%D7%9D_%D7%91%D7%90%D7%95%D7%AA%D7%94_%D7%94%D7%93%D7%A7%D7%94&diff=114391&oldid=prev 2023-04-20T22:44:57Z

<p></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="he"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">→ הגרסה הקודמת</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">גרסה מ־01:44, 21 באפריל 2023</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l1">שורה 1:</td> <td colspan="2" class="diff-lineno">שורה 1:</td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>כל השחקנים שיש להם שער <del style="font-weight: bold; text-decoration: none;">ובישול </del>באותה הדקה, זה <del style="font-weight: bold; text-decoration: none;">לא אפשרי אלא אם כן נכבשו שני שערים באותה הדקה:</del></div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">{{תיבת טקסט</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">|כותרת=שחקנים שהיו מעורבים בשני שערים באותה הדקה</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">|תוכן=שליפה זו מראה את </ins>כל השחקנים שיש להם <ins style="font-weight: bold; text-decoration: none;">יותר מאירוע אחד של (בישול או </ins>שער<ins style="font-weight: bold; text-decoration: none;">) באותה דקה, משמע שהם כבשו פעמיים, בישלו פעמיים או כבשו ובישלו </ins>באותה הדקה, <ins style="font-weight: bold; text-decoration: none;">בד&quot;כ מדובר בטעות, אך יתכן כי מצב </ins>זה <ins style="font-weight: bold; text-decoration: none;">קרה בעבר.</ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> </div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>{{#cargo_query:</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>{{#cargo_query:</div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>tables=Games_Events<del style="font-weight: bold; text-decoration: none;">, Games_Events=Events2</del></div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>tables=Games_Events</div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;">|join on=Games_Events._pageID = Events2._pageID</del></div></td><td colspan="2" class="diff-side-added"></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>|where=1=1</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>|where=1=1</div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>AND Games_Events.<del style="font-weight: bold; text-decoration: none;">PlayerName </del>= <del style="font-weight: bold; text-decoration: none;">Events2</del>.<del style="font-weight: bold; text-decoration: none;">PlayerName</del></div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>AND Games_Events.<ins style="font-weight: bold; text-decoration: none;">EventType IN (3, 4)</ins></div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;">AND </del>Games_Events.<del style="font-weight: bold; text-decoration: none;">EventType = 3</del></div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">|fields</ins>=<ins style="font-weight: bold; text-decoration: none;">Games_Events</ins>.<ins style="font-weight: bold; text-decoration: none;">_pageName, </ins>Games_Events.<ins style="font-weight: bold; text-decoration: none;">PlayerName, </ins>Games_Events.Minute<ins style="font-weight: bold; text-decoration: none;">, COUNT(*)</ins>=<ins style="font-weight: bold; text-decoration: none;">כמות אירועים</ins></div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;">AND Events2.EventType = 4</del></div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>|<ins style="font-weight: bold; text-decoration: none;">group by</ins>=Games_Events.<ins style="font-weight: bold; text-decoration: none;">_pageID</ins>, Games_Events.PlayerName, Games_Events.Minute</div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;">AND </del>Games_Events.Minute = <del style="font-weight: bold; text-decoration: none;">Events2.Minute</del></div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">|having=COUNT(*) &gt; 1</ins></div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>|<del style="font-weight: bold; text-decoration: none;">fields</del>=Games_Events.<del style="font-weight: bold; text-decoration: none;">_pageName</del>, Games_Events.PlayerName, Games_Events.Minute</div></td><td colspan="2" class="diff-side-added"></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>}}</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>}}</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br/></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">}}</ins></div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[[קטגוריה:עמודי מעקב למשחקים]]</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>[[קטגוריה:עמודי מעקב למשחקים]]</div></td></tr> <!-- diff cache key maccabit_MaccabiPedia-MPMW_:diff::1.12:old-99035:rev-114391 --> </table>

Kosh https://www.maccabipedia.co.il/index.php?title=%D7%A9%D7%97%D7%A7%D7%A0%D7%99%D7%9D_%D7%A9%D7%94%D7%99%D7%95_%D7%9E%D7%A2%D7%95%D7%A8%D7%91%D7%99%D7%9D_%D7%91%D7%A9%D7%A0%D7%99_%D7%A9%D7%A2%D7%A8%D7%99%D7%9D_%D7%91%D7%90%D7%95%D7%AA%D7%94_%D7%94%D7%93%D7%A7%D7%94&diff=99035&oldid=prev 2022-04-09T16:27:08Z

<p>יצירת דף עם התוכן &quot;כל השחקנים שיש להם שער ובישול באותה הדקה, זה לא אפשרי אלא אם כן נכבשו שני שערים באותה הדקה...&quot;</p> <p><b>דף חדש</b></p><div>כל השחקנים שיש להם שער ובישול באותה הדקה, זה לא אפשרי אלא אם כן נכבשו שני שערים באותה הדקה:<br /> <br /> {{#cargo_query:<br /> tables=Games_Events, Games_Events=Events2<br /> |join on=Games_Events._pageID = Events2._pageID<br /> |where=1=1<br /> AND Games_Events.PlayerName = Events2.PlayerName<br /> AND Games_Events.EventType = 3<br /> AND Events2.EventType = 4<br /> AND Games_Events.Minute = Events2.Minute<br /> |fields=Games_Events._pageName, Games_Events.PlayerName, Games_Events.Minute<br /> }}<br /> <br /> [[קטגוריה:עמודי מעקב למשחקים]]</div>

Kosh