write/edit a Solr query

Avg Bid (USD)
Project Budget (USD)
$30 - $250

Project Description:
the following query returns an incorrect number of records:

i had hoped this query would limit the records returned to the field value (end_date) range specified bu additional records are being returned. about 27000 records are being returned when it s expected that less then half that many should be returned. I can count the records returned by pressing control plus F at the same time then entering 'cu' in the top right -that will give you the total records. I am looking for someone who can edit this query to obtain the desired result.
An even better result may be obtained if you are able to search across 2 document types joining on a common field. the 2 document types are "ticket' and "event" the filter field is event_date and the common field joining the two document types is event_id.If you can set up a 1 day event_date range and return substantially less then 27,000 records with no records outside that date range then that would be great.

a good starting point for the documentation for the solr to be searched is located at:


All work is "work for hire" and a non disclosure would need to be signed. This is part of a larger project and could lead to your inclusion on the larger project.

Ideally i am looking for a ticket document using an event_date

Additional Project Description:
05/08/2013 at 23:13 WIT
updated query requirements-disregard above:
current query:

need to edit above query so that for any results returned where2 id's are identical only the max datelastindexed will be returned.

05/09/2013 at 4:07 WIT
want to query across 2 document types (ticket and event) on a common field (event_id) so that fields from both document types can be returned filtered by an event_date range -this is now the top goal of the project if it is technically feasible

Skills required:
Apache Solr
About the employer:
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.