mysql fixes
I had a query something like this returning many duplicate rows:
SELECT entries.permalink, video.id, ... FROM entries, entries2video, video WHERE entries.feedid = '1' AND entries.id = entries2video.entryid AND video.id = entries2video.videoid ORDER BY id DESC LIMIT
It turns out the fix was pretty easy: instead of "order by id", make it "order by entries.id" (which makes more sense). I am not sure why, but this fixed the problem of returning duplicate rows.
# May 28, 2006