Mysql : fetch all sales details for specific manufacture

Hello,

I have a client who is selling tickets via the zencart system. He wants to have a page where he can view all the tickets sold for a certain gig. gigs are grouped by manufacture.

e.g.
all day ticket - £22 - manufacture = event Name
Weekend ticket - £42 - manufacture = even name

What i need to do is drag from the database the sales info secific to the event

e.g select * from database WHERE manufacture = event name AND date = last month

Then i need to display in table format
product id
transaction id
customer name
items ordered + item totals
customer address
order total

Does anyone know if any modules come close to displaying something like this that i can tweak? Failing that I may have to try and code one up from scratch (but rather not!)

Ive installed orders export and it seems to have alsmost what i need.

I having trouble editing the following

$filelayout_sql = "SELECT

zo.orders_id as v_orders_id,
customers_id as v_customers_id,
customers_name as v_customers_name,
customers_company as v_customers_company,
customers_street_address as v_customers_street_address,
customers_suburb as v_customers_suburb,
customers_city as v_customers_city,
customers_postcode as v_customers_postcode,
customers_country as v_customers_country,
customers_telephone as v_customers_telephone,
customers_email_address as v_customers_email_address,
date_purchased as v_date_purchased,
orders_status_name as v_orders_status_name,
products_model as v_products_model,
products_name as v_products_name,
products_options as v_products_options,
products_options_values as v_products_options_values
FROM ".TABLE_ORDERS_PRODUCTS." zop LEFT JOIN ".TABLE_ORDERS_PRODUCTS_ATTRIBUTES." opa
ON(zop.orders_products_id = opa.orders_products_id), ".TABLE_ORDERS." zo, ".TABLE_ORDERS_STATUS." zos
WHERE zo.orders_id = zop.orders_id
AND zo.orders_status = zos.orders_status_id
";

the above code works fine but what i want to add is

('zo.orders_id','customers_id') as barcode_id,

but this doesnt work, any ideas?

You seem to want to be combine those two fields. Is is a simple concatenation? If so, adding

CONCAT(zo.orders_id,customers_id) as barcode_id,
```should work.

thanks that worked a treat, now i need to somehow limit it so it only fetches orders which match the manufacture ID e.g. Select * from table where manufacture_id = 2