Powered by JReviews

Login

Newsletter

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

Top User Ratings

Santa Cruz Kayaks Raptor SOT
Editor rating
 
0.0
User rating
 
5.0 (6)
Hobie Quest 13
Editor rating
 
0.0
User rating
 
5.0 (4)
Old Town Predator 13
Editor rating
 
4.0 (2)
User rating
 
5.0 (4)
Field and Stream Eagle Talon
Editor rating
 
0.0
User rating
 
5.0 (4)
Jackson Kayak Coosa
Editor rating
 
0.0
User rating
 
5.0 (3)
Santa Cruz Kayaks Raptor
Editor rating
 
0.0
User rating
 
5.0 (3)
Wilderness Systems Ride 115 Advanced Angler
Editor rating
 
5.0
User rating
 
5.0 (3)
NuCanoe Frontier 12
Editor rating
 
0.0
User rating
 
5.0 (3)
Malibu Kayaks Stealth 14
Editor rating
 
0.0
User rating
 
5.0 (2)
Emotion Kayaks Grand Slam Angler
Editor rating
 
0.0
User rating
 
5.0 (2)
Ocean Kayak Caper Angler
Editor rating
 
0.0
User rating
 
5.0 (2)
Feelfree Moken 12.5
Editor rating
 
0.0
User rating
 
5.0 (2)
Wilderness Systems Tarpon 140 Angler
Editor rating
 
0.0
User rating
 
5.0 (1)
Feelfree Moken 12
Editor rating
 
0.0
User rating
 
5.0 (1)
Emotion Kayaks Glide Angler
Editor rating
 
0.0
User rating
 
5.0 (1)
Feelfree Moken 14
Editor rating
 
0.0
User rating
 
5.0 (1)
KC Kayaks K12 Fishing Kayak
Editor rating
 
0.0
User rating
 
5.0 (1)
Wilderness Systems Commander 140 Angler
Editor rating
 
0.0
User rating
 
5.0 (1)
Old Town Vapor 10 Angler
Editor rating
 
0.0
User rating
 
5.0 (1)
Jackson Kayak Cuda 14
Editor rating
 
0.0
User rating
 
5.0 (1)

Most Popular

Hobie Mirage Outback
Editor rating
 
0.0
User rating
 
4.5 (14)
Jackson Kayak Cuda 12
Editor rating
 
4.0
User rating
 
0.0 (0)
Hobie Mirage Revolution 13
Editor rating
 
0.0
User rating
 
4.5 (9)
Field and Stream Eagle Talon
Editor rating
 
0.0
User rating
 
5.0 (4)
Malibu Kayaks Stealth 14
Editor rating
 
0.0
User rating
 
5.0 (2)
Hobie Quest 13
Editor rating
 
0.0
User rating
 
5.0 (4)
Old Town Predator 13
Editor rating
 
4.0 (2)
User rating
 
5.0 (4)
Malibu Kayaks X-13
Editor rating
 
0.0
User rating
 
4.5 (6)
Wilderness Systems Tarpon 100
Editor rating
 
0.0
User rating
 
4.9 (8)
Hobie Mirage Pro Angler 14
Editor rating
 
0.0
User rating
 
4.8 (4)
Wilderness Systems Ride 115 Advanced Angler
Editor rating
 
5.0
User rating
 
5.0 (3)
Native Watercraft Kayaks Redfish 14 Angler
Editor rating
 
0.0
User rating
 
4.8 (4)
Native Watercraft Manta Ray 12 Angler
Editor rating
 
0.0
User rating
 
4.7 (4)
Ocean Kayak Trident 13 Angler
Editor rating
 
0.0
User rating
 
4.8 (5)
Ocean Kayak Prowler Big Game
Editor rating
 
0.0
User rating
 
4.4 (5)
Santa Cruz Kayaks Raptor
Editor rating
 
0.0
User rating
 
5.0 (3)
Wilderness Systems Tarpon 120 Angler
Editor rating
 
0.0
User rating
 
4.0 (4)
Malibu Kayaks Mini-X
Editor rating
 
0.0
User rating
 
4.0 (2)
Jackson Kayak Coosa
Editor rating
 
0.0
User rating
 
5.0 (3)
Hobie Mirage Adventure
Editor rating
 
0.0
User rating
 
4.4 (5)

Random Kayak Listings

Malibu Kayaks Stealth 9
Editor rating
 
0.0
User rating
 
0.0 (0)
Malibu Kayaks Ranger 15.1
Editor rating
 
0.0
User rating
 
0.0 (0)
West Marine Pompano 120
Editor rating
 
0.0
User rating
 
0.0 (0)
Wilderness Systems Ride 135 Advanced Angler
Editor rating
 
0.0
User rating
 
4.8 (4)
Lifetime Payette 116 Angler
Editor rating
 
0.0
User rating
 
0.0 (0)
Santa Cruz Kayaks Raptor
Editor rating
 
0.0
User rating
 
5.0 (3)
Malibu Kayaks Express
Editor rating
 
0.0
User rating
 
0.0 (0)
Native Watercraft Manta Ray 14 Angler
Editor rating
 
0.0
User rating
 
4.3 (3)
Ocean Kayak Trident 11 Angler
Editor rating
 
0.0
User rating
 
4.0 (2)
Wilderness Systems Tarpon 120 Angler
Editor rating
 
0.0
User rating
 
4.0 (4)
Pelican Strike 120X Angler kayak
Editor rating
 
4.0
User rating
 
0.0 (0)
Malibu Kayaks Pro2 Tandem
Editor rating
 
0.0
User rating
 
0.0 (0)
Native Watercraft Ultimate 16 Angler
Editor rating
 
0.0
User rating
 
0.0 (0)
Feelfree Moken 10 Standard
Editor rating
 
0.0
User rating
 
0.0 (0)
Hobie Mirage Revolution 11
Editor rating
 
0.0
User rating
 
5.0 (1)
Ocean Kayak Ultra 4.7
Editor rating
 
0.0
User rating
 
4.0 (1)
Native Watercraft Mariner 10 Propel
Editor rating
 
0.0
User rating
 
0.0 (0)
Malibu Kayaks Stealth 12
Editor rating
 
0.0
User rating
 
4.0 (1)
Editor rating
 
0.0
User rating
 
0.0 (0)
Ascend D12
Editor rating
 
0.0
User rating
 
0.0 (0)

Search

Length:
 < 9'
 9'
 10'
 11'
 12'
 13'
 14'
 15'
 >= 16'
Width:
 < 29"
 28"
 29"
 30"
 31"
 32"
 33"
 34"
 35"
 >= 36"
Weight:
 < 40 lbs
 40-49 lbs
 50-59 lbs
 60-69 lbs
 70-79 lbs
 80-89 lbs
 >= 90 lbs
Capacity:
 < 300 lbs
 300-349 lbs
 350-399 lbs
 400-499 lbs
 500-599 lbs
 >= 600 lbs
Base Price:
Main Propulsion:
 Paddle
 Pedal
 Motor
 Sail
Passengers:
 1
 2
Hull Type:
 Sit-On-Top
 Sit-Inside
 Hybrid
 Outrigger
 SUP
Keywords:   

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.092 seconds, 6.62 MB
Application afterRoute: 0.112 seconds, 8.62 MB
Application afterDispatch: 0.285 seconds, 21.07 MB
Application afterRender: 1.188 seconds, 60.09 MB

•Memory Usage•

63082280

•127 queries logged•

  1. SELECT *
      FROM jos_session
      WHERE session_id = 'f1be24afbdb0f74b785fc47201cb21d8'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1436182740' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = 'f1be24afbdb0f74b785fc47201cb21d8'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'f1be24afbdb0f74b785fc47201cb21d8','1436212740','','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_menu
      WHERE id = 553

  10.   SET SQL_BIG_SELECTS=1
  11. SELECT
                            id
                       
      FROM
                            jos_menu
                       
      WHERE
                            link LIKE "%com_comprofiler"
      AND published = 1
      AND TYPE = "component"
  12. SELECT Category.id AS `Category.cat_id`,
    Category.SECTION AS `Category.section_id`,
    Category.title AS `Category.title`,
    Category.alias AS `Category.slug`,
    Category.image AS `Category.image`,
    Category.image_position AS `Category.image_position`,
    Category.description AS `Category.description`,
    Category.access AS `Category.access`,
    Category.published AS `Category.published`,
    Directory.id AS `Category.dir_id`,
    JreviewsCategory.criteriaid AS `Category.criteria_id`,
    JreviewsCategory.tmpl AS `Category.tmpl`,
    JreviewsCategory.tmpl_suffix AS `Category.tmpl_suffix`,
    Directory.id AS `Directory.dir_id`,
    Directory.DESC AS `Directory.title`,
    Directory.title AS `Directory.slug`,
    ListingType.config AS `ListingType.config`,
     
                                (SELECT
                                  COUNT(*)
                                 
      FROM jos_content AS Listing
                                 
      INNER JOIN jos_jreviews_categories AS JreviewsCategory
      ON JreviewsCategory.id = Listing.catid
      AND JreviewsCategory.`option` = "com_content"
                                 
      WHERE
                                        Listing.sectionid = 55
                                       
      AND Listing.catid = Category.id        
                                       
      AND Listing.state = 1
                                       
      AND Listing.access <= 0
                                       
      AND ( Listing.publish_up = "0000-00-00 00:00:00" OR Listing.publish_up <= "2015-07-06 19:59" )
                                       
      AND ( Listing.publish_down = "0000-00-00 00:00:00" OR Listing.publish_down >= "2015-07-06 19:59" )
                                ) AS `Category.listing_count`                    
                           
     
      FROM jos_categories AS Category

      INNER JOIN jos_jreviews_categories AS JreviewsCategory
      ON Category.id = JreviewsCategory.id
      AND JreviewsCategory.OPTION = "com_content"

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

      LEFT JOIN jos_jreviews_criteria AS ListingType
      ON JreviewsCategory.criteriaid = ListingType.id
     
      WHERE 1 = 1
      AND (
       Category.SECTION = 55
       
      AND Category.published = 1
     )
     
      ORDER BY Category.title ASC
  13. SELECT SECTION.id AS `Section.section_id`,
    SECTION.title AS `Section.title`,
    SECTION.alias AS `Section.slug`,
    SECTION.image AS `Section.image`,
    SECTION.image_position AS `Section.image_position`,
    SECTION.description AS `Section.description`,
    SECTION.access AS `Section.access`,
    SECTION.published AS `Section.published`,
    JreviewsSection.tmpl AS `Section.tmpl`,
    JreviewsSection.tmpl_suffix AS `Section.tmpl_suffix`,
    1 AS `Section.dir_id`
     
      FROM jos_sections AS `Section`

      LEFT JOIN jos_jreviews_sections AS JreviewsSection
      ON SECTION.id = JreviewsSection.sectionid
     
      WHERE 1 = 1
      AND (
       SECTION.id = 55
     )
  14. SELECT Directory.id AS `Directory.id`,
    Directory.title AS `Directory.slug`,
    Directory.DESC AS `Directory.title`,
    Directory.tmpl_suffix AS `Directory.tmpl_suffix`,
    Directory.id AS `Directory.dir_id`,
    Directory.title AS `Directory.slug`,
    Directory.DESC AS `Directory.title`
     
      FROM jos_jreviews_directories AS Directory
     
      WHERE 1 = 1
      AND (
       Directory.id = 1
     )
  15. SELECT COUNT(DISTINCT groupid)
     
      FROM jos_jreviews_criteria
     
      WHERE groupid != ''
  16. SELECT criteriaid
      FROM jos_jreviews_categories
     
      WHERE `option` = 'com_content'
     
      AND id IN (313,338,209,347,324,220,314,215,216,344,219,221,331,312,337,336,341,213,210,315,322,230,339,340,224,214,311,332,346,345,212)
  17. 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)
     )
  18. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (4,3)
     
      AND TYPE = 'content'
  19. SELECT FIELD.fieldid, FIELD.title AS text, FIELD.name AS VALUE, FIELD.access_view AS access
     
      FROM jos_jreviews_fields AS FIELD
     
      WHERE FIELD.location = 'content'
     
      AND FIELD.listsort = 1
     
      AND FIELD.groupid IN (3,4)
  20. SELECT menutype, id, name, link  
      FROM jos_menu  
      WHERE id = 553
  21. SELECT menutype
      FROM jos_menu
      WHERE  1=1  
      AND link LIKE '%option=com_jreviews%'
      AND published=1
  22. SELECT menutype
      FROM jos_menu
      WHERE  1=1  
      AND link LIKE '%option=com_jreviews%'
      AND published=1
  23. SELECT *  
      FROM jos_ijseo_metags  
      WHERE mtype = 'mainmenu'  
      AND id = 553
  24. SELECT *  
      FROM jos_ijseo_metags  
      WHERE mtype = 'mainmenu'  
      AND id = 553
  25. SELECT j_user_id
      FROM jos_jfbconnect_user_map
      WHERE fb_user_id=''
  26. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 553)
      ORDER BY menuid DESC
      LIMIT 0, 1
  27. 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 = 553 OR mm.menuid = 0 )
      ORDER BY POSITION, ordering
  28. SELECT *
      FROM jos_ninjarsssyndicator_feeds
      WHERE published = 1
      AND (id = 1)
      ORDER BY feed_name

  29.   SET SQL_BIG_SELECTS=1
  30. SELECT
                            id
                       
      FROM
                            jos_menu
                       
      WHERE
                            link LIKE "%com_comprofiler"
      AND published = 1
      AND TYPE = "component"
  31. 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-06 19:59") )
       
      AND ( Listing.publish_down = "0000-00-00 00:00:00" OR DATE(Listing.publish_down) >= DATE("2015-07-06 19:59") )
       
      AND Category.access <= 0
       
      AND Listing.access <= 0
       
      AND Listing.sectionid IN (52)
       
      AND Review.published > 0
     )
     
      ORDER BY `Review.created` DESC
     
      LIMIT 12
  32. 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)
     )
  33. SELECT
                            id
                       
      FROM
                            jos_menu
                       
      WHERE
                            link LIKE "%com_comprofiler"
      AND published = 1
      AND TYPE = "component"
  34. SELECT *
     
      FROM jos_comprofiler AS Community
     
      WHERE 1 = 1
      AND (
       user_id IN (62,63,7026,5782,4698)
     )
  35. 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
  36. 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)
     )
  37. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (3,3,5)
     
      AND TYPE = 'content'
  38. 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
  39. 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)
  40. SELECT *
     
      FROM jos_comprofiler AS Community
     
      WHERE 1 = 1
      AND (
       user_id IN (8333,8332,5782,4698,8182,7660,7026,7814)
     )
  41. 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)
     )
  42. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (3,3,5)
     
      AND TYPE = 'review'
  43. SELECT username
      FROM jos_users
      WHERE id = 8333
      LIMIT 0, 1
  44. SELECT username
      FROM jos_users
      WHERE id = 8332
      LIMIT 0, 1
  45. SELECT username
      FROM jos_users
      WHERE id = 5782
      LIMIT 0, 1
  46. SELECT username
      FROM jos_users
      WHERE id = 5782
      LIMIT 0, 1
  47. SELECT username
      FROM jos_users
      WHERE id = 4698
      LIMIT 0, 1
  48. SELECT username
      FROM jos_users
      WHERE id = 8182
      LIMIT 0, 1
  49. SELECT username
      FROM jos_users
      WHERE id = 5782
      LIMIT 0, 1
  50. SELECT username
      FROM jos_users
      WHERE id = 7660
      LIMIT 0, 1
  51. SELECT username
      FROM jos_users
      WHERE id = 7026
      LIMIT 0, 1
  52. SELECT username
      FROM jos_users
      WHERE id = 7814
      LIMIT 0, 1

  53.   SET SQL_BIG_SELECTS=1
  54. SELECT
                            id
                       
      FROM
                            jos_menu
                       
      WHERE
                            link LIKE "%com_comprofiler"
      AND published = 1
      AND TYPE = "component"
  55. 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-06 19:59") )
       
      AND ( Listing.publish_down = "0000-00-00 00:00:00" OR DATE(Listing.publish_down) >= DATE("2015-07-06 19:59") )
       
      AND Category.access <= 0
       
      AND Listing.access <= 0
       
      AND Listing.sectionid IN (55)
       
      AND Review.published > 0
     )
     
      ORDER BY `Review.created` DESC
     
      LIMIT 12
  56. 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)
     )
  57. SELECT *
     
      FROM jos_comprofiler AS Community
     
      WHERE 1 = 1
      AND (
       user_id IN (4698)
     )
  58. 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
  59. 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)
     )
  60. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (4,3)
     
      AND TYPE = 'content'
  61. 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
  62. 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)
  63. 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
  64. SELECT *
     
      FROM jos_comprofiler AS Community
     
      WHERE 1 = 1
      AND (
       user_id IN (9176,7293,9022,9000,8886,8861,8725,8678,8631,8421,407)
     )
  65. 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)
     )
  66. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (4,3)
     
      AND TYPE = 'review'
  67. SELECT username
      FROM jos_users
      WHERE id = 9176
      LIMIT 0, 1
  68. SELECT username
      FROM jos_users
      WHERE id = 9176
      LIMIT 0, 1
  69. SELECT username
      FROM jos_users
      WHERE id = 7293
      LIMIT 0, 1
  70. SELECT username
      FROM jos_users
      WHERE id = 9022
      LIMIT 0, 1
  71. SELECT username
      FROM jos_users
      WHERE id = 9000
      LIMIT 0, 1
  72. SELECT username
      FROM jos_users
      WHERE id = 8886
      LIMIT 0, 1
  73. SELECT username
      FROM jos_users
      WHERE id = 8861
      LIMIT 0, 1
  74. SELECT username
      FROM jos_users
      WHERE id = 8725
      LIMIT 0, 1
  75. SELECT username
      FROM jos_users
      WHERE id = 8678
      LIMIT 0, 1
  76. SELECT username
      FROM jos_users
      WHERE id = 8631
      LIMIT 0, 1
  77. SELECT username
      FROM jos_users
      WHERE id = 8421
      LIMIT 0, 1
  78. SELECT username
      FROM jos_users
      WHERE id = 407
      LIMIT 0, 1

  79.   SET SQL_BIG_SELECTS=1
  80. SELECT
                            id
                       
      FROM
                            jos_menu
                       
      WHERE
                            link LIKE "%com_comprofiler"
      AND published = 1
      AND TYPE = "component"
  81. SELECT
                        FieldValue.optionid, FieldValue.fieldid, FieldValue.text, FieldValue.VALUE, FieldValue.image, FieldValue.ordering
                   
      FROM
                        jos_jreviews_fieldoptions AS FieldValue
                   
      WHERE
                        FieldValue.fieldid IN (20,9,10,18,12,16,19)
                       
                   
      ORDER
                        BY FieldValue.text ASC
  82. SELECT
                        FieldValue.optionid, FieldValue.fieldid, FieldValue.text, FieldValue.VALUE, FieldValue.image, FieldValue.ordering
                   
      FROM
                        jos_jreviews_fieldoptions AS FieldValue
                   
      WHERE
                        FieldValue.fieldid IN (20,9,10,18,12,16,19)
                       
                   
      ORDER
                        BY FieldValue.ordering ASC
  83. SELECT id
      FROM jos_menu
      WHERE link LIKE 'index.php?option=com_comprofiler&task=registers%'
      AND published = 1
      AND access IN (0)
  84. SELECT `id`
     
      FROM `jos_groups`
     
      WHERE `id` <= 0
     
      ORDER BY `id`
  85. 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
  86. SELECT *
      FROM jos_acymailing_config
  87. SELECT *
      FROM jos_acymailing_list
      WHERE TYPE = 'list'  
      ORDER BY ordering ASC
  88. SELECT *
      FROM jos_ad_agency_settings
      LIMIT 1
  89. SELECT *
      FROM jos_ad_agency_zone
      WHERE zoneid=687
      LIMIT 1
  90. SELECT *
      FROM jos_ad_agency_settings
      LIMIT 1
  91. SELECT *
      FROM jos_ad_agency_zone
      WHERE zoneid=783
      LIMIT 1

  92.   SET SQL_BIG_SELECTS=1
  93. SELECT
                            id
                       
      FROM
                            jos_menu
                       
      WHERE
                            link LIKE "%com_comprofiler"
      AND published = 1
      AND TYPE = "component"
  94. 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.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`,
    '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`,
    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

      INNER 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 (
       Totals.user_rating > 0
       
      AND Listing.state = 1
       
      AND ( Listing.publish_up = "0000-00-00 00:00:00" OR DATE(Listing.publish_up) <= DATE("2015-07-06 19:59") )
       
      AND ( Listing.publish_down = "0000-00-00 00:00:00" OR DATE(Listing.publish_down) >= DATE("2015-07-06 19:59") )
       
      AND Category.access <= 0
       
      AND Listing.access <= 0
       
      AND Listing.sectionid IN (55)
     )
     
      ORDER BY Totals.user_rating DESC, Totals.user_rating_count DESC
     
      LIMIT 20
  95. SELECT *
     
      FROM jos_comprofiler AS Community
     
      WHERE 1 = 1
      AND (
       user_id IN (4698,64)
     )
  96. SELECT
                        content_id AS listing_id, COUNT(*) AS favored
      FROM jos_jreviews_favorites AS Favorite
                               
      WHERE
                        Favorite.content_id IN (1607,1003,1727,1758,1325,1322,1414,1606,959,974,985,1609,871,999,976,1610,1659,926,1668,1505)
                               
      GROUP BY
                        listing_id
  97. 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)
     )
  98. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (4,3)
     
      AND TYPE = 'content'
  99. 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
  100. 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 (1607,1003,1727,1758,1325,1322,1414,1606,959,974,985,1609,871,999,976,1610,1659,926,1668,1505)
  101. SELECT
                            *
                       
      FROM
                            jos_jreviews_fieldoptions
                       
      WHERE
                            fieldid IN ( '9','18','19','20','10','14','16','12','13','17')
                           
      AND
                            VALUE IN ( '14-0-to-14-11','28','70-to-79-lbs','350399-lbs','paddle','optional','1','sitontop','polyethylene','full-production','14-0-to-14-11','30','70-to-79-lbs','400499-lbs','paddle','optional','1','hybrid','polyethylene','full-production','14-0-to-14-11','33','60-to-69-lbs','500599-lbs','paddle','optional','1','sitontop','rotomolded','full-production','14-0-to-14-11','30','70-to-79-lbs','350399-lbs','paddle','optional','1','sitontop','polyethylene','full-production','9-0-to-9-11','29','39-lbs-and-ligher','300lbs','paddle','no','1','sitinside','polyethylene','full-production','11-0-to-11-9','31','40-to49-lbs','300349-lbs','paddle','no','1','sitontop','polyethylene','full-production','12-0-to-12-11','29','50-to-59-lbs','350399-lbs','paddle','no','1','sitontop','polyethylene','limited-production','13-0-to-13-11','28','60-to-69-lbs','350399-lbs','paddle','no','1','sitontop','polyethylene','full-production','13-0-to-13-11','34','60-to-69-lbs','300349-lbs','paddle','optional','1','sitinside','polyethylene','full-production','11-0-to-11-9','32','60-to-69-lbs','350399-lbs','paddle','no','1','sitontop','polyethylene','full-production','11-0-to-11-9','30','70-to-79-lbs','400499-lbs','paddle','optional','1','sitontop','polyethylene','full-production','14-0-to-14-11','30','80-to-89-lbs','400499-lbs','paddle','optional','1','sitontop','polyethylene','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','14-0-to-14-11','30','70-to-79-lbs','400499-lbs','paddle','optional','1','sitontop','polyethylene','full-production','12-0-to-12-11','34','60-to-69-lbs','400499-lbs','paddle','no','1','sitontop','thermoformed','full-production','10-0-to-10-11','28','40-to49-lbs','300349-lbs','paddle','no','1','sitinside','polyethylene','full-production','13-0-to-13-11','33','70-to-79-lbs','400499-lbs','paddle','no','1','hybrid','rotomolded','full-production','12-0-to-12-11','30','60-to-69-lbs','400499-lbs','paddle','no','1','sitontop','rotomolded','full-production')
                       
      ORDER
                            BY ordering ASC ,optionid ASC

  102.   SET SQL_BIG_SELECTS=1
  103. SELECT
                            id
                       
      FROM
                            jos_menu
                       
      WHERE
                            link LIKE "%com_comprofiler"
      AND published = 1
      AND TYPE = "component"
  104. 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.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`,
    '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`,
    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 USE KEY (jr_hits)

      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.state = 1
       
      AND ( Listing.publish_up = "0000-00-00 00:00:00" OR DATE(Listing.publish_up) <= DATE("2015-07-06 19:59") )
       
      AND ( Listing.publish_down = "0000-00-00 00:00:00" OR DATE(Listing.publish_down) >= DATE("2015-07-06 19:59") )
       
      AND Category.access <= 0
       
      AND Listing.access <= 0
       
      AND Listing.sectionid IN (55)
     )
     
      ORDER BY Listing.hits DESC
     
      LIMIT 20
  105. SELECT *
     
      FROM jos_comprofiler AS Community
     
      WHERE 1 = 1
      AND (
       user_id IN (4698,64)
     )
  106. SELECT
                        content_id AS listing_id, COUNT(*) AS favored
      FROM jos_jreviews_favorites AS Favorite
                               
      WHERE
                        Favorite.content_id IN (1008,1504,1010,1758,959,1003,1727,957,875,1006,1414,995,971,983,981,1322,868,961,1325,1007)
                               
      GROUP BY
                        listing_id
  107. 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)
     )
  108. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (4,3)
     
      AND TYPE = 'content'
  109. 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
  110. 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,1504,1010,1758,959,1003,1727,957,875,1006,1414,995,971,983,981,1322,868,961,1325,1007)
  111. 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','30','70-to-79-lbs','350399-lbs','paddle','optional','1','sitontop','polyethylene','full-production','10-0-to-10-11','30','50-to-59-lbs','300349-lbs','paddle','no','1','sitontop','polyethylene','full-production','13-0-to-13-11','29','60-to-69-lbs','400499-lbs','paddle','optional','1','sitontop','rotomolded','full-production','14-0-to-14-11','33','60-to-69-lbs','500599-lbs','paddle','optional','1','sitontop','rotomolded','full-production','10-0-to-10-11','35','40-to49-lbs','300349-lbs','paddle','no','1','sitontop','rotomolded','full-production','12-0-to-12-11','30','60-to-69-lbs','300349-lbs','paddle','no','1','sitontop','polyethylene','full-production','12-0-to-12-11','34','60-to-69-lbs','600-lbs','paddle','optional','1','sitontop','polyethylene','full-production','13-0-to-13-11','29','50-to-59-lbs','400499-lbs','paddle','optional','1','sitontop','polyethylene','full-production','14-0-to-14-11','31','70-to-79-lbs','400499-lbs','paddle','no','1','sitontop','polyethylene','full-production','13-0-to-13-11','28','60-to-69-lbs','350399-lbs','paddle','no','1','sitontop','polyethylene','full-production','13-0-to-13-11','36-and-wider','90-lbs-and-heavier','600-lbs','pedal','standard','1','hybrid','polyethylene','full-production','16-0-and-longer','27-and-narrowew','70-to-79-lbs','350399-lbs','pedal','standard','1','sitontop','polyethylene','full-production','12-0-to-12-11','33','70-to-79-lbs','400499-lbs','pedal','standard','1','sitontop','polyethylene','full-production','13-0-to-13-11','28','70-to-79-lbs','350399-lbs','pedal','standard','1','sitontop','polyethylene','full-production','13-0-to-13-11','34','60-to-69-lbs','300349-lbs','paddle','optional','1','sitinside','polyethylene','full-production','11-0-to-11-9','32','60-to-69-lbs','350399-lbs','paddle','no','1','sitontop','polyethylene','full-production','11-0-to-11-9','30','70-to-79-lbs','400499-lbs','paddle','optional','1','sitontop','polyethylene','full-production','12-0-to-12-11','31','60-to-69-lbs','350399-lbs','paddle','optional','1','sitontop','polyethylene','full-production','13-0-to-13-11','33','70-to-79-lbs','400499-lbs','paddle','no','1','hybrid','rotomolded','full-production','12-0-to-12-11','30','60-to-69-lbs','400499-lbs','paddle','no','1','sitontop','rotomolded','full-production')
                       
      ORDER
                            BY ordering ASC ,optionid ASC

  112.   SET SQL_BIG_SELECTS=1
  113. SELECT
                            id
                       
      FROM
                            jos_menu
                       
      WHERE
                            link LIKE "%com_comprofiler"
      AND published = 1
      AND TYPE = "component"
  114. 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.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`,
    '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`,
    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.state = 1
       
      AND ( Listing.publish_up = "0000-00-00 00:00:00" OR DATE(Listing.publish_up) <= DATE("2015-07-06 19:59") )
       
      AND ( Listing.publish_down = "0000-00-00 00:00:00" OR DATE(Listing.publish_down) >= DATE("2015-07-06 19:59") )
       
      AND Category.access <= 0
       
      AND Listing.access <= 0
       
      AND Listing.sectionid IN (55)
     )
     
      ORDER BY RAND(1712860198)
     
      LIMIT 20
  115. SELECT *
     
      FROM jos_comprofiler AS Community
     
      WHERE 1 = 1
      AND (
       user_id IN (4698,64,5782)
     )
  116. SELECT
                        content_id AS listing_id, COUNT(*) AS favored
      FROM jos_jreviews_favorites AS Favorite
                               
      WHERE
                        Favorite.content_id IN (1638,1635,1777,877,1691,1322,1639,969,984,868,1843,955,965,1634,1616,1460,1655,960,1329,1680)
                               
      GROUP BY
                        listing_id
  117. 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)
     )
  118. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (4,3)
     
      AND TYPE = 'content'
  119. 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
  120. 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 (1638,1635,1777,877,1691,1322,1639,969,984,868,1843,955,965,1634,1616,1460,1655,960,1329,1680)
  121. 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','30','70-to-79-lbs','350399-lbs','paddle','optional','1','sitontop','polyethylene','full-production','13-0-to-13-11','31','80-to-89-lbs','500599-lbs','paddle','optional','1','sitontop','polyethylene','full-production','13-0-to-13-11','33','60-to-69-lbs','500599-lbs','paddle','no','2','sitontop','rotomolded','full-production','12-0-to-12-11','33','60-to-69-lbs','400499-lbs','paddle','optional','1','sitontop','rotomolded','full-production','16-0-and-longer','31','80-to-89-lbs','600-lbs','paddle','optional','1','hybrid','polyethylene','full-production','14-0-to-14-11','28','70-to-79-lbs','350399-lbs','paddle','no','1','sitontop','polyethylene','full-production','11-0-to-11-9','30','50-to-59-lbs','400499-lbs','paddle','optional','1','sitontop','polyethylene','full-production','13-0-to-13-11','34','60-to-69-lbs','300349-lbs','paddle','optional','1','sitinside','polyethylene','full-production','15-0-to-15-11','28','60-to-69-lbs','400499-lbs','paddle','no','1','sitontop','thermoformed','full-production','16-0-and-longer','29','70-to-79-lbs','500599-lbs','paddle','optional','1','sitontop','polyethylene','full-production','11-0-to-11-9','29','50-to-59-lbs','300lbs','pedal','standard','1','sitontop','polyethylene','full-production','10-0-to-10-11','35','60-to-69-lbs','400499-lbs','paddle','no','1','sitontop','polyethylene','limited-production','15-0-to-15-11','35','80-to-89-lbs','600-lbs','paddle','no','1','hybrid','rotomolded','full-production','9-0-to-9-11','33','40-to49-lbs','300lbs','paddle','optional','1','sitontop','rotomolded','full-production','14-0-to-14-11','27-and-narrowew','40-to49-lbs','300lbs','paddle','optional','1','hybrid','rotomolded','full-production','10-0-to-10-11','32','70-to-79-lbs','300lbs','pedal','standard','1','sitontop','polyethylene','full-production','12-0-to-12-11','29','70-to-79-lbs','350399-lbs','paddle','no','1','sitinside','rotomolded','full-production','8-11-and-shorter','30','40-to49-lbs','300lbs','paddle','no','1','sitinside','rotomolded','full-production','12-0-to-12-11','28','60-to-69-lbs','350399-lbs','paddle','no','1','sitontop','rotomolded','full-production','12-0-to-12-11','30','60-to-69-lbs','350399-lbs','paddle','optional','1','sitontop','thermoformed','full-production')
                       
      ORDER
                            BY ordering ASC ,optionid ASC
  122. SELECT *
      FROM jos_ad_agency_settings
      LIMIT 1
  123. SELECT *
      FROM jos_ad_agency_zone
      WHERE zoneid=690
      LIMIT 1
  124. 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
  125. SELECT m.*
      FROM jos_menu AS m

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

•Language Files Loaded•

•Untranslated Strings Diagnostic•

NO	JHTMLSelect::booleanlist()	[:]
YES	JHTMLSelect::booleanlist()	[:]

•Untranslated Strings Designer•


# ??Unknown file??

NO=no
YES=yes