- S
- M
- T
- W
- T
- F
- S
-
-
-
-
SELECT
events.e_id AS events_id,
date_format(STR_TO_DATE( REPLACE( events.e_date, '/', '.' ) , GET_FORMAT( DATE, 'USA' ) ),'%e') as date_number,
date_format(STR_TO_DATE( REPLACE( events.e_date, '/', '.' ) , GET_FORMAT( DATE, 'USA' ) ),'%c/%e') as month_date,
shows.title,
shows.status,
events.e_ticket_link as ticket_link
FROM events, shows
WHERE events.e_show_id=shows.show_id
AND STR_TO_DATE( REPLACE( events.e_date, '/', '.' ) , GET_FORMAT( DATE, 'USA' ) ) >= DATE_SUB(now(), INTERVAL 1 DAY)
AND STR_TO_DATE( REPLACE( events.e_date, '/', '.' ) , GET_FORMAT( DATE, 'USA' ) ) >= '2024-8-01'
AND STR_TO_DATE( REPLACE( events.e_date, '/', '.' ) , GET_FORMAT( DATE, 'USA' ) ) < '2024-9-01'
AND e_status=1
AND shows.status = '1'
- 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
- 31