SELECT events.*, cont_authors.author_name, places_places.place_name FROM events LEFT JOIN places_places ON events.place_id = places_places.id LEFT JOIN places_zones ON places_places.zone_id=places_zones.id LEFT JOIN cont_authors ON events.author_id = cont_authors.id INNER JOIN events_events_categories AS cie ON cie.event_id = events.id WHERE (event_date BETWEEN '2012-05-25' and '2013-05-25') and ( (events.category_id in ('84')) OR (cie.category_id = '84' )) AND events.approved='1' GROUP BY id ORDER BY events.event_date asc, places_places.place_name asc, events.featured desc, events.priority desc, events.event_name asc