Meta: TalkFavorites.me is a Q&A site focused on helping you find the best stuff in your neighborhood.
MySQL Queries
[0.00036787986755371] Connecting to MySQL server
[0.00065994262695312] SELECT * FROM countries ORDER BY country_name ASC
[0.00012612342834473] 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
