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 - NEWS
NEWS
Notizie dal mondo cantieristico, delle associazioni di categoria e delle vacanze.


Lista NEWS
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,....
DISNEY CRUISE LINE, Look for the all-new “Toy Story-The Musical” stage spectacular on Disney Wonder’s Caribbean sailings....
DISNEY CRUISE LINE, Look for the all-new “Toy Story-The Musical” stage spectacular on Disney Wonder’s Caribbean sailings....
MSC CRUISES, MSC Lirica’s current Deep and Western Caribbean itineraries....
MSC CRUISES, MSC Lirica’s current Deep and Western Caribbean itineraries....
Princess cruise TAHITIAN PRINCESS to become OCEAN PRINCESS, renamed for new deployments
Princess cruise TAHITIAN PRINCESS to become OCEAN PRINCESS, renamed for new deployments
Star Cruises Sells Norwegian Dream And Norwegian Majesty
Star Cruises Sells Norwegian Dream And Norwegian Majesty
Certificazioni Occorrenti per Ufficiali Marina Mercantile

Pagina: 1


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