500 - DB function failed with error number 3065
Expression #1 of ORDER BY clause is not in SELECT list, references column 'pokercast2017.a.connection_id' which is not in SELECT list; this is incompatible with DISTINCT SQL=SELECT DISTINCT(a.`connect_to`) AS id , CASE WHEN c.`userid` IS NULL THEN 0 ELSE 1 END AS online, b.name FROM `jos_community_connection` AS a INNER JOIN `jos_users` AS b ON a.`connect_from`='6267' AND b.block=0 AND a.`connect_to`=b.`id` AND a.`status`='1' LEFT JOIN `jos_session` AS c ON a.`connect_to` = c.`userid` WHERE NOT EXISTS ( SELECT d.`blocked_userid` FROM `jos_community_blocklist` AS d WHERE d.`userid` = '6267' AND d.`blocked_userid` = a.`connect_to`) ORDER BY a.`connection_id` DESC LIMIT 0, 24

You may not be able to visit this page because of:

  1. an out-of-date bookmark/favourite
  2. a search engine that has an out-of-date listing for this site
  3. a mistyped address
  4. you have no access to this page
  5. The requested resource was not found.
  6. An error has occurred while processing your request.

Please try one of the following pages:

If difficulties persist, please contact the System Administrator of this site.

DB function failed with error number 3065
Expression #1 of ORDER BY clause is not in SELECT list, references column 'pokercast2017.a.connection_id' which is not in SELECT list; this is incompatible with DISTINCT SQL=SELECT DISTINCT(a.`connect_to`) AS id , CASE WHEN c.`userid` IS NULL THEN 0 ELSE 1 END AS online, b.name FROM `jos_community_connection` AS a INNER JOIN `jos_users` AS b ON a.`connect_from`='6267' AND b.block=0 AND a.`connect_to`=b.`id` AND a.`status`='1' LEFT JOIN `jos_session` AS c ON a.`connect_to` = c.`userid` WHERE NOT EXISTS ( SELECT d.`blocked_userid` FROM `jos_community_blocklist` AS d WHERE d.`userid` = '6267' AND d.`blocked_userid` = a.`connect_to`) ORDER BY a.`connection_id` DESC LIMIT 0, 24