The following sponsors proudly support the Friends of the Greenbelt Foundation.

© 2009 Unless otherwise indicated, all information contained on this website is the copyright property of Tourism Niagara and Brock University. All other information is the copyright property of its respective owner(s). Disclaimer.

TRAVEL ITINERARY

No POIs selected

COMMUNITY

General Information

TRAVEL ITINERARY

Click "PRINT" to print your itinerary to your PDF writer for off-line viewing.

If you don't have a PDF writer please download one here.

MULTIMEDIA FILES

Video, audio and image files will be zipped. Click "SAVE" to download the file to your computer.

SELECT p.parent AS parent, p.parent_title AS parent_title, cc.id AS catid, cc.title AS category, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS("-", cc.id, cc.alias,".html") ELSE cc.id END as catslug, IFNULL(COUNT( b.id ),0) + IFNULL(subitems,0) AS numitems FROM #__categories AS cc LEFT JOIN #__content AS b ON b.catid = cc.id LEFT JOIN ( SELECT COUNT(con.id) AS subitems, cats.parent_id FROM #__content AS con INNER JOIN #__categories AS cats ON con.catid = cats.id GROUP BY cats.parent_id) AS lvl2 ON lvl2.parent_id = cc.id INNER JOIN ( SELECT id AS parent, title AS parent_title FROM #__categories WHERE parent_id = 0 AND section IN (1,2,3,4,5,6) ) AS p ON cc.parent_id = p.parent GROUP BY cc.id HAVING numitems > 0 ORDER BY p.parent_title, cc.title DESC

POI Descriptions :	Brief	Full
Attach photo gallery images :	No	Yes
Attach multimedia files :	No	Yes

To :
Message :	Check out the great itinerary full of interesting stops I made at http://www.niagaragreenbelt.com.
Link :

TRAVEL ITINERARY

MULTIMEDIA FILES

PixSearch