|Princess cruise TAHITIAN PRINCESS to become OCEAN PRINCESS, renamed for new deployments|
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
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