Updates from June 17, 2005

SELECT boardclass,contentid,title,sticky,author,numposts,firstpostdate,featured,unix_timestamp(lastpostdate) as dateposted FROM forum_topics WHERE topicid=

SELECT * FROM blogposts WHERE live=1 && DATE(timeposted)='' ORDER BY id

SELECT i.*,b.backgroundid,l.secret AS locationSecret,l.name AS locationName,l.state AS locationState FROM im_other i LEFT JOIN locations l ON l.id=i.locationid LEFT JOIN backgrounds b ON b.contentid=i.imageid && b.contenttype='im_other' WHERE i.shown_trout=0 && i.shown_fish=0  && private=0  && i.datetaken='' ORDER BY i.stat_rating DESC

SELECT i.*,b.backgroundid,GROUP_CONCAT(r2.taxonid SEPARATOR ',') AS taxonids,l.secret AS locationSecret,l.name AS locationName,l.state AS locationState FROM im_uwphoto i LEFT JOIN locations l ON l.id=i.locationid LEFT JOIN rel_taxa_uwphoto r2 ON i.imageid=r2.imageid LEFT JOIN backgrounds b ON b.contentid=i.imageid && b.contenttype='im_uwphoto' WHERE i.shown_trout=0 && i.datetaken=''  GROUP BY i.imageid ORDER BY i.stat_rating DESC

SELECT i.*,b.backgroundid,GROUP_CONCAT(r2.taxonid SEPARATOR ',') AS taxonids,l.secret AS locationSecret,l.name AS locationName,l.state AS locationState FROM im_extax i LEFT JOIN locations l ON l.id=i.locationid LEFT JOIN backgrounds b ON b.contentid=i.imageid && b.contenttype='im_extax' LEFT JOIN rel_taxa_extaxim r2 ON r2.imageid=i.imageid WHERE i.datetaken=''  GROUP BY i.imageid ORDER BY i.stat_rating DESC

SELECT s.*, t.taxonid, t.parentid AS parenttaxonid,t.name AS taxonname,t.level AS taxonlevel,p.name AS parenttaxonname, i.*,l.secret AS locationSecret,l.name AS locationName,l.state AS locationState FROM specimens s INNER JOIN taxa t ON t.taxonid=s.belongs_to INNER JOIN taxa p ON p.taxonid=t.parentid LEFT JOIN im_regspec i ON s.stat_bestimage=i.imageid LEFT JOIN locations l ON l.id=s.locationid WHERE s.datecollected=''  ORDER BY s.stat_rating DESC

SELECT v.*,GROUP_CONCAT(r.contentid SEPARATOR ',') AS contentids,GROUP_CONCAT(r.contenttype SEPARATOR ',') AS contenttypes,GROUP_CONCAT(s.belongs_to SEPARATOR ',') AS taxonids,GROUP_CONCAT(s.stage SEPARATOR ',') AS stages, l.secret AS locationSecret,l.name AS locationName,l.state AS locationState FROM videos v LEFT JOIN rel_videos r ON v.videoid=r.videoid LEFT JOIN specimens s ON r.contentid=s.specimenid LEFT JOIN locations l ON l.id=v.locationid WHERE v.dateshot=''  GROUP BY v.videoid