Red Drum Fishing •E-mail•
••Sunday•, 24 •January• 2010 07:09•
Sciaenops ocellatus aka the red drum can be found in both the Atlantic Ocean and gulf of Mexico as far north as Delaware and as far south as Mexico. They are found in inshore waters and feed on fish and crustaceans.
They prefer water temps of 65-85 degrees but can be found and sometimes caught in their sluggish state in the winter.

Winter

As the water gets colder bait will become so hard to find that lures may become the only option that is unless you have access to a warm water discharge. But lures cover more water, which is better in the winter to find these scattered fish. When the water gets cooler it will also become clearer giving excellent sight casting opportunities to fish warming themselves on flats. When you see these fish they will not chase a lure down all the time. In this situation you want to throw the lure, preferably a jig head with some type of plastic, past the fish and drag it right past his nose, creating a puff of sand while dragging it. These fish will usually not turn up a good meal that sits right in front of them. Just think of it as if your sitting on the couch and a big mac plops on your lap. Are you going to just leave it there? No, you'll gobble it up like it was nothing. The other main type of fishing I will do in the winter is to fish mud flats. The fish will stack up on these flats because they retain heat in the winter. I fish the drop offs of these flats by fishing suspending jerk bait's such as a lucky craft or x rap. I use colors such as a Halloween candy(orange, gold, and black) or a natural mullet color. On these drop offs I also like to fish spinner baits with a large, gold, Colorado blade by slow rolling it off the shallow parts then letting it drop when it hits a ledge.


Spring

As the water starts to warm and bait starts to filter into the marshes the redfish come out in the marsh in full force gobbling up everything in sight. This is when I like to fish a combination of lures. I have two main luresI key in on in the spring my first would have to be a top water lure, my favorite being a rapala skitter walk with a bone colored back, chartreuse belly and silver sides, my second would be any spinner bait with a large, gold, Colorado blade. I will fish the top water on the slopes of oyster beds where redfish love to ambush the mullet cruising the beds. I will also fish it over grass beds and mud flats where fish are crashing bait hiding in the grass and cruising the surface of the water on the flats. I love using a spinner bait during this season the most, because I am able to fish it fast and constant therefore I cover a lot of water and coming across more schools of fish. Over the grass beds also love using weedless rigged flukes in white or albino colors to imitate the mullet. I either work them erratically or let it flutter into the grass and rip it out then let it fall back down rip out and repeat. This ripping out usually trigger a strike from fish waiting in the grass for a minnow to come swimming by. Another great tactic in fishing these grass flats is to use a recoil rig with a fluke and throw it right in the grass and just work the line with your finger so the lure dances in its place right above the grass imitating an injured minnow.

Summer

During summer the best times to fish will be the coolest times of the day; that being sunset and sunrise. During these two times I prefer to fish a top water because you will notice around these same times, mullet will skitter the surface fleeing schools of redfish cruising every square inch of the water looking for a good meal. Another great lure to fish at low light times is a spinner bait since these fish will not have that great visiblity at this time and they will key in on the vibration of the blade, but when they come in closer they will see the profile of the soft plastic which is what seals the deal. During the day I go to rip rap formations and jetties and throw deep diving crank baits such as a DT sure set rapala. I like to throw directly at the rip rap from open water and use a steady action working the lure down and most bites will come when the bottom changes from rocks to mud. I also fish backwater sand flats that are about 3-5 foot deep in water with little to no boat activity. These fish have had almost no interaction with a hook and are on these flats cooling off. On these flats it is usually very clear and this is where I do my sight casting in the summer. I rig up a ½ ounce jig head with a shrimp imitating plastic. I toss this past a school of fish then drag it right into their path. I land many upper slot and 30 inch redfish throughout the summer using this technique.


Fall

Fall is the complete opposite of spring. The water is cooling down and the fish are on their way out. I usually start fishing hard starting early September for this fall run of fish. I like to go into the backs of inlets and work gold spoons in grass flats and the marshes with a plastic trailer. I will let it flutter down then give it a few twitches then flutter and repeat. Most fish will come off the flutter of the spoon. I use top water baits paralleling the shoreline and use a Halloween color, very fitting to the time of year as well. In fall there are sight casting opportunities on sandy beaches where the fish are sitting in the sloughs and I cast a jig head rigged with a crab imitation and drag it right past them. It imitates a crab trying to bury itself in the sand. I setup parallel to a dock and cast directly down the line of pilings using a recoil rig with a fluke and work each and every piling waiting for a redfish to pop out of the dock to ambush my lure. I usually have amazing success doing this averaging 5-8 fish per dock. During the end of fall going into winter I fish along beaches casting towards the beach working a spinner bait, rapala sub-walk, or DOA shrimp working the slough picking up migrating fish headed south for the winter.



 

•Comments•  

 
0 #1 Guest •2010-02-10 16:24•
Great article that covers the entire year.Keep the articles coming.
 
 
0 #2 NH Explorer •2010-02-10 17:25•
Very nice article Kyle, even I could understand it ;-) . Looking forward to trying some of your tactics when I get down your way...probably for the TKAA Tourney.
Keep up the fishing and good writing. Roger
 
 
0 #3 Guest •2010-02-10 18:40•
Roger, I'll be fishing the tournament as always, look forward to seeing you there!
 
 
0 #4 Guest •2010-02-10 18:42•
Roger, thanks, and I look forward to meeting you there!
 

You must be registered to post a comment.


Login

Newsletter

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

Most Popular

Choosing a Fishing Kayak
Like many kayak fisherman, my first fishig kayak was a mistake and I only used it a few times.  There wasn’t a lot of information available.  Things have...
Effective Trolling With Your Kayak
  While trolling is a mainstay of saltwater fishermen and also popular for targeting suspended fish in deepwater lakes of the northern US and Canada, it’s not the way most...
Electric Kayaks – an in Depth Look
Bassyaks, Torqeedo and Torque I have been living with electric kayaks (EK) since July of 2009. I have done so in order to get a much better understanding of their potential,...

Random

Texas Road Trip - Part 2
The mecca of kayak fishing in the Port Aransas area. It was time to head up to Corpus Christi . Slowride Guide Services and Kayak Rentals (www.slowrideguide.com) is just north of...
Baby Boomers and Kayak Fishing - Part 3
Part III: Launching and Paddling your Yak The shallow beach ripples with a light chop as you approach your kayak, making for a promising day on the water. But then it hits you,...
Kayak Fishing Safety Learned from Experience
In reflecting back on my past 11 years of kayak fishing I can easily fire off a bunch of stories of great fishing days on the water. In that memory collage I can also remember...

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.078 seconds, 6.62 MB
Application afterRoute: 0.104 seconds, 8.67 MB
Application afterDispatch: 0.395 seconds, 21.51 MB
Application afterRender: 0.998 seconds, 50.75 MB

•Memory Usage•

53282896

•116 queries logged•

  1. SELECT *
      FROM jos_session
      WHERE session_id = '12314d43ec96565049e6efc088422b38'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1436182731' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = '12314d43ec96565049e6efc088422b38'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( '12314d43ec96565049e6efc088422b38','1436212731','','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 = 1080
      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 19:58:51' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2015-07-06 19:58:51' )   )    OR  ( a.state = -1 )  )
  12. UPDATE jos_content
      SET hits = ( hits + 1 )
      WHERE id='1080'
  13. SELECT
                published, params
           
      FROM
                jos_plugins
           
      WHERE
                element = 'jreviews'
      AND folder = 'content'
      LIMIT 1
  14. SELECT catid
      FROM jos_content
      WHERE id = 1080
  15. SELECT
                        COUNT(*)
                   
      FROM
                        jos_jreviews_categories AS Category
                   
      WHERE
                        Category.OPTION = 'com_content'
                       
      AND
                        Category.id = 102
  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='64'
      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='64'
      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 19:58:51',a.checkdate))
      ORDER BY checkdate
      LIMIT 0,5
  26. SELECT *
      FROM jos_ijseo_keys AS a
      WHERE 1<=(SELECT DATEDIFF('2015-07-06 19:58:51',a.checkdate))
      ORDER BY checkdate
      LIMIT 0,5
  27. SELECT COUNT(*)

      FROM jos_jcomments_blacklist AS bl

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

      FROM jos_jcomments AS c

      WHERE c.object_id = 1080
      AND c.object_group = 'com_content'
      AND c.published = 1
  30. SELECT c.id, c.parent, c.object_id, c.object_group, c.userid, c.name, c.username, c.title, c.comment
    , c.email, c.homepage, c.DATE, c.DATE AS datetime, c.ip, c.published, c.deleted, c.checked_out, c.checked_out_time
    , c.isgood, c.ispoor
    , v.VALUE AS voted
    , CASE WHEN c.parent = 0 THEN unix_timestamp(c.DATE) ELSE 0 END AS threaddate, '' AS object_title, '' AS object_link, 0 AS object_access, 0 AS object_owner

      FROM jos_jcomments AS c

      LEFT JOIN jos_jcomments_votes AS v
      ON c.id = v.commentid  
      AND v.userid = 0
      AND v.ip = '54.166.227.36'

      WHERE c.object_id = 1080
      AND c.object_group = 'com_content'
      AND c.published = 1

      ORDER BY c.DATE ASC

      LIMIT 0, 40
  31. SELECT menutype, id, name, link  
      FROM jos_menu  
      WHERE id = 578
  32. SELECT menutype
      FROM jos_menu
      WHERE  1=1  
      AND link LIKE '%option=com_content%'
      AND link LIKE '%view=article%'
      AND link LIKE '%id=1080:red-drum-fishing%'
      AND published=1
  33. SELECT menutype
      FROM jos_menu
      WHERE  1=1  
      AND link LIKE '%option=com_content%'
      AND link LIKE '%view=article%'
      AND link LIKE '%id=1080:red-drum-fishing%'
      AND published=1
  34. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_content&view=article&id=1080'
  35. SELECT id
      FROM jos_menu
      WHERE link='index.php?option=com_content&view=article&id=1080'
  36. SELECT t.*, c.*  
      FROM jos_ijseo_title t  JOIN jos_content c
      ON t.id = c.id  
      WHERE t.id = '1080'
  37. SELECT t.*, c.*  
      FROM jos_ijseo_title t  JOIN jos_content c
      ON t.id = c.id  
      WHERE t.id = '1080'
  38. SELECT menutype
      FROM jos_menu
      WHERE  1=1  
      AND link LIKE '%option=com_content%'
      AND link LIKE '%view=article%'
      AND link LIKE '%id=1080:red-drum-fishing%'
      AND published=1
  39. SELECT menutype
      FROM jos_menu
      WHERE  1=1  
      AND link LIKE '%option=com_content%'
      AND link LIKE '%view=article%'
      AND link LIKE '%id=1080:red-drum-fishing%'
      AND published=1
  40. SELECT t.*, c.*  
      FROM jos_ijseo_title t  JOIN jos_content c
      ON t.id = c.id  
      WHERE t.id = '1080'
  41. SELECT t.*, c.*  
      FROM jos_ijseo_title t  JOIN jos_content c
      ON t.id = c.id  
      WHERE t.id = '1080'
  42. SELECT t.*, c.*  
      FROM jos_ijseo_title t  JOIN jos_content c
      ON t.id = c.id  
      WHERE t.id = '1080'
  43. SELECT j_user_id
      FROM jos_jfbconnect_user_map
      WHERE fb_user_id=''
  44. 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
  45. SELECT *
      FROM jos_ninjarsssyndicator_feeds
      WHERE published = 1
      AND (id = 1)
      ORDER BY feed_name

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

  70.   SET SQL_BIG_SELECTS=1
  71. SELECT
                            id
                       
      FROM
                            jos_menu
                       
      WHERE
                            link LIKE "%com_comprofiler"
      AND published = 1
      AND TYPE = "component"
  72. 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:58") )
       
      AND ( Listing.publish_down = "0000-00-00 00:00:00" OR DATE(Listing.publish_down) >= DATE("2015-07-06 19:58") )
       
      AND Category.access <= 0
       
      AND Listing.access <= 0
       
      AND Listing.sectionid IN (55)
       
      AND Review.published > 0
     )
     
      ORDER BY `Review.created` DESC
     
      LIMIT 12
  73. 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)
     )
  74. SELECT *
     
      FROM jos_comprofiler AS Community
     
      WHERE 1 = 1
      AND (
       user_id IN (4698)
     )
  75. 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
  76. 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)
     )
  77. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (4,3)
     
      AND TYPE = 'content'
  78. 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
  79. 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)
  80. 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
  81. SELECT *
     
      FROM jos_comprofiler AS Community
     
      WHERE 1 = 1
      AND (
       user_id IN (9176,7293,9022,9000,8886,8861,8725,8678,8631,8421,407)
     )
  82. 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)
     )
  83. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (4,3)
     
      AND TYPE = 'review'
  84. SELECT username
      FROM jos_users
      WHERE id = 9176
      LIMIT 0, 1
  85. SELECT username
      FROM jos_users
      WHERE id = 9176
      LIMIT 0, 1
  86. SELECT username
      FROM jos_users
      WHERE id = 7293
      LIMIT 0, 1
  87. SELECT username
      FROM jos_users
      WHERE id = 9022
      LIMIT 0, 1
  88. SELECT username
      FROM jos_users
      WHERE id = 9000
      LIMIT 0, 1
  89. SELECT username
      FROM jos_users
      WHERE id = 8886
      LIMIT 0, 1
  90. SELECT username
      FROM jos_users
      WHERE id = 8861
      LIMIT 0, 1
  91. SELECT username
      FROM jos_users
      WHERE id = 8725
      LIMIT 0, 1
  92. SELECT username
      FROM jos_users
      WHERE id = 8678
      LIMIT 0, 1
  93. SELECT username
      FROM jos_users
      WHERE id = 8631
      LIMIT 0, 1
  94. SELECT username
      FROM jos_users
      WHERE id = 8421
      LIMIT 0, 1
  95. SELECT username
      FROM jos_users
      WHERE id = 407
      LIMIT 0, 1
  96. SELECT id
      FROM jos_menu
      WHERE link LIKE 'index.php?option=com_comprofiler&task=registers%'
      AND published = 1
      AND access IN (0)
  97. SELECT `id`
     
      FROM `jos_groups`
     
      WHERE `id` <= 0
     
      ORDER BY `id`
  98. 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
  99. SELECT *
      FROM jos_acymailing_config
  100. SELECT *
      FROM jos_acymailing_list
      WHERE TYPE = 'list'  
      ORDER BY ordering ASC
  101. SELECT *
      FROM jos_ad_agency_settings
      LIMIT 1
  102. SELECT *
      FROM jos_ad_agency_zone
      WHERE zoneid=687
      LIMIT 1
  103. SELECT *
      FROM jos_ad_agency_settings
      LIMIT 1
  104. SELECT *
      FROM jos_ad_agency_zone
      WHERE zoneid=783
      LIMIT 1
  105. 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 = 1080
  106. 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 != 1080
      AND a.state = 1
      AND a.access <= 0
      AND (  CONCAT(",", REPLACE(a.metakey,", ",","),",") LIKE "%,Red Drum Fishing,%" OR CONCAT(",", REPLACE(a.metakey,", ",","),",") LIKE "%,Kyle Sawyer,%" OR a.catid = '102'  )
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2015-07-06 19:58:51' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2015-07-06 19:58:51' )  
      AND a.sectionid IN(38)
      AND a.catid IN (102)
      ORDER BY random
      LIMIT 0, 10
  107. SELECT *
      FROM jos_content
      WHERE id = '1080'
  108. 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 19:58:51' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2015-07-06 19:58:51' )
      AND f.content_id IS NULL
      AND a.id!=1080
      AND s.id > 0
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND cc.id=102
      AND s.published = 1
      AND cc.published = 1
      ORDER BY a.hits DESC
      LIMIT 0, 3
  109. SELECT *
      FROM jos_content
      WHERE id = '1080'
  110. 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 19:58:51' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2015-07-06 19:58:51' )
      AND f.content_id IS NULL
      AND a.id!=1080
      AND s.id > 0
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND cc.id=102
      AND s.published = 1
      AND cc.published = 1
      ORDER BY rand()
      LIMIT 0, 3
  111. SELECT *
      FROM jos_ad_agency_settings
      LIMIT 1
  112. SELECT *
      FROM jos_ad_agency_zone
      WHERE zoneid=690
      LIMIT 1
  113. 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
  114. SELECT m.*
      FROM jos_menu AS m

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

•Language Files Loaded•

•Untranslated Strings Diagnostic•

•None•

•Untranslated Strings Designer•

•None•