Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

what does this mean?


Recommended Posts

Can any one advise me what this error means and how to fix it? It is in Administration > Orders


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 '-20, 20' at line 1


select c.customers_firstname, c.customers_lastname, sum(op.products_quantity * op.final_price) as ordersum from customers c, orders_products op, orders o where c.customers_id = o.customers_id and o.orders_id = op.orders_id group by c.customers_firstname, c.customers_lastname order by ordersum DESC limit -20, 20



No external links here.  

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...