Meta: TalkFavorites.me is a Q&A site focused on helping you find the best stuff in your neighborhood.
MySQL Queries
[0.00026178359985352] Connecting to MySQL server
[0.00050210952758789] SELECT * FROM countries ORDER BY country_name ASC
[0.0031650066375732] SELECT * FROM locations l LEFT JOIN states s ON s.state_id = l.state_id LEFT JOIN countries c ON c.country_id = s.country_id WHERE l.status IN ('new','pending','validated') AND l.longitude BETWEEN -0.3 AND 0.3 AND l.latitude BETWEEN -0.3 AND 0.3