[Request] MySQL Database Query

<p><strong>Q: What was the request about? </strong><br>Was having trouble getting head around some advanced MYSQL query needs.<br><br><strong>Q: How did you help with the request?</strong><br>I modified the queries to match what he needed and found a index flaw in the way the tables were indexed.<br><br><strong>Q: Any best practices &amp; key learnings you can share?</strong><br>Indexes are your friend. Make sure when you are using multiple filters on the same table that those tables have the proper index or you may be wasting much server resources.</p>