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 - CUNARD LINE, Queen Mary 2 is sailing the Caribbean on a series of 10-day Connoisseur’s Caribbean voyages,....
CUNARD LINE, Queen Mary 2 is sailing the Caribbean on a series of 10-day Connoisseur’s Caribbean voyages,....
CUNARD LINE, Queen Mary 2 is sailing the Caribbean on a series of 10-day Connoisseur’s Caribbean voyages,....Queen Mary 2 is sailing the Caribbean on a series of 10-day Connoisseur’s Caribbean voyages, roundtrip from New York, through April 16. After the conclusion of her Transatlantic season in November, the ocean liner will return to the Caribbean, departing New York on November 21 on the eight-day Caribbean Adventure when she will call on St. Kitts, Grenada, and Bonaire en route to Ft. Lauderdale. The ship will sail several roundtrip Caribbean voyages from Ft. Lauderdale through January 13, 2009. Port calls include Tortola, St. Kitts, St. Lucia, Barbados, St. Thomas, Dominca and Panama.



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