Immagine
Codice prodotto
Dettagli
Prezzo
Stock
Quantità
SQL ERROR:SQLSTATE[42000]: Syntax error or access violation: 1064 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 '' at line 13
select p.products_id, p.products_price,
p.products_tax_class_id, p.products_image,p.products_image_med, p.products_image_lrg,
pd.products_name, pd.products_description, p.vendors_id,p.products_tech_specs,
p.products_model, p.products_matching ,products_att_1,products_att_2,products_att_hex,
DATEDIFF(CURDATE(),products_date_added) as days_new
from products p, products_description pd
where p.products_parent_id = 0
and p.products_status = '1'
and p.products_id = pd.products_id
and pd.language_id = 1
and (p.products_group_access like '%,G,%' or p.products_group_access like 'G,%' or p.products_group_access like '%,G' or p.products_group_access='G')
order by