|  | 
SELECT hwcEventType.eventTypeID, hwcEventType.eventTypeName, hwcEventType.eventTypePath, hwcEventType.eventID, hwcEvent.eventName, hwcEvent.eventStart, hwcEvent.eventStop, hwcEventPage.pageID, hwcEventPage.pageSubTitle, hwcEventPage.pageSectionTitle, hwcEventPage.pageContent, hwcEventPage.pageInclude, hwcEventPage.eventPageOrder FROM (hwcEventType INNER JOIN hwcEvent ON hwcEventType.eventID = hwcEvent.eventID) INNER JOIN hwcEventPage ON hwcEvent.eventID = hwcEventPage.eventID WHERE (hwcEventPage.pageName = '' OR hwcEventPage.pageName = '') AND hwcEventType.eventTypePath = '/gala.php' AND hwcEventType.eventID > 0 AND hwcEventType.PageID > 0 AND hwcEventType.eventTypeDeleted IS NULL AND hwcEvent.eventDeleted IS NULL AND hwcEventPage.pageDeleted IS NULL ORDER BY hwcEventPage.pageName DESC |
