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 - Star Cruises Sells Norwegian Dream And Norwegian Majesty
Star Cruises Sells Norwegian Dream And Norwegian Majesty
Star Cruises Sells Norwegian Dream And Norwegian Majesty Star Cruises today announced another step to further strengthen the Groupís capital structure. The Group has completed the sale of two ships, Norwegian Dream and Norwegian Majesty to the Cyprus Louis Group for US$218 million and US$162 million respectively. The two ships will be chartered back from the new owner to complete their announced scheduled itineraries in November 2008 for Norwegian Dream and December 2009 for Norwegian Majesty.


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='49' or B.id_category='49' GROUP BY A.name order by A.name asc limit 0, 15