Featured Clubs

•Image• Fayetteville Kayak Anglers
••Tuesday•, 26 •November• 2013•
Chris Reed got in touch recently from North Carolina, USA. A southern state, the boys in NC can fish all year long. In late Fall, looks like Largemouth Bass is top on the menu. From the pictures Reed sent, these guys really get to enjoy a... •Read more...•
•Image• YakFishing Addicts Club
••Saturday•, 05 •March• 2011•
Yakfishing Addicts Club was started to promote kayak fishing. the club trys to provide a way to help the sport. Colorado's kayak fishing community is almost non existent and finding kayak fishing clubs out here is impossible. I have... •Read more...•
•Image• Rochester Institute of Technology (RIT) Bass Club in New York
••Saturday•, 24 •October• 2009•
Kayak angling as a competitive collegiate sport is becoming an increasingly popular idea among university fishing teams.  Campus fishing clubs in New York, Florida, Texas and other states have discovered the value of kayaks as a means for... •Read more...•
•Image• Lafayette Kayak Fishing Club
••Friday•, 23 •October• 2009•
The Lafayette Kayak Fishing Club (42 members and consistently growing as of April 16, 2009) is a unique club of men, women and children anglers who fish fresh and saltwater for redfish, trout, flounder, bass, sac-a-lait (crappie). As you... •Read more...•
•Image• Michigan Kayak Fishing
••Thursday•, 22 •October• 2009•
This month we learn about the people who make up Michigan Kayak Fishing. We'll also learn about their unique fishery and what it means to be a kayak fisherman in this area. It all started as two good fishing buds hit the shorelines of... •Read more...•
•Image• Hardcore Kayak Fishing Team
••Tuesday•, 20 •October• 2009•
Hardcore Kayak Fishing Team was born almost 10yrs ago. Some of us have been yak fishing longer but the name comes from a very early and cold winter launch on the Catawba river near Charlotte N.C. It was just us and a lone, die-hard striper... •Read more...•
•Image• Australia's East Coast Kayak Fishing Club
••Monday•, 19 •October• 2009•
Australia's East Coast Kayak Fishing Club provides information for members and guests on the sport of Kayak Fishing, Fishing Trips, Social Functions and events. Kayak Fishing is an exciting, exhilarating, and challenging •Read more...•
•Image• Bayou Coast Kayak Fishing Club
••Monday•, 19 •October• 2009•
With forum names like Yak-a-Lou, Kreolekayakr and Yakfever, there is little doubt that this bunch of yakaholics is serious about kayak fishing. Coastal Louisiana and Mississippi provide virtually unlimited kayak fishing opportunities and,... •Read more...•
•Image• Paddling Anglers in Canoes and Kayaks - PACK History
••Friday•, 16 •October• 2009•
Paddling Anglers in Canoes and Kayaks formed in March 1998 with about ten enthusiasts looking to share the fun of Gulf Coast fishing from small boats.  Meetings have been held monthly since then, first at Pecos Jack's Wilderness... •Read more...•
•Image• Wolfpack, Kayak Fishing Club
••Tuesday•, 13 •October• 2009•
Meet the Wolfpack, a kayak fishing club where the only rule is "there are no rules".The Pack meets and fishes the NY/NJ area and they believe in safety in numbers and welcome others to fish with them.     •Read more...•
•Image• The Kayak Fishing Association of New York
••Monday•, 12 •October• 2009•
The Kayak Fishing Association of New York was founded in May of 2007 to further the sport of kayak fishing with a keen eye on conservation and to promote safe, effective, and environmentally sound recreational kayak fishing practices. The... •Read more...•
•Image• Georgia Kayak Fishing Club
••Friday•, 09 •October• 2009•
The Georgia Kayak Fishing Club was formed two years ago and now has 440 online members. Our membership stretches to all corners of the state. Club members enjoy picnics, camping trips and get •Read more...•
•Image• Orlando Kayak Fishing Club
••Friday•, 25 •September• 2009•
The Orlando Kayak Fishing Club was founded in March 2007 and has grown to one of the largest clubs in Florida with a total roster of over 380 members throughout the Central Florida region. The objective of the •Read more...•

-

 

Login

Newsletter

Subscribe here to receive FREE email issues of Kayak Fishing Magazine.

Latest Kayak Reviews

Hobie Mirage Outback
 
2.0
NuCanoe Frontier 12
 
5.0
Native Watercraft Mariner 12.5 Propel Anglers
 
4.0
Hobie Mirage Outback
 
5.0
Pelican Castaway 100
 
2.0
Stealth Pro Fisha 575
 
3.0
Field and Stream Eagle Talon
 
5.0
Feelfree Moken 12.5
 
5.0
Pelican Castaway 100
 
4.0
Ascend FS10
 
4.0
Sun Dolphin Excursion 10
 
4.0
Santa Cruz Kayaks Raptor SOT
 
5.0

Latest Equipment Reviews

Body Glove 3T Barefoot Max
 
5.0
Body Glove 3T Barefoot Warrior
 
5.0
Body Glove 3T Barefoot Warrior
 
3.0
Columbia Drainmaker
 
5.0
Sperry SON-R Sounder Shandal
 
4.0
Garmin VIRB Elite
 
4.0
Polaroid XS100
 
4.0
Backwater Paddles Assault Hand Paddle
 
5.0
Backwater Paddles Assault Hand Paddle
 
5.0
Stohlquist Piseas
 
4.0
Wheeleez Tuff Tire Kayak Cart
 
5.0
Boga Grip
 
4.0

•Profile Information•

Application afterLoad: 0.000 seconds, 0.38 MB
Application afterInitialise: 0.070 seconds, 6.62 MB
Application afterRoute: 0.088 seconds, 8.62 MB
Application afterDispatch: 2.313 seconds, 21.88 MB
Application afterRender: 2.781 seconds, 51.27 MB

•Memory Usage•

53836040

•117 queries logged•

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'b748ed245a7e55feab5b57604824351a'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1436198276' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'b748ed245a7e55feab5b57604824351a'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'b748ed245a7e55feab5b57604824351a','1436228276','','0','1','0' )
  5. SELECT *
      FROM jos_components
      WHERE parent = 0
  6. SELECT folder AS TYPE, element AS name, params
      FROM jos_plugins
      WHERE published >= 1
      AND access <= 0
      ORDER BY ordering
  7. SELECT setting,VALUE
      FROM jos_jfbconnect_config
  8. SELECT m.*, c.`option` AS component
      FROM jos_menu AS m
      LEFT JOIN jos_components AS c
      ON m.componentid = c.id
      WHERE m.published = 1
      ORDER BY m.sublevel, m.parent, m.ordering
  9. SELECT *
      FROM jos_jcomments_settings
  10. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 189)
      ORDER BY menuid DESC
      LIMIT 0, 1
  11. SELECT a.*, u.name AS author, u.usertype, cc.title AS category, s.title AS SECTION, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, g.name AS groups, s.published AS sec_pub, cc.published AS cat_pub, s.access AS sec_access, cc.access AS cat_access  
      FROM jos_content AS a
      LEFT JOIN jos_categories AS cc
      ON cc.id = a.catid
      LEFT JOIN jos_sections AS s
      ON s.id = cc.SECTION
      AND s.scope = "content"
      LEFT JOIN jos_users AS u
      ON u.id = a.created_by
      LEFT JOIN jos_groups AS g
      ON a.access = g.id
      WHERE a.id = 1604
      AND (  ( a.created_by = 0 )    OR  ( a.state = 1
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2015-07-07 00:17:56' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2015-07-07 00:17:56' )   )    OR  ( a.state = -1 )  )
  12. UPDATE jos_content
      SET hits = ( hits + 1 )
      WHERE id='1604'
  13. SELECT
                published, params
           
      FROM
                jos_plugins
           
      WHERE
                element = 'jreviews'
      AND folder = 'content'
      LIMIT 1
  14. SELECT catid
      FROM jos_content
      WHERE id = 1604
  15. SELECT g.*
      FROM jos_core_acl_aro_groups AS g
      INNER JOIN jos_core_acl_groups_aro_map AS gm
      ON gm.group_id = g.id
      INNER JOIN jos_core_acl_aro AS ao
      ON ao.id = gm.aro_id
      WHERE ao.VALUE='64'
      ORDER BY g.id
  16. SELECT id, parent_id, VALUE, name, lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE id=23
  17. SELECT id, parent_id, VALUE, name, lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE id=23
  18. SELECT id, parent_id, VALUE, name, lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE id=23
  19. SELECT id, parent_id, VALUE, name, lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE id=25
  20. SELECT g.*
      FROM jos_core_acl_aro_groups AS g
      INNER JOIN jos_core_acl_groups_aro_map AS gm
      ON gm.group_id = g.id
      INNER JOIN jos_core_acl_aro AS ao
      ON ao.id = gm.aro_id
      WHERE ao.VALUE='64'
      ORDER BY g.id
  21. SELECT id, parent_id, VALUE, name, lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE id=23
  22. SELECT MAX(checkdate)
      FROM jos_ijseo_keys
      LIMIT 0,1
  23. SELECT MAX(checkdate)
      FROM jos_ijseo_keys
      LIMIT 0,1
  24. SELECT *
      FROM jos_ijseo_keys AS a
      WHERE 1<=(SELECT DATEDIFF('2015-07-07 00:17:56',a.checkdate))
      ORDER BY checkdate
      LIMIT 0,5
  25. SELECT *
      FROM jos_ijseo_keys AS a
      WHERE 1<=(SELECT DATEDIFF('2015-07-07 00:17:56',a.checkdate))
      ORDER BY checkdate
      LIMIT 0,5
  26. UPDATE jos_ijseo_keys
      SET rank = 0 , rchange =  0, mode = -1 , checkdate = '2015-07-07 00:17:56'
      WHERE title = 'RTM Kayaks Disco Angler'
  27. UPDATE jos_ijseo_keys
      SET rank = 0 , rchange =  0, mode = -1 , checkdate = '2015-07-07 00:17:56'
      WHERE title = 'RTM Kayaks K-Largo'
  28. UPDATE jos_ijseo_keys
      SET rank = 0 , rchange =  0, mode = -1 , checkdate = '2015-07-07 00:17:56'
      WHERE title = 'bilge pump'
  29. UPDATE jos_ijseo_keys
      SET rank = 0 , rchange =  0, mode = -1 , checkdate = '2015-07-07 00:17:56'
      WHERE title = 'Cape Cod'
  30. UPDATE jos_ijseo_keys
      SET rank = 0 , rchange =  0, mode = -1 , checkdate = '2015-07-07 00:17:56'
      WHERE title = 'cape cod'
  31. SELECT menutype, id, name, link  
      FROM jos_menu  
      WHERE id = 189
  32. SELECT menutype
      FROM jos_menu
      WHERE  1=1  
      AND link LIKE '%option=com_content%'
      AND link LIKE '%view=article%'
      AND link LIKE '%id=1604%'
      AND published=1
  33. SELECT menutype
      FROM jos_menu
      WHERE  1=1  
      AND link LIKE '%option=com_content%'
      AND link LIKE '%view=article%'
      AND link LIKE '%id=1604%'
      AND published=1
  34. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_content&view=article&id=1604'
  35. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_content&view=article&id=1604'
  36. SELECT *  
      FROM jos_ijseo_metags  
      WHERE mtype = 'mainmenu'  
      AND id = 189
  37. SELECT *  
      FROM jos_ijseo_metags  
      WHERE mtype = 'mainmenu'  
      AND id = 189
  38. SELECT menutype
      FROM jos_menu
      WHERE  1=1  
      AND link LIKE '%option=com_content%'
      AND link LIKE '%view=article%'
      AND link LIKE '%id=1604%'
      AND published=1
  39. SELECT menutype
      FROM jos_menu
      WHERE  1=1  
      AND link LIKE '%option=com_content%'
      AND link LIKE '%view=article%'
      AND link LIKE '%id=1604%'
      AND published=1
  40. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_content&view=article&id=1604'
  41. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_content&view=article&id=1604'
  42. SELECT *  
      FROM jos_ijseo_metags  
      WHERE mtype = 'mainmenu'  
      AND id = 189
  43. SELECT *  
      FROM jos_ijseo_metags  
      WHERE mtype = 'mainmenu'  
      AND id = 189
  44. SELECT *  
      FROM jos_ijseo_metags  
      WHERE mtype = 'mainmenu'  
      AND id = 189
  45. SELECT menutype, id, name, link  
      FROM jos_menu  
      WHERE id = 189
  46. SELECT j_user_id
      FROM jos_jfbconnect_user_map
      WHERE fb_user_id=''
  47. SELECT id, title, module, POSITION, content, showtitle, control, params
      FROM jos_modules AS m
      LEFT JOIN jos_modules_menu AS mm
      ON mm.moduleid = m.id
      WHERE m.published = 1
      AND m.access <= 0
      AND m.client_id = 0
      AND ( mm.menuid = 189 OR mm.menuid = 0 )
      ORDER BY POSITION, ordering
  48. SELECT *
      FROM jos_ninjarsssyndicator_feeds
      WHERE published = 1
      AND (id = 1)
      ORDER BY feed_name

  49.   SET SQL_BIG_SELECTS=1
  50. SELECT
                            id
                       
      FROM
                            jos_menu
                       
      WHERE
                            link LIKE "%com_comprofiler"
      AND published = 1
      AND TYPE = "component"
  51. SELECT Review.id AS `Review.review_id`,
    Review.pid AS `Review.listing_id`,
    Review.mode AS `Review.extension`,
    Review.created AS `Review.created`,
    Review.modified AS `Review.modified`,
    Review.userid AS `User.user_id`,
    CASE WHEN CHAR_LENGTH(USER.name) THEN USER.name ELSE Review.name END AS `User.name`,
    CASE WHEN CHAR_LENGTH(USER.username) THEN USER.username ELSE Review.username END AS `User.username`,
    Review.email AS `User.email`,
    Review.ipaddress AS `User.ipaddress`,
    Rank.rank AS `User.review_rank`,
    Rank.reviews AS `User.review_count`,
    Review.title AS `Review.title`,
    Review.comments AS `Review.comments`,
    Review.posts AS `Review.posts`,
    Review.author AS `Review.editor`,
    Review.published AS `Review.published`,
    Rating.ratings AS `Rating.ratings`,
    (Rating.ratings_sum/Rating.ratings_qty) AS `Rating.average_rating`,
    Review.vote_helpful AS `Vote.yes`,
    (Review.vote_total - Review.vote_helpful) AS `Vote.no`,
    (Review.vote_helpful/Review.vote_total)*100 AS `Vote.helpful`,
    Review.owner_reply_text AS `Review.owner_reply_text`,
    Review.owner_reply_approved AS `Review.owner_reply_approved`
     
      FROM jos_jreviews_comments AS Review

      LEFT JOIN jos_jreviews_ratings AS Rating
      ON Review.id = Rating.reviewid

      LEFT JOIN jos_users AS USER
      ON Review.userid = USER.id

      LEFT JOIN jos_jreviews_reviewer_ranks AS Rank
      ON Review.userid = Rank.user_id

      LEFT JOIN jos_content AS Listing
      ON Review.pid = Listing.id

      INNER JOIN jos_jreviews_categories AS JreviewsCategory
      ON Listing.catid = JreviewsCategory.id
      AND JreviewsCategory.`option` = 'com_content'

      LEFT JOIN jos_categories AS Category
      ON Category.id = JreviewsCategory.id

      LEFT JOIN jos_jreviews_criteria AS Criteria
      ON JreviewsCategory.criteriaid = Criteria.id
     
      WHERE 1 = 1
      AND (
       Review.mode = 'com_content'
       
      AND Listing.state = 1
       
      AND ( Listing.publish_up = "0000-00-00 00:00:00" OR DATE(Listing.publish_up) <= DATE("2015-07-07 00:17") )
       
      AND ( Listing.publish_down = "0000-00-00 00:00:00" OR DATE(Listing.publish_down) >= DATE("2015-07-07 00:17") )
       
      AND Category.access <= 0
       
      AND Listing.access <= 0
       
      AND Listing.sectionid IN (52)
       
      AND Review.published > 0
     )
     
      ORDER BY `Review.created` DESC
     
      LIMIT 12
  52. SELECT Listing.id AS `Listing.listing_id`,
    Listing.alias AS `Listing.slug`,
    Category.alias AS `Category.slug`,
    Listing.title AS `Listing.title`,
    Listing.introtext AS `Listing.summary`,
    Listing.fulltext AS `Listing.description`,
    Listing.images AS `Listing.images`,
    Listing.hits AS `Listing.hits`,
    Listing.catid AS `Listing.cat_id`,
    Listing.created_by AS `Listing.user_id`,
    Listing.created_by_alias AS `Listing.author_alias`,
    Listing.created AS `Listing.created`,
    Listing.modified AS `Listing.modified`,
    Listing.access AS `Listing.access`,
    Listing.state AS `Listing.state`,
    Listing.publish_up AS `Listing.publish_up`,
    Listing.publish_down AS `Listing.publish_down`,
    Listing.metakey AS `Listing.metakey`,
    Listing.metadesc AS `Listing.metadesc`,
    'com_content' AS `Listing.extension`,
    Category.id AS `Category.cat_id`,
    Category.title AS `Category.title`,
    Directory.id AS `Directory.dir_id`,
    Directory.DESC AS `Directory.title`,
    Directory.title AS `Directory.slug`,
    Criteria.id AS `Criteria.criteria_id`,
    Criteria.title AS `Criteria.title`,
    Criteria.criteria AS `Criteria.criteria`,
    Criteria.tooltips AS `Criteria.tooltips`,
    Criteria.weights AS `Criteria.weights`,
    Criteria.required AS `Criteria.required`,
    Criteria.state AS `Criteria.state`,
    Criteria.config AS `ListingType.config`,
    `Field`.featured AS `Listing.featured`,
    Frontpage.content_id AS `Listing.frontpage`,
    USER.id AS `User.user_id`,
    USER.name AS `User.name`,
    USER.username AS `User.username`,
    USER.email AS `User.email`,
    Totals.user_rating AS `Review.user_rating`,
    Totals.user_rating_count AS `Review.user_rating_count`,
    Totals.user_criteria_rating AS `Review.user_criteria_rating`,
    Totals.user_criteria_rating_count AS `Review.user_criteria_rating_count`,
    Totals.user_comment_count AS `Review.review_count`,
    Totals.editor_rating AS `Review.editor_rating`,
    Totals.editor_rating_count AS `Review.editor_rating_count`,
    Totals.editor_criteria_rating AS `Review.editor_criteria_rating`,
    Totals.editor_criteria_rating_count AS `Review.editor_criteria_rating_count`,
    Totals.editor_comment_count AS `Review.editor_review_count`,
    Claim.approved AS `Claim.approved`,
    Listing.sectionid AS `Listing.section_id`,
    SECTION.id AS `Section.section_id`,
    SECTION.title AS `Section.title`,
    SECTION.alias AS `Section.slug`,
    Category.image AS `Listing.category_image`
     
      FROM jos_content AS Listing

      INNER JOIN jos_jreviews_categories AS JreviewsCategory
      ON Listing.catid = JreviewsCategory.id
      AND JreviewsCategory.`option` = 'com_content'

      LEFT JOIN jos_categories AS Category
      ON JreviewsCategory.id = Category.id

      LEFT JOIN jos_sections AS SECTION
      ON Category.SECTION = SECTION.id

      LEFT JOIN jos_jreviews_listing_totals AS Totals
      ON Totals.listing_id = Listing.id
      AND Totals.extension = 'com_content'

      LEFT JOIN jos_jreviews_content AS FIELD
      ON FIELD.contentid = Listing.id

      LEFT JOIN jos_jreviews_directories AS Directory
      ON JreviewsCategory.dirid = Directory.id

      LEFT JOIN jos_jreviews_criteria AS Criteria
      ON JreviewsCategory.criteriaid = Criteria.id

      LEFT JOIN jos_users AS USER
      ON USER.id = Listing.created_by

      LEFT JOIN jos_jreviews_claims AS Claim
      ON Claim.listing_id = Listing.id
      AND Claim.approved = 1

      LEFT JOIN jos_content_frontpage AS Frontpage
      ON Frontpage.content_id = Listing.id
     
      WHERE 1 = 1
      AND (
       Listing.id IN (1886,1887,1883,1880,1865,1852,1790,687,691,709)
     )
  53. SELECT
                            id
                       
      FROM
                            jos_menu
                       
      WHERE
                            link LIKE "%com_comprofiler"
      AND published = 1
      AND TYPE = "component"
  54. SELECT *
     
      FROM jos_comprofiler AS Community
     
      WHERE 1 = 1
      AND (
       user_id IN (62,63,7026,5782,4698)
     )
  55. SELECT
                        content_id AS listing_id, COUNT(*) AS favored
      FROM jos_jreviews_favorites AS Favorite
                               
      WHERE
                        Favorite.content_id IN (687,691,709,1790,1852,1865,1880,1883,1886,1887)
                               
      GROUP BY
                        listing_id
  56. SELECT Criteria.id AS `Criteria.criteria_id`,
    Criteria.title AS `Criteria.title`,
    Criteria.criteria AS `Criteria.criteria`,
    Criteria.required AS `Criteria.required`,
    Criteria.weights AS `Criteria.weights`,
    Criteria.tooltips AS `Criteria.tooltips`,
    Criteria.qty AS `Criteria.quantity`,
    Criteria.groupid AS `Criteria.group_id`,
    Criteria.state AS `Criteria.state`,
    Criteria.config AS `ListingType.config`,
    Criteria.groupid
     
      FROM jos_jreviews_criteria AS Criteria
     
      WHERE 1 = 1
      AND (
       Criteria.id IN (3,4)
     )
  57. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (3,3,5)
     
      AND TYPE = 'content'
  58. SELECT FIELD.fieldid AS `Field.field_id`, FIELD.groupid AS `Field.group_id`, FIELD.name AS `Field.name`, FIELD.title AS `Field.title`,
     FIELD.showtitle AS `Field.showTitle`, FIELD.description AS `Field.description`, FIELD.required AS `Field.required`,
     FIELD.TYPE AS `Field.type`, FIELD.location AS `Field.location`, FIELD.options AS `Field.params`,
     FIELD.contentview AS `Field.contentView`, FIELD.listview AS `Field.listView`, FIELD.compareview AS `Field.compareView`, FIELD.listsort AS `Field.listSort`,
     FIELD.SEARCH AS `Field.search`, FIELD.access AS `Field.access`, FIELD.access_view AS `Field.accessView`,
     FIELD.published AS `Field.published`,
     `Group`.groupid AS `Group.group_id`, `Group`.title AS `Group.title`, `Group`.name AS `Group.name`, `Group`.showtitle AS `Group.showTitle`
     
      FROM jos_jreviews_fields AS FIELD
     
      INNER JOIN jos_jreviews_groups AS `Group`
      ON (`Group`.groupid = FIELD.groupid
      AND
     `Group`.groupid IN (3,5)
      AND `Group`.TYPE =  'content' )
     
      WHERE FIELD.location = 'content'
      AND FIELD.published = 1
     
      ORDER BY
      GROUP.ordering, FIELD.ordering
  59. SELECT Listing.contentid AS element_id,jr_brand,jr_website
     
      FROM jos_jreviews_content AS Listing
     
      WHERE Listing.contentid IN (687,691,709,1790,1852,1865,1880,1883,1886,1887)
  60. SELECT *
     
      FROM jos_comprofiler AS Community
     
      WHERE 1 = 1
      AND (
       user_id IN (8333,8332,5782,4698,8182,7660,7026,7814)
     )
  61. SELECT Criteria.id AS `Criteria.criteria_id`,
    Criteria.title AS `Criteria.title`,
    Criteria.criteria AS `Criteria.criteria`,
    Criteria.required AS `Criteria.required`,
    Criteria.weights AS `Criteria.weights`,
    Criteria.tooltips AS `Criteria.tooltips`,
    Criteria.qty AS `Criteria.quantity`,
    Criteria.groupid AS `Criteria.group_id`,
    Criteria.state AS `Criteria.state`,
    Criteria.config AS `ListingType.config`,
    Criteria.groupid
     
      FROM jos_jreviews_criteria AS Criteria
     
      WHERE 1 = 1
      AND (
       Criteria.id IN (3,4)
     )
  62. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (3,3,5)
     
      AND TYPE = 'review'
  63. SELECT username
      FROM jos_users
      WHERE id = 8333
      LIMIT 0, 1
  64. SELECT username
      FROM jos_users
      WHERE id = 8332
      LIMIT 0, 1
  65. SELECT username
      FROM jos_users
      WHERE id = 5782
      LIMIT 0, 1
  66. SELECT username
      FROM jos_users
      WHERE id = 5782
      LIMIT 0, 1
  67. SELECT username
      FROM jos_users
      WHERE id = 4698
      LIMIT 0, 1
  68. SELECT username
      FROM jos_users
      WHERE id = 8182
      LIMIT 0, 1
  69. SELECT username
      FROM jos_users
      WHERE id = 5782
      LIMIT 0, 1
  70. SELECT username
      FROM jos_users
      WHERE id = 7660
      LIMIT 0, 1
  71. SELECT username
      FROM jos_users
      WHERE id = 7026
      LIMIT 0, 1
  72. SELECT username
      FROM jos_users
      WHERE id = 7814
      LIMIT 0, 1

  73.   SET SQL_BIG_SELECTS=1
  74. SELECT
                            id
                       
      FROM
                            jos_menu
                       
      WHERE
                            link LIKE "%com_comprofiler"
      AND published = 1
      AND TYPE = "component"
  75. SELECT Review.id AS `Review.review_id`,
    Review.pid AS `Review.listing_id`,
    Review.mode AS `Review.extension`,
    Review.created AS `Review.created`,
    Review.modified AS `Review.modified`,
    Review.userid AS `User.user_id`,
    CASE WHEN CHAR_LENGTH(USER.name) THEN USER.name ELSE Review.name END AS `User.name`,
    CASE WHEN CHAR_LENGTH(USER.username) THEN USER.username ELSE Review.username END AS `User.username`,
    Review.email AS `User.email`,
    Review.ipaddress AS `User.ipaddress`,
    Rank.rank AS `User.review_rank`,
    Rank.reviews AS `User.review_count`,
    Review.title AS `Review.title`,
    Review.comments AS `Review.comments`,
    Review.posts AS `Review.posts`,
    Review.author AS `Review.editor`,
    Review.published AS `Review.published`,
    Rating.ratings AS `Rating.ratings`,
    (Rating.ratings_sum/Rating.ratings_qty) AS `Rating.average_rating`,
    Review.vote_helpful AS `Vote.yes`,
    (Review.vote_total - Review.vote_helpful) AS `Vote.no`,
    (Review.vote_helpful/Review.vote_total)*100 AS `Vote.helpful`,
    Review.owner_reply_text AS `Review.owner_reply_text`,
    Review.owner_reply_approved AS `Review.owner_reply_approved`
     
      FROM jos_jreviews_comments AS Review

      LEFT JOIN jos_jreviews_ratings AS Rating
      ON Review.id = Rating.reviewid

      LEFT JOIN jos_users AS USER
      ON Review.userid = USER.id

      LEFT JOIN jos_jreviews_reviewer_ranks AS Rank
      ON Review.userid = Rank.user_id

      LEFT JOIN jos_content AS Listing
      ON Review.pid = Listing.id

      INNER JOIN jos_jreviews_categories AS JreviewsCategory
      ON Listing.catid = JreviewsCategory.id
      AND JreviewsCategory.`option` = 'com_content'

      LEFT JOIN jos_categories AS Category
      ON Category.id = JreviewsCategory.id

      LEFT JOIN jos_jreviews_criteria AS Criteria
      ON JreviewsCategory.criteriaid = Criteria.id
     
      WHERE 1 = 1
      AND (
       Review.mode = 'com_content'
       
      AND Listing.state = 1
       
      AND ( Listing.publish_up = "0000-00-00 00:00:00" OR DATE(Listing.publish_up) <= DATE("2015-07-07 00:17") )
       
      AND ( Listing.publish_down = "0000-00-00 00:00:00" OR DATE(Listing.publish_down) >= DATE("2015-07-07 00:17") )
       
      AND Category.access <= 0
       
      AND Listing.access <= 0
       
      AND Listing.sectionid IN (55)
       
      AND Review.published > 0
     )
     
      ORDER BY `Review.created` DESC
     
      LIMIT 12
  76. SELECT Listing.id AS `Listing.listing_id`,
    Listing.alias AS `Listing.slug`,
    Category.alias AS `Category.slug`,
    Listing.title AS `Listing.title`,
    Listing.introtext AS `Listing.summary`,
    Listing.fulltext AS `Listing.description`,
    Listing.images AS `Listing.images`,
    Listing.hits AS `Listing.hits`,
    Listing.catid AS `Listing.cat_id`,
    Listing.created_by AS `Listing.user_id`,
    Listing.created_by_alias AS `Listing.author_alias`,
    Listing.created AS `Listing.created`,
    Listing.modified AS `Listing.modified`,
    Listing.access AS `Listing.access`,
    Listing.state AS `Listing.state`,
    Listing.publish_up AS `Listing.publish_up`,
    Listing.publish_down AS `Listing.publish_down`,
    Listing.metakey AS `Listing.metakey`,
    Listing.metadesc AS `Listing.metadesc`,
    'com_content' AS `Listing.extension`,
    Category.id AS `Category.cat_id`,
    Category.title AS `Category.title`,
    Directory.id AS `Directory.dir_id`,
    Directory.DESC AS `Directory.title`,
    Directory.title AS `Directory.slug`,
    Criteria.id AS `Criteria.criteria_id`,
    Criteria.title AS `Criteria.title`,
    Criteria.criteria AS `Criteria.criteria`,
    Criteria.tooltips AS `Criteria.tooltips`,
    Criteria.weights AS `Criteria.weights`,
    Criteria.required AS `Criteria.required`,
    Criteria.state AS `Criteria.state`,
    Criteria.config AS `ListingType.config`,
    `Field`.featured AS `Listing.featured`,
    Frontpage.content_id AS `Listing.frontpage`,
    USER.id AS `User.user_id`,
    USER.name AS `User.name`,
    USER.username AS `User.username`,
    USER.email AS `User.email`,
    Totals.user_rating AS `Review.user_rating`,
    Totals.user_rating_count AS `Review.user_rating_count`,
    Totals.user_criteria_rating AS `Review.user_criteria_rating`,
    Totals.user_criteria_rating_count AS `Review.user_criteria_rating_count`,
    Totals.user_comment_count AS `Review.review_count`,
    Totals.editor_rating AS `Review.editor_rating`,
    Totals.editor_rating_count AS `Review.editor_rating_count`,
    Totals.editor_criteria_rating AS `Review.editor_criteria_rating`,
    Totals.editor_criteria_rating_count AS `Review.editor_criteria_rating_count`,
    Totals.editor_comment_count AS `Review.editor_review_count`,
    Claim.approved AS `Claim.approved`,
    Listing.sectionid AS `Listing.section_id`,
    SECTION.id AS `Section.section_id`,
    SECTION.title AS `Section.title`,
    SECTION.alias AS `Section.slug`,
    Category.image AS `Listing.category_image`
     
      FROM jos_content AS Listing

      INNER JOIN jos_jreviews_categories AS JreviewsCategory
      ON Listing.catid = JreviewsCategory.id
      AND JreviewsCategory.`option` = 'com_content'

      LEFT JOIN jos_categories AS Category
      ON JreviewsCategory.id = Category.id

      LEFT JOIN jos_sections AS SECTION
      ON Category.SECTION = SECTION.id

      LEFT JOIN jos_jreviews_listing_totals AS Totals
      ON Totals.listing_id = Listing.id
      AND Totals.extension = 'com_content'

      LEFT JOIN jos_jreviews_content AS FIELD
      ON FIELD.contentid = Listing.id

      LEFT JOIN jos_jreviews_directories AS Directory
      ON JreviewsCategory.dirid = Directory.id

      LEFT JOIN jos_jreviews_criteria AS Criteria
      ON JreviewsCategory.criteriaid = Criteria.id

      LEFT JOIN jos_users AS USER
      ON USER.id = Listing.created_by

      LEFT JOIN jos_jreviews_claims AS Claim
      ON Claim.listing_id = Listing.id
      AND Claim.approved = 1

      LEFT JOIN jos_content_frontpage AS Frontpage
      ON Frontpage.content_id = Listing.id
     
      WHERE 1 = 1
      AND (
       Listing.id IN (1008,1606,1656,1688,1554,1758,1609,1683,1817,1607)
     )
  77. SELECT *
     
      FROM jos_comprofiler AS Community
     
      WHERE 1 = 1
      AND (
       user_id IN (4698)
     )
  78. SELECT
                        content_id AS listing_id, COUNT(*) AS favored
      FROM jos_jreviews_favorites AS Favorite
                               
      WHERE
                        Favorite.content_id IN (1008,1554,1606,1607,1609,1656,1683,1688,1758,1817)
                               
      GROUP BY
                        listing_id
  79. SELECT Criteria.id AS `Criteria.criteria_id`,
    Criteria.title AS `Criteria.title`,
    Criteria.criteria AS `Criteria.criteria`,
    Criteria.required AS `Criteria.required`,
    Criteria.weights AS `Criteria.weights`,
    Criteria.tooltips AS `Criteria.tooltips`,
    Criteria.qty AS `Criteria.quantity`,
    Criteria.groupid AS `Criteria.group_id`,
    Criteria.state AS `Criteria.state`,
    Criteria.config AS `ListingType.config`,
    Criteria.groupid
     
      FROM jos_jreviews_criteria AS Criteria
     
      WHERE 1 = 1
      AND (
       Criteria.id IN (2)
     )
  80. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (4,3)
     
      AND TYPE = 'content'
  81. SELECT FIELD.fieldid AS `Field.field_id`, FIELD.groupid AS `Field.group_id`, FIELD.name AS `Field.name`, FIELD.title AS `Field.title`,
     FIELD.showtitle AS `Field.showTitle`, FIELD.description AS `Field.description`, FIELD.required AS `Field.required`,
     FIELD.TYPE AS `Field.type`, FIELD.location AS `Field.location`, FIELD.options AS `Field.params`,
     FIELD.contentview AS `Field.contentView`, FIELD.listview AS `Field.listView`, FIELD.compareview AS `Field.compareView`, FIELD.listsort AS `Field.listSort`,
     FIELD.SEARCH AS `Field.search`, FIELD.access AS `Field.access`, FIELD.access_view AS `Field.accessView`,
     FIELD.published AS `Field.published`,
     `Group`.groupid AS `Group.group_id`, `Group`.title AS `Group.title`, `Group`.name AS `Group.name`, `Group`.showtitle AS `Group.showTitle`
     
      FROM jos_jreviews_fields AS FIELD
     
      INNER JOIN jos_jreviews_groups AS `Group`
      ON (`Group`.groupid = FIELD.groupid
      AND
     `Group`.groupid IN (3,4)
      AND `Group`.TYPE =  'content' )
     
      WHERE FIELD.location = 'content'
      AND FIELD.published = 1
     
      ORDER BY
      GROUP.ordering, FIELD.ordering
  82. SELECT Listing.contentid AS element_id,jr_length,jr_width,jr_weight,jr_capacity,jr_lengthgroup,jr_widthgroup,jr_weightgroup,jr_capacitygroup,jr_baseprice,jr_mainpropulsion,jr_rudderoption,jr_maxoccupancy,jr_hulltype,jr_hullconstruction,jr_productionstatus,jr_brand,jr_website
     
      FROM jos_jreviews_content AS Listing
     
      WHERE Listing.contentid IN (1008,1554,1606,1607,1609,1656,1683,1688,1758,1817)
  83. SELECT
                            *
                       
      FROM
                            jos_jreviews_fieldoptions
                       
      WHERE
                            fieldid IN ( '9','18','19','20','10','14','16','12','13','17')
                           
      AND
                            VALUE IN ( '12-0-to-12-11','33','70-to-79-lbs','400499-lbs','pedal','standard','1','sitontop','polyethylene','full-production','16-0-and-longer','27-and-narrowew','50-to-59-lbs','350399-lbs','paddle','optional','1','hybrid','fiberglass','full-production','12-0-to-12-11','36-and-wider','70-to-79-lbs','600-lbs','paddle','no','2','sitontop','rotomolded','full-production','13-0-to-13-11','34','60-to-69-lbs','350399-lbs','paddle','optional','1','sitontop','polyethylene','full-production','12-0-to-12-11','32','70-to-79-lbs','400499-lbs','paddle','optional','1','sitontop','polyethylene','full-production','12-0-to-12-11','32','80-to-89-lbs','400499-lbs','pedal','standard','1','sitontop','polyethylene','full-production','10-0-to-10-11','31','50-to-59-lbs','300349-lbs','paddle','no','1','sitinside','rotomolded','full-production','10-0-to-10-11','30','40-to49-lbs','300lbs','paddle','no','1','sitontop','thermoformed','full-production','12-0-to-12-11','30','60-to-69-lbs','400499-lbs','paddle','no','1','sitontop','rotomolded','full-production','10-0-to-10-11','30','40-to49-lbs','300lbs','paddle','no','1','sitinside','rotomolded','full-production')
                       
      ORDER
                            BY ordering ASC ,optionid ASC
  84. SELECT *
     
      FROM jos_comprofiler AS Community
     
      WHERE 1 = 1
      AND (
       user_id IN (9176,7293,9022,9000,8886,8861,8725,8678,8631,8421,407)
     )
  85. SELECT Criteria.id AS `Criteria.criteria_id`,
    Criteria.title AS `Criteria.title`,
    Criteria.criteria AS `Criteria.criteria`,
    Criteria.required AS `Criteria.required`,
    Criteria.weights AS `Criteria.weights`,
    Criteria.tooltips AS `Criteria.tooltips`,
    Criteria.qty AS `Criteria.quantity`,
    Criteria.groupid AS `Criteria.group_id`,
    Criteria.state AS `Criteria.state`,
    Criteria.config AS `ListingType.config`,
    Criteria.groupid
     
      FROM jos_jreviews_criteria AS Criteria
     
      WHERE 1 = 1
      AND (
       Criteria.id IN (2)
     )
  86. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (4,3)
     
      AND TYPE = 'review'
  87. SELECT username
      FROM jos_users
      WHERE id = 9176
      LIMIT 0, 1
  88. SELECT username
      FROM jos_users
      WHERE id = 9176
      LIMIT 0, 1
  89. SELECT username
      FROM jos_users
      WHERE id = 7293
      LIMIT 0, 1
  90. SELECT username
      FROM jos_users
      WHERE id = 9022
      LIMIT 0, 1
  91. SELECT username
      FROM jos_users
      WHERE id = 9000
      LIMIT 0, 1
  92. SELECT username
      FROM jos_users
      WHERE id = 8886
      LIMIT 0, 1
  93. SELECT username
      FROM jos_users
      WHERE id = 8861
      LIMIT 0, 1
  94. SELECT username
      FROM jos_users
      WHERE id = 8725
      LIMIT 0, 1
  95. SELECT username
      FROM jos_users
      WHERE id = 8678
      LIMIT 0, 1
  96. SELECT username
      FROM jos_users
      WHERE id = 8631
      LIMIT 0, 1
  97. SELECT username
      FROM jos_users
      WHERE id = 8421
      LIMIT 0, 1
  98. SELECT username
      FROM jos_users
      WHERE id = 407
      LIMIT 0, 1
  99. SELECT s.*  
      FROM jos_sections AS s
      WHERE s.scope = "content"
      AND s.access <= 0
      AND (s.id=38)
      AND s.published = 1
      ORDER BY s.id ASC
  100. SELECT a.*,  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      WHERE a.state = 1
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2015-07-07 00:17:59' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2015-07-07 00:17:59' )
      AND s.id > 0
      AND a.access <= 0
      AND s.published = 1
      AND a.sectionid = 38
      AND (a.catid!= 342
      AND a.catid!=325
      AND a.catid!=334)
      ORDER BY a.created DESC
      LIMIT 0, 19
  101. SELECT id
      FROM jos_menu
      WHERE link LIKE 'index.php?option=com_comprofiler&task=registers%'
      AND published = 1
      AND access IN (0)
  102. SELECT `id`
     
      FROM `jos_groups`
     
      WHERE `id` <= 0
     
      ORDER BY `id`
  103. SELECT id, folder, element, published, TYPE, params, CONCAT_WS('/',folder,element) AS lookup, name
     
      FROM jos_comprofiler_plugin
     
      WHERE published = 1
      AND access IN (0)
      AND TYPE = 'user'
     
      ORDER BY ordering
  104. SELECT *
      FROM jos_acymailing_config
  105. SELECT *
      FROM jos_acymailing_list
      WHERE TYPE = 'list'  
      ORDER BY ordering ASC
  106. SELECT *
      FROM jos_ad_agency_settings
      LIMIT 1
  107. SELECT *
      FROM jos_ad_agency_zone
      WHERE zoneid=687
      LIMIT 1
  108. SELECT *
      FROM jos_ad_agency_settings
      LIMIT 1
  109. SELECT *
      FROM jos_ad_agency_zone
      WHERE zoneid=783
      LIMIT 1
  110. SELECT *
      FROM jos_ad_agency_settings
      LIMIT 1
  111. SELECT *
      FROM jos_ad_agency_zone
      WHERE zoneid=690
      LIMIT 1
  112. SELECT c.*,  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END AS slug
      FROM jos_categories AS c
      INNER JOIN jos_sections AS s
      ON s.id = c.SECTION
      WHERE s.scope = "content"
      AND c.access <= 0
      AND (c.id=136)
      AND c.published = 1
      ORDER BY c.SECTION, c.id ASC
  113. SELECT a.*,  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
      FROM jos_content AS a
      INNER JOIN jos_categories AS cc
      ON cc.id = a.catid
      INNER JOIN jos_sections AS s
      ON s.id = a.sectionid
      WHERE a.state = 1
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2015-07-07 00:17:59' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2015-07-07 00:17:59' )
      AND s.id > 0
      AND a.access <= 0
      AND s.published = 1
      AND a.catid = 136
      ORDER BY a.created DESC
      LIMIT 0, 15
  114. SELECT m.*, SUM(CASE WHEN p.published=1 THEN 1 ELSE 0 END) AS cnt

      FROM jos_menu AS m

      LEFT JOIN jos_menu AS p
      ON p.parent = m.id

      WHERE m.menutype='mainmenu'
      AND m.published='1'
      AND m.access <= '0'

      GROUP BY m.id
      ORDER BY m.parent, m.ordering
  115. SELECT m.*
      FROM jos_menu AS m

      WHERE menutype='mainmenu'
      AND m.published='1'
  116. SELECT *
      FROM jos_ad_agency_settings
      LIMIT 1
  117. SELECT *
      FROM jos_ad_agency_zone
      WHERE zoneid=697
      LIMIT 1

•Language Files Loaded•

•Untranslated Strings Diagnostic•

•None•

•Untranslated Strings Designer•

•None•