New Report Highlights Recreational Fishing’s Broad Economic and Conservation Impact •E-mail•
••Thursday•, 10 •January• 2013 09:33•

AmericanSportsfishingAssociation

Anglers' expenditures have a significant impact on the nation's economy

Alexandria, VA – January 10, 2013 – Recreational fishing is more than just a pleasant getaway for millions of Americans. As an industry, it provides a living for countless people in businesses ranging from fishing tackle and boating manufacturing to travel and hospitality to publications, magazines and much more. As reported in Sportfishing in America: An Economic Force for Conservation, a new fishing statistics report produced by the American Sportfishing Association (ASA), the trade association that represents the sportfishing industry, the number of anglers increased 11 percent over the past five years and fishing tackle sales grew more than 16 percent. When expenditures are multiplied by our nation's 60 million anglers, their dollars have a significant impact on our nation's economy.

Sportfishing in America: An Economic Force for Conservation highlights how recreational fishing not only endures as an activity that permeates all social and economic aspects of Americans' lives, but also plays a significant role in the country's most successful fisheries conservation efforts.

"As an industry, we are keenly aware of the impact that sportfishing has on this nation's economy," said ASA President and CEO Mike Nussman. "Just by enjoying a day on the water, men, women and children across the United States pump billions of dollars into this country's economy."

Nussman further said, "And it's not just the economy. In many ways, America's anglers are the nation's most powerful force for conserving our nation's fisheries and waters, investing more than $1 billion dollars each year in fisheries management and conservation through taxes on fishing equipment and state fishing license sales."

According to the new study, America's nearly 60 million anglers are estimated to spend $46 billion per year on fishing equipment, transportation, lodging and other expenses associated with their sport. With a total annual economic impact of $115 billion, fishing supports more than 828,000 jobs and generates $35 billion in wages and $15 billion in federal and state taxes. Despite the economic difficulties facing the U.S. economy over the past five years; the total amount spent on sportfishing, which encompasses tackle, travel and other equipment, grew five percent.

A number of reports strongly indicate that fishing is identified by American families as one of the best ways to spend quality time together. According to the National Sporting Goods Association, fishing as a leisure-time activity ranks higher than playing basketball or softball, skateboarding, jogging or hiking.

"Despite the uncertain economic conditions that beset all Americas, or because of it, anglers continue to fish and spend even more time outdoors," said ASA Vice President Gordon Robertson. "A growing interest in the outdoors helped fuel the growth in angler numbers which we believe will create even more momentum in fishing participation and sales in 2013 and beyond."

Substantially more than any other groups, anglers support the nation's conservation efforts through the Sport Fish Restoration and Boating Trust Fund Program. Special taxes on fishing gear and motorboat fuel channel more than $1 billion of anglers' dollars to state fish and wildlife conservation and recreation programs each year.

ASA's new analysis is based on data from the 2011 National Survey of Fishing, Hunting and Wildlife-Associated Recreation, conducted every five years on behalf of the Association of Fish and Wildlife Agencies by the Census Bureau and the U.S. Fish and Wildlife Service. Sportfishing in America was compiled for ASA by Southwick Associates, Fernandina Beach, Fla.

Facts about Recreational Fishing

There are approximately 60 million anglers in the U.S. of which 46 million are estimated to fish in a given year.

One of every four anglers fishes in saltwater.

Fishing tackle sales grew over 16 percent in the past five years.

Since 2006, angler numbers grew 11 percent

More Americans fish than play golf (21 million) and tennis (13 million) combined.

If fishing were a company, the amount spent by anglers to support fishing-related retail sales would rank number 51 on the Fortune 500™ list.

Fishing generated more revenue ($48 billion) than Lockheed Martin ($47 billion), Intel ($44 billion), Chrysler ($42 billion) or Google ($38 billion).

The economic activity generated by sportfishing is greater than the economy, measured in Gross State Product, of 17 states.

At more than 46 million anglers, more than twice the number of people fished in 2011 than attended every NFL game combined.

###

The American Sportfishing Association (ASA) is the sportfishing industry's trade association committed to representing the interests of the entire sportfishing community. We give the industry a unified voice, speaking out on behalf of sportfishing and boating industries, state and federal natural resource agencies, conservation organizations, angler advocacy groups and outdoor journalists when emerging laws and policies could significantly affect sportfishing business or sportfishing itself. ASA invests in long-term ventures to ensure the industry will remain strong and prosperous, as well as safeguard and promote the enduring social, economic and conservation values of sportfishing in America. ASA also gives America's 60 million anglers a voice in policy decisions that affect their ability to sustainably fish on our nation's waterways through KeepAmericaFishing™, our angler advocacy campaign. America's anglers generate over $46 billion in retail sales with a $115 billion impact on the nation's economy creating employment for more than 828,000 people.

 

You must be registered to post a comment.


Login

Newsletter

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

Most Popular

Kayak Kevin's; Kayak Fishing the Chesapeake Bay 2 DVD Trailer
This, the 2nd installment to the widely popular "Kayak Fishing the Chesapeake Bay" DVD from award winning videographer Kevin Whitley (aka Kayak Kevin) is due for release this fall...
KFM - FaceBook Kayak Fishing Picture Contest Results
We thought it would be a good idea to use Facebook to have a photo contest. Our friends over at Hook, Line and Paddle (HLP) asked us how we can do something together on FB.
Pelican Premium: A little more buck, a lot more bang!
For Immediate Release LAVAL, QUEBEC. April 19, 2013. Pelican International's highly anticipated Premium line does not disappoint! Pelican International's new Premium line of...

Random

Kayak Fishing Tip
What's the difference between these braid scissors?  It ranges anywhere from $3 and $5 depending on where you buy them.  The pair on the left are marketed and sold as braid...
Incipio® Expands Ultra Rugged Waterproof Case Offerings
IRVINE, CA – July 31, 2013 – Incipio®, designer and manufacturer of award-winning mobile device accessories, expands their ultra-rugged case collection with additional form...
Kayak Fishing Classics, Next up; 10,000 Islands
       10,000 Islands & Nowhere to Hide   By KFC staff journalist   The Kayak Fishing ClassicS’ next tournament series stop is in...

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.073 seconds, 6.62 MB
Application afterRoute: 0.092 seconds, 8.67 MB
Application afterDispatch: 0.343 seconds, 20.83 MB
Application afterRender: 0.840 seconds, 50.06 MB

•Memory Usage•

52560400

•115 queries logged•

  1. SELECT *
      FROM jos_session
      WHERE session_id = '96139c73a199e1c2213ab568cac7d3d4'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1436190464' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = '96139c73a199e1c2213ab568cac7d3d4'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( '96139c73a199e1c2213ab568cac7d3d4','1436220464','','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 = 578)
      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  , ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count
      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
      LEFT JOIN jos_content_rating AS v
      ON a.id = v.content_id
      WHERE a.id = 1562
      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-06 22:07:44' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2015-07-06 22:07:44' )   )    OR  ( a.state = -1 )  )
  12. UPDATE jos_content
      SET hits = ( hits + 1 )
      WHERE id='1562'
  13. SELECT
                published, params
           
      FROM
                jos_plugins
           
      WHERE
                element = 'jreviews'
      AND folder = 'content'
      LIMIT 1
  14. SELECT catid
      FROM jos_content
      WHERE id = 1562
  15. SELECT
                        COUNT(*)
                   
      FROM
                        jos_jreviews_categories AS Category
                   
      WHERE
                        Category.OPTION = 'com_content'
                       
      AND
                        Category.id = 325
  16. 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='4698'
      ORDER BY g.id
  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=23
  20. SELECT id, parent_id, VALUE, name, lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE id=25
  21. 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='4698'
      ORDER BY g.id
  22. SELECT id, parent_id, VALUE, name, lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE id=23
  23. SELECT MAX(checkdate)
      FROM jos_ijseo_keys
      LIMIT 0,1
  24. SELECT MAX(checkdate)
      FROM jos_ijseo_keys
      LIMIT 0,1
  25. SELECT *
      FROM jos_ijseo_keys AS a
      WHERE 1<=(SELECT DATEDIFF('2015-07-06 22:07:44',a.checkdate))
      ORDER BY checkdate
      LIMIT 0,5
  26. SELECT *
      FROM jos_ijseo_keys AS a
      WHERE 1<=(SELECT DATEDIFF('2015-07-06 22:07:44',a.checkdate))
      ORDER BY checkdate
      LIMIT 0,5
  27. SELECT COUNT(*)

      FROM jos_jcomments_blacklist AS bl

      WHERE bl.ip = '54.159.111.156'
  28. SELECT *  
      FROM `jos_jcomments_objects`
      WHERE `object_id` = '1562'
      AND `object_group` = 'com_content'
      AND `lang` = 'en-GB'
  29. SELECT COUNT(*)

      FROM jos_jcomments AS c

      WHERE c.object_id = 1562
      AND c.object_group = 'com_content'
      AND c.published = 1
  30. SELECT menutype, id, name, link  
      FROM jos_menu  
      WHERE id = 578
  31. SELECT menutype
      FROM jos_menu
      WHERE  1=1  
      AND link LIKE '%option=com_content%'
      AND link LIKE '%view=article%'
      AND link LIKE '%id=1562:new-report-highlights-recreational-fishings-broad-economic-and-conservation-impact%'
      AND published=1
  32. SELECT menutype
      FROM jos_menu
      WHERE  1=1  
      AND link LIKE '%option=com_content%'
      AND link LIKE '%view=article%'
      AND link LIKE '%id=1562:new-report-highlights-recreational-fishings-broad-economic-and-conservation-impact%'
      AND published=1
  33. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_content&view=article&id=1562'
  34. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_content&view=article&id=1562'
  35. SELECT t.*, c.*  
      FROM jos_ijseo_title t  JOIN jos_content c
      ON t.id = c.id  
      WHERE t.id = '1562'
  36. SELECT t.*, c.*  
      FROM jos_ijseo_title t  JOIN jos_content c
      ON t.id = c.id  
      WHERE t.id = '1562'
  37. SELECT menutype
      FROM jos_menu
      WHERE  1=1  
      AND link LIKE '%option=com_content%'
      AND link LIKE '%view=article%'
      AND link LIKE '%id=1562:new-report-highlights-recreational-fishings-broad-economic-and-conservation-impact%'
      AND published=1
  38. SELECT menutype
      FROM jos_menu
      WHERE  1=1  
      AND link LIKE '%option=com_content%'
      AND link LIKE '%view=article%'
      AND link LIKE '%id=1562:new-report-highlights-recreational-fishings-broad-economic-and-conservation-impact%'
      AND published=1
  39. SELECT t.*, c.*  
      FROM jos_ijseo_title t  JOIN jos_content c
      ON t.id = c.id  
      WHERE t.id = '1562'
  40. SELECT t.*, c.*  
      FROM jos_ijseo_title t  JOIN jos_content c
      ON t.id = c.id  
      WHERE t.id = '1562'
  41. SELECT t.*, c.*  
      FROM jos_ijseo_title t  JOIN jos_content c
      ON t.id = c.id  
      WHERE t.id = '1562'
  42. SELECT j_user_id
      FROM jos_jfbconnect_user_map
      WHERE fb_user_id=''
  43. 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 = 578 OR mm.menuid = 0 )
      ORDER BY POSITION, ordering
  44. SELECT *
      FROM jos_ninjarsssyndicator_feeds
      WHERE published = 1
      AND (id = 1)
      ORDER BY feed_name

  45.   SET SQL_BIG_SELECTS=1
  46. SELECT
                            id
                       
      FROM
                            jos_menu
                       
      WHERE
                            link LIKE "%com_comprofiler"
      AND published = 1
      AND TYPE = "component"
  47. 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 22:07") )
       
      AND ( Listing.publish_down = "0000-00-00 00:00:00" OR DATE(Listing.publish_down) >= DATE("2015-07-06 22:07") )
       
      AND Category.access <= 0
       
      AND Listing.access <= 0
       
      AND Listing.sectionid IN (52)
       
      AND Review.published > 0
     )
     
      ORDER BY `Review.created` DESC
     
      LIMIT 12
  48. 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)
     )
  49. SELECT
                            id
                       
      FROM
                            jos_menu
                       
      WHERE
                            link LIKE "%com_comprofiler"
      AND published = 1
      AND TYPE = "component"
  50. SELECT *
     
      FROM jos_comprofiler AS Community
     
      WHERE 1 = 1
      AND (
       user_id IN (62,63,7026,5782,4698)
     )
  51. 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
  52. 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)
     )
  53. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (3,3,5)
     
      AND TYPE = 'content'
  54. 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
  55. 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)
  56. SELECT *
     
      FROM jos_comprofiler AS Community
     
      WHERE 1 = 1
      AND (
       user_id IN (8333,8332,5782,4698,8182,7660,7026,7814)
     )
  57. 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)
     )
  58. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (3,3,5)
     
      AND TYPE = 'review'
  59. SELECT username
      FROM jos_users
      WHERE id = 8333
      LIMIT 0, 1
  60. SELECT username
      FROM jos_users
      WHERE id = 8332
      LIMIT 0, 1
  61. SELECT username
      FROM jos_users
      WHERE id = 5782
      LIMIT 0, 1
  62. SELECT username
      FROM jos_users
      WHERE id = 5782
      LIMIT 0, 1
  63. SELECT username
      FROM jos_users
      WHERE id = 4698
      LIMIT 0, 1
  64. SELECT username
      FROM jos_users
      WHERE id = 8182
      LIMIT 0, 1
  65. SELECT username
      FROM jos_users
      WHERE id = 5782
      LIMIT 0, 1
  66. SELECT username
      FROM jos_users
      WHERE id = 7660
      LIMIT 0, 1
  67. SELECT username
      FROM jos_users
      WHERE id = 7026
      LIMIT 0, 1
  68. SELECT username
      FROM jos_users
      WHERE id = 7814
      LIMIT 0, 1

  69.   SET SQL_BIG_SELECTS=1
  70. SELECT
                            id
                       
      FROM
                            jos_menu
                       
      WHERE
                            link LIKE "%com_comprofiler"
      AND published = 1
      AND TYPE = "component"
  71. 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 22:07") )
       
      AND ( Listing.publish_down = "0000-00-00 00:00:00" OR DATE(Listing.publish_down) >= DATE("2015-07-06 22:07") )
       
      AND Category.access <= 0
       
      AND Listing.access <= 0
       
      AND Listing.sectionid IN (55)
       
      AND Review.published > 0
     )
     
      ORDER BY `Review.created` DESC
     
      LIMIT 12
  72. 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)
     )
  73. SELECT *
     
      FROM jos_comprofiler AS Community
     
      WHERE 1 = 1
      AND (
       user_id IN (4698)
     )
  74. 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
  75. 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)
     )
  76. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (4,3)
     
      AND TYPE = 'content'
  77. 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
  78. 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)
  79. 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
  80. SELECT *
     
      FROM jos_comprofiler AS Community
     
      WHERE 1 = 1
      AND (
       user_id IN (9176,7293,9022,9000,8886,8861,8725,8678,8631,8421,407)
     )
  81. 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)
     )
  82. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (4,3)
     
      AND TYPE = 'review'
  83. SELECT username
      FROM jos_users
      WHERE id = 9176
      LIMIT 0, 1
  84. SELECT username
      FROM jos_users
      WHERE id = 9176
      LIMIT 0, 1
  85. SELECT username
      FROM jos_users
      WHERE id = 7293
      LIMIT 0, 1
  86. SELECT username
      FROM jos_users
      WHERE id = 9022
      LIMIT 0, 1
  87. SELECT username
      FROM jos_users
      WHERE id = 9000
      LIMIT 0, 1
  88. SELECT username
      FROM jos_users
      WHERE id = 8886
      LIMIT 0, 1
  89. SELECT username
      FROM jos_users
      WHERE id = 8861
      LIMIT 0, 1
  90. SELECT username
      FROM jos_users
      WHERE id = 8725
      LIMIT 0, 1
  91. SELECT username
      FROM jos_users
      WHERE id = 8678
      LIMIT 0, 1
  92. SELECT username
      FROM jos_users
      WHERE id = 8631
      LIMIT 0, 1
  93. SELECT username
      FROM jos_users
      WHERE id = 8421
      LIMIT 0, 1
  94. SELECT username
      FROM jos_users
      WHERE id = 407
      LIMIT 0, 1
  95. SELECT id
      FROM jos_menu
      WHERE link LIKE 'index.php?option=com_comprofiler&task=registers%'
      AND published = 1
      AND access IN (0)
  96. SELECT `id`
     
      FROM `jos_groups`
     
      WHERE `id` <= 0
     
      ORDER BY `id`
  97. 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
  98. SELECT *
      FROM jos_acymailing_config
  99. SELECT *
      FROM jos_acymailing_list
      WHERE TYPE = 'list'  
      ORDER BY ordering ASC
  100. SELECT *
      FROM jos_ad_agency_settings
      LIMIT 1
  101. SELECT *
      FROM jos_ad_agency_zone
      WHERE zoneid=687
      LIMIT 1
  102. SELECT *
      FROM jos_ad_agency_settings
      LIMIT 1
  103. SELECT *
      FROM jos_ad_agency_zone
      WHERE zoneid=783
      LIMIT 1
  104. SELECT a.metakey, a.sectionid, a.catid, a.created_by, a.created_by_alias, cc.title AS category_title, u.name AS author  
      FROM jos_content AS a
      LEFT JOIN jos_categories AS cc
      ON cc.id = a.catid
      LEFT JOIN jos_users AS u
      ON u.id = a.created_by
      WHERE a.id = 1562
  105. SELECT a.id, a.title, a.introtext, a.created AS DATE,  a.sectionid, a.catid, cc.access AS cat_access, a.created_by, a.created_by_alias, u.name AS author,  s.access AS sec_access, cc.published AS cat_state, s.published AS sec_state, 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, cc.title AS category_title, a.introtext AS introtext_raw, a.fulltext, s.title AS section_title, rand() AS random,  a.metakey, "0" AS match_count, "" AS match_list  
      FROM jos_content AS a
      LEFT JOIN jos_content_frontpage AS f
      ON f.content_id = a.id
      LEFT JOIN jos_categories AS cc
      ON cc.id = a.catid
      LEFT JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON u.id = a.created_by
      WHERE a.id != 1562
      AND a.state = 1
      AND a.access <= 0
      AND (  CONCAT(",", REPLACE(a.metakey,", ",","),",") LIKE "%,Fishing economic impact,%" OR CONCAT(",", REPLACE(a.metakey,", ",","),",") LIKE "%,American Sportsfishing Associations,%" OR CONCAT(",", REPLACE(a.metakey,", ",","),",") LIKE "%,Sportfishing in America: An Economic Force for Conservation,%" OR a.catid = '325'  )
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2015-07-06 22:07:44' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2015-07-06 22:07:44' )  
      AND a.sectionid IN(38)
      AND a.catid IN (325)
      ORDER BY random
      LIMIT 0, 10
  106. SELECT *
      FROM jos_content
      WHERE id = '1562'
  107. SELECT a.*, cc.title AS catname, s.title AS secname, s.id 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
      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
      LEFT JOIN jos_content_frontpage AS f
      ON f.content_id = a.id
      WHERE a.state = 1
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2015-07-06 22:07:44' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2015-07-06 22:07:44' )
      AND f.content_id IS NULL
      AND a.id!=1562
      AND s.id > 0
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND cc.id=325
      AND s.published = 1
      AND cc.published = 1
      ORDER BY a.hits DESC
      LIMIT 0, 3
  108. SELECT *
      FROM jos_content
      WHERE id = '1562'
  109. SELECT a.*, cc.title AS catname, s.title AS secname, s.id 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
      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
      LEFT JOIN jos_content_frontpage AS f
      ON f.content_id = a.id
      WHERE a.state = 1
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2015-07-06 22:07:44' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2015-07-06 22:07:44' )
      AND f.content_id IS NULL
      AND a.id!=1562
      AND s.id > 0
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND cc.id=325
      AND s.published = 1
      AND cc.published = 1
      ORDER BY rand()
      LIMIT 0, 3
  110. SELECT *
      FROM jos_ad_agency_settings
      LIMIT 1
  111. SELECT *
      FROM jos_ad_agency_zone
      WHERE zoneid=690
      LIMIT 1
  112. 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
  113. SELECT m.*
      FROM jos_menu AS m

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

•Language Files Loaded•

•Untranslated Strings Diagnostic•

•None•

•Untranslated Strings Designer•

•None•