Notice: Undefined variable: output2 in /home/joey2509/public_html/components/com_comprofiler/plugin/user/plug_cbsuperprofileactivity/cb_plugin_superactivity.php on line 944

Notice: Undefined variable: zoomMeTy in /home/joey2509/public_html/components/com_geocode_factory/views/mapcb/tmpl/default.php on line 78
YAKMAN Profile Page
YAKMAN
5743
OFFLINE
6 years ago
3 years ago
4 years ago
9
-
532
3
-
ArticlesPrivate Message

About Me

YAKMAN is a passionate sea kayaker and obsessive kayak angler specializing in light tackle, small craft, inshore and offshore (mothership) fishing.

Some of Al’s immediate goals are to figure out how to make kayak fishing his day job and not his any available minute job. Al is known on most kayak fishing boards as YAKMAN

You can contact Alan at !-- var prefix = 'mailto'; var suffix = ''; var attribs = ''; var path = 'hr' + 'ef' + '='; var addy1440 = 'info' + '@'; addy1440 = addy1440 + 'eastcoastkayakfishing' + '.' + 'com'; document.write( '' ); document.write( addy1440 ); document.write( '' ); // -->info@eastcoastkayakfishing.com

Contact Info

YAKMAN
-

My Details

Multiple
Other
Wilderness Systems Ride 1

Connections

YAKMAN's connections

  Mullet Miller
  SpinfisherBob
  Pat battle-ship
  jrmyln
  Capt Krav
  Justin Hart
  EddyRider
  Shipwreck
  SJ Fish Whisperer
 

ProfileBlog

How important is your kayak fishing seat?

Created On: 09/05/2010 14:39:32
Edited By YAKMAN On: 09/15/2010 04:52:19
Your kayak fishing seat will be the difference between kayak fishing and kayak fishing all day.

A kayak fishing seat might be the second most important thing you buy after your kayak selection. A good kayak fishing seat will even change your experience on that kayak selection.

A good kayak fishing seat will give you the ability to go anywhere in the world where there is a kayak waiting for you and give you the ability to make that kayak, a kayak fishing machine. When ever I travel on vacation near the ocean, I will bring my seat and a travel rod. This gives me the ability within minutes to be fishing and on the water, the rest is easy.

When selecting a kayak fishing seat, I spend some serious time going over how the seat was constructed and attention to details. I like kayak fishing seats that have 1 or 2 rod holders and a small gear pouch.

I have customized my kayak seat to hold a water bladder system so I can stay hydrated while paddling and what is really nice is that I rig up the mouth piece on PFD so I can drink quick and get back to the action

I encourage you to seek out the best kayak fishing seat your budget will support

FISHON!

Kayak Fishing Efficiency - Part 1

Created On: 09/05/2010 05:22:04
What is "Kayak Fishing Efficiency" and why is it important?

Kayak Fishing Efficiency to me is the ability to have all your kayak fishing tools ready to go with a properly equipped kayak for the fish you are targeting. The zen like feeling that the planets and the stars are aligned so your fishing experience will be perfect. The feeling that you have not forgotten your paddle or favorite lure.

It takes awhile for you to get in the zone where you can fish at night or during the day and reach back in your crate with your eyes closed and grab your lip grippers or powerbar. The feeling of having to lines in the water trolling as you throw the metal from the 3rd rod at breaking fish.

Kayak Fishing Efficiency starts with planning and organizing your gear so when your buddy calls and says the Albie's are breaking in the beach lets go, you can leave within minutes and be chasing fish.

My single best suggestion for being more Kayak Fishing Efficient is to do everything, every time the same way.

2010 Point Pleasant Elks Kayak Fishing Tournament registration is open

Created On: 06/10/2010 03:25:21
The 2010 Point Pleasant Elks Kayak Fishing Tournament registration is open May 1, 2010. Registration for the tournament is $50 before July 1, 2010, after July 1, 2010 the registration will be $65. This year we have increased the range the kayak angler can travel, and also changed the rules so you can fish anywhere in New Jersey, but you have to be back at the Elks Lodge by 2:30 to qualify any fish. If you attend the Capts Meeting the night before, you can head to your spot to be ready to fish by sunrise on July 24, 2010. Elks Kayak Fishing Tournament officially starts at sunrise on July 24th, as the rules state you must take a picture of yourself and the unique identifier at sunrise with your boat.

This years winner will go home with a incredible kayak fishing gear package from the event sponsors, add points to there rankings on the ECKFS and potentially be crowned the 1st Annual Nor' East Kayak Fishing Champion!

For the latest information on the Point Pleasant Elks Kayak Fishing Tournament use the links below

East Coast Kayak Fishing Series Information
www.eckfs.com

Point Pleasant Elks Kayak Fishing Tournament
www.eastcoastkayakfishingseries.com/fluke-tournament.html

Jamaica Bay Kayak Fishing Tournament

Created On: 05/21/2010 01:38:13
What a great tournament and festival of kayak fishing. I don't know what I like better hanging with all the people from different areas talking about the fish they catch or fishing in Jamaica Bay. In the shadows of NYC and with the smell of the city, sounds of traffic, airplanes landing and taking off you are in one of the East Coast's top 5 Fisheries. Not only a ultimate fishing destinations but a kayak angler's dream.

I would also like to bring to the attention, and we should all say thank you to The KAYAK FISHING ASSOCIATION OF NEW YORK (KFA-NY). They have spent the last year or so fighting for kayak fishing access to the bay, especially on Cross Bay Blvd and Floyd Bennit Field.

Here is a link to some pictures of the event.
http://www.kayakfishingmagazine.net/gallery.html?func=viewcategory&catid=51

New Jersey Kayak Fishing

Created On: 04/21/2010 14:12:39
New Jersey Right in the middle of it all. NJ offers the best in kayak fishing diversity. Trophy saltwater fisheries compliment the unlimited freshwater potentials.

<< Start < Prev [1] 2 Next > End >>

ProfileWall



This user currently doesn't have any posts.

Profile Activity

This user has been lazy lately! No activity to display...

Location


Primary address

39.9566993
-74.8997116
My Gallery
 

Total number of images: 11
Average rating: 4 (11 votes)

YAKMAN _1
  • YAKMAN _1
  • •Category: Scenic Photos
  • •Hits: 1545•
  • •Rating: 2&00 (1 •Vote•)• 
  • •Comments: 0•
YAKMAN _2
  • YAKMAN _2
  • •Category: Scenic Photos
  • •Hits: 1389•
  • •Rating: •No Votes•• 
  • •Comments: 0•
Hereferd Inlet, Cape May, NJ_1
  • Hereferd Inlet, Cape May, NJ_1
  • •Category: Scenic Photos
  • •Hits: 1447•
  • •Rating: •No Votes•• 
  • •Comments: 0•
Hereferd Inlet, Cape May, NJ_2
  • Hereferd Inlet, Cape May, NJ_2
  • •Category: Scenic Photos
  • •Hits: 1337•
  • •Rating: •No Votes•• 
  • •Comments: 0•
Hereferd Inlet, Cape May, NJ_3
  • Hereferd Inlet, Cape May, NJ_3
  • •Category: Scenic Photos
  • •Hits: 1463•
  • •Rating: •No Votes•• 
  • •Comments: 0•
Wilderness Ride 135, Carbon Pro Light and YAKGEAR Stake Out Pole_1
  • Wilderness Ride 135, Carbon Pro Light and YAKGEAR Stake Out Pole_1
  • •Category: Rigged Kayak Photos
  • •Hits: 12488•
  • •Rating: 5&00 (1 •Vote•)• 
  • •Comments: 0•
Wilderness Ride 135, Carbon Pro Light and YAKGEAR Stake Out Pole_2
  • Wilderness Ride 135, Carbon Pro Light and YAKGEAR Stake Out Pole_2
  • •Category: Rigged Kayak Photos
  • •Hits: 8634•
  • •Rating: •No Votes•• 
  • •Comments: 0•
Wilderness Ride 135, Carbon Pro Light and YAKGEAR Stake Out Pole_3
  • Wilderness Ride 135, Carbon Pro Light and YAKGEAR Stake Out Pole_3
  • •Category: Rigged Kayak Photos
  • •Hits: 16103•
  • •Rating: 5&00 (3 •Votes•)• 
  • •Comments: 0•
Striper Shootout_1
  • Striper Shootout_1
  • •Category: Rigged Kayak Photos
  • •Hits: 5622•
  • •Rating: •No Votes•• 
  • •Comments: 0•
Striper Shootout_2
  • Striper Shootout_2
  • •Category: Rigged Kayak Photos
  • •Hits: 5472•
  • •Rating: •No Votes•• 
  • •Comments: 0•
Striper Shootout_3
  • Striper Shootout_3
  • •Category: Rigged Kayak Photos
  • •Hits: 5719•
  • •Rating: •No Votes•• 
  • •Comments: 0•

Login

Newsletter

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

Latest Kayak Reviews

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

Latest Equipment Reviews

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

•Profile Information•

Application afterLoad: 0.000 seconds, 0.38 MB
Application afterInitialise: 0.069 seconds, 6.62 MB
Application afterRoute: 0.091 seconds, 8.66 MB
Application afterDispatch: 0.977 seconds, 47.61 MB
Application afterRender: 1.223 seconds, 55.02 MB

•Memory Usage•

57758576

•323 queries logged•

  1. SELECT *
      FROM jos_session
      WHERE session_id = '160925a399385f1cc1ac4e6f531dc539'
  2. DELETE
      FROM jos_session
      WHERE ( TIME < '1436190515' )
  3. SELECT *
      FROM jos_session
      WHERE session_id = '160925a399385f1cc1ac4e6f531dc539'
  4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( '160925a399385f1cc1ac4e6f531dc539','1436220515','','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 id
      FROM jos_users
      WHERE username = 'YAKMAN'
      LIMIT 0, 2
  10. SELECT g1.`id` AS group_id, g1.`name`
     
      FROM `jos_core_acl_aro_groups` AS g1
     
      LEFT JOIN `jos_core_acl_aro_groups` AS g2
      ON g2.`lft` >= g1.`lft`
     
      WHERE g2.`id` = 29
     
      ORDER BY g1.`name`
  11. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'USERS'
  12. SELECT g1.id, g1.name, COUNT(g2.name) AS level
      FROM jos_core_acl_aro_groups AS g1
      INNER JOIN jos_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt
      WHERE g1.lft BETWEEN 2
      AND 21
      GROUP BY g1.name
      ORDER BY g1.lft
  13. SELECT `id`
     
      FROM `jos_groups`
     
      WHERE `id` <= 0
     
      ORDER BY `id`
  14. SELECT c.*, u.*
     
      FROM jos_users AS u
     
      LEFT JOIN jos_comprofiler AS c
      ON c.id = u.id
      WHERE u.id = 64
  15. SELECT `id`
     
      FROM `jos_groups`
     
      WHERE `id` <= 0
     
      ORDER BY `id`
  16. 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
  17. SELECT *
      FROM jos_acymailing_config
  18. SELECT `id`
     
      FROM `jos_groups`
     
      WHERE `id` <= 0
     
      ORDER BY `id`
  19. 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 = 'templates'
     
      ORDER BY ordering
  20. SELECT id
      FROM jos_core_acl_aro
      WHERE section_value='users'
      AND VALUE='64'
  21. SELECT          gm.group_id
                           
      FROM            jos_core_acl_groups_aro_map gm
                                   
      WHERE           gm.aro_id=12
  22. SELECT g1.`id` AS group_id, g1.`name`
     
      FROM `jos_core_acl_aro_groups` AS g1
     
      LEFT JOIN `jos_core_acl_aro_groups` AS g2
      ON g2.`lft` >= g1.`lft`
     
      WHERE g2.`id` = 19
     
      ORDER BY g1.`name`
  23. SELECT lft, rgt
      FROM jos_core_acl_aro_groups
      WHERE name = 'USERS'
  24. SELECT g1.id, g1.name, COUNT(g2.name) AS level
      FROM jos_core_acl_aro_groups AS g1
      INNER JOIN jos_core_acl_aro_groups AS g2
      ON g1.lft BETWEEN g2.lft
      AND g2.rgt
      WHERE g1.lft BETWEEN 2
      AND 21
      GROUP BY g1.name
      ORDER BY g1.lft
  25. SELECT `id`
     
      FROM `jos_groups`
     
      WHERE `id` <= 0
     
      ORDER BY `id`
  26. SELECT *
      FROM jos_comprofiler_tabs t
     
      WHERE t.enabled=1
     
      AND t.viewaccesslevel IN (1)
     
      AND t.useraccessgroupid IN (-2,28,29)
     
      ORDER BY t.POSITION, t.ordering
  27. SELECT `id`
     
      FROM `jos_groups`
     
      WHERE `id` <= 0
     
      ORDER BY `id`
  28. SELECT `id`
     
      FROM `jos_groups`
     
      WHERE `id` <= 0
     
      ORDER BY `id`
  29. SELECT id
      FROM jos_menu
      WHERE link = 'index.php?option=com_comprofiler'
      AND published = 1
      AND access IN (0)
  30. SELECT `id`
     
      FROM `jos_groups`
     
      WHERE `id` <= 0
     
      ORDER BY `id`
  31. SELECT `id`
     
      FROM `jos_groups`
     
      WHERE `id` <= 0
     
      ORDER BY `id`
  32. SELECT `id`
     
      FROM `jos_groups`
     
      WHERE `id` <= 0
     
      ORDER BY `id`
  33. SELECT `id`
     
      FROM `jos_groups`
     
      WHERE `id` <= 0
     
      ORDER BY `id`
  34. SELECT `id`
     
      FROM `jos_groups`
     
      WHERE `id` <= 0
     
      ORDER BY `id`
  35. SELECT `id`
     
      FROM `jos_groups`
     
      WHERE `id` <= 0
     
      ORDER BY `id`
  36. SELECT `id`
     
      FROM `jos_groups`
     
      WHERE `id` <= 0
     
      ORDER BY `id`
  37. SELECT *
      FROM jos_joomgallery_config
      WHERE id = '1'
  38. SELECT `id`
     
      FROM `jos_groups`
     
      WHERE `id` <= 0
     
      ORDER BY `id`
  39. SELECT a.id, a.catid, a.title, a.hits,a.created, ROUND( r.rating_sum / r.rating_count ) AS rating,r.rating_count, 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
     
      LEFT JOIN jos_content_rating AS r
      ON r.content_id=a.id
     
      INNER JOIN jos_sections AS s
      ON s.id=a.sectionid
      AND s.title != 'Mamblog'
     
      LEFT JOIN jos_categories AS cc
      ON cc.id = a.catid
     
      WHERE a.created_by=64
     
      AND a.state = 1
     
      AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2015-07-06 13:08:35')
     
      AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2015-07-06 13:08:35')
     
      AND a.access IN (0)
     
      ORDER BY a.created DESC
  40. SELECT *
      FROM jos_content
      WHERE id = '1479'
  41. SELECT *
      FROM jos_content
      WHERE id = '1294'
  42. SELECT *
      FROM jos_content
      WHERE id = '1255'
  43. SELECT *
      FROM jos_content
      WHERE id = '1240'
  44. SELECT *
      FROM jos_content
      WHERE id = '1073'
  45. SELECT *
      FROM jos_content
      WHERE id = '1232'
  46. SELECT *
      FROM jos_content
      WHERE id = '1229'
  47. SELECT *
      FROM jos_content
      WHERE id = '1208'
  48. SELECT *
      FROM jos_content
      WHERE id = '1228'
  49. SELECT *
      FROM jos_content
      WHERE id = '1224'
  50. SELECT *
      FROM jos_content
      WHERE id = '1185'
  51. SELECT *
      FROM jos_content
      WHERE id = '1161'
  52. SELECT *
      FROM jos_content
      WHERE id = '1158'
  53. SELECT *
      FROM jos_content
      WHERE id = '1141'
  54. SELECT *
      FROM jos_content
      WHERE id = '1140'
  55. SELECT *
      FROM jos_content
      WHERE id = '1139'
  56. SELECT *
      FROM jos_content
      WHERE id = '1138'
  57. SELECT *
      FROM jos_content
      WHERE id = '1080'
  58. SELECT *
      FROM jos_content
      WHERE id = '1075'
  59. SELECT *
      FROM jos_content
      WHERE id = '1093'
  60. SELECT *
      FROM jos_content
      WHERE id = '1072'
  61. SELECT *
      FROM jos_content
      WHERE id = '1070'
  62. SELECT *
      FROM jos_content
      WHERE id = '1065'
  63. SELECT *
      FROM jos_content
      WHERE id = '1063'
  64. SELECT *
      FROM jos_content
      WHERE id = '1049'
  65. SELECT *
      FROM jos_content
      WHERE id = '998'
  66. SELECT *
      FROM jos_content
      WHERE id = '999'
  67. SELECT *
      FROM jos_content
      WHERE id = '860'
  68. SELECT *
      FROM jos_content
      WHERE id = '714'
  69. SELECT *
      FROM jos_content
      WHERE id = '1322'
  70. SELECT *
      FROM jos_content
      WHERE id = '1325'
  71. SELECT *
      FROM jos_content
      WHERE id = '1354'
  72. SELECT *
      FROM jos_content
      WHERE id = '662'
  73. SELECT *
      FROM jos_content
      WHERE id = '674'
  74. SELECT *
      FROM jos_content
      WHERE id = '661'
  75. SELECT *
      FROM jos_content
      WHERE id = '660'
  76. SELECT *
      FROM jos_content
      WHERE id = '647'
  77. SELECT *
      FROM jos_content
      WHERE id = '646'
  78. SELECT *
      FROM jos_content
      WHERE id = '645'
  79. SELECT *
      FROM jos_content
      WHERE id = '643'
  80. SELECT *
      FROM jos_content
      WHERE id = '641'
  81. SELECT *
      FROM jos_content
      WHERE id = '639'
  82. SELECT *
      FROM jos_content
      WHERE id = '575'
  83. SELECT *
      FROM jos_content
      WHERE id = '554'
  84. SELECT *
      FROM jos_content
      WHERE id = '544'
  85. SELECT *
      FROM jos_content
      WHERE id = '543'
  86. SELECT *
      FROM jos_content
      WHERE id = '542'
  87. SELECT *
      FROM jos_content
      WHERE id = '541'
  88. SELECT *
      FROM jos_content
      WHERE id = '540'
  89. SELECT *
      FROM jos_content
      WHERE id = '539'
  90. SELECT *
      FROM jos_content
      WHERE id = '538'
  91. SELECT *
      FROM jos_content
      WHERE id = '537'
  92. SELECT *
      FROM jos_content
      WHERE id = '536'
  93. SELECT *
      FROM jos_content
      WHERE id = '535'
  94. SELECT *
      FROM jos_content
      WHERE id = '520'
  95. SELECT *
      FROM jos_content
      WHERE id = '701'
  96. SELECT *
      FROM jos_content
      WHERE id = '501'
  97. SELECT *
      FROM jos_content
      WHERE id = '431'
  98. SELECT *
      FROM jos_content
      WHERE id = '425'
  99. SELECT *
      FROM jos_content
      WHERE id = '356'
  100. SELECT *
      FROM jos_content
      WHERE id = '236'
  101. SELECT *
      FROM jos_content
      WHERE id = '232'
  102. SELECT *
      FROM jos_content
      WHERE id = '189'
  103. SELECT *
      FROM jos_content
      WHERE id = '168'
  104. SELECT *
      FROM jos_content
      WHERE id = '713'
  105. SELECT *
      FROM jos_content
      WHERE id = '275'
  106. SELECT *
      FROM jos_content
      WHERE id = '307'
  107. SELECT *
      FROM jos_content
      WHERE id = '305'
  108. SELECT *
      FROM jos_content
      WHERE id = '281'
  109. SELECT *
      FROM jos_content
      WHERE id = '280'
  110. SELECT *
      FROM jos_content
      WHERE id = '279'
  111. SELECT *
      FROM jos_content
      WHERE id = '278'
  112. SELECT *
      FROM jos_content
      WHERE id = '314'
  113. SELECT *
      FROM jos_content
      WHERE id = '277'
  114. SELECT gid
      FROM jos_users
      WHERE id=0
  115. SELECT id
      FROM jos_menu
      WHERE link LIKE '%com_uddeim%'
      AND published=1
      AND access=0
      LIMIT 1
  116. SELECT id
      FROM jos_menu
      WHERE link LIKE '%com_uddeim%'
      AND published=0
      AND access=0
      LIMIT 1
  117. SELECT COUNT(*)
     
      FROM jos_comprofiler_members AS m
     
      LEFT JOIN jos_comprofiler AS c
      ON m.memberid = c.id
     
      LEFT JOIN jos_users AS u
      ON m.memberid = u.id
     
      WHERE m.referenceid = 64
     
      AND c.approved = 1
      AND c.confirmed = 1
      AND c.banned = 0
      AND u.block = 0
     
      AND m.pending = 0
      AND m.accepted = 1
  118. SELECT m.*,u.name,u.email,u.username,c.avatar,c.avatarapproved, u.id
     
      FROM jos_comprofiler_members AS m
     
      LEFT JOIN jos_comprofiler AS c
      ON m.memberid=c.id
     
      LEFT JOIN jos_users AS u
      ON m.memberid=u.id
     
      WHERE m.referenceid=64
     
      AND c.approved=1
      AND c.confirmed=1
      AND c.banned=0
      AND u.block=0
     
      AND m.pending=0
      AND m.accepted=1
     
      ORDER BY m.membersince DESC, m.memberid ASC
      LIMIT 0, 10
  119. SELECT username
      FROM jos_users
      WHERE id = 268
      LIMIT 0, 1
  120. SELECT *
      FROM jos_comprofiler_plugin p
     
      WHERE p.published=1
     
      AND p.element LIKE '%pms.%'
     
      ORDER BY p.ordering
  121. SELECT id
      FROM jos_menu
      WHERE link LIKE '%com_uddeim%'
      AND published=1
      AND access=0
      LIMIT 1
  122. SELECT id
      FROM jos_menu
      WHERE link LIKE '%com_uddeim%'
      AND published=0
      AND access=0
      LIMIT 1
  123. SELECT COUNT(*)
      FROM jos_session
      WHERE userid = 268
      AND guest = 0
  124. SELECT username
      FROM jos_users
      WHERE id = 4624
      LIMIT 0, 1
  125. SELECT id
      FROM jos_menu
      WHERE link LIKE '%com_uddeim%'
      AND published=1
      AND access=0
      LIMIT 1
  126. SELECT id
      FROM jos_menu
      WHERE link LIKE '%com_uddeim%'
      AND published=0
      AND access=0
      LIMIT 1
  127. SELECT COUNT(*)
      FROM jos_session
      WHERE userid = 4624
      AND guest = 0
  128. SELECT username
      FROM jos_users
      WHERE id = 4282
      LIMIT 0, 1
  129. SELECT id
      FROM jos_menu
      WHERE link LIKE '%com_uddeim%'
      AND published=1
      AND access=0
      LIMIT 1
  130. SELECT id
      FROM jos_menu
      WHERE link LIKE '%com_uddeim%'
      AND published=0
      AND access=0
      LIMIT 1
  131. SELECT COUNT(*)
      FROM jos_session
      WHERE userid = 4282
      AND guest = 0
  132. SELECT username
      FROM jos_users
      WHERE id = 4368
      LIMIT 0, 1
  133. SELECT id
      FROM jos_menu
      WHERE link LIKE '%com_uddeim%'
      AND published=1
      AND access=0
      LIMIT 1
  134. SELECT id
      FROM jos_menu
      WHERE link LIKE '%com_uddeim%'
      AND published=0
      AND access=0
      LIMIT 1
  135. SELECT COUNT(*)
      FROM jos_session
      WHERE userid = 4368
      AND guest = 0
  136. SELECT username
      FROM jos_users
      WHERE id = 4385
      LIMIT 0, 1
  137. SELECT id
      FROM jos_menu
      WHERE link LIKE '%com_uddeim%'
      AND published=1
      AND access=0
      LIMIT 1
  138. SELECT id
      FROM jos_menu
      WHERE link LIKE '%com_uddeim%'
      AND published=0
      AND access=0
      LIMIT 1
  139. SELECT COUNT(*)
      FROM jos_session
      WHERE userid = 4385
      AND guest = 0
  140. SELECT username
      FROM jos_users
      WHERE id = 4294
      LIMIT 0, 1
  141. SELECT id
      FROM jos_menu
      WHERE link LIKE '%com_uddeim%'
      AND published=1
      AND access=0
      LIMIT 1
  142. SELECT id
      FROM jos_menu
      WHERE link LIKE '%com_uddeim%'
      AND published=0
      AND access=0
      LIMIT 1
  143. SELECT COUNT(*)
      FROM jos_session
      WHERE userid = 4294
      AND guest = 0
  144. SELECT username
      FROM jos_users
      WHERE id = 1360
      LIMIT 0, 1
  145. SELECT id
      FROM jos_menu
      WHERE link LIKE '%com_uddeim%'
      AND published=1
      AND access=0
      LIMIT 1
  146. SELECT id
      FROM jos_menu
      WHERE link LIKE '%com_uddeim%'
      AND published=0
      AND access=0
      LIMIT 1
  147. SELECT COUNT(*)
      FROM jos_session
      WHERE userid = 1360
      AND guest = 0
  148. SELECT username
      FROM jos_users
      WHERE id = 2368
      LIMIT 0, 1
  149. SELECT id
      FROM jos_menu
      WHERE link LIKE '%com_uddeim%'
      AND published=1
      AND access=0
      LIMIT 1
  150. SELECT id
      FROM jos_menu
      WHERE link LIKE '%com_uddeim%'
      AND published=0
      AND access=0
      LIMIT 1
  151. SELECT COUNT(*)
      FROM jos_session
      WHERE userid = 2368
      AND guest = 0
  152. SELECT username
      FROM jos_users
      WHERE id = 3850
      LIMIT 0, 1
  153. SELECT id
      FROM jos_menu
      WHERE link LIKE '%com_uddeim%'
      AND published=1
      AND access=0
      LIMIT 1
  154. SELECT id
      FROM jos_menu
      WHERE link LIKE '%com_uddeim%'
      AND published=0
      AND access=0
      LIMIT 1
  155. SELECT COUNT(*)
      FROM jos_session
      WHERE userid = 3850
      AND guest = 0
  156. SELECT `id`
     
      FROM `jos_groups`
     
      WHERE `id` <= 0
     
      ORDER BY `id`
  157. SELECT `id`
     
      FROM `jos_groups`
     
      WHERE `id` <= 0
     
      ORDER BY `id`
  158. SELECT `id`
     
      FROM `jos_groups`
     
      WHERE `id` <= 0
     
      ORDER BY `id`
  159. SELECT COUNT(*)
     
      FROM jos_comprofiler_plug_profilebook
     
      WHERE userid = 64
     
      AND mode = 'b'
     
     
      AND published = 1
  160. SELECT *, pb.id AS pbid
     
      FROM jos_comprofiler_plug_profilebook pb
     
      LEFT JOIN jos_users u
      ON pb.posterid=u.id
     
      LEFT JOIN jos_comprofiler c
      ON pb.posterid=c.id
     
      WHERE pb.userid=64
     
      AND mode = 'b'
     
      AND published = 1
     
      ORDER BY DATE DESC
     
      LIMIT 0,5
  161. SELECT username
      FROM jos_users
      WHERE id = 64
      LIMIT 0, 1
  162. SELECT username
      FROM jos_users
      WHERE id = 64
      LIMIT 0, 1
  163. SELECT username
      FROM jos_users
      WHERE id = 64
      LIMIT 0, 1
  164. SELECT COUNT(*)
     
      FROM jos_comprofiler_plug_profilebook
     
      WHERE userid = 64
     
      AND mode = 'w'
     
     
      AND published = 1
  165. SELECT *, pb.id AS pbid
     
      FROM jos_comprofiler_plug_profilebook pb
     
      LEFT JOIN jos_users u
      ON pb.posterid=u.id
     
      LEFT JOIN jos_comprofiler c
      ON pb.posterid=c.id
     
      WHERE pb.userid=64
     
      AND mode = 'w'
     
      AND published = 1
     
      ORDER BY DATE DESC
     
      LIMIT 0,10
  166. SELECT *
      FROM jos_supera_conf
  167. SELECT id
      FROM jos_menu
      WHERE link = 'index.php?option=com_comprofiler'
      AND published=1
  168. SELECT *
      FROM jos_supera_cb_tab
      ORDER BY actidate DESC
  169. TRUNCATE TABLE jos_supera_cb_tab
  170. SELECT `id`
     
      FROM `jos_groups`
     
      WHERE `id` <= 0
     
      ORDER BY `id`
  171. SELECT `id`
     
      FROM `jos_groups`
     
      WHERE `id` <= 0
     
      ORDER BY `id`

  172.   SET SQL_BIG_SELECTS=1
  173. SELECT
                            id
                       
      FROM
                            jos_menu
                       
      WHERE
                            link LIKE "%com_comprofiler"
      AND published = 1
      AND TYPE = "component"
  174. 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
     
      WHERE 1 = 1
      AND (
       Review.userid = 64
       
      AND Review.published > 0
     )
     
      ORDER BY `Review.created` DESC
     
      LIMIT 10
  175. 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 (676)
     )
  176. SELECT
                            id
                       
      FROM
                            jos_menu
                       
      WHERE
                            link LIKE "%com_comprofiler"
      AND published = 1
      AND TYPE = "component"
  177. SELECT
                        content_id AS listing_id, COUNT(*) AS favored
      FROM jos_jreviews_favorites AS Favorite
                               
      WHERE
                        Favorite.content_id IN (676)
                               
      GROUP BY
                        listing_id
  178. 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)
     )
  179. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (3)
     
      AND TYPE = 'content'
  180. 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)
      AND `Group`.TYPE =  'content' )
     
      WHERE FIELD.location = 'content'
      AND FIELD.published = 1
     
      ORDER BY
      GROUP.ordering, FIELD.ordering
  181. SELECT Listing.contentid AS element_id,jr_brand,jr_website
     
      FROM jos_jreviews_content AS Listing
     
      WHERE Listing.contentid IN (676)
  182. SELECT *
     
      FROM jos_comprofiler AS Community
     
      WHERE 1 = 1
      AND (
       user_id IN (64)
     )
  183. 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)
     )
  184. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (3)
     
      AND TYPE = 'review'
  185. SELECT username
      FROM jos_users
      WHERE id = 64
      LIMIT 0, 1
  186. SELECT `id`
     
      FROM `jos_groups`
     
      WHERE `id` <= 0
     
      ORDER BY `id`
  187. SELECT `id`
     
      FROM `jos_groups`
     
      WHERE `id` <= 0
     
      ORDER BY `id`
  188. SELECT COUNT(*)
                                           
      FROM jos_geocode_factory_maps
                                           
      WHERE id='5'
      AND public=1
  189. SELECT *
                                                   
      FROM jos_geocode_factory_maps
                                                   
      WHERE id='5'
                                                   
      LIMIT 1
  190. SELECT `keynom`, `valeur`      
      FROM jos_geocode_factory_parametres    
      WHERE  `id_map`='5'
  191. SELECT *
      FROM jos_geocode_factory_markersets
      WHERE id_map='5'  
      ORDER BY ordering
  192. SELECT
                      COUNT(jg.id)
                   
      FROM
                      jos_joomgallery AS jg
                   
      LEFT JOIN
                      jos_joomgallery_catg AS jgc
                   
      ON
                      jgc.cid = jg.catid
                   
      WHERE
                          jgc.access   <= 0
                       
      AND jg.useruploaded = '1'
                     
      AND jg.approved   = 1
                     
      AND jg.owner      = 64
                     
      AND jgc.published = 1
                     
      AND jg.published  = 1
                     
      AND jgc.hidden    = 0
                     
      AND jgc.in_hidden = 0
                     
      AND jg.hidden     = 0
  193. SELECT SUM(imgvotes) AS numvotes, SUM(imgvotesum) AS votesum
             
      FROM jos_joomgallery
             
      WHERE owner = 64
  194. SELECT
                              id
                           
      FROM
                              jos_menu
                           
      WHERE
                                  link LIKE '%com_joomgallery&view=gallery%'
                             
      AND access = 0
                           
      ORDER BY
                              id DESC
  195. SELECT
                                id
                             
      FROM
                                jos_menu
                             
      WHERE
                                    link LIKE '%com_joomgallery%'
                               
      AND access = 0
                             
      ORDER BY
                                id DESC
  196. SELECT  (
                      SELECT
                        COUNT(cmtid)
                     
      FROM
                        jos_joomgallery_comments
                     
      WHERE
                        cmtpic=jg.id
                      ) AS cmtcount,
                       jg.id,
                      jg.catid,
                      jg.imgthumbname,
                      jg.imgfilename,
                      jg.owner,
                      jg.imgauthor,
                      jg.imgdate,
                      jg.imgtitle,
                      jg.imgtext,
                      jg.hits,
                      jg.imgvotes,
                      ROUND(LEAST(IF(imgvotes > 0, jg.imgvotesum/jg.imgvotes, 0.0), 10), 2) AS rating,
                      jgc.name AS cattitle,
                      jgc.catpath AS catpath
                 
                   
      FROM
                      jos_joomgallery AS jg
                   
      LEFT JOIN
                      jos_joomgallery_catg AS jgc
                   
      ON
                      jgc.cid = jg.catid
                   
      WHERE        jgc.access   <= 0
                       
      AND jg.useruploaded = '1'
                     
      AND jg.approved   = 1
                     
      AND jg.owner      = 64
                     
      AND jgc.published = 1
                     
      AND jg.published  = 1
                     
      AND jgc.hidden    = 0
                     
      AND jgc.in_hidden = 0
                     
      AND jg.hidden     = 0
                   
      ORDER BY
                      jg.catid ASC
                   
      LIMIT 0, 12
  197. SELECT
                                  catpath
                               
      FROM
                                  jos_joomgallery_catg
                               
      WHERE
                                  cid= 5
  198. SELECT
                          catid, alias
                       
      FROM
                          jos_joomgallery
                       
      WHERE
                          id = 99
  199. SELECT
                          alias
                       
      FROM
                          jos_joomgallery_catg
                       
      WHERE
                          cid = 5
  200. SELECT
                          alias
                       
      FROM
                          jos_joomgallery_catg
                       
      WHERE
                          cid = 5
  201. SELECT
                          catid, alias
                       
      FROM
                          jos_joomgallery
                       
      WHERE
                          id = 100
  202. SELECT
                          alias
                       
      FROM
                          jos_joomgallery_catg
                       
      WHERE
                          cid = 5
  203. SELECT
                          alias
                       
      FROM
                          jos_joomgallery_catg
                       
      WHERE
                          cid = 5
  204. SELECT
                          catid, alias
                       
      FROM
                          jos_joomgallery
                       
      WHERE
                          id = 444
  205. SELECT
                          alias
                       
      FROM
                          jos_joomgallery_catg
                       
      WHERE
                          cid = 5
  206. SELECT
                          alias
                       
      FROM
                          jos_joomgallery_catg
                       
      WHERE
                          cid = 5
  207. SELECT
                          catid, alias
                       
      FROM
                          jos_joomgallery
                       
      WHERE
                          id = 445
  208. SELECT
                          alias
                       
      FROM
                          jos_joomgallery_catg
                       
      WHERE
                          cid = 5
  209. SELECT
                          alias
                       
      FROM
                          jos_joomgallery_catg
                       
      WHERE
                          cid = 5
  210. SELECT
                          catid, alias
                       
      FROM
                          jos_joomgallery
                       
      WHERE
                          id = 446
  211. SELECT
                          alias
                       
      FROM
                          jos_joomgallery_catg
                       
      WHERE
                          cid = 5
  212. SELECT
                          alias
                       
      FROM
                          jos_joomgallery_catg
                       
      WHERE
                          cid = 5
  213. SELECT
                                  catpath
                               
      FROM
                                  jos_joomgallery_catg
                               
      WHERE
                                  cid= 6
  214. SELECT
                          catid, alias
                       
      FROM
                          jos_joomgallery
                       
      WHERE
                          id = 418
  215. SELECT
                          alias
                       
      FROM
                          jos_joomgallery_catg
                       
      WHERE
                          cid = 6
  216. SELECT
                          alias
                       
      FROM
                          jos_joomgallery_catg
                       
      WHERE
                          cid = 6
  217. SELECT
                          catid, alias
                       
      FROM
                          jos_joomgallery
                       
      WHERE
                          id = 419
  218. SELECT
                          alias
                       
      FROM
                          jos_joomgallery_catg
                       
      WHERE
                          cid = 6
  219. SELECT
                          alias
                       
      FROM
                          jos_joomgallery_catg
                       
      WHERE
                          cid = 6
  220. SELECT
                          catid, alias
                       
      FROM
                          jos_joomgallery
                       
      WHERE
                          id = 420
  221. SELECT
                          alias
                       
      FROM
                          jos_joomgallery_catg
                       
      WHERE
                          cid = 6
  222. SELECT
                          alias
                       
      FROM
                          jos_joomgallery_catg
                       
      WHERE
                          cid = 6
  223. SELECT
                          catid, alias
                       
      FROM
                          jos_joomgallery
                       
      WHERE
                          id = 496
  224. SELECT
                          alias
                       
      FROM
                          jos_joomgallery_catg
                       
      WHERE
                          cid = 6
  225. SELECT
                          alias
                       
      FROM
                          jos_joomgallery_catg
                       
      WHERE
                          cid = 6
  226. SELECT
                          catid, alias
                       
      FROM
                          jos_joomgallery
                       
      WHERE
                          id = 497
  227. SELECT
                          alias
                       
      FROM
                          jos_joomgallery_catg
                       
      WHERE
                          cid = 6
  228. SELECT
                          alias
                       
      FROM
                          jos_joomgallery_catg
                       
      WHERE
                          cid = 6
  229. SELECT
                          catid, alias
                       
      FROM
                          jos_joomgallery
                       
      WHERE
                          id = 498
  230. SELECT
                          alias
                       
      FROM
                          jos_joomgallery_catg
                       
      WHERE
                          cid = 6
  231. SELECT
                          alias
                       
      FROM
                          jos_joomgallery_catg
                       
      WHERE
                          cid = 6
  232. SELECT `id`
     
      FROM `jos_groups`
     
      WHERE `id` <= 0
     
      ORDER BY `id`
  233. SELECT f.*
      FROM jos_comprofiler_fields f
     
      INNER JOIN jos_comprofiler_tabs AS t
      ON (f.tabid = t.tabid)
     
      WHERE f.published = 1
      AND f.profile != 0
      AND t.enabled = 1
      AND t.viewaccesslevel IN (1)
      AND t.useraccessgroupid IN (-2,28,29)
     
      ORDER BY t.POSITION, t.ordering, f.ordering
  234. SELECT `id`
     
      FROM `jos_groups`
     
      WHERE `id` <= 0
     
      ORDER BY `id`
  235. SELECT `id`
     
      FROM `jos_groups`
     
      WHERE `id` <= 0
     
      ORDER BY `id`
  236. SELECT MAX(TIME)
      FROM jos_session
      WHERE userid = 64
      AND guest = 0
  237. SELECT `id`
     
      FROM `jos_menu`
     
      WHERE `link` LIKE '%com_kunena%'
  238. SELECT *
      FROM jos_kunena_configuration
      WHERE id=1
  239. SELECT u.name, u.username, u.email, u.block AS blocked, u.registerDate, u.lastvisitDate, ku.*
                           
      FROM jos_users AS u
                           
      LEFT JOIN jos_kunena_users AS ku
      ON u.id = ku.userid
                           
      WHERE u.id = 64
  240. SELECT `id`
     
      FROM `jos_groups`
     
      WHERE `id` <= 0
     
      ORDER BY `id`
  241. SELECT `id`
     
      FROM `jos_groups`
     
      WHERE `id` <= 0
     
      ORDER BY `id`
  242. SELECT `id`
     
      FROM `jos_groups`
     
      WHERE `id` <= 0
     
      ORDER BY `id`
  243. SELECT `id`
     
      FROM `jos_groups`
     
      WHERE `id` <= 0
     
      ORDER BY `id`
  244. SELECT `id`
     
      FROM `jos_groups`
     
      WHERE `id` <= 0
     
      ORDER BY `id`
  245. SELECT `id`
     
      FROM `jos_groups`
     
      WHERE `id` <= 0
     
      ORDER BY `id`
  246. SELECT `id`
     
      FROM `jos_groups`
     
      WHERE `id` <= 0
     
      ORDER BY `id`
  247. SELECT `id`
     
      FROM `jos_groups`
     
      WHERE `id` <= 0
     
      ORDER BY `id`
  248. SELECT `lastview`, `lastip`
     
      FROM `jos_comprofiler_views`
     
      WHERE `viewer_id` = 0
     
      AND `profile_id` = 64
     
      AND `lastip` = '54.159.111.156'
     
      ORDER BY `lastview` DESC
  249. INSERT INTO `jos_comprofiler_views`
     ( `viewer_id`, `profile_id`, `lastip`, `lastview`, `viewscount` )
     
      VALUES ( 0, 64, '54.159.111.156', NOW(), 1 )
  250. UPDATE jos_comprofiler
      SET hits=(hits+1)
      WHERE id=64
  251. TRUNCATE TABLE jos_supera_cb_tab
  252. SELECT menutype, id, name, link  
      FROM jos_menu  
      WHERE id = 491
  253. SELECT menutype
      FROM jos_menu
      WHERE  1=1  
      AND link LIKE '%option=com_comprofiler%'
      AND link LIKE '%task=userprofile%'
      AND published=1
  254. SELECT menutype
      FROM jos_menu
      WHERE  1=1  
      AND link LIKE '%option=com_comprofiler%'
      AND link LIKE '%task=userprofile%'
      AND published=1
  255. SELECT *  
      FROM jos_ijseo_metags  
      WHERE mtype = 'mainmenu'  
      AND id = 491
  256. SELECT *  
      FROM jos_ijseo_metags  
      WHERE mtype = 'mainmenu'  
      AND id = 491
  257. SELECT j_user_id
      FROM jos_jfbconnect_user_map
      WHERE fb_user_id=''
  258. SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 491)
      ORDER BY menuid DESC
      LIMIT 0, 1
  259. 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 = 491 OR mm.menuid = 0 )
      ORDER BY POSITION, ordering
  260. SELECT *
      FROM jos_ninjarsssyndicator_feeds
      WHERE published = 1
      AND (id = 1)
      ORDER BY feed_name

  261.   SET SQL_BIG_SELECTS=1
  262. SELECT
                            id
                       
      FROM
                            jos_menu
                       
      WHERE
                            link LIKE "%com_comprofiler"
      AND published = 1
      AND TYPE = "component"
  263. 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:08") )
       
      AND ( Listing.publish_down = "0000-00-00 00:00:00" OR DATE(Listing.publish_down) >= DATE("2015-07-06 22:08") )
       
      AND Category.access <= 0
       
      AND Listing.access <= 0
       
      AND Listing.sectionid IN (52)
       
      AND Review.published > 0
     )
     
      ORDER BY `Review.created` DESC
     
      LIMIT 12
  264. 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)
     )
  265. SELECT *
     
      FROM jos_comprofiler AS Community
     
      WHERE 1 = 1
      AND (
       user_id IN (62,63,7026,5782,4698)
     )
  266. 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
  267. 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)
     )
  268. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (3,3,5)
     
      AND TYPE = 'content'
  269. 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
  270. 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)
  271. SELECT *
     
      FROM jos_comprofiler AS Community
     
      WHERE 1 = 1
      AND (
       user_id IN (8333,8332,5782,4698,8182,7660,7026,7814)
     )
  272. 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)
     )
  273. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (3,3,5)
     
      AND TYPE = 'review'
  274. SELECT username
      FROM jos_users
      WHERE id = 8333
      LIMIT 0, 1
  275. SELECT username
      FROM jos_users
      WHERE id = 8332
      LIMIT 0, 1
  276. SELECT username
      FROM jos_users
      WHERE id = 5782
      LIMIT 0, 1
  277. SELECT username
      FROM jos_users
      WHERE id = 5782
      LIMIT 0, 1
  278. SELECT username
      FROM jos_users
      WHERE id = 4698
      LIMIT 0, 1
  279. SELECT username
      FROM jos_users
      WHERE id = 8182
      LIMIT 0, 1
  280. SELECT username
      FROM jos_users
      WHERE id = 5782
      LIMIT 0, 1
  281. SELECT username
      FROM jos_users
      WHERE id = 7660
      LIMIT 0, 1
  282. SELECT username
      FROM jos_users
      WHERE id = 7026
      LIMIT 0, 1
  283. SELECT username
      FROM jos_users
      WHERE id = 7814
      LIMIT 0, 1

  284.   SET SQL_BIG_SELECTS=1
  285. SELECT
                            id
                       
      FROM
                            jos_menu
                       
      WHERE
                            link LIKE "%com_comprofiler"
      AND published = 1
      AND TYPE = "component"
  286. 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:08") )
       
      AND ( Listing.publish_down = "0000-00-00 00:00:00" OR DATE(Listing.publish_down) >= DATE("2015-07-06 22:08") )
       
      AND Category.access <= 0
       
      AND Listing.access <= 0
       
      AND Listing.sectionid IN (55)
       
      AND Review.published > 0
     )
     
      ORDER BY `Review.created` DESC
     
      LIMIT 12
  287. 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)
     )
  288. SELECT *
     
      FROM jos_comprofiler AS Community
     
      WHERE 1 = 1
      AND (
       user_id IN (4698)
     )
  289. 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
  290. 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)
     )
  291. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (4,3)
     
      AND TYPE = 'content'
  292. 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
  293. 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)
  294. 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
  295. SELECT *
     
      FROM jos_comprofiler AS Community
     
      WHERE 1 = 1
      AND (
       user_id IN (9176,7293,9022,9000,8886,8861,8725,8678,8631,8421,407)
     )
  296. 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)
     )
  297. SELECT groupid
      FROM jos_jreviews_groups
     
      WHERE groupid IN (4,3)
     
      AND TYPE = 'review'
  298. SELECT username
      FROM jos_users
      WHERE id = 9176
      LIMIT 0, 1
  299. SELECT username
      FROM jos_users
      WHERE id = 9176
      LIMIT 0, 1
  300. SELECT username
      FROM jos_users
      WHERE id = 7293
      LIMIT 0, 1
  301. SELECT username
      FROM jos_users
      WHERE id = 9022
      LIMIT 0, 1
  302. SELECT username
      FROM jos_users
      WHERE id = 9000
      LIMIT 0, 1
  303. SELECT username
      FROM jos_users
      WHERE id = 8886
      LIMIT 0, 1
  304. SELECT username
      FROM jos_users
      WHERE id = 8861
      LIMIT 0, 1
  305. SELECT username
      FROM jos_users
      WHERE id = 8725
      LIMIT 0, 1
  306. SELECT username
      FROM jos_users
      WHERE id = 8678
      LIMIT 0, 1
  307. SELECT username
      FROM jos_users
      WHERE id = 8631
      LIMIT 0, 1
  308. SELECT username
      FROM jos_users
      WHERE id = 8421
      LIMIT 0, 1
  309. SELECT username
      FROM jos_users
      WHERE id = 407
      LIMIT 0, 1
  310. SELECT `id`
     
      FROM `jos_groups`
     
      WHERE `id` <= 0
     
      ORDER BY `id`
  311. SELECT id
      FROM jos_menu
      WHERE link LIKE 'index.php?option=com_comprofiler&task=registers%'
      AND published = 1
      AND access IN (0)
  312. SELECT `id`
     
      FROM `jos_groups`
     
      WHERE `id` <= 0
     
      ORDER BY `id`
  313. SELECT *
      FROM jos_acymailing_list
      WHERE TYPE = 'list'  
      ORDER BY ordering ASC
  314. SELECT *
      FROM jos_ad_agency_settings
      LIMIT 1
  315. SELECT *
      FROM jos_ad_agency_zone
      WHERE zoneid=687
      LIMIT 1
  316. SELECT *
      FROM jos_ad_agency_settings
      LIMIT 1
  317. SELECT *
      FROM jos_ad_agency_zone
      WHERE zoneid=783
      LIMIT 1
  318. SELECT *
      FROM jos_ad_agency_settings
      LIMIT 1
  319. SELECT *
      FROM jos_ad_agency_zone
      WHERE zoneid=690
      LIMIT 1
  320. 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
  321. SELECT m.*
      FROM jos_menu AS m

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

•Language Files Loaded•

•Untranslated Strings Diagnostic•

AUTHOR	JAuthorization::get_group_children_tree()	[/home/joey2509/public_html/administrator/components/com_comprofiler/library/cb/cb.acl.php:180]
AUTHOR	JAuthorization::get_group_children_tree()	[/home/joey2509/public_html/administrator/components/com_comprofiler/library/cb/cb.acl.php:180]
EDITOR	JAuthorization::get_group_children_tree()	[/home/joey2509/public_html/administrator/components/com_comprofiler/library/cb/cb.acl.php:180]
EDITOR	JAuthorization::get_group_children_tree()	[/home/joey2509/public_html/administrator/components/com_comprofiler/library/cb/cb.acl.php:180]
MANAGER	JAuthorization::get_group_children_tree()	[/home/joey2509/public_html/administrator/components/com_comprofiler/library/cb/cb.acl.php:180]
NO	JHTMLSelect::booleanlist()	[:]
PUBLIC BACKEND	JAuthorization::get_group_children_tree()	[/home/joey2509/public_html/administrator/components/com_comprofiler/library/cb/cb.acl.php:180]
PUBLIC BACKEND	JAuthorization::get_group_children_tree()	[/home/joey2509/public_html/administrator/components/com_comprofiler/library/cb/cb.acl.php:180]
PUBLIC FRONTEND	JAuthorization::get_group_children_tree()	[/home/joey2509/public_html/administrator/components/com_comprofiler/library/cb/cb.acl.php:180]
PUBLIC FRONTEND	JAuthorization::get_group_children_tree()	[/home/joey2509/public_html/administrator/components/com_comprofiler/library/cb/cb.acl.php:180]
PUBLISHER	JAuthorization::get_group_children_tree()	[/home/joey2509/public_html/administrator/components/com_comprofiler/library/cb/cb.acl.php:180]
PUBLISHER	JAuthorization::get_group_children_tree()	[/home/joey2509/public_html/administrator/components/com_comprofiler/library/cb/cb.acl.php:180]
SUPER ADMINISTRATOR	JAuthorization::get_group_children_tree()	[/home/joey2509/public_html/administrator/components/com_comprofiler/library/cb/cb.acl.php:180]
SUPER ADMINISTRATOR	JAuthorization::get_group_children_tree()	[/home/joey2509/public_html/administrator/components/com_comprofiler/library/cb/cb.acl.php:180]
USERS	JAuthorization::get_group_children_tree()	[/home/joey2509/public_html/administrator/components/com_comprofiler/library/cb/cb.acl.php:180]
YES	JHTMLSelect::booleanlist()	[:]

•Untranslated Strings Designer•


# /home/joey2509/public_html/administrator/components/com_comprofiler/library/cb/cb.acl.php

AUTHOR=Author
EDITOR=Editor
MANAGER=Manager
PUBLIC BACKEND=Public Backend
PUBLIC FRONTEND=Public Frontend
PUBLISHER=Publisher
SUPER ADMINISTRATOR=Super Administrator
USERS=USERS

# ??Unknown file??

NO=no
YES=yes