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


Lista COSTA CROCIERE - COSTA CRUISES
Webcam Costa Allegra
Webcam Costa Allegra
Webcam Costa Atlantica
Webcam Costa Atlantica
Webcam Costa Classica
Webcam Costa Classica
Webcam Costa Concordia
Webcam Costa Concordia
Webcam Costa Europa
Webcam Costa Europa
Webcam Costa Fortuna
Webcam Costa Fortuna
Webcam Costa Magica
Webcam Costa Magica
Webcam Costa Marina
Webcam Costa Marina
Webcam Costa  Mediterranea
Webcam Costa Mediterranea
Webcam Costa Romantica
Webcam Costa Romantica
Webcam Costa Serena
Webcam Costa Serena
Webcam Costa Victoria
Webcam Costa Victoria
Webcam Costa Voyager
Webcam Costa Voyager

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