select name, flyer__media_info_id, dow, short_description, dj_music,
case
when dow = 'Mon' then 1
when dow = 'Tue' then 2
when dow = 'Wed' then 3
when dow = 'Thu' then 4
when dow = 'Fri' then 5
when dow = 'Sat' then 6
when dow = 'Sun' then 7
end as dow_code
from vs_party
where active = 1
and venue_id = 11105
and event_type = 'w'
order by dow_code asc
Database connection failed
| |
