Home Main Menu Home Our Products Recipes FAQ Photo Gallery Links Our Products Crab Fish Fillets Salmon BBQ Local Market Shellfish Gift Ideas SmokedSalmon Seafood Club Welcome back to Northwestcatch!   After a bit of a hiatus I am excited to annouce that "coming soon" Northwestcatch.com will be online and taking orders again. Thank you to all my customers that have stayed in touch with me and I look forward to sending the best in Northwest Seafood again..Stay tuned! Keith Paddock-Northwestcatch.com Read more... [ Back ] Polls What is your favorite seafood? Shrimp Crab Oysters Scallops Clams Fish Other    Latest News Health benefits from eating wild seafood Omega 3's and your health Welcome back to Northwestcatch! ALASKA HALIBUT THE WORLD'S PREMIUM WHITEFISH Dungeness Crab FINEST TASTING IN THE WORLD

Shipping Info  |  Privacy Notice  |  Conditions of Use  |  Contact Us

Copyright © 2004-2007 Fisherman Direct Seafoods Website created by BusinessWebSpace.com

1
SELECT id, link
 FROM mos_menu
 WHERE menutype='mainmenu' AND published='1'
 ORDER BY parent, ordering LIMIT 1
2
SELECT template FROM mos_templates_menu WHERE client_id='0' AND menuid='0'
3
SELECT template FROM mos_templates_menu WHERE client_id='0' AND menuid='1' LIMIT 1
4
DELETE FROM mos_session
WHERE (time < 1246577790)
5
SELECT * FROM mos_session WHERE session_id='075cbc2d8b03eb8069dda57ad709d559'
6
SELECT session_id FROM mos_session WHERE session_id=MD5('b919a38311797632e1422d7c1d26d77a')
7
INSERT INTO mos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( '79622a612dc92b5e0bb979f966874ecb','1246578690','','0','1' )
8
SELECT count(*) FROM mos_stats_agents WHERE agent='Unknown' AND type='0'
9
UPDATE mos_stats_agents SET hits=(hits+1) WHERE agent='Unknown' AND type='0'
10
SELECT count(*) FROM mos_stats_agents WHERE agent='Unknown' AND type='1'
11
UPDATE mos_stats_agents SET hits=(hits+1) WHERE agent='Unknown' AND type='1'
12
SELECT count(*) FROM mos_stats_agents WHERE agent='Unknown' AND type='2'
13
UPDATE mos_stats_agents SET hits=(hits+1) WHERE agent='Unknown' AND type='2'
14
SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup
FROM mos_mambots
WHERE published >= 1 AND access <= 0 AND folder='editors'
ORDER BY ordering
15
SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup
FROM mos_mambots
WHERE published >= 1 AND access <= 0 AND folder='editors-xtd'
ORDER BY ordering
16
SELECT access FROM mos_menu WHERE id='1'
17
SELECT * FROM mos_menu WHERE id='1'
18
SELECT a.*, ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count, u.name AS author, u.usertype, s.name AS section, cc.name AS category, g.name AS groups
 FROM mos_content AS a
 INNER JOIN mos_content_frontpage AS f ON f.content_id = a.id
 INNER JOIN mos_categories AS cc ON cc.id = a.catid
 INNER JOIN mos_sections AS s ON s.id = a.sectionid
 LEFT JOIN mos_users AS u ON u.id = a.created_by
 LEFT JOIN mos_content_rating AS v ON a.id = v.content_id
 LEFT JOIN mos_groups AS g ON a.access = g.id
 WHERE a.state = '1'
 AND a.access <= '0'
 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2009-07-02 19:51:30'  )
 AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2009-07-02 19:51:30' )
 ORDER BY f.ordering
19
SELECT COUNT( m.id )
 FROM mos_content AS i
 LEFT JOIN mos_sections AS s ON i.sectionid=s.id
 LEFT JOIN mos_menu AS m ON m.componentid=s.id 
 WHERE m.type='content_blog_section'
 AND m.published='1'
20
SELECT COUNT( m.id )
 FROM mos_content AS i
 LEFT JOIN mos_categories AS c ON i.catid=c.id
 LEFT JOIN mos_menu AS m ON m.componentid=c.id 
 WHERE m.type='content_blog_category'
  AND m.published='1'
21
SELECT COUNT( id )
 FROM mos_menu 
 WHERE type='content_blog_section'
 AND published='1'
 AND componentid=0
22
SELECT folder, element, published, CONCAT_WS('/',folder,element) AS lookup
FROM mos_mambots
WHERE published >= 1 AND access <= 0 AND folder='content'
ORDER BY ordering
23
SELECT id FROM mos_mambots WHERE element = 'mosemailcloak' AND folder = 'content'
24
SELECT * FROM mos_mambots WHERE id='18'
25
SELECT m.id 
FROM mos_content AS i
LEFT JOIN mos_sections AS s ON i.sectionid=s.id
LEFT JOIN mos_menu AS m ON m.componentid=s.id 
WHERE m.type='content_section' AND m.published='1' AND i.id=43
26
SELECT a.id
 FROM mos_components AS a
 WHERE a.name = 'Syndicate'
27
SELECT * FROM mos_components WHERE id='17'
28
SELECT id, title, module, position, content, showtitle, params
FROM mos_modules AS m, mos_modules_menu AS mm
WHERE m.published='1' AND m.access <= '0' AND m.client_id='0'
AND mm.moduleid=m.id
AND (mm.menuid = '1' OR mm.menuid = '0')
ORDER BY ordering
29
SELECT *
FROM mos_menu
WHERE menutype='mainmenu' AND published='1'
ORDER BY parent, ordering LIMIT 1
30
SELECT id, name, link, parent, type
FROM mos_menu
WHERE published='1'
ORDER BY parent, ordering
31
SELECT m.* FROM mos_menu AS m
WHERE menutype='mainmenu' AND published='1' AND access <= '0'
ORDER BY parent,ordering
32
SELECT m.* FROM mos_menu AS m
WHERE menutype='othermenu' AND published='1' AND access <= '0'
ORDER BY parent,ordering
33
SELECT p.id, p.title
FROM mos_poll_menu AS pm, mos_polls AS p
WHERE (pm.menuid='1' OR pm.menuid='0') AND p.id=pm.pollid
AND p.published=1
34
SELECT id, text FROM mos_poll_data
WHERE pollid='14' AND text <> ''
ORDER BY id
35
SELECT a.id, a.title, a.sectionid, a.catid
 FROM mos_content AS a
 LEFT JOIN mos_content_frontpage AS f ON f.content_id = a.id
 WHERE ( a.state = '1' AND a.checked_out = '0' AND a.sectionid > '0' )
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2009-07-02 19:51:30' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2009-07-02 19:51:30' )
 AND a.access <= '0'
 ORDER BY a.created DESC LIMIT 5
36
SELECT COUNT( m.id )
 FROM mos_content AS i
 LEFT JOIN mos_sections AS s ON i.sectionid=s.id
 LEFT JOIN mos_menu AS m ON m.componentid=s.id 
 WHERE m.type='content_blog_section'
 AND m.published='1'
37
SELECT COUNT( m.id )
 FROM mos_content AS i
 LEFT JOIN mos_categories AS c ON i.catid=c.id
 LEFT JOIN mos_menu AS m ON m.componentid=c.id 
 WHERE m.type='content_blog_category'
  AND m.published='1'
38
SELECT COUNT( id )
 FROM mos_menu 
 WHERE type='content_blog_section'
 AND published='1'
 AND componentid=0
39
SELECT m.id 
FROM mos_content AS i
LEFT JOIN mos_sections AS s ON i.sectionid=s.id
LEFT JOIN mos_menu AS m ON m.componentid=s.id 
WHERE m.type='content_section' AND m.published='1' AND i.id=46
40
SELECT m.id 
FROM mos_content AS i
LEFT JOIN mos_sections AS s ON i.sectionid=s.id
LEFT JOIN mos_menu AS m ON m.componentid=s.id 
WHERE m.type='content_section' AND m.published='1' AND i.id=45
41
SELECT m.id 
FROM mos_content AS i
LEFT JOIN mos_sections AS s ON i.sectionid=s.id
LEFT JOIN mos_menu AS m ON m.componentid=s.id 
WHERE m.type='content_section' AND m.published='1' AND i.id=43
42
SELECT m.id 
FROM mos_content AS i
LEFT JOIN mos_sections AS s ON i.sectionid=s.id
LEFT JOIN mos_menu AS m ON m.componentid=s.id 
WHERE m.type='content_section' AND m.published='1' AND i.id=40
43
SELECT m.id 
FROM mos_content AS i
LEFT JOIN mos_sections AS s ON i.sectionid=s.id
LEFT JOIN mos_menu AS m ON m.componentid=s.id 
WHERE m.type='content_section' AND m.published='1' AND i.id=39