Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/mhd-01/www.crocieramania.it/htdocs/_dbquery.php on line 224
Crociera Mania by Mania Team Net - Crociere Costa MSC Princess Carnival Celebrity - Princess cruise TAHITIAN PRINCESS to become OCEAN PRINCESS, renamed for new deployments
Princess cruise TAHITIAN PRINCESS to become OCEAN PRINCESS, renamed for new deployments
Princess cruise TAHITIAN PRINCESS to become OCEAN PRINCESS, renamed for new deploymentsTahitian Princess, one of the small ships in the Princess fleet, will be renamed in 2009, becoming Ocean Princess. The new name is intended to reflect the ship's new deployment on worldwide itineraries. The renaming will take place while the ship is out of service during a routine maintenance period in Singapore in November 2009.

During next year's fall season, Pacific Princess, another of the line's small vessels, will provide cruises from Papeete, Tahiti, where the Tahitian Princess has been based.

"Tahitian Princess, along with our other two small ships, has developed a loyal following of passengers who enjoy a more intimate cruise experience, and also the opportunity to visit some off-the-beaten-path destinations," said Jan Swartz, Princess' senior vice president of customer service and sales. "As this ship is now sailing on itineraries around the world, we felt its name should reflect a more global theme."

Tahitian Princess joined the Princess fleet in 2002, and has been primarily deployed on sailings in the South Pacific, particularly French Polynesia and Hawaii. Beginning this summer, the ship sets off on new worldwide deployments, featuring a Connoisseur's cruise in Alaska, a world cruise in early 2009 and a season of unique Northern Europe sailings next summer. Following the 2009 renaming, Ocean Princess will sail on a series of Asia voyages to be announced separately.


Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'crociera47124.A.id_product' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
name
select DISTINCT(A.name), A.id_product, A.thumbnail, IF (MIN(C.stock) <> 0, IF (MIN(C.stock) < 0, 1000, MIN(C.stock)), IF (MAX(C.stock) <> 0, MAX(C.stock), IF (A.stock = -1, 1000, A.stock))) as `stock`, IF (D.price <> 0, D.price, IF (MIN(C.price) <> 0, MIN(C.price), A.price)) as `price`, IF (MIN(C.price) <> 0, MIN(C.price), A.price) as `original_price`, IF (D.price <> 0, 1, 0) as `onsale`, A.description, A.addbr, A.subproducts from `cpProducts` as A left join `cpLinkedProducts` as B on (A.id_product=B.id_product) left join `cpSubProducts` as C on (A.id_product=C.id_product) left join `cpSales` as D on (A.id_product=D.id_product and D.start <= NOW() and D.last >= NOW() or C.id_subproduct=D.id_subproduct and D.start <= NOW() and D.last >= NOW()) where A.id_category='45' or B.id_category='45' GROUP BY A.name order by A.name asc limit 0, 15