annotate gpp/templates/core/mp3comp_block.html @ 388:c3231af55778

For #191; r410 is wrong: it is returning the wrong posts. Rework. MySQL is not using an index on our query, and it is taking 10+ seconds. Replace this slow query with a loop that loops over the public forums, then sorts and returns the posts.
author Brian Neal <bgneal@gmail.com>
date Sat, 19 Mar 2011 05:03:51 +0000
parents 8e3f252e4fbb
children 06baec10cd20
rev   line source
bgneal@357 1 {% extends 'side_block.html' %}
bgneal@357 2 {% block block_title %}SG101 MP3 Comps{% endblock %}
bgneal@357 3 {% block block_content %}
bgneal@357 4 <a target="_blank" href="http://www.archive.org/details/SG101-2005_Mp3_Comp">2005</a>
bgneal@357 5 <a target="_blank" href="http://www.archive.org/details/SG101_2006_MP3_Compilation">2006</a>
bgneal@357 6 <a target="_blank" href="http://www.archive.org/details/SG1012007MP3">2007</a>
bgneal@357 7 <a target="_blank" href="http://www.archive.org/details/SurfGuitar101.com_2008_MP3_Compilation">2008</a>
bgneal@357 8 <a target="_blank" href="http://www.archive.org/details/Surfguitar101.com2009Mp3Compilation">2009</a>
bgneal@357 9 <a target="_blank" href="http://www.archive.org/details/Surfguitar101.com2010Mp3Compilation">2010</a>
bgneal@357 10 {% endblock %}