select so.order_id, convert_tz(o.created_at, '+0:00', '+7:00') as created_at,
CONCAT(sab.lastname," ", sab.firstname) as customer_name,
sab.telephone AS customer_phone,
CONCAT(u.last_name," ", u.first_name) as cashier
from fahasa_suborder so
join fhs_sales_flat_order o on o.increment_id = so.order_id
JOIN fhs_sales_flat_order_address sab      ON o.billing_address_id = sab.entity_id
left join fahasa_bookstore_log l on l.order_id = so.order_id and l.action = 'bookfairBookStoreTakeOrder'
left join fahasa_bookstore_user u on u.email = l.userId
where so.status in ('assigned','confirmed')
and so.bookstore_id = 41
and so.customer_pickup = 1
group by so.order_id;