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 <= '2020-9-3' AND a.event_end >= '2020-9-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 '2020-9-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 '2020-9-3') >= EXTRACT(YEAR FROM c.event_begin) AND c.event_repeats != 0 AND (EXTRACT(YEAR FROM '2020-9-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 '2020-9-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 '2020-9-3') >= EXTRACT(YEAR FROM e.event_begin) AND e.event_repeats != 0 AND (PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM '2020-9-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 '2020-9-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 '2020-9-3') >= EXTRACT(YEAR FROM g.event_begin) AND g.event_repeats != 0 AND (PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM '2020-9-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 '2020-9-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 '2020-9-3' >= i.event_begin AND i.event_repeats != 0 AND (i.event_repeats*7) >= (TO_DAYS('2020-9-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 <= '2020-9-25' AND a.event_end >= '2020-9-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 '2020-9-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 '2020-9-25') >= EXTRACT(YEAR FROM c.event_begin) AND c.event_repeats != 0 AND (EXTRACT(YEAR FROM '2020-9-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 '2020-9-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 '2020-9-25') >= EXTRACT(YEAR FROM e.event_begin) AND e.event_repeats != 0 AND (PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM '2020-9-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 '2020-9-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 '2020-9-25') >= EXTRACT(YEAR FROM g.event_begin) AND g.event_repeats != 0 AND (PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM '2020-9-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 '2020-9-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 '2020-9-25' >= i.event_begin AND i.event_repeats != 0 AND (i.event_repeats*7) >= (TO_DAYS('2020-9-25') - 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 |
29 |
30 |