https://wiki.christchurchchislehurst.org/index.php?action=history&feed=atom&title=Website_Clear_Down_DPCalendar_Events
Website Clear Down DPCalendar Events - Revision history
2026-04-13T08:17:41Z
Revision history for this page on the wiki
MediaWiki 1.31.0
https://wiki.christchurchchislehurst.org/index.php?title=Website_Clear_Down_DPCalendar_Events&diff=39421&oldid=prev
Marc.maier at 22:23, 10 July 2015
2015-07-10T22:23:50Z
<p></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<col class="diff-marker" />
<col class="diff-content" />
<col class="diff-marker" />
<col class="diff-content" />
<tr class="diff-title" lang="en">
<td colspan="2" style="background-color: #fff; color: #222; text-align: center;">← Older revision</td>
<td colspan="2" style="background-color: #fff; color: #222; text-align: center;">Revision as of 22:23, 10 July 2015</td>
</tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l3" >Line 3:</td>
<td colspan="2" class="diff-lineno">Line 3:</td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; 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>   SELECT id FROM (</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; 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>   SELECT id FROM (</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; 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>   SELECT id FROM ccc_dpcalendar_events e</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; 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>   SELECT id FROM ccc_dpcalendar_events e</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #222; 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>   WHERE (original_id <> -1 AND end_date < '2015-07-01')  </div></td><td class='diff-marker'>+</td><td style="color: #222; 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>   WHERE (original_id <> -1 AND end_date < '<ins class="diffchange diffchange-inline">[date, e.g. </ins>2015-07-01<ins class="diffchange diffchange-inline">]</ins>')  </div></td></tr>
<tr><td class='diff-marker'>−</td><td style="color: #222; 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>   OR (original_id = -1 AND '2015-07-01' >  </div></td><td class='diff-marker'>+</td><td style="color: #222; 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>   OR (original_id = -1 AND '<ins class="diffchange diffchange-inline">[date, e.g. </ins>2015-07-01<ins class="diffchange diffchange-inline">]</ins>' >  </div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; 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>   (SELECT MAX(end_date) FROM ccc_dpcalendar_events  WHERE original_id = e.id))</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; 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>   (SELECT MAX(end_date) FROM ccc_dpcalendar_events  WHERE original_id = e.id))</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; 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>   ) x</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; 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>   ) x</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #222; 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: #222; 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>
</table>
Marc.maier
https://wiki.christchurchchislehurst.org/index.php?title=Website_Clear_Down_DPCalendar_Events&diff=39420&oldid=prev
Marc.maier: Created page with "To clear down DPCalendar events that are no longer required. Please follow run the following SQL via the phpAdmin console which is accessible via the [https://212.227.59.105:8..."
2015-07-10T22:23:22Z
<p>Created page with "To clear down DPCalendar events that are no longer required. Please follow run the following SQL via the phpAdmin console which is accessible via the [https://212.227.59.105:8..."</p>
<p><b>New page</b></p><div>To clear down DPCalendar events that are no longer required. Please follow run the following SQL via the phpAdmin console which is accessible via the [https://212.227.59.105:8443/smb/database/list/domainId/8 Parallel administration panel].<br />
DELETE FROM ccc_dpcalendar_events WHERE id IN (<br />
SELECT id FROM (<br />
SELECT id FROM ccc_dpcalendar_events e<br />
WHERE (original_id <> -1 AND end_date < '2015-07-01') <br />
OR (original_id = -1 AND '2015-07-01' > <br />
(SELECT MAX(end_date) FROM ccc_dpcalendar_events WHERE original_id = e.id))<br />
) x<br />
)</div>
Marc.maier