You should check your table for duplicates because one of your sub queries is returning multiple records from the table based on your parameters. This could happen if you have duplicate records.
Try using Select Distinct OR Select 1 to avoid the error.
Vinu Vijayan