View Single Post
Old 09-03-2018, 02:22 AM
  qualiteam's Avatar 
qualiteam qualiteam is offline

Join Date: Dec 2010
Posts: 6,373

Default Re: Search for Order by IP Address

It should be something like this.

select xcart_orders.orderid from xcart_orders left join xcart_order_extras on xcart_orders.orderid = xcart_order_extras.orderid where xcart_order_extras.khash = 'ip' and xcart_order_extras.value = '';
Alex Solovev,


User manual Video tutorials X-Cart FAQ

You are welcome to press "Thanks" button
if you find this post useful

Click here to learn how to apply patches

X-Cart Extensions
Reply With Quote