Subquery returns more than 1 row

SELECT id, 
parent, 
label
 FROM (`_CMS`)
 
  WHERE label LIKE "Macy's_Fashion_Night_Out_at_the_Aventura_Mall_in_Florida"
    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