The famous nocturnal Hex hatch of the Midwest (and a few other lucky locations) stirs to the surface mythically large brown trout that only touch streamers for the rest of the year.
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.*,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 WHERE i.shown_trout=0 && i.shown_fish=0 && private=0 && i.datetaken='' ORDER BY i.stat_rating DESC
SELECT i.*,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 WHERE i.shown_trout=0 && i.datetaken='' GROUP BY i.imageid ORDER BY i.stat_rating DESC
SELECT i.*,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 rel_taxa_extaxim r2 ON r2.imageid=i.imageid WHERE i.datetaken='' GROUP BY i.imageid ORDER BY i.stat_rating DESC
SELECT t.parentid AS parenttaxonid,
t.parentname AS parenttaxonname,
t.name AS taxonname,
t.level AS taxonlevel,
t.taxonid,
s.*,
i.*,
l.secret AS locationSecret,
l.name AS locationName,
l.state AS locationState,
s.water AS location
FROM specimens s
LEFT JOIN im_regspec i ON s.stat_bestimage = i.imageid
INNER JOIN taxa t ON t.taxonid = s.belongs_to
LEFT JOIN locations l ON l.id = s.locationid
WHERE s.datecollected=''
ORDER BY s.author_is_troutnut DESC, s.quality_tier DESC, s.stat_bestimage DESC # assume newer images are better
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
SELECT p.postid,p.author,p.body,p.postdate,u.location,u.signature,u.numposts,u.priv_admin,u.priv_subadmin,u.priv_mod,u.banned,i.imageid,i.username,i.full_width,i.full_height,i.dims,i.has_thumbs,GROUP_CONCAT(rl.username SEPARATOR ',') AS likes FROM forum_posts p INNER JOIN users u ON u.username=p.author LEFT JOIN im_user_profile i ON u.username=i.username LEFT JOIN forum_rel_liked rl ON p.postid=rl.postid WHERE p.topicid= GROUP BY p.postid ORDER BY p.postdate LIMIT 0,20
SELECT * FROM blogposts WHERE live=1 && DATE(timeposted)='' ORDER BY id
SELECT i.*,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 WHERE i.shown_trout=0 && i.shown_fish=0 && private=0 && i.datetaken='' ORDER BY i.stat_rating DESC
SELECT i.*,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 WHERE i.shown_trout=0 && i.datetaken='' GROUP BY i.imageid ORDER BY i.stat_rating DESC
SELECT i.*,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 rel_taxa_extaxim r2 ON r2.imageid=i.imageid WHERE i.datetaken='' GROUP BY i.imageid ORDER BY i.stat_rating DESC
SELECT t.parentid AS parenttaxonid,
t.parentname AS parenttaxonname,
t.name AS taxonname,
t.level AS taxonlevel,
t.taxonid,
s.*,
i.*,
l.secret AS locationSecret,
l.name AS locationName,
l.state AS locationState,
s.water AS location
FROM specimens s
LEFT JOIN im_regspec i ON s.stat_bestimage = i.imageid
INNER JOIN taxa t ON t.taxonid = s.belongs_to
LEFT JOIN locations l ON l.id = s.locationid
WHERE s.datecollected=''
ORDER BY s.author_is_troutnut DESC, s.quality_tier DESC, s.stat_bestimage DESC # assume newer images are better
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
SELECT CONCAT_WS(' ',t.title,t.title,t.title,GROUP_CONCAT(p.body SEPARATOR ' ')) AS alltext FROM forum_posts p INNER JOIN forum_topics t ON p.topicid=t.topicid WHERE t.topicid=