Our MySQL (version 5) database stores information in multiple tables, which are connected by foreign keys. We need to add advanced search features to our site, based on data in this database. To do this, we would need to write several MySQL SELECT queries, joining different tables and filtering according to the required parameters. We will supply the test data (from mysql dump). We expect to receive, not only fully functional and debugged queries, but also documentation in English, in text format, explaining each query. Also, part of the work should be recommendation as to what indexes need to be added to the database in order to speed up queries. Please don't bid yet. Contact us here and we'll send you a detailed description of the table structure and the queries that we need.
1) Complete and functional MySQL queries, running correctly on our test data.
2) Documentation, per query, explaining how it operates.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).