Subquery returns more than 1 row

SELECT id, 
parent, 
label
 FROM (`_CMS`)
 
  WHERE label LIKE "Steve_Harvey_Show"
    ORDER BY IF((SELECT p.id
 FROM (`_CMS` AS `p`)
 
  WHERE p.label LIKE "appearances"
    ), 0, 1)
  LIMIT 1



Fatal error: Call to a member function fetch_row() on a non-object in /home/countess/public_html/live/_private/functions/basic.inc.php on line 136