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 - PRINCESS CRUISES
PRINCESS CRUISES
PRINCESS CRUISES PRINCESS CRUISES NAVI CON WEBCAM A BORDO
PRINCESS CRUISE SHIPS WITH A WEBCAM


Lista PRINCESS CRUISES
Webcam Caribbean Princess
Webcam Caribbean Princess
Webcam Coral Princess
Webcam Coral Princess
Webcam Crown Princess
Webcam Crown Princess
Webcam Dawn Princess
Webcam Dawn Princess
Webcam Diamond Princess
Webcam Diamond Princess
Webcam Golden Princess
Webcam Golden Princess
Webcam Grand Princess
Webcam Grand Princess
Webcam Island Princess
Webcam Island Princess
Webcam Pacific Princess
Webcam Pacific Princess
Webcam Royal Princess
Webcam Royal Princess
Webcam Sapphire Princess
Webcam Sapphire Princess
Webcam Sea Princess
Webcam Sea Princess
Webcam Star Princess
Webcam Star Princess
Webcam Sun Princess
Webcam Sun Princess
Webcam Tahitian Princess
Webcam Tahitian Princess

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