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 - MSC CRUISES, MSC Lirica’s current Deep and Western Caribbean itineraries....
MSC CRUISES, MSC Lirica’s current Deep and Western Caribbean itineraries....
MSC CRUISES, MSC Lirica’s current Deep and Western Caribbean itineraries....MSC Lirica’s current Deep and Western Caribbean itineraries feature a call at the line’s private island – the popular Cayo Levantado in the Dominican Republic – a prime spot for watching humpback whales. For the 2008-2009 Caribbean season, the company will have two state-of-the-art ships, MSC Lirica and MSC Orchestra, offering seven Caribbean itineraries featuring 16 ports, including a maiden call in Bermuda. MSC Orchestra, one of the company’s newest vessels, just debuted last year


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