Errore sul database di WordPress: [Got error 28 from storage engine]SELECT a.*,'Normal' AS type FROM wp_calendar AS a WHERE a.event_begin <= '2023-2-1' AND a.event_end >= '2023-2-1' AND a.event_recur = 'S'
UNION ALL
SELECT b.*,'Yearly' AS type FROM wp_calendar AS b WHERE b.event_recur = 'Y' AND EXTRACT(YEAR FROM '2023-2-1') >= EXTRACT(YEAR FROM b.event_begin) AND b.event_repeats = 0
UNION ALL
SELECT c.*,'Yearly' AS type FROM wp_calendar AS c WHERE c.event_recur = 'Y' AND EXTRACT(YEAR FROM '2023-2-1') >= EXTRACT(YEAR FROM c.event_begin) AND c.event_repeats != 0 AND (EXTRACT(YEAR FROM '2023-2-1')-EXTRACT(YEAR FROM c.event_begin)) <= c.event_repeats
UNION ALL
SELECT d.*,'Monthly' AS type FROM wp_calendar AS d WHERE d.event_recur = 'M' AND EXTRACT(YEAR FROM '2023-2-1') >= EXTRACT(YEAR FROM d.event_begin) AND d.event_repeats = 0
UNION ALL
SELECT e.*,'Monthly' AS type FROM wp_calendar AS e WHERE e.event_recur = 'M' AND EXTRACT(YEAR FROM '2023-2-1') >= EXTRACT(YEAR FROM e.event_begin) AND e.event_repeats != 0 AND (PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM '2023-2-1'),EXTRACT(YEAR_MONTH FROM e.event_begin))) <= e.event_repeats
UNION ALL
SELECT f.*,'MonthSun' AS type FROM wp_calendar AS f WHERE f.event_recur = 'U' AND EXTRACT(YEAR FROM '2023-2-1') >= EXTRACT(YEAR FROM f.event_begin) AND f.event_repeats = 0
UNION ALL
SELECT g.*,'MonthSun' AS type FROM wp_calendar AS g WHERE g.event_recur = 'U' AND EXTRACT(YEAR FROM '2023-2-1') >= EXTRACT(YEAR FROM g.event_begin) AND g.event_repeats != 0 AND (PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM '2023-2-1'),EXTRACT(YEAR_MONTH FROM g.event_begin))) <= g.event_repeats
UNION ALL
SELECT h.*,'Weekly' AS type FROM wp_calendar AS h WHERE h.event_recur = 'W' AND '2023-2-1' >= h.event_begin AND h.event_repeats = 0
UNION ALL
SELECT i.*,'Weekly' AS type FROM wp_calendar AS i WHERE i.event_recur = 'W' AND '2023-2-1' >= i.event_begin AND i.event_repeats != 0 AND (i.event_repeats*7) >= (TO_DAYS('2023-2-1') - TO_DAYS(i.event_end))
ORDER BY event_id
Errore sul database di WordPress: [Got error 28 from storage engine]SELECT a.*,'Normal' AS type FROM wp_calendar AS a WHERE a.event_begin <= '2023-2-2' AND a.event_end >= '2023-2-2' AND a.event_recur = 'S'
UNION ALL
SELECT b.*,'Yearly' AS type FROM wp_calendar AS b WHERE b.event_recur = 'Y' AND EXTRACT(YEAR FROM '2023-2-2') >= EXTRACT(YEAR FROM b.event_begin) AND b.event_repeats = 0
UNION ALL
SELECT c.*,'Yearly' AS type FROM wp_calendar AS c WHERE c.event_recur = 'Y' AND EXTRACT(YEAR FROM '2023-2-2') >= EXTRACT(YEAR FROM c.event_begin) AND c.event_repeats != 0 AND (EXTRACT(YEAR FROM '2023-2-2')-EXTRACT(YEAR FROM c.event_begin)) <= c.event_repeats
UNION ALL
SELECT d.*,'Monthly' AS type FROM wp_calendar AS d WHERE d.event_recur = 'M' AND EXTRACT(YEAR FROM '2023-2-2') >= EXTRACT(YEAR FROM d.event_begin) AND d.event_repeats = 0
UNION ALL
SELECT e.*,'Monthly' AS type FROM wp_calendar AS e WHERE e.event_recur = 'M' AND EXTRACT(YEAR FROM '2023-2-2') >= EXTRACT(YEAR FROM e.event_begin) AND e.event_repeats != 0 AND (PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM '2023-2-2'),EXTRACT(YEAR_MONTH FROM e.event_begin))) <= e.event_repeats
UNION ALL
SELECT f.*,'MonthSun' AS type FROM wp_calendar AS f WHERE f.event_recur = 'U' AND EXTRACT(YEAR FROM '2023-2-2') >= EXTRACT(YEAR FROM f.event_begin) AND f.event_repeats = 0
UNION ALL
SELECT g.*,'MonthSun' AS type FROM wp_calendar AS g WHERE g.event_recur = 'U' AND EXTRACT(YEAR FROM '2023-2-2') >= EXTRACT(YEAR FROM g.event_begin) AND g.event_repeats != 0 AND (PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM '2023-2-2'),EXTRACT(YEAR_MONTH FROM g.event_begin))) <= g.event_repeats
UNION ALL
SELECT h.*,'Weekly' AS type FROM wp_calendar AS h WHERE h.event_recur = 'W' AND '2023-2-2' >= h.event_begin AND h.event_repeats = 0
UNION ALL
SELECT i.*,'Weekly' AS type FROM wp_calendar AS i WHERE i.event_recur = 'W' AND '2023-2-2' >= i.event_begin AND i.event_repeats != 0 AND (i.event_repeats*7) >= (TO_DAYS('2023-2-2') - TO_DAYS(i.event_end))
ORDER BY event_id
Errore sul database di WordPress: [Got error 28 from storage engine]SELECT a.*,'Normal' AS type FROM wp_calendar AS a WHERE a.event_begin <= '2023-2-3' AND a.event_end >= '2023-2-3' AND a.event_recur = 'S'
UNION ALL
SELECT b.*,'Yearly' AS type FROM wp_calendar AS b WHERE b.event_recur = 'Y' AND EXTRACT(YEAR FROM '2023-2-3') >= EXTRACT(YEAR FROM b.event_begin) AND b.event_repeats = 0
UNION ALL
SELECT c.*,'Yearly' AS type FROM wp_calendar AS c WHERE c.event_recur = 'Y' AND EXTRACT(YEAR FROM '2023-2-3') >= EXTRACT(YEAR FROM c.event_begin) AND c.event_repeats != 0 AND (EXTRACT(YEAR FROM '2023-2-3')-EXTRACT(YEAR FROM c.event_begin)) <= c.event_repeats
UNION ALL
SELECT d.*,'Monthly' AS type FROM wp_calendar AS d WHERE d.event_recur = 'M' AND EXTRACT(YEAR FROM '2023-2-3') >= EXTRACT(YEAR FROM d.event_begin) AND d.event_repeats = 0
UNION ALL
SELECT e.*,'Monthly' AS type FROM wp_calendar AS e WHERE e.event_recur = 'M' AND EXTRACT(YEAR FROM '2023-2-3') >= EXTRACT(YEAR FROM e.event_begin) AND e.event_repeats != 0 AND (PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM '2023-2-3'),EXTRACT(YEAR_MONTH FROM e.event_begin))) <= e.event_repeats
UNION ALL
SELECT f.*,'MonthSun' AS type FROM wp_calendar AS f WHERE f.event_recur = 'U' AND EXTRACT(YEAR FROM '2023-2-3') >= EXTRACT(YEAR FROM f.event_begin) AND f.event_repeats = 0
UNION ALL
SELECT g.*,'MonthSun' AS type FROM wp_calendar AS g WHERE g.event_recur = 'U' AND EXTRACT(YEAR FROM '2023-2-3') >= EXTRACT(YEAR FROM g.event_begin) AND g.event_repeats != 0 AND (PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM '2023-2-3'),EXTRACT(YEAR_MONTH FROM g.event_begin))) <= g.event_repeats
UNION ALL
SELECT h.*,'Weekly' AS type FROM wp_calendar AS h WHERE h.event_recur = 'W' AND '2023-2-3' >= h.event_begin AND h.event_repeats = 0
UNION ALL
SELECT i.*,'Weekly' AS type FROM wp_calendar AS i WHERE i.event_recur = 'W' AND '2023-2-3' >= i.event_begin AND i.event_repeats != 0 AND (i.event_repeats*7) >= (TO_DAYS('2023-2-3') - TO_DAYS(i.event_end))
ORDER BY event_id
Errore sul database di WordPress: [Got error 28 from storage engine]SELECT a.*,'Normal' AS type FROM wp_calendar AS a WHERE a.event_begin <= '2023-2-4' AND a.event_end >= '2023-2-4' AND a.event_recur = 'S'
UNION ALL
SELECT b.*,'Yearly' AS type FROM wp_calendar AS b WHERE b.event_recur = 'Y' AND EXTRACT(YEAR FROM '2023-2-4') >= EXTRACT(YEAR FROM b.event_begin) AND b.event_repeats = 0
UNION ALL
SELECT c.*,'Yearly' AS type FROM wp_calendar AS c WHERE c.event_recur = 'Y' AND EXTRACT(YEAR FROM '2023-2-4') >= EXTRACT(YEAR FROM c.event_begin) AND c.event_repeats != 0 AND (EXTRACT(YEAR FROM '2023-2-4')-EXTRACT(YEAR FROM c.event_begin)) <= c.event_repeats
UNION ALL
SELECT d.*,'Monthly' AS type FROM wp_calendar AS d WHERE d.event_recur = 'M' AND EXTRACT(YEAR FROM '2023-2-4') >= EXTRACT(YEAR FROM d.event_begin) AND d.event_repeats = 0
UNION ALL
SELECT e.*,'Monthly' AS type FROM wp_calendar AS e WHERE e.event_recur = 'M' AND EXTRACT(YEAR FROM '2023-2-4') >= EXTRACT(YEAR FROM e.event_begin) AND e.event_repeats != 0 AND (PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM '2023-2-4'),EXTRACT(YEAR_MONTH FROM e.event_begin))) <= e.event_repeats
UNION ALL
SELECT f.*,'MonthSun' AS type FROM wp_calendar AS f WHERE f.event_recur = 'U' AND EXTRACT(YEAR FROM '2023-2-4') >= EXTRACT(YEAR FROM f.event_begin) AND f.event_repeats = 0
UNION ALL
SELECT g.*,'MonthSun' AS type FROM wp_calendar AS g WHERE g.event_recur = 'U' AND EXTRACT(YEAR FROM '2023-2-4') >= EXTRACT(YEAR FROM g.event_begin) AND g.event_repeats != 0 AND (PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM '2023-2-4'),EXTRACT(YEAR_MONTH FROM g.event_begin))) <= g.event_repeats
UNION ALL
SELECT h.*,'Weekly' AS type FROM wp_calendar AS h WHERE h.event_recur = 'W' AND '2023-2-4' >= h.event_begin AND h.event_repeats = 0
UNION ALL
SELECT i.*,'Weekly' AS type FROM wp_calendar AS i WHERE i.event_recur = 'W' AND '2023-2-4' >= i.event_begin AND i.event_repeats != 0 AND (i.event_repeats*7) >= (TO_DAYS('2023-2-4') - TO_DAYS(i.event_end))
ORDER BY event_id
Errore sul database di WordPress: [Got error 28 from storage engine]SELECT a.*,'Normal' AS type FROM wp_calendar AS a WHERE a.event_begin <= '2023-2-5' AND a.event_end >= '2023-2-5' AND a.event_recur = 'S'
UNION ALL
SELECT b.*,'Yearly' AS type FROM wp_calendar AS b WHERE b.event_recur = 'Y' AND EXTRACT(YEAR FROM '2023-2-5') >= EXTRACT(YEAR FROM b.event_begin) AND b.event_repeats = 0
UNION ALL
SELECT c.*,'Yearly' AS type FROM wp_calendar AS c WHERE c.event_recur = 'Y' AND EXTRACT(YEAR FROM '2023-2-5') >= EXTRACT(YEAR FROM c.event_begin) AND c.event_repeats != 0 AND (EXTRACT(YEAR FROM '2023-2-5')-EXTRACT(YEAR FROM c.event_begin)) <= c.event_repeats
UNION ALL
SELECT d.*,'Monthly' AS type FROM wp_calendar AS d WHERE d.event_recur = 'M' AND EXTRACT(YEAR FROM '2023-2-5') >= EXTRACT(YEAR FROM d.event_begin) AND d.event_repeats = 0
UNION ALL
SELECT e.*,'Monthly' AS type FROM wp_calendar AS e WHERE e.event_recur = 'M' AND EXTRACT(YEAR FROM '2023-2-5') >= EXTRACT(YEAR FROM e.event_begin) AND e.event_repeats != 0 AND (PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM '2023-2-5'),EXTRACT(YEAR_MONTH FROM e.event_begin))) <= e.event_repeats
UNION ALL
SELECT f.*,'MonthSun' AS type FROM wp_calendar AS f WHERE f.event_recur = 'U' AND EXTRACT(YEAR FROM '2023-2-5') >= EXTRACT(YEAR FROM f.event_begin) AND f.event_repeats = 0
UNION ALL
SELECT g.*,'MonthSun' AS type FROM wp_calendar AS g WHERE g.event_recur = 'U' AND EXTRACT(YEAR FROM '2023-2-5') >= EXTRACT(YEAR FROM g.event_begin) AND g.event_repeats != 0 AND (PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM '2023-2-5'),EXTRACT(YEAR_MONTH FROM g.event_begin))) <= g.event_repeats
UNION ALL
SELECT h.*,'Weekly' AS type FROM wp_calendar AS h WHERE h.event_recur = 'W' AND '2023-2-5' >= h.event_begin AND h.event_repeats = 0
UNION ALL
SELECT i.*,'Weekly' AS type FROM wp_calendar AS i WHERE i.event_recur = 'W' AND '2023-2-5' >= i.event_begin AND i.event_repeats != 0 AND (i.event_repeats*7) >= (TO_DAYS('2023-2-5') - TO_DAYS(i.event_end))
ORDER BY event_id
Errore sul database di WordPress: [Got error 28 from storage engine]SELECT a.*,'Normal' AS type FROM wp_calendar AS a WHERE a.event_begin <= '2023-2-6' AND a.event_end >= '2023-2-6' AND a.event_recur = 'S'
UNION ALL
SELECT b.*,'Yearly' AS type FROM wp_calendar AS b WHERE b.event_recur = 'Y' AND EXTRACT(YEAR FROM '2023-2-6') >= EXTRACT(YEAR FROM b.event_begin) AND b.event_repeats = 0
UNION ALL
SELECT c.*,'Yearly' AS type FROM wp_calendar AS c WHERE c.event_recur = 'Y' AND EXTRACT(YEAR FROM '2023-2-6') >= EXTRACT(YEAR FROM c.event_begin) AND c.event_repeats != 0 AND (EXTRACT(YEAR FROM '2023-2-6')-EXTRACT(YEAR FROM c.event_begin)) <= c.event_repeats
UNION ALL
SELECT d.*,'Monthly' AS type FROM wp_calendar AS d WHERE d.event_recur = 'M' AND EXTRACT(YEAR FROM '2023-2-6') >= EXTRACT(YEAR FROM d.event_begin) AND d.event_repeats = 0
UNION ALL
SELECT e.*,'Monthly' AS type FROM wp_calendar AS e WHERE e.event_recur = 'M' AND EXTRACT(YEAR FROM '2023-2-6') >= EXTRACT(YEAR FROM e.event_begin) AND e.event_repeats != 0 AND (PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM '2023-2-6'),EXTRACT(YEAR_MONTH FROM e.event_begin))) <= e.event_repeats
UNION ALL
SELECT f.*,'MonthSun' AS type FROM wp_calendar AS f WHERE f.event_recur = 'U' AND EXTRACT(YEAR FROM '2023-2-6') >= EXTRACT(YEAR FROM f.event_begin) AND f.event_repeats = 0
UNION ALL
SELECT g.*,'MonthSun' AS type FROM wp_calendar AS g WHERE g.event_recur = 'U' AND EXTRACT(YEAR FROM '2023-2-6') >= EXTRACT(YEAR FROM g.event_begin) AND g.event_repeats != 0 AND (PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM '2023-2-6'),EXTRACT(YEAR_MONTH FROM g.event_begin))) <= g.event_repeats
UNION ALL
SELECT h.*,'Weekly' AS type FROM wp_calendar AS h WHERE h.event_recur = 'W' AND '2023-2-6' >= h.event_begin AND h.event_repeats = 0
UNION ALL
SELECT i.*,'Weekly' AS type FROM wp_calendar AS i WHERE i.event_recur = 'W' AND '2023-2-6' >= i.event_begin AND i.event_repeats != 0 AND (i.event_repeats*7) >= (TO_DAYS('2023-2-6') - TO_DAYS(i.event_end))
ORDER BY event_id
Errore sul database di WordPress: [Got error 28 from storage engine]SELECT a.*,'Normal' AS type FROM wp_calendar AS a WHERE a.event_begin <= '2023-2-7' AND a.event_end >= '2023-2-7' AND a.event_recur = 'S'
UNION ALL
SELECT b.*,'Yearly' AS type FROM wp_calendar AS b WHERE b.event_recur = 'Y' AND EXTRACT(YEAR FROM '2023-2-7') >= EXTRACT(YEAR FROM b.event_begin) AND b.event_repeats = 0
UNION ALL
SELECT c.*,'Yearly' AS type FROM wp_calendar AS c WHERE c.event_recur = 'Y' AND EXTRACT(YEAR FROM '2023-2-7') >= EXTRACT(YEAR FROM c.event_begin) AND c.event_repeats != 0 AND (EXTRACT(YEAR FROM '2023-2-7')-EXTRACT(YEAR FROM c.event_begin)) <= c.event_repeats
UNION ALL
SELECT d.*,'Monthly' AS type FROM wp_calendar AS d WHERE d.event_recur = 'M' AND EXTRACT(YEAR FROM '2023-2-7') >= EXTRACT(YEAR FROM d.event_begin) AND d.event_repeats = 0
UNION ALL
SELECT e.*,'Monthly' AS type FROM wp_calendar AS e WHERE e.event_recur = 'M' AND EXTRACT(YEAR FROM '2023-2-7') >= EXTRACT(YEAR FROM e.event_begin) AND e.event_repeats != 0 AND (PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM '2023-2-7'),EXTRACT(YEAR_MONTH FROM e.event_begin))) <= e.event_repeats
UNION ALL
SELECT f.*,'MonthSun' AS type FROM wp_calendar AS f WHERE f.event_recur = 'U' AND EXTRACT(YEAR FROM '2023-2-7') >= EXTRACT(YEAR FROM f.event_begin) AND f.event_repeats = 0
UNION ALL
SELECT g.*,'MonthSun' AS type FROM wp_calendar AS g WHERE g.event_recur = 'U' AND EXTRACT(YEAR FROM '2023-2-7') >= EXTRACT(YEAR FROM g.event_begin) AND g.event_repeats != 0 AND (PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM '2023-2-7'),EXTRACT(YEAR_MONTH FROM g.event_begin))) <= g.event_repeats
UNION ALL
SELECT h.*,'Weekly' AS type FROM wp_calendar AS h WHERE h.event_recur = 'W' AND '2023-2-7' >= h.event_begin AND h.event_repeats = 0
UNION ALL
SELECT i.*,'Weekly' AS type FROM wp_calendar AS i WHERE i.event_recur = 'W' AND '2023-2-7' >= i.event_begin AND i.event_repeats != 0 AND (i.event_repeats*7) >= (TO_DAYS('2023-2-7') - TO_DAYS(i.event_end))
ORDER BY event_id
Errore sul database di WordPress: [Got error 28 from storage engine]SELECT a.*,'Normal' AS type FROM wp_calendar AS a WHERE a.event_begin <= '2023-2-8' AND a.event_end >= '2023-2-8' AND a.event_recur = 'S'
UNION ALL
SELECT b.*,'Yearly' AS type FROM wp_calendar AS b WHERE b.event_recur = 'Y' AND EXTRACT(YEAR FROM '2023-2-8') >= EXTRACT(YEAR FROM b.event_begin) AND b.event_repeats = 0
UNION ALL
SELECT c.*,'Yearly' AS type FROM wp_calendar AS c WHERE c.event_recur = 'Y' AND EXTRACT(YEAR FROM '2023-2-8') >= EXTRACT(YEAR FROM c.event_begin) AND c.event_repeats != 0 AND (EXTRACT(YEAR FROM '2023-2-8')-EXTRACT(YEAR FROM c.event_begin)) <= c.event_repeats
UNION ALL
SELECT d.*,'Monthly' AS type FROM wp_calendar AS d WHERE d.event_recur = 'M' AND EXTRACT(YEAR FROM '2023-2-8') >= EXTRACT(YEAR FROM d.event_begin) AND d.event_repeats = 0
UNION ALL
SELECT e.*,'Monthly' AS type FROM wp_calendar AS e WHERE e.event_recur = 'M' AND EXTRACT(YEAR FROM '2023-2-8') >= EXTRACT(YEAR FROM e.event_begin) AND e.event_repeats != 0 AND (PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM '2023-2-8'),EXTRACT(YEAR_MONTH FROM e.event_begin))) <= e.event_repeats
UNION ALL
SELECT f.*,'MonthSun' AS type FROM wp_calendar AS f WHERE f.event_recur = 'U' AND EXTRACT(YEAR FROM '2023-2-8') >= EXTRACT(YEAR FROM f.event_begin) AND f.event_repeats = 0
UNION ALL
SELECT g.*,'MonthSun' AS type FROM wp_calendar AS g WHERE g.event_recur = 'U' AND EXTRACT(YEAR FROM '2023-2-8') >= EXTRACT(YEAR FROM g.event_begin) AND g.event_repeats != 0 AND (PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM '2023-2-8'),EXTRACT(YEAR_MONTH FROM g.event_begin))) <= g.event_repeats
UNION ALL
SELECT h.*,'Weekly' AS type FROM wp_calendar AS h WHERE h.event_recur = 'W' AND '2023-2-8' >= h.event_begin AND h.event_repeats = 0
UNION ALL
SELECT i.*,'Weekly' AS type FROM wp_calendar AS i WHERE i.event_recur = 'W' AND '2023-2-8' >= i.event_begin AND i.event_repeats != 0 AND (i.event_repeats*7) >= (TO_DAYS('2023-2-8') - TO_DAYS(i.event_end))
ORDER BY event_id
Errore sul database di WordPress: [Got error 28 from storage engine]SELECT a.*,'Normal' AS type FROM wp_calendar AS a WHERE a.event_begin <= '2023-2-9' AND a.event_end >= '2023-2-9' AND a.event_recur = 'S'
UNION ALL
SELECT b.*,'Yearly' AS type FROM wp_calendar AS b WHERE b.event_recur = 'Y' AND EXTRACT(YEAR FROM '2023-2-9') >= EXTRACT(YEAR FROM b.event_begin) AND b.event_repeats = 0
UNION ALL
SELECT c.*,'Yearly' AS type FROM wp_calendar AS c WHERE c.event_recur = 'Y' AND EXTRACT(YEAR FROM '2023-2-9') >= EXTRACT(YEAR FROM c.event_begin) AND c.event_repeats != 0 AND (EXTRACT(YEAR FROM '2023-2-9')-EXTRACT(YEAR FROM c.event_begin)) <= c.event_repeats
UNION ALL
SELECT d.*,'Monthly' AS type FROM wp_calendar AS d WHERE d.event_recur = 'M' AND EXTRACT(YEAR FROM '2023-2-9') >= EXTRACT(YEAR FROM d.event_begin) AND d.event_repeats = 0
UNION ALL
SELECT e.*,'Monthly' AS type FROM wp_calendar AS e WHERE e.event_recur = 'M' AND EXTRACT(YEAR FROM '2023-2-9') >= EXTRACT(YEAR FROM e.event_begin) AND e.event_repeats != 0 AND (PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM '2023-2-9'),EXTRACT(YEAR_MONTH FROM e.event_begin))) <= e.event_repeats
UNION ALL
SELECT f.*,'MonthSun' AS type FROM wp_calendar AS f WHERE f.event_recur = 'U' AND EXTRACT(YEAR FROM '2023-2-9') >= EXTRACT(YEAR FROM f.event_begin) AND f.event_repeats = 0
UNION ALL
SELECT g.*,'MonthSun' AS type FROM wp_calendar AS g WHERE g.event_recur = 'U' AND EXTRACT(YEAR FROM '2023-2-9') >= EXTRACT(YEAR FROM g.event_begin) AND g.event_repeats != 0 AND (PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM '2023-2-9'),EXTRACT(YEAR_MONTH FROM g.event_begin))) <= g.event_repeats
UNION ALL
SELECT h.*,'Weekly' AS type FROM wp_calendar AS h WHERE h.event_recur = 'W' AND '2023-2-9' >= h.event_begin AND h.event_repeats = 0
UNION ALL
SELECT i.*,'Weekly' AS type FROM wp_calendar AS i WHERE i.event_recur = 'W' AND '2023-2-9' >= i.event_begin AND i.event_repeats != 0 AND (i.event_repeats*7) >= (TO_DAYS('2023-2-9') - TO_DAYS(i.event_end))
ORDER BY event_id
Errore sul database di WordPress: [Got error 28 from storage engine]SELECT a.*,'Normal' AS type FROM wp_calendar AS a WHERE a.event_begin <= '2023-2-10' AND a.event_end >= '2023-2-10' AND a.event_recur = 'S'
UNION ALL
SELECT b.*,'Yearly' AS type FROM wp_calendar AS b WHERE b.event_recur = 'Y' AND EXTRACT(YEAR FROM '2023-2-10') >= EXTRACT(YEAR FROM b.event_begin) AND b.event_repeats = 0
UNION ALL
SELECT c.*,'Yearly' AS type FROM wp_calendar AS c WHERE c.event_recur = 'Y' AND EXTRACT(YEAR FROM '2023-2-10') >= EXTRACT(YEAR FROM c.event_begin) AND c.event_repeats != 0 AND (EXTRACT(YEAR FROM '2023-2-10')-EXTRACT(YEAR FROM c.event_begin)) <= c.event_repeats
UNION ALL
SELECT d.*,'Monthly' AS type FROM wp_calendar AS d WHERE d.event_recur = 'M' AND EXTRACT(YEAR FROM '2023-2-10') >= EXTRACT(YEAR FROM d.event_begin) AND d.event_repeats = 0
UNION ALL
SELECT e.*,'Monthly' AS type FROM wp_calendar AS e WHERE e.event_recur = 'M' AND EXTRACT(YEAR FROM '2023-2-10') >= EXTRACT(YEAR FROM e.event_begin) AND e.event_repeats != 0 AND (PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM '2023-2-10'),EXTRACT(YEAR_MONTH FROM e.event_begin))) <= e.event_repeats
UNION ALL
SELECT f.*,'MonthSun' AS type FROM wp_calendar AS f WHERE f.event_recur = 'U' AND EXTRACT(YEAR FROM '2023-2-10') >= EXTRACT(YEAR FROM f.event_begin) AND f.event_repeats = 0
UNION ALL
SELECT g.*,'MonthSun' AS type FROM wp_calendar AS g WHERE g.event_recur = 'U' AND EXTRACT(YEAR FROM '2023-2-10') >= EXTRACT(YEAR FROM g.event_begin) AND g.event_repeats != 0 AND (PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM '2023-2-10'),EXTRACT(YEAR_MONTH FROM g.event_begin))) <= g.event_repeats
UNION ALL
SELECT h.*,'Weekly' AS type FROM wp_calendar AS h WHERE h.event_recur = 'W' AND '2023-2-10' >= h.event_begin AND h.event_repeats = 0
UNION ALL
SELECT i.*,'Weekly' AS type FROM wp_calendar AS i WHERE i.event_recur = 'W' AND '2023-2-10' >= i.event_begin AND i.event_repeats != 0 AND (i.event_repeats*7) >= (TO_DAYS('2023-2-10') - TO_DAYS(i.event_end))
ORDER BY event_id
Errore sul database di WordPress: [Got error 28 from storage engine]SELECT a.*,'Normal' AS type FROM wp_calendar AS a WHERE a.event_begin <= '2023-2-11' AND a.event_end >= '2023-2-11' AND a.event_recur = 'S'
UNION ALL
SELECT b.*,'Yearly' AS type FROM wp_calendar AS b WHERE b.event_recur = 'Y' AND EXTRACT(YEAR FROM '2023-2-11') >= EXTRACT(YEAR FROM b.event_begin) AND b.event_repeats = 0
UNION ALL
SELECT c.*,'Yearly' AS type FROM wp_calendar AS c WHERE c.event_recur = 'Y' AND EXTRACT(YEAR FROM '2023-2-11') >= EXTRACT(YEAR FROM c.event_begin) AND c.event_repeats != 0 AND (EXTRACT(YEAR FROM '2023-2-11')-EXTRACT(YEAR FROM c.event_begin)) <= c.event_repeats
UNION ALL
SELECT d.*,'Monthly' AS type FROM wp_calendar AS d WHERE d.event_recur = 'M' AND EXTRACT(YEAR FROM '2023-2-11') >= EXTRACT(YEAR FROM d.event_begin) AND d.event_repeats = 0
UNION ALL
SELECT e.*,'Monthly' AS type FROM wp_calendar AS e WHERE e.event_recur = 'M' AND EXTRACT(YEAR FROM '2023-2-11') >= EXTRACT(YEAR FROM e.event_begin) AND e.event_repeats != 0 AND (PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM '2023-2-11'),EXTRACT(YEAR_MONTH FROM e.event_begin))) <= e.event_repeats
UNION ALL
SELECT f.*,'MonthSun' AS type FROM wp_calendar AS f WHERE f.event_recur = 'U' AND EXTRACT(YEAR FROM '2023-2-11') >= EXTRACT(YEAR FROM f.event_begin) AND f.event_repeats = 0
UNION ALL
SELECT g.*,'MonthSun' AS type FROM wp_calendar AS g WHERE g.event_recur = 'U' AND EXTRACT(YEAR FROM '2023-2-11') >= EXTRACT(YEAR FROM g.event_begin) AND g.event_repeats != 0 AND (PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM '2023-2-11'),EXTRACT(YEAR_MONTH FROM g.event_begin))) <= g.event_repeats
UNION ALL
SELECT h.*,'Weekly' AS type FROM wp_calendar AS h WHERE h.event_recur = 'W' AND '2023-2-11' >= h.event_begin AND h.event_repeats = 0
UNION ALL
SELECT i.*,'Weekly' AS type FROM wp_calendar AS i WHERE i.event_recur = 'W' AND '2023-2-11' >= i.event_begin AND i.event_repeats != 0 AND (i.event_repeats*7) >= (TO_DAYS('2023-2-11') - TO_DAYS(i.event_end))
ORDER BY event_id
Errore sul database di WordPress: [Got error 28 from storage engine]SELECT a.*,'Normal' AS type FROM wp_calendar AS a WHERE a.event_begin <= '2023-2-12' AND a.event_end >= '2023-2-12' AND a.event_recur = 'S'
UNION ALL
SELECT b.*,'Yearly' AS type FROM wp_calendar AS b WHERE b.event_recur = 'Y' AND EXTRACT(YEAR FROM '2023-2-12') >= EXTRACT(YEAR FROM b.event_begin) AND b.event_repeats = 0
UNION ALL
SELECT c.*,'Yearly' AS type FROM wp_calendar AS c WHERE c.event_recur = 'Y' AND EXTRACT(YEAR FROM '2023-2-12') >= EXTRACT(YEAR FROM c.event_begin) AND c.event_repeats != 0 AND (EXTRACT(YEAR FROM '2023-2-12')-EXTRACT(YEAR FROM c.event_begin)) <= c.event_repeats
UNION ALL
SELECT d.*,'Monthly' AS type FROM wp_calendar AS d WHERE d.event_recur = 'M' AND EXTRACT(YEAR FROM '2023-2-12') >= EXTRACT(YEAR FROM d.event_begin) AND d.event_repeats = 0
UNION ALL
SELECT e.*,'Monthly' AS type FROM wp_calendar AS e WHERE e.event_recur = 'M' AND EXTRACT(YEAR FROM '2023-2-12') >= EXTRACT(YEAR FROM e.event_begin) AND e.event_repeats != 0 AND (PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM '2023-2-12'),EXTRACT(YEAR_MONTH FROM e.event_begin))) <= e.event_repeats
UNION ALL
SELECT f.*,'MonthSun' AS type FROM wp_calendar AS f WHERE f.event_recur = 'U' AND EXTRACT(YEAR FROM '2023-2-12') >= EXTRACT(YEAR FROM f.event_begin) AND f.event_repeats = 0
UNION ALL
SELECT g.*,'MonthSun' AS type FROM wp_calendar AS g WHERE g.event_recur = 'U' AND EXTRACT(YEAR FROM '2023-2-12') >= EXTRACT(YEAR FROM g.event_begin) AND g.event_repeats != 0 AND (PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM '2023-2-12'),EXTRACT(YEAR_MONTH FROM g.event_begin))) <= g.event_repeats
UNION ALL
SELECT h.*,'Weekly' AS type FROM wp_calendar AS h WHERE h.event_recur = 'W' AND '2023-2-12' >= h.event_begin AND h.event_repeats = 0
UNION ALL
SELECT i.*,'Weekly' AS type FROM wp_calendar AS i WHERE i.event_recur = 'W' AND '2023-2-12' >= i.event_begin AND i.event_repeats != 0 AND (i.event_repeats*7) >= (TO_DAYS('2023-2-12') - TO_DAYS(i.event_end))
ORDER BY event_id
Errore sul database di WordPress: [Got error 28 from storage engine]SELECT a.*,'Normal' AS type FROM wp_calendar AS a WHERE a.event_begin <= '2023-2-13' AND a.event_end >= '2023-2-13' AND a.event_recur = 'S'
UNION ALL
SELECT b.*,'Yearly' AS type FROM wp_calendar AS b WHERE b.event_recur = 'Y' AND EXTRACT(YEAR FROM '2023-2-13') >= EXTRACT(YEAR FROM b.event_begin) AND b.event_repeats = 0
UNION ALL
SELECT c.*,'Yearly' AS type FROM wp_calendar AS c WHERE c.event_recur = 'Y' AND EXTRACT(YEAR FROM '2023-2-13') >= EXTRACT(YEAR FROM c.event_begin) AND c.event_repeats != 0 AND (EXTRACT(YEAR FROM '2023-2-13')-EXTRACT(YEAR FROM c.event_begin)) <= c.event_repeats
UNION ALL
SELECT d.*,'Monthly' AS type FROM wp_calendar AS d WHERE d.event_recur = 'M' AND EXTRACT(YEAR FROM '2023-2-13') >= EXTRACT(YEAR FROM d.event_begin) AND d.event_repeats = 0
UNION ALL
SELECT e.*,'Monthly' AS type FROM wp_calendar AS e WHERE e.event_recur = 'M' AND EXTRACT(YEAR FROM '2023-2-13') >= EXTRACT(YEAR FROM e.event_begin) AND e.event_repeats != 0 AND (PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM '2023-2-13'),EXTRACT(YEAR_MONTH FROM e.event_begin))) <= e.event_repeats
UNION ALL
SELECT f.*,'MonthSun' AS type FROM wp_calendar AS f WHERE f.event_recur = 'U' AND EXTRACT(YEAR FROM '2023-2-13') >= EXTRACT(YEAR FROM f.event_begin) AND f.event_repeats = 0
UNION ALL
SELECT g.*,'MonthSun' AS type FROM wp_calendar AS g WHERE g.event_recur = 'U' AND EXTRACT(YEAR FROM '2023-2-13') >= EXTRACT(YEAR FROM g.event_begin) AND g.event_repeats != 0 AND (PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM '2023-2-13'),EXTRACT(YEAR_MONTH FROM g.event_begin))) <= g.event_repeats
UNION ALL
SELECT h.*,'Weekly' AS type FROM wp_calendar AS h WHERE h.event_recur = 'W' AND '2023-2-13' >= h.event_begin AND h.event_repeats = 0
UNION ALL
SELECT i.*,'Weekly' AS type FROM wp_calendar AS i WHERE i.event_recur = 'W' AND '2023-2-13' >= i.event_begin AND i.event_repeats != 0 AND (i.event_repeats*7) >= (TO_DAYS('2023-2-13') - TO_DAYS(i.event_end))
ORDER BY event_id
Errore sul database di WordPress: [Got error 28 from storage engine]SELECT a.*,'Normal' AS type FROM wp_calendar AS a WHERE a.event_begin <= '2023-2-14' AND a.event_end >= '2023-2-14' AND a.event_recur = 'S'
UNION ALL
SELECT b.*,'Yearly' AS type FROM wp_calendar AS b WHERE b.event_recur = 'Y' AND EXTRACT(YEAR FROM '2023-2-14') >= EXTRACT(YEAR FROM b.event_begin) AND b.event_repeats = 0
UNION ALL
SELECT c.*,'Yearly' AS type FROM wp_calendar AS c WHERE c.event_recur = 'Y' AND EXTRACT(YEAR FROM '2023-2-14') >= EXTRACT(YEAR FROM c.event_begin) AND c.event_repeats != 0 AND (EXTRACT(YEAR FROM '2023-2-14')-EXTRACT(YEAR FROM c.event_begin)) <= c.event_repeats
UNION ALL
SELECT d.*,'Monthly' AS type FROM wp_calendar AS d WHERE d.event_recur = 'M' AND EXTRACT(YEAR FROM '2023-2-14') >= EXTRACT(YEAR FROM d.event_begin) AND d.event_repeats = 0
UNION ALL
SELECT e.*,'Monthly' AS type FROM wp_calendar AS e WHERE e.event_recur = 'M' AND EXTRACT(YEAR FROM '2023-2-14') >= EXTRACT(YEAR FROM e.event_begin) AND e.event_repeats != 0 AND (PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM '2023-2-14'),EXTRACT(YEAR_MONTH FROM e.event_begin))) <= e.event_repeats
UNION ALL
SELECT f.*,'MonthSun' AS type FROM wp_calendar AS f WHERE f.event_recur = 'U' AND EXTRACT(YEAR FROM '2023-2-14') >= EXTRACT(YEAR FROM f.event_begin) AND f.event_repeats = 0
UNION ALL
SELECT g.*,'MonthSun' AS type FROM wp_calendar AS g WHERE g.event_recur = 'U' AND EXTRACT(YEAR FROM '2023-2-14') >= EXTRACT(YEAR FROM g.event_begin) AND g.event_repeats != 0 AND (PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM '2023-2-14'),EXTRACT(YEAR_MONTH FROM g.event_begin))) <= g.event_repeats
UNION ALL
SELECT h.*,'Weekly' AS type FROM wp_calendar AS h WHERE h.event_recur = 'W' AND '2023-2-14' >= h.event_begin AND h.event_repeats = 0
UNION ALL
SELECT i.*,'Weekly' AS type FROM wp_calendar AS i WHERE i.event_recur = 'W' AND '2023-2-14' >= i.event_begin AND i.event_repeats != 0 AND (i.event_repeats*7) >= (TO_DAYS('2023-2-14') - TO_DAYS(i.event_end))
ORDER BY event_id
Errore sul database di WordPress: [Got error 28 from storage engine]SELECT a.*,'Normal' AS type FROM wp_calendar AS a WHERE a.event_begin <= '2023-2-15' AND a.event_end >= '2023-2-15' AND a.event_recur = 'S'
UNION ALL
SELECT b.*,'Yearly' AS type FROM wp_calendar AS b WHERE b.event_recur = 'Y' AND EXTRACT(YEAR FROM '2023-2-15') >= EXTRACT(YEAR FROM b.event_begin) AND b.event_repeats = 0
UNION ALL
SELECT c.*,'Yearly' AS type FROM wp_calendar AS c WHERE c.event_recur = 'Y' AND EXTRACT(YEAR FROM '2023-2-15') >= EXTRACT(YEAR FROM c.event_begin) AND c.event_repeats != 0 AND (EXTRACT(YEAR FROM '2023-2-15')-EXTRACT(YEAR FROM c.event_begin)) <= c.event_repeats
UNION ALL
SELECT d.*,'Monthly' AS type FROM wp_calendar AS d WHERE d.event_recur = 'M' AND EXTRACT(YEAR FROM '2023-2-15') >= EXTRACT(YEAR FROM d.event_begin) AND d.event_repeats = 0
UNION ALL
SELECT e.*,'Monthly' AS type FROM wp_calendar AS e WHERE e.event_recur = 'M' AND EXTRACT(YEAR FROM '2023-2-15') >= EXTRACT(YEAR FROM e.event_begin) AND e.event_repeats != 0 AND (PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM '2023-2-15'),EXTRACT(YEAR_MONTH FROM e.event_begin))) <= e.event_repeats
UNION ALL
SELECT f.*,'MonthSun' AS type FROM wp_calendar AS f WHERE f.event_recur = 'U' AND EXTRACT(YEAR FROM '2023-2-15') >= EXTRACT(YEAR FROM f.event_begin) AND f.event_repeats = 0
UNION ALL
SELECT g.*,'MonthSun' AS type FROM wp_calendar AS g WHERE g.event_recur = 'U' AND EXTRACT(YEAR FROM '2023-2-15') >= EXTRACT(YEAR FROM g.event_begin) AND g.event_repeats != 0 AND (PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM '2023-2-15'),EXTRACT(YEAR_MONTH FROM g.event_begin))) <= g.event_repeats
UNION ALL
SELECT h.*,'Weekly' AS type FROM wp_calendar AS h WHERE h.event_recur = 'W' AND '2023-2-15' >= h.event_begin AND h.event_repeats = 0
UNION ALL
SELECT i.*,'Weekly' AS type FROM wp_calendar AS i WHERE i.event_recur = 'W' AND '2023-2-15' >= i.event_begin AND i.event_repeats != 0 AND (i.event_repeats*7) >= (TO_DAYS('2023-2-15') - TO_DAYS(i.event_end))
ORDER BY event_id
Errore sul database di WordPress: [Got error 28 from storage engine]SELECT a.*,'Normal' AS type FROM wp_calendar AS a WHERE a.event_begin <= '2023-2-16' AND a.event_end >= '2023-2-16' AND a.event_recur = 'S'
UNION ALL
SELECT b.*,'Yearly' AS type FROM wp_calendar AS b WHERE b.event_recur = 'Y' AND EXTRACT(YEAR FROM '2023-2-16') >= EXTRACT(YEAR FROM b.event_begin) AND b.event_repeats = 0
UNION ALL
SELECT c.*,'Yearly' AS type FROM wp_calendar AS c WHERE c.event_recur = 'Y' AND EXTRACT(YEAR FROM '2023-2-16') >= EXTRACT(YEAR FROM c.event_begin) AND c.event_repeats != 0 AND (EXTRACT(YEAR FROM '2023-2-16')-EXTRACT(YEAR FROM c.event_begin)) <= c.event_repeats
UNION ALL
SELECT d.*,'Monthly' AS type FROM wp_calendar AS d WHERE d.event_recur = 'M' AND EXTRACT(YEAR FROM '2023-2-16') >= EXTRACT(YEAR FROM d.event_begin) AND d.event_repeats = 0
UNION ALL
SELECT e.*,'Monthly' AS type FROM wp_calendar AS e WHERE e.event_recur = 'M' AND EXTRACT(YEAR FROM '2023-2-16') >= EXTRACT(YEAR FROM e.event_begin) AND e.event_repeats != 0 AND (PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM '2023-2-16'),EXTRACT(YEAR_MONTH FROM e.event_begin))) <= e.event_repeats
UNION ALL
SELECT f.*,'MonthSun' AS type FROM wp_calendar AS f WHERE f.event_recur = 'U' AND EXTRACT(YEAR FROM '2023-2-16') >= EXTRACT(YEAR FROM f.event_begin) AND f.event_repeats = 0
UNION ALL
SELECT g.*,'MonthSun' AS type FROM wp_calendar AS g WHERE g.event_recur = 'U' AND EXTRACT(YEAR FROM '2023-2-16') >= EXTRACT(YEAR FROM g.event_begin) AND g.event_repeats != 0 AND (PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM '2023-2-16'),EXTRACT(YEAR_MONTH FROM g.event_begin))) <= g.event_repeats
UNION ALL
SELECT h.*,'Weekly' AS type FROM wp_calendar AS h WHERE h.event_recur = 'W' AND '2023-2-16' >= h.event_begin AND h.event_repeats = 0
UNION ALL
SELECT i.*,'Weekly' AS type FROM wp_calendar AS i WHERE i.event_recur = 'W' AND '2023-2-16' >= i.event_begin AND i.event_repeats != 0 AND (i.event_repeats*7) >= (TO_DAYS('2023-2-16') - TO_DAYS(i.event_end))
ORDER BY event_id
Errore sul database di WordPress: [Got error 28 from storage engine]SELECT a.*,'Normal' AS type FROM wp_calendar AS a WHERE a.event_begin <= '2023-2-17' AND a.event_end >= '2023-2-17' AND a.event_recur = 'S'
UNION ALL
SELECT b.*,'Yearly' AS type FROM wp_calendar AS b WHERE b.event_recur = 'Y' AND EXTRACT(YEAR FROM '2023-2-17') >= EXTRACT(YEAR FROM b.event_begin) AND b.event_repeats = 0
UNION ALL
SELECT c.*,'Yearly' AS type FROM wp_calendar AS c WHERE c.event_recur = 'Y' AND EXTRACT(YEAR FROM '2023-2-17') >= EXTRACT(YEAR FROM c.event_begin) AND c.event_repeats != 0 AND (EXTRACT(YEAR FROM '2023-2-17')-EXTRACT(YEAR FROM c.event_begin)) <= c.event_repeats
UNION ALL
SELECT d.*,'Monthly' AS type FROM wp_calendar AS d WHERE d.event_recur = 'M' AND EXTRACT(YEAR FROM '2023-2-17') >= EXTRACT(YEAR FROM d.event_begin) AND d.event_repeats = 0
UNION ALL
SELECT e.*,'Monthly' AS type FROM wp_calendar AS e WHERE e.event_recur = 'M' AND EXTRACT(YEAR FROM '2023-2-17') >= EXTRACT(YEAR FROM e.event_begin) AND e.event_repeats != 0 AND (PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM '2023-2-17'),EXTRACT(YEAR_MONTH FROM e.event_begin))) <= e.event_repeats
UNION ALL
SELECT f.*,'MonthSun' AS type FROM wp_calendar AS f WHERE f.event_recur = 'U' AND EXTRACT(YEAR FROM '2023-2-17') >= EXTRACT(YEAR FROM f.event_begin) AND f.event_repeats = 0
UNION ALL
SELECT g.*,'MonthSun' AS type FROM wp_calendar AS g WHERE g.event_recur = 'U' AND EXTRACT(YEAR FROM '2023-2-17') >= EXTRACT(YEAR FROM g.event_begin) AND g.event_repeats != 0 AND (PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM '2023-2-17'),EXTRACT(YEAR_MONTH FROM g.event_begin))) <= g.event_repeats
UNION ALL
SELECT h.*,'Weekly' AS type FROM wp_calendar AS h WHERE h.event_recur = 'W' AND '2023-2-17' >= h.event_begin AND h.event_repeats = 0
UNION ALL
SELECT i.*,'Weekly' AS type FROM wp_calendar AS i WHERE i.event_recur = 'W' AND '2023-2-17' >= i.event_begin AND i.event_repeats != 0 AND (i.event_repeats*7) >= (TO_DAYS('2023-2-17') - TO_DAYS(i.event_end))
ORDER BY event_id
Errore sul database di WordPress: [Got error 28 from storage engine]SELECT a.*,'Normal' AS type FROM wp_calendar AS a WHERE a.event_begin <= '2023-2-18' AND a.event_end >= '2023-2-18' AND a.event_recur = 'S'
UNION ALL
SELECT b.*,'Yearly' AS type FROM wp_calendar AS b WHERE b.event_recur = 'Y' AND EXTRACT(YEAR FROM '2023-2-18') >= EXTRACT(YEAR FROM b.event_begin) AND b.event_repeats = 0
UNION ALL
SELECT c.*,'Yearly' AS type FROM wp_calendar AS c WHERE c.event_recur = 'Y' AND EXTRACT(YEAR FROM '2023-2-18') >= EXTRACT(YEAR FROM c.event_begin) AND c.event_repeats != 0 AND (EXTRACT(YEAR FROM '2023-2-18')-EXTRACT(YEAR FROM c.event_begin)) <= c.event_repeats
UNION ALL
SELECT d.*,'Monthly' AS type FROM wp_calendar AS d WHERE d.event_recur = 'M' AND EXTRACT(YEAR FROM '2023-2-18') >= EXTRACT(YEAR FROM d.event_begin) AND d.event_repeats = 0
UNION ALL
SELECT e.*,'Monthly' AS type FROM wp_calendar AS e WHERE e.event_recur = 'M' AND EXTRACT(YEAR FROM '2023-2-18') >= EXTRACT(YEAR FROM e.event_begin) AND e.event_repeats != 0 AND (PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM '2023-2-18'),EXTRACT(YEAR_MONTH FROM e.event_begin))) <= e.event_repeats
UNION ALL
SELECT f.*,'MonthSun' AS type FROM wp_calendar AS f WHERE f.event_recur = 'U' AND EXTRACT(YEAR FROM '2023-2-18') >= EXTRACT(YEAR FROM f.event_begin) AND f.event_repeats = 0
UNION ALL
SELECT g.*,'MonthSun' AS type FROM wp_calendar AS g WHERE g.event_recur = 'U' AND EXTRACT(YEAR FROM '2023-2-18') >= EXTRACT(YEAR FROM g.event_begin) AND g.event_repeats != 0 AND (PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM '2023-2-18'),EXTRACT(YEAR_MONTH FROM g.event_begin))) <= g.event_repeats
UNION ALL
SELECT h.*,'Weekly' AS type FROM wp_calendar AS h WHERE h.event_recur = 'W' AND '2023-2-18' >= h.event_begin AND h.event_repeats = 0
UNION ALL
SELECT i.*,'Weekly' AS type FROM wp_calendar AS i WHERE i.event_recur = 'W' AND '2023-2-18' >= i.event_begin AND i.event_repeats != 0 AND (i.event_repeats*7) >= (TO_DAYS('2023-2-18') - TO_DAYS(i.event_end))
ORDER BY event_id
Errore sul database di WordPress: [Got error 28 from storage engine]SELECT a.*,'Normal' AS type FROM wp_calendar AS a WHERE a.event_begin <= '2023-2-19' AND a.event_end >= '2023-2-19' AND a.event_recur = 'S'
UNION ALL
SELECT b.*,'Yearly' AS type FROM wp_calendar AS b WHERE b.event_recur = 'Y' AND EXTRACT(YEAR FROM '2023-2-19') >= EXTRACT(YEAR FROM b.event_begin) AND b.event_repeats = 0
UNION ALL
SELECT c.*,'Yearly' AS type FROM wp_calendar AS c WHERE c.event_recur = 'Y' AND EXTRACT(YEAR FROM '2023-2-19') >= EXTRACT(YEAR FROM c.event_begin) AND c.event_repeats != 0 AND (EXTRACT(YEAR FROM '2023-2-19')-EXTRACT(YEAR FROM c.event_begin)) <= c.event_repeats
UNION ALL
SELECT d.*,'Monthly' AS type FROM wp_calendar AS d WHERE d.event_recur = 'M' AND EXTRACT(YEAR FROM '2023-2-19') >= EXTRACT(YEAR FROM d.event_begin) AND d.event_repeats = 0
UNION ALL
SELECT e.*,'Monthly' AS type FROM wp_calendar AS e WHERE e.event_recur = 'M' AND EXTRACT(YEAR FROM '2023-2-19') >= EXTRACT(YEAR FROM e.event_begin) AND e.event_repeats != 0 AND (PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM '2023-2-19'),EXTRACT(YEAR_MONTH FROM e.event_begin))) <= e.event_repeats
UNION ALL
SELECT f.*,'MonthSun' AS type FROM wp_calendar AS f WHERE f.event_recur = 'U' AND EXTRACT(YEAR FROM '2023-2-19') >= EXTRACT(YEAR FROM f.event_begin) AND f.event_repeats = 0
UNION ALL
SELECT g.*,'MonthSun' AS type FROM wp_calendar AS g WHERE g.event_recur = 'U' AND EXTRACT(YEAR FROM '2023-2-19') >= EXTRACT(YEAR FROM g.event_begin) AND g.event_repeats != 0 AND (PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM '2023-2-19'),EXTRACT(YEAR_MONTH FROM g.event_begin))) <= g.event_repeats
UNION ALL
SELECT h.*,'Weekly' AS type FROM wp_calendar AS h WHERE h.event_recur = 'W' AND '2023-2-19' >= h.event_begin AND h.event_repeats = 0
UNION ALL
SELECT i.*,'Weekly' AS type FROM wp_calendar AS i WHERE i.event_recur = 'W' AND '2023-2-19' >= i.event_begin AND i.event_repeats != 0 AND (i.event_repeats*7) >= (TO_DAYS('2023-2-19') - TO_DAYS(i.event_end))
ORDER BY event_id
Errore sul database di WordPress: [Got error 28 from storage engine]SELECT a.*,'Normal' AS type FROM wp_calendar AS a WHERE a.event_begin <= '2023-2-20' AND a.event_end >= '2023-2-20' AND a.event_recur = 'S'
UNION ALL
SELECT b.*,'Yearly' AS type FROM wp_calendar AS b WHERE b.event_recur = 'Y' AND EXTRACT(YEAR FROM '2023-2-20') >= EXTRACT(YEAR FROM b.event_begin) AND b.event_repeats = 0
UNION ALL
SELECT c.*,'Yearly' AS type FROM wp_calendar AS c WHERE c.event_recur = 'Y' AND EXTRACT(YEAR FROM '2023-2-20') >= EXTRACT(YEAR FROM c.event_begin) AND c.event_repeats != 0 AND (EXTRACT(YEAR FROM '2023-2-20')-EXTRACT(YEAR FROM c.event_begin)) <= c.event_repeats
UNION ALL
SELECT d.*,'Monthly' AS type FROM wp_calendar AS d WHERE d.event_recur = 'M' AND EXTRACT(YEAR FROM '2023-2-20') >= EXTRACT(YEAR FROM d.event_begin) AND d.event_repeats = 0
UNION ALL
SELECT e.*,'Monthly' AS type FROM wp_calendar AS e WHERE e.event_recur = 'M' AND EXTRACT(YEAR FROM '2023-2-20') >= EXTRACT(YEAR FROM e.event_begin) AND e.event_repeats != 0 AND (PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM '2023-2-20'),EXTRACT(YEAR_MONTH FROM e.event_begin))) <= e.event_repeats
UNION ALL
SELECT f.*,'MonthSun' AS type FROM wp_calendar AS f WHERE f.event_recur = 'U' AND EXTRACT(YEAR FROM '2023-2-20') >= EXTRACT(YEAR FROM f.event_begin) AND f.event_repeats = 0
UNION ALL
SELECT g.*,'MonthSun' AS type FROM wp_calendar AS g WHERE g.event_recur = 'U' AND EXTRACT(YEAR FROM '2023-2-20') >= EXTRACT(YEAR FROM g.event_begin) AND g.event_repeats != 0 AND (PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM '2023-2-20'),EXTRACT(YEAR_MONTH FROM g.event_begin))) <= g.event_repeats
UNION ALL
SELECT h.*,'Weekly' AS type FROM wp_calendar AS h WHERE h.event_recur = 'W' AND '2023-2-20' >= h.event_begin AND h.event_repeats = 0
UNION ALL
SELECT i.*,'Weekly' AS type FROM wp_calendar AS i WHERE i.event_recur = 'W' AND '2023-2-20' >= i.event_begin AND i.event_repeats != 0 AND (i.event_repeats*7) >= (TO_DAYS('2023-2-20') - TO_DAYS(i.event_end))
ORDER BY event_id
Errore sul database di WordPress: [Got error 28 from storage engine]SELECT a.*,'Normal' AS type FROM wp_calendar AS a WHERE a.event_begin <= '2023-2-21' AND a.event_end >= '2023-2-21' AND a.event_recur = 'S'
UNION ALL
SELECT b.*,'Yearly' AS type FROM wp_calendar AS b WHERE b.event_recur = 'Y' AND EXTRACT(YEAR FROM '2023-2-21') >= EXTRACT(YEAR FROM b.event_begin) AND b.event_repeats = 0
UNION ALL
SELECT c.*,'Yearly' AS type FROM wp_calendar AS c WHERE c.event_recur = 'Y' AND EXTRACT(YEAR FROM '2023-2-21') >= EXTRACT(YEAR FROM c.event_begin) AND c.event_repeats != 0 AND (EXTRACT(YEAR FROM '2023-2-21')-EXTRACT(YEAR FROM c.event_begin)) <= c.event_repeats
UNION ALL
SELECT d.*,'Monthly' AS type FROM wp_calendar AS d WHERE d.event_recur = 'M' AND EXTRACT(YEAR FROM '2023-2-21') >= EXTRACT(YEAR FROM d.event_begin) AND d.event_repeats = 0
UNION ALL
SELECT e.*,'Monthly' AS type FROM wp_calendar AS e WHERE e.event_recur = 'M' AND EXTRACT(YEAR FROM '2023-2-21') >= EXTRACT(YEAR FROM e.event_begin) AND e.event_repeats != 0 AND (PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM '2023-2-21'),EXTRACT(YEAR_MONTH FROM e.event_begin))) <= e.event_repeats
UNION ALL
SELECT f.*,'MonthSun' AS type FROM wp_calendar AS f WHERE f.event_recur = 'U' AND EXTRACT(YEAR FROM '2023-2-21') >= EXTRACT(YEAR FROM f.event_begin) AND f.event_repeats = 0
UNION ALL
SELECT g.*,'MonthSun' AS type FROM wp_calendar AS g WHERE g.event_recur = 'U' AND EXTRACT(YEAR FROM '2023-2-21') >= EXTRACT(YEAR FROM g.event_begin) AND g.event_repeats != 0 AND (PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM '2023-2-21'),EXTRACT(YEAR_MONTH FROM g.event_begin))) <= g.event_repeats
UNION ALL
SELECT h.*,'Weekly' AS type FROM wp_calendar AS h WHERE h.event_recur = 'W' AND '2023-2-21' >= h.event_begin AND h.event_repeats = 0
UNION ALL
SELECT i.*,'Weekly' AS type FROM wp_calendar AS i WHERE i.event_recur = 'W' AND '2023-2-21' >= i.event_begin AND i.event_repeats != 0 AND (i.event_repeats*7) >= (TO_DAYS('2023-2-21') - TO_DAYS(i.event_end))
ORDER BY event_id
Errore sul database di WordPress: [Got error 28 from storage engine]SELECT a.*,'Normal' AS type FROM wp_calendar AS a WHERE a.event_begin <= '2023-2-22' AND a.event_end >= '2023-2-22' AND a.event_recur = 'S'
UNION ALL
SELECT b.*,'Yearly' AS type FROM wp_calendar AS b WHERE b.event_recur = 'Y' AND EXTRACT(YEAR FROM '2023-2-22') >= EXTRACT(YEAR FROM b.event_begin) AND b.event_repeats = 0
UNION ALL
SELECT c.*,'Yearly' AS type FROM wp_calendar AS c WHERE c.event_recur = 'Y' AND EXTRACT(YEAR FROM '2023-2-22') >= EXTRACT(YEAR FROM c.event_begin) AND c.event_repeats != 0 AND (EXTRACT(YEAR FROM '2023-2-22')-EXTRACT(YEAR FROM c.event_begin)) <= c.event_repeats
UNION ALL
SELECT d.*,'Monthly' AS type FROM wp_calendar AS d WHERE d.event_recur = 'M' AND EXTRACT(YEAR FROM '2023-2-22') >= EXTRACT(YEAR FROM d.event_begin) AND d.event_repeats = 0
UNION ALL
SELECT e.*,'Monthly' AS type FROM wp_calendar AS e WHERE e.event_recur = 'M' AND EXTRACT(YEAR FROM '2023-2-22') >= EXTRACT(YEAR FROM e.event_begin) AND e.event_repeats != 0 AND (PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM '2023-2-22'),EXTRACT(YEAR_MONTH FROM e.event_begin))) <= e.event_repeats
UNION ALL
SELECT f.*,'MonthSun' AS type FROM wp_calendar AS f WHERE f.event_recur = 'U' AND EXTRACT(YEAR FROM '2023-2-22') >= EXTRACT(YEAR FROM f.event_begin) AND f.event_repeats = 0
UNION ALL
SELECT g.*,'MonthSun' AS type FROM wp_calendar AS g WHERE g.event_recur = 'U' AND EXTRACT(YEAR FROM '2023-2-22') >= EXTRACT(YEAR FROM g.event_begin) AND g.event_repeats != 0 AND (PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM '2023-2-22'),EXTRACT(YEAR_MONTH FROM g.event_begin))) <= g.event_repeats
UNION ALL
SELECT h.*,'Weekly' AS type FROM wp_calendar AS h WHERE h.event_recur = 'W' AND '2023-2-22' >= h.event_begin AND h.event_repeats = 0
UNION ALL
SELECT i.*,'Weekly' AS type FROM wp_calendar AS i WHERE i.event_recur = 'W' AND '2023-2-22' >= i.event_begin AND i.event_repeats != 0 AND (i.event_repeats*7) >= (TO_DAYS('2023-2-22') - TO_DAYS(i.event_end))
ORDER BY event_id
Errore sul database di WordPress: [Got error 28 from storage engine]SELECT a.*,'Normal' AS type FROM wp_calendar AS a WHERE a.event_begin <= '2023-2-23' AND a.event_end >= '2023-2-23' AND a.event_recur = 'S'
UNION ALL
SELECT b.*,'Yearly' AS type FROM wp_calendar AS b WHERE b.event_recur = 'Y' AND EXTRACT(YEAR FROM '2023-2-23') >= EXTRACT(YEAR FROM b.event_begin) AND b.event_repeats = 0
UNION ALL
SELECT c.*,'Yearly' AS type FROM wp_calendar AS c WHERE c.event_recur = 'Y' AND EXTRACT(YEAR FROM '2023-2-23') >= EXTRACT(YEAR FROM c.event_begin) AND c.event_repeats != 0 AND (EXTRACT(YEAR FROM '2023-2-23')-EXTRACT(YEAR FROM c.event_begin)) <= c.event_repeats
UNION ALL
SELECT d.*,'Monthly' AS type FROM wp_calendar AS d WHERE d.event_recur = 'M' AND EXTRACT(YEAR FROM '2023-2-23') >= EXTRACT(YEAR FROM d.event_begin) AND d.event_repeats = 0
UNION ALL
SELECT e.*,'Monthly' AS type FROM wp_calendar AS e WHERE e.event_recur = 'M' AND EXTRACT(YEAR FROM '2023-2-23') >= EXTRACT(YEAR FROM e.event_begin) AND e.event_repeats != 0 AND (PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM '2023-2-23'),EXTRACT(YEAR_MONTH FROM e.event_begin))) <= e.event_repeats
UNION ALL
SELECT f.*,'MonthSun' AS type FROM wp_calendar AS f WHERE f.event_recur = 'U' AND EXTRACT(YEAR FROM '2023-2-23') >= EXTRACT(YEAR FROM f.event_begin) AND f.event_repeats = 0
UNION ALL
SELECT g.*,'MonthSun' AS type FROM wp_calendar AS g WHERE g.event_recur = 'U' AND EXTRACT(YEAR FROM '2023-2-23') >= EXTRACT(YEAR FROM g.event_begin) AND g.event_repeats != 0 AND (PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM '2023-2-23'),EXTRACT(YEAR_MONTH FROM g.event_begin))) <= g.event_repeats
UNION ALL
SELECT h.*,'Weekly' AS type FROM wp_calendar AS h WHERE h.event_recur = 'W' AND '2023-2-23' >= h.event_begin AND h.event_repeats = 0
UNION ALL
SELECT i.*,'Weekly' AS type FROM wp_calendar AS i WHERE i.event_recur = 'W' AND '2023-2-23' >= i.event_begin AND i.event_repeats != 0 AND (i.event_repeats*7) >= (TO_DAYS('2023-2-23') - TO_DAYS(i.event_end))
ORDER BY event_id
Errore sul database di WordPress: [Got error 28 from storage engine]SELECT a.*,'Normal' AS type FROM wp_calendar AS a WHERE a.event_begin <= '2023-2-24' AND a.event_end >= '2023-2-24' AND a.event_recur = 'S'
UNION ALL
SELECT b.*,'Yearly' AS type FROM wp_calendar AS b WHERE b.event_recur = 'Y' AND EXTRACT(YEAR FROM '2023-2-24') >= EXTRACT(YEAR FROM b.event_begin) AND b.event_repeats = 0
UNION ALL
SELECT c.*,'Yearly' AS type FROM wp_calendar AS c WHERE c.event_recur = 'Y' AND EXTRACT(YEAR FROM '2023-2-24') >= EXTRACT(YEAR FROM c.event_begin) AND c.event_repeats != 0 AND (EXTRACT(YEAR FROM '2023-2-24')-EXTRACT(YEAR FROM c.event_begin)) <= c.event_repeats
UNION ALL
SELECT d.*,'Monthly' AS type FROM wp_calendar AS d WHERE d.event_recur = 'M' AND EXTRACT(YEAR FROM '2023-2-24') >= EXTRACT(YEAR FROM d.event_begin) AND d.event_repeats = 0
UNION ALL
SELECT e.*,'Monthly' AS type FROM wp_calendar AS e WHERE e.event_recur = 'M' AND EXTRACT(YEAR FROM '2023-2-24') >= EXTRACT(YEAR FROM e.event_begin) AND e.event_repeats != 0 AND (PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM '2023-2-24'),EXTRACT(YEAR_MONTH FROM e.event_begin))) <= e.event_repeats
UNION ALL
SELECT f.*,'MonthSun' AS type FROM wp_calendar AS f WHERE f.event_recur = 'U' AND EXTRACT(YEAR FROM '2023-2-24') >= EXTRACT(YEAR FROM f.event_begin) AND f.event_repeats = 0
UNION ALL
SELECT g.*,'MonthSun' AS type FROM wp_calendar AS g WHERE g.event_recur = 'U' AND EXTRACT(YEAR FROM '2023-2-24') >= EXTRACT(YEAR FROM g.event_begin) AND g.event_repeats != 0 AND (PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM '2023-2-24'),EXTRACT(YEAR_MONTH FROM g.event_begin))) <= g.event_repeats
UNION ALL
SELECT h.*,'Weekly' AS type FROM wp_calendar AS h WHERE h.event_recur = 'W' AND '2023-2-24' >= h.event_begin AND h.event_repeats = 0
UNION ALL
SELECT i.*,'Weekly' AS type FROM wp_calendar AS i WHERE i.event_recur = 'W' AND '2023-2-24' >= i.event_begin AND i.event_repeats != 0 AND (i.event_repeats*7) >= (TO_DAYS('2023-2-24') - TO_DAYS(i.event_end))
ORDER BY event_id
Errore sul database di WordPress: [Got error 28 from storage engine]SELECT a.*,'Normal' AS type FROM wp_calendar AS a WHERE a.event_begin <= '2023-2-25' AND a.event_end >= '2023-2-25' AND a.event_recur = 'S'
UNION ALL
SELECT b.*,'Yearly' AS type FROM wp_calendar AS b WHERE b.event_recur = 'Y' AND EXTRACT(YEAR FROM '2023-2-25') >= EXTRACT(YEAR FROM b.event_begin) AND b.event_repeats = 0
UNION ALL
SELECT c.*,'Yearly' AS type FROM wp_calendar AS c WHERE c.event_recur = 'Y' AND EXTRACT(YEAR FROM '2023-2-25') >= EXTRACT(YEAR FROM c.event_begin) AND c.event_repeats != 0 AND (EXTRACT(YEAR FROM '2023-2-25')-EXTRACT(YEAR FROM c.event_begin)) <= c.event_repeats
UNION ALL
SELECT d.*,'Monthly' AS type FROM wp_calendar AS d WHERE d.event_recur = 'M' AND EXTRACT(YEAR FROM '2023-2-25') >= EXTRACT(YEAR FROM d.event_begin) AND d.event_repeats = 0
UNION ALL
SELECT e.*,'Monthly' AS type FROM wp_calendar AS e WHERE e.event_recur = 'M' AND EXTRACT(YEAR FROM '2023-2-25') >= EXTRACT(YEAR FROM e.event_begin) AND e.event_repeats != 0 AND (PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM '2023-2-25'),EXTRACT(YEAR_MONTH FROM e.event_begin))) <= e.event_repeats
UNION ALL
SELECT f.*,'MonthSun' AS type FROM wp_calendar AS f WHERE f.event_recur = 'U' AND EXTRACT(YEAR FROM '2023-2-25') >= EXTRACT(YEAR FROM f.event_begin) AND f.event_repeats = 0
UNION ALL
SELECT g.*,'MonthSun' AS type FROM wp_calendar AS g WHERE g.event_recur = 'U' AND EXTRACT(YEAR FROM '2023-2-25') >= EXTRACT(YEAR FROM g.event_begin) AND g.event_repeats != 0 AND (PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM '2023-2-25'),EXTRACT(YEAR_MONTH FROM g.event_begin))) <= g.event_repeats
UNION ALL
SELECT h.*,'Weekly' AS type FROM wp_calendar AS h WHERE h.event_recur = 'W' AND '2023-2-25' >= h.event_begin AND h.event_repeats = 0
UNION ALL
SELECT i.*,'Weekly' AS type FROM wp_calendar AS i WHERE i.event_recur = 'W' AND '2023-2-25' >= i.event_begin AND i.event_repeats != 0 AND (i.event_repeats*7) >= (TO_DAYS('2023-2-25') - TO_DAYS(i.event_end))
ORDER BY event_id
Errore sul database di WordPress: [Got error 28 from storage engine]SELECT a.*,'Normal' AS type FROM wp_calendar AS a WHERE a.event_begin <= '2023-2-26' AND a.event_end >= '2023-2-26' AND a.event_recur = 'S'
UNION ALL
SELECT b.*,'Yearly' AS type FROM wp_calendar AS b WHERE b.event_recur = 'Y' AND EXTRACT(YEAR FROM '2023-2-26') >= EXTRACT(YEAR FROM b.event_begin) AND b.event_repeats = 0
UNION ALL
SELECT c.*,'Yearly' AS type FROM wp_calendar AS c WHERE c.event_recur = 'Y' AND EXTRACT(YEAR FROM '2023-2-26') >= EXTRACT(YEAR FROM c.event_begin) AND c.event_repeats != 0 AND (EXTRACT(YEAR FROM '2023-2-26')-EXTRACT(YEAR FROM c.event_begin)) <= c.event_repeats
UNION ALL
SELECT d.*,'Monthly' AS type FROM wp_calendar AS d WHERE d.event_recur = 'M' AND EXTRACT(YEAR FROM '2023-2-26') >= EXTRACT(YEAR FROM d.event_begin) AND d.event_repeats = 0
UNION ALL
SELECT e.*,'Monthly' AS type FROM wp_calendar AS e WHERE e.event_recur = 'M' AND EXTRACT(YEAR FROM '2023-2-26') >= EXTRACT(YEAR FROM e.event_begin) AND e.event_repeats != 0 AND (PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM '2023-2-26'),EXTRACT(YEAR_MONTH FROM e.event_begin))) <= e.event_repeats
UNION ALL
SELECT f.*,'MonthSun' AS type FROM wp_calendar AS f WHERE f.event_recur = 'U' AND EXTRACT(YEAR FROM '2023-2-26') >= EXTRACT(YEAR FROM f.event_begin) AND f.event_repeats = 0
UNION ALL
SELECT g.*,'MonthSun' AS type FROM wp_calendar AS g WHERE g.event_recur = 'U' AND EXTRACT(YEAR FROM '2023-2-26') >= EXTRACT(YEAR FROM g.event_begin) AND g.event_repeats != 0 AND (PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM '2023-2-26'),EXTRACT(YEAR_MONTH FROM g.event_begin))) <= g.event_repeats
UNION ALL
SELECT h.*,'Weekly' AS type FROM wp_calendar AS h WHERE h.event_recur = 'W' AND '2023-2-26' >= h.event_begin AND h.event_repeats = 0
UNION ALL
SELECT i.*,'Weekly' AS type FROM wp_calendar AS i WHERE i.event_recur = 'W' AND '2023-2-26' >= i.event_begin AND i.event_repeats != 0 AND (i.event_repeats*7) >= (TO_DAYS('2023-2-26') - TO_DAYS(i.event_end))
ORDER BY event_id
Errore sul database di WordPress: [Got error 28 from storage engine]SELECT a.*,'Normal' AS type FROM wp_calendar AS a WHERE a.event_begin <= '2023-2-27' AND a.event_end >= '2023-2-27' AND a.event_recur = 'S'
UNION ALL
SELECT b.*,'Yearly' AS type FROM wp_calendar AS b WHERE b.event_recur = 'Y' AND EXTRACT(YEAR FROM '2023-2-27') >= EXTRACT(YEAR FROM b.event_begin) AND b.event_repeats = 0
UNION ALL
SELECT c.*,'Yearly' AS type FROM wp_calendar AS c WHERE c.event_recur = 'Y' AND EXTRACT(YEAR FROM '2023-2-27') >= EXTRACT(YEAR FROM c.event_begin) AND c.event_repeats != 0 AND (EXTRACT(YEAR FROM '2023-2-27')-EXTRACT(YEAR FROM c.event_begin)) <= c.event_repeats
UNION ALL
SELECT d.*,'Monthly' AS type FROM wp_calendar AS d WHERE d.event_recur = 'M' AND EXTRACT(YEAR FROM '2023-2-27') >= EXTRACT(YEAR FROM d.event_begin) AND d.event_repeats = 0
UNION ALL
SELECT e.*,'Monthly' AS type FROM wp_calendar AS e WHERE e.event_recur = 'M' AND EXTRACT(YEAR FROM '2023-2-27') >= EXTRACT(YEAR FROM e.event_begin) AND e.event_repeats != 0 AND (PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM '2023-2-27'),EXTRACT(YEAR_MONTH FROM e.event_begin))) <= e.event_repeats
UNION ALL
SELECT f.*,'MonthSun' AS type FROM wp_calendar AS f WHERE f.event_recur = 'U' AND EXTRACT(YEAR FROM '2023-2-27') >= EXTRACT(YEAR FROM f.event_begin) AND f.event_repeats = 0
UNION ALL
SELECT g.*,'MonthSun' AS type FROM wp_calendar AS g WHERE g.event_recur = 'U' AND EXTRACT(YEAR FROM '2023-2-27') >= EXTRACT(YEAR FROM g.event_begin) AND g.event_repeats != 0 AND (PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM '2023-2-27'),EXTRACT(YEAR_MONTH FROM g.event_begin))) <= g.event_repeats
UNION ALL
SELECT h.*,'Weekly' AS type FROM wp_calendar AS h WHERE h.event_recur = 'W' AND '2023-2-27' >= h.event_begin AND h.event_repeats = 0
UNION ALL
SELECT i.*,'Weekly' AS type FROM wp_calendar AS i WHERE i.event_recur = 'W' AND '2023-2-27' >= i.event_begin AND i.event_repeats != 0 AND (i.event_repeats*7) >= (TO_DAYS('2023-2-27') - TO_DAYS(i.event_end))
ORDER BY event_id
Errore sul database di WordPress: [Got error 28 from storage engine]SELECT a.*,'Normal' AS type FROM wp_calendar AS a WHERE a.event_begin <= '2023-2-28' AND a.event_end >= '2023-2-28' AND a.event_recur = 'S'
UNION ALL
SELECT b.*,'Yearly' AS type FROM wp_calendar AS b WHERE b.event_recur = 'Y' AND EXTRACT(YEAR FROM '2023-2-28') >= EXTRACT(YEAR FROM b.event_begin) AND b.event_repeats = 0
UNION ALL
SELECT c.*,'Yearly' AS type FROM wp_calendar AS c WHERE c.event_recur = 'Y' AND EXTRACT(YEAR FROM '2023-2-28') >= EXTRACT(YEAR FROM c.event_begin) AND c.event_repeats != 0 AND (EXTRACT(YEAR FROM '2023-2-28')-EXTRACT(YEAR FROM c.event_begin)) <= c.event_repeats
UNION ALL
SELECT d.*,'Monthly' AS type FROM wp_calendar AS d WHERE d.event_recur = 'M' AND EXTRACT(YEAR FROM '2023-2-28') >= EXTRACT(YEAR FROM d.event_begin) AND d.event_repeats = 0
UNION ALL
SELECT e.*,'Monthly' AS type FROM wp_calendar AS e WHERE e.event_recur = 'M' AND EXTRACT(YEAR FROM '2023-2-28') >= EXTRACT(YEAR FROM e.event_begin) AND e.event_repeats != 0 AND (PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM '2023-2-28'),EXTRACT(YEAR_MONTH FROM e.event_begin))) <= e.event_repeats
UNION ALL
SELECT f.*,'MonthSun' AS type FROM wp_calendar AS f WHERE f.event_recur = 'U' AND EXTRACT(YEAR FROM '2023-2-28') >= EXTRACT(YEAR FROM f.event_begin) AND f.event_repeats = 0
UNION ALL
SELECT g.*,'MonthSun' AS type FROM wp_calendar AS g WHERE g.event_recur = 'U' AND EXTRACT(YEAR FROM '2023-2-28') >= EXTRACT(YEAR FROM g.event_begin) AND g.event_repeats != 0 AND (PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM '2023-2-28'),EXTRACT(YEAR_MONTH FROM g.event_begin))) <= g.event_repeats
UNION ALL
SELECT h.*,'Weekly' AS type FROM wp_calendar AS h WHERE h.event_recur = 'W' AND '2023-2-28' >= h.event_begin AND h.event_repeats = 0
UNION ALL
SELECT i.*,'Weekly' AS type FROM wp_calendar AS i WHERE i.event_recur = 'W' AND '2023-2-28' >= i.event_begin AND i.event_repeats != 0 AND (i.event_repeats*7) >= (TO_DAYS('2023-2-28') - TO_DAYS(i.event_end))
ORDER BY event_id
|
|||||||||
| Lunedì | Martedì | Mercoledì | Giovedì | Venerdì | Sabato | Domenica | |||
| 1 |
2 |
3 |
4 |
5 |
|||||
| 6 |
7 |
8 |
9 |
10 |
11 |
12 |
|||
| 13 |
14 |
15 |
16 |
17 |
18 |
19 |
|||
| 20 |
21 |
22 |
23 |
24 |
25 |
26 |
|||
| 27 |
28 |
||||||||