|
|
ปฏิทินกิจกรรม
|
« |
พฤษภาคม 2567 |
» |
อา. |
จ. |
อ. |
พ. |
พฤ. |
ศ. |
ส. |
| | |
select
cal_event.*, cal_show_event.event_date_start, cal_show_event.event_date_end, cal_category.cat_name,
cal_category.cat_color, cal_show_event.event_show_end, cal_show_event.event_show_start
from
cal_event inner join cal_show_event on cal_event.event_id = cal_show_event.event_id
inner join cal_category on cal_category.cat_id = cal_event.cat_id
left join cal_invite on cal_event.event_id = cal_invite.event_id
where
(cal_event.event_date_start <= '2024-05-01' and cal_event.event_date_end >= '2024-05-01') and
((cal_show_event.event_show_start <= '2024-05-02' OR cal_show_event.event_show_start = '0000-00-00') and (cal_show_event.event_show_end >= '2024-05-02' OR cal_show_event.event_show_end = '0000-00-00'))
AND (cal_event.event_private = '2')
group by cal_event.event_id
order by cal_show_event.event_date_start, cal_show_event.event_date_end Can't create/write to file '/tmp/#sql_40b_0.MYI' (Errcode: 30) | | | |