SELECT DISTINCT a.id AS value, a.title AS text, a.level, a.published

  FROM (
SELECT DISTINCT id,title,level,published,parent_id,extension,lft,rgt

  FROM d7jwf_categories

  WHERE (extension = 'com_content') 
  AND published IN (0,1)

  ORDER BY lft ASC) AS a

  LEFT JOIN `d7jwf_categories` AS b 
  ON a.lft > b.lft 
  AND a.rgt < b.rgt

SELECT DISTINCT a.id AS value, a.title AS text, a.level, a.published, a.lft

  FROM (
SELECT id,title,level,published,parent_id,extension,lft,rgt

  FROM d7jwf_categories

  WHERE (extension = 'com_content') 
  AND published IN (0,1)) AS a

  LEFT JOIN `d7jwf_categories` AS b 
  ON a.lft > b.lft 
  AND a.rgt < b.rgt

  ORDER BY a.lft ASC