Function: _SearchEcommerce
Query: SELECT SQL_CALC_FOUND_ROWS p.*,MIN(p.prezzo) FROM ec_prodotti_ecommerce AS p WHERE p.abilitato=1 AND p.itemID= Group by p.ID ORDER BY p.prezzo ASC
Array
(
    [] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Group by p.ID ORDER BY p.prezzo ASC' at line 6
)
| Vasco Caffè - Caffè

Prodotto aggiunto al carrello

Benvenuto su Vasco Caffè

Iscriviti alla newsletter e ricevi un buono sconto del 5% valido per il tuo primo acquisto

Acconsento al trattamento dei miei dati per le finalitá di cui ai punti a) e b) dell'informativa

x
Spedizione gratuita
per ordini superiori a 69,00

Prodotto al momento non disponibile

Function: _Search
Query: SELECT SQL_CALC_FOUND_ROWS p.*, cat.nome_it AS categoria_it,cat.nome_en AS categoria_en,cat.ID as categoriaID, cat.permalink_it AS categoria_permalink_it,cat.permalink_en AS categoria_permalink_en,cat.nome_it AS categoria_nome_it,cat.ID AS categoria_ID, m.nome AS marca_nome,m.permalink AS marca_permalink,m.abilitato as marca_abilitato, MIN(e.prezzo) AS prezzo,e.prezzo_offerta AS prezzo_offerta,e.qta AS qta,e.ID AS costoID,e.descrizione_it as prezzo_descrizione_it FROM ec_prodotti AS p JOIN ec_prodotti_categorie AS c ON (p.ID=c.itemID) JOIN categorie AS cat ON (c.categoriaID=cat.ID) JOIN ec_prodotti_ecommerce AS e ON (p.ID=e.itemID) JOIN ec_marche AS m ON (p.marcaID=m.ID) WHERE m.ID= AND cat.ID=7 AND p.abilitato=1 AND p.ID!= GROUP BY p.ID ORDER BY p.nome_it ASC LIMIT 0, 4
Array
(
    [] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Group by p.ID ORDER BY p.prezzo ASC' at line 6
    [1] => You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND cat.ID=7 AND p.abilitato=1 AND p.ID!=
                        GROUP BY p.ID ' at line 12
)

Correlati