Get Adobe Flash player

Home Page

Logtrain_Logo_1

The leader in skills training, e-learning, courses & workshops in the following fields: Supply Chain Management, Logistics, Air, Sea, Road & Rail Freight, Transport, Shipping, Importing, Exporting, Incoterms® Rules, Customs, Bond & Rebate Stores, Warehousing, Marine Insurance, MIDP

Prepare your staff for the new SARS Customs Policies and Procedures
and avoid rejected Entries, Consignments and Penalties

Customs Training

Do you pass the test?
 Sars_Inspection

Focussing on the Customs Clearing & Forwarding environment as well as the completion of statutory documentation. Ideal for learners already employed in the industry or for those wishing to embark on a career in Customs Clearing & Forwarding. It is also ideal for Importers and Exporters who wish to know more about the role their Customs Clearing & Forwarding Agent plays in the handling of your shipments and customs clearing and forwarding procedures.

Sars_Logo

Courses Available

  International_Trade For detailed information on any of the course listed below, please go to Downloads and then Course Outlines or click Course Outlines :

  • Bond & Rebate Store Operations
  • Bond Store II Advanced
  • Container Management
  • Customs Clearing & Forwarding I
  • Customs II - Advanced
  • Dangerous Goods (Awareness)
  • Forwarding II - Advanced
  • Import & Export Procedures
  • Incoterms® 2011 Rules
  • Marine Cargo Insurance
  • Perishable Cargo
  • Road Freight - Cross Border
  • Warehousing Management & Operations

Incoterms ® 2010 Book


Incoterms_2010_logo_new 

This book is your essential tool to ensure correct application of the Incoterms® rules in global and domestic sales transactions


More info

ScanPen

IRIS_Scan_Pen
You can view a video on the IRIS Scan Pen



Get the Flash Player to see this player.

time2online Joomla Extensions: Simple Video Flash Player Module

You can request more information by clicking here

You can purchase the IRIS Scan Pen by clicking here

 

 

Logtrain Communty

Active Groups - Join

Community Activities

 

Profile Information

Application afterLoad: 0.000 seconds, 0.37 MB
Application afterInitialise: 0.064 seconds, 4.68 MB
Application afterRoute: 0.075 seconds, 5.43 MB
Application afterDispatch: 0.153 seconds, 10.13 MB
Application afterRender: 0.943 seconds, 20.11 MB

Memory Usage

21206904

85 queries logged

  1. SELECT *
      FROM joj_session
      WHERE session_id = 'bb29e2be12142e7ebb8134a8aa484181'
  2. DELETE
      FROM joj_session
      WHERE ( TIME < '1337448427' )
  3. SELECT *
      FROM joj_session
      WHERE session_id = 'bb29e2be12142e7ebb8134a8aa484181'
  4. INSERT INTO `joj_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
      VALUES ( 'bb29e2be12142e7ebb8134a8aa484181','1337451127','','0','1','0' )
  5. SELECT *
      FROM joj_components
      WHERE parent = 0
  6. SELECT folder AS TYPE, element AS name, params
      FROM joj_plugins
      WHERE published >= 1
      AND access <= 0
      ORDER BY ordering
  7. SELECT m.*, c.`option` AS component
      FROM joj_menu AS m
      LEFT JOIN joj_components AS c
      ON m.componentid = c.id
      WHERE m.published = 1
      ORDER BY m.sublevel, m.parent, m.ordering
  8. SELECT template
      FROM joj_templates_menu
      WHERE client_id = 0
      AND (menuid = 0 OR menuid = 1)
      ORDER BY menuid DESC
      LIMIT 0, 1
  9. SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.attribs, a.urls, a.metakey, a.metadesc, a.access, 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, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups, u.email AS author_email, cc.title AS category, s.title AS SECTION, s.ordering AS s_ordering, cc.ordering AS cc_ordering, a.ordering AS a_ordering, f.ordering AS f_ordering
      FROM joj_content AS a
      INNER JOIN joj_content_frontpage AS f
      ON f.content_id = a.id
      LEFT JOIN joj_categories AS cc
      ON cc.id = a.catid
      LEFT JOIN joj_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN joj_users AS u
      ON u.id = a.created_by
      LEFT JOIN joj_groups AS g
      ON a.access = g.id
      WHERE 1
      AND a.access <= 0
      AND a.state = 1
      AND (( cc.published = 1
      AND s.published = 1 ) OR ( a.catid = 0
      AND a.sectionid = 0 ) )
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-05-19 18:12:07' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-05-19 18:12:07' )
      ORDER BY  f.ordering
      LIMIT 0, 9
  10. SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.attribs, a.urls, a.metakey, a.metadesc, a.access, 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, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups, u.email AS author_email, cc.title AS category, s.title AS SECTION, s.ordering AS s_ordering, cc.ordering AS cc_ordering, a.ordering AS a_ordering, f.ordering AS f_ordering
      FROM joj_content AS a
      INNER JOIN joj_content_frontpage AS f
      ON f.content_id = a.id
      LEFT JOIN joj_categories AS cc
      ON cc.id = a.catid
      LEFT JOIN joj_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN joj_users AS u
      ON u.id = a.created_by
      LEFT JOIN joj_groups AS g
      ON a.access = g.id
      WHERE 1
      AND a.access <= 0
      AND a.state = 1
      AND (( cc.published = 1
      AND s.published = 1 ) OR ( a.catid = 0
      AND a.sectionid = 0 ) )
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-05-19 18:12:07' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-05-19 18:12:07' )
      ORDER BY  f.ordering
  11. SELECT id, title, module, POSITION, content, showtitle, control, params
      FROM joj_modules AS m
      LEFT JOIN joj_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 = 1 OR mm.menuid = 0 )
      ORDER BY POSITION, ordering
  12. SELECT m.*
      FROM joj_menu AS m
      WHERE menutype='mainmenu'
      AND published = 1
      AND access <= 0
      AND parent = 0
      ORDER BY ordering
  13. SELECT *
      FROM joj_community_config
      WHERE name = 'config'
  14. SELECT *
      FROM `joj_users` AS a
      INNER JOIN `joj_community_users` AS b
      ON a.`id` = b.`userid`
      WHERE a.`block` = '0'  
      ORDER BY a.`registerDate` DESC
      LIMIT 10
  15. SELECT          a.`userid` AS _userid , a.`status` AS _status ,         a.`points` AS _points,  a.`posted_on` AS _posted_on,    a.`avatar`      AS _avatar ,    a.`thumb`       AS _thumb ,     a.`invite`      AS _invite,     a.`params`      AS _cparams,    a.`view`        AS _view,  a.`friends` AS _friends,  a.`alias`  AS _alias,  a.`profile_id` AS _profile_id,  a.`friendcount` AS _friendcount,  a.`storage` AS _storage,  a.`watermark_hash` AS _watermark_hash,  a.`search_email` AS _search_email,  s.`userid` AS _isonline, u.*  
      FROM `joj_community_users` AS a  
      LEFT JOIN `joj_users` u  
      ON u.`id`=a.`userid`
      LEFT
      OUTER JOIN `joj_session`s  
      ON s.`userid`=a.`userid`
      WHERE a.`userid` IN (92,91,90,89,88,87,86,85,83,82)
  16. SELECT COUNT(DISTINCT connect_to)  
      FROM `joj_community_connection` AS a, `joj_users` AS b
      WHERE a.`connect_from`='82'
      AND b.block=0  
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `joj_community_blocklist` AS d
      WHERE d.`userid` = '82'
      AND d.`blocked_userid` = a.`connect_to`)  
      ORDER BY a.`connection_id` DESC
  17. SELECT COUNT(DISTINCT connect_to)  
      FROM `joj_community_connection` AS a, `joj_users` AS b
      WHERE a.`connect_from`='83'
      AND b.block=0  
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `joj_community_blocklist` AS d
      WHERE d.`userid` = '83'
      AND d.`blocked_userid` = a.`connect_to`)  
      ORDER BY a.`connection_id` DESC
  18. SELECT COUNT(DISTINCT connect_to)  
      FROM `joj_community_connection` AS a, `joj_users` AS b
      WHERE a.`connect_from`='85'
      AND b.block=0  
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `joj_community_blocklist` AS d
      WHERE d.`userid` = '85'
      AND d.`blocked_userid` = a.`connect_to`)  
      ORDER BY a.`connection_id` DESC
  19. SELECT COUNT(DISTINCT connect_to)  
      FROM `joj_community_connection` AS a, `joj_users` AS b
      WHERE a.`connect_from`='86'
      AND b.block=0  
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `joj_community_blocklist` AS d
      WHERE d.`userid` = '86'
      AND d.`blocked_userid` = a.`connect_to`)  
      ORDER BY a.`connection_id` DESC
  20. SELECT COUNT(DISTINCT connect_to)  
      FROM `joj_community_connection` AS a, `joj_users` AS b
      WHERE a.`connect_from`='87'
      AND b.block=0  
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `joj_community_blocklist` AS d
      WHERE d.`userid` = '87'
      AND d.`blocked_userid` = a.`connect_to`)  
      ORDER BY a.`connection_id` DESC
  21. SELECT COUNT(DISTINCT connect_to)  
      FROM `joj_community_connection` AS a, `joj_users` AS b
      WHERE a.`connect_from`='88'
      AND b.block=0  
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `joj_community_blocklist` AS d
      WHERE d.`userid` = '88'
      AND d.`blocked_userid` = a.`connect_to`)  
      ORDER BY a.`connection_id` DESC
  22. SELECT COUNT(DISTINCT connect_to)  
      FROM `joj_community_connection` AS a, `joj_users` AS b
      WHERE a.`connect_from`='89'
      AND b.block=0  
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `joj_community_blocklist` AS d
      WHERE d.`userid` = '89'
      AND d.`blocked_userid` = a.`connect_to`)  
      ORDER BY a.`connection_id` DESC
  23. SELECT COUNT(DISTINCT connect_to)  
      FROM `joj_community_connection` AS a, `joj_users` AS b
      WHERE a.`connect_from`='90'
      AND b.block=0  
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `joj_community_blocklist` AS d
      WHERE d.`userid` = '90'
      AND d.`blocked_userid` = a.`connect_to`)  
      ORDER BY a.`connection_id` DESC
  24. SELECT COUNT(DISTINCT connect_to)  
      FROM `joj_community_connection` AS a, `joj_users` AS b
      WHERE a.`connect_from`='91'
      AND b.block=0  
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `joj_community_blocklist` AS d
      WHERE d.`userid` = '91'
      AND d.`blocked_userid` = a.`connect_to`)  
      ORDER BY a.`connection_id` DESC
  25. SELECT COUNT(DISTINCT connect_to)  
      FROM `joj_community_connection` AS a, `joj_users` AS b
      WHERE a.`connect_from`='92'
      AND b.block=0  
      AND a.`status`='1'
      AND a.`connect_to`=b.`id`
      AND NOT EXISTS ( SELECT d.`blocked_userid`
      FROM `joj_community_blocklist` AS d
      WHERE d.`userid` = '92'
      AND d.`blocked_userid` = a.`connect_to`)  
      ORDER BY a.`connection_id` DESC
  26. SELECT `id`
      FROM `joj_menu`
      WHERE `link` LIKE '%option=com_community&view=profile%'
      AND `published`='1'
      AND `menutype`!='jomsocial'
      AND `type`='component'
  27. SELECT `id`
      FROM `joj_menu`
      WHERE `link` = 'index.php?option=com_community&view=frontpage'
      AND `published`='1'
      AND `type`='component'
  28. SELECT `id`
      FROM `joj_menu`
      WHERE `link` LIKE '%option=com_community%'
      AND `published`='1'
      AND `type`='component'
  29. SELECT          a.`userid` AS _userid ,         a.`status` AS _status ,         a.`points`      AS _points,     a.`posted_on` AS _posted_on,    a.`avatar`      AS _avatar ,    a.`thumb`       AS _thumb ,     a.`invite`      AS _invite,     a.`params`      AS _cparams,    a.`view`        AS _view,  a.`friends` AS _friends,  a.`groups` AS _groups,  a.`friendcount` AS _friendcount,  a.`alias` AS _alias,  a.`profile_id` AS _profile_id,  a.`storage` AS _storage,  a.`watermark_hash` AS _watermark_hash,  a.`search_email` AS _search_email,  s.`userid` AS _isonline, u.*  
      FROM `joj_community_users` AS a  
      LEFT JOIN `joj_users` u  
      ON u.`id`=a.`userid`
      LEFT
      OUTER JOIN `joj_session` s  
      ON s.`userid`=a.`userid`
      AND s.`client_id` !='1'
      WHERE a.`userid`='0'
  30. SELECT *
      FROM `joj_community_users`
      WHERE `userid`='92'
      AND (`status_access` <= 10)
      ORDER BY `posted_on` DESC
      LIMIT 1
  31. SELECT *
      FROM `joj_community_users`
      WHERE `userid`='91'
      AND (`status_access` <= 10)
      ORDER BY `posted_on` DESC
      LIMIT 1
  32. SELECT *
      FROM `joj_community_users`
      WHERE `userid`='90'
      AND (`status_access` <= 10)
      ORDER BY `posted_on` DESC
      LIMIT 1
  33. SELECT *
      FROM `joj_community_users`
      WHERE `userid`='89'
      AND (`status_access` <= 10)
      ORDER BY `posted_on` DESC
      LIMIT 1
  34. SELECT *
      FROM `joj_community_users`
      WHERE `userid`='88'
      AND (`status_access` <= 10)
      ORDER BY `posted_on` DESC
      LIMIT 1
  35. SELECT *
      FROM `joj_community_users`
      WHERE `userid`='87'
      AND (`status_access` <= 10)
      ORDER BY `posted_on` DESC
      LIMIT 1
  36. SELECT *
      FROM `joj_community_users`
      WHERE `userid`='86'
      AND (`status_access` <= 10)
      ORDER BY `posted_on` DESC
      LIMIT 1
  37. SELECT *
      FROM `joj_community_users`
      WHERE `userid`='85'
      AND (`status_access` <= 10)
      ORDER BY `posted_on` DESC
      LIMIT 1
  38. SELECT *
      FROM `joj_community_users`
      WHERE `userid`='83'
      AND (`status_access` <= 10)
      ORDER BY `posted_on` DESC
      LIMIT 1
  39. SELECT *
      FROM `joj_community_users`
      WHERE `userid`='82'
      AND (`status_access` <= 10)
      ORDER BY `posted_on` DESC
      LIMIT 1
  40. SELECT `id`
      FROM `joj_menu`
      WHERE `link` LIKE '%option=com_community&view=search%'
      AND `published`='1'
      AND `menutype`!='jomsocial'
      AND `type`='component'
  41. SELECT
                                                    `cid`,
                                                    COUNT(`cid`) AS `count`
                                       
      FROM
                                                    `joj_community_activities` a
                             
      INNER JOIN     `joj_community_groups` b
      ON a.`cid` = b.`id`
                                     
      WHERE
                                                    a.`app` = 'groups'
      AND
                                                    b.`published` = '1'
      AND
                                                    a.`archived` = '0'
      AND
                                                    a.`cid` != '0'
                               
      GROUP BY a.`cid`
                               
      ORDER BY `count` DESC
                               
      LIMIT 20
  42. SELECT a.*, b.`name` AS ownername , c.`name` AS category
      FROM `joj_community_groups` AS a  
      INNER JOIN `joj_users` AS b  
      INNER JOIN `joj_community_groups_category` AS c  
      WHERE a.`id`='13'  
      AND a.`ownerid`=b.`id`
      AND a.`categoryid`=c.`id`
  43. SELECT a.`memberid` AS id, a.`approved` , b.`name` AS name
      FROM`joj_community_groups_members` AS a  
      INNER JOIN `joj_users` AS b  
      WHERE b.`id`=a.`memberid`
      AND a.`groupid`='13'
      AND b.`block`='0'  
      AND a.`permissions` !='-1'
      AND a.`approved`='1'
      ORDER BY b.`name`
  44. SELECT COUNT(*)
      FROM `joj_community_groups_members` AS a  
      INNER JOIN `joj_users` AS b  
      WHERE b.`id`=a.`memberid`
      AND a.`groupid`='13'
      AND b.`block`='0'
      AND a.`approved`='1'
  45. SELECT a.*, b.`name` AS ownername , c.`name` AS category
      FROM `joj_community_groups` AS a  
      INNER JOIN `joj_users` AS b  
      INNER JOIN `joj_community_groups_category` AS c  
      WHERE a.`id`='15'  
      AND a.`ownerid`=b.`id`
      AND a.`categoryid`=c.`id`
  46. SELECT a.`memberid` AS id, a.`approved` , b.`name` AS name
      FROM`joj_community_groups_members` AS a  
      INNER JOIN `joj_users` AS b  
      WHERE b.`id`=a.`memberid`
      AND a.`groupid`='15'
      AND b.`block`='0'  
      AND a.`permissions` !='-1'
      AND a.`approved`='1'
      ORDER BY b.`name`
  47. SELECT COUNT(*)
      FROM `joj_community_groups_members` AS a  
      INNER JOIN `joj_users` AS b  
      WHERE b.`id`=a.`memberid`
      AND a.`groupid`='15'
      AND b.`block`='0'
      AND a.`approved`='1'
  48. SELECT a.*, b.`name` AS ownername , c.`name` AS category
      FROM `joj_community_groups` AS a  
      INNER JOIN `joj_users` AS b  
      INNER JOIN `joj_community_groups_category` AS c  
      WHERE a.`id`='2'  
      AND a.`ownerid`=b.`id`
      AND a.`categoryid`=c.`id`
  49. SELECT a.`memberid` AS id, a.`approved` , b.`name` AS name
      FROM`joj_community_groups_members` AS a  
      INNER JOIN `joj_users` AS b  
      WHERE b.`id`=a.`memberid`
      AND a.`groupid`='2'
      AND b.`block`='0'  
      AND a.`permissions` !='-1'
      AND a.`approved`='1'
      ORDER BY b.`name`
  50. SELECT COUNT(*)
      FROM `joj_community_groups_members` AS a  
      INNER JOIN `joj_users` AS b  
      WHERE b.`id`=a.`memberid`
      AND a.`groupid`='2'
      AND b.`block`='0'
      AND a.`approved`='1'
  51. SELECT a.*, b.`name` AS ownername , c.`name` AS category
      FROM `joj_community_groups` AS a  
      INNER JOIN `joj_users` AS b  
      INNER JOIN `joj_community_groups_category` AS c  
      WHERE a.`id`='1'  
      AND a.`ownerid`=b.`id`
      AND a.`categoryid`=c.`id`
  52. SELECT a.`memberid` AS id, a.`approved` , b.`name` AS name
      FROM`joj_community_groups_members` AS a  
      INNER JOIN `joj_users` AS b  
      WHERE b.`id`=a.`memberid`
      AND a.`groupid`='1'
      AND b.`block`='0'  
      AND a.`permissions` !='-1'
      AND a.`approved`='1'
      ORDER BY b.`name`
  53. SELECT COUNT(*)
      FROM `joj_community_groups_members` AS a  
      INNER JOIN `joj_users` AS b  
      WHERE b.`id`=a.`memberid`
      AND a.`groupid`='1'
      AND b.`block`='0'
      AND a.`approved`='1'
  54. SELECT a.*, b.`name` AS ownername , c.`name` AS category
      FROM `joj_community_groups` AS a  
      INNER JOIN `joj_users` AS b  
      INNER JOIN `joj_community_groups_category` AS c  
      WHERE a.`id`='10'  
      AND a.`ownerid`=b.`id`
      AND a.`categoryid`=c.`id`
  55. SELECT a.`memberid` AS id, a.`approved` , b.`name` AS name
      FROM`joj_community_groups_members` AS a  
      INNER JOIN `joj_users` AS b  
      WHERE b.`id`=a.`memberid`
      AND a.`groupid`='10'
      AND b.`block`='0'  
      AND a.`permissions` !='-1'
      AND a.`approved`='1'
      ORDER BY b.`name`
  56. SELECT COUNT(*)
      FROM `joj_community_groups_members` AS a  
      INNER JOIN `joj_users` AS b  
      WHERE b.`id`=a.`memberid`
      AND a.`groupid`='10'
      AND b.`block`='0'
      AND a.`approved`='1'
  57. SELECT a.*, b.`name` AS ownername , c.`name` AS category
      FROM `joj_community_groups` AS a  
      INNER JOIN `joj_users` AS b  
      INNER JOIN `joj_community_groups_category` AS c  
      WHERE a.`id`='14'  
      AND a.`ownerid`=b.`id`
      AND a.`categoryid`=c.`id`
  58. SELECT a.`memberid` AS id, a.`approved` , b.`name` AS name
      FROM`joj_community_groups_members` AS a  
      INNER JOIN `joj_users` AS b  
      WHERE b.`id`=a.`memberid`
      AND a.`groupid`='14'
      AND b.`block`='0'  
      AND a.`permissions` !='-1'
      AND a.`approved`='1'
      ORDER BY b.`name`
  59. SELECT COUNT(*)
      FROM `joj_community_groups_members` AS a  
      INNER JOIN `joj_users` AS b  
      WHERE b.`id`=a.`memberid`
      AND a.`groupid`='14'
      AND b.`block`='0'
      AND a.`approved`='1'
  60. SELECT a.*, b.`name` AS ownername , c.`name` AS category
      FROM `joj_community_groups` AS a  
      INNER JOIN `joj_users` AS b  
      INNER JOIN `joj_community_groups_category` AS c  
      WHERE a.`id`='12'  
      AND a.`ownerid`=b.`id`
      AND a.`categoryid`=c.`id`
  61. SELECT a.`memberid` AS id, a.`approved` , b.`name` AS name
      FROM`joj_community_groups_members` AS a  
      INNER JOIN `joj_users` AS b  
      WHERE b.`id`=a.`memberid`
      AND a.`groupid`='12'
      AND b.`block`='0'  
      AND a.`permissions` !='-1'
      AND a.`approved`='1'
      ORDER BY b.`name`
  62. SELECT COUNT(*)
      FROM `joj_community_groups_members` AS a  
      INNER JOIN `joj_users` AS b  
      WHERE b.`id`=a.`memberid`
      AND a.`groupid`='12'
      AND b.`block`='0'
      AND a.`approved`='1'
  63. SELECT a.*, b.`name` AS ownername , c.`name` AS category
      FROM `joj_community_groups` AS a  
      INNER JOIN `joj_users` AS b  
      INNER JOIN `joj_community_groups_category` AS c  
      WHERE a.`id`='11'  
      AND a.`ownerid`=b.`id`
      AND a.`categoryid`=c.`id`
  64. SELECT a.`memberid` AS id, a.`approved` , b.`name` AS name
      FROM`joj_community_groups_members` AS a  
      INNER JOIN `joj_users` AS b  
      WHERE b.`id`=a.`memberid`
      AND a.`groupid`='11'
      AND b.`block`='0'  
      AND a.`permissions` !='-1'
      AND a.`approved`='1'
      ORDER BY b.`name`
  65. SELECT COUNT(*)
      FROM `joj_community_groups_members` AS a  
      INNER JOIN `joj_users` AS b  
      WHERE b.`id`=a.`memberid`
      AND a.`groupid`='11'
      AND b.`block`='0'
      AND a.`approved`='1'
  66. SELECT a.*, b.`name` AS ownername , c.`name` AS category
      FROM `joj_community_groups` AS a  
      INNER JOIN `joj_users` AS b  
      INNER JOIN `joj_community_groups_category` AS c  
      WHERE a.`id`='9'  
      AND a.`ownerid`=b.`id`
      AND a.`categoryid`=c.`id`
  67. SELECT a.`memberid` AS id, a.`approved` , b.`name` AS name
      FROM`joj_community_groups_members` AS a  
      INNER JOIN `joj_users` AS b  
      WHERE b.`id`=a.`memberid`
      AND a.`groupid`='9'
      AND b.`block`='0'  
      AND a.`permissions` !='-1'
      AND a.`approved`='1'
      ORDER BY b.`name`
  68. SELECT COUNT(*)
      FROM `joj_community_groups_members` AS a  
      INNER JOIN `joj_users` AS b  
      WHERE b.`id`=a.`memberid`
      AND a.`groupid`='9'
      AND b.`block`='0'
      AND a.`approved`='1'
  69. SELECT `id`
      FROM `joj_menu`
      WHERE `link` LIKE '%option=com_community&view=groups%'
      AND `published`='1'
      AND `menutype`!='jomsocial'
      AND `type`='component'
  70. SELECT id
      FROM joj_core_acl_aro
      WHERE section_value='users'
      AND VALUE='0'
  71. SELECT m.*,n.`name`
      FROM `joj_community_blocklist` m
      LEFT JOIN `joj_users` n
      ON m.`blocked_userid`=n.`id`
      WHERE m.`userid`='0'
      AND m.`blocked_userid`!=0
  72. SELECT a.*,  TO_DAYS('2012-05-19 20:12:07') -  TO_DAYS( DATE_ADD(a.`created`, INTERVAL 2 HOUR ) ) AS _daydiff
      FROM `joj_community_activities` AS a  
      WHERE  `archived`=0
      AND (a.`access` <= 10)
      GROUP BY a.`id`
      ORDER BY a.`created` DESC
      LIMIT 40
  73. SELECT a.*  
      FROM `joj_community_wall` AS a  
      WHERE  (  a.`type`='profile.status'
      AND  a.`contentid` IN (41,39,38,37,36,5)  )  OR  (  a.`type`='profile.avatar.upload'
      AND  a.`contentid` IN (87,63,62)  )  OR  (  a.`type`='groups.wall'
      AND  a.`contentid` IN (1)  )  
      ORDER BY `id` DESC
  74. SELECT a.*  
      FROM `joj_community_likes` AS a  
      WHERE  (  a.`element`='profile.status'
      AND  a.`uid` IN (41,39,38,37,36,5)  )  OR  (  a.`element`='profile.avatar.upload'
      AND  a.`uid` IN (87,63,62)  )
  75. SELECT `name`
      FROM `joj_plugins`
      WHERE `element`='profile'
      AND `folder`='community'
  76. SELECT `name`
      FROM `joj_plugins`
      WHERE `element`='profile'
      AND `folder`='community'
  77. SELECT `name`
      FROM `joj_plugins`
      WHERE `element`='profile'
      AND `folder`='community'
  78. SELECT `name`
      FROM `joj_plugins`
      WHERE `element`='profile'
      AND `folder`='community'
  79. SELECT COUNT(1)
      FROM `joj_community_activities`
  80. SELECT COUNT(1)
      FROM `joj_community_activities`
  81. SELECT *
      FROM joj_acymailing_config
  82. SELECT m.senddate, m.alias, m.subject, m.mailid, l.listid, l.alias AS listalias
      FROM joj_acymailing_list AS l
      LEFT JOIN joj_acymailing_listmail AS b
      ON l.listid = b.listid
      LEFT JOIN joj_acymailing_mail AS m
      ON b.mailid = m.mailid
      WHERE m.TYPE = 'news'
      AND l.published = 1
      AND m.published = 1
      AND l.visible = 1
      AND m.visible = 1
      AND l.TYPE= 'list'
      GROUP BY m.mailid
      ORDER BY m.senddate DESC
      LIMIT 5
  83. SELECT *
      FROM joj_acymailing_list
      WHERE TYPE = 'list'
      ORDER BY ordering ASC
  84. SELECT a.*, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug
      FROM joj_content AS a
      LEFT JOIN joj_content_frontpage AS f
      ON f.content_id = a.id
      INNER JOIN joj_categories AS cc
      ON cc.id = a.catid
      INNER JOIN joj_sections AS s
      ON s.id = a.sectionid
      WHERE ( a.state = 1
      AND s.id > 0 )
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-05-19 18:12:07' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-05-19 18:12:07' )
      AND a.access <= 0
      AND cc.access <= 0
      AND s.access <= 0
      AND (s.id=2)
      AND s.published = 1
      AND cc.published = 1
      ORDER BY a.hits DESC
      LIMIT 0, 13
  85. SELECT `value`
      FROM `joj_admintools_storage`
      WHERE `key` = 'cparams'

Language Files Loaded

Untranslated Strings Diagnostic

None

Untranslated Strings Designer

None