|
OFFERTE SPECIALI:
PA001 - Parure Fascia Colore € 140 | 
PA002 - Parure Fascia Cognac € 140 | 
RS007 - Madonna di Czestochova € 270 | 
RS010 - OFFERTA -50% - Madonna di Vladimir Bilaminato ARGENTO € 85 | 
RS011 - OFFERTA -50% - Madonna di Kazan Bilaminato ARGENTO € 45 |
|
|
|
|
IN EVIDENZA:
Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'artepolacca.foto.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SELECT P.id AS idProd, F.id, P.nome, P.descrizione, F.titolo FROM prodotti AS P LEFT JOIN (SELECT id, prodottoId, titolo FROM foto GROUP BY prodottoId) AS F ON P.id = F.prodottoId WHERE P.evidenza = 1 AND fuoriCatalogo = 0 ORDER BY RAND() | | |
