Exporting FooEvent Tickets

foo_tickets_export.sql

## THIS IS FOR EXPORTING TICKETS FROM YOUR FOO EVENT WOOCOMMERCE PLUGIN.
## I CREATED THIS BECAUSE I HAVE A DIFFERENT SYSTEM FOR USERS TO LOGIN TO AND
## I WOULD LIKE THE USERS TO BE ABLE TO USE THE SAME TICKET. IN THE NEW SYSTEM
## I REGENERATE THE QR BASED ON TICKET_ID.

SELECT wp00_posts.ID, wp00_posts.post_title, wp00_posts.post_type,
   max(case when (meta_key='WooCommerceEventsTicketID') then meta_value else NULL end) as 'Ticket_ID',
   max(case when (meta_key='WooCommerceEventsAttendeeName') then meta_value else NULL end) as 'First_Name',
   max(case when (meta_key='WooCommerceEventsAttendeeLastName') then meta_value else NULL end) as 'Last_Name',
   max(case when (meta_key='WooCommerceEventsAttendeeEmail') then meta_value else NULL end) as 'Email',
   max(case when (meta_key='WooCommerceEventsAttendeeTelephone') then meta_value else NULL end) as 'Phone_No',
   max(case when (meta_key='WooCommerceEventsAttendeeCompany') then meta_value else NULL end) as 'Company',
   max(case when (meta_key='WooCommerceEventsProductName') then meta_value else NULL end) as 'Ticket_Type'
FROM wp00_postmeta LEFT JOIN wp00_posts ON wp00_postmeta.post_id = wp00_posts.ID
   group by wp00_posts.ID
HAVING post_type = 'event_magic_tickets'