select e.event_id, e.event_name, e.event_notes, e.event_image, e.event_locations, e.price_desc, e.event_to_be_sold_as, d.id as date_id, d.seats_left, d.event_time_desc, d.event_short_desc, d.event_date, d.event_time_zone, d.start_date,d.end_date,l.location_id,l.location_name,l.location_address from `sltix_event` e INNER JOIN `sltix_dates` d ON e.event_id = d.event_id INNER JOIN sltix_location l on l.location_id = d.location_id where e.status = 'Active' and d.status = 'Active' and e.event_id='22' and d.is_deleted = '0' and d.end_date > NOW() order by d.event_date asc SugarloafTix

©2022 SugarloafTix.Com. All rights reserved. | Designed by Miles Image for Stand-Up Global