Difference between revisions of "Website Clear Down DPCalendar Events"

From CCCWiki
Jump to: navigation, search
(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...")
 
 
Line 3: Line 3:
 
   SELECT id FROM (
 
   SELECT id FROM (
 
   SELECT id FROM ccc_dpcalendar_events e
 
   SELECT id FROM ccc_dpcalendar_events e
   WHERE (original_id <> -1 AND end_date < '2015-07-01')  
+
   WHERE (original_id <> -1 AND end_date < '[date, e.g. 2015-07-01]')  
   OR (original_id = -1 AND '2015-07-01' >  
+
   OR (original_id = -1 AND '[date, e.g. 2015-07-01]' >  
 
   (SELECT MAX(end_date) FROM ccc_dpcalendar_events  WHERE original_id = e.id))
 
   (SELECT MAX(end_date) FROM ccc_dpcalendar_events  WHERE original_id = e.id))
 
   ) x
 
   ) x
 
   )
 
   )

Latest revision as of 22:23, 10 July 2015

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 Parallel administration panel.

 DELETE FROM ccc_dpcalendar_events WHERE id IN (
 	SELECT id FROM (
 		SELECT id FROM ccc_dpcalendar_events e
 			WHERE (original_id <> -1 AND end_date < '[date, e.g. 2015-07-01]') 
 				OR (original_id = -1 AND '[date, e.g. 2015-07-01]' > 
 				(SELECT MAX(end_date) FROM ccc_dpcalendar_events  WHERE original_id = e.id))
 	) x
 )