DB::query(SELECT DISTINCT( items.id ), items.title FROM items INNER JOIN itemLocation ON itemLocation.itemId = items.id WHERE items.section = 37 AND itemLocation.country = AND items.id <> 2869 AND items.site = 'ttm' AND items.active = 'y' AND items.dateadded <= '2008-11-21 09:38:13' ORDER BY items.dateadded DESC LIMIT 0, 15)
mysql_query

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND items.id <> 2869 AND items.site = 'ttm' AND items.active = 'y' ' at line 6
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/lib/class_db.php on line 145

DB::query(SELECT DISTINCT( i.title ), i.id FROM items i LEFT JOIN itemCategory ic ON i.id = ic.itemId LEFT JOIN itemLocation il ON i.id = il.itemId WHERE i.section = 37 AND country = AND category = 80 AND subcategory = 0 AND i.active = 'y')
mysql_query

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND category = 80 AND subcategory = 0 AND i.active = 'y'' at line 7 Theme Parks Around The World :: The Travel Magazine
 

Sections

Village Properties

Dental Cyprus

Travel Talk Radio

English Retreats

SkiingTheAlps - Your guide to European skiing resorts

Cheap Hotels

Receive the FREE Travel Newsletter :

Theme Parks Around The World

Print Mail to a friend

Everyone in the family loves a theme park. Here we list some of the most popular theme parks around the world.

Close Email a friend

Security Code

 

THEME PARKS IN THE UNITED KINGDOM

What: Chessington World of Adventures
Where: Surrey, England, UK
When: March 24 – October 31

What: Thorpe Park
Where: Surrey, England, UK
When: March 17 – November 4

What: Alton Towers
Where: Staffordshire, England, UK
When: March 17 – November 11
Web: www.altontowers.com

THEME PARKS IN SPAIN

What: PortAventura
Where: Salou, Spain
When: March 23 – January 7
More information: PortAventura

What: Terra Mitica
Where: Benidorm, Spain
When: March 25 – November 5

THEME PARKS IN ITALY

What: Gardaland

Where: Bardolino, Italy
When: March 31 – January 6


THEME PARKS IN GERMANY

What: Phantasialand
Where: Breuhl, Germany
When: April 1 – November 4

What: Europa Park

Where: Rust, Germany
When: March 31 – January 7


THEME PARKS IN THE NETHERLANDS

What: Efteling
Where:
Tilburg
When: April 1 – October 28
Web: Efteling


THEME PARKS IN DENMARK

What: Tivoli Gardens
Where: Copenhagen, Denmark
When: April 13 – September 23


THEME PARKS IN FRANCE

What: Disneyland Resort
Where: Paris, France
When: Open all year
Web: Disneyland Resort Paris

What: Parc Asterix
Where: Plailly, France
When: April 5 – October 14

What: Futurescope

Where: Poitiers, France
When: 10 February – January 6
Web: Futuroscope

THEME PARKS IN USA

What: Universal Studios
Where: Orlando, USA
When: Open all year

What: Walt Disney World Resort
Where: Orlando, USA
When: Open all year
More Information: Walt Disney World Resort

What: Disneyland Resort
Where: Carlifornia, USA
When: Open all year

What: Busch Gardens
Where: Tampa Bay, USA
When: Open all year
Web: Busch Gardens

What: Universal Studios

Where: Hollywood, USA
When: Open all year

What: Six Flags Magic Mountain
Where: Hollywood, USA
When: Open all year

What: Knott’s Berry Farm
Where: Buena Park, USA
When: Open all year
Web: Knott's

AUSTRALIA

What: Warner Bros. Movie World
Where:
Gold Coast, USA
When: Open all year except Christmas Day

31 July 2008

Comments

Be the first to leave a comment

Add Your Comment

Your comment has been recieved.

You will recieve an email once one of our modarators has
approved your comment.

Please note: all comments will be manually verified by our staff before appearing on the site. Please do not try and spam and do not use offending language. If you want to be notified when your post has been published, add your email address below.

Required Fields


Optional

If you want us to email you when your comment is posted or when someone else posts a comment, enter your email address here.

 

More Destination Guides

 

EuropeAfricaNorth AmericaEast-Southeast AsiaAustralasiaMiddle EastCaribbeanLatin AmericaIndian SubcontinentCentral Asia