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,
s.nome AS stagione_nome,s.codice AS stagioneID,s.permalink as stagione_permalink,s.sconto as stagione_sconto,e.prezzo,e.prezzo_offerta,e.prezzo_outlet,e.in_offerta, MIN(e.prezzo) AS prezzo,e.codice AS taglia
FROM ec_prodotti AS p
LEFT JOIN ec_prodotti_categorie AS c ON (p.modello=c.itemID)
LEFT JOIN categorie AS cat ON (c.categoriaID=cat.ID)
LEFT JOIN ec_prodotti_ecommerce AS e ON (p.modello=e.itemID)
LEFT JOIN ec_stagioni AS s ON (p.stagioneID=s.codice)
WHERE c.categoriaID= AND e.prezzo!='' AND p.stagioneID='AI1617' AND p.abilitato=1
GROUP BY p.modello ORDER BY p.nome_it ASC LIMIT 0, 7
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 e.prezzo!='' AND p.stagioneID='AI1617' AND p.abilitato=1
' at line 11
)
Function: _SearchColors Query: SELECT SQL_CALC_FOUND_ROWS
cl.*
FROM colori AS cl
LEFT JOIN ec_prodotti_ecommerce AS e ON (cl.codice=e.coloreID)
LEFT JOIN ec_prodotti AS p ON (e.itemID=p.modello)
LEFT JOIN ec_stagioni AS s ON (p.stagioneID=s.codice)
LEFT JOIN ec_prodotti_categorie AS c ON (p.modello=c.itemID)
LEFT JOIN categorie AS cat ON (c.categoriaID=cat.ID)
WHERE p.stagioneID='AI1617' AND c.categoriaID= AND e.prezzo!=''
GROUP BY cl.codice ORDER BY cl.codice ASC
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 e.prezzo!='' AND p.stagioneID='AI1617' AND p.abilitato=1
' at line 11
[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 e.prezzo!=''
GROUP BY cl.codice ORDER BY cl.codice A' at line 9
)
Function: _SearchSize Query: SELECT SQL_CALC_FOUND_ROWS
e.*
FROM ec_prodotti_ecommerce AS e
LEFT JOIN ec_prodotti AS p ON (e.itemID=p.modello)
LEFT JOIN ec_stagioni AS s ON (p.stagioneID=s.codice)
LEFT JOIN ec_prodotti_categorie AS c ON (p.modello=c.itemID)
LEFT JOIN categorie AS cat ON (c.categoriaID=cat.ID)
WHERE p.stagioneID='AI1617' AND c.categoriaID= AND e.prezzo!='' AND p.abilitato=1
GROUP BY e.codice ORDER BY e.codice ASC
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 e.prezzo!='' AND p.stagioneID='AI1617' AND p.abilitato=1
' at line 11
[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 e.prezzo!=''
GROUP BY cl.codice ORDER BY cl.codice A' at line 9
[2] => 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 e.prezzo!='' AND p.abilitato=1
GROUP BY e.codice ORD' at line 8
)