osCommerce Support Site  Online Catalog  Administration  
  Administration Support Site  |  Online Catalog  |  Administration  
Best Customer Orders-Total
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 '-0, Hacked by JaCKaL...' 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 -0, Hacked by JaCKaL...

[TEP STOP]

No. Customers Total Purchased