Access denied for user 'lubersy'@'%' (using password: YES)<br>
    SELECT d.*, IFNULL( t1.`count`, 0) as `count`
      FROM `dic_item` d

         INNER JOIN (
             SELECT COUNT(*) as `count`, SUBSTRING(sphere,1,2) as level1
               FROM `v_company`
              GROUP BY  level1

         ) as t1 ON t1.level1 = d.code
    WHERE up = 44

    ORDER BY code desc