|
| SP003 - Spilla Rose | € 62,00 |
| 
| SP004 - Spilla Fiore | € 62,00 |
| 
| SP005 - Spilla Rana | € 47,00 |
| 
| SP006 - Spilla Geco | € 23,00 |
| 
| SP007 - Spilla Farfalla | € 45,00 |
| 
| SP008 - Spilla Gatto | € 30,00 |
| 
| SP009 - Spilla Classic | € 26,00 |
| 
| SP010 - Spilla Scolpito Fiore | € 162,00 |
| 
| SP011 - Spilla Scolpito Donna 01 | € 94,00 |
| 
| SP012 - Spilla Scolpito Donna 02 | € 62,00 |
|
|
|
|
|
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() | | |
