SELECT orders_id,
customers_id, 
customers_name, 
customers_company, 
customers_street_address, 
customers_suburb, 
customers_city, 
customers_postcode, 
customers_state, 
customers_country, 
customers_telephone, 
customers_email_address, 
customers_address_format_id, 
delivery_name, 
delivery_company, 
delivery_street_address, 
delivery_suburb, 
delivery_city, 
delivery_postcode, 
delivery_state, 
delivery_country, 
delivery_address_format_id, 
billing_name, 
billing_company, 
billing_street_address, 
billing_suburb, 
billing_city, 
billing_postcode, 
billing_state, 
billing_country, 
billing_address_format_id, 
payment_method, 
cc_type, 
cc_owner, 
cc_number, 
cc_expires, 
last_modified, 
date_purchased, 
orders_status, 
orders_date_finished, 
currency, 
currency_value
FROM <@PREFIX>orders
where ((date_purchased >= %s and last_modified is null) or last_modified >= %s ) and orders_status in (%s)
and ((date_purchased <= %s and last_modified is null) or last_modified <= %s )
order by date_purchased
