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 CROCIERE - MSC CRUISES
MSC CROCIERE - MSC CRUISES
MSC CROCIERE - MSC CRUISESNAVI MSC CROCIERE CON WEBCAM A BORDO MSC CRUISES SHIPS WITH A WEBCAM


Lista MSC CROCIERE - MSC CRUISES
Webcam MSC Fantasia
Webcam MSC Fantasia
Webcam MSC Orchestra
Webcam MSC Orchestra
Webcam MSC Poesia
Webcam MSC Poesia
Webcam MSC Musica
Webcam MSC Musica
Webcam MSC Opera
Webcam MSC Opera
Webcam MSC Lirica
Webcam MSC Lirica
Webcam MSC Sinfonia
Webcam MSC Sinfonia
Webcam MSC Armonia
Webcam MSC Armonia
Webcam MSC Melody
Webcam MSC Melody

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