SQL:
SELECT id, title, DATE_FORMAT(date, '%M %d, %Y') as date_formatted, short_title, short_description, location_name, image_small, highlight_order, type FROM _e_events WHERE active = 1 AND private=0 AND highlight_order > 0 ORDER BY highlight_order ASC |
SQL:
SELECT id, title, DATE_FORMAT(date, '%M %d, %Y') as date_formatted, short_title, short_description, location_name, image_small, type FROM _e_events WHERE active = 1 AND private = 0 AND highlight_order < 1 ORDER BY date ASC |
|
|
|
|||