SELECT p.pid, p.filename, AVG(v.vote) as avgv, COUNT(v.vote) as avgc FROM wp_ngg_pictures p LEFT JOIN wp_nggv_votes v ON (p.pid = v.pid) ...
PHP SQL Query Optimization
by https://www.google.com/accounts/o8/id?id=AItOawmyRuor7Z0aC0QytK3lMrz5h5jH73-dECw,
December 13, 2011 21:03,
3 refactorings, tagged with speed, sql, optimization
This SQL query is currently...