Vaughan Public Libraries
Enrich Inspire Transform
 

We are sorry. The page you were looking for could not be found.

If you were directed here from a link in this site, please feel free to let us know.
If you were directed here from a different site you might want to inform that site's owner the link is incorrect.
If you entered the URL manually, please check it for typos.

To find the content you were looking for you may:

The main page of this site is: http://www.vaughanpl.info

 
Translate this Site
How do I
Site Map | Site Search | FAQs | Privacy | Contact | Donate to VPL © Vaughan Public Libraries 2014
Locations & Hours | Check My Record/Renew | Downloads & Digital
9 queries took 33 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `RecommendedLinks`14142
2DESCRIBE `RL_SpecificSubjects`331
3SELECT `Subject`.`SpecificSubjectID`, `Subject`.`BroadSubjectID`, `Subject`.`SpecificSubjectName` FROM `RL_SpecificSubjects` AS `Subject` WHERE `Subject`.`specificsubjectid` = 522 LIMIT 1112
4 SELECT BroadSubjectID, AreaID, BroadSubjectName FROM RL_BroadSubjects AS BroadSubject WHERE BroadSubjectID = 135111
5SELECT `Area`.`AreaID`, `Area`.`AreaName`, `Area`.`AreaTypeID`, `Area`.`URL`, `Area`.`Image`, `Area`.`Description`, `Area`.`Live` FROM `AreasOfVPLSite` AS `Area` WHERE `Area`.`areaid` = 1 LIMIT 1111
6SELECT `AreaPage`.`AreaID`, `AreaPage`.`page_type`, `AreaPage`.`page_title`, `AreaPage`.`page_url` FROM `Area_pages` AS `AreaPage` WHERE `AreaPage`.`AreaID` IN (1) ORDER BY `AreaPage`.`page_type` ASC 001
7 SELECT AreasOfVPLSite.AreaID, AreasOfVPLSite.AreaName, AreasOfVPLSite.AreaTypeID, RL_BroadSubjects.BroadSubjectID, RL_BroadSubjects.BroadSubjectName, IF(RL_SpecificSubjects.BroadSubjectID=135,RL_SpecificSubjects.SpecificSubjectID,null) AS ApplicableSpecificSubjectID, IF(RL_SpecificSubjects.BroadSubjectID=135,RL_SpecificSubjects.SpecificSubjectName,null) AS ApplicableSpecificSubjectName, count(RL_Link_Subject.LinkID) AS HowMany FROM AreasOfVPLSite JOIN RL_BroadSubjects ON RL_BroadSubjects.AreaID = AreasOfVPLSite.AreaID JOIN RL_SpecificSubjects ON RL_SpecificSubjects.BroadSubjectID = RL_BroadSubjects.BroadSubjectID JOIN RL_Link_Subject on RL_Link_Subject.SpecificSubjectID = RL_SpecificSubjects.SpecificSubjectID JOIN RecommendedLinks on RL_Link_Subject.LinkID = RecommendedLinks.LinkID WHERE AreasOfVPLSite.AreaID = 1 AND RecommendedLinks.IsLive = '1' GROUP BY AreasOfVPLSite.AreaID, AreasOfVPLSite.AreaName, AreasOfVPLSite.AreaTypeID, RL_BroadSubjects.BroadSubjectID, RL_BroadSubjects.BroadSubjectName, ApplicableSpecificSubjectID, ApplicableSpecificSubjectName ORDER BY AreasOfVPLSite.AreaName, RL_BroadSubjects.BroadSubjectName, RL_SpecificSubjects.SpecificSubjectName262618
8SELECT DISTINCT Link.LinkID, Link.TitleOfWebsite, Link.UrlOfWebsite, Link.Description, Link.WebsitePublisher, Link.DateUpdated, SiteArea.AreaName, MATCH(Link.TitleOfWebsite, Link.Description, Link.Keywords) AGAINST ('*' IN BOOLEAN MODE) AS Relevance FROM RecommendedLinks Link, RL_Link_Subject, RL_BroadSubjects SubjectArea, RL_SpecificSubjects Subject, AreasOfVPLSite SiteArea WHERE SubjectArea.AreaID = SiteArea.AreaID AND Subject.BroadSubjectID = SubjectArea.BroadSubjectID AND RL_Link_Subject.SpecificSubjectID = Subject.SpecificSubjectID AND Link.IsLive = '1' AND RL_Link_Subject.LinkID = Link.LinkID AND Subject.SpecificSubjectID=522 GROUP BY Link.LinkID, Link.TitleOfWebsite, Link.UrlOfWebsite, Link.Description, Link.WebsitePublisher, Link.DateUpdated, SiteArea.AreaName ORDER BY Relevance DESC, TitleOfWebsite LIMIT 0,10334
9SELECT COUNT(DISTINCT Link.LinkID) as count FROM RecommendedLinks Link, RL_Link_Subject, RL_BroadSubjects SubjectArea, RL_SpecificSubjects Subject, AreasOfVPLSite SiteArea WHERE SubjectArea.AreaID = SiteArea.AreaID AND Subject.BroadSubjectID = SubjectArea.BroadSubjectID AND RL_Link_Subject.SpecificSubjectID = Subject.SpecificSubjectID AND Link.IsLive = '1' AND RL_Link_Subject.LinkID = Link.LinkID AND Subject.SpecificSubjectID=522113