Vaughan Public Libraries
 
  • Learn how to send attachments and how to use an address book and junk mail filters.

    Prerequisite: Email Made Easy Part I or some experience with email and your own email address.
 

Schedule

2008
Nov
Thu
 
Search the Catalogue:

Check My Record/
Renew Items
© Vaughan Public Libraries 2008
Libraries & Hours | Site Map | Site Search | FAQs | About | Privacy
12 queries took 27 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `ATL_Programs`13132
2DESCRIBE `ATL_Categories`331
3DESCRIBE `ATL_AgeGroups`221
4DESCRIBE `AreasOfVPLSite`661
5DESCRIBE `Area_pages`441
6DESCRIBE `Campaigns`10101
7DESCRIBE `ATL_Schedule`331
8SELECT `Program`.`ProgramID`, `Program`.`ProgramName`, `Program`.`Standardized`, `Program`.`Description`, `Program`.`Keywords`, `Program`.`Fee`, `Program`.`SpecialNotes`, `Program`.`ProposedBy`, `Program`.`ApprovedBy`, `Program`.`ModifiedBy`, `Program`.`DateUpdated`, `Program`.`Status`, `Program`.`Image` FROM `ATL_Programs` AS `Program` WHERE `Program`.`ProgramID` = 128 LIMIT 1111
9 SELECT Event.EventID AS id, Event.StartDate AS date, Event.StartTime AS time, Event.EndDate AS end_date, Event.EndTime AS end_time, Event.DayOfWeek AS day_of_week, Schedule.StartDate AS start_date, Schedule.EndDate AS end_date, Details.Desc_Prefix AS preffix, Details.Desc_Suffix AS suffix, Details.Image AS image, Details.Registration, Details.RegRequirement, Details.Ages, Details.SpecialNotes as notes, Library.BranchName AS name, Library.BranchID AS id FROM ATL_Events AS Details LEFT OUTER JOIN ATL_Event_Time AS Event ON Event.EventID = Details.EventID, ATL_Schedule AS Schedule, Branches AS Library WHERE Schedule.ScheduleID = Details.ScheduledFor AND Schedule.EndDate >= CURDATE() AND Details.ProgramID=128 AND Details.PublicityStatus = 1 AND Details.StatusInBranch = 2 AND (IFNULL(Event.StartDate,"9999-01-01") >= CURDATE() OR DAYOFMONTH(Event.StartDate)<1 OR Event.StartDate <> Event.EndDate) AND Library.BranchID = Details.BranchID ORDER BY IF(ISNULL(Event.StartDate) OR DAYOFMONTH(Event.StartDate)<1, "9999-01-01", Event.StartDate), Library.BranchName, Event.StartTime 118
10SELECT `Category`.`CategoryID`, `Category`.`CategoryName`, `Category`.`visible` FROM `ATL_Categories` AS `Category` JOIN `ATL_Program_Category` ON (`ATL_Program_Category`.`ProgramID` = 128 AND `ATL_Program_Category`.`CategoryID` = `Category`.`CategoryID`) WHERE 1 = 1 111
11 SELECT MainEvent.StartDate AS date, MainEvent.StartTime AS time, Details.Desc_Suffix AS comment, Library.BranchName AS name, Library.BranchShort AS short, Library.BranchID AS id , Program.ProgramName AS name, Program.Description AS description, Program.ProgramID AS id FROM ATL_Program_Category, ATL_Programs AS Program, ATL_Events AS Details, ATL_Event_Time AS MainEvent, Branches AS Library WHERE ATL_Program_Category.CategoryID=4 AND Program.ProgramID = ATL_Program_Category.ProgramID AND Details.ProgramID = ATL_Program_Category.ProgramID AND Details.PublicityStatus = 1 AND MainEvent.EventID = Details.EventID AND MainEvent.StartDate >= CURDATE() AND Library.BranchID = Details.BranchID ORDER BY MainEvent.StartDate, MainEvent.StartTime LIMIT 5 448
12SELECT `AgeGroup`.`GroupID`, `AgeGroup`.`GroupName` FROM `ATL_AgeGroups` AS `AgeGroup` JOIN `ATL_Program_AgeGroup` ON (`ATL_Program_AgeGroup`.`ProgramID` = 128 AND `ATL_Program_AgeGroup`.`AgeGroupID` = `AgeGroup`.`GroupID`) WHERE 1 = 1 111