Salmonflies
Pteronarcys californica
The giant Salmonflies of the Western mountains are legendary for their proclivity to elicit consistent dry-fly action and ferocious strikes.
Featured on the forum
Troutnut is a project started in 2003 by salmonid ecologist Jason "Troutnut" Neuswanger to help anglers and
fly tyers unabashedly embrace the entomological side of the sport. Learn more about Troutnut or
support the project for an enhanced experience here.
Updates from June 16, 2005
Updates from June 16, 2005
Database Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Generated by query:
SELECT boardclass,contentid,title,sticky,author,numposts,firstpostdate,featured,unix_timestamp(lastpostdate) as dateposted FROM forum_topics WHERE topicid=Backtrace:
getTopicData <— __construct <— __construct <— initPageObjects
Database Error: Incorrect DATE value: ''
Generated by query:
SELECT * FROM blogposts WHERE live=1 && DATE(timeposted)='' ORDER BY idBacktrace:
__construct <— __construct <— initPageObjects
Database Error: Incorrect DATE value: ''
Generated by query:
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 DESCBacktrace:
__construct <— __construct <— initPageObjects
Database Error: Incorrect DATE value: ''
Generated by query:
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 DESCBacktrace:
__construct <— __construct <— initPageObjects
Database Error: Incorrect DATE value: ''
Generated by query:
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 DESCBacktrace:
__construct <— __construct <— initPageObjects
Database Error: Incorrect DATE value: ''
Generated by query:
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 betterBacktrace:
__construct <— __construct <— initPageObjects
Database Error: Incorrect DATE value: ''
Generated by query:
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.videoidBacktrace:
__construct <— __construct <— initPageObjects
Database Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY p.postid ORDER BY p.postdate LIMIT 0,20' at line 1
Generated by query:
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,20Backtrace:
getFullHTML <— printPageBody <— cc_printPageFromTemplate
Database Error: Incorrect DATE value: ''
Generated by query:
SELECT * FROM blogposts WHERE live=1 && DATE(timeposted)='' ORDER BY idBacktrace:
__construct <— getPreFullHTML <— getFullHTML <— printPageBody <— cc_printPageFromTemplate
Database Error: Incorrect DATE value: ''
Generated by query:
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 DESCBacktrace:
__construct <— getPreFullHTML <— getFullHTML <— printPageBody <— cc_printPageFromTemplate
Database Error: Incorrect DATE value: ''
Generated by query:
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 DESCBacktrace:
__construct <— getPreFullHTML <— getFullHTML <— printPageBody <— cc_printPageFromTemplate
Database Error: Incorrect DATE value: ''
Generated by query:
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 DESCBacktrace:
__construct <— getPreFullHTML <— getFullHTML <— printPageBody <— cc_printPageFromTemplate
Database Error: Incorrect DATE value: ''
Generated by query:
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 betterBacktrace:
__construct <— getPreFullHTML <— getFullHTML <— printPageBody <— cc_printPageFromTemplate
Database Error: Incorrect DATE value: ''
Generated by query:
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.videoidBacktrace:
__construct <— getPreFullHTML <— getFullHTML <— printPageBody <— cc_printPageFromTemplate
Database Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Generated by query:
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=Backtrace:
getKeywords <— getRelatedTopicsDataFromDatabase <— getRelatedTopicsHTML <— getFullHTML <— printPageBody <— cc_printPageFromTemplate