Function: _Search
Query: SELECT SQL_CALC_FOUND_ROWS
p.*,
cat.nome_it AS categoria_it,cat.nome_en AS categoria_en,
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,
e.prezzo AS prezzo,e.prezzo_offerta AS prezzo_offerta,e.qta AS qta,e.ID AS costoID
FROM ec_prodotti AS p
LEFT JOIN ec_prodotti_categorie AS c ON (p.codice=c.itemID)
LEFT JOIN categorie AS cat ON (c.categoriaID=cat.ID)
LEFT JOIN ec_prodotti_ecommerce AS e ON (p.codice=e.itemID)
LEFT JOIN ec_marche AS m ON (p.marcaID=m.ID)
LEFT JOIN geo_regioni AS r ON (m.regioneID=r.ID)
WHERE cat.ID= AND p.abilitato=1 AND e.prezzo>0.00 AND m.abilitato=1 AND p.nome_en!=''
GROUP BY p.nome_it ORDER BY p.nome_it ASC LIMIT 0, 12
Array
(
[] => You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND p.abilitato=1 AND e.prezzo>0.00 AND m.abilitato=1 AND p.nome_en!=''
' at line 13
)
Function: _Search
Query: SELECT SQL_CALC_FOUND_ROWS
p.*,
cat.nome_it AS categoria_it,cat.nome_en AS categoria_en,
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,
e.prezzo AS prezzo,e.prezzo_offerta AS prezzo_offerta,e.qta AS qta,e.ID AS costoID
FROM ec_prodotti AS p
LEFT JOIN ec_prodotti_categorie AS c ON (p.codice=c.itemID)
LEFT JOIN categorie AS cat ON (c.categoriaID=cat.ID)
LEFT JOIN ec_prodotti_ecommerce AS e ON (p.codice=e.itemID)
LEFT JOIN ec_marche AS m ON (p.marcaID=m.ID)
LEFT JOIN geo_regioni AS r ON (m.regioneID=r.ID)
WHERE cat.ID= AND p.abilitato=1 AND e.prezzo>0.00 AND m.abilitato=1 AND p.nome_en!='' AND p.nome_en!=''
GROUP BY p.nome_it ORDER BY p.nome_it ASC LIMIT 0, 12
Array
(
[] => You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND p.abilitato=1 AND e.prezzo>0.00 AND m.abilitato=1 AND p.nome_en!=''
' at line 13
[1] => You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND p.abilitato=1 AND e.prezzo>0.00 AND m.abilitato=1 AND p.nome_en!='' AND p.no' at line 13
)